names

17 rows where place_id = 760094

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3762070 1945779 1945779 defendant Garlond William (legal representative) 760094 760094 Garlond, William, of Stanford in the Hope, executor of 0
4466998 2190348 2190348 defendant Sevy John   760094 760094 Sevy, John, of Stanford in the Hope 1
4467205 2190416 2190416 plaintiff atte Hill Christine   760094 760094 atte Hill, Christine, of Stanford in the Hope 0
4467208 2190416 2190416 defendant Sweyn John   760094 760094 Sweyn, John, of Stanford in the Hope 2
4605887 2232955 2232955 defendant Lorkyn Agnes   760094 760094 Lorkyn, Agnes, of Stanford in the Hope, formerly wife of John 1
4710640 2268683 2268683 defendant Andrewe William yeoman 760094 760094 Andrewe, William, of Stanford in the Hope, yeoman 0
4710641 2268683 2268683 defendant Peryman William shipman 760094 760094 Peryman, William, of Stanford in the Hope, shipman 1
4719435 2271423 2271423 defendant Swayn Henry shipman 760094 760094 Swayn, Henry, of Stanford in the Hope, shipman 0
4746795 2279563 2279563 defendant Colyn Joan widow & formerly wife of Thomas Colyn 760094 760094 Colyn, Joan, of Stanford in the Hope, widow & formerly wife of Thomas Colyn 1
4769720 2286502 2286502 defendant Breynok William laborer 760094 760094 Breynok, William, of Stanford in the Hope, laborer 1
4777594 2288989 2288989 defendant Couper William husbandman 760094 760094 Couper, William, of Stanford in the Hope, husbandman 0
4777595 2288989 2288989 defendant Rogger John herder 760094 760094 Rogger, John, of Stanford in the Hope, herder 1
4777597 2288989 2288989 defendant Crane Alice widow 760094 760094 Crane, Alice, of Stanford in the Hope, widow 3
4880934 2320944 2320944 defendant Lymbour John vintner 760094 760094 Lymbour, John, of Stanford in the Hope, vintner 1
4913608 2330753 2330753 defendant Ardall John gent 760094 760094 Ardall, John, of Stanford in the Hope, gent 0
5086056 2382314 2382314 defendant Pitman Thomas yeoman 760094 760094 Pitman, Thomas, of Stanford in the Hope, yeoman 0
5479054 2498757 2498757 defendant Weston John tailor 760094 760094 Weston, John, of Stanford in the Hope, tailor 1

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