names

11 rows where case_id = 2239447

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4627161 2239447 2239447 plaintiff rex or Armeston William     rex or Armeston, William 0
4627162 2239447 2239447 defendant Bagshawe Thomas son of William   Bagshawe, Thomas, son of William 0
4627163 2239447 2239447 defendant Hobisson Thomas     Hobisson, Thomas 1
4627164 2239447 2239447 defendant Sale Roger de son of John   together with Sale, Roger de, son of John 2
4627165 2239447 2239447 defendant Burton John de son of Nicholas   Burton, John de, son of Nicholas 3
4627166 2239447 2239447 defendant Taillour Roberft   586137 586137 Taillour, Roberft, of Fairfeld 4
4627167 2239447 2239447 defendant Aleyn William son of Nicholas   Aleyn, William, son of Nicholas 5
4627168 2239447 2239447 defendant Willeson John   605693 605693 Willeson, John, of Chapell 6
4627169 2239447 2239447 defendant del Birchus William     del Birchus, William 7
4627170 2239447 2239447 defendant Workusley John son of John   Workusley, John, son of John 8
4627171 2239447 2239447 defendant del Kirke John son of John   del Kirke, John, son of John 9

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