names

138 rows where place_id = 624417

✎ 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
3758030 1944495 1944495 defendant Walys Nicholas husbandman 624417 624417 Walys, Nicholas, of Jacobstowe, husbandman 2
3772651 1949137 1949137 defendant Sepeherd "Theopacum" husbandman 624417 624417 Sepeherd, "Theopacum", of Jacobstowe, husbandman 3
3799201 1957662 1957662 defendant Ward John husbandman 624417 624417 Ward, John, of Jacobstowe, husbandman 0
3799202 1957662 1957662 defendant Downeyend John husbandman 624417 624417 Downeyend, John, of Jacobstowe, husbandman 1
3799203 1957662 1957662 defendant Pyper David husbandman 624417 624417 Pyper, David, of Jacobstowe, husbandman 2
3817505 1963383 1963383 defendant Wellys John laborer 624417 624417 Wellys, John, of Jacobstowe, laborer 0
3817506 1963383 1963383 defendant Wellys Richard husbandman 624417 624417 Wellys, Richard, of Jacobstowe, husbandman 1
3817509 1963383 1963383 defendant Kenner Walter husbandman 624417 624417 Kenner, Walter, of Jacobstowe, husbandman 4
3817510 1963383 1963383 defendant Wallys Nicholas husbandman 624417 624417 Wallys, Nicholas, of Jacobstowe, husbandman 5
3817511 1963383 1963383 defendant Wallys Thomas husbandman 624417 624417 Wallys, Thomas, of Jacobstowe, husbandman 6
3817512 1963383 1963383 defendant Brocke Edmund   624417 624417 Brocke, Edmund, of Jacobstowe, "hellyer" 7
3817513 1963383 1963383 defendant Rockett John laborer 624417 624417 Rockett, John, of Jacobstowe, laborer 8
3817519 1963384 1963384 defendant Walys Nicholas husbandman 624417 624417 Walys, Nicholas, of Jacobstowe, husbandman 0
3817520 1963384 1963384 defendant Walys Thomas laborer 624417 624417 Walys, Thomas, of Jacobstowe, laborer 1
3817629 1963416 1963416 defendant Wallys Thomas husbandman 624417 624417 Wallys, Thomas, of Jacobstowe, husbandman 6
3817630 1963416 1963416 defendant Brocke Edmund   624417 624417 Brocke, Edmund, of Jacobstowe, "hellyer" 7
3817631 1963416 1963416 defendant Rockett John laborer 624417 624417 Rockett, John, of Jacobstowe, laborer 8
3875016 1981870 1981870 defendant Marshall William chaplain 624417 624417 Marshall, William, of Jacobstowe, chaplain 0
3878608 1983092 1983092 defendant Tahyll John, junior husbandman 624417 624417 Tahyll, John, junior, of Jacobstowe, husbandman 3
3929823 2000313 2000313 defendant Hamlye Thomas yeoman 624417 624417 Hamlye, Thomas, of Jacobstowe, yeoman 2
3954177 2008534 2008534 defendant Donacombe John husbandman 624417 624417 Donacombe, John, of Jacobstowe, husbandman 1
3954178 2008534 2008534 defendant Hyden John husbandman 624417 624417 Hyden, John, of Jacobstowe, husbandman 2
3970400 2014247 2014247 defendant Smyth Reginald husbandman 624417 624417 Smyth, Reginald, of Jacobstowe, husbandman 0
3970401 2014247 2014247 defendant Ivell or Juell John laborer 624417 624417 Ivell or Juell, John, of Jacobstowe, laborer 1
3985771 2019673 2019673 defendant Burlace John gent 624417 624417 Burlace, John, of Jacobstowe, gent 0
3991601 2021757 2021757 defendant Warde John, junior   624417 624417 Warde, John, junior, of Jacobstowe, groom 0
3991603 2021758 2021758 defendant Warde John, senior yeoman 624417 624417 Warde, John, senior, of Jacobstowe, yeoman 0
3992317 2022018 2022018 defendant Stowell Ralph esq 624417 624417 Stowell, Ralph, of Jacobstowe, esq 0
3992320 2022019 2022019 defendant Stowell Robert gent 624417 624417 Stowell, Robert, of Jacobstowe, gent 0
4003375 2025968 2025968 defendant Langdon Roger husbandman 624417 624417 Langdon, Roger, of Jacobstowe, husbandman 0
4003376 2025968 2025968 defendant Wade Richard husbandman 624417 624417 Wade, Richard, of Jacobstowe, husbandman 1
4003449 2025997 2025997 defendant Langdon Roger husbandman 624417 624417 Langdon, Roger, of Jacobstowe, husbandman 0
4003450 2025997 2025997 defendant Wade Richard husbandman 624417 624417 Wade, Richard, of Jacobstowe, husbandman 1
4011120 2028747 2028747 defendant Warde John husbandman 624417 624417 Warde, John, of Jacobstowe, husbandman 8
4013317 2029496 2029496 defendant Collyn John   624417 624417 Collyn, John, of Jacobstowe, gent, administrators of 0
4013318 2029496 2029496 defendant Burlace John gent 624417 624417 (Burlace, John, of Jacobstowe, gent 1
4025246 2033692 2033692 defendant Elyott Nicholas husbandman 624417 624417 Elyott, Nicholas, of Jacobstowe, husbandman 2
4028057 2034685 2034685 defendant Donecomb John yeoman 624417 624417 Donecomb, John, of Jacobstowe, yeoman 1
4044860 2040612 2040612 defendant Collyn John   624417 624417 Collyn, John, of Jacobstowe, gent, administrators of 0
4044861 2040612 2040612 defendant Burlace John   624417 624417 (Burlace, John, of Jacobstowe 1
4050128 2042476 2042476 defendant Nycoll John husbandman 624417 624417 Nycoll, John, of Jacobstowe, husbandman 0
4054082 2043845 2043845 plaintiff Babbe Richard   624417 624417 Babbe, Richard, of Jacobstowe 0
4054083 2043845 2043845 defendant abbe Richard   624417 624417 �abbe, Richard, of Jacobstowe 0
4054084 2043846 2043846 plaintiff Babbe Richard clothier 624417 624417 Babbe, Richard, of Jacobstowe, clothier 0
4056651 2044767 2044767 defendant Warde John, senior   624417 624417 Warde, John, senior, of Jacobstowe, yeoman, administrators of 0
4057326 2045004 2045004 defendant Warde Anthony husbandman 624417 624417 Warde, Anthony, of Jacobstowe, husbandman 0
4057327 2045004 2045004 defendant Warde John husbandman 624417 624417 Warde, John, of Jacobstowe, husbandman 1
4057328 2045004 2045004 defendant Warde Richard husbandman 624417 624417 Warde, Richard, of Jacobstowe, husbandman 2
4057329 2045004 2045004 defendant Langdon William gent 624417 624417 together with Langdon, William, of Jacobstowe, gent 3
4057330 2045004 2045004 defendant Edye alias Edwarde Edward laborer 624417 624417 Edye alias Edwarde, Edward, of Jacobstowe, laborer 4
4082220 2053954 2053954 defendant Warde Anthony husbandman 624417 624417 Warde, Anthony, of Jacobstowe, husbandman 0
4082221 2053954 2053954 defendant Warde John husbandman 624417 624417 Warde, John, of Jacobstowe, husbandman 1
4082222 2053954 2053954 defendant Warde Richard husbandman 624417 624417 Warde, Richard, of Jacobstowe, husbandman 2
4091389 2057209 2057209 defendant Warde Anthony husbandman 624417 624417 Warde, Anthony, of Jacobstowe, husbandman 0
4091390 2057209 2057209 defendant Warde John husbandman 624417 624417 Warde, John, of Jacobstowe, husbandman 1
4091391 2057209 2057209 defendant Warde Richard husbandman 624417 624417 Warde, Richard, of Jacobstowe, husbandman 2
4091393 2057210 2057210 defendant Warde Anthony husbandman 624417 624417 Warde, Anthony, of Jacobstowe, husbandman 0
4091394 2057210 2057210 defendant Warde John husbandman 624417 624417 Warde, John, of Jacobstowe, husbandman 1
4091395 2057210 2057210 defendant Warde Richard husbandman 624417 624417 Warde, Richard, of Jacobstowe, husbandman 2
4092268 2057536 2057536 defendant Langdon alias Trewecke John laborer 624417 624417 Langdon alias Trewecke, John, of Jacobstowe, laborer 1
4092887 2057768 2057768 defendant Langson William gent 624417 624417 Langson, William, of Jacobstowe, gent 0
4095114 2058582 2058582 defendant Warde John husbandman 624417 624417 Warde John, of Jacobstowe, husbandman 0
4095115 2058582 2058582 defendant Warde Anthony husbandman 624417 624417 Warde, Anthony, of Jacobstowe, husbandman 1
4095121 2058584 2058584 defendant Warde Anthony husbandman 624417 624417 Warde, Anthony, of Jacobstowe, husbandman 0
4095123 2058585 2058585 defendant Warde Richard husbandman 624417 624417 Warde, Richard, of Jacobstowe, husbandman 0
4103428 2061511 2061511 defendant Marshall William husbandman 624417 624417 Marshall, William, of Jacobstowe, husbandman 0
4103429 2061511 2061511 defendant Marshall Roger husbandman 624417 624417 Marshall, Roger, of Jacobstowe, husbandman 1
4103430 2061511 2061511 defendant Marshall William, junior laborer 624417 624417 Marshall, William, junior, of Jacobstowe, laborer 2
4114206 2065364 2065364 defendant Maynerd John yeoman 624417 624417 Maynerd, John, of Jacobstowe, yeoman 0
4114207 2065364 2065364 defendant Foxe William husbandman 624417 624417 Foxe, William, of Jacobstowe, husbandman 1
4114714 2065551 2065551 defendant Nyccoll John husbandman 624417 624417 Nyccoll, John, of Jacobstowe, husbandman 4
4115875 2065962 2065962 defendant Burlace John   624417 624417 Burlace, John, of Jacobstowe, groom 0
4115877 2065962 2065962 defendant Lobbis John carpenter 624417 624417 Lobbis, John, of Jacobstowe, carpenter 2
4115878 2065962 2065962 defendant Prouz John gent 624417 624417 together with Prouz, John, of Jacobstowe, gent 3
4115880 2065963 2065963 defendant Dennys John yeoman 624417 624417 Dennys, John, of Jacobstowe, yeoman 0
4115881 2065963 2065963 defendant Prouz John gent 624417 624417 together with Prouz, John, of Jacobstowe, gent 1
4115882 2065963 2065963 defendant Dennys William yeoman 624417 624417 Dennys, William, of Jacobstowe, yeoman 2
4115884 2065964 2065964 defendant Dennys William husbandman 624417 624417 Dennys, William, of Jacobstowe, husbandman 0
4115886 2065965 2065965 defendant Prouze John gent 624417 624417 Prouze, John, of Jacobstowe, gent 0
4139317 2074428 2074428 defendant Treweke Tristram yeoman 624417 624417 Treweke, Tristram, of Jacobstowe, yeoman 0
4139318 2074428 2074428 defendant Treweke Joan widow 624417 624417 Treweke, Joan, of Jacobstowe, widow 1
4147500 2077268 2077268 defendant Collyns John yeoman 624417 624417 Collyns, John, of Jacobstowe, yeoman 0
4147501 2077268 2077268 defendant Well George   624417 624417 Well, George, of Jacobstowe 1
4147502 2077268 2077268 defendant Dobbe James laborer 624417 624417 Dobbe, James, of Jacobstowe, laborer 2
4187676 2091192 2091192 defendant Treweeke Richard gent 624417 624417 Treweeke, Richard, of Jacobstowe, gent 0
4196678 2094384 2094384 defendant Rondell William husbandman 624417 624417 Rondell, William, of Jacobstowe, husbandman 1
4196679 2094384 2094384 defendant Langdon Richard laborer 624417 624417 Langdon, Richard, of Jacobstowe, laborer 2
4211176 2099465 2099465 defendant Trewicke Richard gent 624417 624417 Trewicke, Richard, of Jacobstowe, gent 0
4214292 2100516 2100516 defendant Warde Jane spinster 624417 624417 Warde, Jane, of Jacobstowe, spinster 0
4214293 2100516 2100516 defendant Worthe Lawrence husbandman 624417 624417 Worthe, Lawrence, of Jacobstowe, husbandman 1
4215843 2101039 2101039 defendant Warde Jane spinster 624417 624417 Warde, Jane, of Jacobstowe, spinster 0
4215845 2101040 2101040 defendant Warde Jane spinster 624417 624417 Warde, Jane, of Jacobstowe, spinster 0
4224945 2104194 2104194 defendant Prouze John gent 624417 624417 Prouze, John, of Jacobstowe, gent 0
4224946 2104194 2104194 defendant Hollman Thomas laborer 624417 624417 Hollman, Thomas, of Jacobstowe, laborer 1
4224947 2104194 2104194 defendant Sheere Thomas laborer 624417 624417 Sheere, Thomas, of Jacobstowe, laborer 2
4240816 2109912 2109912 defendant Hiddon John husbandman 624417 624417 Hiddon, John, of Jacobstowe, husbandman 0
4240817 2109912 2109912 defendant Hiddon Nicholas husbandman 624417 624417 Hiddon, Nicholas, of Jacobstowe, husbandman 1
4242020 2110325 2110325 defendant Warde Jane spinster 624417 624417 Warde, Jane, of Jacobstowe, spinster 0
4244643 2111193 2111193 defendant Collyns Ralph husbandman 624417 624417 Collyns, Ralph, of Jacobstowe, husbandman 2
4251659 2113539 2113539 defendant Downe Richard tanner 624417 624417 Downe, Richard, of Jacobstowe, tanner 0

Next page

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