names

19 rows where case_id = 1931918

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3717958 1931918 1931918 plaintiff Fairfax William esq   Fairfax, William, esq 0
3717959 1931918 1931918 defendant Creswell Robert gent 598666 598666 Creswell, Robert, of Newcastle, gent 0
3717960 1931918 1931918 defendant Bramsby William yeoman 617138 617138 Bramsby, William, of Esyngwalde, yeoman 1
3717961 1931918 1931918 defendant Barteram Edward     Barteram, Edward 2
3717962 1931918 1931918 defendant Bartley William     Bartley, William 3
3717963 1931918 1931918 defendant Taillour Edmund     Taillour, Edmund 4
3717964 1931918 1931918 defendant Taillour John     Taillour, John 5
3717965 1931918 1931918 defendant Smyth William     Smyth, William 6
3717966 1931918 1931918 defendant Hennyng John     Hennyng, John 7
3717967 1931918 1931918 defendant Lawson James     Lawson, James 8
3717968 1931918 1931918 defendant Chadforth John     Chadforth, John 9
3717969 1931918 1931918 defendant Kighley John     Kighley, John 10
3717970 1931918 1931918 defendant Wardyll William     Wardyll, William 11
3717971 1931918 1931918 defendant Hall Adam     Hall, Adam 12
3717972 1931918 1931918 defendant Anderson Thomas     Anderson, Thomas 13
3717973 1931918 1931918 defendant Boland Thomas     Boland, Thomas 14
3717974 1931918 1931918 defendant Coke John     Coke, John 15
3717975 1931918 1931918 defendant Scott Richard     Scott, Richard 16
3717976 1931918 1931918 defendant Lauson William     Lauson, William 17

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