names

10 rows where place_id = 763358

✎ 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
4496462 2199569 2199569 defendant Bucks Stabolt Richard   763358 763358 Bucks Stabolt, Richard, of Tewekesbury, Gloucs 2
4610357 2234322 2234322 defendant Rose Thomas   763358 763358 Rose, Thomas, of Tewekesbury, Gloucs 1
4763459 2284556 2284556 defendant Godman Robert yeoman 763358 763358 Godman, Robert, of Tewekesbury, Gloucs, yeoman 0
4908446 2329196 2329196 defendant Fauconer John husbandman 763358 763358 Fauconer, John, of Tewekesbury, Gloucs, husbandman 2
5010630 2359980 2359980 defendant Boman John merchant 763358 763358 Boman, John, of Tewekesbury, Gloucs, merchant 2
5043402 2369650 2369650 defendant Donne John ferryman 763358 763358 Donne, John, of Tewekesbury, Gloucs, ferryman 0
5148020 2400566 2400566 defendant Jet William mercer 763358 763358 Jet, William, of Tewekesbury, Gloucs, mercer 4
5167472 2406218 2406218 defendant Jet alias Pecok William mercer 763358 763358 Jet alias Pecok, William, of Tewekesbury, Gloucs, mercer 2
5167480 2406219 2406219 defendant Jet alias Pecok William mercer 763358 763358 Jet alias Pecok, William, of Tewekesbury, Gloucs, mercer 4
5210230 2418720 2418720 defendant Berton Ralph mercer 763358 763358 Berton, Ralph, of Tewekesbury, Gloucs, mercer 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);