names

96 rows where place_id = 591084

✎ 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
3603279 1868698 1868698 defendant Fletcher Ellen widow 591084 591084 Fletcher, Ellen, of Geyst, widow 2
3603427 1868739 1868739 defendant Mason Thomas yeoman 591084 591084 Mason, Thomas, of Geyst, yeoman 16
3637629 1906580 1906580 defendant Beverley Richard thatcher 591084 591084 Beverley, Richard, of Geyst, thatcher 2
3708946 1929090 1929090 defendant Adams Thomas husbandman 591084 591084 Adams, Thomas, of Geyst, husbandman 2
3726848 1934665 1934665 defendant Ferror Thomas husbandman 591084 591084 Ferror, Thomas, of Geyst, husbandman 2
3734872 1937147 1937147 defendant Adams Thomas husbandman 591084 591084 Adams, Thomas, of Geyst, husbandman 5
3852364 1974341 1974341 defendant Preston John miller 591084 591084 Preston, John, of Geyst, miller 2
3885509 1985408 1985408 defendant Brandon Ralph yeoman 591084 591084 (Brandon, Ralph, of Geyst, yeoman 1
3885514 1985409 1985409 defendant Brandon Ralph yeoman 591084 591084 (Brandon, Ralph, of Geyst, yeoman 1
3922425 1997816 1997816 defendant Southgate Henry husbandman 591084 591084 Southgate, Henry, of Geyst, husbandman 0
3922426 1997816 1997816 defendant Wylton Thomas husbandman 591084 591084 Wylton, Thomas, of Geyst, husbandman 1
3970353 2014229 2014229 plaintiff Davye Edmund yeoman 591084 591084 Davye, Edmund, of Geyst, yeoman 0
3970354 2014229 2014229 defendant Makyn William butcher 591084 591084 Makyn, William, of Geyst, butcher 0
3970355 2014229 2014229 defendant Dyman Simon yeoman 591084 591084 Dyman, Simon, of Geyst, yeoman 1
4035724 2037452 2037452 defendant Clement Robert yeoman 591084 591084 Clement, Robert, of Geyst, yeoman 1
4053316 2043561 2043561 defendant Diamont Simon yeoman 591084 591084 Diamont, Simon, of Geyst, yeoman 1
4089678 2056603 2056603 defendant Steynesby Andrew clerk 591084 591084 Steynesby, Andrew, of Geyst, or of Wysbyche, Isle of Ely, Cams, clerk 0
4145439 2076563 2076563 defendant Nicholl William yeoman 591084 591084 Nicholl, William, of Geyst, yeoman 0
4145492 2076581 2076581 defendant Nicholl William yeoman 591084 591084 Nicholl, William, of Geyst, yeoman 0
4425736 2172858 2172858 defendant Barkere William   591084 591084 Barkere, William, of Geyst 0
4473878 2192482 2192482 defendant Coupere John   591084 591084 Coupere, John, of Geyst 2
4476731 2193383 2193383 defendant Wykkes John   591084 591084 Wykkes, John, of Geyst 0
4599567 2231080 2231080 defendant Ferrour John   591084 591084 Ferrour, John, of Geyst 1
4603087 2232177 2232177 defendant Wykkes John   591084 591084 Wykkes, John, of Geyst 1
4625341 2238891 2238891 defendant Barkere Henry   591084 591084 Barkere, Henry, of Geyst 0
4625343 2238891 2238891 defendant Long Thomas   591084 591084 Long, Thomas, of Geyst 2
4642972 2244050 2244050 defendant Marcheys John   591084 591084 Marcheys, John, of Geyst 1
4642973 2244050 2244050 defendant Southgate Adam   591084 591084 Southgate, Adam, of Geyst 2
4650127 2246056 2246056 defendant Grene Thomas   591084 591084 Grene, Thomas, of Geyst 0
4654652 2247333 2247333 defendant Smal John husbandman 591084 591084 Smal, John, of Geyst, husbandman 5
4654653 2247333 2247333 defendant Sutton John yeoman 591084 591084 Sutton, John, of Geyst, yeoman 6
4688270 2261899 2261899 defendant Wykkes John laborer 591084 591084 Wykkes, John, of Geyst, laborer 3
4688528 2261977 2261977 defendant Kyng John miller 591084 591084 Kyng, John, of Geyst, miller 1
4690279 2262514 2262514 defendant Grene Thomas husbandman 591084 591084 Grene, Thomas, of Geyst, husbandman 1
4702075 2266057 2266057 defendant atte Grene Thomas laborer 591084 591084 atte Grene, Thomas, of Geyst, laborer 2
4702076 2266057 2266057 defendant Wykkes William laborer 591084 591084 Wykkes, William, of Geyst, laborer 3
4726189 2273473 2273473 defendant Wykkes William laborer 591084 591084 Wykkes, William, of Geyst, laborer 2
4742381 2278265 2278265 defendant Abelot Thomas husbandman 591084 591084 Abelot, Thomas, of Geyst, husbandman 2
4750745 2280700 2280700 defendant Dobbes John husbandman 591084 591084 Dobbes, John, of Geyst, husbandman 2
4751686 2280982 2280982 defendant Dobbys John husbandman 591084 591084 Dobbys, John, of Geyst, husbandman 1
4752739 2281258 2281258 defendant Abelot Henry yeoman 591084 591084 Abelot, Henry, of Geyst, yeoman 0
4756669 2282452 2282452 defendant Miller Hugh husbandman 591084 591084 Miller, Hugh, of Geyst, husbandman 0
4759065 2283186 2283186 defendant Skowele Robert yeoman 591084 591084 Skowele, Robert, of Geyst, yeoman 0
4759066 2283186 2283186 defendant Abelot Thomas yeoman 591084 591084 Abelot, Thomas, of Geyst, yeoman 1
4768813 2286223 2286223 defendant Lutton William husbandman 591084 591084 Lutton, William, of Geyst, husbandman 3
4772377 2287325 2287325 defendant Dobbys John yeoman 591084 591084 Dobbys, John, of Geyst, yeoman 0
4772378 2287325 2287325 defendant Southgate John   591084 591084 Southgate, John, of Geyst, yeoman, son of Thomas 1
4780670 2289951 2289951 defendant Fecard Edmund yeoman 591084 591084 Fecard, Edmund, of Geyst, yeoman 0
4793332 2294012 2294012 defendant Lutton William husbandman 591084 591084 Lutton, William, of Geyst, husbandman 3
4812145 2299911 2299911 defendant Southgate Adam yeoman 591084 591084 Southgate, Adam, of Geyst, yeoman 0
4830060 2305446 2305446 defendant Miles William husbandman 591084 591084 Miles, William, of Geyst, husbandman 4
4871644 2318097 2318097 defendant Kempster Seman husbandman 591084 591084 Kempster, Seman, of Geyst, husbandman 2
4892230 2324312 2324312 defendant Wekkys John laborer 591084 591084 Wekkys, John, of Geyst, laborer 7
4900897 2326909 2326909 defendant Whithie William husbandman 591084 591084 Whithie, William, of Geyst, husbandman 2
4927502 2335037 2335037 defendant Wythye William   591084 591084 Wythye, William, of Geyst, shepherd 0
4934897 2337317 2337317 defendant Wethe William husbandman 591084 591084 Wethe William, of Geyst, husbandman 0
4934898 2337317 2337317 defendant Narburgh Richard husbandman 591084 591084 Narburgh, Richard, of Geyst, husbandman 1
4936736 2337868 2337868 defendant Ferve Nicholas husbandman 591084 591084 Ferve, Nicholas, of Geyst, husbandman 7
4936737 2337868 2337868 defendant Fayre Thomas husbandman 591084 591084 Fayre, Thomas, of Geyst, husbandman 8
4936738 2337868 2337868 defendant Barker Adam husbandman 591084 591084 Barker, Adam, of Geyst, husbandman 9
4937175 2337994 2337994 defendant Reder Simon miller 591084 591084 Reder, Simon, of Geyst, miller 2
4947918 2341335 2341335 defendant Martyn William yeoman 591084 591084 Martyn, William, of Geyst, yeoman 0
4962118 2345576 2345576 defendant Rous Edmund husbandman 591084 591084 Rous, Edmund, of Geyst, husbandman 4
4973334 2348962 2348962 defendant Bateman John husbandman 591084 591084 Bateman, John, of Geyst, husbandman 0
4981949 2351519 2351519 defendant Narburgh Henry husbandman 591084 591084 Narburgh, Henry, of Geyst, husbandman 1
4984852 2352398 2352398 defendant Reder Simon miller 591084 591084 Reder, Simon, of Geyst, miller 1
4984855 2352399 2352399 plaintiff Martyn William husbandman 591084 591084 Martyn, William, of Geyst, husbandman 1
5020496 2362883 2362883 defendant Wekis John husbandman 591084 591084 Wekis, John, of Geyst, husbandman 1
5024350 2364038 2364038 defendant Martyn William husbandman 591084 591084 Martyn, William, of Geyst, husbandman 0
5027007 2364769 2364769 defendant Martyn William yeoman 591084 591084 Martyn, William, of Geyst, or of Henyngham, Norf, yeoman 0
5075406 2379139 2379139 defendant Gardener William butcher 591084 591084 Gardener, William, of Geyst, butcher 0
5075407 2379139 2379139 defendant Pirt Henry husbandman 591084 591084 Pirt, Henry, of Geyst, husbandman 1
5075408 2379139 2379139 defendant Sowgate Thomas husbandman 591084 591084 Sowgate, Thomas, of Geyst, husbandman 2
5075409 2379139 2379139 defendant Wyx- John husbandman 591084 591084 Wyx-, John, of Geyst, husbandman 3
5075410 2379139 2379139 defendant Davy Robert husbandman 591084 591084 Davy, Robert, of Geyst, husbandman 4
5108434 2388901 2388901 defendant Skynner Robert husbandman 591084 591084 Skynner, Robert, of Geyst, or of Gyldengeyst, husbandman 1
5125430 2393921 2393921 defendant Skynner Robert husbandman 591084 591084 Skynner, Robert, of Geyst, husbandman 0
5144057 2399409 2399409 defendant Skynner Robert husbandman 591084 591084 Skynner, Robert, of Geyst, husbandman 0
5165042 2405516 2405516 defendant Skynner Robert husbandman 591084 591084 Skynner, Robert, of Geyst, husbandman 0
5188767 2412444 2412444 defendant Brese Thomas yeoman 591084 591084 Brese, Thomas, of Geyst, yeoman 2
5279435 2439069 2439069 plaintiff Brese John, junior   591084 591084 Brese, John, junior, of Geyst 0
5304615 2446378 2446378 defendant Brese John yeoman 591084 591084 Brese, John, of Geyst, yeoman 1
5315827 2449806 2449806 defendant Southgate Thomas husbandman 591084 591084 Southgate, Thomas, of Geyst, husbandman 0
5315828 2449806 2449806 defendant Southgate John husbandman 591084 591084 Southgate, John, of Geyst, husbandman 1
5379879 2469293 2469293 defendant Barker Robert yeoman 591084 591084 Barker, Robert, of Geyst, yeoman 2
5391021 2472499 2472499 defendant Barker Robert husbandman 591084 591084 Barker, Robert, of Geyst, husbandman 2
5419808 2480840 2480840 plaintiff Sylke Henry   591084 591084 Sylke, Henry, of Geyst 0
5475844 2497779 2497779 plaintiff Sylke Henry   591084 591084 Sylke, Henry, of Geyst 0
5477237 2498201 2498201 defendant Wylton Thomas husbandman 591084 591084 Wylton, Thomas, of Geyst, husbandman 0
5545521 2518680 2518680 defendant Martyn Thomas clerk 591084 591084 Martyn, Thomas, of Geyst, clerk 2
5545542 2518684 2518684 defendant Martyn Thomas clerk 591084 591084 Martyn, Thomas, of Geyst, clerk 2
5572091 2526385 2526385 defendant Beverley Richard husbandman 591084 591084 Beverley, Richard, of Geyst, husbandman 0
5572092 2526385 2526385 defendant Buk Robert husbandman 591084 591084 Buk, Robert, of Geyst, husbandman 1
5572093 2526385 2526385 defendant Courby John husbandman 591084 591084 Courby, John, of Geyst, husbandman 2
5586975 2530953 2530953 defendant Beverley Richard husbandman 591084 591084 Beverley, Richard, of Geyst, husbandman 0
5586976 2530953 2530953 defendant Buk Robert husbandman 591084 591084 Buk, Robert, of Geyst, husbandman 1

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