names

29 rows where place_id = 615537

✎ 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
3709394 1929237 1929237 defendant Bolleham Thomas yeoman 615537 615537 Bolleham, Thomas, of Dry Drayton, yeoman 0
3785940 1953399 1953399 defendant Spencer Thomas mealman 615537 615537 Spencer, Thomas, of Dry Drayton, mealman 0
3847336 1972727 1972727 defendant Johnson Thomas yeoman 615537 615537 Johnson, Thomas, of Dry Drayton, yeoman 0
3930029 2000388 2000388 defendant Hutton Thomas gent 615537 615537 Hutton, Thomas, of Dry Drayton, gent 0
4296276 2128766 2128766 defendant Gyfford Thomas husbandman 615537 615537 Gyfford, Thomas, of Dry Drayton, husbandman 0
4397957 2163895 2163895 defendant Mathewe John yeoman 615537 615537 Mathewe, John, of Dry Drayton, yeoman 0
4451404 2185411 2185411 defendant Swyft Matilda   615537 615537 Swyft, Matilda, of Dry Drayton, formerly wife of Robert 1
4463130 2189168 2189168 defendant Gifford Robert   615537 615537 Gifford, Robert, of Dry Drayton 0
4472872 2192191 2192191 defendant Chipmay Henry   615537 615537 Chipmay, Henry, of Dry Drayton 3
4502729 2201431 2201431 defendant Wattesson John   615537 615537 Wattesson, John, of Dry Drayton 0
4502730 2201431 2201431 defendant Campion Richard   615537 615537 Campion, Richard, of Dry Drayton 1
4574471 2223547 2223547 defendant Campyon Richard   615537 615537 Campyon, Richard, of Dry Drayton 0
4574475 2223548 2223548 defendant Campyon Richard   615537 615537 Campyon, Richard, of Dry Drayton 0
4586733 2227253 2227253 defendant Campion Richard   615537 615537 Campion, Richard, of Dry Drayton 1
4652243 2246648 2246648 defendant Taillour John husbandman 615537 615537 Taillour, John, of Dry Drayton, husbandman 0
4695805 2264172 2264172 plaintiff Burgoyne Richard clerk 615537 615537 Burgoyne, Richard, of Dry Drayton, clerk 0
4890761 2323860 2323860 defendant Reynold John husbandman 615537 615537 Reynold, John, of Dry Drayton, husbandman 2
4931944 2336378 2336378 defendant Aleyn John husbandman 615537 615537 Aleyn, John, of Dry Drayton, husbandman 1
4931958 2336382 2336382 plaintiff Wattysson John   615537 615537 Wattysson, John, of Dry Drayton 0
5016516 2361725 2361725 plaintiff Burgoyn William   615537 615537 Burgoyn, William, of Dry Drayton 0
5061216 2374938 2374938 defendant Broun Oliver yeoman 615537 615537 Broun, Oliver, of Dry Drayton, yeoman 0
5229570 2424264 2424264 defendant Simond Robert husbandman 615537 615537 Simond, Robert, of Dry Drayton, husbandman 2
5260102 2433282 2433282 defendant Scot Henry husbandman 615537 615537 Scot, Henry, of Dry Drayton, husbandman 0
5343827 2458252 2458252 defendant Meryell Thomas husbandman 615537 615537 Meryell, Thomas, of Dry Drayton, husbandman 0
5563691 2523989 2523989 defendant Hogonson William yeoman 615537 615537 Hogonson, William, of Dry Drayton, yeoman 0
5572873 2526618 2526618 defendant Stowghton Thomas husbandman 615537 615537 Stowghton, Thomas, of Dry Drayton, husbandman 0
5572874 2526618 2526618 defendant Salman Robert, junior husbandman 615537 615537 Salman, Robert, junior, of Dry Drayton, husbandman 1
5572875 2526618 2526618 defendant Wrottam John husbandman 615537 615537 Wrottam, John, of Dry Drayton, husbandman 2
5594175 2533154 2533154 defendant Johnson Thomas husbandman 615537 615537 Johnson, Thomas, of Dry Drayton, 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);