names

10 rows where case_id = 2438188

✎ 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
5276457 2438188 2438188 plaintiff Wells John prior of the Hospital of St John Baptist, also called episcopus Tinensis, in   Wells, John, prior of the Hospital of St John Baptist, also called episcopus Tinensis, in 0
5276458 2438188 2438188 defendant Loxston (illegible) husbandman 847047 847047 Loxston, ----, of West Horyngdon, husbandman 0
5276459 2438188 2438188 defendant Piers Thomas husbandman 847047 847047 Piers, Thomas, of West Horyngdon, husbandman 1
5276460 2438188 2438188 defendant Branderep John husbandman 847047 847047 Branderep, John, of West Horyngdon, husbandman 2
5276461 2438188 2438188 defendant Tommys William husbandman 847047 847047 Tommys, William, of West Horyngdon, husbandman 3
5276462 2438188 2438188 defendant Loxston William husbandman 867611 867611 Loxston, William, of Handen, in Wells, husbandman 4
5276463 2438188 2438188 defendant Hoper Thomas husbandman 604261 604261 Hoper, Thomas, of Wells, husbandman 5
5276464 2438188 2438188 defendant Bubtyng William husbandman 654707 654707 Bubtyng, William, of Walcombe, husbandman 6
5276465 2438188 2438188 defendant T---- Thomas husbandman 593171 593171 T----, Thomas, of Milton, husbandman 7
5276466 2438188 2438188 defendant Hoper Walter husbandman 604261 604261 Hoper, Walter, of Wells, husbandman 8

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