names

23 rows where case_id = 2533555

✎ 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
5595566 2533555 2533555 plaintiff Brough Thomas, junior     Brough, Thomas, junior 0
5595567 2533555 2533555 plaintiff Turwite William     Turwite, William 1
5595568 2533555 2533555 plaintiff Skipwith William     Skipwith, William 2
5595569 2533555 2533555 plaintiff Henege Thomas     Henege, Thomas 3
5595570 2533555 2533555 plaintiff Litelbury Richard     Litelbury, Richard 4
5595571 2533555 2533555 plaintiff Litelbury Thomas     Litelbury, Thomas 5
5595572 2533555 2533555 plaintiff Litelbury John, senior     Litelbury, John, senior 6
5595573 2533555 2533555 plaintiff Sutton Robert     Sutton, Robert 7
5595574 2533555 2533555 plaintiff Hupton Nicholas     Hupton, Nicholas 8
5595575 2533555 2533555 plaintiff Copeldyke John     Copeldyke, John 9
5595576 2533555 2533555 plaintiff Upton John     Upton, John 10
5595577 2533555 2533555 plaintiff Sheffeld Robert, junior   597495 597495 Sheffeld, Robert, junior, of Butterwyke 11
5595578 2533555 2533555 plaintiff Hanshart William     Hanshart, William 12
5595579 2533555 2533555 plaintiff Ascogh Christopher     Ascogh, Christopher 13
5595580 2533555 2533555 plaintiff Thymelby John     Thymelby, John 14
5595581 2533555 2533555 plaintiff Yerbrough Charles     Yerbrough, Charles 15
5595582 2533555 2533555 plaintiff Meres Christopher     Meres, Christopher 16
5595583 2533555 2533555 plaintiff Aungevyn John     Aungevyn, John 17
5595584 2533555 2533555 plaintiff Sheffeld Christopher     Sheffeld, Christopher 18
5595585 2533555 2533555 plaintiff Hilliard Christopher     Hilliard, Christopher 19
5595586 2533555 2533555 plaintiff Yerbrough Richard     Yerbrough, Richard 20
5595587 2533555 2533555 plaintiff Meres Vincent     Meres, Vincent 21
5595588 2533555 2533555 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);