names

14 rows where case_id = 2456838

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5339214 2456838 2456838 plaintiff Marlowe John abbot of Bermondsey Abbey   Marlowe, John, abbot of Bermondsey Abbey 0
5339215 2456838 2456838 defendant Sarank or Sarauk John tailor 875182 875182 Sarank or Sarauk, John, of Wedford, tailor 0
5339216 2456838 2456838 defendant Sarank or Sarauk Thomas husbandman 875182 875182 Sarank or Sarauk, Thomas, of Wedford, husbandman 1
5339217 2456838 2456838 defendant Sarank or Sarauk William husbandman 865748 865748 Sarank or Sarauk, William, of Honnesdon, husbandman 2
5339218 2456838 2456838 defendant Sarank or Sarauk John yeoman 875183 875183 Sarank or Sarauk, John, of Barwes, yeoman 3
5339219 2456838 2456838 defendant Sarank or Sarauk William laborer 716968 716968 Sarank or Sarauk, William, of Haddam Magna, laborer 4
5339220 2456838 2456838 defendant Sarank or Sarauk Robert laborer 875182 875182 Sarank or Sarauk, Robert, of Wedford, laborer 5
5339221 2456838 2456838 defendant Sarank or Sarauk John laborer 865748 865748 Sarank or Sarauk, John, of Honnesdon, laborer 6
5339222 2456838 2456838 defendant Sarank or Sarauk Nicholas laborer 586059 586059 Sarank or Sarauk, Nicholas, of Ware, laborer 7
5339223 2456838 2456838 defendant Smyth Milicent widow 716968 716968 Smyth, Milicent, of Haddam Magna, widow 8
5339224 2456838 2456838 defendant at More John husbandman 716968 716968 at More, John, of Haddam Magna, husbandman 9
5339225 2456838 2456838 defendant Clerk John husbandman 589395 589395 Clerk, John, of Stortford, husbandman 10
5339226 2456838 2456838 defendant Hochyn John husbandman 875182 875182 Hochyn, John, of Wedford, husbandman 11
5339227 2456838 2456838 defendant Crosland William husbandman 716968 716968 Crosland, William, of Haddam Magna, 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);