names

14 rows where place_id = 754283

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4419081 2170832 2170832 defendant Peroun John   754283 754283 Peroun, John, of Rouceby 2
4482954 2195365 2195365 plaintiff Multon Gilbert de   754283 754283 Multon, Gilbert de, of Rouceby 0
4492514 2198348 2198348 defendant Umfray John   754283 754283 Umfray, John, of Rouceby, vicar, on his own account 0
4510818 2203841 2203841 defendant Tirell William   754283 754283 Tirell, William, of Rouceby 0
4511212 2203952 2203952 defendant Osberne John   754283 754283 Osberne, John, of Rouceby 1
4529744 2209586 2209586 defendant Umfray John   754283 754283 Umfray, John, of Rouceby, vicar 0
4534978 2211220 2211220 defendant Umgray John   754283 754283 Umgray, John, of Rouceby, parson 0
4571685 2222722 2222722 defendant Skeggeby John   754283 754283 Skeggeby, John, of Rouceby 0
4591895 2228818 2228818 plaintiff Multon Gilbert   754283 754283 Multon, Gilbert, of Rouceby 0
4624151 2238533 2238533 plaintiff Multon Gilbert de   754283 754283 Multon, Gilbert de, of Rouceby 0
4707993 2267872 2267872 plaintiff Multon Gilbert de   754283 754283 Multon, Gilbert de, of Rouceby 0
4834079 2306666 2306666 defendant Bevenshire John husbandman 754283 754283 Bevenshire, John, of Rouceby, husbandman 0
5166496 2405922 2405922 defendant Thomson John husbandman 754283 754283 Thomson, John, of Rouceby, husbandman 17
5166497 2405922 2405922 defendant Bulman William husbandman 754283 754283 Bulman, William, of Rouceby, husbandman 18

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);