names

13 rows where case_id = 2247775

✎ 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
4656049 2247775 2247775 plaintiff Burton Thomas clerk   Burton, Thomas, clerk 0
4656050 2247775 2247775 defendant Sawyer Richard husbandman 608809 608809 Sawyer, Richard, of Pagham, Sussex, husbandman 0
4656051 2247775 2247775 defendant atte Sole John husbandman 778068 778068 atte Sole, John, of Lovent, Sussex, husbandman 1
4656052 2247775 2247775 defendant Koc John carpenter 600115 600115 Koc, John, of Hese, Middx, carpenter 2
4656053 2247775 2247775 defendant Hatfeld John husbandman 778693 778693 Hatfeld, John, of Wymbuldon, Surrey, husbandman 3
4656054 2247775 2247775 defendant Sager John husbandman 659582 659582 Sager, John, of Hampton, Surrey, husbandman 4
4656055 2247775 2247775 defendant Cotyng Robert butcher 596824 596824 Cotyng, Robert, of Lynstede, Kent, butcher 5
4656056 2247775 2247775 defendant Hoke Richard husbandman 628419 628419 Hoke, Richard, of Wymbuldon, husbandman 6
4656057 2247775 2247775 defendant Hatfeld John husbandman 628419 628419 Hatfeld, John, of Wymbuldon, husbandman 7
4656058 2247775 2247775 defendant Estre Robert husbandman 778694 778694 Estre, Robert, of Reculvere, Kent, husbandman 8
4656059 2247775 2247775 defendant Estre Thomas husbandman 629489 629489 Estre, Thomas, of Sutton, Kent, husbandman 9
4656060 2247775 2247775 defendant Wyke Thomas (legal representative) 778075 778075 Wyke, Thomas, of Maydenston, Kent, executrix of 10
4656061 2247775 2247775 defendant Wyke Alice widow   Wyke, Alice, widow 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);