names

13 rows where case_id = 2401109

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5149915 2401109 2401109 plaintiff Exeter Henry duke, of   Exeter, Henry, duke, of 0
5149916 2401109 2401109 defendant Reyd Gerard gent 594060 594060 Reyd, Gerard, of Whaddon, gent 0
5149917 2401109 2401109 defendant Lyly John butcher 594060 594060 Lyly, John, of Whaddon, butcher 1
5149918 2401109 2401109 defendant Smyth Henry smith 594060 594060 Smyth, Henry, of Whaddon, smith 2
5149919 2401109 2401109 defendant Chapman William of Whaddon husbandman   Chapman, William of Whaddon, husbandman 3
5149920 2401109 2401109 defendant Hoket William husbandman 594060 594060 Hoket, William, of Whaddon, husbandman 4
5149921 2401109 2401109 defendant Chapman John husbandman 594060 594060 Chapman, John, of Whaddon, husbandman 5
5149922 2401109 2401109 defendant Scalys John laborer 594060 594060 Scalys, John, of Whaddon, laborer 6
5149923 2401109 2401109 defendant Wangeworth Richard laborer 594060 594060 Wangeworth, Richard, of Whaddon, laborer 7
5149924 2401109 2401109 defendant Spycer William husbandman 594060 594060 Spycer, William, of Whaddon, husbandman 8
5149925 2401109 2401109 defendant Loney William laborer 594060 594060 Loney, William, of Whaddon, laborer 9
5149926 2401109 2401109 defendant Lyly William laborer 594060 594060 Lyly, William, of Whaddon, laborer 10
5149927 2401109 2401109 defendant Broke William laborer 594060 594060 Broke, William, of Whaddon, laborer 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);