names

15 rows where case_id = 2248052

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4656885 2248052 2248052 plaintiff Cheverell John     Cheverell, John 0
4656886 2248052 2248052 defendant Asshelyn John, senior     Asshelyn, John, senior 0
4656887 2248052 2248052 defendant Gomayde John   597821 597821 Gomayde, John, of Evershete 1
4656888 2248052 2248052 defendant Gardiner John   762198 762198 Gardiner, John, of Bemestre 2
4656889 2248052 2248052 defendant Carter Walter   641175 641175 Carter, Walter, of Knyghton 3
4656890 2248052 2248052 defendant Hacche Richard   596420 596420 Hacche, Richard, of Somerset, mason 4
4656891 2248052 2248052 defendant Turnour Peter   778820 778820 Turnour, Peter, of Mersshwode Wale 5
4656892 2248052 2248052 defendant Melbury Edmund tailor   Melbury, Edmund, tailor 6
4656893 2248052 2248052 defendant Wolf Richard   622259 622259 Wolf, Richard, of Aulton 7
4656894 2248052 2248052 defendant Trent John   598043 598043 Trent, John, of Cerne 8
4656895 2248052 2248052 defendant Curteys William   586344 586344 Curteys, William, of Burton 9
4656896 2248052 2248052 defendant Smyth John, junior   632055 632055 Smyth, John, junior, of Shirborn 10
4656897 2248052 2248052 defendant Fogge John dyer 758362 758362 Fogge, John, of Dorchestre, dyer 11
4656898 2248052 2248052 defendant Short William   593064 593064 Short, William, of Blakemore 12
4656899 2248052 2248052 defendant Wodeward Robert   651985 651985 Wodeward, Robert, of Mynterne 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);