names

21 rows where case_id = 1971819

✎ 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
3844481 1971819 1971819 plaintiff Dacre Christopher knight   Dacre, Christopher, knight 0
3844482 1971819 1971819 defendant Graym George yeoman 638726 638726 Graym, George, of Hartregh Holm, yeoman 0
3844483 1971819 1971819 defendant Story Edward yeoman 638726 638726 Story, Edward, of Hartregh Holm, yeoman 1
3844484 1971819 1971819 defendant Story George yeoman 638726 638726 Story, George, of Hartregh Holm, yeoman 2
3844485 1971819 1971819 defendant Corry Edward yeoman 638727 638727 Corry, Edward, of Randelynton, yeoman 3
3844486 1971819 1971819 defendant Corry John yeoman 638727 638727 Corry, John, of Randelynton, yeoman 4
3844487 1971819 1971819 defendant Gurley Gilbert yeoman 638727 638727 Gurley, Gilbert, of Randelynton, yeoman 5
3844488 1971819 1971819 defendant Bell James yeoman 638728 638728 Bell, James, of Austenby, yeoman 6
3844489 1971819 1971819 defendant Bell Thomas yeoman 638728 638728 Bell, Thomas, of Austenby, yeoman 7
3844490 1971819 1971819 defendant Bell Cuthbert yeoman 638728 638728 Bell, Cuthbert, of Austenby, yeoman 8
3844491 1971819 1971819 defendant Story Edmund   638729 638729 Story, Edmund, of Austenby, yeoma 9
3844492 1971819 1971819 defendant Bell Richard yeoman 638728 638728 Bell, Richard, of Austenby, yeoman 10
3844493 1971819 1971819 defendant Rychardson William yeoman 638728 638728 Rychardson, William, of Austenby, yeoman 11
3844494 1971819 1971819 defendant Syds Christopher yeoman 590660 590660 Syds, Christopher, of Carlisle, yeoman 12
3844495 1971819 1971819 defendant Barn Edward yeoman 590660 590660 Barn, Edward, of Carlisle, yeoman 13
3844496 1971819 1971819 defendant Fallder Thomas yeoman 590660 590660 Fallder, Thomas, of Carlisle, yeoman 14
3844497 1971819 1971819 defendant Rychardson William yeoman 590660 590660 Rychardson, William, of Carlisle, yeoman 15
3844498 1971819 1971819 defendant Hereman Thomas yeoman 590660 590660 Hereman, Thomas, of Carlisle, yeoman 16
3844499 1971819 1971819 defendant Clementson Robert yeoman 590660 590660 Clementson, Robert, of Carlisle, yeoman 17
3844500 1971819 1971819 defendant Stoddert Nicholas yeoman 590660 590660 Stoddert, Nicholas, of Carlisle, yeoman 18
3844501 1971819 1971819 defendant Person William yeoman 590660 590660 Person, William, of Carlisle, yeoman 19

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