names

23 rows where case_id = 2533556

✎ 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
5595589 2533556 2533556 plaintiff Brough Thomas, junior     Brough, Thomas, junior 0
5595590 2533556 2533556 plaintiff Turwite William     Turwite, William 1
5595591 2533556 2533556 plaintiff Skipwith William     Skipwith, William 2
5595592 2533556 2533556 plaintiff Henege Thomas     Henege, Thomas 3
5595593 2533556 2533556 plaintiff Litelbury Richard     Litelbury, Richard 4
5595594 2533556 2533556 plaintiff Litelbury Thomas     Litelbury, Thomas 5
5595595 2533556 2533556 plaintiff Litelbury John, senior     Litelbury, John, senior 6
5595596 2533556 2533556 plaintiff Sutton Robert     Sutton, Robert 7
5595597 2533556 2533556 plaintiff Hupton Nicholas     Hupton, Nicholas 8
5595598 2533556 2533556 plaintiff Copeldyke John     Copeldyke, John 9
5595599 2533556 2533556 plaintiff Upton John     Upton, John 10
5595600 2533556 2533556 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595601 2533556 2533556 plaintiff Hanshart William     Hanshart, William 12
5595602 2533556 2533556 plaintiff Ascogh Christopher     Ascogh, Christopher 13
5595603 2533556 2533556 plaintiff Thymelby John     Thymelby, John 14
5595604 2533556 2533556 plaintiff Yerbrough Charles     Yerbrough, Charles 15
5595605 2533556 2533556 plaintiff Meres Christopher     Meres, Christopher 16
5595606 2533556 2533556 plaintiff Aungevyn John     Aungevyn, John 17
5595607 2533556 2533556 plaintiff Sheffeld Christopher     Sheffeld, Christopher 18
5595608 2533556 2533556 plaintiff Hilliard Christopher     Hilliard, Christopher 19
5595609 2533556 2533556 plaintiff Yerbrough Richard     Yerbrough, Richard 20
5595610 2533556 2533556 plaintiff Meres Vincent     Meres, Vincent 21
5595611 2533556 2533556 defendant Moigne Alexander     Moigne, Alexander 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);