names

11 rows where case_id = 2436257

✎ 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
5269723 2436257 2436257 plaintiff Coke John chaplain   Coke, John, chaplain 0
5269724 2436257 2436257 defendant Neuhous James gent 654270 654270 Neuhous, James, of Mylverton, Soms, gent 0
5269725 2436257 2436257 defendant Tayllour William tailor 866510 866510 Tayllour, William, of Clayhanger, Devon, tailor 1
5269726 2436257 2436257 defendant Tor--- William tailor 586580 586580 Tor---, William, of Mylverton, tailor 2
5269727 2436257 2436257 defendant Brener Nicholas   586580 586580 Brener, Nicholas, of Mylverton 3
5269728 2436257 2436257 defendant Edward Thomas laborer 866511 866511 Edward, Thomas, of Kynverton, laborer 4
5269729 2436257 2436257 defendant Hert Robert husbandman 737314 737314 Hert, Robert, of Grendenham, Soms, husbandman 5
5269730 2436257 2436257 defendant Shute John yeoman 780227 780227 Shute, John, of North Cory, Soms, yeoman 6
5269731 2436257 2436257 defendant Merl-- John husbandman 655537 655537 Merl--, John, of Burlescombe, Devon, husbandman 7
5269732 2436257 2436257 defendant Flogyn Robert   801076 801076 Flogyn, Robert, of Halse, Soms 8
5269733 2436257 2436257 defendant Pytte Nicholas husbandman 866512 866512 Pytte, Nicholas, of Asshebrytell, Soms, husbandman 9

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);