names

13 rows where case_id = 2492125

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5457433 2492125 2492125 plaintiff Dalves Ralph     Dalves, Ralph 0
5457434 2492125 2492125 defendant Coke Richard husbandman 598666 598666 Coke, Richard, of Newcastle under Lyme, husbandman 0
5457435 2492125 2492125 defendant Coke John alderman 598666 598666 Coke, John, of Newcastle under Lyme, alderman 1
5457436 2492125 2492125 defendant Kelsall John husbandman 598666 598666 Kelsall, John, of Newcastle under Lyme, husbandman 2
5457437 2492125 2492125 defendant Thorp Robert husbandman 598666 598666 Thorp, Robert, of Newcastle, husbandman 3
5457438 2492125 2492125 defendant Holyns Ralph   595623 595623 Holyns, Ralph, of Knotton 4
5457439 2492125 2492125 defendant Glover John jun, of Knotton, husbandman   Glover, John, jun, of Knotton, husbandman 5
5457440 2492125 2492125 defendant Vernon Thomas husbandman 598666 598666 Vernon, Thomas, of Newcastle, dyer. Badeley, Henry, of Holdych, husbandman 6
5457441 2492125 2492125 defendant Savage John husbandman 589100 589100 Savage, John, of Chesterton, husbandman 7
5457442 2492125 2492125 defendant Fox Thomas husbandman 589100 589100 Fox, Thomas, of Chesterton, husbandman 8
5457443 2492125 2492125 defendant Turnour Richard husbandman 888244 888244 Turnour, Richard, of Burseleym, husbandman 9
5457444 2492125 2492125 defendant Smyth John husbandman 889647 889647 Smyth, John, of Parkeende, husbandman 10
5457445 2492125 2492125 defendant Croket Thomas yeoman 588483 588483 Croket, Thomas, of Audeley, 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);