names

15 rows where case_id = 2370195

✎ 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
5045199 2370195 2370195 plaintiff Jud--- John     Jud---, John 0
5045200 2370195 2370195 defendant Park John     Park, John 0
5045201 2370195 2370195 defendant Foster John     Foster, John 1
5045202 2370195 2370195 defendant Tompler Thomas     Tompler, Thomas 2
5045203 2370195 2370195 defendant Sherewod (illegible)     Sherewod, ---- 3
5045204 2370195 2370195 defendant Cook Thomas   586182 586182 Cook, Thomas, of Ardeley 4
5045205 2370195 2370195 defendant Pulter John     Pulter, John 5
5045206 2370195 2370195 defendant Pebs Thomas     Pebs, Thomas 6
5045207 2370195 2370195 defendant Algore John     Algore, John 7
5045208 2370195 2370195 defendant Ryisse Thomas     Ryisse, Thomas 8
5045209 2370195 2370195 defendant Sparowe Robert     Sparowe, Robert 9
5045210 2370195 2370195 defendant Caboche John     Caboche, John 10
5045211 2370195 2370195 defendant Laryot Geoffrey     Laryot, Geoffrey 11
5045212 2370195 2370195 defendant Doreward John, junior esq   Doreward, John, junior, esq 12
5045213 2370195 2370195 defendant Doreward William gent   Doreward, William, gent 13

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