names

12 rows where case_id = 1920021

✎ 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
3680621 1920021 1920021 plaintiff Rowe John sergeant at law   Rowe, John, sergeant at law 0
3680622 1920021 1920021 plaintiff Willoughby Nicholas     Willoughby, Nicholas 1
3680623 1920021 1920021 plaintiff Langdon Robert     Langdon, Robert 2
3680624 1920021 1920021 plaintiff Beket Gilbert     Beket, Gilbert 3
3680625 1920021 1920021 plaintiff Menwenyk John   606006 606006 Menwenyk, John, of St German 4
3680626 1920021 1920021 plaintiff Tremayn Richard     Tremayn, Richard 5
3680627 1920021 1920021 plaintiff Menwenyk John   609841 609841 Menwenyk, John, of Menwenyk 6
3680628 1920021 1920021 plaintiff Webbe Thomas     Webbe, Thomas 7
3680629 1920021 1920021 plaintiff Gydde William, junior   590233 590233 Gydde, William, junior, of South Pederwyn 8
3680630 1920021 1920021 plaintiff Harrys John   609842 609842 Harrys, John, of Lanrest 9
3680631 1920021 1920021 defendant Lenne William   587287 587287 Lenne, William, of Launceston 0
3680632 1920021 1920021 defendant Wymond Robert     Wymond, Robert 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);