names

47 rows where place_id = 650259

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3911076 1994030 1994030 defendant Rowsewyll Richard husbandman 650259 650259 Rowsewyll, Richard, of Buckland, husbandman 0
3911722 1994246 1994246 defendant Osborn John smith 650259 650259 Osborn, John, of Buckland Bruer, smith 0
3983731 2018953 2018953 defendant Walle Humphrey husbandman 650259 650259 Walle, Humphrey, of Buckland, husbandman 2
4029684 2035256 2035256 defendant Daye John miller 650259 650259 Daye, John, of Buckland, miller 0
4029686 2035257 2035257 defendant Daye John miller 650259 650259 Daye, John, of Buckland, miller 0
4031968 2036099 2036099 defendant Myller John husbandman 650259 650259 Myller, John, of Buckland, husbandman 0
4031969 2036099 2036099 defendant Howlett Roger husbandman 650259 650259 Howlett, Roger, of Buckland, husbandman 1
4041028 2039282 2039282 defendant Masie John weaver 650259 650259 Masie, John, of Buckland, weaver 3
4041033 2039283 2039283 defendant Masye John weaver 650259 650259 Masye, John, of Buckland, weaver 3
4052980 2043502 2043502 defendant Staunton William yeoman 650259 650259 Staunton, William, of Buckland, yeoman 1
4072521 2050477 2050477 defendant Anderton George husbandman 650259 650259 Anderton, George, of Buckland, husbandman 0
4080082 2053182 2053182 defendant Tybbes Richard husbandman 650259 650259 Tybbes, Richard, of Buckland, husbandman 0
4108543 2063310 2063310 defendant Myten alias Capper John husbandman 650259 650259 Myten alias Capper, John, of Buckland, husbandman 3
4113023 2064925 2064925 defendant Corter John tucker 650259 650259 Corter, John, of Buckland, tucker 2
4122449 2068337 2068337 defendant Chicke Hugh yeoman 650259 650259 Chicke, Hugh, of Buckland, yeoman 0
4136529 2073407 2073407 defendant Capland Edward yeoman 650259 650259 Capland, Edward, of Buckland, yeoman 1
4142095 2075411 2075411 defendant Dyer Henry husbandman 650259 650259 Dyer, Henry, of Buckland, husbandman 0
4145701 2076650 2076650 defendant Chicke Hugh yeoman 650259 650259 Chicke, Hugh, of Buckland, yeoman 0
4168457 2084453 2084453 defendant Clare Richard yeoman 650259 650259 Clare, Richard, of Buckland, yeoman 1
4176325 2087199 2087199 defendant Scryvener Robert yeoman 650259 650259 Scryvener, Robert, of Buckland, yeoman 0
4184605 2090126 2090126 defendant Scrivener Robert husbanman 650259 650259 Scrivener, Robert, of Buckland, husbanman 0
4189109 2091682 2091682 defendant Skryven Robert husbandman 650259 650259 Skryven, Robert, of Buckland, husbandman 0
4213729 2100317 2100317 plaintiff Yate John (legal representative) 650259 650259 Yate, John, of Buckland, esq, executor of Edward Fetiplace, of Pryors Court, esq, executor of 0
4223155 2103588 2103588 defendant Dugdale Roger yeoman 650259 650259 Dugdale, Roger, of Buckland, yeoman 0
4231146 2106396 2106396 defendant Webbe Anthony husbandman 650259 650259 Webbe, Anthony, of Buckland Brewer, husbandman 0
4234526 2107619 2107619 defendant Vincent John, junior smith 650259 650259 Vincent, John, junior, of Buckland, smith 0
4249096 2112681 2112681 defendant Willoughby Albin gent 650259 650259 Willoughby, Albin, of Buckland, gent 3
4251116 2113352 2113352 defendant Miller Roger husbandman 650259 650259 Miller, Roger, of Buckland, or of Plushe, husbandman 0
4266629 2118483 2118483 defendant Vyncent John, junior smith 650259 650259 Vyncent, John, junior, of Buckland, smith 0
4271032 2119886 2119886 defendant Ventrys John yeoman 650259 650259 Ventrys, John, of Buckland, yeoman 1
4292059 2127234 2127234 defendant Salisburie William merchant 650259 650259 Salisburie, William, of Buckland Brewer, or of Barnstaple, merchant 0
4309018 2133309 2133309 defendant Sallisberye William merchant 650259 650259 Sallisberye, William, of Buckland Brewer, or of Barnstaple, merchant 0
4312919 2134643 2134643 defendant Rickard John husbandman 650259 650259 Rickard, John, of Buckland Bruer, husbandman 2
4360231 2150825 2150825 defendant Tallamye or Tallamore John husbandman 650259 650259 Tallamye or Tallamore, John, of Buckland Bruer, husbandman 0
4360232 2150825 2150825 defendant Galsworthe Thomas husbandman 650259 650259 Galsworthe, Thomas, of Buckland Bruer, husbandman 1
4360234 2150826 2150826 defendant Tallamye John husbandman 650259 650259 Tallamye, John, of Buckland Bruer, husbandman 0
4360235 2150826 2150826 defendant Galsworthye Thomas husbandman 650259 650259 Galsworthye, Thomas, of Buckland Bruer, husbandman 1
4360611 2150964 2150964 defendant Trowde Thomas victualer 650259 650259 Trowde, Thomas, of Buckland, victualer 1
4360612 2150964 2150964 defendant Trowde William husbandman 650259 650259 Trowde, William, of Buckland, husbandman 2
4364025 2152190 2152190 defendant Hellyer John gent 650259 650259 Hellyer, John, of Buckland, gent 3
4364696 2152432 2152432 defendant Phillipps John clerk 650259 650259 Phillipps, John, of Buckland, clerk 0
4383254 2159118 2159118 defendant Edwardes William yeoman 650259 650259 Edwardes, William, of Buckland, yeoman 0
4387191 2160369 2160369 defendant Vyncent John, senior blacksmith 650259 650259 Vyncent, John, senior, of Buckland, or of Skillinge Oakford, blacksmith 0
4396930 2163544 2163544 defendant Elwyll or Elwyn William yeoman 650259 650259 Elwyll or Elwyn, William, of Buckland, yeoman 0
5406996 2477061 2477061 defendant Wode John tailor 650259 650259 Wode, John, of Buckland Brewer, tailor 6
5446151 2488731 2488731 defendant Olyver Thomas   650259 650259 Olyver, Thomas, of Buckland, abbot of the house & church of the BM 0
5584071 2530092 2530092 defendant Conysby Edward gent 650259 650259 Conysby, Edward, of Buckland, gent 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);