names

16 rows where case_id = 2394008

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5125714 2394008 2394008 plaintiff Beauchamp Richard   603409 603409 Beauchamp, Richard, of Salisbury, bishop 0
5125715 2394008 2394008 plaintiff Longe Henry esq   Longe, Henry, esq 1
5125716 2394008 2394008 plaintiff Blake John esq   Blake, John, esq 2
5125717 2394008 2394008 plaintiff Halles John merchant 586859 586859 Halles, John, of Salisbury, merchant 3
5125718 2394008 2394008 defendant Brokehurst John butcher   Brokehurst, John, butcher 0
5125719 2394008 2394008 defendant Brokehurst William butcher   Brokehurst, William, butcher 1
5125720 2394008 2394008 defendant Dorselyn Andrew tailor   Dorselyn, Andrew, tailor 2
5125721 2394008 2394008 defendant Tyer John merchant   Tyer, John, merchant 3
5125722 2394008 2394008 defendant Capon William barber   Capon, William, barber 4
5125723 2394008 2394008 defendant Burbrigge William hosier   Burbrigge, William, hosier 5
5125724 2394008 2394008 defendant Cole William yeoman   Cole, William, yeoman 6
5125725 2394008 2394008 defendant Forster Robert sheerman   Forster, Robert, sheerman 7
5125726 2394008 2394008 defendant Tomson Richard tailor   Tomson, Richard, tailor 8
5125727 2394008 2394008 defendant Glasyer Thomas hosier   Glasyer, Thomas, hosier 9
5125728 2394008 2394008 defendant Colvyle Richard sheerman   Colvyle, Richard, sheerman 10
5125729 2394008 2394008 defendant Patryk Simon merchant   Patryk, Simon, merchant 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);