names

15 rows where case_id = 2345843

✎ 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
4962969 2345843 2345843 plaintiff Burton Robert     Burton, Robert 0
4962970 2345843 2345843 defendant Keynes Nicholas     Keynes, Nicholas 0
4962971 2345843 2345843 defendant Hacche John     Hacche, John 1
4962972 2345843 2345843 defendant Bury John   772962 772962 Bury, John, of Coleton 2
4962973 2345843 2345843 defendant Tremayn Thomas     Tremayn, Thomas 3
4962974 2345843 2345843 defendant Bosse Thomas     Bosse, Thomas 4
4962975 2345843 2345843 defendant Mey William     Mey, William 5
4962976 2345843 2345843 defendant Spyre Robert     Spyre, Robert 6
4962977 2345843 2345843 defendant Trebrygge Thomas     Trebrygge, Thomas 7
4962978 2345843 2345843 defendant Wode Thomas   827963 827963 Wode, Thomas, of Putteford 8
4962979 2345843 2345843 defendant Passelewe Simon     Passelewe, Simon 9
4962980 2345843 2345843 defendant Wollecombe William     Wollecombe, William 10
4962981 2345843 2345843 defendant Lywer Walter     Lywer, Walter 11
4962982 2345843 2345843 defendant Saltern William     Saltern, William 12
4962983 2345843 2345843 defendant Ayer John     Ayer, John 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);