names

23 rows where case_id = 2533557

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5595612 2533557 2533557 plaintiff Brough Thomas, junior     Brough, Thomas, junior 0
5595613 2533557 2533557 plaintiff Turwite William     Turwite, William 1
5595614 2533557 2533557 plaintiff Skipwith William     Skipwith, William 2
5595615 2533557 2533557 plaintiff Henege Thomas     Henege, Thomas 3
5595616 2533557 2533557 plaintiff Litelbury Richard     Litelbury, Richard 4
5595617 2533557 2533557 plaintiff Litelbury Thomas     Litelbury, Thomas 5
5595618 2533557 2533557 plaintiff Litelbury John, senior     Litelbury, John, senior 6
5595619 2533557 2533557 plaintiff Sutton Robert     Sutton, Robert 7
5595620 2533557 2533557 plaintiff Hupton Nicholas     Hupton, Nicholas 8
5595621 2533557 2533557 plaintiff Copeldyke John     Copeldyke, John 9
5595622 2533557 2533557 plaintiff Upton John     Upton, John 10
5595623 2533557 2533557 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595624 2533557 2533557 plaintiff Hanshart William     Hanshart, William 12
5595625 2533557 2533557 plaintiff Ascogh Christopher     Ascogh, Christopher 13
5595626 2533557 2533557 plaintiff Thymelby John     Thymelby, John 14
5595627 2533557 2533557 plaintiff Yerbrough Charles     Yerbrough, Charles 15
5595628 2533557 2533557 plaintiff Meres Christopher     Meres, Christopher 16
5595629 2533557 2533557 plaintiff Aungevyn John     Aungevyn, John 17
5595630 2533557 2533557 plaintiff Sheffeld Christopher     Sheffeld, Christopher 18
5595631 2533557 2533557 plaintiff Hilliard Christopher     Hilliard, Christopher 19
5595632 2533557 2533557 plaintiff Yerbrough Richard     Yerbrough, Richard 20
5595633 2533557 2533557 plaintiff Meres Vincent     Meres, Vincent 21
5595634 2533557 2533557 defendant Moygne Lawrence     Moygne, Lawrence 0

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