names

17 rows where case_id = 2234196

✎ 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
4609912 2234196 2234196 plaintiff Bygod John knight   Bygod, John, knight 0
4609913 2234196 2234196 defendant Sprot John   759352 759352 Sprot, John, of Thorp Basset 0
4609914 2234196 2234196 defendant Fyn Clement   759352 759352 Fyn, Clement, of Thorp Basset 1
4609915 2234196 2234196 defendant Taillour Richard   759352 759352 Taillour, Richard, of Thorp Basset 2
4609916 2234196 2234196 defendant Baille William   759352 759352 Baille, William, of Thorp Basset 3
4609917 2234196 2234196 defendant Blakman Thomas     Blakman, Thomas 4
4609918 2234196 2234196 defendant Blakman John     Blakman, John 5
4609919 2234196 2234196 defendant Pykeryng William   759352 759352 Pykeryng, William, of Thorp Basset 6
4609920 2234196 2234196 defendant Redenesse Richard   774260 774260 Redenesse, Richard, of Sketkilthorp 7
4609921 2234196 2234196 defendant Beleby John     Beleby, John 8
4609922 2234196 2234196 defendant Davy of Norton     Davy, of Norton 9
4609923 2234196 2234196 defendant Garbot Thomas     Garbot, Thomas 10
4609924 2234196 2234196 defendant Bolum Wiliam     Bolum, Wiliam 11
4609925 2234196 2234196 defendant Cruke Robert     Cruke, Robert 12
4609926 2234196 2234196 defendant Clerk John, sen     Clerk, John, sen 13
4609927 2234196 2234196 defendant Beleby Wiliam     Beleby, Wiliam 14
4609928 2234196 2234196 defendant Curt Thomas     Curt, Thomas 15

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