names

8 rows where case_id = 2248207

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4657398 2248207 2248207 plaintiff Clynton William knight   Clynton, William, knight 0
4657399 2248207 2248207 defendant Jeke Henry yeoman 591261 591261 Jeke, Henry, of Tamworth, Staffs, yeoman 0
4657400 2248207 2248207 defendant Jeke William yeoman 629017 629017 Jeke, William, of Wyggeston, Leics, yeoman 1
4657401 2248207 2248207 defendant Bowyer John yeoman 586028 586028 Bowyer, John, of Tamworth, yeoman 2
4657402 2248207 2248207 defendant Stedeman John sawyer 586028 586028 Stedeman, John, of Tamworth, sawyer 3
4657403 2248207 2248207 defendant John that was Henryservant Taillour of Tamworth tailor   John that was Henryservant Taillour, of Tamworth, tailor 4
4657404 2248207 2248207 defendant Juet Thomas laborer 586028 586028 Juet, Thomas, of Tamworth, laborer 5
4657405 2248207 2248207 defendant Keesley John   778900 778900 Keesley, John, of Magna Amynton, stone breaker 6

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