names

15 rows where case_id = 2548458

✎ 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
5614890 2548458 2548458 plaintiff (not given)   abbot of Fountains Abbey   Fountains Abbey, abbot of 0
5614891 2548458 2548458 defendant Coke William   595423 595423 Coke, William, of Skelton 0
5614892 2548458 2548458 defendant Daweson Thomas   595423 595423 Daweson, Thomas, of Skelton 1
5614893 2548458 2548458 defendant Netehird John   595423 595423 Netehird, John, of Skelton 2
5614894 2548458 2548458 defendant Sallay John de   760315 760315 Sallay, John de, of Sharowe 3
5614895 2548458 2548458 defendant Chapman John   782567 782567 Chapman, John, of Heton Conyers 4
5614896 2548458 2548458 defendant Cowehird William     Cowehird, William 5
5614897 2548458 2548458 defendant Coke William     Coke, William 6
5614898 2548458 2548458 defendant Legge Robert   769530 769530 Legge, Robert, of Hoton Conyers 7
5614899 2548458 2548458 defendant Raynson William   595423 595423 Raynson, William, of Skelton 8
5614900 2548458 2548458 defendant Raynson John   595423 595423 Raynson, John, of Skelton 9
5614901 2548458 2548458 defendant Eskilby Richard de   761289 761289 Eskilby, Richard de, of Difford 10
5614902 2548458 2548458 defendant Difford Richard de son of Richard   Difford, Richard de, son of Richard 11
5614903 2548458 2548458 defendant Ward Richard de Difford, son of John   Ward, Richard, de Difford, son of John 12
5614904 2548458 2548458 defendant Webster John   594932 594932 Webster, John, of Neuby 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);