names

14 rows where case_id = 2468748

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5378155 2468748 2468748 plaintiff Tocotes Roger knight   Tocotes, Roger, knight 0
5378156 2468748 2468748 plaintiff Hunderford Edward esq   Hunderford, Edward, esq 1
5378157 2468748 2468748 plaintiff Mompesson John esq   Mompesson, John, esq 2
5378158 2468748 2468748 plaintiff Baynard Robert esq   Baynard, Robert, esq 3
5378159 2468748 2468748 plaintiff Longe Henry esq   Longe, Henry, esq 4
5378160 2468748 2468748 plaintiff Colyngborne William esq   Colyngborne, William, esq 5
5378161 2468748 2468748 plaintiff Touke John     Touke, John 6
5378162 2468748 2468748 plaintiff Ludlowe John     Ludlowe, John 7
5378163 2468748 2468748 plaintiff Unwyn Thomas     Unwyn, Thomas 8
5378164 2468748 2468748 plaintiff Lygh Robert     Lygh, Robert 9
5378165 2468748 2468748 plaintiff Hampton John     Hampton, John 10
5378166 2468748 2468748 plaintiff Gamage Wlater     Gamage, Wlater 11
5378167 2468748 2468748 defendant Bartelot William husbandman 600547 600547 Bartelot, William, of East Harneham, husbandman 0
5378168 2468748 2468748 defendant Boulond Christopher husbandman 600547 600547 Boulond, Christopher, of East Harneham, husbandman 1

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