names

19 rows where case_id = 2474493

✎ 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
5397959 2474493 2474493 plaintiff Chester Richard     Chester, Richard 0
5397960 2474493 2474493 plaintiff Cole Thomas     Cole, Thomas 1
5397961 2474493 2474493 plaintiff Ryver John     Ryver, John 2
5397962 2474493 2474493 plaintiff Draper John     Draper, John 3
5397963 2474493 2474493 plaintiff Martyn William     Martyn, William 4
5397964 2474493 2474493 plaintiff Barl-- Nicholas     Barl--, Nicholas 5
5397965 2474493 2474493 plaintiff Sate--- Walter     Sate---, Walter 6
5397966 2474493 2474493 plaintiff Passemer John     Passemer, John 7
5397967 2474493 2474493 plaintiff Bernard Thomas     Bernard, Thomas 8
5397968 2474493 2474493 plaintiff Hichecok William     Hichecok, William 9
5397969 2474493 2474493 plaintiff Swanne Richard     Swanne, Richard 10
5397970 2474493 2474493 plaintiff Cok John Caston, Oliver   Cok, John, Caston, Oliver 11
5397971 2474493 2474493 plaintiff Bourne Thomas     Bourne, Thomas 12
5397972 2474493 2474493 plaintiff Danyell Oliver     Danyell, Oliver 13
5397973 2474493 2474493 plaintiff Grynsted George     Grynsted, George 14
5397974 2474493 2474493 plaintiff Seman Richard     Seman, Richard 15
5397975 2474493 2474493 plaintiff Strauntoft Richard     Strauntoft, Richard 16
5397976 2474493 2474493 defendant Garnet Rciahrd esq 613361 613361 Garnet, Rciahrd, of Lambehith, esq 0
5397977 2474493 2474493 defendant D--- Henry tailor 609509 609509 D---, Henry, of Longon, 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);