names

18 rows where case_id = 1931053

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3715227 1931053 1931053 plaintiff Broun Mathew knight   Broun, Mathew, knight 0
3715228 1931053 1931053 plaintiff Polsted Thomas     Polsted, Thomas 1
3715229 1931053 1931053 plaintiff Shore John     Shore, John 2
3715230 1931053 1931053 plaintiff Hanford Henry     Hanford, Henry 3
3715231 1931053 1931053 plaintiff Duke Oliver     Duke, Oliver 4
3715232 1931053 1931053 plaintiff Cotell John     Cotell, John 5
3715233 1931053 1931053 plaintiff White John     White, John 6
3715234 1931053 1931053 plaintiff Lucok Humphrey     Lucok, Humphrey 7
3715235 1931053 1931053 plaintiff Brokhole William     Brokhole, William 8
3715236 1931053 1931053 plaintiff Sutton James     Sutton, James 9
3715237 1931053 1931053 plaintiff A Downe Thomas     A Downe, Thomas 10
3715238 1931053 1931053 plaintiff Godman Richard     Godman, Richard 11
3715239 1931053 1931053 defendant Grove Richard laborer 616597 616597 Grove, Richard, of Feccham, laborer 0
3715240 1931053 1931053 defendant Man Richard laborer 616597 616597 Man, Richard, of Feccham, laborer 1
3715241 1931053 1931053 defendant Cheynell William laborer 616597 616597 Cheynell, William, of Feccham, laborer 2
3715242 1931053 1931053 defendant Cheseman Richard yeoman 616598 616598 Cheseman, Richard, of Stoke Dabernon, yeoman 3
3715243 1931053 1931053 defendant Shore Thomas laborer 616598 616598 Shore, Thomas, of Stoke Dabernon, laborer 4
3715244 1931053 1931053 defendant Colney Thomas laborer 616598 616598 Colney, Thomas, of Stoke Dabernon, laborer 5

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