names

10 rows where place_id = 624525

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3758668 1944705 1944705 defendant Massy Thomas husbandman 624525 624525 Massy, Thomas, of Sudbury, Derbs, husbandman 1
3821960 1964762 1964762 defendant Lorde Humphrey yeoman 624525 624525 Lorde, Humphrey, of Sudbury, Derbs, yeoman 0
3825551 1965845 1965845 defendant Ashton William smith 624525 624525 Ashton, William, of Sudbury, Derbs, smith 1
3896907 1989178 1989178 defendant Fawkener Thomas husbandman 624525 624525 Fawkener, Thomas, of Sudbury, Derbs, husbandman 0
3983710 2018946 2018946 defendant Vernon Henry esq 624525 624525 Vernon, Henry, of Sudbury, Derbs, esq 0
4038564 2038432 2038432 defendant Vernon John gent 624525 624525 Vernon, John, of Sudbury, Derbs, gent 0
4323903 2138405 2138405 defendant Boyer Thomas yeoman 624525 624525 Boyer, Thomas, of Sudbury, Derbs, or of London, yeoman 0
5239420 2427111 2427111 defendant Decun William laborer 624525 624525 Decun, William, of Sudbury, Derbs, laborer 5
5280701 2439431 2439431 defendant Agard Nicholas gent 624525 624525 Agard, Nicholas, of Sudbury, Derbs, gent 0
5311782 2448551 2448551 defendant Agard Nicholas esq 624525 624525 Agard, Nicholas, of Sudbury, Derbs, esq 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);