names

15 rows where case_id = 2172726

✎ 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
4425245 2172726 2172726 plaintiff Loudham John knight   Loudham, John, knight 0
4425246 2172726 2172726 defendant Parker Thomas le   753839 753839 Parker, Thomas le, of Welhawe 0
4425247 2172726 2172726 defendant Parker John of Welhawe, son of Thomas   Parker, John, , of Welhawe, son of Thomas 1
4425248 2172726 2172726 defendant Bonbem Williaml of Welhawe     Bonbem, Williaml of Welhawe 2
4425249 2172726 2172726 defendant Chaumbre John de la   753839 753839 Chaumbre, John de la, of Welhawe 3
4425250 2172726 2172726 defendant Brome Richard   753839 753839 Brome, Richard, of Welhawe 4
4425251 2172726 2172726 defendant Anker William   730815 730815 Anker, William, of Brymston 5
4425252 2172726 2172726 defendant Prodhome William   754005 754005 Prodhome, William, of Edenstowe 6
4425253 2172726 2172726 defendant Druye Henry   755048 755048 Druye, Henry, of Thornesby 7
4425254 2172726 2172726 defendant Sheil Robert   618916 618916 Sheil, Robert, of Clipston 8
4425255 2172726 2172726 defendant Matyn Hugh   755049 755049 Matyn, Hugh, of Manesfeld 9
4425256 2172726 2172726 defendant Dobbes Robert milner   Dobbes, Robert, milner 10
4425257 2172726 2172726 defendant Coke Robert le   753844 753844 Coke, Robert le, of Bothumeshel 11
4425258 2172726 2172726 defendant Colyngham William de   755050 755050 Colyngham, William de, of Allyrton 12
4425259 2172726 2172726 defendant Sire Richard   753839 753839 Sire, 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);