names

13 rows where case_id = 2348016

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4970120 2348016 2348016 plaintiff Harecourt Robert knight   Harecourt, Robert, knight 0
4970121 2348016 2348016 defendant Acton Richard esq 817417 817417 Acton, Richard, of Potters Merston, Leics, esq 0
4970122 2348016 2348016 defendant Waleys John gent 784418 784418 Waleys, John, of Wygeston, Leics, gent 1
4970123 2348016 2348016 defendant Wystowe Thomas   678410 678410 Wystowe, Thomas, of Foston, Leics, franklin 2
4970124 2348016 2348016 defendant Cok William   779025 779025 Cok, William, of Hynkeley, Leics, franklin 3
4970125 2348016 2348016 defendant Chapman John   624812 624812 Chapman, John, of Foxton, leics, franklon 4
4970126 2348016 2348016 defendant Desford Robert yeoman 666320 666320 Desford, Robert, of Desford, Leics, yeoman 5
4970127 2348016 2348016 defendant Lussell William husbandman 639693 639693 Lussell, William, of Walton, Leics, husbandman 6
4970128 2348016 2348016 defendant Fresseby Thomas yeoman 828812 828812 Fresseby, Thomas, of Carlton, Leics, yeoman 7
4970129 2348016 2348016 defendant Bailly John husbandman 828813 828813 Bailly, John, of Hygham, Leics, husbandman 8
4970130 2348016 2348016 defendant Laye John husbandman 796602 796602 Laye, John, of Burton Overay, Leics, husbandman 9
4970131 2348016 2348016 defendant Symmes John husbandman 828814 828814 Symmes, John, of Galby, Leics, husbandman 10
4970132 2348016 2348016 defendant Hotofte Richard esq 645998 645998 Hotofte, Richard, of Humbreston, Leics, esq 11

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