names

41 rows where place_id = 614394

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3703408 1927343 1927343 defendant Bruggeman John yeoman 614394 614394 Bruggeman, John, of Magna Deane, yeoman 0
3793800 1955925 1955925 plaintiff Brugeman John gent 614394 614394 Brugeman, John, of Magna Deane, gent 0
3827522 1966472 1966472 plaintiff Brayne Thomas (legal representative) 614394 614394 Brayne, Thomas, of Magna Deane, gent, executor of 0
3872788 1981111 1981111 defendant Haynes Roger yeoman 614394 614394 Haynes, Roger, of Magna Deane, yeoman 3
3945013 2005350 2005350 defendant Woodcok William yeoman 614394 614394 Woodcok, William, of Magna Deane, yeoman 0
3973065 2015149 2015149 defendant Syngleton Robert yeoman 614394 614394 Syngleton, Robert, of Magna Deane, yeoman 0
3973067 2015150 2015150 defendant Syngleton Robert yeoman 614394 614394 Syngleton, Robert, of Magna Deane, yeoman 0
3990247 2021267 2021267 defendant Brydgman Thomas gent 614394 614394 Brydgman, Thomas, of Magna Deane, gent 0
3999305 2024512 2024512 plaintiff Fudger John husbandman 614394 614394 Fudger, John, of Magna Deane, husbandman 0
4009933 2028318 2028318 defendant Pyrke William gent 614394 614394 Pyrke, William, of Magna Deane, gent 0
4022520 2032779 2032779 defendant Dyxton Miles smith 614394 614394 Dyxton, Miles, of Magna Deane, yeoman, or of Sturbridge, Worcs, smith 1
4022523 2032780 2032780 defendant Lee John smith 614394 614394 Lee, John, of Magna Deane, or of Swyndon, or Hollowe Lanes End, Staffs, smith 0
4022524 2032780 2032780 defendant Dyxton Miles smith 614394 614394 Dyxton, Miles, of Magna Deane, yeoman, or of Sturbridge, Worcs, smith 1
4025274 2033701 2033701 plaintiff Bridgeman Henry gent 614394 614394 Bridgeman, Henry, of Magna Deane, gent 0
4025278 2033702 2033702 defendant Boudge or Bondge William clerk 614394 614394 Boudge or Bondge, William, of Magna Deane, clerk 0
4025279 2033702 2033702 defendant Pyrke Richard smith 614394 614394 Pyrke, Richard, of Magna Deane, smith 1
4025796 2033879 2033879 defendant Nurse Richard husbandman 614394 614394 Nurse, Richard, of Magna Deane, husbandman 0
4042902 2039938 2039938 plaintiff Pelley Thomas yeoman 614394 614394 Pelley, Thomas, of Magna Deane, yeoman 0
4042905 2039938 2039938 defendant Cole Henry smith 614394 614394 Cole, Henry, of Magna Deane, yeoman, or of Old Swynforde, Worcs, smith 2
4042906 2039939 2039939 plaintiff Pelley Thomas yeoman 614394 614394 Pelley, Thomas, of Magna Deane, yeoman 0
4042909 2039939 2039939 defendant Cole Henry smith 614394 614394 Cole, Henry, of Magna Deane, yeoman, or of Wytham, Worcs, smith 2
4052613 2043358 2043358 defendant Pengrie Robert laborer 614394 614394 Pengrie, Robert, of Magna Deane, laborer 0
4074317 2051115 2051115 defendant ap Powell Rice yeoman 614394 614394 ap Powell, Rice, of Magna Deane, yeoman 0
4099453 2060133 2060133 defendant Sergeante John, junior mercer 614394 614394 Sergeante, John, junior, of Magna Deane, mercer 1
4142943 2075704 2075704 defendant Phelpott John laborer 614394 614394 Phelpott, John, of Magna Deane, laborer 0
4142953 2075706 2075706 defendant Phelpott John laborer 614394 614394 Phelpott, John, of Magna Deane, laborer 3
4145929 2076732 2076732 defendant A Rudge Thomas chapman 614394 614394 A Rudge, Thomas, of Magna Deane, chapman 0
4147871 2077391 2077391 defendant Pyrk William gent 614394 614394 Pyrk, William, of Magna Deane, gent 0
4147873 2077392 2077392 defendant Pyrk William gent 614394 614394 Pyrk, William, of Magna Deane, gent 0
4167859 2084245 2084245 defendant Serjaunt John gent 614394 614394 Serjaunt, John, of Magna Deane, gent 0
4169711 2084897 2084897 defendant Bridgeman George gent 614394 614394 Bridgeman, George, of Magna Deane, gent 0
4169712 2084897 2084897 defendant Bridgeman James gent 614394 614394 Bridgeman, James, of Magna Deane, gent 1
4231928 2106666 2106666 defendant Bridgeman John gent 614394 614394 Bridgeman, John, of Magna Deane, gent 0
4231929 2106666 2106666 defendant Bridgeman Thomas esq 614394 614394 Bridgeman, Thomas, of Magna Deane, or of Powlton, Awer, esq 1
4382620 2158894 2158894 defendant Birche Thomas miller 614394 614394 Birche, Thomas, of Magna Deane, miller 0
4382621 2158894 2158894 defendant Goughe Thomas smith 614394 614394 Goughe, Thomas, of Magna Deane, smith 1
4383662 2159246 2159246 defendant Collyns James   614394 614394 Collyns, James, of Magna Deane, mason 3
4383666 2159247 2159247 defendant Gonne William clothier 614394 614394 Gonne, William, of Magna Deane, clothier 2
4383667 2159247 2159247 defendant Hall James (legal representative) 614394 614394 Hall, James, of Magna Deane, clothier, executrix of 3
4383668 2159247 2159247 defendant Hall Alice widow 614394 614394 Hall, Alice, of Magna Deane, widow 4
4386516 2160165 2160165 defendant Bridgman James (legal representative) 614394 614394 Bridgman, James, of Magna Deane, gent, executors of 2

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