names

8 rows where case_id = 2042058

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4048918 2042058 2042058 plaintiff Tompson John     Tompson, John 0
4048919 2042058 2042058 defendant Kelyowe William gent 638279 638279 Kelyowe, William, of St Teth, gent 0
4048920 2042058 2042058 defendant Denbold or Deubold Michael clerk 682284 682284 Denbold or Deubold, Michael, of Wapestowe, clerk 1
4048921 2042058 2042058 defendant Grygge John husbandman 681194 681194 Grygge, John, of St Stephens, Launceston, husbandman 2
4048922 2042058 2042058 defendant Lee Humphrey yeoman 637943 637943 Lee, Humphrey, of St Mary Weke, yeoman 3
4048923 2042058 2042058 defendant Trebesper William gent 614681 614681 Trebesper, William, of Morewynstowe, gent 4
4048924 2042058 2042058 defendant Allen John yeoman 617555 617555 Allen, John, of Kylkehampton, yeoman 5
4048925 2042058 2042058 defendant Norres John clerk 682285 682285 Norres, John, of Ashwater, Devon, clerk 6

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