names

15 rows where case_id = 2242045

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4635814 2242045 2242045 plaintiff Armeston William     Armeston, William 0
4635815 2242045 2242045 plaintiff Puttes Richard     Puttes, Richard 1
4635816 2242045 2242045 defendant Dodyngton Robert mason   Dodyngton, Robert, mason 0
4635817 2242045 2242045 defendant Hawe John smith   Hawe, John, smith 1
4635818 2242045 2242045 defendant Gilson John     Gilson, John 2
4635819 2242045 2242045 defendant Doe Thomas     Doe, Thomas 3
4635820 2242045 2242045 defendant Phelip William     Phelip, William 4
4635821 2242045 2242045 defendant Couper John   624138 624138 Couper, John, of Brigstoke 5
4635822 2242045 2242045 defendant atte Kirke Richard     atte Kirke, Richard 6
4635823 2242045 2242045 defendant Tubbe Richard     Tubbe, Richard 7
4635824 2242045 2242045 defendant Darcy Richard thatcher   Darcy, Richard, thatcher 8
4635825 2242045 2242045 defendant Tukke Henry     Tukke, Henry 9
4635826 2242045 2242045 defendant Dye John   776620 776620 Dye, John, of Bridstoke 10
4635827 2242045 2242045 defendant Giles John     Giles, John 11
4635828 2242045 2242045 defendant Giles Thomas   624138 624138 Giles, Thomas, of Brigstoke 12

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