names

229 rows where place_id = 587557

✎ 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
3591735 1865034 1865034 defendant Crysford John husbandman 587557 587557 Crysford, John, of Benynden, husbandman 0
3597203 1866749 1866749 defendant Hoigge William husbandman 587557 587557 Hoigge, William, of Benynden, husbandman 0
3615058 1872354 1872354 defendant Hellys Michael husbandman 587557 587557 Hellys, Michael, of Benynden, husbandman 1
3616647 1872837 1872837 defendant Hoygges John clothmaker 587557 587557 Hoygges, John, of Benynden, clothmaker 1
3621192 1874171 1874171 plaintiff More Walter   587557 587557 More, Walter, of Benynden 0
3621927 1874402 1874402 defendant Watte William clothmaker 587557 587557 Watte, William, of Benynden, clothmaker 0
3622829 1874671 1874671 defendant Stokes Gilbert husbandman 587557 587557 Stokes, Gilbert, of Benynden, husbandman 4
3625616 1875545 1875545 defendant Everden James clothmaker 587557 587557 Everden, James, of Benynden, clothmaker 0
3625618 1875546 1875546 defendant Hoberd John clothmaker 587557 587557 Hoberd, John, of Benynden, clothmaker 0
3666399 1915442 1915442 defendant Morlayn John butcher 587557 587557 Morlayn, John, of Benynden, butcher 0
3670222 1916633 1916633 defendant Fowlle John clothier 587557 587557 Fowlle, John, of Benynden, clothier 1
3674031 1917918 1917918 defendant Hubbard William fuller 587557 587557 Hubbard, William, of Benynden, fuller 0
3676323 1918638 1918638 defendant Symme Stephen husbandman 587557 587557 Symme, Stephen, of Benynden, husbandman 0
3676324 1918638 1918638 defendant Symme John laborer 587557 587557 Symme, John, of Benynden, laborer 1
3676468 1918685 1918685 defendant Lede william clothier 587557 587557 Lede, william, of Benynden, clothier 0
3677073 1918868 1918868 defendant Water John smith 587557 587557 Water, John, of Benynden, smith 2
3677209 1918915 1918915 defendant Morley John butcher 587557 587557 Morley, John, of Benynden, butcher 1
3677215 1918917 1918917 defendant Leche Stephen yeoman 587557 587557 Leche, Stephen, of Benynden, yeoman 0
3680313 1919919 1919919 defendant Kete Thomas yeoman 587557 587557 Kete, Thomas, of Benynden, yeoman 0
3682493 1920628 1920628 defendant Lesden Joan widow 587557 587557 Lesden, Joan, of Benynden, widow 0
3682494 1920628 1920628 defendant Lesden Richard weaver 587557 587557 Lesden, Richard, of Benynden, weaver 1
3683975 1921121 1921121 defendant Lede william clothier 587557 587557 Lede, william, of Benynden, clothier 0
3685573 1921639 1921639 defendant Ledes William clothier 587557 587557 Ledes, William, of Benynden, clothier 0
3688925 1922696 1922696 defendant Fowle John clothman 587557 587557 Fowle, John, of Benynden, clothman 1
3690156 1923078 1923078 defendant Hubberd William fuller 587557 587557 Hubberd, William, of Benynden, fuller 0
3692195 1923725 1923725 defendant Symme John husbandman 587557 587557 Symme, John, of Benynden, husbandman 0
3692879 1923970 1923970 defendant Lech Stephen yeoman 587557 587557 Lech, Stephen, of Benynden, yeoman 0
3697134 1925326 1925326 plaintiff Stace Robert (legal representative) 587557 587557 Stace, Robert, of Benynden, executor of 0
3697138 1925326 1925326 defendant Goldyng Richard husbandman 587557 587557 Goldyng, Richard, of Benynden, husbandman 2
3707802 1928738 1928738 defendant Hobberd William clothier 587557 587557 Hobberd, William, of Benynden, clothier 2
3718481 1932059 1932059 defendant Morleyn John yeoman 587557 587557 Morleyn, John, of Benynden, yeoman 1
3734218 1936944 1936944 defendant Morleyn John yeoman 587557 587557 Morleyn, John, of Benynden, yeoman 0
3747902 1941267 1941267 plaintiff Foule John (legal representative) 587557 587557 Foule, John, of Benynden, administrator of 0
3747904 1941267 1941267 defendant Babbe Richard clothier 587557 587557 Babbe, Richard, of Benynden, clothier 0
3747905 1941267 1941267 defendant Babbe Thomas fuller 587557 587557 Babbe, Thomas, of Benynden, fuller 1
3747906 1941267 1941267 defendant Foule James husbandman 587557 587557 Foule, James, of Benynden, husbandman 2
3756995 1944167 1944167 defendant Philpott Thomas clothmaker 587557 587557 Philpott, Thomas, of Benynden, clothmaker 0
3759820 1945068 1945068 plaintiff Rammysden John, junior   587557 587557 Rammysden, John, junior, of Benynden 1
3761887 1945726 1945726 plaintiff Foule John (legal representative) 587557 587557 Foule, John, of Benynden, administrator of 0
3761889 1945726 1945726 defendant Babbe Richard clothier 587557 587557 Babbe, Richard, of Benynden, clothier 0
3761890 1945726 1945726 defendant Babbe Thomas fuller 587557 587557 Babbe, Thomas, of Benynden, fuller 1
3761891 1945726 1945726 defendant Foule James husbandman 587557 587557 Foule, James, of Benynden, husbandman 2
3761972 1945752 1945752 defendant Morleyn John butcher 587557 587557 Morleyn, John, of Benynden, butcher 0
3780138 1951511 1951511 defendant Morleyn John butcher 587557 587557 Morleyn, John, of Benynden, butcher 1
3798527 1957442 1957442 defendant Glover John clothier 587557 587557 Glover, John, of Benynden, clothier 0
3806837 1960044 1960044 defendant Bygge Stephen husbandman 587557 587557 Bygge, Stephen, of Benynden, husbandman 0
3827013 1966303 1966303 defendant Bygge Richard clothmaker 587557 587557 Bygge, Richard, of Benynden, clothmaker 1
3832313 1968023 1968023 defendant Denman John husbandman 587557 587557 Denman, John, of Benynden, husbandman 0
3846918 1972573 1972573 defendant Wellys Henry clothier 587557 587557 Wellys, Henry, of Benynden, clothier 0
3847930 1972929 1972929 defendant Anford William clothmaker 587557 587557 Anford, William, of Benynden, clothmaker 0
3852541 1974403 1974403 defendant Glover Richard husbandman 587557 587557 Glover, Richard, of Benynden, husbandman 0
3854448 1975030 1975030 defendant Bygge Richard husbandman 587557 587557 Bygge, Richard, of Benynden, husbandman 0
3863195 1977894 1977894 plaintiff Leeve Edward   587557 587557 (Leeve, Edward, of Benynden 1
3863200 1977895 1977895 plaintiff Lede Edward   587557 587557 (Lede, Edward, of Benynden 1
3868864 1979828 1979828 defendant Bygg Richard yeoman 587557 587557 Bygg, Richard, of Benynden, yeoman 0
3868866 1979829 1979829 defendant Bygg Richard yeoman 587557 587557 Bygg, Richard, of Benynden, yeoman 0
3874104 1981562 1981562 defendant Albourn Richard butcher 587557 587557 Albourn, Richard, of Benynden, butcher 0
3892881 1987867 1987867 defendant Bygge Walter tailor 587557 587557 Bygge, Walter, of Benynden, tailor 3
3911413 1994132 1994132 plaintiff Watte William clothier 587557 587557 Watte, William, of Benynden, clothier 0
3914191 1995089 1995089 defendant Ramysden John clothman 587557 587557 Ramysden, John, of benynden, clothman 0
3919814 1996963 1996963 plaintiff Lucas John   587557 587557 Lucas, John, of Benynden 0
3961586 2011150 2011150 defendant Rade John gent 587557 587557 Rade, John, of Benynden, gent 0
3983973 2019036 2019036 defendant Everynden John clothier 587557 587557 Everynden, John, of Benynden, clothier 0
3997911 2024012 2024012 defendant Lede Walter clothier 587557 587557 Lede, Walter, of Benynden, clothier 0
3997913 2024013 2024013 defendant Lede Walter clothier 587557 587557 Lede, Walter, of Benynden, clothier 0
4013416 2029532 2029532 defendant Hopper Thomas clothier 587557 587557 Hopper, Thomas, of Benynden, clothier 0
4031915 2036079 2036079 defendant Stace John yeoman 587557 587557 Stace, John, of Benynden, yeoman 0
4479453 2194231 2194231 defendant Ian or Jan Thomas   587557 587557 Ian or Jan, Thomas, of Benynden 0
4545522 2214521 2214521 defendant Duk Henry   587557 587557 Duk, Henry, of Benynden 0
4567418 2221369 2221369 defendant Cook William   587557 587557 Cook, William, of Benynden 1
4575094 2223732 2223732 defendant Jan Thomas   587557 587557 Jan, Thomas, of Benynden 0
4587486 2227492 2227492 defendant Duk Henry   587557 587557 Duk, Henry, of Benynden 1
4587487 2227492 2227492 defendant Stace Thomas   587557 587557 Stace, Thomas, of Benynden, balstaf or balkstaff maker 2
4595791 2229935 2229935 defendant Hogge Mathew   587557 587557 Hogge, Mathew, of Benynden 0
4600189 2231286 2231286 defendant Dewk Henry carpenter 587557 587557 Dewk, Henry, of Benynden, carpenter 0
4600191 2231287 2231287 defendant Dewk Henry carpenter 587557 587557 Dewk, Henry, of Benynden, carpenter 0
4619305 2237032 2237032 defendant Stace Thomas   587557 587557 Stace, Thomas, of Benynden, balstaf maker 0
4623953 2238470 2238470 plaintiff More Thomas   587557 587557 More, Thomas, of Benynden 0
4623958 2238472 2238472 defendant Hogge Mathew   587557 587557 Hogge, Mathew, of Benynden 0
4623961 2238473 2238473 defendant Hogge John   587557 587557 Hogge, John, of Benynden 1
4628115 2239722 2239722 defendant Skyppere Thomas   587557 587557 Skyppere, Thomas, of Benynden 0
4636461 2242236 2242236 defendant Brynchesle John   587557 587557 Brynchesle, John, of Benynden 0
4637249 2242445 2242445 defendant Austyn John   587557 587557 Austyn, John, of Benynden 0
4641094 2243487 2243487 defendant Duk Henry   587557 587557 Duk, Henry, of Benynden 0
4642867 2244024 2244024 defendant More Richard   587557 587557 More, Richard, of Benynden 0
4644329 2244430 2244430 defendant Brynchesle John   587557 587557 Brynchesle, John, of Benynden 0
4650239 2246090 2246090 defendant Bechyng Augustine   587557 587557 Bechyng, Augustine, of Benynden 0
4653901 2247129 2247129 defendant More Thomas   587557 587557 More, Thomas, of Benynden 2
4654099 2247164 2247164 plaintiff Bigge John   587557 587557 Bigge, John, of Benynden 0
4654100 2247164 2247164 defendant Wayte Henry husbandman 587557 587557 Wayte, Henry, of Benynden, husbandman 0
4655102 2247479 2247479 plaintiff Brenchesle John   587557 587557 Brenchesle, John, of Benynden 0
4656123 2247795 2247795 plaintiff Bygge John   587557 587557 Bygge, John, of Benynden 0
4656124 2247795 2247795 defendant Wayte Henry husbandman 587557 587557 Wayte, Henry, of Benynden, husbandman 0
4665302 2250638 2250638 defendant Robert Robert yeoman 587557 587557 Robert, Robert, of Benynden, yeoman 0
4665471 2250675 2250675 defendant Lucas John laborer 587557 587557 Lucas, John, of Benynden, laborer 1
4666424 2250976 2250976 defendant Foghel John, senior laborer 587557 587557 Foghel, John, senior, of Benynden, laborer 0
4670541 2256462 2256462 plaintiff Brynchesle John husbandman 587557 587557 Brynchesle, John, of Benynden, husbandman 0
4675477 2257939 2257939 defendant Jan Thomas husbandman 587557 587557 Jan, Thomas, of Benynden, husbandman 0
4677041 2258434 2258434 defendant Benynden Henry husbandman 587557 587557 Benynden, Henry, of Benynden, husbandman 0
4677042 2258434 2258434 defendant Judde William laborer 587557 587557 Judde, William, of Benynden, laborer 1

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