names

15 rows where case_id = 2555253

✎ 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
5636121 2555253 2555253 plaintiff Wodehous Simon   809864 809864 Wodehous, Simon, of Chirton 0
5636122 2555253 2555253 defendant Groyn Richard smith 908174 908174 Groyn, Richard, of Fysshelden, smith 0
5636123 2555253 2555253 defendant Hank or Hauk William husbandman 908174 908174 Hank or Hauk, William, of Fysshelden, husbandman 1
5636124 2555253 2555253 defendant Tumber John husbandman 908174 908174 Tumber, John, of Fysshelden, husbandman 2
5636125 2555253 2555253 defendant Pyper John laborer 908174 908174 Pyper, John, of Fysshelden, laborer 3
5636126 2555253 2555253 defendant Newe Richard husbandman 589426 589426 Newe, Richard, of Abyndon, husbandman 4
5636127 2555253 2555253 defendant Lange John husbandman 908175 908175 Lange, John, of Ablyndon, husbandman 5
5636128 2555253 2555253 defendant Newe John husbandman 908175 908175 Newe, John, of Ablyndon, husbandman 6
5636129 2555253 2555253 defendant Skalarn William husbandman 908175 908175 Skalarn, William, of Ablyndon, husbandman 7
5636130 2555253 2555253 defendant Pyper Robert husbandman 908175 908175 Pyper, Robert, of Ablyndon, husbandman 8
5636131 2555253 2555253 defendant Durneford Richard husbandman 908175 908175 Durneford, Richard, of Ablyndon, husbandman 9
5636132 2555253 2555253 defendant Robyn John husbandman 908176 908176 Robyn, John, of Couk, husbandman 10
5636133 2555253 2555253 defendant Segon John husbandman 809864 809864 Segon, John, of Chirton, husbandman 11
5636134 2555253 2555253 defendant Rede John husbandman 590448 590448 Rede, John, of Alton, husbandman 12
5636135 2555253 2555253 defendant Rede John laborer 590448 590448 Rede, John, of Alton, laborer 13

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