names

14 rows where case_id = 1909792

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648064 1909792 1909792 plaintiff Melton John esq   Melton, John, esq 0
3648065 1909792 1909792 defendant Sheffeld John husbandman 602021 602021 Sheffeld, John, of Beghton, Derbs, husbandman 0
3648066 1909792 1909792 defendant Shemeld Christopher husbandman 602022 602022 Shemeld, Christopher, of Beghton, husbandman 1
3648067 1909792 1909792 defendant Mylner William husbandman   Mylner, William, husbandman 2
3648068 1909792 1909792 defendant Thomson George glover   Thomson, George, glover 3
3648069 1909792 1909792 defendant Wengard Thomas yeoman   Wengard, Thomas, yeoman 4
3648070 1909792 1909792 defendant Stubbynges William yeoman   Stubbynges, William, yeoman 5
3648071 1909792 1909792 defendant Arnold Thomas husbandman   Arnold, Thomas, husbandman 6
3648072 1909792 1909792 defendant Blyth Roger yeoman   Blyth, Roger, yeoman 7
3648073 1909792 1909792 defendant Grene John yeoman   Grene, John, yeoman 8
3648074 1909792 1909792 defendant Machon William husbandman   Machon, William, husbandman 9
3648075 1909792 1909792 defendant Clerke John yeoman   Clerke, John, yeoman 10
3648076 1909792 1909792 defendant Grenes Robert husbandman   Grenes, Robert, husbandman 11
3648077 1909792 1909792 defendant Treton John husbandman 602022 602022 Treton, John, of Beghton, husbandman 12

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