names

13 rows where case_id = 2485178

✎ 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
5434178 2485178 2485178 plaintiff Northumberland Henry Earl of   Northumberland, Henry, Earl of 0
5434179 2485178 2485178 defendant Bust John shipman 598916 598916 Bust, John, of Anderby, shipman 0
5434180 2485178 2485178 defendant Godard John shipman 598916 598916 Godard, John, of Anderby, shipman 1
5434181 2485178 2485178 defendant Swete John   598916 598916 Swete, John, of Anderby, wright 2
5434182 2485178 2485178 defendant Swete Thomas husbandman 598916 598916 Swete, Thomas, of Anderby, husbandman 3
5434183 2485178 2485178 defendant Snayth Henry husbandman 592848 592848 Snayth, Henry, of Hotoft, husbandman 4
5434184 2485178 2485178 defendant Coke John weaver 646995 646995 Coke, John, of Hotofte, weaver 5
5434185 2485178 2485178 defendant Drax Alan husbandman 646995 646995 Drax, Alan, of Hotofte, husbandman 6
5434186 2485178 2485178 defendant Purle John laborer 646995 646995 Purle, John, of Hotofte, laborer 7
5434187 2485178 2485178 defendant Webster William shipman 646995 646995 Webster, William, of Hotofte, shipman 8
5434188 2485178 2485178 defendant Bugge John laborer 646995 646995 Bugge, John, of Hotofte, laborer 9
5434189 2485178 2485178 defendant West Thomas laborer 646995 646995 West, Thomas, of Hotofte, laborer 10
5434190 2485178 2485178 defendant West William laborer 646995 646995 West, William, of Hotofte, 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);