names

19 rows where case_id = 2226073

✎ 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
4582862 2226073 2226073 plaintiff Ferrour Lawrence     Ferrour, Lawrence 0
4582863 2226073 2226073 defendant Wynneman William   771859 771859 Wynneman, William, of Minstreworth 0
4582864 2226073 2226073 defendant Shepescombe William     Shepescombe, William 1
4582865 2226073 2226073 defendant Pavy John     Pavy, John 2
4582866 2226073 2226073 defendant Wodeward Robert   590628 590628 Wodeward, Robert, of Tewkesbury 3
4582867 2226073 2226073 defendant Sperman William     Sperman, William 4
4582868 2226073 2226073 defendant Streynesham Thomas     Streynesham, Thomas 5
4582869 2226073 2226073 defendant Wytteney John     Wytteney, John 6
4582870 2226073 2226073 defendant Watte William     Watte, William 7
4582871 2226073 2226073 defendant Smyth Henry   771860 771860 Smyth, Henry, of Seberwe 8
4582872 2226073 2226073 defendant Bulbat Richard     Bulbat, Richard 9
4582873 2226073 2226073 defendant Sylvestre Mark     Sylvestre, Mark 10
4582874 2226073 2226073 defendant Grygge John     Grygge, John 11
4582875 2226073 2226073 defendant Rotelond John     Rotelond, John 12
4582876 2226073 2226073 defendant Coke John of Elmore     Coke, John of Elmore 13
4582877 2226073 2226073 defendant Marvan Henry     together with Marvan, Henry 14
4582878 2226073 2226073 defendant Lane John     Lane, John 15
4582879 2226073 2226073 defendant Kyngeston John     Kyngeston, John 16
4582880 2226073 2226073 defendant Pollard John     Pollard, John 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);