names

62 rows where place_id = 596034

✎ 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
3622830 1874672 1874672 plaintiff Robert John   596034 596034 Robert, John, of Haukherst 0
3643473 1908384 1908384 defendant Fystynden Simon husbandman 596034 596034 Fystynden, Simon, of Haukherst, husbandman 4
3664842 1914950 1914950 defendant Pende Thomas husbandman 596034 596034 Pende, Thomas, of Haukherst, husbandman 1
3664843 1914950 1914950 defendant Smyth Robert carpenter 596034 596034 Smyth, Robert, of Haukherst, carpenter 2
3692524 1923848 1923848 defendant Badcok John yeoman 596034 596034 Badcok, John, of Haukherst, yeoman 0
3692525 1923848 1923848 defendant Frystynden Stephen husbandman 596034 596034 Frystynden, Stephen, of Haukherst, husbandman 1
3707902 1928767 1928767 defendant Baker George husbandman 596034 596034 Baker, George, of Haukherst, husbandman 4
3818066 1963564 1963564 plaintiff Lucas Thomas   596034 596034 Lucas, Thomas, of Haukherst 0
3843629 1971541 1971541 defendant Wever Edmund tanner 596034 596034 Wever, Edmund, of Haukherst, tanner 0
4493027 2198517 2198517 plaintiff ate Melle John   596034 596034 ate Melle, John, of Haukherst 0
4520308 2206696 2206696 defendant Hokeregge John   596034 596034 Hokeregge, John, of Haukherst 0
4559912 2219055 2219055 defendant Boiman Simon   596034 596034 Boiman, Simon, of Haukherst 0
4593064 2229139 2229139 defendant Meller John   596034 596034 Meller, John, of Haukherst 0
4623367 2238280 2238280 plaintiff Mellere John   596034 596034 Mellere, John, of Haukherst 0
4637048 2242392 2242392 defendant Herdynden John   596034 596034 Herdynden, John, of Haukherst 4
4653895 2247128 2247128 defendant Elynden Richard husbandman 596034 596034 Elynden, Richard, of Haukherst, husbandman 0
4656078 2247780 2247780 defendant Philpot Thomas draper 596034 596034 Philpot, Thomas, of Haukherst, draper 0
4752498 2281191 2281191 defendant Hamond William husbandman 596034 596034 Hamond, William, of Haukherst, husbandman 1
4752499 2281191 2281191 defendant Sprynget John laborer 596034 596034 Sprynget, John, of Haukherst, laborer 2
4887373 2322887 2322887 plaintiff Watt John   596034 596034 Watt, John, of Haukherst 1
4892851 2324495 2324495 plaintiff Watt John   596034 596034 Watt, John, of Haukherst 1
4906843 2328726 2328726 plaintiff Neweneham William, senior   596034 596034 Neweneham, William, senior, of Haukherst 0
4906844 2328726 2328726 defendant Watte John yeoman 596034 596034 Watte, John, of Haukherst, yeoman 0
4967935 2347353 2347353 defendant Sesele Robert husbandman 596034 596034 Sesele, Robert, of Haukherst, husbandman 0
4983651 2352036 2352036 plaintiff Watte John   596034 596034 Watte, John, of Haukherst 0
5014738 2361182 2361182 defendant Stephene William yeoman 596034 596034 Stephene, William, of Haukherst, yeoman 0
5016545 2361734 2361734 defendant Sharsmyth Richard husbandman 596034 596034 Sharsmyth, Richard, of Haukherst, husbandman 0
5027551 2364936 2364936 defendant Kenot John husbandman 596034 596034 Kenot, John, of Haukherst, husbandman 2
5069582 2377400 2377400 defendant Whatman Bartholomew laborer 596034 596034 Whatman, Bartholomew, of Haukherst, laborer 4
5078753 2380133 2380133 defendant Gildford Richard   596034 596034 Gildford, Richard, of Haukherst, bailiff 5
5086332 2382395 2382395 defendant Congherst William baker 596034 596034 Congherst, William, of Haukherst, baker 0
5102295 2387088 2387088 defendant atte Watere William fuller 596034 596034 atte Watere, William, of Haukherst, fuller 3
5102533 2387143 2387143 defendant Whatman Lawrence husbandman 596034 596034 Whatman, Lawrence, of Haukherst, husbandman 1
5237805 2426641 2426641 defendant Geffrey William   596034 596034 Geffrey, William, of Haukherst, "rypyer" 0
5241882 2427823 2427823 defendant Geffray William   596034 596034 Geffray, William, of Haukherst, "rypyer" 0
5281203 2439578 2439578 defendant Sprenget Denis carpenter 596034 596034 Sprenget, Denis, of Haukherst, carpenter 0
5297458 2444258 2444258 defendant Hovynden Edward   596034 596034 Hovynden, Edward, of Haukherst, cloth maker 1
5325509 2452710 2452710 defendant Walet Lawrence husbandman 596034 596034 Walet, Lawrence, of Haukherst, husbandman 2
5369911 2466179 2466179 defendant Sleman William thatcher 596034 596034 Sleman, William, of Haukherst, thatcher 0
5408736 2477569 2477569 defendant Wevynden John butcher 596034 596034 Wevynden, John, of Haukherst, butcher 0
5421572 2481389 2481389 defendant Alye Richard yeoman 596034 596034 Alye, Richard, of Haukherst, yeoman 0
5438822 2486531 2486531 defendant Sefele Stephen butcher 596034 596034 Sefele, Stephen, of Haukherst, butcher 0
5438823 2486531 2486531 defendant Kene James husbandman 596034 596034 Kene, James, of Haukherst, husbandman 1
5438825 2486532 2486532 defendant Sesele Stephen butcher 596034 596034 Sesele, Stephen, of Haukherst, butcher 0
5438826 2486532 2486532 defendant Kent James husbandman 596034 596034 Kent, James, of Haukherst, husbandman 1
5443730 2488047 2488047 defendant Alye Richard yeoman 596034 596034 Alye, Richard, of Haukherst, yeoman 0
5452708 2490692 2490692 defendant Sesele Stephen butcher 596034 596034 Sesele, Stephen, of Haukherst, butcher 0
5452709 2490692 2490692 defendant (illegible) James husbandman 596034 596034 _, James, of Haukherst, husbandman 1
5453163 2490829 2490829 defendant Wyvynden John husbandman 596034 596034 Wyvynden, John, of Haukherst, husbandman 1
5453164 2490829 2490829 defendant Walet Lawrence husbandman 596034 596034 Walet, Lawrence, of Haukherst, husbandman 2
5464644 2494342 2494342 defendant Sesele Stephen butcher 596034 596034 Sesele, Stephen, of Haukherst, butcher 0
5464645 2494342 2494342 defendant Kent James husbandman 596034 596034 Kent, James, of Haukherst, husbandman 1
5470459 2496084 2496084 defendant Whatman John husbandman 596034 596034 Whatman, John, of Haukherst, husbandman 3
5479233 2498807 2498807 defendant Mercer John, junior   596034 596034 Mercer, John, junior, of Haukherst, "repyer" 0
5479234 2498807 2498807 defendant Fontener John husbandman 596034 596034 Fontener, John, of Haukherst, husbandman 1
5558276 2522371 2522371 defendant Congherst Edmund yeoman 596034 596034 Congherst, Edmund, of Haukherst, yeoman 0
5583851 2530030 2530030 defendant Batcok Richard fuller 596034 596034 Batcok, Richard, of Haukherst, fuller 0
5583852 2530030 2530030 defendant Batcok Joan widow 596034 596034 Batcok, Joan, of Haukherst, widow 1
5583853 2530030 2530030 defendant Alys John   596034 596034 Alys, John, of Haukherst, "wenemaker" 2
5608780 2537647 2537647 defendant Solman William thatcher 596034 596034 Solman, William, of Haukherst, thatcher 0
5608953 2537701 2537701 plaintiff Herpynghope John smith 596034 596034 Herpynghope, John, of Haukherst, smith 0
5627591 2552601 2552601 defendant Bernes William gent 596034 596034 Bernes, William, of Haukherst, gent 2

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