names

16 rows where case_id = 2362376

✎ 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
5018744 2362376 2362376 plaintiff Crakenthorp Margaret     Crakenthorp, Margaret 0
5018745 2362376 2362376 plaintiff Crakenthorp William     Crakenthorp, William 1
5018746 2362376 2362376 defendant Burcy John smith 781694 781694 Burcy, John, of Temple Soureby, smith 0
5018747 2362376 2362376 defendant Gayle William husbandman 781694 781694 Gayle, William, of Temple Soureby, husbandman 1
5018748 2362376 2362376 defendant Blamyre Richard yeoman 781694 781694 Blamyre, Richard, of Temple Soureby, yeoman 2
5018749 2362376 2362376 defendant Staple John yeoman 781694 781694 Staple, John, of Temple Soureby, yeoman 3
5018750 2362376 2362376 defendant Lonson William yeoman 781694 781694 Lonson, William, of Temple Soureby, yeoman 4
5018751 2362376 2362376 defendant Wylson John yeoman 781694 781694 Wylson, John, of Temple Soureby, yeoman 5
5018752 2362376 2362376 defendant Johnson William yeoman 781694 781694 Johnson, William, of Temple Soureby, yeoman 6
5018753 2362376 2362376 defendant Soureby Richard yeoman 781694 781694 Soureby, Richard, of Temple Soureby, yeoman 7
5018754 2362376 2362376 defendant Soureby William yeoman 781694 781694 Soureby, William, of Temple Soureby, yeoman 8
5018755 2362376 2362376 defendant Hall Richard yeoman 781694 781694 Hall, Richard, of Temple Soureby, yeoman 9
5018756 2362376 2362376 defendant Soureby John yeoman 781694 781694 Soureby, John, of Temple Soureby, yeoman 10
5018757 2362376 2362376 defendant Hertlay William yeoman 781694 781694 Hertlay, William, of Temple Soureby, yeoman 11
5018758 2362376 2362376 defendant Hall Robert yeoman 781694 781694 Hall, Robert, of Temple Soureby, yeoman 12
5018759 2362376 2362376 defendant Lambe Thomas yeoman 758643 758643 Lambe, Thomas, of Kyrkeby Stephen, 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);