names

19 rows where place_id = 593486

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3612067 1871418 1871418 defendant West William gent 593486 593486 West, William, of Swathelyng, gent 0
3612380 1871501 1871501 defendant Ederiche Thomas miller 593486 593486 Ederiche, Thomas, of Swathelyng, miller 0
3636972 1906360 1906360 defendant Bewtie Gabriel yeoman 593486 593486 Bewtie, Gabriel, of Swathelyng, yeoman 0
4413379 2169062 2169062 defendant Penne John   593486 593486 Penne, John, of Swathelyng, 0
4486699 2196551 2196551 plaintiff Sayt Peter   593486 593486 Sayt, Peter, of Swathelyng 0
4680471 2259506 2259506 defendant Wodegrene John laborer 593486 593486 Wodegrene, John, of Swathelyng, laborer 0
4810204 2299337 2299337 defendant Morvyle John husbandman 593486 593486 Morvyle, John, of Swathelyng, husbandman 0
5306198 2446840 2446840 defendant Taylour John husbandman 593486 593486 Taylour, John, of Swathelyng, husbandman 0
5330426 2454179 2454179 defendant Clerk John yeoman 593486 593486 Clerk, John, of Swathelyng, yeoman 3
5357280 2462339 2462339 defendant Scobard William husbandman 593486 593486 Scobard, William, of Swathelyng, husbandman 3
5365315 2464825 2464825 defendant Hardman John yeoman 593486 593486 Hardman, John, of Swathelyng, yeoman 0
5474071 2497222 2497222 defendant Shephurde Thomas husbandman 593486 593486 Shephurde, Thomas, of Swathelyng, husbandman 2
5481890 2499514 2499514 defendant Cullyng Thomas yeoman 593486 593486 Cullyng, Thomas, of Swathelyng, yeoman 0
5485498 2500575 2500575 defendant Cullyng Thomas yeoman 593486 593486 Cullyng, Thomas, of Swathelyng, yeoman 2
5485499 2500575 2500575 defendant Shepeherd Thomas husbandman 593486 593486 Shepeherd, Thomas, of Swathelyng, husbandman 3
5485509 2500577 2500577 defendant Cullyng Thomas yeoman 593486 593486 Cullyng, Thomas, of Swathelyng, yeoman 2
5485510 2500577 2500577 defendant Shepeherd Thomas husbandman 593486 593486 Shepeherd, Thomas, of Swathelyng, husbandman 3
5487980 2501293 2501293 defendant Hardeman John yeoman 593486 593486 Hardeman, John, of Swathelyng, yeoman 0
5504514 2506334 2506334 defendant atte Herne Richard husbandman 593486 593486 atte Herne, Richard, of Swathelyng, husbandman 0

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