names

13 rows where case_id = 2376516

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5066525 2376516 2376516 plaintiff (not given) Robert prior of Mountagu Priory   Mountagu Priory, Robert, prior of 0
5066526 2376516 2376516 defendant Tomas Robert husbandman 635463 635463 Tomas, Robert, of Holcombe Rogus, husbandman 0
5066527 2376516 2376516 defendant Rounsy John husbandman 635463 635463 Rounsy, John, of Holcombe Rogus, husbandman 1
5066528 2376516 2376516 defendant Leche Robert husbandman 635463 635463 Leche, Robert, of Holcombe Rogus, husbandman 2
5066529 2376516 2376516 defendant Lome William husbandman 635463 635463 Lome, William, of Holcombe Rogus, husbandman 3
5066530 2376516 2376516 defendant Thomas Nicholas husbandman 635463 635463 Thomas, Nicholas, of Holcombe Rogus, husbandman 4
5066531 2376516 2376516 defendant Smert Richard husbandman 635463 635463 Smert, Richard, of Holcombe Rogus, husbandman 5
5066532 2376516 2376516 defendant Merwode Geoffrey husbandman 635463 635463 Merwode, Geoffrey, of Holcombe Rogus, husbandman 6
5066533 2376516 2376516 defendant Wynterbourne John husbandman 635463 635463 Wynterbourne, John, of Holcombe Rogus, husbandman 7
5066534 2376516 2376516 defendant Cokke Thomas husbandman 635463 635463 Cokke, Thomas, of Holcombe Rogus, husbandman 8
5066535 2376516 2376516 defendant Smert Robert husbandman 635463 635463 Smert, Robert, of Holcombe Rogus, husbandman 9
5066536 2376516 2376516 defendant Bole Nicholas husbandman 635463 635463 Bole, Nicholas, of Holcombe Rogus, husbandman 10
5066537 2376516 2376516 defendant Fysshe John hooper 635463 635463 Fysshe, John, of Holcombe Rogus, hooper 11

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