names

23 rows where case_id = 2513438

✎ 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
5528501 2513438 2513438 plaintiff Morton John Archbishop of Canterbury   Morton, John, Archbishop of Canterbury 0
5528502 2513438 2513438 plaintiff Foxe Richard Bishop of Durham   Foxe, Richard, Bishop of Durham 1
5528503 2513438 2513438 plaintiff Denham John   586740 586740 Denham, John, of Denham, knight 2
5528504 2513438 2513438 plaintiff Fyneux John knight   Fyneux, John, knight 3
5528505 2513438 2513438 plaintiff Bryan Thomas knight   Bryan, Thomas, knight 4
5528506 2513438 2513438 plaintiff Bray Reginald knight   Bray, Reginald, knight 5
5528507 2513438 2513438 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 6
5528508 2513438 2513438 plaintiff Bourghchier Thomas knight   Bourghchier, Thomas, knight 7
5528509 2513438 2513438 plaintiff Gylford Richard knight   Gylford, Richard, knight 8
5528510 2513438 2513438 plaintiff Tirwhit William knight   Tirwhit, William, knight 9
5528511 2513438 2513438 plaintiff Poyntz Robert knight   Poyntz, Robert, knight 10
5528512 2513438 2513438 plaintiff Lovel Robert knight   Lovel, Robert, knight 11
5528513 2513438 2513438 plaintiff Kebell Thomas sergeant at law   Kebell, Thomas, sergeant at law 12
5528514 2513438 2513438 plaintiff Constable Robert sergeant at law   Constable, Robert, sergeant at law 13
5528515 2513438 2513438 plaintiff Frowyke Thomas sergeant at law   Frowyke, Thomas, sergeant at law 14
5528516 2513438 2513438 plaintiff Kyngesmell John sergeant at law   Kyngesmell, John, sergeant at law 15
5528517 2513438 2513438 plaintiff Emson Richard esq   Emson, Richard, esq 16
5528518 2513438 2513438 plaintiff Straungwyshe Thomas esq   Straungwyshe, Thomas, esq 17
5528519 2513438 2513438 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528520 2513438 2513438 plaintiff Nudigate John     Nudigate, John 19
5528521 2513438 2513438 plaintiff Pollerd Lewis     Pollerd, Lewis 20
5528522 2513438 2513438 plaintiff Menwynek William clerk   Menwynek, William, clerk 21
5528523 2513438 2513438 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);