names

89 rows where place_id = 597485

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628766 1903874 1903874 defendant Broke William laborer 597485 597485 Broke, William, of Wyston, laborer 0
3628767 1903874 1903874 defendant Guntar Thomas laborer 597485 597485 Guntar, Thomas, of Wyston, laborer 1
3628768 1903874 1903874 defendant Frenschman John laborer 597485 597485 Frenschman, John, of Wyston, laborer 2
3628769 1903874 1903874 defendant Crichelowe Ralph yeoman 597485 597485 Crichelowe, Ralph, of Wyston, yeoman 3
3674222 1917977 1917977 defendant Dockyng Edmund husbandman 597485 597485 Dockyng, Edmund, of Wyston, husbandman 1
3675642 1918417 1918417 defendant Marchaunt George yeoman 597485 597485 Marchaunt, George, of Wyston, yeoman 1
3721388 1932998 1932998 defendant Shyrley Richard esq 597485 597485 Shyrley, Richard, of Wyston, esq 0
3755983 1943826 1943826 defendant Fenor Thomas husbandman 597485 597485 Fenor, Thomas, of Wyston, husbandman 0
3769697 1948178 1948178 defendant Venour Thomas laborer 597485 597485 Venour, Thomas, of Wyston, laborer 0
3780443 1951617 1951617 defendant Haryson Thomas brewer 597485 597485 Haryson, Thomas, of Wyston, brewer 3
3794616 1956194 1956194 defendant Sherley Richard   597485 597485 Sherley, Richard, of Wyston, knight 0
3834864 1968845 1968845 plaintiff Orwell Thomas yeoman 597485 597485 Orwell, Thomas, of Wyston, yeoman 0
3837590 1969665 1969665 defendant Fenour Thomas husbandman 597485 597485 Fenour, Thomas, of Wyston, husbandman 1
3859953 1976832 1976832 defendant Denour Thomas husbandman 597485 597485 Denour, Thomas, of Wyston, husbandman 1
3859957 1976833 1976833 defendant Venour Thomas husbandman 597485 597485 Venour, Thomas, of Wyston, husbandman 0
3860128 1976885 1976885 defendant Venour Thomas husbandman 597485 597485 Venour, Thomas, of Wyston, husbandman 0
3873707 1981422 1981422 defendant Sherley Richard   597485 597485 Sherley, Richard, of Wyston, knight 0
3874908 1981833 1981833 plaintiff Dey John   597485 597485 Dey, John, of Wyston 0
3890282 1986996 1986996 defendant Gybson Robert shoemaker 597485 597485 Gybson, Robert, of Wyston, shoemaker 0
3896236 1988950 1988950 defendant Dey Robert cooper 597485 597485 Dey, Robert, of Wyston, cooper 0
3898092 1989571 1989571 defendant Lorkyng Hugh husbandman 597485 597485 Lorkyng, Hugh, of Wyston, husbandman 3
3898093 1989571 1989571 defendant Lorken James husbandman 597485 597485 Lorken, James, of Wyston, husbandman 4
3902486 1991062 1991062 defendant Dey John, junior merchant 597485 597485 Dey, John, junior, of Wyston, merchant 0
3902488 1991063 1991063 defendant Deye John, junior merchant 597485 597485 Deye, John, junior, of Wyston, merchant 0
3923877 1998297 1998297 defendant Nunne Simon tailor 597485 597485 Nunne, Simon, of Wyston, tailor 0
3927781 1999630 1999630 defendant Dey John, junior (legal representative) 597485 597485 Dey, John, junior, of Wyston, merchant, executrix of 0
3943308 2004780 2004780 defendant Robert John yeoman 597485 597485 Robert, John, of Wyston, yeoman 2
3943314 2004781 2004781 defendant Robert John yeoman 597485 597485 Robert, John, of Wyston, yeoman 2
3946115 2005717 2005717 defendant Wulff John husbandman 597485 597485 Wulff, John, of Wyston, husbandman 0
3951871 2007715 2007715 plaintiff Harmer Thomas   597485 597485 Harmer, Thomas, of Wyston 0
3959493 2010411 2010411 defendant Monney Robert mariner 597485 597485 Monney, Robert, of Wyston, mariner 1
3977735 2016782 2016782 defendant Thurlowe Christopher   597485 597485 Thurlowe, Christopher, of Wyston, Norf mariner 0
3981058 2017986 2017986 defendant Sayre Henry husbandman 597485 597485 Sayre, Henry, of Wyston, husbandman 0
3981059 2017986 2017986 defendant Bothe Thomas husbandman 597485 597485 Bothe, Thomas, of Wyston, husbandman 1
3982432 2018489 2018489 defendant West Philip yeoman 597485 597485 West, Philip, of Wyston, yeoman 0
3985659 2019634 2019634 defendant Clemens William (legal representative) 597485 597485 Clemens, William, of Wyston, mariner, executrix of 2
3997850 2023989 2023989 defendant Sherley Anthony gent 597485 597485 Sherley, Anthony, of Wyston, gent 1
4127147 2069998 2069998 defendant Smythe John shipmaster 597485 597485 Smythe, John, of Wyston, shipmaster 0
4152184 2078875 2078875 defendant Toly George fisherman 597485 597485 Toly, George, of Wyston, fisherman 1
4198365 2094977 2094977 defendant Allen George husbandman 597485 597485 Allen, George, of Wyston, husbandman 0
4200242 2095637 2095637 defendant Saer William yeoman 597485 597485 Saer, William, of Wyston, yeoman 0
4274636 2121072 2121072 defendant Bacon Henry husbandman 597485 597485 Bacon, Henry, of Wyston, husbandman 0
4274638 2121072 2121072 defendant Wynterflode John yeoman 597485 597485 Wynterflode, John, of Wyston, yeoman 2
4303982 2131525 2131525 defendant Brett Peter clothworker 597485 597485 Brett, Peter, of Wyston, yeoman, clothworker 0
4407547 2167090 2167090 defendant Wynterflood John yeoman 597485 597485 Wynterflood, John, of Wyston, yeoman 0
4407548 2167090 2167090 defendant Todd Thomas sherman 597485 597485 Todd, Thomas, of Wyston, sherman 1
4416531 2170035 2170035 defendant Siward Richard   597485 597485 Siward, Richard, of Wyston 0
4519213 2206363 2206363 plaintiff Dykes John   597485 597485 Dykes, John, of Wyston 0
4522648 2207422 2207422 defendant Wyston John   597485 597485 Wyston, John, of Wyston 1
4565500 2220781 2220781 defendant Dykes Richard   597485 597485 Dykes, Richard, of Wyston 0
4565501 2220781 2220781 defendant Dykes Robert   597485 597485 Dykes, Robert, of Wyston 1
4670747 2256528 2256528 defendant Brewys John   597485 597485 Brewys, John, of Wyston, knight 0
4671675 2256787 2256787 defendant Fuller John husbandman 597485 597485 Fuller, John, of Wyston, husbandman 0
4671676 2256787 2256787 defendant Wodeman William   597485 597485 Wodeman, William, of Wyston, groom 1
4677567 2258596 2258596 defendant Wyston John husbandman 597485 597485 Wyston, John, of Wyston, husbandman 0
4695262 2263998 2263998 defendant Tolay Nicholas laborer 597485 597485 Tolay, Nicholas, of Wyston, laborer 4
4712268 2269152 2269152 defendant Lancastre John de yeoman 597485 597485 Lancastre, John de, of Wyston, yeoman 2
4737769 2276917 2276917 defendant Stephenes John   597485 597485 Stephenes, John, of Wyston, shepherd 2
4757374 2282677 2282677 defendant Whyte John husbandman 597485 597485 Whyte, John, of Wyston, husbandman 0
4760193 2283537 2283537 defendant Gardeney Walter   597485 597485 Gardeney, Walter, of Wyston, vicar 0
4779448 2289550 2289550 defendant Whyte John husbandman 597485 597485 Whyte, John, of Wyston, husbandman 0
4815093 2300832 2300832 defendant Growenyng Nicholas husbandman 597485 597485 Growenyng, Nicholas, of Wyston, husbandman 0
4915943 2331482 2331482 defendant atte Hill Emma widow 597485 597485 atte Hill, Emma, of Wyston, widow 0
4923635 2333828 2333828 defendant Resby Matilda widow 597485 597485 Resby, Matilda, of Wyston, widow 0
4931404 2336200 2336200 defendant Spendelove John laborer 597485 597485 Spendelove, John, of Wyston, laborer 0
5013975 2360944 2360944 defendant Benet William husbandman 597485 597485 Benet, William, of Wyston, husbandman 1
5039062 2368331 2368331 defendant Benet William husbandman 597485 597485 Benet, William, of Wyston, husbandman 0
5039066 2368332 2368332 defendant Bener William husbandman 597485 597485 Bener, William, of Wyston, husbandman 1
5097325 2385648 2385648 defendant Laurens Roger husbandman 597485 597485 Laurens, Roger, of Wyston, husbandman 3
5129058 2394982 2394982 defendant Bray Richard husbandman 597485 597485 Bray, Richard, of Wyston, husbandman 2
5148289 2400636 2400636 defendant Bray Richard husbandman 597485 597485 Bray, Richard, of Wyston, husbandman 2
5167632 2406256 2406256 defendant Bray Richard husbandman 597485 597485 Bray, Richard, of Wyston, husbandman 2
5179217 2409657 2409657 defendant Hagun Simon yeoman 597485 597485 Hagun, Simon, of Wyston, yeoman 0
5183196 2410825 2410825 defendant Bray Richard husbandman 597485 597485 Bray, Richard, of Wyston, husbandman 2
5230924 2424652 2424652 defendant Hagun John ywoman 597485 597485 Hagun, John, of Wyston, ywoman 3
5255424 2431816 2431816 defendant Calowe William yeoman 597485 597485 Calowe, William, of Wyston, yeoman 0
5298578 2444558 2444558 defendant Dalle John (legal representative) 597485 597485 Dalle, John, of Wyston, yeoman, executors of 2
5298580 2444558 2444558 defendant Dalle Thomas husbandman 597485 597485 Dalle, Thomas, of Wyston, husbandman 4
5298581 2444558 2444558 defendant Ketyll Thomas (legal representative) 597485 597485 Ketyll, Thomas, of Wyston, smith, executor of 5
5298582 2444558 2444558 defendant Ketyll Richard smith 597485 597485 Ketyll, Richard, of Wyston, smith 6
5315124 2449581 2449581 defendant Manwode William husbandman 597485 597485 Manwode, William, of Wyston, husbandman 0
5315449 2449684 2449684 defendant Calowe William yeoman 597485 597485 Calowe, William, of Wyston, yeoman 0
5344550 2458464 2458464 defendant Scardeburgh Richard yeoman 597485 597485 Scardeburgh, Richard, of Wyston, yeoman 0
5367129 2465366 2465366 defendant Tompson Richard butcher 597485 597485 Tompson, Richard, of Wyston, butcher 1
5506584 2506970 2506970 defendant La- Edmund yeoman 597485 597485 La-, Edmund, of Wyston, yeoman 2
5553112 2520949 2520949 defendant Crowe William husbandman 597485 597485 Crowe, William, of Wyston, husbandman 0
5571952 2526339 2526339 defendant Spencer Christopher laborer 597485 597485 Spencer, Christopher, of Wyston, laborer 0
5617566 2549317 2549317 defendant Grem William   597485 597485 Grem, William, of Wyston 0
5626370 2552216 2552216 plaintiff Milner Robert   597485 597485 Milner, Robert, of Wyston 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);