names

15 rows where case_id = 2380372

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5079539 2380372 2380372 plaintiff Carmynowe Joan     Carmynowe, Joan 0
5079540 2380372 2380372 defendant Watte Richard husbandman 835612 835612 Watte, Richard, of Benorth, Cardenan, husbandman 0
5079541 2380372 2380372 defendant Luttecote William husbandman 843926 843926 Luttecote, William, of Treweythek, Cardenan, husbandman 1
5079542 2380372 2380372 defendant Grose William husbandman 843927 843927 Grose, William, of Garbleke, Cardenan, husbandman 2
5079543 2380372 2380372 defendant Penhale Thomas husbandman 843928 843928 Penhale, Thomas, of Atprays, Cardenan, husbandman 3
5079544 2380372 2380372 defendant Nykjelyn Thomas husbandman 843929 843929 Nykjelyn, Thomas, of Cabylye, Cardenan, husbandman 4
5079545 2380372 2380372 defendant Rondell John husbandman 843930 843930 Rondell, John, of Gwayton, Cardenan, husbandman 5
5079546 2380372 2380372 defendant Watte Jams of Olde Cardenan husbandman   Watte, Jams of Olde Cardenan, husbandman 6
5079547 2380372 2380372 defendant Hendy John husbandman 843931 843931 Hendy, John, of Casteleget, husbandman 7
5079548 2380372 2380372 defendant Lokyer William husbandman 843932 843932 Lokyer, William, of Cabylymyll, husbandman 8
5079549 2380372 2380372 defendant Warne Stephen husbandman 843933 843933 Warne, Stephen, of Cabyle, Cardenan, husbandman 9
5079550 2380372 2380372 defendant Tapper Nicholas   843934 843934 Tapper, Nicholas, of Cardenan Myll, millward 10
5079551 2380372 2380372 defendant Gregore William husbandman 843935 843935 Gregore, William, of Kyngeswode, Cardenan, husbandman 11
5079552 2380372 2380372 defendant Gregore John husbandman 843935 843935 Gregore, John, of Kyngeswode, Cardenan, husbandman 12
5079553 2380372 2380372 defendant Hauke or Hanke William husbandman 843936 843936 Hauke or Hanke, William, of Tresole, Cardenan, husbandman 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);