names

158 rows where place_id = 587486

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591540 1864980 1864980 plaintiff Elryngton John gent 587486 587486 Elryngton, John, of Hakeney, gent 0
3591546 1864981 1864981 plaintiff Elryngton John gent 587486 587486 Elryngton, John, of Hakeney, gent 0
3601421 1868104 1868104 defendant Waller Thomas laborer 587486 587486 Waller, Thomas, of Hakeney, laborer 0
3601423 1868105 1868105 plaintiff Elryngton John gent 587486 587486 Elryngton, John, of Hakeney, gent 1
3625215 1875422 1875422 defendant ap Thomas of Hugh yeoman 587486 587486 ap Thomas, of Hugh, of Hakeney, yeoman 0
3637991 1906700 1906700 defendant Atwodde Agnes spinster 587486 587486 Atwodde, Agnes, of Hakeney, spinster 1
3637996 1906701 1906701 defendant Atwodde Agnes spinster 587486 587486 Atwodde, Agnes, of Hakeney, spinster 1
3638001 1906702 1906702 defendant Atwodde Agnes spinster 587486 587486 Atwodde, Agnes, of Hakeney, spinster 1
3656691 1912343 1912343 defendant Thompson John brewer 587486 587486 Thompson, John, of Hakeney, brewer 0
3664996 1914997 1914997 defendant Messenger Thomas husbandman 587486 587486 Messenger, Thomas, of Hakeney, husbandman 0
3664998 1914998 1914998 defendant Messenger Thomas husbandman 587486 587486 Messenger, Thomas, of Hakeney, husbandman 0
3667500 1915777 1915777 defendant Podde Thomas husbandman 587486 587486 Podde, Thomas, of Hakeney, husbandman 1
3667502 1915778 1915778 defendant Podde Thomas husbandman 587486 587486 Podde, Thomas, of Hakeney, husbandman 0
3722066 1933164 1933164 defendant Hedy John hakeneyman 587486 587486 Hedy, John, of Hakeney, hakeneyman 3
3782081 1952150 1952150 defendant Bayly Robert yeoman 587486 587486 Bayly, Robert, of Hakeney, yeoman 0
3785135 1953138 1953138 defendant Knevett William gent 587486 587486 Knevett, William, of Hakeney, gent 2
3798112 1957306 1957306 defendant Crypsey John innholder 587486 587486 Crypsey, John, of Hakeney, innholder 5
3827743 1966544 1966544 defendant Heron Edmund gent 587486 587486 Heron, Edmund, of Hakeney, gent 0
3827744 1966544 1966544 defendant Heron Christopher gent 587486 587486 Heron, Christopher, of Hakeney, gent 1
3827751 1966546 1966546 defendant Heron Christopher gent 587486 587486 Heron, Christopher, of Hakeney, gent 1
3846218 1972374 1972374 defendant Bred John smith 587486 587486 Bred, John, of Hakeney, smith 1
3861864 1977426 1977426 defendant Bred John smith 587486 587486 Bred, John, of Hakeney, smith 1
4448870 2184587 2184587 defendant Bregge John, junior   587486 587486 Bregge, John, junior, of Hakeney 0
4473661 2192407 2192407 defendant Hal--- William   587486 587486 Hal---, William, of Hakeney 1
4477439 2193607 2193607 defendant Baker John   587486 587486 Baker, John, of Hakeney 0
4537656 2212050 2212050 defendant Forthe John   587486 587486 Forthe, John, of Hakeney 0
4587904 2227616 2227616 defendant Salman William   587486 587486 Salman, William, of Hakeney 0
4639566 2243085 2243085 plaintiff Rede John   587486 587486 Rede, John, of Hakeney 2
4692957 2263307 2263307 defendant Fissher Richard fishmonger 587486 587486 Fissher, Richard, of Hakeney, fishmonger 0
4717943 2270951 2270951 defendant Van William laborer 587486 587486 Van, William, of Hakeney, laborer 0
4765300 2285131 2285131 defendant Rede Richard laborer 587486 587486 Rede, Richard, of Hakeney, laborer 0
4767215 2285731 2285731 plaintiff Malter John   587486 587486 Malter, John, of Hakeney 0
4767216 2285731 2285731 defendant Goldstone Nicholas husbandman 587486 587486 Goldstone, Nicholas, of Hakeney, husbandman 0
4771124 2286951 2286951 defendant Alford William husbandman 587486 587486 Alford, William, of Hakeney, husbandman 0
4771754 2287142 2287142 defendant Douner John husbandman 587486 587486 Douner, John, of Hakeney, husbandman 1
4771755 2287142 2287142 defendant Colman John husbandman 587486 587486 Colman, John, of Hakeney, husbandman 2
4773929 2287825 2287825 defendant Anstone John husbandman 587486 587486 Anstone, John, of Hakeney, husbandman 1
4778942 2289390 2289390 defendant Leues or Lenes Richard husbandman 587486 587486 Leues or Lenes, Richard, of Hakeney, husbandman 1
4802957 2297111 2297111 defendant Merssanger John husbandman 587486 587486 Merssanger, John, of Hakeney, husbandman 0
4802958 2297111 2297111 defendant Lanam John husbandman 587486 587486 Lanam, John, of Hakeney, husbandman 1
4802959 2297111 2297111 defendant Howeker William laborer 587486 587486 Howeker, William, of Hakeney, laborer 2
4863734 2315629 2315629 defendant Drymond John husbandman 587486 587486 Drymond, John, of Hakeney, husbandman 0
4884520 2322064 2322064 plaintiff Newerk Thomas   587486 587486 Newerk, Thomas, of Hakeney 0
4890598 2323816 2323816 defendant Roddok Thomas husbandman 587486 587486 Roddok, Thomas, of Hakeney, husbandman 0
4890599 2323816 2323816 defendant Howard Richard husbandman 587486 587486 Howard, Richard, of Hakeney, husbandman 1
4890600 2323816 2323816 defendant Hoker William husbandman 587486 587486 Hoker, William, of Hakeney, husbandman 2
4890601 2323816 2323816 defendant Myllys John husbandman 587486 587486 Myllys, John, of Hakeney, husbandman 3
4903554 2327722 2327722 defendant Estfeld Luke husbandman 587486 587486 Estfeld, Luke, of Hakeney, husbandman 0
4910927 2329929 2329929 defendant Dowenner John yeoman 587486 587486 Dowenner, John, of Hakeney, yeoman 0
4915858 2331455 2331455 defendant Rysshebury John yeoman 587486 587486 Rysshebury, John, of Hakeney, yeoman 0
4915860 2331456 2331456 defendant Rysshebury John yeoman 587486 587486 Rysshebury, John, of Hakeney, yeoman 0
4916082 2331530 2331530 defendant Girlyngton Edmund husbandman 587486 587486 Girlyngton, Edmund, of Hakeney, husbandman 3
4922304 2333393 2333393 defendant Rolff John husbandman 587486 587486 Rolff, John, of Hakeney, husbandman 0
4923128 2333651 2333651 defendant Rolf John husbandman 587486 587486 Rolf, John, of Hakeney, husbandman 1
4947454 2341200 2341200 defendant Austyn John husbandman 587486 587486 Austyn, John, of Hakeney, husbandman 1
4961936 2345523 2345523 defendant Puell Geoffrey husbandman 587486 587486 Puell, Geoffrey, of Hakeney, husbandman 0
4971767 2348484 2348484 defendant Tyllesley Elias gent 587486 587486 Tyllesley, Elias, of Hakeney, gent 0
4979334 2350780 2350780 defendant Rous Giles husbandman 587486 587486 Rous, Giles, of Hakeney, husbandman 0
4997010 2355958 2355958 defendant Heron Ralph husbandman 587486 587486 Heron, Ralph, of Hakeney, husbandman 0
5006448 2358785 2358785 defendant Sunday Anne widow 587486 587486 Sunday, Anne, of Hakeney, widow 0
5006450 2358786 2358786 defendant Sunday Anne widow 587486 587486 Sunday, Anne, of Hakeney, widow 0
5006849 2358903 2358903 defendant Tyrwyn Thomas baker 587486 587486 Tyrwyn, Thomas, of Hakeney, baker 1
5018011 2362150 2362150 defendant Dyrwyn Thomas   587486 587486 Dyrwyn, Thomas, of Hakeney, servant 0
5018012 2362150 2362150 defendant H- Ralph husbandman 587486 587486 H-, Ralph, of Hakeney, husbandman 1
5024989 2364208 2364208 defendant Porter John husbandman 587486 587486 Porter, John, of Hakeney, husbandman 0
5026292 2364578 2364578 defendant Smyth John husbandman 587486 587486 Smyth, John, of Hakeney, husbandman 3
5032643 2366432 2366432 defendant May John lanorer 587486 587486 May, John, of Hakeney, lanorer 0
5037700 2367898 2367898 defendant Fyssher Richard husbandman 587486 587486 Fyssher, Richard, of Hakeney, husbandman 2
5052397 2372316 2372316 defendant Austyn William husbandman 587486 587486 Austyn, William, of Hakeney, husbandman 0
5052398 2372316 2372316 defendant Ruddok Thomas husbandman 587486 587486 Ruddok, Thomas, of Hakeney, husbandman 1
5054066 2372808 2372808 defendant Wygen John yeoman 587486 587486 Wygen, John, of Hakeney, yeoman 1
5054067 2372808 2372808 defendant Janyver William butcher 587486 587486 Janyver, William, of Hakeney, butcher 2
5059467 2374400 2374400 defendant Smallage John husbandman 587486 587486 Smallage, John, of Hakeney, husbandman 0
5060204 2374624 2374624 defendant Porter John husbandman 587486 587486 Porter, John, of Hakeney, husbandman 2
5060205 2374624 2374624 defendant Man John yeoman 587486 587486 Man, John, of Hakeney, yeoman 3
5070352 2377626 2377626 defendant Man John husbandman 587486 587486 Man, John, of Hakeney, husbandman 0
5074303 2378810 2378810 defendant Messanger Richard husbandman 587486 587486 Messanger, Richard, of Hakeney, husbandman 0
5074304 2378810 2378810 defendant Colman Thomas hackneyman 587486 587486 Colman, Thomas, of Hakeney, hackneyman 1
5074305 2378810 2378810 defendant Ruddok Thomas hackneyman 587486 587486 Ruddok, Thomas, of Hakeney, hackneyman 2
5074306 2378810 2378810 defendant Roger Thomas laborer 587486 587486 Roger, Thomas, of Hakeney, laborer 3
5074307 2378810 2378810 defendant Watson William husbandman 587486 587486 Watson, William, of Hakeney, husbandman 4
5084708 2381940 2381940 defendant Auston Thomas yeoman 587486 587486 (Auston, Thomas, of Hakeney, yeoman 3
5084709 2381940 2381940 defendant Honyburn John   587486 587486 Honyburn, John, of Hakeney, wine drawer 4
5084719 2381941 2381941 defendant Auston Thomas yeoman 587486 587486 (Auston, Thomas, of Hakeney, yeoman 3
5084720 2381941 2381941 defendant Honybury John   587486 587486 Honybury, John, of Hakeney, wine drawer 4
5085182 2382066 2382066 defendant Manne John husbandman 587486 587486 Manne, John, of Hakeney, husbandman 0
5085183 2382066 2382066 defendant Heron Ralph husbandman 587486 587486 Heron, Ralph, of Hakeney, husbandman 1
5085185 2382066 2382066 defendant Baker Thomas husbandman 587486 587486 Baker, Thomas, of Hakeney, husbandman 3
5092769 2384263 2384263 defendant Everard Alice widow 587486 587486 Everard, Alice, of Hakeney, widow 3
5095690 2385161 2385161 defendant Forde Richard (legal representative) 587486 587486 Forde, Richard, of Hakeney, executors of 4
5095692 2385161 2385161 defendant Horspole Bartholomew yeoman 587486 587486 Horspole, Bartholomew, of Hakeney, yeoman 6
5100550 2386586 2386586 defendant Massynger Hugh husbandman 587486 587486 Massynger, Hugh, of Hakeney, husbandman 0
5100551 2386586 2386586 defendant Robynson Henry   587486 587486 Robynson, Henry, of Hakeney 1
5102260 2387080 2387080 defendant Massynger Hugh husbandman 587486 587486 Massynger, Hugh, of Hakeney, husbandman 0
5102261 2387080 2387080 defendant Robynson Henry husbandman 587486 587486 Robynson, Henry, of Hakeney, husbandman 1
5107944 2388764 2388764 plaintiff Elryngon Simon   587486 587486 Elryngon, Simon, of Hakeney 0
5107949 2388765 2388765 plaintiff Elryngton Simon   587486 587486 Elryngton, Simon, of Hakeney 0
5114638 2390696 2390696 defendant Erle Walter hackneyman 587486 587486 Erle, Walter, of Hakeney, hackneyman 0
5122969 2393148 2393148 defendant Heron Ralph laborer 587486 587486 Heron, Ralph, of Hakeney, laborer 3
5135395 2396859 2396859 defendant Erle Walter haberdasher 587486 587486 Erle, Walter, of Hakeney, haberdasher 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);