names

26 rows where case_id = 2326514

✎ 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
4899599 2326514 2326514 plaintiff Skelton John knight   Skelton, John, knight 0
4899600 2326514 2326514 defendant Beauchamp Roger gent 590660 590660 Beauchamp, Roger, of Carlisle, gent 0
4899601 2326514 2326514 defendant Carleton Thomas gent 586121 586121 Carleton, Thomas, of Carleton, gent 1
4899602 2326514 2326514 defendant Hoton John gent 758826 758826 Hoton, John, of Hoton in the Forest, gent 2
4899603 2326514 2326514 defendant Sewell Adaam yeoman 819079 819079 Sewell, Adaam, of Hubrightby, yeoman 3
4899604 2326514 2326514 defendant Hoggesson John yeoman 595423 595423 Hoggesson, John, of Skelton, yeoman 4
4899605 2326514 2326514 defendant Jonson William yeoman 595423 595423 Jonson, William, of Skelton, yeoman 5
4899606 2326514 2326514 defendant Walker Robert yeoman 595423 595423 Walker, Robert, of Skelton, yeoman 6
4899607 2326514 2326514 defendant Walker Thomas yeoman 595423 595423 Walker, Thomas, of Skelton, yeoman 7
4899608 2326514 2326514 defendant Hudson Thomas yeoman 595423 595423 Hudson, Thomas, of Skelton, yeoman 8
4899609 2326514 2326514 defendant Whitelok Alice   595423 595423 Whitelok, Alice, of Skelton, widow of Whitelok, Thomas 9
4899610 2326514 2326514 defendant Bourebank Thomas yeoman 819081 819081 Bourebank, Thomas, of Blenkowe, yeoman 10
4899611 2326514 2326514 defendant Gybson Thomas yeoman 819081 819081 Gybson, Thomas, of Blenkowe, yeoman 11
4899612 2326514 2326514 defendant Robynson John yeoman 819081 819081 Robynson, John, of Blenkowe, yeoman 12
4899613 2326514 2326514 defendant Burgh Robert yeoman 587559 587559 Burgh, Robert, of Bampton, yeoman 13
4899614 2326514 2326514 defendant Gray John yeoman 819082 819082 Gray, John, of Langomby, yeoman 14
4899615 2326514 2326514 defendant Cherden John yeoman 590660 590660 Cherden, John, of Carlisle, yeoman 15
4899616 2326514 2326514 defendant Brisby Simon yeoman 819083 819083 Brisby, Simon, of Sotheronby, yeoman 16
4899617 2326514 2326514 defendant Hewetson Robert yeoman 819084 819084 Hewetson, Robert, of Rukcrofte, yeoman 17
4899618 2326514 2326514 defendant Walker John yeoman 778236 778236 Walker, John, of Kirkeswald, yeoman 18
4899619 2326514 2326514 defendant Lyndelay William yeoman 635763 635763 Lyndelay, William, of Salkeld, yeoman 19
4899620 2326514 2326514 defendant Smythson Thomas yeoman 819085 819085 Smythson, Thomas, of Hardrigge, yeoman 20
4899621 2326514 2326514 defendant Cutbersom William yeoman 758826 758826 Cutbersom, William, of Hoton in the Forest, yeoman 21
4899622 2326514 2326514 defendant Henryson Thomas yeoman 819086 819086 Henryson, Thomas, of Gayteskales, yeoman 22
4899623 2326514 2326514 defendant Raynaldson Thomas yeoman 600085 600085 Raynaldson, Thomas, of Haukesdale, yeoman 23
4899624 2326514 2326514 defendant del Spetell John yeoman 819087 819087 del Spetell, John, of Kyrkeby Thure, Westmor, yeoman 24

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