names

21 rows where case_id = 2485179

✎ 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
5434191 2485179 2485179 plaintiff Northumberland Henry Earl of   Northumberland, Henry, Earl of 0
5434192 2485179 2485179 plaintiff Sandford John esq   Sandford, John, esq 1
5434193 2485179 2485179 plaintiff Sandford Brian esq   Sandford, Brian, esq 2
5434194 2485179 2485179 plaintiff Dunham John esq   Dunham, John, esq 3
5434195 2485179 2485179 defendant Okys John clerk 602593 602593 Okys, John, of Hellowe, clerk 0
5434196 2485179 2485179 defendant Childe Thomas yeoman 602593 602593 Childe, Thomas, of Hellowe, yeoman 1
5434197 2485179 2485179 defendant Dykson John laborer 602593 602593 Dykson, John, of Hellowe, laborer 2
5434198 2485179 2485179 defendant Carter Robert laborer 602593 602593 Carter, Robert, of Hellowe, laborer 3
5434199 2485179 2485179 defendant Carter Leonard laborer 602593 602593 Carter, Leonard, of Hellowe, laborer 4
5434200 2485179 2485179 defendant Maltby Robert   887111 887111 Maltby, Robert, of Swaby, smyth 5
5434201 2485179 2485179 defendant Day Walter laborer 609257 609257 Day, Walter, of Swaby, laborer 6
5434202 2485179 2485179 defendant Turnour Simon laborer 609257 609257 Turnour, Simon, of Swaby, laborer 7
5434203 2485179 2485179 defendant Tourney Thomas gent 681275 681275 together with Tourney, Thomas, of Gayton in the Marsh, gent 8
5434204 2485179 2485179 defendant Spence Richard yeoman 602593 602593 Spence, Richard, of Hellowe, yeoman 9
5434205 2485179 2485179 defendant Hamerton Peter laborer 602593 602593 Hamerton, Peter, of Hellowe, laborer 10
5434206 2485179 2485179 defendant Day Robert laborer 602593 602593 Day, Robert, of Hellowe, laborer 11
5434207 2485179 2485179 defendant Okys John laborer 602593 602593 Okys, John, of Hellowe, laborer 12
5434208 2485179 2485179 defendant Merycok Simon husbandman 609257 609257 Merycok, Simon, of Swaby, husbandman 13
5434209 2485179 2485179 defendant Bulcotes Richard husbandman 609257 609257 Bulcotes, Richard, of Swaby, husbandman 14
5434210 2485179 2485179 defendant Kynght Robert yeoman 609257 609257 Kynght, Robert, of Swaby, yeoman 15
5434211 2485179 2485179 defendant Merycok John Swaby, laborer   Merycok, John, Swaby, laborer 16

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