names

29 rows where place_id = 611173

✎ 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
3687204 1922175 1922175 defendant Clyfford William gent 611173 611173 Clyfford, William, of Boscombe, gent 0
3687205 1922175 1922175 defendant Davy William husbandman 611173 611173 Davy, William, of Boscombe, husbandman 1
3797959 1957260 1957260 defendant Glyfford William esq 611173 611173 Glyfford, William, of Boscombe, esq 0
3797960 1957260 1957260 defendant Pullen Robert yeoman 611173 611173 Pullen, Robert, of Boscombe, yeoman 1
3797961 1957260 1957260 defendant Dyppar Richard yeoman 611173 611173 Dyppar, Richard, of Boscombe, yeoman 2
3797962 1957260 1957260 defendant Dawes William husbandman 611173 611173 Dawes, William, of Boscombe, husbandman 3
3814690 1962506 1962506 defendant Clyfford William esq 611173 611173 Clyfford, William, of Boscombe, esq 0
3814691 1962506 1962506 defendant Pullen Robert yeoman 611173 611173 Pullen, Robert, of Boscombe, yeoman 1
3814692 1962506 1962506 defendant Dipper Richard yeoman 611173 611173 Dipper, Richard, of Boscombe, yeoman 2
3814693 1962506 1962506 defendant Dawes William husbandman 611173 611173 Dawes, William, of Boscombe, husbandman 3
3815284 1962696 1962696 defendant Clyfford William esq 611173 611173 Clyfford, William, of Boscombe, esq 0
3815285 1962696 1962696 defendant Pullen Robert yeoman 611173 611173 Pullen, Robert, of Boscombe, yeoman 1
3815286 1962696 1962696 defendant Dyppar Richard yeoman 611173 611173 Dyppar, Richard, of Boscombe, yeoman 2
3815287 1962696 1962696 defendant Dawes William husbandman 611173 611173 Dawes, William, of Boscombe, husbandman 3
3902543 1991085 1991085 defendant Rutter William husbandman 611173 611173 (Rutter, William, of Boscombe, husbandman 4
4650220 2246084 2246084 defendant Rikhill John   611173 611173 Rikhill, John, of Boscombe 6
4667397 2255525 2255525 defendant Thorp Henry (legal representative) 611173 611173 Thorp, Henry, of Boscombe, esq, executors of 0
4681590 2259856 2259856 defendant Thorp Cecily   611173 611173 Thorp, Cecily, of Boscombe, widow, formerly the wife of Henry Thorp 0
4681595 2259856 2259856 defendant Kirkeby Thomas yeoman 611173 611173 Kirkeby, Thomas, of Boscombe, yeoman 5
4773746 2287763 2287763 defendant Tyncok Richard husbandman 611173 611173 Tyncok, Richard, of Boscombe, husbandman 0
4780038 2289761 2289761 plaintiff Broune Simon (legal representative) 611173 611173 Broune, Simon, of Boscombe, executors of 0
4972677 2348761 2348761 plaintiff Kyrkeby Ralph   611173 611173 Kyrkeby, Ralph, of Boscombe 0
5045471 2370275 2370275 defendant Osmont William husbandman 611173 611173 Osmont, William, of Boscombe, husbandman 0
5159613 2403929 2403929 defendant Thacham Robert clerk 611173 611173 Thacham, Robert, of Boscombe, clerk 3
5174682 2408295 2408295 defendant Thacham Robert clerk 611173 611173 Thacham, Robert, of Boscombe, clerk 3
5196242 2414653 2414653 defendant Kyrkeby Thomas husbandman 611173 611173 Kyrkeby, Thomas, of Boscombe, husbandman 1
5209607 2418549 2418549 defendant Kyrkeby Thomas husbandman 611173 611173 Kyrkeby, Thomas, of Boscombe, husbandman 0
5246319 2429084 2429084 defendant Thacham Robert clerk 611173 611173 Thacham, Robert, of Boscombe, clerk 2
5362735 2463990 2463990 defendant Ryppeley Robert yeoman 611173 611173 Ryppeley, Robert, of Boscombe, yeoman 4

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