names

13 rows where case_id = 2374028

✎ 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
5058274 2374028 2374028 plaintiff Cumberford William     Cumberford, William 0
5058275 2374028 2374028 defendant Savage John esq 614787 614787 Savage, John, of Halton, Cheshire, esq 0
5058276 2374028 2374028 defendant Middelwod Roger yeoman 841358 841358 Middelwod, Roger, of Everston in Pikrynglich, Yorks, yeoman 1
5058277 2374028 2374028 defendant Middelwod Thomas yeoman 841359 841359 Middelwod, Thomas, of Everston in Pikrynglich, yeoman 2
5058278 2374028 2374028 defendant Westthorp William   841360 841360 Westthorp, William, of Brompton in Pikrynglich, Yorks 3
5058279 2374028 2374028 defendant Rouseby Nicholas gent 841361 841361 Rouseby, Nicholas, of Thornton in Pikrynglich, gent 4
5058280 2374028 2374028 defendant Mery Thomas yeoman 841362 841362 Mery, Thomas, of Pirynglich, yeoman 5
5058281 2374028 2374028 defendant Proktour Henry yeoman 841363 841363 Proktour, Henry, of Stayngrefe in Rydale, Yorks, yeoman 6
5058282 2374028 2374028 defendant Burnet W-   586731 586731 Burnet, W-, of Wakefeld, Yorks, bailiff 7
5058283 2374028 2374028 defendant Thornour Robert gent 841365 841365 Thornour, Robert, of Farsley, Yorks, gent 8
5058284 2374028 2374028 defendant Tothelay John yeoman 841366 841366 Tothelay, John, of Rothelay, Yorks, yeoman 9
5058285 2374028 2374028 defendant Willeson Henry of Carleton, Yorks, husbandman   Willeson, Henry, ,of Carleton, Yorks, husbandman 10
5058286 2374028 2374028 defendant Lassels of Pikryng yeoman   Lassels, of Pikryng, yeoman 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);