names

22 rows where place_id = 630100

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3792443 1955499 1955499 defendant Blokeley Roger tanner 630100 630100 Blokeley, Roger, of Kynvare, Staffs, tanner 0
3792446 1955500 1955500 defendant Blokley Roger tanner 630100 630100 Blokley, Roger, of Kynvare, Staffs, tanner 0
3798261 1957353 1957353 plaintiff Harrys Humphrey chapman 630100 630100 Harrys, Humphrey, of Kynvare, Staffs, chapman 0
3807359 1960207 1960207 defendant Rugge Roger carver 630100 630100 Rugge, Roger, of Kynvare, Staffs, carver 0
3846727 1972533 1972533 defendant Blakley Roger tanner 630100 630100 Blakley, Roger, of Kynvare, Staffs, tanner 0
3858761 1976415 1976415 defendant Rudge Roger carver 630100 630100 Rudge, Roger, of Kynvare, Staffs, carver 0
3890042 1986905 1986905 plaintiff Harres Humphrey (legal representative) 630100 630100 Harres, Humphrey, of Kynvare, Staffs, chapman, executors of 0
3903258 1991314 1991314 defendant Jokys Thomas butcher 630100 630100 Jokys, Thomas, of Kynvare, Staffs, butcher 1
3976775 2016443 2016443 defendant Wenarton Edmund husbandman 630100 630100 Wenarton, Edmund, of Kynvare, Staffs, husbandman 1
4393471 2162417 2162417 defendant Caterall John glover 630100 630100 Caterall, John, of Kynvare, Staffs, glover 1
4394994 2162909 2162909 defendant Brysto or Brysco Robert butcher 630100 630100 Brysto or Brysco, Robert, of Kynvare, Staffs, butcher 0
4396807 2163500 2163500 defendant Bate Thomas yeoman 630100 630100 Bate, Thomas, of Kynvare, Staffs, yeoman 1
5178597 2409455 2409455 defendant Bowelond John chapman 630100 630100 Bowelond, John, of Kynvare or Kinver, Staffs, chapman 0
5194424 2414097 2414097 defendant Bowelond John chapman 630100 630100 Bowelond, John, of Kynvare, Staffs, chapman 0
5194428 2414098 2414098 defendant Bowelond John chapman 630100 630100 Bowelond, John, of Kynvare, Staffs, chapman 0
5201516 2416202 2416202 defendant Bowelond John chapman 630100 630100 Bowelond, John, of Kynvare, Staffs, chapman 0
5274166 2437523 2437523 defendant (illegible) Thomas chapman 630100 630100 ---, Thomas, of Kynvare, Staffs, chapman 3
5275163 2437812 2437812 defendant Smerte Thomas chapman 630100 630100 Smerte, Thomas, of Kynvare, Staffs, chapman 1
5275169 2437813 2437813 defendant Smarte Thomas   630100 630100 Smarte, Thomas, of Kynvare, Staffs 1
5292764 2442880 2442880 defendant Smart Thomas chapman 630100 630100 Smart, Thomas, of Kynvare, Staffs, chapman 2
5329016 2453758 2453758 defendant Fowne Henry mercer 630100 630100 Fowne, Henry, of Kynvare, Staffs, mercer 0
5410266 2478022 2478022 defendant Blokley John, sen yeoman 630100 630100 Blokley, John, sen, of Kynvare, Staffs, yeoman 4

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