names

15 rows where case_id = 2348150

✎ 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
4970608 2348150 2348150 plaintiff Heron John esq   Heron, John, esq 0
4970609 2348150 2348150 defendant Thomson John yeoman 762689 762689 Thomson, John, of Rouchestre, yeoman 0
4970610 2348150 2348150 defendant Dixson Robert yeoman 828872 828872 Dixson, Robert, of Baronesford, yeoman 1
4970611 2348150 2348150 defendant Wode William yeoman 600732 600732 Wode, William, of Edyngton, yeoman 2
4970612 2348150 2348150 defendant Fresell Roland yeoman 616005 616005 Fresell, Roland, of Rotheley, yeoman 3
4970613 2348150 2348150 defendant Clerk William yeoman 694026 694026 Clerk, William, of Gosford, yeoman 4
4970614 2348150 2348150 defendant Hogge Thomas yeoman 605432 605432 Hogge, Thomas, of Cramlyngton, yeoman 5
4970615 2348150 2348150 defendant Matheweson John yeoman 828873 828873 Matheweson, John, of Esshet, yeoman 6
4970616 2348150 2348150 defendant Borewell Richard yeoman 828873 828873 Borewell, Richard, of Esshet, yeoman 7
4970617 2348150 2348150 defendant More Robert yeoman 593193 593193 More, Robert, of Braunton, yeoman 8
4970618 2348150 2348150 defendant Ogle Thomas yeoman 791054 791054 Ogle, Thomas, of Rothebery, yeoman 9
4970619 2348150 2348150 defendant Redell William yeoman 595857 595857 Redell, William, of Alnewyk, yeoman 10
4970620 2348150 2348150 defendant Rogerson John yeoman 595857 595857 Rogerson, John, of Alnewyk, yeoman 11
4970621 2348150 2348150 defendant Crankeston Nicholas yeoman 599046 599046 Crankeston, Nicholas, of Ford, yeoman 12
4970622 2348150 2348150 defendant Forster John yeoman 828874 828874 Forster, John, of Cornell, yeoman 13

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