names

23 rows where case_id = 2513439

✎ 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
5528524 2513439 2513439 plaintiff Morton John Archbishop of Canterbury   Morton, John, Archbishop of Canterbury 0
5528525 2513439 2513439 plaintiff Foxe Richard Bishop of Durham   Foxe, Richard, Bishop of Durham 1
5528526 2513439 2513439 plaintiff Denham John   586740 586740 Denham, John, of Denham, knight 2
5528527 2513439 2513439 plaintiff Fyneux John knight   Fyneux, John, knight 3
5528528 2513439 2513439 plaintiff Bryan Thomas knight   Bryan, Thomas, knight 4
5528529 2513439 2513439 plaintiff Bray Reginald knight   Bray, Reginald, knight 5
5528530 2513439 2513439 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 6
5528531 2513439 2513439 plaintiff Bourghchier Thomas knight   Bourghchier, Thomas, knight 7
5528532 2513439 2513439 plaintiff Gylford Richard knight   Gylford, Richard, knight 8
5528533 2513439 2513439 plaintiff Tirwhit William knight   Tirwhit, William, knight 9
5528534 2513439 2513439 plaintiff Poyntz Robert knight   Poyntz, Robert, knight 10
5528535 2513439 2513439 plaintiff Lovel Robert knight   Lovel, Robert, knight 11
5528536 2513439 2513439 plaintiff Kebell Thomas sergeant at law   Kebell, Thomas, sergeant at law 12
5528537 2513439 2513439 plaintiff Constable Robert sergeant at law   Constable, Robert, sergeant at law 13
5528538 2513439 2513439 plaintiff Frowyke Thomas sergeant at law   Frowyke, Thomas, sergeant at law 14
5528539 2513439 2513439 plaintiff Kyngesmell John sergeant at law   Kyngesmell, John, sergeant at law 15
5528540 2513439 2513439 plaintiff Emson Richard esq   Emson, Richard, esq 16
5528541 2513439 2513439 plaintiff Straungwyshe Thomas esq   Straungwyshe, Thomas, esq 17
5528542 2513439 2513439 plaintiff Nevyll Thomas esq 611918 611918 Nevyll, Thomas, of Holte, esq 18
5528543 2513439 2513439 plaintiff Nudigate John     Nudigate, John 19
5528544 2513439 2513439 plaintiff Pollerd Lewis     Pollerd, Lewis 20
5528545 2513439 2513439 plaintiff Menwynek William clerk   Menwynek, William, clerk 21
5528546 2513439 2513439 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);