names

7 rows where place_id = 853660

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5011824 2360308 2360308 defendant Reynold Richard   853660 853660 Reynold, Richard, of Castyr, parson & clerk 2
5152198 2401778 2401778 defendant Ousteby John husbandman 853660 853660 Ousteby, John, of Castyr, husbandman 10
5170073 2406980 2406980 defendant Oustehey John husbandman 853660 853660 Oustehey, John, of Castyr, husbandman 12
5187435 2412048 2412048 defendant Tenelby William yeoman 853660 853660 Tenelby, William, of Castyr, yeoman 2
5187437 2412048 2412048 defendant Lovell Richard butcher 853660 853660 Lovell, Richard, of Castyr, butcher 4
5225976 2423264 2423264 defendant Andrew John husbandman 853660 853660 Andrew, John, of Castyr, husbandman 0
5602147 2535568 2535568 defendant Waren John husbandman 853660 853660 Waren, John, of Castyr, 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);