names

14 rows where case_id = 2365196

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5028448 2365196 2365196 plaintiff Morley Nicholas esq   Morley, Nicholas, esq 0
5028449 2365196 2365196 defendant Joskyn John gent 586425 586425 Joskyn, John, of Braughyng, gent 0
5028450 2365196 2365196 defendant Elveden or Elneden Henry esq 586425 586425 Elveden or Elneden, Henry, of Braughyng, esq 1
5028451 2365196 2365196 defendant Warman John yeoman 596776 596776 Warman, John, of Pokeryche, yeoman 2
5028452 2365196 2365196 defendant Isak John husbandman 586425 586425 Isak, John, of Braughyng, husbandman 3
5028453 2365196 2365196 defendant Pepurcorn John husbandman 590001 590001 Pepurcorn, John, of Aldebury, husbandman 4
5028454 2365196 2365196 defendant Trewth John husbandman 590001 590001 Trewth, John, of Aldebury, husbandman 5
5028455 2365196 2365196 defendant Warner John husbandman 640982 640982 Warner, John, of Parva Hadham, husbandman 6
5028456 2365196 2365196 defendant Lokyer William husbandman 640982 640982 Lokyer, William, of Parva Hadham, husbandman 7
5028457 2365196 2365196 defendant Hunt Robert husbandman 640982 640982 Hunt, Robert, of Parva Hadham, husbandman 8
5028458 2365196 2365196 defendant Snowe William maltman 586425 586425 Snowe, William, of Braughyng, maltman 9
5028459 2365196 2365196 defendant Cherchesey Richard miller 586425 586425 Cherchesey, Richard, of Braughyng, miller 10
5028460 2365196 2365196 defendant Shyngey William husbandman 586425 586425 Shyngey, William, of Braughyng, husbandman 11
5028461 2365196 2365196 defendant Hampton William husbandman 586425 586425 Hampton, William, of Braughyng, husbandman 12

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