names

10 rows where place_id = 623186

✎ 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
3751088 1942268 1942268 defendant Grenewey Robert husbandman 623186 623186 Grenewey, Robert, of Ulnehale, husbandman 4
3788829 1954309 1954309 defendant Smyth Thomas husbandman 623186 623186 Smyth, Thomas, of Ulnehale, husbandman 0
3819516 1963982 1963982 defendant Norton John shoemaker 623186 623186 Norton, John, of Ulnehale, shoemaker 1
4866531 2316494 2316494 plaintiff Halughton Robert   623186 623186 Halughton, Robert, of Ulnehale 0
5188057 2412219 2412219 defendant Hobbeday William husbandman 623186 623186 Hobbeday, William, of Ulnehale, husbandman 0
5188058 2412219 2412219 defendant Hull Robert husbandman 623186 623186 Hull, Robert, of Ulnehale, husbandman 1
5205853 2417447 2417447 defendant Hobbeday Gilbert husbandman 623186 623186 Hobbeday, Gilbert, of Ulnehale, husbandman 0
5205854 2417447 2417447 defendant Hull Robert husbandman 623186 623186 Hull, Robert, of Ulnehale, husbandman 1
5494382 2503221 2503221 defendant Grove John butcher 623186 623186 Grove, John,of Ulnehale, butcher 3
5510478 2508109 2508109 defendant Strayn John husbandman 623186 623186 Strayn, John, of Ulnehale, 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);