names

15 rows where case_id = 1996516

✎ 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
3918493 1996516 1996516 plaintiff Horner John esq   Horner, John, esq 0
3918494 1996516 1996516 plaintiff Eryngton Gerard gent   Eryngton, Gerard, gent 1
3918495 1996516 1996516 plaintiff Lovell William     Lovell, William 2
3918496 1996516 1996516 defendant Doddyng Robert dyer 588465 588465 Doddyng, Robert, of Wellys, dyer 0
3918497 1996516 1996516 defendant Merler John husbandman 651538 651538 Merler, John, of Coxlaygh, husbandman 1
3918498 1996516 1996516 defendant Barton Hugh smith 586748 586748 Barton, Hugh, of Welles, smith 2
3918499 1996516 1996516 defendant Turner Jenry   586748 586748 Turner, Jenry, of Welles, lime burner 3
3918500 1996516 1996516 defendant Busshe John husbandman 651540 651540 Busshe, John, of Assheweke, husbandman 4
3918501 1996516 1996516 defendant Somerton William husbandman 597394 597394 Somerton, William, of Corscombe, husbandman 5
3918502 1996516 1996516 defendant Brokes John carpenter 648888 648888 Brokes, John, of Dyndre, carpenter 6
3918503 1996516 1996516 defendant Russell Richard carrier 586748 586748 Russell, Richard, of Welles, carrier 7
3918504 1996516 1996516 defendant Meryfyld Robert husbandman 651541 651541 Meryfyld, Robert, of Hylhowse, husbandman 8
3918505 1996516 1996516 defendant Loxton John husbandman 648885 648885 Loxton, John, of Hawdon, husbandman 9
3918506 1996516 1996516 defendant Hooper John collier 586748 586748 Hooper, John, of Welles, collier 10
3918507 1996516 1996516 defendant Heale William husbandman 651542 651542 Heale, William, of Shepton Malererbe, 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);