names

98 rows where place_id = 586450

✎ 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
3588747 1864123 1864123 defendant Becher John husbandman 586450 586450 Becher, John, of Tunbregge, husbandman 4
3590380 1864632 1864632 defendant Lorkyn Richard laborer 586450 586450 Lorkyn, Richard, of Tunbregge, laborer 0
3591195 1864869 1864869 plaintiff Dodde John (legal representative) 586450 586450 Dodde, John, of Tunbregge, yeoman, executrix of 0
3591197 1864869 1864869 defendant Tunbregge Hugh tanner 586450 586450 Tunbregge, Hugh, of Tunbregge, tanner 0
3595436 1866207 1866207 defendant Pyrdow John yeoman 586450 586450 Pyrdow, John, of Tunbregge, yeoman 0
3595437 1866207 1866207 defendant Marden Thomas yeoman 586450 586450 Marden, Thomas, of Tunbregge, yeoman 1
3595865 1866345 1866345 defendant Latter William husbandman 586450 586450 Latter, William, of Tunbregge, husbandman 2
3599278 1867417 1867417 defendant Ramesey John clerk 586450 586450 Ramesey, John, of Tunbregge, clerk 0
3599940 1867637 1867637 defendant Fane John (legal representative) 586450 586450 Fane, John, of Tunbregge, executors of 0
3599941 1867637 1867637 defendant Fane Sybil widow 586450 586450 (Fane, Sybil, of Tunbregge, widow 1
3599942 1867637 1867637 defendant Fane Henry gent 586450 586450 Fane, Henry, of Tunbregge, gent 2
3605496 1869383 1869383 defendant Romyng John   586450 586450 Romyng, John, of Tunbregge, tile maker 2
3608314 1870258 1870258 defendant Tylly John joiner 586450 586450 Tylly, John, of Tunbregge, joiner 0
3624645 1875243 1875243 defendant Tilly John carver 586450 586450 Tilly, John, of Tunbregge, carver 0
3716085 1931317 1931317 plaintiff Childern John (legal representative) 586450 586450 Childern, John, of Tunbregge, executors of 0
3717995 1931924 1931924 defendant Willard Richard husbandman 586450 586450 Willard, Richard, of Tunbregge, husbandman 0
3729088 1935348 1935348 defendant Peke Richard innholder 586450 586450 Peke, Richard, of Tunbregge, innholder 0
3731734 1936155 1936155 plaintiff Chyldern John, senior (legal representative) 586450 586450 Chyldern, John, senior, of Tunbregge, executor of 0
3750359 1942031 1942031 defendant Dixson Thomas yeoman 586450 586450 Dixson, Thomas, of Tunbregge, yeoman 0
3811622 1961532 1961532 defendant West Lawrence smith 586450 586450 West, Lawrence, of Tunbregge, smith 1
3860758 1977091 1977091 defendant Weste Lawrence smith 586450 586450 Weste, Lawrence, of Tunbregge, smith 1
3891358 1987375 1987375 defendant Harrys John chapman 586450 586450 Harrys, John, of Tunbregge, chapman 1
3919381 1996813 1996813 defendant Harrys John chapman 586450 586450 Harrys, John, of Tunbregge, chapman 1
4485227 2196084 2196084 plaintiff Punche John   586450 586450 Punche, John, of tunbregge 0
4596863 2230257 2230257 plaintiff Sandhelle Richard   586450 586450 Sandhelle, Richard, of Tunbregge 0
4631882 2240855 2240855 defendant Hadle John   586450 586450 Hadle, John, of Tunbregge 0
4653454 2247011 2247011 plaintiff Beerme Thomas   586450 586450 Beerme, Thomas, of Tunbregge 0
4653456 2247011 2247011 defendant Halle Thomas glover 586450 586450 Halle, Thomas, of Tunbregge, glover 1
4677975 2258729 2258729 defendant Kerst John laborer 586450 586450 Kerst, John, of Tunbregge, laborer 0
4750277 2280559 2280559 defendant Cotyng Roger husbandman 586450 586450 Cotyng, Roger, of Tunbregge, husbandman 0
4785631 2291533 2291533 defendant Willyam Robert laborer 586450 586450 Willyam, Robert, of Tunbregge, laborer 1
4816943 2301401 2301401 plaintiff Mathewe William   586450 586450 Mathewe, William, of Tunbregge, on his own account 0
4817487 2301560 2301560 defendant Pycot John   586450 586450 Pycot, John, of Tunbregge 0
4819633 2302215 2302215 defendant Herst Reginald baker 586450 586450 Herst, Reginald, of Tunbregge, baker 0
4821581 2302831 2302831 defendant Kyne Lawrence clerk 586450 586450 Kyne, Lawrence, of Tunbregge, clerk 1
4821582 2302831 2302831 defendant Basele John husbandman 586450 586450 Basele, John, of Tunbregge, husbandman 2
4828422 2304933 2304933 defendant Fyssher Thomas fuller 586450 586450 Fyssher, Thomas, of Tunbregge, fuller 1
4861047 2314813 2314813 defendant Gyles John butcher 586450 586450 Gyles, John, of Tunbregge, butcher 2
4879603 2320545 2320545 defendant Hadlo John husbandman 586450 586450 Hadlo, John, of Tunbregge, husbandman 1
4884235 2321978 2321978 defendant Bitesere or Bitefere Giles   586450 586450 Bitesere or Bitefere, Giles, of Tunbregge, servant 0
4896233 2325482 2325482 plaintiff Chaundeler Thomas   586450 586450 Chaundeler, Thomas, of Tunbregge 0
4896927 2325689 2325689 defendant Goldsmyth John roper 586450 586450 Goldsmyth, John, of Tunbregge, roper 0
4896929 2325690 2325690 defendant Goldsmyth John roper 586450 586450 Goldsmyth, John, of Tunbregge, roper 0
4924414 2334074 2334074 defendant Partrych William parker or park keeper 586450 586450 Partrych, William, of Tunbregge, parker or park keeper 1
4929194 2335547 2335547 defendant Style John yeoman 586450 586450 Style, John, of Tunbregge, yeoman 2
4942801 2339719 2339719 defendant Herman William butcher 586450 586450 Herman, William, of Tunbregge, butcher 0
5004513 2358220 2358220 plaintiff Pycot John   586450 586450 Pycot, John, of Tunbregge 0
5004517 2358221 2358221 plaintiff Pycot John   586450 586450 Pycot, John, of Tunbregge 0
5010321 2359888 2359888 defendant Mauncer Thomas butcher 586450 586450 Mauncer, Thomas, of Tunbregge, butcher 0
5015422 2361392 2361392 defendant Basele John husbandman 586450 586450 Basele, John, of Tunbregge, husbandman 0
5046291 2370522 2370522 defendant Martyn alias Mortymer William husbandman 586450 586450 Martyn alias Mortymer, William, of Tunbregge, husbandman 0
5046293 2370523 2370523 defendant Martyn alias Mortymer William husbandman 586450 586450 Martyn alias Mortymer, William, of Tunbregge, husbandman 0
5049836 2371578 2371578 defendant Est John husbandman 586450 586450 Est, John, of Tunbregge, husbandman 3
5070169 2377573 2377573 defendant Fyssher Thomas fuller 586450 586450 Fyssher, Thomas, of Tunbregge, fuller 0
5122380 2392972 2392972 defendant Basyn John husbandman 586450 586450 Basyn, John, of Tunbregge, husbandman 0
5132626 2396038 2396038 plaintiff Herst Reginald, junior   586450 586450 Herst, Reginald, junior, of Tunbregge 0
5195297 2414372 2414372 defendant Tyherst John baker 586450 586450 Tyherst, John, of Tunbregge, baker 0
5217947 2420984 2420984 defendant Plane Thomas yeoman 586450 586450 Plane, Thomas, of Tunbregge, yeoman 0
5217948 2420984 2420984 defendant Borner Robert yeoman 586450 586450 Borner, Robert, of Tunbregge, yeoman 1
5239302 2427080 2427080 defendant Avane John yeoman 586450 586450 Avane, John, of Tunbregge, yeoman 0
5314816 2449476 2449476 defendant Shepherd John collier 586450 586450 Shepherd, John, of Tunbregge, collier 0
5324514 2452417 2452417 defendant Goodmond Roger chapman 586450 586450 Goodmond, Roger, of Tunbregge, chapman 0
5330010 2454056 2454056 defendant Carter Richard yeoman 586450 586450 Carter, Richard, of Tunbregge, yeoman 0
5339005 2456770 2456770 defendant Ware John butcher 586450 586450 Ware, John, of Tunbregge, butcher 0
5339006 2456770 2456770 defendant Walter John   586450 586450 Walter, John, of Tunbregge, patin maker 1
5341047 2457400 2457400 defendant Polley John gent 586450 586450 Polley, John, of Tunbregge, gent 1
5341049 2457400 2457400 defendant Hamme Anne widow 586450 586450 Hamme, Anne, of Tunbregge, widow 3
5353913 2461289 2461289 defendant Holstok Thomas dyer 586450 586450 Holstok, Thomas, of Tunbregge, dyer 0
5353916 2461289 2461289 defendant Andrewe John weaver 586450 586450 Andrewe, John, of Tunbregge, weaver 3
5359875 2463129 2463129 defendant Welle William smith 586450 586450 Welle, William, of Tunbregge, smith 0
5363943 2464376 2464376 defendant Lyon Henry tailor 586450 586450 Lyon, Henry, of Tunbregge, tailor 0
5419445 2480734 2480734 defendant Fane John yeoman 586450 586450 Fane, John, of Tunbregge, yeoman 0
5431330 2484322 2484322 defendant Rumshet Nicholas husbandman 586450 586450 Rumshet, Nicholas, of Tunbregge, husbandman 0
5432645 2484731 2484731 defendant Grene William dyer 586450 586450 Grene, William, of Tunbregge, dyer 4
5441633 2487415 2487415 defendant Hasden Thomas husbandman 586450 586450 Hasden, Thomas, of Tunbregge, husbandman 0
5443680 2488031 2488031 defendant Polley Thomas butcher 586450 586450 Polley, Thomas, of Tunbregge, butcher 0
5448690 2489505 2489505 defendant Grene William dyer 586450 586450 Grene, William, of Tunbregge, dyer 4
5451940 2490462 2490462 defendant Fane John yeoman 586450 586450 Fane, John, of Tunbregge, yeoman 0
5456470 2491858 2491858 defendant Polley Thomas butcher 586450 586450 Polley, Thomas, of Tunbregge, butcher 0
5468288 2495457 2495457 defendant Polley Thomas butcher 586450 586450 Polley, Thomas, of Tunbregge, butcher 0
5472549 2496757 2496757 defendant Grene William dyer 586450 586450 Grene, William, of Tunbregge, dyer 4
5491768 2502438 2502438 defendant Coke Simon butcher 586450 586450 Coke, Simon, of Tunbregge, butcher 0
5505030 2506484 2506484 plaintiff Bechere Nicholas   586450 586450 Bechere, Nicholas, of Tunbregge 0
5505033 2506484 2506484 defendant Hothe Richard glover 586450 586450 Hothe, Richard, of Tunbregge, glover 2
5506671 2507003 2507003 defendant Holstok Thomas husbandman 586450 586450 Holstok, Thomas, of Tunbregge, husbandman 0
5530589 2514084 2514084 defendant Adamps David yeoman of the crown 586450 586450 Adamps, David, of Tunbregge, yeoman of the crown 1
5546075 2518849 2518849 defendant Tylly John carver 586450 586450 Tylly, John, of Tunbregge, carver 0
5559921 2522857 2522857 defendant Becher Cuthbert yeoman 586450 586450 Becher, Cuthbert, of Tunbregge, yeoman 2
5559925 2522858 2522858 defendant Becher Cuthbert yeoman 586450 586450 Becher, Cuthbert, of Tunbregge, yeoman 2
5559927 2522859 2522859 defendant Becher Nicholas (legal representative) 586450 586450 Becher, Nicholas, of Tunbregge, cutler, executors of 0
5559929 2522859 2522859 defendant Becher Cuthbert yeoman 586450 586450 Becher, Cuthbert, of Tunbregge, yeoman 2
5559933 2522860 2522860 defendant Becher Cuthbert yeoman 586450 586450 Becher, Cuthbert, of Tunbregge, yeoman 2
5576363 2527660 2527660 defendant Salmon William husbandman 586450 586450 Salmon, William, of Tunbregge, husbandman 0
5576364 2527660 2527660 defendant Salmon George husbandman 586450 586450 Salmon, George, of Tunbregge, husbandman 1
5590904 2532132 2532132 defendant Leukenore Richard gent 586450 586450 Leukenore, Richard, of Tunbregge, gent 0
5627270 2552497 2552497 defendant Godfrey William shingler 586450 586450 Godfrey, William, of Tunbregge, shingler 0
5631489 2553858 2553858 defendant Hervest John husbandman 586450 586450 Hervest, John, of Tunbregge, husbandman 2
5636432 2555349 2555349 defendant Halden John gent 586450 586450 Halden, John, of Tunbregge, gent 3

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