names

14 rows where case_id = 2423919

✎ 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
5228413 2423919 2423919 plaintiff (not given) William prior of Watton Priory   Watton Priory, William, prior of 0
5228414 2423919 2423919 defendant Broun Adam husbandman 861708 861708 Broun, Adam, of Arwom, husbandman 0
5228415 2423919 2423919 defendant Bilton John husbandman 861708 861708 Bilton, John, of Arwom, husbandman 1
5228416 2423919 2423919 defendant Forster Robert husbandman 861708 861708 Forster, Robert, of Arwom, husbandman 2
5228417 2423919 2423919 defendant Otley Thoms husbandman 861708 861708 Otley, Thoms, of Arwom, husbandman 3
5228418 2423919 2423919 defendant Raventhorp Richard husbandman 837622 837622 Raventhorp, Richard, of Craunsewyk, husbandman 4
5228419 2423919 2423919 defendant Thurston William husbandman 837622 837622 Thurston, William, of Craunsewyk, husbandman 5
5228420 2423919 2423919 defendant Cartwright John husbandman 837622 837622 Cartwright, John, of Craunsewyk, husbandman 6
5228421 2423919 2423919 defendant Edmond Richard husbandman 590484 590484 Edmond, Richard, of Watton, husbandman 7
5228422 2423919 2423919 defendant Edmond Hugh husbandman 590484 590484 Edmond, Hugh, of Watton, husbandman 8
5228423 2423919 2423919 defendant Warner John husbandman 590484 590484 Warner, John, of Watton, husbandman 9
5228424 2423919 2423919 defendant Broun Peter husbandman 590484 590484 Broun, Peter, of Watton, husbandman 10
5228425 2423919 2423919 defendant Broun John husbandman 590484 590484 Broun, John, of Watton, husbandman 11
5228426 2423919 2423919 defendant Broun Richard husbandman 590484 590484 Broun, Richard, of Watton, husbandman 12

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