names

13 rows where case_id = 2518332

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5544309 2518332 2518332 plaintiff Reynold Richard     Reynold, Richard 0
5544310 2518332 2518332 defendant Hoton Richard yeoman 586067 586067 Hoton, Richard, of York, yeoman 0
5544311 2518332 2518332 defendant Wattys Thomas carrier 898386 898386 Wattys, Thomas, of Skelynghoppe, Lincs, carrier 1
5544312 2518332 2518332 defendant Wod Roger fuller 586846 586846 Wod, Roger, of Lincoln, fuller 2
5544313 2518332 2518332 defendant Feynold John dyer 589256 589256 Feynold, John, of Newebery, Berks, dyer 3
5544314 2518332 2518332 defendant Isod Richard dyer 586901 586901 Isod, Richard, of Nottingham, dyer 4
5544315 2518332 2518332 defendant Peyntour Henry yeoman 586117 586117 Peyntour, Henry, of Coventry, yeoman 5
5544316 2518332 2518332 defendant Parker Henry dyer 586117 586117 Parker, Henry, of Coventry, dyer 6
5544317 2518332 2518332 defendant Noresse Thomas   586117 586117 Noresse, Thomas, of Coventry, card maker 7
5544318 2518332 2518332 defendant Swetnam Thomas capper 586117 586117 Swetnam, Thomas, of Coventry, capper 8
5544319 2518332 2518332 defendant Parkyn William dyer 586117 586117 Parkyn, William, of Coventry, dyer 9
5544320 2518332 2518332 defendant Yerdeley Oliver yeoman 588266 588266 Yerdeley, Oliver, of Kelyngworth, Warks, yeoman 10
5544321 2518332 2518332 defendant Rodon Thomas dyer 587516 587516 Rodon, Thomas, of Stafford, dyer 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);