names

23 rows where case_id = 2513436

✎ 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
5528455 2513436 2513436 plaintiff Morton John Archbishop of Canterbury   Morton, John, Archbishop of Canterbury 0
5528456 2513436 2513436 plaintiff Foxe Richard Bishop of Durham   Foxe, Richard, Bishop of Durham 1
5528457 2513436 2513436 plaintiff Denham John   586740 586740 Denham, John, of Denham, knight 2
5528458 2513436 2513436 plaintiff Fyneux John knight   Fyneux, John, knight 3
5528459 2513436 2513436 plaintiff Bryan Thomas knight   Bryan, Thomas, knight 4
5528460 2513436 2513436 plaintiff Bray Reginald knight   Bray, Reginald, knight 5
5528461 2513436 2513436 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 6
5528462 2513436 2513436 plaintiff Bourghchier Thomas knight   Bourghchier, Thomas, knight 7
5528463 2513436 2513436 plaintiff Gylford Richard knight   Gylford, Richard, knight 8
5528464 2513436 2513436 plaintiff Tirwhit William knight   Tirwhit, William, knight 9
5528465 2513436 2513436 plaintiff Poyntz Robert knight   Poyntz, Robert, knight 10
5528466 2513436 2513436 plaintiff Lovel Robert knight   Lovel, Robert, knight 11
5528467 2513436 2513436 plaintiff Kebell Thomas sergeant at law   Kebell, Thomas, sergeant at law 12
5528468 2513436 2513436 plaintiff Constable Robert sergeant at law   Constable, Robert, sergeant at law 13
5528469 2513436 2513436 plaintiff Frowyke Thomas sergeant at law   Frowyke, Thomas, sergeant at law 14
5528470 2513436 2513436 plaintiff Kyngesmell John sergeant at law   Kyngesmell, John, sergeant at law 15
5528471 2513436 2513436 plaintiff Emson Richard esq   Emson, Richard, esq 16
5528472 2513436 2513436 plaintiff Straungwyshe Thomas esq   Straungwyshe, Thomas, esq 17
5528473 2513436 2513436 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528474 2513436 2513436 plaintiff Nudigate John     Nudigate, John 19
5528475 2513436 2513436 plaintiff Pollerd Lewis     Pollerd, Lewis 20
5528476 2513436 2513436 plaintiff Menwynek William clerk   Menwynek, William, clerk 21
5528477 2513436 2513436 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);