names

14 rows where case_id = 1973727

✎ 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
3850431 1973727 1973727 plaintiff Monketon Marmaduke     Monketon, Marmaduke 0
3850432 1973727 1973727 plaintiff Hodlowe Robert     Hodlowe, Robert 1
3850433 1973727 1973727 defendant Johnson John, junior husbandman 586019 586019 Johnson, John, junior, of South Cave, husbandman 0
3850434 1973727 1973727 defendant Fowle John husbandman 586019 586019 Fowle, John, of South Cave, husbandman 1
3850435 1973727 1973727 defendant Leddell Michael husbandman 586019 586019 Leddell, Michael, of South Cave, husbandman 2
3850436 1973727 1973727 defendant Johnson William husbandman 586019 586019 Johnson, William, of South Cave, husbandman 3
3850437 1973727 1973727 defendant Johnson Richard husbandman 586019 586019 Johnson, Richard, of South Cave, husbandman 4
3850438 1973727 1973727 defendant Glow or Edlow Thomas husbandman 595432 595432 Glow or Edlow, Thomas, of Everthorp, husbandman 5
3850439 1973727 1973727 defendant Stevyn Thomas husbandman 595431 595431 Stevyn, Thomas, of North Cave, husbandman 6
3850440 1973727 1973727 defendant Jennyson Agnes widow 595431 595431 Jennyson, Agnes, of North Cave, widow 7
3850441 1973727 1973727 defendant Fanden or Fauden Lawrence husbandman 595431 595431 Fanden or Fauden, Lawrence, of North Cave, husbandman 8
3850442 1973727 1973727 defendant Forster William husbandman 595431 595431 Forster, William, of North Cave, husbandman 9
3850443 1973727 1973727 defendant Westmorland John husbandman 595431 595431 Westmorland, John, of North Cave, husbandman 10
3850444 1973727 1973727 defendant Narres Robert husbandman 639700 639700 Narres, Robert, of Newbald, husbandman 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);