names

15 rows where case_id = 2471691

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5388259 2471691 2471691 plaintiff Gower Thomas   881695 881695 Gower, Thomas, of the hospice of Lions 0
5388260 2471691 2471691 defendant Taverner John gent 881014 881014 Taverner, John, of St Clement Danes outside the New Temple Bars, Middx, gent 0
5388261 2471691 2471691 defendant Gybbes John gent 585929 585929 Gybbes, John, of St Clement Danes, gent 1
5388262 2471691 2471691 defendant Arnold John gent 585929 585929 Arnold John, of St Clement Danes, gent 2
5388263 2471691 2471691 defendant Straccheleigh William gent 585929 585929 Straccheleigh, William, of St Clement Danes, gent 3
5388264 2471691 2471691 defendant Willesford William gent   Willesford, William, gent 4
5388265 2471691 2471691 defendant Smyth John gent   Smyth, John, gent 5
5388266 2471691 2471691 defendant Mountendy John gent   Mountendy, John, gent 6
5388267 2471691 2471691 defendant Floyer William gent   Floyer, William, gent 7
5388268 2471691 2471691 defendant Trevenour John gent   Trevenour, John, gent 8
5388269 2471691 2471691 defendant Owen Richard gent   Owen, Richard, gent 9
5388270 2471691 2471691 defendant Drury John gent   Drury, John, gent 10
5388271 2471691 2471691 defendant Payne John gent   Payne, John, gent 11
5388272 2471691 2471691 defendant Walcote William gent   Walcote, William, gent 12
5388273 2471691 2471691 defendant Daynes Edward gent   Daynes, Edward, gent 13

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