names

17 rows where place_id = 655085

✎ 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
3934843 2001955 2001955 defendant Bassett Thomas yeoman & beer brewer 655085 655085 Bassett, Thomas, of Marche, Cambs, yeoman & beer brewer 0
3940409 2003810 2003810 defendant Makrell Clement chapman 655085 655085 Makrell, Clement, of Marche, Cambs, chapman 0
4681159 2259734 2259734 defendant Spynk John husbandman 655085 655085 Spynk, John, of Marche, Cambs, husbandman 0
4928038 2335202 2335202 defendant Payn William yeoman 655085 655085 Payn, William, of Marche, Cambs, yeoman 0
4931100 2336118 2336118 defendant Colvyle John gent 655085 655085 Colvyle, John, of Marche, Cambs, gent 3
5003796 2358000 2358000 defendant Payn William husbandman 655085 655085 Payn, William, of Marche, Cambs, husbandman 0
5004764 2358298 2358298 defendant Hill John husbandman 655085 655085 Hill, John, of Marche, Cambs, husbandman 1
5004769 2358298 2358298 defendant Went Robert yeoman 655085 655085 Went, Robert, of Marche, Cambs, yeoman 6
5004795 2358302 2358302 defendant Hyll John husbandman 655085 655085 Hyll, John, of Marche, Cambs, husbandman 1
5004799 2358302 2358302 defendant Weng Robert yeoman 655085 655085 Weng, Robert, of Marche, Cambs, yeoman 5
5154538 2402480 2402480 defendant Lythold John husbandman 655085 655085 Lythold, John, of Marche, Cambs, husbandman 0
5171592 2407411 2407411 defendant Lythold John husbandman 655085 655085 Lythold, John, of Marche, Cambs, husbandman 0
5274591 2437650 2437650 defendant Southwold John yeoman 655085 655085 Southwold, John, of Marche, Cambs, yeoman 0
5381836 2469862 2469862 defendant Walbot William brewer 655085 655085 Walbot, William, of Marche, Cambs, brewer 1
5389943 2472187 2472187 defendant Walbot William brewer 655085 655085 Walbot, William, of Marche, Cambs, brewer 0
5452636 2490673 2490673 defendant Bole William husbandman 655085 655085 Bole, William, of Marche, Cambs, husbandman 0
5464584 2494325 2494325 defendant Bole William husbandman 655085 655085 Bole, William, of Marche, 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);