names

16 rows where case_id = 2099092

✎ 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
4210090 2099092 2099092 plaintiff Stone Thomas Principal of New Inn, St Clement Danes, Middx   Stone, Thomas, Principal of New Inn, St Clement Danes, Middx 0
4210091 2099092 2099092 defendant Burlace Nicholas gent 715572 715572 Burlace, Nicholas, of Tredlore, Cornw, gent 0
4210092 2099092 2099092 defendant Sayntaubyn Henry gent 715573 715573 Sayntaubyn, Henry, of Litheron, Cornw, gent 1
4210093 2099092 2099092 defendant Chapman Alan gent 592176 592176 Chapman, Alan, of Lynton, Cams, gent 2
4210094 2099092 2099092 defendant Arderne Richard gent 715574 715574 Arderne, Richard, of Hewerden, Cheshire, gent 3
4210095 2099092 2099092 defendant Arderne Thomas gent 711780 711780 Arderne, Thomas, of Barrowe, Cheshire, gent 4
4210096 2099092 2099092 defendant Tylley Alexander gent 666277 666277 Tylley, Alexander, of Cannyngton, Soms, gent 5
4210097 2099092 2099092 defendant Harryngton Robert gent 671482 671482 Harryngton, Robert, of Witham, Lincs, gent 6
4210098 2099092 2099092 defendant Browne Philip gent 585869 585869 Browne, Philip, of London, gent 7
4210099 2099092 2099092 defendant Broke William gent 585869 585869 Broke, William, of London, gent 8
4210100 2099092 2099092 defendant Wallopp William esq 715575 715575 Wallopp, William, of Upwynborn Monckton, Dorset, esq 9
4210101 2099092 2099092 defendant Hawles Nicholas esq 715576 715576 Hawles, Nicholas, of Upwynborn Monckton, esq 10
4210102 2099092 2099092 defendant Mallery Peter gent 645728 645728 Mallery, Peter, of Papworth, Hunts, gent 11
4210103 2099092 2099092 defendant Brett James gent 715577 715577 Brett, James, of Somersume, Hunts, gent 12
4210104 2099092 2099092 defendant Bore Nicholas gent 715578 715578 Bore, Nicholas, of Marston Mungumbury, Staffs, gent 13
4210105 2099092 2099092 defendant Flyer William gent 607643 607643 Flyer, William, of Utcetur, Staffs, gent 14

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