names

26 rows where place_id = 594182

✎ 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
3614956 1872322 1872322 defendant Pullesworthy William laborer 594182 594182 Pullesworthy, William, of Okeford, laborer 0
3614957 1872322 1872322 defendant May William tailor 594182 594182 May, William, of Okeford, tailor 1
3614958 1872322 1872322 defendant Vausey Humphrey husbandman 594182 594182 Vausey, Humphrey, of Okeford, husbandman 2
3649567 1910253 1910253 defendant Byckam Humphrey   594182 594182 Byckam, Humphrey, of Okeford 0
3759209 1944868 1944868 defendant Radford William husbandman 594182 594182 Radford, William, of Okeford, husbandman 0
3823918 1965352 1965352 defendant Campe John husbandman 594182 594182 Campe, John, of Okeford, husbandman 0
3880526 1983744 1983744 defendant Snow William smith 594182 594182 Snow, William, of Okeford, smith 0
3930602 2000578 2000578 defendant Templett John husbandman 594182 594182 Templett, John, of Okeford, husbandman 0
4050921 2042774 2042774 defendant Prescote John (legal representative) 594182 594182 Prescote, John, of Okeford, yeoman, executrix of 0
4050924 2042775 2042775 defendant Prescott John (legal representative) 594182 594182 Prescott, John, of Okeford, yeoman, executrix of 0
4230192 2106046 2106046 defendant Prescott Lewis (legal representative) 594182 594182 Prescott, Lewis, of Okeford, yeoman, executrix of 0
4272081 2120228 2120228 defendant Prescott Lewis (legal representative) 594182 594182 Prescott, Lewis, of Okeford, yeoman, executrix of 0
4302488 2130990 2130990 defendant Bowden Walter   594182 594182 Bowden, Walter, of Okeford, Devon yeoman 0
4326995 2139360 2139360 defendant Pope Morgan yeoman 594182 594182 Pope, Morgan, of Okeford, yeoman 0
4362975 2151820 2151820 defendant White Elizabeth widow 594182 594182 White, Elizabeth, of Okeford, widow 1
4946717 2340975 2340975 defendant atte Forde Alan husbandman 594182 594182 atte Forde, Alan, of Okeford, husbandman 1
4960900 2345223 2345223 defendant atte Hole William husbandman 594182 594182 atte Hole, William, of Okeford, husbandman 1
5287818 2441460 2441460 defendant Quyk William tailor 594182 594182 Quyk, William, of Okeford, tailor 0
5301509 2445408 2445408 plaintiff Davy John   594182 594182 Davy, John, of Okeford 0
5301514 2445408 2445408 plaintiff Davy Richard   594182 594182 Davy, Richard, of Okeford 5
5310875 2448286 2448286 defendant Hille John husbandman 594182 594182 Hille, John, of Okeford, husbandman 0
5368303 2465703 2465703 defendant Bykcombe John husbandman 594182 594182 Bykcombe, John, of Okeford, husbandman 3
5379074 2469051 2469051 plaintiff White Henry   594182 594182 White, Henry, of Okeford 0
5394546 2473500 2473500 plaintiff Whyte Henry   594182 594182 Whyte, Henry, of Okeford 0
5560074 2522904 2522904 defendant Mannyng James yeoman 594182 594182 Mannyng, James, of Okeford, yeoman 0
5567667 2525115 2525115 defendant Voysy Humphrey husbandman 594182 594182 Voysy, Humphrey, of Okeford, 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);