names

10 rows where place_id = 780374

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4667700 2255609 2255609 defendant Banastre Henry fuller 780374 780374 Banastre, Henry, of Shirborn, Dors, fuller 1
4747340 2279725 2279725 defendant Baker John husbandman 780374 780374 Baker, John, of Shirborn, Dors, husbandman 0
4803997 2297433 2297433 defendant Draper Thomas husbandman 780374 780374 Draper, Thomas, of Shirborn, Dors, husbandman 0
4811780 2299796 2299796 defendant Salter John weaver 780374 780374 Salter, John, of Shirborn, Dors, weaver 0
4811786 2299797 2299797 defendant Salter John, senior weaver 780374 780374 Salter, John, senior, of Shirborn, Dors, weaver 4
4812051 2299882 2299882 defendant Gavelacre William butcher 780374 780374 Gavelacre, William, of Shirborn, Dors, butcher 3
5124795 2393725 2393725 defendant Baret William gent 780374 780374 Baret, William, of Shirborn, Dors, gent 0
5274406 2437593 2437593 defendant Pyle Walter husbandman 780374 780374 Pyle, Walter, of Shirborn, dors, husbandman 0
5389775 2472142 2472142 defendant Shete John gent 780374 780374 Shete, John, of Shirborn, Dors, gent 0
5402613 2475821 2475821 defendant Shete John gent 780374 780374 Shete, John, of Shirborn, Dors, gent 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);