names

16 rows where case_id = 1905977

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3635725 1905977 1905977 plaintiff Percy Henry Earl of Northumberland   Percy, Henry, Earl of Northumberland 0
3635726 1905977 1905977 defendant Wylson John husbandman 599205 599205 Wylson, John, of Talentyre, husbandman 0
3635727 1905977 1905977 defendant Matson John husbandman 599205 599205 Matson, John, of Talentyre, husbandman 1
3635728 1905977 1905977 defendant Faunce John     Faunce, John 2
3635729 1905977 1905977 defendant Dogeson John     Dogeson, John 3
3635730 1905977 1905977 defendant Hope John     Hope, John 4
3635731 1905977 1905977 defendant Bacon Roger     Bacon, Roger 5
3635732 1905977 1905977 defendant Brygge Henry     Brygge, Henry 6
3635733 1905977 1905977 defendant Robynson William     Robynson, William 7
3635734 1905977 1905977 defendant Suresby Thomas     Suresby, Thomas 8
3635735 1905977 1905977 defendant Palmer Thomas     Palmer, Thomas 9
3635736 1905977 1905977 defendant Faunce Thomas     Faunce, Thomas 10
3635737 1905977 1905977 defendant Dogeson William     Dogeson, William 11
3635738 1905977 1905977 defendant Suresby John     Suresby, John 12
3635739 1905977 1905977 defendant Palmer John     Palmer, John 13
3635740 1905977 1905977 defendant Dogeson John husbandman 599205 599205 Dogeson, John, of Talentyre, husbandman 14

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