names

50 rows where place_id = 596513

✎ 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
3625092 1875382 1875382 defendant Comber Thomas yeoman 596513 596513 Comber, Thomas, of Ukkefeld, yeoman 0
3636163 1906099 1906099 defendant Wynter Robert husbandman 596513 596513 Wynter, Robert, of Ukkefeld, husbandman 6
4443473 2182923 2182923 defendant Chaunterell Michael chaplain 596513 596513 Chaunterell, Michael, of Ukkefeld, chaplain 0
4443474 2182923 2182923 defendant Est Richard   596513 596513 Est, Richard, of Ukkefeld 1
4485491 2196169 2196169 plaintiff Bakere Thomas   596513 596513 Bakere, Thomas, of Ukkefeld 2
4638340 2242759 2242759 defendant Huchon Thomas   596513 596513 Huchon, Thomas, of Ukkefeld 0
4654347 2247233 2247233 plaintiff Boche John   596513 596513 Boche, John, of Ukkefeld 0
4654348 2247233 2247233 defendant Chauntour John, junior baker 596513 596513 Chauntour, John, junior, of Ukkefeld, baker 0
4654349 2247233 2247233 defendant Norman John laborer 596513 596513 Norman, John, of Ukkefeld, laborer 1
4654719 2247354 2247354 plaintiff Bothe John   596513 596513 Bothe, John, of Ukkefeld 0
4654720 2247354 2247354 defendant Chauntour John, junior barker 596513 596513 Chauntour, John, junior, of Ukkefeld, barker 0
4654721 2247354 2247354 defendant Norman John laborer 596513 596513 Norman, John, of Ukkefeld, laborer 1
4665501 2250682 2250682 defendant Huchon Thomas gent 596513 596513 Huchon, Thomas, of Ukkefeld, gent 2
4665938 2250823 2250823 defendant Hokeman John smith 596513 596513 Hokeman, John, of Ukkefeld, smith 0
4665940 2250823 2250823 defendant Budde William founder 596513 596513 Budde, William, of Ukkefeld, founder 2
4665942 2250823 2250823 defendant Pocok John tinker 596513 596513 Pocok, John, of Ukkefeld, tinker 4
4666691 2255303 2255303 defendant Chanry Thomas baker 596513 596513 Chanry, Thomas, of Ukkefeld, baker 0
4670559 2256469 2256469 defendant atte Gate William repyer or seller of fish inland 596513 596513 atte Gate, William, of Ukkefeld, repyer or seller of fish inland 0
4670561 2256469 2256469 defendant Mason John tailor 596513 596513 Mason, John, of Ukkefeld, tailor 2
4683103 2260330 2260330 defendant Audeby or Andeby Lawrence butcher 596513 596513 Audeby or Andeby, Lawrence, of Ukkefeld, butcher 1
4781355 2290178 2290178 defendant Poterne John laborer 596513 596513 Poterne, John, of Ukkefeld, laborer 0
4821355 2302762 2302762 defendant Gylderegge Thomas baker 596513 596513 Gylderegge, Thomas, of Ukkefeld, baker 0
4867842 2316914 2316914 defendant Russell Thomas draper 596513 596513 Russell, Thomas, of Ukkefeld, draper 0
4874739 2319041 2319041 defendant Pylcher Regineld glover 596513 596513 Pylcher, Regineld, of Ukkefeld, glover 0
4874740 2319041 2319041 defendant Skynner John tanner 596513 596513 Skynner, John, of Ukkefeld, tanner 1
4874741 2319041 2319041 defendant Smyth John fuller 596513 596513 Smyth, John, of Ukkefeld, fuller 2
4874742 2319041 2319041 defendant Budde James tailor 596513 596513 Budde, James, of Ukkefeld, tailor 3
4879888 2320624 2320624 defendant Mason John tailor 596513 596513 Mason, John, of Ukkefeld, tailor 3
4933551 2336873 2336873 defendant Mamicere William husbandman 596513 596513 Mamicere, William, of Ukkefeld, husbandman 0
4943987 2340085 2340085 defendant Dane Roger yeoman 596513 596513 Dane, Roger, of Ukkefeld, yeoman 0
4951915 2342548 2342548 defendant Dave Roger yeoman 596513 596513 Dave, Roger, of Ukkefeld, yeoman 1
5019003 2362449 2362449 defendant Lucy Richard   596513 596513 Lucy, Richard, of Ukkefeld, groom 2
5019004 2362449 2362449 defendant Pilcher John glover 596513 596513 Pilcher, John, of Ukkefeld, glover 3
5053589 2372674 2372674 defendant Baker Thomas yeoman 596513 596513 Baker, Thomas, of Ukkefeld, yeoman 0
5137773 2397559 2397559 defendant Atherwold John butcher 596513 596513 Atherwold, John, of Ukkefeld, butcher 1
5157986 2403460 2403460 defendant Atherwold John butcher 596513 596513 Atherwold, John, of Ukkefeld, butcher 1
5227854 2423761 2423761 defendant Hochon John husbandman 596513 596513 Hochon, John, of Ukkefeld, husbandman 0
5249474 2429957 2429957 defendant Hochon John husbandman 596513 596513 Hochon, John, of Ukkefeld, husbandman 0
5284229 2440407 2440407 defendant A Downe John butcher 596513 596513 A Downe, John, of Ukkefeld, butcher 0
5312289 2448712 2448712 defendant Warnet John gent 596513 596513 Warnet, John, of Ukkefeld, gent 0
5405282 2476596 2476596 defendant Smyth Andrew smith 596513 596513 Smyth, Andrew, of Ukkefeld, smith 2
5418357 2480416 2480416 defendant Smyth Andrew   596513 596513 Smyth, Andrew, of Ukkefeld 2
5436317 2485796 2485796 defendant Smyth Andrew smith 596513 596513 Smyth, Andrew, of Ukkefeld, smith 2
5436322 2485797 2485797 defendant Smyth Andrew smith 596513 596513 Smyth, Andrew, of Ukkefeld, smith 2
5502094 2505576 2505576 defendant Swayneslond John, junior (legal representative) 596513 596513 Swayneslond, John, junior, of Ukkefeld, hosier, executors of 0
5507114 2507134 2507134 defendant Coyfe Richard weaver 596513 596513 Coyfe, Richard, of Ukkefeld, weaver 0
5507116 2507134 2507134 defendant Broke Thomas laborer 596513 596513 Broke, Thomas, of Ukkefeld, laborer 2
5507117 2507134 2507134 defendant Kyng Thomas laborer 596513 596513 Kyng, Thomas, of Ukkefeld, laborer 3
5610168 2546892 2546892 plaintiff atte Leye Richard   596513 596513 atte Leye, Richard, of Ukkefeld 0
5610169 2546892 2546892 defendant Bocher John   596513 596513 Bocher, John, of Ukkefeld 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);