names

188 rows where place_id = 589927

✎ 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
3599295 1867423 1867423 defendant Roger Thomas husbandman 589927 589927 Roger, Thomas, of Paston, husbandman 0
3608095 1870183 1870183 defendant Hubberd John   589927 589927 Hubberd, John, of Paston 3
3632501 1904985 1904985 defendant Note Jasper glover 589927 589927 Note, Jasper, of Paston, glover 2
3635833 1906008 1906008 defendant Albon Robert yeoman 589927 589927 Albon, Robert, of Paston, yeoman 0
3635834 1906008 1906008 defendant Albon Robert   589927 589927 Albon, Robert, of Paston, wax chandler 1
3635835 1906008 1906008 defendant Sylvern John husbandman 589927 589927 Sylvern, John, of Paston, husbandman 2
3649270 1910160 1910160 defendant Albon Adam husbandman 589927 589927 Albon, Adam, of Paston, husbandman 3
3649271 1910160 1910160 defendant Albon Robert   589927 589927 Albon, Robert, of Paston, wax chandler 4
3664477 1914837 1914837 defendant Hobard John husbandman 589927 589927 Hobard, John, of Paston, husbandman 0
3670424 1916706 1916706 defendant Silvern John yeoman 589927 589927 Silvern, John, of Paston, yeoman 0
3670425 1916706 1916706 defendant Plumsted William husbandman 589927 589927 Plumsted, William, of Paston, husbandman 1
3676406 1918666 1918666 defendant Albon Robert husbandman 589927 589927 Albon, Robert, of Paston, husbandman 1
3686641 1921975 1921975 defendant Sylvern John yeoman 589927 589927 Sylvern, John, of Paston, yeoman 0
3764807 1946660 1946660 defendant Balles John husbandman 589927 589927 Balles, John, of Paston, husbandman 0
3764808 1946660 1946660 defendant Albon Robert husbandman 589927 589927 Albon, Robert, of Paston, husbandman 1
3769176 1948017 1948017 defendant Sylvern John husbandman 589927 589927 Sylvern, John, of Paston, husbandman 2
3778211 1950893 1950893 defendant Hubbert John husbandman 589927 589927 Hubbert, John, of Paston, husbandman 0
3778215 1950894 1950894 defendant Hubbert John husbandman 589927 589927 Hubbert, John, of Paston, husbandman 1
3795368 1956421 1956421 defendant Hubberd John husbandman 589927 589927 Hubberd, John, of Paston, husbandman 0
3821064 1964482 1964482 defendant Myller John roper 589927 589927 Myller, John, of Paston, roper 1
3840741 1970670 1970670 defendant Thorpe Robert carpenter 589927 589927 Thorpe, Robert, of Paston, carpenter 0
3847440 1972762 1972762 defendant Ryley Thomas clerk 589927 589927 Ryley, Thomas, of Paston, clerk 0
3847441 1972762 1972762 defendant Leder Charles clerk 589927 589927 Leder, Charles, of Paston, clerk 1
3847442 1972762 1972762 defendant Emlyn Richard husbandman 589927 589927 Emlyn, Richard, of Paston, husbandman 2
3869343 1979989 1979989 defendant Carwithan William gent 589927 589927 Carwithan, William, of Paston, gent 1
3880337 1983677 1983677 defendant Leche John husbandman 589927 589927 Leche, John, of Paston, husbandman 3
3882672 1984469 1984469 defendant Sylverne Thomas laborer 589927 589927 Sylverne, Thomas, of Paston, laborer 0
3899628 1990094 1990094 defendant Leche Thomas husbandman 589927 589927 Leche, Thomas, of Paston, husbandman 0
3914111 1995065 1995065 defendant Calke John husbandman 589927 589927 Calke, John, of Paston, husbandman 1
3929984 2000371 2000371 defendant Paston William   589927 589927 Paston, William, of Paston 0
3929986 2000372 2000372 defendant Paston William   589927 589927 Paston, William, of Paston 0
3943163 2004729 2004729 defendant Rake Robert yeoman 589927 589927 Rake, Robert, of Paston, yeoman 1
3951183 2007482 2007482 defendant Wylson Richard yeoman 589927 589927 Wylson, Richard, of Paston, yeoman 2
3951188 2007483 2007483 defendant Wylson Richard yeoman 589927 589927 Wylson, Richard, of Paston, yeoman 2
3963601 2011880 2011880 defendant Sheffeld William husbandman 589927 589927 Sheffeld, William, of Paston, husbandman 0
4021362 2032365 2032365 plaintiff Wyllsonne Richard yeoman 589927 589927 Wyllsonne, Richard, of Paston, yeoman 0
4022068 2032622 2032622 defendant Shorte Thomas yeoman 589927 589927 Shorte, Thomas, of Paston, yeoman 0
4042586 2039817 2039817 plaintiff Paston William esq 589927 589927 Paston, William, of Paston, esq 0
4042588 2039818 2039818 plaintiff Paston William esq 589927 589927 Paston, William, of Paston, esq 0
4044577 2040512 2040512 defendant Reve Robert (legal representative) 589927 589927 Reve, Robert, of Paston, executor of 0
4048600 2041948 2041948 defendant Leithe Thomas husbandman 589927 589927 Leithe, Thomas, of Paston, husbandman 1
4048944 2042063 2042063 defendant Leiche Thomas husbandman 589927 589927 Leiche, Thomas, of Paston, husbandman 1
4052997 2043505 2043505 defendant Sower John gent 589927 589927 Sower, John, of Paston, gent 2
4054523 2044008 2044008 defendant Sower John yeoman 589927 589927 Sower, John, of Paston, yeoman 0
4084749 2054817 2054817 defendant Leche Thomas, junior laborer 589927 589927 Leche, Thomas, junior, of Paston, laborer 0
4090653 2056945 2056945 defendant Sower John yeoman 589927 589927 Sower, John, of Paston, yeoman 0
4112001 2064542 2064542 defendant Leeche Richard husbandman 589927 589927 Leeche, Richard, of Paston, husbandman 3
4120957 2067785 2067785 defendant Elgood William husbandman 589927 589927 Elgood, William, of Paston, husbandman 1
4127588 2070159 2070159 defendant Payne William husbandman 589927 589927 Payne, William, of Paston, husbandman 0
4138804 2074251 2074251 defendant Gooderycke Richard husbandman 589927 589927 Gooderycke, Richard, of Paston, husbandman 0
4147767 2077360 2077360 defendant Paston William   589927 589927 Paston, William, of Paston, knight, sheriff 0
4150755 2078403 2078403 defendant Gurney William gent 589927 589927 Gurney, William, of Paston, ,gent 3
4159766 2081484 2081484 defendant Curtes Edmund yeoman 589927 589927 Curtes, Edmund, of Paston, yeoman 2
4169460 2084820 2084820 defendant Curtes Edmund yeoman 589927 589927 Curtes, Edmund, of Paston, yeoman 2
4170536 2085191 2085191 defendant Gooderyche Richard husbandman 589927 589927 Gooderyche, Richard, of Paston, husbandman 1
4170539 2085192 2085192 defendant Gooderycke Richard husbandman 589927 589927 Gooderycke, Richard, of Paston, husbandman 1
4172764 2085932 2085932 defendant Paston William   589927 589927 Paston, William, of Paston, knight, sheriff of Norf 0
4209592 2098906 2098906 defendant Curtes Edmund yeoman 589927 589927 Curtes, Edmund, of Paston, yeoman 0
4256573 2115169 2115169 defendant Sowier John yeoman 589927 589927 Sowier, John, of Paston, yeoman 0
4257863 2115605 2115605 defendant Curtys Edmund yeoman 589927 589927 Curtys, Edmund, of Paston, yeoman 0
4260736 2116556 2116556 defendant Gryme Nicholas husbandman 589927 589927 Gryme, Nicholas, of Paston, husbandman 1
4320620 2137302 2137302 defendant Gryme Nicholas husbandman 589927 589927 Gryme, Nicholas, of Paston, husbandman 3
4324808 2138685 2138685 defendant Payne William yeoman 589927 589927 Payne, William, of Paston, yeoman 1
4324809 2138685 2138685 defendant Gryme Nicholas yeoman 589927 589927 Gryme, Nicholas, of Paston, yeoman 2
4330320 2140445 2140445 defendant Wilebore Blanche widow 589927 589927 Wilebore, Blanche, of Paston, widow 1
4332459 2141146 2141146 defendant Hubberd Clement husbandman 589927 589927 Hubberd, Clement, of Paston, husbandman 0
4332460 2141146 2141146 defendant Boulter Francis yeoman 589927 589927 Boulter, Francis, of Paston, yeoman 1
4332720 2141227 2141227 defendant Gryme Nicholas husbandman 589927 589927 Gryme, Nicholas, of Paston, husbandman 3
4334161 2141704 2141704 defendant Wilbore Blanche widow 589927 589927 Wilbore, Blanche, of Paston, widow 1
4340374 2143896 2143896 defendant Relinge John husbandman 589927 589927 Relinge, John, of Paston, husbandman 0
4361452 2151257 2151257 defendant Curtis Edmund husbandman 589927 589927 Curtis, Edmund, of Paston, husbandman 3
4362843 2151770 2151770 defendant Drake William clerk 589927 589927 Drake, William, of Paston, clerk 3
4362848 2151771 2151771 defendant Curtis Edmund yeoman 589927 589927 Curtis, Edmund, of Paston, yeoman 3
4375917 2156448 2156448 defendant Claydon Richard yeoman 589927 589927 Claydon, Richard, of Paston, yeoman 1
4387206 2160372 2160372 defendant Curtis Edmund husbandman 589927 589927 Curtis, Edmund, of Paston, husbandman 3
4388966 2160941 2160941 defendant Curtis Edmund yeoman 589927 589927 Curtis, Edmund, of Paston, yeoman 3
4389408 2161082 2161082 defendant Drake William clerk 589927 589927 Drake, William, of Paston, clerk 3
4400323 2164701 2164701 defendant Ryse James   589927 589927 Ryse, James, of Paston, linen weaver 0
4454011 2186268 2186268 defendant Kyng John   589927 589927 Kyng, John, of Paston 8
4574002 2223390 2223390 defendant Gyldell William   589927 589927 Gyldell, William, of Paston 0
4583545 2226276 2226276 plaintiff Kynge John chaplain 589927 589927 Kynge, John, of Paston, chaplain 1
4622008 2237861 2237861 defendant S_ Philip   589927 589927 S_, Philip, of Paston 0
4623163 2238218 2238218 defendant Soutere William   589927 589927 Soutere, William, of paston 1
4645646 2244791 2244791 plaintiff Stoke William   589927 589927 Stoke, William, of Paston 1
4660460 2249097 2249097 defendant Osbern John husbandman 589927 589927 Osbern, John, of Paston, husbandman 0
4669106 2256045 2256045 defendant Hornyntoft John butcher 589927 589927 Hornyntoft, John, of Paston, butcher 0
4683331 2260391 2260391 plaintiff Paston William   589927 589927 Paston, William, of Paston, on his own account 0
4709097 2268213 2268213 plaintiff Paston William   589927 589927 Paston, William, of Paston 0
4724681 2273017 2273017 plaintiff Paston William   589927 589927 Paston, William, of Paston 2
4739215 2277358 2277358 plaintiff Paston William   589927 589927 Paston, William, of Paston 1
4754048 2281648 2281648 plaintiff Paston William   589927 589927 Paston, William, of Paston 1
4769315 2286379 2286379 plaintiff Paston William   589927 589927 Paston, William, of Paston 0
4791927 2293580 2293580 defendant Horntoft John mercer 589927 589927 Horntoft, John, of Paston, mercer 0
4833554 2306500 2306500 defendant Rang_ John husbandman 589927 589927 Rang_, John, of Paston, husbandman 3
4845481 2310102 2310102 plaintiff Paston William   589927 589927 Paston, William, of Paston 0
4862576 2315281 2315281 defendant Paston William gent 589927 589927 Paston, William, of Paston, gent 0
4873020 2318521 2318521 plaintiff Paston William   589927 589927 Paston, William, of Paston 0
4873023 2318522 2318522 plaintiff Paston William   589927 589927 Paston, William, of Paston 0
4890064 2323673 2323673 defendant Bernard John husbandman 589927 589927 Bernard, John, of Paston, husbandman 1
4899735 2326550 2326550 plaintiff Gybbes Henry   589927 589927 Gybbes, Henry, of Paston 0

Next page

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);