names

23 rows where case_id = 2513437

✎ 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
5528478 2513437 2513437 plaintiff Morton John Archbishop of Canterbury   Morton, John, Archbishop of Canterbury 0
5528479 2513437 2513437 plaintiff Foxe Richard Bishop of Durham   Foxe, Richard, Bishop of Durham 1
5528480 2513437 2513437 plaintiff Denham John   586740 586740 Denham, John, of Denham, knight 2
5528481 2513437 2513437 plaintiff Fyneux John knight   Fyneux, John, knight 3
5528482 2513437 2513437 plaintiff Bryan Thomas knight   Bryan, Thomas, knight 4
5528483 2513437 2513437 plaintiff Bray Reginald knight   Bray, Reginald, knight 5
5528484 2513437 2513437 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 6
5528485 2513437 2513437 plaintiff Bourghchier Thomas knight   Bourghchier, Thomas, knight 7
5528486 2513437 2513437 plaintiff Gylford Richard knight   Gylford, Richard, knight 8
5528487 2513437 2513437 plaintiff Tirwhit William knight   Tirwhit, William, knight 9
5528488 2513437 2513437 plaintiff Poyntz Robert knight   Poyntz, Robert, knight 10
5528489 2513437 2513437 plaintiff Lovel Robert knight   Lovel, Robert, knight 11
5528490 2513437 2513437 plaintiff Kebell Thomas sergeant at law   Kebell, Thomas, sergeant at law 12
5528491 2513437 2513437 plaintiff Constable Robert sergeant at law   Constable, Robert, sergeant at law 13
5528492 2513437 2513437 plaintiff Frowyke Thomas sergeant at law   Frowyke, Thomas, sergeant at law 14
5528493 2513437 2513437 plaintiff Kyngesmell John sergeant at law   Kyngesmell, John, sergeant at law 15
5528494 2513437 2513437 plaintiff Emson Richard esq   Emson, Richard, esq 16
5528495 2513437 2513437 plaintiff Straungwyshe Thomas esq   Straungwyshe, Thomas, esq 17
5528496 2513437 2513437 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528497 2513437 2513437 plaintiff Nudigate John     Nudigate, John 19
5528498 2513437 2513437 plaintiff Pollerd Lewis     Pollerd, Lewis 20
5528499 2513437 2513437 plaintiff Menwynek William clerk   Menwynek, William, clerk 21
5528500 2513437 2513437 defendant Willoughby Robert   588620 588620 Willoughby, Robert, of Broke, knight 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);