names

12 rows where case_id = 1961137

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3810376 1961137 1961137 plaintiff Broke George knight, Lord Cobham   Broke, George, knight, Lord Cobham 0
3810377 1961137 1961137 plaintiff Bray Edward knight   Bray, Edward, knight 1
3810378 1961137 1961137 plaintiff Bray Reginald esq   Bray, Reginald, esq 2
3810379 1961137 1961137 plaintiff ap Ryce Edward gent   ap Ryce, Edward, gent 3
3810380 1961137 1961137 defendant Strudwyke alias Whytespore John, senior glazier 633046 633046 Strudwyke alias Whytespore, John, senior, of Goundevyle, Kurdeford, Sussex, glazier 0
3810381 1961137 1961137 defendant Strudwyle John, junior glazier 594918 594918 Strudwyle, John, junior, of Kyrdeford, glazier 1
3810382 1961137 1961137 defendant Marten John weaver 633047 633047 Marten, John, of Grenem Sussex, weaver 2
3810383 1961137 1961137 defendant Slade Thomas weaver 599552 599552 Slade, Thomas, of Grene, weaver 3
3810384 1961137 1961137 defendant Pulter Walter laborer 633048 633048 Pulter, Walter, of Alfolde, laborer 4
3810385 1961137 1961137 defendant Strudwyke Thomas, senior glazier 633049 633049 Strudwyke, Thomas, senior, of Newebryge, Sussex, glazier 5
3810386 1961137 1961137 defendant Strudwyke Thomas, junior glazier 633050 633050 Strudwyke, Thomas, junior, of Newebryge, glazier 6
3810387 1961137 1961137 defendant Broker John husbandman 633050 633050 Broker, John, of Newebryge, husbandman 7

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