names

13 rows where case_id = 2202524

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4506467 2202524 2202524 plaintiff Threlkeld Richard de     Threlkeld, Richard de 0
4506468 2202524 2202524 defendant Artured John   586936 586936 Artured, John, of Thoresby, parson 0
4506469 2202524 2202524 defendant Clerk Thomas   764489 764489 Clerk, Thomas, of Hilton dall 1
4506470 2202524 2202524 defendant Ja-- Robert, junior     Ja--, Robert, junior 2
4506471 2202524 2202524 defendant Aleynson John   760887 760887 Aleynson, John, of Gillesland 3
4506472 2202524 2202524 defendant Gudale John   592147 592147 Gudale, John, of Neuton 4
4506473 2202524 2202524 defendant Beghman Alexander   764490 764490 Beghman, Alexander, of Derwent Selles 5
4506474 2202524 2202524 defendant Wildyng John     Wildyng, John 6
4506475 2202524 2202524 defendant Lowes Thomas     Lowes, Thomas 7
4506476 2202524 2202524 defendant Rakestre John     Rakestre, John 8
4506477 2202524 2202524 defendant Thomson John   764491 764491 Thomson, John, of Gre-- 9
4506478 2202524 2202524 defendant Juddeson John     Juddeson, John 10
4506479 2202524 2202524 defendant Archur John chaplain   Archur, John, chaplain 11

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