names

21 rows where place_id = 791333

✎ 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
4723405 2272630 2272630 defendant Arnold William husbandman 791333 791333 Arnold, William, of Kyrkton in Holand, husbandman 0
4799348 2295972 2295972 defendant Heyland John husbandman 791333 791333 Heyland, John, of Kyrkton in Holand, husbandman 0
4902402 2327367 2327367 defendant Preston John husbandman 791333 791333 Preston, John, of Kyrkton in Holand, husbandman 0
4902403 2327367 2327367 defendant Hardpene Thomas husbandman 791333 791333 Hardpene, Thomas, of Kyrkton in Holand, husbandman 1
4930139 2335834 2335834 plaintiff Thomson John   791333 791333 Thomson, John, of Kyrkton in Holand, son of Alan Thomson 0
5129013 2394970 2394970 plaintiff Covyn Alan merchant 791333 791333 Covyn, Alan, of Kyrkton in Holand, merchant 0
5155201 2402670 2402670 defendant Wardon William butcher 791333 791333 Wardon, William, of Kyrkton in Holand, butcher 0
5171929 2407505 2407505 defendant Wardon William butcher 791333 791333 Wardon, William, of Kyrkton in Holand, butcher 0
5171930 2407505 2407505 defendant Robert William husbandman 791333 791333 Robert, William, of Kyrkton in Holand, husbandman 1
5207052 2417799 2417799 defendant Wardon William butcher 791333 791333 Wardon, William, of Kyrkton in Holand, butcher 0
5207053 2417799 2417799 defendant Robert William husbandman 791333 791333 Robert, William, of Kyrkton in Holand, husbandman 1
5207054 2417799 2417799 defendant Hopkynson William husbandman 791333 791333 Hopkynson, William, of Kyrkton in Holand, husbandman 2
5315623 2449734 2449734 defendant Claymond William husbandman 791333 791333 Claymond, William, of Kyrkton in Holand, husbandman 14
5349238 2459891 2459891 defendant Thomson Alan yeoman 791333 791333 Thomson, Alan, of Kyrkton in Holand, yeoman 0
5398492 2474628 2474628 plaintiff Conyng John (legal representative) 791333 791333 Conyng, John, of Kyrkton in Holand, gent, executors of 0
5402389 2475757 2475757 defendant Ordyng William yeoman 791333 791333 Ordyng, William, of Kyrkton in Holand, yeoman 0
5402392 2475757 2475757 defendant Spenlove Thomas husbandman 791333 791333 Spenlove, Thomas, of Kyrkton in Holand, husbandman 3
5406699 2476982 2476982 defendant Heleand Thomas yeoman 791333 791333 Heleand, Thomas, of Kyrkton in Holand, yeoman 2
5419853 2480853 2480853 defendant Heland Thomas yeoman 791333 791333 Heland, Thomas, of Kyrkton in Holand, yeoman 2
5438386 2486413 2486413 defendant Heland Thomas yeoman 791333 791333 Heland, Thomas, of Kyrkton in Holand, yeoman 2
5444231 2488182 2488182 plaintiff Conyng John (legal representative) 791333 791333 Conyng, John, of Kyrkton in Holand, gent, executors of 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);