names

78 rows where place_id = 587696

✎ 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
3592169 1865170 1865170 defendant Wygge John carpenter 587696 587696 Wygge, John, of Haukeherst, carpenter 0
3592994 1865434 1865434 defendant Mercer John, senior husbandman 587696 587696 Mercer, John, senior, of Haukeherst, husbandman 0
3592995 1865434 1865434 defendant Mercer George husbandman 587696 587696 Mercer, George, of Haukeherst, husbandman 1
3595445 1866209 1866209 defendant Frensshe Robert husbandman 587696 587696 Frensshe, Robert, of Haukeherst, husbandman 0
3597966 1866988 1866988 defendant Afford John husbandman 587696 587696 Afford, John, of Haukeherst, husbandman 0
3597970 1866989 1866989 defendant Afford John husbandman 587696 587696 Afford, John, of Haukeherst, husbandman 0
3622834 1874672 1874672 defendant Kent George laborer 587696 587696 Kent, George, of Haukeherst, laborer 3
3693904 1924297 1924297 defendant Corkewell Vincent carpenter 587696 587696 Corkewell, Vincent, of Haukeherst, carpenter 2
3726795 1934648 1934648 defendant Seceley Henry (legal representative) 587696 587696 Seceley, Henry, of Haukeherst, yeoman, executors of 3
3726797 1934648 1934648 defendant Seceley John clothier 587696 587696 Seceley, John, of Haukeherst, clothier 5
3815380 1962726 1962726 defendant Morys John chaplain 587696 587696 Morys, John, of Haukeherst, chaplain 0
3815382 1962727 1962727 defendant Morys John chaplain 587696 587696 Morys, John, of Haukeherst, chaplain 0
3815384 1962728 1962728 defendant Morys John chaplain 587696 587696 Morys, John, of Haukeherst, chaplain 0
3822875 1965062 1965062 defendant Morys John chaplain 587696 587696 Morys, John, of Haukeherst, chaplain 0
3849181 1973340 1973340 defendant Bullok Henry husbandman 587696 587696 Bullok, Henry, of Haukeherst, husbandman 2
3862456 1977639 1977639 plaintiff Hamon John yeoman 587696 587696 Hamon, John, of Haukeherst, yeoman 0
3862458 1977639 1977639 defendant Badcok Andrew yeoman 587696 587696 Badcok, Andrew, of Haukeherst, yeoman 1
3862459 1977640 1977640 plaintiff Hamon John yeoman 587696 587696 Hamon, John, of Haukeherst, yeoman 0
3862461 1977640 1977640 defendant Badcok Andrew yeoman 587696 587696 Badcok, Andrew, of Haukeherst, yeoman 1
3869082 1979905 1979905 defendant Hamon John yeoman 587696 587696 Hamon, John, of Haukeherst, yeoman 0
3955276 2008914 2008914 plaintiff Mantell John   587696 587696 Mantell, John, of Haukeherst 0
4559914 2219055 2219055 defendant Godwyne John   587696 587696 Godwyne, John, of Haukeherst 2
4794092 2294285 2294285 defendant Festynden Stephen laborer 587696 587696 Festynden, Stephen, of Haukeherst, laborer 1
4880110 2320689 2320689 defendant Philpot Thomas husbandman 587696 587696 Philpot, Thomas, of Haukeherst, husbandman 0
4894127 2324859 2324859 plaintiff Watte John   587696 587696 Watte, John, of Haukeherst 0
4897440 2325860 2325860 defendant Knok Roger husbandman 587696 587696 Knok, Roger, of Haukeherst, husbandman 0
4909983 2329649 2329649 defendant Sefele Robert husbandman 587696 587696 Sefele, Robert, of Haukeherst, husbandman 0
4936440 2337788 2337788 defendant Sesele Robert husbandman 587696 587696 Sesele, Robert, of Haukeherst, husbandman 0
4942297 2339582 2339582 defendant Sesele Robert yeoman 587696 587696 Sesele, Robert, of Haukeherst, yeoman 0
4960889 2345220 2345220 defendant Sesele Robert husbandman 587696 587696 Sesele, Robert, of Haukeherst, husbandman 0
4983649 2352035 2352035 plaintiff Watte John   587696 587696 Watte, John, of Haukeherst 0
5014532 2361114 2361114 defendant Sesele Robert husbandman 587696 587696 Sesele, Robert, of Haukeherst, husbandman 0
5026051 2364512 2364512 defendant Bernys Robert gent 587696 587696 Bernys, Robert, of Haukeherst, gent 0
5031104 2365971 2365971 defendant Smyth Simon drover 587696 587696 Smyth, Simon, of Haukeherst, drover 0
5118386 2391814 2391814 defendant Jankyn Elisa widow 587696 587696 Jankyn, Elisa, of Haukeherst, widow 1
5118387 2391814 2391814 defendant Baret Simon weaver 587696 587696 Baret, Simon, of Haukeherst, weaver 2
5214916 2420083 2420083 plaintiff Castelman Alice (legal representative) 587696 587696 Castelman, Alice, of Haukeherst, executor of 0
5219423 2421406 2421406 defendant Jurdan William butcher 587696 587696 Jurdan, William, of Haukeherst, butcher 0
5223950 2422688 2422688 defendant Whateman Lawrence weaver 587696 587696 Whateman, Lawrence, of Haukeherst, weaver 0
5233072 2425257 2425257 defendant Froster Henry weaver 587696 587696 Froster, Henry, of Haukeherst, weaver 0
5233073 2425257 2425257 defendant Whatman John husbandman 587696 587696 Whatman, John, of Haukeherst, husbandman 1
5241496 2427711 2427711 defendant Geffray William rippier 587696 587696 Geffray, William, of Haukeherst, rippier 1
5250171 2430165 2430165 defendant Whatman Lawrence weaver 587696 587696 Whatman, Lawrence, of Haukeherst, weaver 0
5250172 2430165 2430165 defendant Whatman John husbandman 587696 587696 Whatman, John, of Haukeherst, husbandman 1
5271130 2436651 2436651 plaintiff Funtyng Robert   587696 587696 Funtyng, Robert, of Haukeherst 0
5311756 2448540 2448540 defendant Jurdan John butcher 587696 587696 Jurdan, John, of Haukeherst, butcher 0
5311757 2448540 2448540 defendant Jurdan William butcher 587696 587696 Jurdan, William, of Haukeherst, butcher 1
5314690 2449428 2449428 defendant Hovynden or Honynden Edward clothmaker 587696 587696 Hovynden or Honynden, Edward, of Haukeherst, clothmaker 0
5343890 2458277 2458277 defendant Fryman William fuller 587696 587696 Fryman, William, of Haukeherst, fuller 2
5354110 2461350 2461350 defendant Lucas Edward mercer 587696 587696 Lucas, Edward, of Haukeherst, mercer 0
5354111 2461350 2461350 defendant Lucas John weaver 587696 587696 Lucas, John, of Haukeherst, weaver 1
5361383 2463580 2463580 defendant Basden Robert husbandman 587696 587696 Basden, Robert, of Haukeherst, husbandman 3
5371241 2466589 2466589 defendant Wenynden or Wevynden John butcher 587696 587696 Wenynden or Wevynden, John, of Haukeherst, butcher 0
5395431 2473768 2473768 defendant Wevynden John butcher 587696 587696 Wevynden, John, of Haukeherst, butcher 0
5398070 2474517 2474517 defendant Dunke John, senior   587696 587696 Dunke, John, senior, of Haukeherst 0
5398071 2474517 2474517 defendant John junior husbandman 587696 587696 John, junior, of Haukeherst, husbandman 1
5398072 2474517 2474517 defendant -evynden John butcher 587696 587696 -evynden, John, of Haukeherst, butcher 2
5421739 2481439 2481439 defendant Wovyndon John butcher 587696 587696 Wovyndon, John, of Haukeherst, butcher 0
5422014 2481521 2481521 defendant Wenynden John butcher 587696 587696 Wenynden, John, of Haukeherst, butcher 0
5422016 2481522 2481522 defendant Wenynden John butcher 587696 587696 Wenynden, John, of Haukeherst, butcher 0
5441584 2487401 2487401 defendant Wenynden John butcher 587696 587696 Wenynden, John, of Haukeherst, butcher 0
5450119 2489924 2489924 plaintiff Pende Nicholas clothmaker 587696 587696 Pende, Nicholas, of Haukeherst, clothmaker 0
5453162 2490829 2490829 defendant Sloweman William husbandman 587696 587696 Sloweman, William, of Haukeherst, husbandman 0
5454371 2491217 2491217 defendant Wevenden John butcher 587696 587696 Wevenden, John, of Haukeherst, butcher 0
5455287 2491499 2491499 defendant Lucas Lawrence husbandman 587696 587696 Lucas, Lawrence, of Haukeherst, husbandman 1
5455288 2491499 2491499 defendant Whatman John husbandman 587696 587696 Whatman, John, of Haukeherst, husbandman 2
5462306 2493627 2493627 plaintiff Pende Nicholas clothmaker 587696 587696 Pende, Nicholas, of Haukeherst, clothmaker 0
5477574 2498308 2498308 defendant Wyvenden John butcher 587696 587696 Wyvenden, John, of Haukeherst, butcher 0
5484045 2500163 2500163 defendant Whytton William (legal representative) 587696 587696 Whytton, William, of Haukeherst, linen weaver, administratrix of 2
5484046 2500163 2500163 defendant Whytton Godelena widow 587696 587696 Whytton, Godelena, of Haukeherst, widow 3
5509349 2507775 2507775 defendant Frensshe John laborer 587696 587696 Frensshe, John, of Haukeherst, laborer 1
5512600 2508794 2508794 defendant Gilderige James carver 587696 587696 Gilderige, James, of Haukeherst, carver 4
5517859 2510427 2510427 defendant Herteknoppe John, senior husbandman 587696 587696 Herteknoppe, John, senior, of Haukeherst, husbandman 0
5531847 2514505 2514505 defendant Sesele John carpenter 587696 587696 Sesele, John, of Haukeherst, carpenter 0
5566579 2524820 2524820 defendant Cutlaff or Cutlass Stephen husbandman 587696 587696 Cutlaff or Cutlass, Stephen, of Haukeherst, husbandman 0
5581494 2529285 2529285 defendant Congherst Edmund yeoman 587696 587696 Congherst, Edmund, of Haukeherst, yeoman 0
5588511 2531412 2531412 defendant Badcok Robert husbandman 587696 587696 Badcok, Robert, of Haukeherst, husbandman 1
5593567 2532970 2532970 defendant Pykkynden Thomas   587696 587696 Pykkynden, Thomas, of Haukeherst, "rypyer" 0

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