names

17 rows where place_id = 760385

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4469528 2191133 2191133 defendant Baldery guy   760385 760385 Baldery, guy, of Crydyton 0
4673536 2257353 2257353 defendant Auvelmaker John smith 760385 760385 with Auvelmaker, John, of Crydyton, smith 1
4685864 2261170 2261170 defendant Brere Hugh husbandman 760385 760385 Brere, Hugh, of Crydyton, husbandman 0
4778142 2289155 2289155 defendant Wodelegh Joan   760385 760385 Wodelegh, Joan, of Crydyton, "chapman" 0
4778145 2289155 2289155 defendant Noreys Roger husbandman 760385 760385 Noreys, Roger, of Crydyton, husbandman 3
4793749 2294162 2294162 defendant atte Forde Henry husbandman 760385 760385 atte Forde, Henry, of Crydyton, husbandman 4
4861253 2314886 2314886 defendant Dery John laborer 760385 760385 Dery, John, of Crydyton, laborer 0
5028135 2365100 2365100 defendant Whyte John tinker 760385 760385 Whyte, John, of Crydyton, tinker 0
5103023 2387307 2387307 defendant Deyman William yeoman 760385 760385 Deyman, William, of Crydyton, yeoman 1
5110503 2389474 2389474 defendant Payle John chaplain 760385 760385 Payle, John, of Crydyton,chaplain 0
5224393 2422811 2422811 defendant Corun John tucker 760385 760385 Corun, John, of Crydyton, tucker 0
5233153 2425284 2425284 plaintiff Carpenter William (legal representative) 760385 760385 Carpenter, William, of Crydyton, executors of 0
5278961 2438958 2438958 defendant Laxkey Thomas husbandman 760385 760385 Laxkey, Thomas, of Crydyton, husbandman 0
5278963 2438959 2438959 defendant Laxky Thomas husbandman 760385 760385 Laxky, Thomas, of Crydyton, husbandman 0
5336013 2455844 2455844 defendant Ganet John hooper 760385 760385 Ganet, John, of Crydyton, hooper 0
5339902 2457048 2457048 defendant Kent William butcher 760385 760385 Kent, William, of Crydyton, butcher 0
5505323 2506575 2506575 defendant Colbeare Stephen baker 760385 760385 Colbeare, Stephen, of Crydyton, baker 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);