names

16 rows where case_id = 2224710

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4578310 2224710 2224710 plaintiff Clay Richard   763156 763156 Clay, Richard, of Langedon 0
4578311 2224710 2224710 plaintiff Clay Alice   763156 763156 Clay, Alice, of Langedon 1
4578312 2224710 2224710 plaintiff Clay Lucy   763156 763156 Clay, Lucy, of Langedon 2
4578313 2224710 2224710 defendant Grymeston Richard de     Grymeston, Richard de 0
4578314 2224710 2224710 defendant Muron Richard     Muron, Richard 1
4578315 2224710 2224710 defendant Scochese Robert     Scochese, Robert 2
4578316 2224710 2224710 defendant Langedon Richard de     Langedon, Richard de 3
4578317 2224710 2224710 defendant Langedon John de     Langedon, John de 4
4578318 2224710 2224710 defendant Palmer John     Palmer, John 5
4578319 2224710 2224710 defendant Palmer Richard     Palmer, Richard 6
4578320 2224710 2224710 defendant Wythyfen William     Wythyfen, William 7
4578321 2224710 2224710 defendant Ruse William     Ruse, William 8
4578322 2224710 2224710 defendant Whale John     Whale, John 9
4578323 2224710 2224710 defendant Sudcote Richard de     Sudcote, Richard de 10
4578324 2224710 2224710 defendant Gate William     Gate, William 11
4578325 2224710 2224710 defendant Stonhous Nicholas     Stonhous, Nicholas 12

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