names

14 rows where case_id = 2438999

✎ 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
5279124 2438999 2438999 plaintiff Bourchier Thomas Archbishop of Canterbury   Bourchier, Thomas, Archbishop of Canterbury 0
5279125 2438999 2438999 defendant Herte John yeoman 592778 592778 Herte, John, of Penshurst, Kent, yeoman 0
5279126 2438999 2438999 defendant Cheseman Nicholas   588882 588882 Cheseman, Nicholas, of Retherfeld, "syvyer" 1
5279127 2438999 2438999 defendant Saxpayce Thomas husbandman 867945 867945 Saxpayce, Thomas, of Speldhurst, Kent, husbandman 2
5279128 2438999 2438999 defendant Saxpayce Richard husbandman 598873 598873 Saxpayce, Richard, of Wythyham, husbandman 3
5279129 2438999 2438999 defendant Staple John, junior husbandman 588882 588882 Staple, John, junior, of Retherfeld, husbandman 4
5279130 2438999 2438999 defendant Cheseman John yeoman 588882 588882 Cheseman, John, of Retherfeld, yeoman 5
5279131 2438999 2438999 defendant Kynge John   588882 588882 Kynge, John, of Retherfeld, holy water clerk 6
5279132 2438999 2438999 defendant Maynard John, senior husbandman 598873 598873 Maynard, John, senior, of Wythyham, husbandman 7
5279133 2438999 2438999 defendant Catell Nicholas miller 588882 588882 Catell, Nicholas, of Retherfeld, miller 8
5279134 2438999 2438999 defendant Donne or Doune John   588882 588882 Donne or Doune, John, of Retherfeld, "syvyer" 9
5279135 2438999 2438999 defendant Kente Thomas laborer 588882 588882 Kente, Thomas, of Retherfeld, laborer 10
5279136 2438999 2438999 defendant Kente John laborer 588882 588882 Kente, John, of Retherfeld, laborer 11
5279137 2438999 2438999 defendant Grubbe Richard yeoman 598873 598873 Grubbe, Richard, of Wythyham, yeoman 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);