names

104 rows where place_id = 591887

✎ 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
3605890 1869506 1869506 defendant Barsham John husbandman 591887 591887 Barsham, John, of Hokham, husbandman 4
3605899 1869508 1869508 defendant Barsham John yeoman 591887 591887 Barsham, John, of Hokham, yeoman 2
3637974 1906697 1906697 defendant Symondys Richard   591887 591887 Symondys, Richard, of Hokham, wheelwright 0
3638054 1906721 1906721 plaintiff Gryggys Avery   591887 591887 (Gryggys, Avery, of Hokham 1
3638056 1906721 1906721 defendant Purdy John (legal representative) 591887 591887 Purdy, John, of Hokham, wax chandler, executors of 0
3674654 1918123 1918123 defendant Inkelowe John husbandman 591887 591887 Inkelowe, John, of Hokham, husbandman 1
3693344 1924132 1924132 defendant Bassoun Thomas husbandman 591887 591887 Bassoun, Thomas, of Hokham, husbandman 0
3707544 1928653 1928653 defendant Bassom Thomas husbandman 591887 591887 Bassom, Thomas, of Hokham, husbandman 0
3707546 1928654 1928654 defendant Bassom Thomas husbandman 591887 591887 Bassom, Thomas, of Hokham, husbandman 0
3739379 1938523 1938523 defendant Belle Thomas husbandman 591887 591887 Belle, Thomas, of Hokham, husbandman 1
3814971 1962602 1962602 defendant Kelyng William smith 591887 591887 Kelyng, William, of Hokham, smith 0
3829080 1966976 1966976 defendant Bealys Thomas husbandman 591887 591887 Bealys, Thomas, of Hokham, husbandman 0
3830890 1967543 1967543 defendant Kelyng William smith 591887 591887 Kelyng, William, of Hokham, smith 2
3834356 1968689 1968689 defendant Stone Thomas yeoman 591887 591887 Stone, Thomas, of Hokham, yeoman 0
3834358 1968689 1968689 defendant Spycer Thomas warrener 591887 591887 Spycer, Thomas, of Hokham, warrener 2
3842456 1971178 1971178 defendant Bele alias Beales Thomes husbandman 591887 591887 Bele alias Beales, Thomes, of Hokham, husbandman 0
3842745 1971263 1971263 defendant Norres Osbert husbandman 591887 591887 Norres, Osbert, of Hokham, husbandman 2
3842978 1971338 1971338 defendant Newgate Robert husbandman 591887 591887 Newgate, Robert, of Hokham, husbandman 1
3842979 1971338 1971338 defendant Newgate Nicholas laborer 591887 591887 Newgate, Nicholas, of Hokham, laborer 2
3842980 1971338 1971338 defendant Pampe Thomas husbandman 591887 591887 Pampe, Thomas, of Hokham, husbandman 3
3843498 1971503 1971503 defendant Galle Thomas butcher 591887 591887 Galle, Thomas, of Hokham, butcher 1
3845045 1972005 1972005 defendant Norres Osbert husbandman 591887 591887 Norres, Osbert, of Hokham, husbandman 1
3850589 1973771 1973771 defendant Bele John husbandman 591887 591887 Bele, John, of Hokham, husbandman 3
3857000 1975822 1975822 defendant Walter Stephen husbandman 591887 591887 Walter, Stephen, of Hokham, husbandman 3
3859094 1976531 1976531 defendant Fen Thomas husbandman 591887 591887 Fen, Thomas, of Hokham, husbandman 0
3862079 1977504 1977504 defendant Stone Thomas yeoman 591887 591887 Stone, Thomas, of Hokham, yeoman 0
3875819 1982166 1982166 defendant Bele Thomas yeoman 591887 591887 Bele, Thomas, of Hokham, yeoman 0
4474623 2192725 2192725 defendant Sayene alias Sayne Richard   591887 591887 Sayene alias Sayne, Richard, of Hokham 0
4475558 2193041 2193041 defendant Fraunceys John   591887 591887 Fraunceys, John, of Hokham 0
4555524 2217659 2217659 defendant Smyth John   591887 591887 Smyth, John, of Hokham, administrators of 0
4555525 2217659 2217659 defendant Bele Richard   591887 591887 (Bele, Richard, of Hokham 1
4555527 2217659 2217659 defendant Busshell John   591887 591887 Busshell, John, of Hokham 3
4555528 2217659 2217659 defendant Busshell Robert   591887 591887 Busshell, Robert, of Hokham 4
4555529 2217659 2217659 defendant Busshell William   591887 591887 Busshell, William, of Hokham 5
4571508 2222667 2222667 defendant Bilneye Robert   591887 591887 Bilneye, Robert, of Hokham 2
4583788 2226346 2226346 defendant Sokyrman Robert   591887 591887 Sokyrman, Robert, of Hokham 0
4583789 2226347 2226347 plaintiff Fyssh William   591887 591887 Fyssh, William, of Hokham 0
4597355 2230414 2230414 defendant Calwere John   591887 591887 Calwere, John, of Hokham 1
4600102 2231257 2231257 defendant Fulsflone or Fuloflove John   591887 591887 Fulsflone or Fuloflove, John, of Hokham 0
4610310 2234308 2234308 defendant Pipere John   591887 591887 Pipere, John, of Hokham 1
4610311 2234308 2234308 defendant Harpere Thomas   591887 591887 Harpere, Thomas, of Hokham 2
4611600 2234693 2234693 defendant Denyel John   591887 591887 Denyel, John, of Hokham 0
4615809 2235939 2235939 defendant Pipere John   591887 591887 Pipere, John, of Hokham 1
4625832 2239031 2239031 defendant Brekhill Robert woolman 591887 591887 Brekhill, Robert, of Hokham, woolman 1
4629144 2240044 2240044 plaintiff Smyth Agnes   591887 591887 Smyth, Agnes, of Hokham 0
4653916 2247135 2247135 defendant Fysshe William cordwainer 591887 591887 Fysshe, William, of Hokham, cordwainer 0
4655583 2247635 2247635 defendant Fyssh William cordwainer 591887 591887 Fyssh, William, of Hokham, cordwainer 5
4656479 2247923 2247923 defendant Fysshe William yeoman 591887 591887 Fysshe, William, of Hokham, yeoman 2
4658740 2248608 2248608 plaintiff Rykedon Thomas   591887 591887 Rykedon, Thomas, of Hokham 2
4663834 2250172 2250172 defendant Hokham Richard gent 591887 591887 (Hokham, Richard, of Hokham, gent 1
4685163 2260961 2260961 defendant Brighill Robert woolman 591887 591887 Brighill, Robert, of Hokham, woolman 0
4689789 2262367 2262367 defendant Fysshe William husbandman 591887 591887 Fysshe, William, of Hokham, husbandman 0
4692390 2263136 2263136 defendant Haliwell William yeoman 591887 591887 Haliwell, William, of Hokham, yeoman 0
4731952 2275171 2275171 defendant Skepper Thomas laborer 591887 591887 Skepper, Thomas, of Hokham, laborer 9
4731954 2275171 2275171 defendant Doweshed John husbandman 591887 591887 Doweshed, John, of Hokham, husbandman 11
4731955 2275171 2275171 defendant Harpour Thomas   591887 591887 Harpour, Thomas, of Hokham, minstrel 12
4735965 2276396 2276396 defendant Rykedon Thomas yeoman 591887 591887 Rykedon, Thomas, of Hokham, yeoman 0
4735971 2276397 2276397 defendant Rykedon Thomas yeoman 591887 591887 Rykedon, Thomas, of Hokham, yeoman 0
4761809 2284038 2284038 defendant Hokham Peter gent 591887 591887 Hokham, Peter, of Hokham, gent 0
4766447 2285497 2285497 defendant Busshell John   591887 591887 Busshell, John, of Hokham, wool man 3
4786283 2291753 2291753 defendant Fysshe William cordwainer 591887 591887 Fysshe, William, of Hokham, cordwainer 1
4809335 2299095 2299095 defendant Pypere John yeoman 591887 591887 Pypere, John, of Hokham, yeoman 1
4976587 2349957 2349957 defendant Grubbe John husbandman 591887 591887 Grubbe, John, of Hokham, husbandman 3
4987627 2353261 2353261 defendant Crubbe John husbandman 591887 591887 Crubbe, John, of Hokham, husbandman 2
5015087 2361296 2361296 defendant Hokham Peter   591887 591887 Hokham, Peter, of Hokham, gent, administrators of 0
5026842 2364718 2364718 defendant Rykdon Thomas   591887 591887 (Rykdon, Thomas, of Hokham, franklin 1
5032700 2366448 2366448 defendant Barsham John smith 591887 591887 Barsham, John, of Hokham, smith 1
5035337 2367193 2367193 defendant Fraunceys John husbandman 591887 591887 Fraunceys, John, of Hokham, husbandman 0
5060344 2374669 2374669 defendant Fullolove Robert butcher 591887 591887 Fullolove, Robert, of Hokham, butcher 0
5060345 2374669 2374669 defendant Farthyng Thomas laborer 591887 591887 Farthyng, Thomas, of Hokham, laborer 1
5071362 2377929 2377929 defendant Mannyng Thomas yeoman 591887 591887 Mannyng, Thomas, of Hokham, yeoman 0
5071363 2377929 2377929 defendant Fraunces William yeoman 591887 591887 Fraunces, William, of Hokham, yeoman 1
5071369 2377930 2377930 defendant Mannyng Thomas yeoman 591887 591887 Mannyng, Thomas, of Hokham, yeoman 0
5071370 2377930 2377930 defendant Fraunces William yeoman 591887 591887 Fraunces, William, of Hokham, yeoman 1
5084017 2381722 2381722 plaintiff Fraunceys William   591887 591887 Fraunceys, William, of Hokham 0
5111473 2389749 2389749 defendant Fraunceys William, junior husbandman 591887 591887 Fraunceys, William, junior, of Hokham, husbandman 4
5111474 2389749 2389749 defendant Grubbe John husbandman 591887 591887 Grubbe, John, of Hokham, husbandman 5
5136166 2397090 2397090 plaintiff Fraunceys William   591887 591887 Fraunceys, William, of Hokham 1
5172674 2407735 2407735 plaintiff Fraunceys William   591887 591887 Fraunceys, William, of Hokham 1
5179460 2409727 2409727 defendant Debeney Robert husbandman 591887 591887 Debeney, Robert, of Hokham, husbandman 1
5179463 2409728 2409728 defendant Dekeney Robert husbandman 591887 591887 Dekeney, Robert, of Hokham, husbandman 1
5258305 2432716 2432716 defendant Coo Robert yeoman 591887 591887 Coo, Robert, of Hokham, yeoman 1
5261210 2433620 2433620 plaintiff Mannyng Thomas   591887 591887 Mannyng, Thomas, of Hokham 0
5261214 2433621 2433621 plaintiff Mannyng Thomas raffman 591887 591887 Mannyng, Thomas, of Hokham, raffman 0
5289042 2441805 2441805 plaintiff Mannyg Thomas   591887 591887 Mannyg, Thomas, of Hokham 0
5306052 2446798 2446798 plaintiff Mannyng Thomas   591887 591887 Mannyng, Thomas, of Hokham 0
5329091 2453781 2453781 defendant Mere Edmund husbandman 591887 591887 Mere, Edmund, of Hokham, husbandman 2
5329092 2453781 2453781 defendant Blake Robert husbandman 591887 591887 Blake, Robert, of Hokham, husbandman 3
5336511 2455991 2455991 defendant Shymplyng William shoemaker 591887 591887 Shymplyng, William, of Hokham, shoemaker 0
5339072 2456795 2456795 plaintiff Mannyng Thomas   591887 591887 Mannyng, Thomas, of Hokham 0
5347359 2459335 2459335 defendant Then William husbandman 591887 591887 Then, William, of Hokham, husbandman 0
5370595 2466390 2466390 defendant Palreyman Robert butcher 591887 591887 Palreyman, Robert, of Hokham, butcher 3
5373151 2467199 2467199 plaintiff Mannyng Thomas   591887 591887 Mannyng, Thomas, of Hokham 0
5437083 2486029 2486029 defendant Fraunceys William husbandman 591887 591887 Fraunceys, William, of Hokham, husbandman 0
5451272 2490257 2490257 defendant Andrew John husbandman 591887 591887 Andrew, John, of Hokham, husbandman 0
5555336 2521564 2521564 defendant Crume Robert chaplain 591887 591887 Crume, Robert, of Hokham, chaplain 0
5568067 2525210 2525210 defendant Knave William husbandman 591887 591887 Knave, William, of Hokham, husbandman 1
5568070 2525211 2525211 defendant Knave William husbandman 591887 591887 Knave, William, of Hokham, husbandman 1
5601082 2535224 2535224 defendant Purdye John husbandman 591887 591887 Purdye, John, of Hokham, husbandman 3
5603079 2535847 2535847 defendant Purdy John yeoman 591887 591887 Purdy, John, of Hokham, yeoman 2

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