names

23 rows where case_id = 2533554

✎ 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
5595543 2533554 2533554 plaintiff Brough Thomas, junior     Brough, Thomas, junior 0
5595544 2533554 2533554 plaintiff Turwite William     Turwite, William 1
5595545 2533554 2533554 plaintiff Skipwith William     Skipwith, William 2
5595546 2533554 2533554 plaintiff Henege Thomas     Henege, Thomas 3
5595547 2533554 2533554 plaintiff Litelbury Richard     Litelbury, Richard 4
5595548 2533554 2533554 plaintiff Litelbury Thomas     Litelbury, Thomas 5
5595549 2533554 2533554 plaintiff Litelbury John, senior     Litelbury, John, senior 6
5595550 2533554 2533554 plaintiff Sutton Robert     Sutton, Robert 7
5595551 2533554 2533554 plaintiff Hupton Nicholas     Hupton, Nicholas 8
5595552 2533554 2533554 plaintiff Copeldyke John     Copeldyke, John 9
5595553 2533554 2533554 plaintiff Upton John     Upton, John 10
5595554 2533554 2533554 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595555 2533554 2533554 plaintiff Hanshart William     Hanshart, William 12
5595556 2533554 2533554 plaintiff Ascogh Christopher     Ascogh, Christopher 13
5595557 2533554 2533554 plaintiff Thymelby John     Thymelby, John 14
5595558 2533554 2533554 plaintiff Yerbrough Charles     Yerbrough, Charles 15
5595559 2533554 2533554 plaintiff Meres Christopher     Meres, Christopher 16
5595560 2533554 2533554 plaintiff Aungevyn John     Aungevyn, John 17
5595561 2533554 2533554 plaintiff Sheffeld Christopher     Sheffeld, Christopher 18
5595562 2533554 2533554 plaintiff Hilliard Christopher     Hilliard, Christopher 19
5595563 2533554 2533554 plaintiff Yerbrough Richard     Yerbrough, Richard 20
5595564 2533554 2533554 plaintiff Meres Vincent     Meres, Vincent 21
5595565 2533554 2533554 defendant Copeldyke James     Copeldyke, James 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);