names

13 rows where case_id = 1985278

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3885104 1985278 1985278 plaintiff Baker Thomas     Baker, Thomas 0
3885105 1985278 1985278 defendant Thurmonde Thomas yeoman 613394 613394 Thurmonde, Thomas, of Chesterford Magna, Essex, yeoman 0
3885106 1985278 1985278 defendant Colfeld John yeoman 600722 600722 Colfeld, John, of Henham, Essex, yeoman 1
3885107 1985278 1985278 defendant Felsted Nicholas yeoman 645345 645345 Felsted, Nicholas, of Magna Wenden, essex, yeoman 2
3885108 1985278 1985278 defendant Henworthe Thomas yeoman 637066 637066 Henworthe, Thomas, of Bromefeld, Essex, yeoman 3
3885109 1985278 1985278 defendant Coolyn John yeoman 645346 645346 Coolyn, John, of Magna Donmowe, Essex, yeoman 4
3885110 1985278 1985278 defendant Appleby John yeoman 642765 642765 Appleby, John, of Ingerston, Essex, yeoman 5
3885111 1985278 1985278 defendant Clerke Christopher yeoman 601544 601544 Clerke, Christopher, of Chelmysford, yeoman 6
3885112 1985278 1985278 defendant Gent William yeoman 645347 645347 Gent, William, of Bumpsted by the Tower, Essex, yeoman 7
3885113 1985278 1985278 defendant Candeler John yeoman 645348 645348 Candeler, John, of Magna Warley, Essex, yeoman 8
3885114 1985278 1985278 defendant Corall John yeoman 645349 645349 Corall, John, of Brentwood Weld, Essex, yeoman 9
3885115 1985278 1985278 defendant Seyntle Thomas yeoman 645350 645350 Seyntle, Thomas, of Lachendon, Essex, yeoman 10
3885116 1985278 1985278 defendant Stephyn Thomas yeoman 592247 592247 Stephyn, Thomas, of Tyllyngham, Essex, yeoman 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);