names

13 rows where case_id = 2339205

✎ 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
4940990 2339205 2339205 plaintiff Duffeld Richard     Duffeld, Richard 0
4940991 2339205 2339205 defendant Hare Philip husbandman 717823 717823 Hare, Philip, of Goushill, husbandman 0
4940992 2339205 2339205 defendant Tucher Henry husbandman 717823 717823 Tucher, Henry, of Goushill, husbandman 1
4940993 2339205 2339205 defendant Redmer Thomas husbandman 717823 717823 Redmer, Thomas, of Goushill, husbandman 2
4940994 2339205 2339205 defendant Sewestern Thomas husbandman 825138 825138 Sewestern, Thomas, of Spyttyll in the Stret, husbandman 3
4940995 2339205 2339205 defendant Wylkynson John husbandman 589231 589231 Wylkynson, John, of Hemyngby, husbandman 4
4940996 2339205 2339205 defendant Mason William laborer 624750 624750 Mason, William, of Bysshop Norton, laborer 5
4940997 2339205 2339205 defendant Cartwright George husbandman 623950 623950 Cartwright, George, of Laceby, husbandman 6
4940998 2339205 2339205 defendant Hervy John husbandman 590061 590061 Hervy, John, of Barton, husbandman 7
4940999 2339205 2339205 defendant Bocher Robert butcher 590061 590061 Bocher, Robert, of Barton, butcher 8
4941000 2339205 2339205 defendant Byddes Richard butcher 590061 590061 Byddes, Richard, of Barton, butcher 9
4941001 2339205 2339205 defendant Jonson Richard   590061 590061 Jonson, Richard, of Barton, cartwright 10
4941002 2339205 2339205 defendant Palmer Richard chaplain 756465 756465 Palmer, Richard, of Germethorp, chaplain 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);