names

19 rows where case_id = 2224698

✎ 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
4578259 2224698 2224698 plaintiff Circestre William     Circestre, William 0
4578260 2224698 2224698 defendant Wynneman William   771444 771444 Wynneman, William, of Munstreworth 0
4578261 2224698 2224698 defendant Shepescombe William     Shepescombe, William 1
4578262 2224698 2224698 defendant Pavy John     Pavy, John 2
4578263 2224698 2224698 defendant Wodeward Robert   771445 771445 Wodeward, Robert, of Tewksbury 3
4578264 2224698 2224698 defendant Sperman William     Sperman, William 4
4578265 2224698 2224698 defendant Streynesham Thomas     Streynesham, Thomas 5
4578266 2224698 2224698 defendant Witteney John     Witteney, John 6
4578267 2224698 2224698 defendant Smyth Henry   771446 771446 Smyth, Henry, of Segbrewe 7
4578268 2224698 2224698 defendant Wattes William   592878 592878 Wattes, William, of Elmore 8
4578269 2224698 2224698 defendant Silvestre Mark     Silvestre, Mark 9
4578270 2224698 2224698 defendant Grygge John     Grygge, John 10
4578271 2224698 2224698 defendant Hasard John     together with Hasard, John 11
4578272 2224698 2224698 defendant Bulbat Richard     Bulbat, Richard 12
4578273 2224698 2224698 defendant Marnan Henry     Marnan, Henry 13
4578274 2224698 2224698 defendant Rutlond John     Rutlond, John 14
4578275 2224698 2224698 defendant Lane John     Lane, John 15
4578276 2224698 2224698 defendant Kyngeston John Pollard, John   Kyngeston, John, Pollard, John 16
4578277 2224698 2224698 defendant Coke John   592878 592878 Coke, John, of Elmore 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);