names

41 rows where place_id = 611976

✎ 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
3691020 1923356 1923356 plaintiff Hall Thomas   611976 611976 Hall, Thomas, of Alcestre 0
3691021 1923356 1923356 defendant Wolmer John   611976 611976 Wolmer, John, of Alcestre, "gyldeler" 0
3896426 1989010 1989010 defendant Skynner Ralph yeoman 611976 611976 Skynner, Ralph, of Alcestre, yeoman 0
3974004 2015477 2015477 defendant Orton John husbandman 611976 611976 Orton, John, of Alcestre, husbandman 1
4413479 2169099 2169099 defendant Olebury William de   611976 611976 Olebury, William de, of Alcestre 0
4478364 2193913 2193913 defendant Gragh Hugh   611976 611976 Gragh, Hugh, of Alcestre 1
4481887 2195043 2195043 defendant Deget Hugh   611976 611976 Deget, Hugh, of Alcestre 0
4545031 2214365 2214365 defendant Hicchecokkes John   611976 611976 Hicchecokkes, John, of Alcestre 1
4547090 2215024 2215024 defendant Frekyndon William   611976 611976 Frekyndon, William, of Alcestre 0
4547091 2215024 2215024 defendant Cokeney John   611976 611976 Cokeney, John, of Alcestre 1
4551849 2216525 2216525 defendant Walsheman Mathew laborer 611976 611976 Walsheman, Mathew, of Alcestre, laborer 0
4560934 2219373 2219373 defendant Glover William   611976 611976 Glover, William, of Alcestre 1
4570235 2222262 2222262 defendant atte Wode William   611976 611976 atte Wode, William, of Alcestre 0
4579012 2224917 2224917 plaintiff Colman John   611976 611976 Colman, John, of Alcestre 0
4603073 2232174 2232174 defendant Walker Henry   611976 611976 Walker, Henry, of Alcestre 0
4603075 2232174 2232174 defendant Baker William   611976 611976 Baker, William, of Alcestre 2
4727482 2273838 2273838 defendant Halle Richard shoemaker 611976 611976 Halle, Richard, of Alcestre, shoemaker 0
4777327 2288901 2288901 defendant Tykhyll William fisher 611976 611976 Tykhyll, William, of Alcestre, fisher 0
4859099 2314222 2314222 defendant Leche Nicholas husbandman 611976 611976 Leche, Nicholas, of Alcestre, husbandman 0
4911908 2330228 2330228 defendant Okham William shoemaker 611976 611976 Okham, William, of Alcestre, shoemaker 0
4936700 2337861 2337861 defendant Thurkill John yeoman 611976 611976 Thurkill, John, of Alcestre, yeoman 0
4978983 2350671 2350671 defendant Cokkes John butcher 611976 611976 Cokkes, John, of Alcestre, butcher 0
4987681 2353277 2353277 defendant Illare Richard fishmonger 611976 611976 Illare, Richard, of Alcestre, fishmonger 1
5060476 2374712 2374712 plaintiff Freston John   611976 611976 Freston, John, of Alcestre 0
5228501 2423941 2423941 defendant Panter or Pauter Henry husbandman 611976 611976 Panter or Pauter, Henry, of Alcestre, husbandman 0
5246028 2429003 2429003 defendant Skynner Henry barker 611976 611976 Skynner, Henry, of Alcestre, barker 0
5246029 2429003 2429003 defendant Taylor John tailor 611976 611976 Taylor, John, of Alcestre, tailor 1
5276526 2438210 2438210 defendant Wele John husbandman 611976 611976 Wele, John, of Alcestre, husbandman 0
5276528 2438211 2438211 defendant Whole John husbandman 611976 611976 Whole, John, of Alcestre, husbandman 0
5361619 2463656 2463656 defendant Hyet Hugh baker 611976 611976 Hyet, Hugh, of Alcestre, baker 2
5361620 2463656 2463656 defendant Hulloke John chaplain 611976 611976 Hulloke, John, of Alcestre, chaplain 3
5363697 2464299 2464299 defendant Hyron Richard barker 611976 611976 (Hyron, Richard, of Alcestre, barker 1
5440914 2487195 2487195 defendant Shawe John   611976 611976 Shawe, John, of Alcestre 3
5440921 2487195 2487195 defendant Haselholte William   611976 611976 Haselholte, William, of Alcestre 10
5460439 2493063 2493063 defendant Parton John chapman 611976 611976 Parton, John, of Alcestre, chapman 0
5511620 2508482 2508482 defendant Wrangham Hugh tanner 611976 611976 Wrangham, Hugh, of Alcestre, tanner 0
5515613 2509726 2509726 defendant Wrangham Hugh tanner 611976 611976 Wrangham, Hugh, of Alcestre, tanner 0
5577908 2528163 2528163 defendant Shawe John, junior yeoman 611976 611976 Shawe, John, junior, of Alcestre, yeoman 0
5614687 2548392 2548392 defendant Perkynes Hugh, junior   611976 611976 Perkynes, Hugh, junior, of Alcestre 1
5621331 2550560 2550560 plaintiff Steyner William   611976 611976 Steyner, William, of Alcestre 0
5621332 2550560 2550560 defendant Mors Thomas   611976 611976 Mors, Thomas, of Alcestre 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);