names

11 rows where case_id = 2040241

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4043818 2040241 2040241 plaintiff Prouz John gent, clerk of William Whetley, esq, Chief Prothonotary of the Court   Prouz, John, gent, clerk of William Whetley, esq, Chief Prothonotary of the Court 0
4043819 2040241 2040241 defendant James alias Nicholl Henry tinner 661491 661491 James alias Nicholl, Henry, of Lalant, tinner 0
4043820 2040241 2040241 defendant Trevalsons Edward gent 629230 629230 Trevalsons, Edward, of St Moran, gent 1
4043821 2040241 2040241 defendant Cossyn Margaret widow 616952 616952 Cossyn, Margaret, of St Tue, widow 2
4043822 2040241 2040241 defendant Lee John yeoman 681195 681195 Lee, John, of Quetheeck, yeoman 3
4043823 2040241 2040241 defendant Lucas William smith 645492 645492 Lucas, William, of St Stephyns juxta Launceston, smith 4
4043824 2040241 2040241 defendant Reynsbye John yeoman 645492 645492 Reynsbye, John, of St Stephyns juxta Launceston, yeoman 5
4043825 2040241 2040241 defendant Coll John gent 625712 625712 Coll, John, of St Clere, gent 6
4043826 2040241 2040241 defendant Androwe Sampson yeoman 604983 604983 Androwe, Sampson, of Paddestowe, yeoman 7
4043827 2040241 2040241 defendant Payne John gent 641567 641567 Payne, John, of St Issey, gent 8
4043828 2040241 2040241 defendant Harrys John husbandman 657779 657779 Harrys, John, of Warbestowe, husbandman 9

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