names

18 rows where place_id = 604378

✎ 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
3657833 1912700 1912700 defendant Federston John yeoman 604378 604378 Federston, John, of Wilberfosse, yeoman 0
3819464 1963972 1963972 defendant Drury William yeoman 604378 604378 Drury, William, of Wilberfosse, yeoman 0
4360628 2150970 2150970 defendant Goulthwayt Nicholas husbandman 604378 604378 Goulthwayt, Nicholas, of Wilberfosse, husbandman 0
4455507 2186728 2186728 defendant Danby John   604378 604378 Danby, John, of Wilberfosse 0
4455509 2186728 2186728 defendant Brumfleyte Emma   604378 604378 Brumfleyte, Emma, of Wilberfosse 2
4459510 2188028 2188028 defendant atte Esshe Richard   604378 604378 atte Esshe, Richard, of Wilberfosse 1
4459511 2188028 2188028 defendant atte Esshe William   604378 604378 atte Esshe, William, of Wilberfosse 2
4550357 2216053 2216053 defendant Wrygh Simon   604378 604378 Wrygh, Simon, of Wilberfosse 1
4789399 2292750 2292750 defendant Brid James gent 604378 604378 Brid, James, of Wilberfosse, gent 1
4813994 2300486 2300486 plaintiff Nikson Thomas   604378 604378 Nikson, Thomas, of Wilberfosse 5
4840685 2308626 2308626 plaintiff Tailour Robert   604378 604378 Tailour, Robert, of Wilberfosse 6
5033486 2366678 2366678 plaintiff Smyth William (legal representative) 604378 604378 Smyth, William, of Wilberfosse, executors of 0
5091655 2383949 2383949 plaintiff Nikson Thomas   604378 604378 Nikson, Thomas, of Wilberfosse 0
5098149 2385892 2385892 plaintiff Tyndale Thomas yeoman 604378 604378 Tyndale, Thomas, of Wilberfosse, yeoman 0
5107062 2388496 2388496 defendant Fox Thomas husbandman 604378 604378 Fox, Thomas, of Wilberfosse, husbandman 5
5111801 2389843 2389843 defendant Wilberfosse alias Taillour John tailor or yeoman 604378 604378 Wilberfosse alias Taillour, John, of Wilberfosse, tailor or yeoman 0
5111802 2389843 2389843 defendant Drewery John husbandman 604378 604378 Drewery, John, of Wilberfosse, husbandman 1
5116204 2391168 2391168 plaintiff Nykson Thomas yeoman 604378 604378 Nykson, Thomas, of Wilberfosse, 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);