names

17 rows where case_id = 2442845

✎ 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
5292634 2442845 2442845 plaintiff Salkeld Richard     Salkeld, Richard 0
5292635 2442845 2442845 defendant Skelton Clement esq 869474 869474 Skelton, Clement, of Thistylthwayte, esq 0
5292636 2442845 2442845 defendant Fenton William yeoman 778235 778235 Fenton, William, of Petrelwra, yeoman 1
5292637 2442845 2442845 defendant James John yeoman 778235 778235 James, John, of Petrelwra, yeoman 2
5292638 2442845 2442845 defendant Meryman Thomas yeoman 778235 778235 Meryman, Thomas, of Petrelwra, yeoman 3
5292639 2442845 2442845 defendant Edmell John yeoman 778235 778235 Edmell, John, of Petrelwra, yeoman 4
5292640 2442845 2442845 defendant Donkan Patonus yeoman 778235 778235 Donkan, Patonus, of Petrelwra, yeoman 5
5292641 2442845 2442845 defendant Donkan Andrew yeoman 778235 778235 Donkan, Andrew, of Petrelwra, yeoman 6
5292642 2442845 2442845 defendant Scot William yeoman 778235 778235 Scot, William, of Petrelwra, yeoman 7
5292643 2442845 2442845 defendant Stevenson Richard yeoman 869475 869475 Stevenson, Richard, of Jeegyll, yeoman 8
5292644 2442845 2442845 defendant Bristowe John yeoman 869476 869476 Bristowe, John, of Kirkethwayte, yeoman 9
5292645 2442845 2442845 defendant Rothburn William yeoman 869476 869476 Rothburn, William, of Kirkethwayte, yeoman 10
5292646 2442845 2442845 defendant Robankys Thomas yeoman 591223 591223 Robankys, Thomas, of Soureby, yeoman 11
5292647 2442845 2442845 defendant Symson William yeoman 869477 869477 Symson, William, of Raughtonhed, yeoman 12
5292648 2442845 2442845 defendant Tomlynson William yeoman 600085 600085 Tomlynson, William, of Haukesdale, yeoman 13
5292649 2442845 2442845 defendant Hall Richard yeoman 600085 600085 Hall, Richard, of Haukesdale, yeoman 14
5292650 2442845 2442845 defendant Doughty Thomas yeoman 600085 600085 Doughty, Thomas, of Haukesdale, yeoman 15

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