names

16 rows where case_id = 2334026

✎ 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
4924242 2334026 2334026 plaintiff Neville Richard   759252 759252 Neville, Richard, of Salisbury, Earl 0
4924243 2334026 2334026 defendant Geldhird Thomas husbandman 591850 591850 Geldhird, Thomas, of Bradley, husbandman 0
4924244 2334026 2334026 defendant Brathwayt William husbandman 591850 591850 Brathwayt, William, of Bradley, husbandman 1
4924245 2334026 2334026 defendant Horner Thomas husbandman 822814 822814 Horner, Thomas, of Westhous in Niderdale, husbandman 2
4924246 2334026 2334026 defendant Holden Richard husbandman 822815 822815 Holden, Richard, of Angerom, in Niderdale, husbandman 3
4924247 2334026 2334026 defendant Frere William husbandman 586312 586312 Frere, William, of Walden, husbandman 4
4924248 2334026 2334026 defendant del Loge Amery widow 591850 591850 del Loge, Amery, of Bradley, widow 5
4924249 2334026 2334026 defendant Spence John yeoman 822816 822816 Spence, John, of Keldheved in Coverdale, son of Richard Spence, yeoman 6
4924250 2334026 2334026 defendant Spence Matilda     Matilda, his wife 7
4924251 2334026 2334026 defendant del Loge Richard husbandman 591850 591850 del Loge, Richard, of Bradley, husbandman 8
4924252 2334026 2334026 defendant Frere Henry husbandman 586312 586312 Frere, Henry, of Walden, husbandman 9
4924253 2334026 2334026 defendant Baythyrd John   822817 822817 Baythyrd, John, of East Wytton, husbandamn 10
4924254 2334026 2334026 defendant Bayne John del Lege, in Niderdale, husbandman   Bayne, John, del Lege, in Niderdale, husbandman 11
4924255 2334026 2334026 defendant Marton Thomas husbandman 690962 690962 Marton, Thomas, of Markyngton, husbandman 12
4924256 2334026 2334026 defendant Wilson Geoffrey husbandman 586312 586312 with Wilson, Geoffrey, of Walden, husbandman 13
4924257 2334026 2334026 defendant Golthwayt Thomas husbandman 654068 654068 Golthwayt, Thomas, of East Wytton, husbandman 14

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