names

13 rows where case_id = 2379796

✎ 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
5077588 2379796 2379796 plaintiff Bolde Simon     Bolde, Simon 0
5077589 2379796 2379796 defendant Burne Thomas husbandman 640406 640406 Burne, Thomas, of Wenlynburgh, husbandman 0
5077590 2379796 2379796 defendant Elyotte William husbandman 616939 616939 Elyotte, William, of Wendlyngburgh, husbandman 1
5077591 2379796 2379796 defendant Elyotte Thomas husbandman 616939 616939 Elyotte, Thomas, of Wendlyngburgh, husbandman 2
5077592 2379796 2379796 defendant Hurluston Stephen husbandman 616939 616939 Hurluston, Stephen, of Wendlyngburgh, husbandman 3
5077593 2379796 2379796 defendant Idelote Thomas   616939 616939 Idelote, Thomas, of Wendlyngburgh, wright 4
5077594 2379796 2379796 defendant Magot Henry roper 616939 616939 Magot, Henry, of Wendlyngburgh, roper 5
5077595 2379796 2379796 defendant Willy John fuller 616939 616939 Willy, John, of Wendlyngburgh, fuller 6
5077596 2379796 2379796 defendant Willy Ralph fuller 616939 616939 Willy, Ralph, of Wendlyngburgh, fuller 7
5077597 2379796 2379796 defendant Wodeland John husbandman 616939 616939 Wodeland, John, of Wendlyngburgh, husbandman 8
5077598 2379796 2379796 defendant Bele Richard   616939 616939 Bele, Richard, of Wendlyngburgh, "peytour" or painter 9
5077599 2379796 2379796 defendant Umfray Robert smith 616939 616939 Umfray, Robert, of Wendlyngburgh, smith 10
5077600 2379796 2379796 defendant Crowley John weaver 616939 616939 Crowley, John, of Wendlyngburgh, weaver 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);