names

22 rows where place_id = 607800

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670819 1916838 1916838 defendant Brendwood John husbandman 607800 607800 Brendwood, John, of Berdewell, husbandman 0
3745884 1940618 1940618 defendant Parken John husbandman 607800 607800 Parken, John, of Berdewell, husbandman 0
4463373 2189235 2189235 defendant Barkere Hugh   607800 607800 Barkere, Hugh, of Berdewell 0
4498936 2200306 2200306 defendant Flye Hugh miller 607800 607800 Flye, Hugh, of Berdewell, miller 1
4733769 2275743 2275743 defendant souser John   607800 607800 souser, John, of Berdewell, vicar 0
4733770 2275743 2275743 defendant North John husbandman 607800 607800 North, John, of Berdewell, husbandman 1
4737394 2276812 2276812 defendant Parmafey John yeoman 607800 607800 Parmafey, John, of Berdewell, yeoman 0
4749372 2280296 2280296 defendant Ingelond Thomas yeoman 607800 607800 Ingelond, Thomas, of Berdewell, yeoman 0
4762091 2284129 2284129 defendant Rudham Walter   607800 607800 Rudham, Walter, of Berdewell 0
4762092 2284129 2284129 defendant Parmafay John   607800 607800 Parmafay, John, of Berdewell 1
4762099 2284129 2284129 defendant Souser John   607800 607800 Souser, John, of Berdewell, vicar 8
4885570 2322367 2322367 defendant Hert John husbandman 607800 607800 Hert, John, of Berdewell, husbandman 1
4889528 2323522 2323522 defendant Berdewell William esq 607800 607800 Berdewell, William, of Berdewell, esq 0
4890446 2323779 2323779 defendant Purpyll John yeoman 607800 607800 Purpyll, John, of Berdewell, yeoman 4
4891082 2323951 2323951 defendant Purpyll John yeoman 607800 607800 Purpyll, John, of Berdewell, yeoman 4
4898493 2326179 2326179 defendant Hert John yeoman 607800 607800 Hert, John, of Berdewell, yeoman 1
4898494 2326179 2326179 defendant Syre Walter yeoman 607800 607800 Syre, Walter, of Berdewell, yeoman 2
4934242 2337098 2337098 defendant Hert John carpenter 607800 607800 Hert, John, of Berdewell, carpenter 0
4948167 2341399 2341399 defendant Hyggelond John husbandman 607800 607800 Hyggelond, John, of Berdewell, husbandman 3
5136008 2397042 2397042 defendant Spencer John mercer 607800 607800 Spencer, John, of Berdewell, mercer 0
5285802 2440873 2440873 defendant Sponer William husbandman 607800 607800 Sponer, William, of Berdewell, husbandman 0
5570853 2526031 2526031 defendant Wyndowe John (legal representative) 607800 607800 Wyndowe, John, of Berdewell, chaplain, 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);