names

13 rows where case_id = 2434872

✎ 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
5265184 2434872 2434872 plaintiff Stocfold Walter esq   Stocfold, Walter, esq 0
5265185 2434872 2434872 defendant Noke Thomas laborer 598423 598423 Noke, Thomas, of Fyncheley, laborer 0
5265186 2434872 2434872 defendant Noke John laborer 598423 598423 Noke, John, of Fyncheley, laborer 1
5265187 2434872 2434872 defendant Prat Richard laborer 598423 598423 Prat, Richard, of Fyncheley, laborer 2
5265188 2434872 2434872 defendant Coppewode Thomas husbandman 598423 598423 Coppewode, Thomas, of Fyncheley, husbandman 3
5265189 2434872 2434872 defendant Coppewode Richard husbandman 598423 598423 Coppewode, Richard, of Fyncheley, husbandman 4
5265190 2434872 2434872 defendant Dogget John brewer 598423 598423 Dogget, John, of Fyncheley, brewer 5
5265191 2434872 2434872 defendant Fox Thomas husbandman 598423 598423 Fox, Thomas, of Fyncheley, husbandman 6
5265192 2434872 2434872 defendant Gladwyn John husbandman 865929 865929 Gladwyn, John, of Freron Barnet, husbandman 7
5265193 2434872 2434872 defendant Gladwyn Richard laborer 865929 865929 Gladwyn, Richard, of Freron Barnet, laborer 8
5265194 2434872 2434872 defendant Petyr John collier 865929 865929 Petyr, John, of Freron Barnet, collier 9
5265195 2434872 2434872 defendant Dogget Richard laborer 865929 865929 Dogget, Richard, of Freron Barnet, laborer 10
5265196 2434872 2434872 defendant Prat John yeoman 865929 865929 Prat, John, of Freron Barnet, yeoman 11

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