names

15 rows where case_id = 2169932

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4416125 2169932 2169932 plaintiff Loudham John de knight   Loudham, John de, knight 0
4416126 2169932 2169932 defendant Parker Thomas le   753839 753839 Parker, Thomas le, of Welhawe 0
4416127 2169932 2169932 defendant Parker John le   753839 753839 Parker, John le, of Welhawe, son of Thomas 1
4416128 2169932 2169932 defendant Boulem William   753839 753839 Boulem, William, of Welhawe 2
4416129 2169932 2169932 defendant Chaumbre John de la   753839 753839 Chaumbre, John de la, of Welhawe 3
4416130 2169932 2169932 defendant Brome Richard   753839 753839 Brome, Richard, of Welhawe 4
4416131 2169932 2169932 defendant Anker William   588845 588845 Anker, William, of Grymston 5
4416132 2169932 2169932 defendant Predhomme William   753841 753841 Predhomme, William, of Edenestowe 6
4416133 2169932 2169932 defendant Dinye Henry   753842 753842 Dinye, Henry, of Thouresby 7
4416134 2169932 2169932 defendant Sheil Robert   618916 618916 Sheil, Robert, of Clipston 8
4416135 2169932 2169932 defendant Cratyn Hugh   753843 753843 Cratyn, Hugh, of Maundesfeld 9
4416136 2169932 2169932 defendant Dobbes Ralph milner   Dobbes, Ralph, milner 10
4416137 2169932 2169932 defendant Coke Robert le   753844 753844 Coke, Robert le, of Bothumeshel 11
4416138 2169932 2169932 defendant Colyngham William de   753845 753845 Colyngham, William de, of Allnton 12
4416139 2169932 2169932 defendant Saye Richard   753839 753839 Saye, Richard, of Welhawe 13

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