names

20 rows where case_id = 2471003

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5385767 2471003 2471003 plaintiff Chester Richard     Chester, Richard 0
5385768 2471003 2471003 plaintiff Cole Thomas     Cole, Thomas 1
5385769 2471003 2471003 plaintiff Ryver John     Ryver, John 2
5385770 2471003 2471003 plaintiff Draper John     Draper, John 3
5385771 2471003 2471003 plaintiff Martyn William     Martyn, William 4
5385772 2471003 2471003 plaintiff Smert Walter     Smert, Walter 5
5385773 2471003 2471003 plaintiff Passemer John     Passemer, John 6
5385774 2471003 2471003 plaintiff Bernard Thomas     Bernard, Thomas 7
5385775 2471003 2471003 plaintiff Hichecok William     Hichecok, William 8
5385776 2471003 2471003 plaintiff Swanne Richard     Swanne, Richard 9
5385777 2471003 2471003 plaintiff Goldherst Thomas     Goldherst, Thomas 10
5385778 2471003 2471003 plaintiff Cok John     Cok, John 11
5385779 2471003 2471003 plaintiff Caston Oliver     Caston, Oliver 12
5385780 2471003 2471003 plaintiff Bourne Thomas     Bourne, Thomas 13
5385781 2471003 2471003 plaintiff Danyell Oliver     Danyell, Oliver 14
5385782 2471003 2471003 plaintiff Grynsted George     Grynsted, George 15
5385783 2471003 2471003 plaintiff Seman Richard     Seman, Richard 16
5385784 2471003 2471003 plaintiff Grantoft Roger     Grantoft, Roger 17
5385785 2471003 2471003 defendant Garnet Richard esq 613361 613361 Garnet, Richard, of Lambehith, esq 0
5385786 2471003 2471003 defendant Dodde Henry tailor 585869 585869 Dodde, Henry, of London, tailor 1

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