names

13 rows where place_id = 674467

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4014160 2029793 2029793 plaintiff Savile William esq 674467 674467 Savile, William, of Humby, esq 1
4014166 2029794 2029794 plaintiff Savile William esq 674467 674467 Savile, William, of Humby, esq 1
4593544 2229261 2229261 defendant Casterton Richard   674467 674467 Casterton, Richard, of Humby 0
4593550 2229261 2229261 defendant Hers William   674467 674467 Hers, William, of Humby 6
4593557 2229261 2229261 defendant Bayhard John   674467 674467 Bayhard, John, of Humby 13
4593558 2229261 2229261 defendant Scot John   674467 674467 Scot, John, of Humby 14
4619836 2237181 2237181 defendant Wylughby William   674467 674467 Wylughby, William, of Humby 0
4619839 2237181 2237181 defendant Pynchebek Thomas   674467 674467 Pynchebek, Thomas, of Humby 3
4657890 2248353 2248353 defendant Fox Edmund husbandman 674467 674467 Fox, Edmund, of Humby, husbandman 0
4721517 2272061 2272061 defendant Casterton Richard gent 674467 674467 Casterton, Richard, of Humby, gent 0
4859615 2314380 2314380 plaintiff Casterton Richard esq 674467 674467 Casterton, Richard, of Humby, esq 0
5293625 2443099 2443099 defendant Horton William laborer 674467 674467 Horton, William, of Humby, laborer 3
5308788 2447668 2447668 defendant Horton John husbandman 674467 674467 Horton, John, of Humby, husbandman 0

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