names

12 rows where case_id = 2288190

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4775041 2288190 2288190 plaintiff West Reginald knight   West, Reginald, knight 0
4775042 2288190 2288190 plaintiff Uvedale John     Uvedale, John 1
4775043 2288190 2288190 plaintiff Basset William     Basset, William 2
4775044 2288190 2288190 defendant Laurens William   800716 800716 Laurens, William, of Godelawe 0
4775045 2288190 2288190 defendant Pordowe John   800717 800717 Pordowe, John, of Littlehampton 1
4775046 2288190 2288190 defendant Bararet William   800717 800717 Bararet, William, of Littlehampton 2
4775047 2288190 2288190 defendant Kelpot Richard   586459 586459 Kelpot, Richard, of Stoke 3
4775048 2288190 2288190 defendant Aune Richard   587191 587191 Aune, Richard, of Arundell 4
4775049 2288190 2288190 defendant Abbot Robert   587191 587191 Abbot, Robert, of Arundell 5
4775050 2288190 2288190 defendant Sadeler Robert   587191 587191 Sadeler, Robert, of Arundell 6
4775051 2288190 2288190 defendant North John   587191 587191 North, John, of Arundell 7
4775052 2288190 2288190 defendant Clerk Thomas   599046 599046 Clerk, Thomas, of Ford 8

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