names

9 rows where place_id = 616186

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3713096 1930414 1930414 defendant Sterte William smith 616186 616186 Sterte, William, of Storyton, smith 17
3713097 1930414 1930414 defendant Eston William smith 616186 616186 Eston, William, of Storyton, smith 18
3713098 1930414 1930414 defendant Mare William husbandman 616186 616186 Mare, William, of Storyton, husbandman 19
3844994 1971984 1971984 defendant Mugge John husbandman 616186 616186 Mugge, John, of Storyton, husbandman 2
4813899 2300458 2300458 defendant Ansley John   616186 616186 Ansley, John, of Storyton, vicar 0
5122575 2393034 2393034 defendant atte Hill John husbandman 616186 616186 atte Hill, John, of Storyton, husbandman 0
5122576 2393034 2393034 defendant Blakhall Nicholas husbandman 616186 616186 Blakhall, Nicholas, of Storyton, husbandman 1
5183553 2410925 2410925 defendant Blakhall Nicholas yeoman 616186 616186 Blakhall, Nicholas, of Storyton, yeoman 0
5203912 2416895 2416895 defendant Blakhall Nicholas yeoman 616186 616186 Blakhall, Nicholas, of Storyton, yeoman 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);