names

18 rows where case_id = 2221989

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4569297 2221989 2221989 plaintiff Welborn John (legal representative) 586286 586286 Welborn, John, of Boston, executors of 0
4569298 2221989 2221989 plaintiff Banham William     (Banham, William 1
4569299 2221989 2221989 plaintiff Banham Agnes     Agnes, his wife 2
4569300 2221989 2221989 defendant Freston Simon son of Alexander   Freston, Simon, son of Alexander 0
4569301 2221989 2221989 defendant Gosberkirke John   770588 770588 Gosberkirke, John, of Leigton 1
4569302 2221989 2221989 defendant Northorp Richard   586083 586083 Northorp, Richard, of Langton 2
4569303 2221989 2221989 defendant (not given) John his son   John, his son 3
4569304 2221989 2221989 defendant Pere_ William   762981 762981 Pere_, William, of Sibsay 4
4569305 2221989 2221989 defendant Hagon John   762981 762981 Hagon, John, of Sibsay 5
4569306 2221989 2221989 defendant Waltham Robert   604761 604761 Waltham, Robert, of Lyndesey 6
4569307 2221989 2221989 defendant Kirkeby William     Kirkeby, William 7
4569308 2221989 2221989 defendant Kirkeby Agnes     Agnes, his wife 8
4569309 2221989 2221989 defendant To_ William   586044 586044 To_, William, of Welborn 9
4569310 2221989 2221989 defendant Blayke John   597185 597185 Blayke, John, of Freston 10
4569311 2221989 2221989 defendant Pykeryng William   597328 597328 Pykeryng, William, of Leke 11
4569312 2221989 2221989 defendant Wytham Hugh     Wytham, Hugh 12
4569313 2221989 2221989 defendant Walpole John   586286 586286 Walpole, John,of Boston 13
4569314 2221989 2221989 defendant Barneby John   623295 623295 Barneby, John, of Rode 14

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