names

15 rows where case_id = 2222852

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4572187 2222852 2222852 plaintiff Arundell John knight   Arundell, John, knight 0
4572188 2222852 2222852 defendant Kernyk John   768494 768494 Kernyk, John, of Lananta 0
4572189 2222852 2222852 defendant Ivel John   768494 768494 Ivel, John, of Lananta 1
4572190 2222852 2222852 defendant Hogge Peter   768494 768494 Hogge, Peter, of Lananta 2
4572191 2222852 2222852 defendant Karlen John   768494 768494 Karlen, John, of Lananta 3
4572192 2222852 2222852 defendant Antony Nicholas of Seyntya     Antony, Nicholas of Seyntya 4
4572193 2222852 2222852 defendant Iryssh Thomas   770873 770873 Iryssh, Thomas, of Seyntya Cothowe 5
4572194 2222852 2222852 defendant Kellegh John   590689 590689 Kellegh, John, of Mousehole 6
4572195 2222852 2222852 defendant Tyek John   590689 590689 Tyek, John, of Mousehole 7
4572196 2222852 2222852 defendant Rawe John   590689 590689 Rawe, John, of Mousehole 8
4572197 2222852 2222852 defendant Hopkyn John   770874 770874 Hopkyn, John, of St Golvel 9
4572198 2222852 2222852 defendant Caleys Thomas   591010 591010 Caleys, Thomas, of Penryn 10
4572199 2222852 2222852 defendant John Thomas   603624 603624 John, Thomas, of Truro 11
4572200 2222852 2222852 defendant Chamburleyn Thomas   762636 762636 Chamburleyn, Thomas, of Grauntpount 12
4572201 2222852 2222852 defendant Sage Thomas   770875 770875 Sage, Thomas, of Grauntpoint 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);