names

107 rows where place_id = 660893

✎ 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
3958258 2009963 2009963 plaintiff Reynolde John   660893 660893 Reynolde, John, of Leedes 0
3966863 2013043 2013043 defendant Morrys William tanner 660893 660893 Morrys, William, of Leedes, tanner 1
3966864 2013043 2013043 defendant Robynson Thomas tanner 660893 660893 Robynson, Thomas, of Leedes, tanner 2
3966872 2013045 2013045 defendant Kyllyngheke or Kyllyngbeke Robert tanner 660893 660893 Kyllyngheke or Kyllyngbeke, Robert, of Leedes, tanner 3
3972610 2014996 2014996 defendant Waterson John tanner 660893 660893 Waterson, John, of Leedes, tanner 3
3972624 2014999 2014999 defendant Kendall Thomas shoemaker 660893 660893 Kendall, Thomas, of Leedes, shoemaker 2
3972625 2014999 2014999 defendant Hodgson Christopher shoemaker 660893 660893 Hodgson, Christopher, of Leedes, shoemaker 3
3972628 2015000 2015000 defendant Galle William tanner 660893 660893 Galle, William, of Leedes, tanner 1
3973858 2015424 2015424 defendant Marten Henry clothier 660893 660893 Marten, Henry, of Leedes, clothier 1
3973859 2015424 2015424 defendant Dyconson John clothier 660893 660893 Dyconson, John, of Leedes, clothier 2
3976172 2016233 2016233 defendant Symson William clothier 660893 660893 Symson, William, of Leedes, clothier 1
3988494 2020629 2020629 defendant Thorneton John shoemaker 660893 660893 Thorneton, John, of Leedes, shoemaker 0
3995579 2023164 2023164 plaintiff Craven John clothier 660893 660893 Craven, John, of Leedes, clothier 0
4000708 2025021 2025021 defendant Garret Christopher husbandman 660893 660893 Garret, Christopher, of Leedes, husbandman 0
4000709 2025021 2025021 defendant Foster William husbandman 660893 660893 Foster, William, of Leedes, husbandman 1
4000710 2025021 2025021 defendant Garfurthe William husbandman 660893 660893 Garfurthe, William, of Leedes, husbandman 2
4009678 2028231 2028231 defendant Fawconer Robert yeoman 660893 660893 Fawconer, Robert, of Leedes, yeoman 0
4009679 2028231 2028231 defendant Leadbetter Christopher draper 660893 660893 Leadbetter, Christopher, of Leedes, draper 1
4009680 2028231 2028231 defendant Baynes Brian yeoman 660893 660893 Baynes, Brian, of Leedes, yeoman 2
4009681 2028231 2028231 defendant Waddesworth William merchant 660893 660893 Waddesworth, William, of Leedes, merchant 3
4014528 2029920 2029920 defendant Bassett William yeoman 660893 660893 Bassett, William, of Leedes, yeoman 0
4020404 2032019 2032019 defendant Whiteheade Anthony dyer 660893 660893 Whiteheade, Anthony, of Leedes, dyer 0
4031209 2035832 2035832 defendant Bumbye Thomas clothier 660893 660893 Bumbye, Thomas, of Leedes, clothier 0
4031210 2035832 2035832 defendant Browne Robert clothier 660893 660893 Browne, Robert, of Leedes, clothier 1
4034175 2036885 2036885 defendant Leadbetter Christopher merchant 660893 660893 Leadbetter, Christopher, of Leedes, merchant 0
4038554 2038429 2038429 defendant Craven John yeoman 660893 660893 Craven, John, of Leedes, yeoman 0
4062308 2046808 2046808 defendant Bredyer or Bregger Robert yeoman 660893 660893 Bredyer or Bregger, Robert, of Leedes, yeoman 0
4070374 2049701 2049701 defendant Leadbeatter Christopher chapman 660893 660893 Leadbeatter, Christopher, of Leedes, chapman 1
4090055 2056727 2056727 defendant Browne Thomas clothier 660893 660893 Browne, Thomas, of Leedes, clothier 0
4091347 2057195 2057195 defendant Cockell William laborer 660893 660893 Cockell, William, of Leedes, laborer 1
4091348 2057195 2057195 defendant Charley John cooper 660893 660893 Charley, John, of Leedes, cooper 2
4091353 2057196 2057196 defendant Jeffreson Richard laborer 660893 660893 Jeffreson, Richard, of Leedes, laborer 2
4096872 2059215 2059215 defendant Ellys William clothier 660893 660893 Ellys, William, of Leedes, clothier 0
4096875 2059216 2059216 defendant Sleighton Nicholas butcher 660893 660893 Sleighton, Nicholas, of Leedes, butcher 0
4110999 2064182 2064182 defendant Ambler Henry, junior victualer 660893 660893 Ambler, Henry, junior, of Leedes, victualer 1
4111000 2064182 2064182 defendant Dyckenson John clothier 660893 660893 Dyckenson, John, of Leedes, clothier 2
4119864 2067394 2067394 defendant Ambler Daniel clothier 660893 660893 Ambler, Daniel, of Leedes, clothier 1
4122073 2068197 2068197 defendant Ambler Daniel clothier 660893 660893 Ambler, Daniel, of Leedes, clothier 1
4124983 2069224 2069224 defendant Blackburne William clothier 660893 660893 Blackburne, William, of Leedes, clothier 3
4126389 2069728 2069728 defendant Tmpson John yeoman 660893 660893 Tmpson, John, of Leedes, yeoman 0
4128535 2070495 2070495 defendant Grene Anthony dyer 660893 660893 Grene, Anthony, of Leedes, dyer 2
4131605 2071623 2071623 defendant Spurstowe George esq 660893 660893 Spurstowe, George, of Leedes, or of Spurstowe, Cheshire, esq 0
4137575 2073793 2073793 defendant Mathewe Richard clothier 660893 660893 Mathewe, Richard, of Leedes, clothier 0
4138682 2074202 2074202 defendant Foster Ralph blacksmith 660893 660893 Foster, Ralph, of Leedes, blacksmith 0
4141965 2075356 2075356 defendant Gray William husbandman 660893 660893 Gray, William, of Leedes, husbandman 0
4160557 2081769 2081769 defendant Tenant Christopher tailor 660893 660893 Tenant, Christopher, of Leedes, tailor 0
4163249 2082677 2082677 defendant Crowmake Thomas clothier 660893 660893 Crowmake, Thomas, of Leedes, clothier 0
4163250 2082677 2082677 defendant Firne Christopher clothier 660893 660893 Firne, Christopher, of Leedes, clothier 1
4167554 2084146 2084146 defendant Wastall Roger laborer 660893 660893 Wastall, Roger, of Leedes, laborer 0
4167778 2084220 2084220 defendant Allen Richard butcher 660893 660893 Allen, Richard, of Leedes, butcher 0
4167779 2084220 2084220 defendant Joye John   660893 660893 Joye, John, of Leedes, "worpspynner" 1
4173024 2086019 2086019 defendant Hargrave Richard clothier 660893 660893 Hargrave, Richard, of Leedes, clothier 1
4174918 2086692 2086692 defendant Questenbury Henry tailor 660893 660893 Questenbury, Henry, of Leedes, tailor 3
4179788 2088406 2088406 defendant Clarke William clothier 660893 660893 Clarke, William, of Leedes, clothier 1
4187473 2091118 2091118 defendant Carothers John peddler 660893 660893 Carothers, John, of Leedes, peddler 0
4187474 2091118 2091118 defendant Burnett James draper 660893 660893 Burnett, James, of Leedes, draper 1
4189979 2091998 2091998 defendant Walker Thomas yeoman 660893 660893 Walker, Thomas, of Leedes, yeoman 0
4213964 2100406 2100406 defendant Robynson Alexander clothier 660893 660893 Robynson, Alexander, of Leedes, clothier 0
4240696 2109870 2109870 defendant Dixson James clothier 660893 660893 Dixson, James, of Leedes, clothier 1
4249223 2112725 2112725 defendant Dixson James clothier 660893 660893 Dixson, James, of Leedes, clothier 1
4249224 2112725 2112725 defendant Venners John clothier 660893 660893 Venners, John, of Leedes, clothier 2
4250163 2113035 2113035 defendant Acroyde Roger clerk 660893 660893 Acroyde, Roger, of Leedes, clerk 0
4253393 2114124 2114124 defendant Foster Ralph yeoman 660893 660893 Foster, Ralph, of Leedes, yeoman 0
4264464 2117754 2117754 defendant Acroyde Roger clerk 660893 660893 Acroyde, Roger, of Leedes, clerk 0
4278748 2122503 2122503 defendant Falkingham John gent 660893 660893 Falkingham, John, of Leedes, gent 0
4312136 2134384 2134384 defendant Bensted John mercer 660893 660893 Bensted, John, of Leedes, mercer 0
4316177 2135770 2135770 defendant Cooke Robert yeoman 660893 660893 Cooke, Robert, of Leedes, yeoman 2
4316343 2135831 2135831 defendant Lawson Guilford gent 660893 660893 Lawson, Guilford, of Leedes, or of Washington, Durham, gent 0
4317527 2136245 2136245 defendant Ellis Richard clothier 660893 660893 Ellis, Richard, of Leedes, clothier 1
4317529 2136245 2136245 defendant Ferne Christopher clothier 660893 660893 Ferne, Christopher, of Leedes, clothier 3
4317888 2136368 2136368 defendant Jeffrey William clothier 660893 660893 Jeffrey, William, of Leedes, clothier 0
4322352 2137889 2137889 defendant Greathead Edward   660893 660893 Greathead, Edward, of Leedes, or of Cowlne, Lancs, surgeon 3
4332422 2141134 2141134 defendant Taylor Thomas yeoman 660893 660893 Taylor, Thomas, of Leedes, yeoman 1
4349824 2147196 2147196 defendant Cowper George yeoman 660893 660893 Cowper, George, of Leedes, yeoman 0
4353287 2148377 2148377 defendant Browne Thomas clothier 660893 660893 Browne, Thomas, of Leedes, clothier 2
4353288 2148377 2148377 defendant Ambler James yeoman 660893 660893 Ambler, James, of Leedes, yeoman 3
4359263 2150474 2150474 defendant Reynold Edward clothier 660893 660893 Reynold, Edward, of Leedes, clothier 0
4362036 2151467 2151467 defendant Reynoldes Edward yeoman 660893 660893 Reynoldes, Edward, of Leedes, yeoman 0
4365422 2152699 2152699 defendant Dickson William clothier 660893 660893 Dickson, William, of Leedes, clothier 0
4375933 2156455 2156455 defendant Reynoldes Richard yeoman 660893 660893 Reynoldes, Richard, of Leedes, yeoman 0
4375944 2156460 2156460 defendant Reynold Edward yeoman 660893 660893 Reynold, Edward, of Leedes, yeoman 0
4375946 2156461 2156461 defendant Reynold Edward yeoman 660893 660893 Reynold, Edward, of Leedes, yeoman 0
4375947 2156461 2156461 defendant Coucheman Thomas yeoman 660893 660893 Coucheman, Thomas, of Leedes, yeoman 1
4380272 2158047 2158047 defendant Kytchyn John yeoman 660893 660893 Kytchyn, John, of Leedes, yeoman 0
4382140 2158719 2158719 defendant Coldcole Brian chapman 660893 660893 Coldcole, Brian, of Leedes, chapman 0
4384852 2159622 2159622 defendant Hopton Christopher draper 660893 660893 Hopton, Christopher, of Leedes, draper 2
4386826 2160262 2160262 defendant Sowden George chapman 660893 660893 Sowden, George, of Leedes, chapman 1
4390303 2161379 2161379 defendant Woldgate Richard yeoman 660893 660893 Woldgate, Richard, of Leedes, yeoman 0
4392893 2162235 2162235 defendant Colcole Brian chapman 660893 660893 Colcole, Brian, of Leedes, chapman 0
4392896 2162235 2162235 defendant Hardwick Thomas yeoman 660893 660893 Hardwick, Thomas, of Leedes, yeoman 3
4397712 2163812 2163812 defendant Heldreth Henry yeoman 660893 660893 Heldreth, Henry, of Leedes, yeoman 0
4401177 2164989 2164989 defendant Hirste Robert sherman 660893 660893 (Hirste, Robert, of Leedes, sherman 4
4404879 2166202 2166202 defendant Marton Ingram yeoman 660893 660893 Marton, Ingram, of Leedes, yeoman 0
4404882 2166202 2166202 defendant Kitchinman George yeoman 660893 660893 Kitchinman, George, of Leedes, yeoman 3
4404972 2166233 2166233 defendant Reynoldes Richard yeoman 660893 660893 Reynoldes, Richard, of Leedes, yeoman 0
4405006 2166246 2166246 defendant Coucheman Thomas yeoman 660893 660893 Coucheman, Thomas, of Leedes, yeoman 0
4406256 2166656 2166656 defendant Francklyn Thomas dyer 660893 660893 Francklyn, Thomas, of Leedes, dyer 2
4408460 2167409 2167409 defendant Raynold Edward clothier 660893 660893 Raynold, Edward, of Leedes, clothier 1
4408461 2167409 2167409 defendant Cowcheman Thomas fuller 660893 660893 Cowcheman, Thomas, of Leedes, fuller 2
4409113 2167652 2167652 defendant Franckland Thomas dyer 660893 660893 Franckland, Thomas, of Leedes, dyer 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);