names

22 rows where place_id = 767303

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4537864 2212127 2212127 plaintiff Tewe John   767303 767303 Tewe, John, of Wysebech, Cambs 0
4650074 2246036 2246036 defendant Loke Richard chaplain 767303 767303 Loke, Richard, of Wysebech, Cambs, chaplain 0
4699599 2265325 2265325 defendant Katesson John husbandman 767303 767303 Katesson, John, of Wysebech, Cambs, husbandman 0
4699600 2265325 2265325 defendant Perest Henry husbandman 767303 767303 Perest, Henry, of Wysebech, Cambs, husbandman 1
4730932 2274872 2274872 defendant Keep John brewer 767303 767303 Keep, John, of Wysebech, Cambs, brewer 0
4910958 2329940 2329940 defendant Sutton Geoffrey esq 767303 767303 Sutton, Geoffrey, of Wysebech, Cambs, esq 0
4924000 2333947 2333947 defendant Orlbere Richard brewer 767303 767303 Orlbere, Richard, of Wysebech, Cambs, brewer 0
4991123 2354235 2354235 defendant Tokkysforth Roger weaver 767303 767303 Tokkysforth, Roger, of Wysebech, Cambs, weaver 2
4993917 2355051 2355051 plaintiff Swan John chaplain 767303 767303 Swan, John, of Wysebech, Cambs, chaplain 1
4993918 2355051 2355051 defendant Lombe alias Edward Richard yeoman 767303 767303 Lombe alias Edward, Richard, of Wysebech, Cambs, yeoman 0
5043292 2369618 2369618 defendant Lomle Thomas yeoman 767303 767303 Lomle, Thomas, of Wysebech, Cambs, yeoman 0
5043296 2369619 2369619 defendant Taillour William husbandman 767303 767303 Taillour, William, of Wysebech, Cambs, husbandman 0
5043311 2369623 2369623 defendant Buk John draper 767303 767303 Buk, John, of Wysebech, Cambs, draper 2
5043314 2369623 2369623 defendant Clement John tanner 767303 767303 Clement, John, of Wysebech, Cambs, tanner 5
5183728 2410975 2410975 defendant Adamson John husbandman 767303 767303 Adamson, John, of Wysebech, Cambs, husbandman 0
5185194 2411417 2411417 defendant Fyssh Thomas   767303 767303 Fyssh, Thomas, of Wysebech, Cambs, mercer, executors 1
5419729 2480814 2480814 defendant Drake John butcher 767303 767303 Drake, John, of Wysebech, Cambs, butcher 0
5435008 2485398 2485398 defendant Bulwer Robert (legal representative) 767303 767303 Bulwer, Robert, of Wysebech, Cambs, husbandman, executors of 0
5435009 2485398 2485398 defendant Morlay Thomas husbandman 767303 767303 (Morlay, Thomas, of Wysebech, Cambs, husbandman 1
5450180 2489941 2489941 defendant Bulwere Robert (legal representative) 767303 767303 Bulwere, Robert, of Wysebech, Cambs, husbandman, executor of 0
5450181 2489941 2489941 defendant Morlay Thomas husbandman 767303 767303 Morlay, Thomas, of Wysebech, Cambs, husbandman 1
5462360 2493644 2493644 defendant Morley Thomas husbandman 767303 767303 (Morley, Thomas, of Wysebech, Cambs, husbandman 1

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