names

15 rows where case_id = 2281479

✎ 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
4753517 2281479 2281479 plaintiff Warrewik George de     Warrewik, George de, on his own account 0
4753518 2281479 2281479 defendant Patonson Thomas yeoman 764652 764652 Patonson, Thomas, of Corkby, yeoman 0
4753519 2281479 2281479 defendant Peresson Simon yeoman 764652 764652 Peresson, Simon, of Corkby, yeoman 1
4753520 2281479 2281479 defendant Morgan William yeoman 796957 796957 Morgan, William, of Wederhell, yeoman 2
4753521 2281479 2281479 defendant Bury Robert of Carlisle yeoman   Bury, Robert of Carlisle, yeoman 3
4753522 2281479 2281479 defendant Scologg Thomas yeoman 796958 796958 Scologg, Thomas, of Little Corkby, yeoman 4
4753523 2281479 2281479 defendant Temple John de yeoman 796958 796958 Temple, John de, of Little Corkby, yeoman 5
4753524 2281479 2281479 defendant Edmundson William yeoman 796958 796958 Edmundson, William, of Little Corkby, yeoman 6
4753525 2281479 2281479 defendant Derman Thomas yeoman 796958 796958 Derman, Thomas, of Little Corkby, yeoman 7
4753526 2281479 2281479 defendant Sparought John ofCrosseby, yeoman   Sparought, John, ofCrosseby, yeoman 8
4753527 2281479 2281479 defendant Doweson William yeoman 765096 765096 Doweson, William, of Crosseby, yeoman 9
4753528 2281479 2281479 defendant Henryson John yeoman 765096 765096 Henryson, John, of Crosseby, yeoman 10
4753529 2281479 2281479 defendant Bakhous Robert de yeoman 782756 782756 Bakhous, Robert de, of Aykton, yeoman 11
4753530 2281479 2281479 defendant Borugh John de yeoman 782756 782756 Borugh, John de, of Aykton, yeoman 12
4753531 2281479 2281479 defendant del Hall John yeoman 796959 796959 del Hall, John, of Aytkon, 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);