names

314 rows where place_id = 593171

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610783 1871037 1871037 defendant Horndon Richard, junior husbandman 593171 593171 Horndon, Richard, junior, of Milton, husbandman 0
3613684 1871928 1871928 defendant Sawell William husbandman 593171 593171 Sawell, William, of Milton, husbandman 0
3616451 1872783 1872783 defendant Sharp Edmund yeoman 593171 593171 Sharp, Edmund, of Milton, or of Steventon, yeoman 0
3622099 1874448 1874448 defendant Bartelot John husbandman 593171 593171 Bartelot, John, of Milton, husbandman 9
3642665 1908151 1908151 defendant Godyn John (legal representative) 593171 593171 Godyn, John, of Milton, executors of 0
3642667 1908151 1908151 defendant Godyn Christopher husbandman 593171 593171 Godyn, Christopher, of Milton, husbandman 2
3649408 1910206 1910206 defendant Ryccard Robert butcher 593171 593171 Ryccard, Robert, of Milton, butcher 0
3653201 1911336 1911336 defendant Hennege William gent 593171 593171 Hennege, William, of Milton, gent 0
3656135 1912173 1912173 defendant Domer Walter husbandman 593171 593171 Domer, Walter, of Milton, husbandman 1
3662436 1914164 1914164 defendant Catlotte Thomas husbandman 593171 593171 Catlotte, Thomas, of Milton, husbandman 1
3666291 1915406 1915406 defendant Martylle John husbandman 593171 593171 Martylle, John, of Milton, husbandman 0
3666292 1915406 1915406 defendant Trynrcarde Richard husbandman 593171 593171 Trynrcarde, Richard, of Milton, husbandman 1
3670926 1916874 1916874 defendant Bruse Richard waterman 593171 593171 Bruse, Richard, of Milton, waterman 0
3670927 1916874 1916874 defendant Baston John   593171 593171 Baston, John, of Milton, masket maker 1
3685391 1921584 1921584 defendant Tollocke Richard yeoman 593171 593171 Tollocke, Richard, of Milton, yeoman 0
3688664 1922615 1922615 defendant Pope John yeoman 593171 593171 Pope, John, of Milton, yeoman 0
3691055 1923365 1923365 defendant Clement Richard esq 593171 593171 Clement, Richard, of Milton, esq 0
3695194 1924719 1924719 defendant Corbet Roger gent 593171 593171 Corbet, Roger, of Milton, gent 1
3695535 1924828 1924828 defendant Savyan Richard hardwareman 593171 593171 Savyan, Richard, of Milton, hardwareman 1
3696206 1925034 1925034 defendant Gollofer Richard clothier 593171 593171 Gollofer, Richard, of Milton, clothier 4
3721890 1933114 1933114 defendant Hoton Richard gent 593171 593171 Hoton, Richard, of Milton, Cumber, gent 2
3723003 1933460 1933460 defendant Hayman Ralph yeoman 593171 593171 Hayman, Ralph, of Milton, yeoman 0
3743365 1939798 1939798 defendant Tybboll John tailor 593171 593171 Tybboll, John, of Milton, tailor 2
3744375 1940140 1940140 defendant Webster John husbandman 593171 593171 Webster, John, of Milton, husbandman 2
3744376 1940140 1940140 defendant Hyll Thomas husbandman 593171 593171 Hyll, Thomas, of Milton, husbandman 3
3758218 1944561 1944561 defendant Wodhalle Thomas husbandman 593171 593171 Wodhalle, Thomas, of Milton, husbandman 0
3762452 1945899 1945899 defendant Hokkeday Henry butcher 593171 593171 Hokkeday, Henry, of Milton, butcher 5
3771359 1948732 1948732 defendant Joye John (legal representative) 593171 593171 Joye, John, of Milton, executor of 5
3771360 1948732 1948732 defendant Joye John husbandman 593171 593171 Joye, John, of Milton, husbandman 6
3822530 1964948 1964948 defendant Spervyll Robert yeoman 593171 593171 Spervyll, Robert, of Milton, yeoman 0
3825685 1965887 1965887 defendant Grene John yeoman 593171 593171 Grene, John, of Milton, yeoman 0
3828401 1966754 1966754 defendant Casse John husbandman 593171 593171 Casse, John, of Milton, husbandman 1
3834173 1968630 1968630 defendant Stede William chapman 593171 593171 Stede, William, of Milton, chapman 0
3849646 1973475 1973475 defendant Hoton Richard gent 593171 593171 Hoton, Richard, of Milton, Cumber, gent 0
3862280 1977572 1977572 plaintiff Guntter Geoffrey gent 593171 593171 Guntter, Geoffrey, of Milton, gent 0
3862282 1977573 1977573 plaintiff Guntter Geoffrey gent 593171 593171 Guntter, Geoffrey, of Milton, gent 0
3862284 1977574 1977574 plaintiff Guntter Geoffrey gent 593171 593171 Guntter, Geoffrey, of Milton, gent 0
3880660 1983797 1983797 defendant Rocke Richard pewterer 593171 593171 Rocke, Richard, of Milton, pewterer 3
3894838 1988479 1988479 defendant Edward John butcher 593171 593171 Edward, John, of Milton, butcher 0
3900285 1990326 1990326 defendant Becher Thomas clothmaker 593171 593171 Becher, Thomas, of Milton, clothmaker 1
3900286 1990326 1990326 defendant Broune William butcher 593171 593171 Broune, William, of Milton, butcher 2
3909820 1993594 1993594 defendant Love William husbandman 593171 593171 Love, William, of Milton, husbandman 0
3926290 1999116 1999116 defendant Pulter Francis gent 593171 593171 Pulter, Francis, of Milton, gent 1
3984137 2019091 2019091 defendant Triddell Robert husbandman 593171 593171 Triddell, Robert, of Milton, husbandman 0
4038221 2038304 2038304 defendant Quyer Henry widow 593171 593171 Quyer, Henry, of Milton, yeoman, servant to Elizabeth Tregonwell, of Mylton, widow 1
4047010 2041381 2041381 plaintiff Spatchurche or Spatchurste Anthony (legal representative) 593171 593171 Spatchurche or Spatchurste, Anthony, of Milton, yeoman, executor of 0
4047013 2041382 2041382 plaintiff Spatchurst Anthony (legal representative) 593171 593171 Spatchurst, Anthony, of Milton, yeoman, executor of 0
4049108 2042126 2042126 plaintiff Tregonwell John esq 593171 593171 Tregonwell, John, of Milton, esq 0
4049109 2042126 2042126 defendant Asheburie Richard gent 593171 593171 Asheburie, Richard, of Milton, gent 0
4049110 2042127 2042127 plaintiff Tregonwell John esq 593171 593171 Tregonwell, John, of Milton, esq 0
4126747 2069854 2069854 defendant Preston William husbandman 593171 593171 Preston, William, of Milton, husbandman 0
4129098 2070710 2070710 defendant Tregonwell John esq 593171 593171 Tregonwell, John, of Milton, esq 0
4133075 2072158 2072158 defendant Mede John innholder 593171 593171 Mede, John, of Milton, innholder 0
4137241 2073667 2073667 defendant Sheppard senior yeoman 593171 593171 Sheppard, , senior, of Milton on Stower, yeoman 0
4137242 2073667 2073667 defendant Sheppard Edward, junior yeoman 593171 593171 Sheppard, Edward, junior, of Milton on Stower, yeoman 1
4152676 2079048 2079048 defendant Mullyns Nicholas merchant 593171 593171 Mullyns, Nicholas, of Milton, merchant 0
4171414 2085465 2085465 defendant Payer John husbandman 593171 593171 Payer, John, of Milton, husbandman 0
4171416 2085466 2085466 defendant Welsted Roger merchant 593171 593171 Welsted, Roger, of Milton, merchant 0
4171488 2085492 2085492 defendant Tregonell John esq 593171 593171 Tregonell, John, of Milton, esq 0
4171502 2085497 2085497 defendant Channell Thomas butcher 593171 593171 Channell, Thomas, of Milton, butcher 0
4175906 2087049 2087049 defendant Grenhill Edward weaver 593171 593171 Grenhill, Edward, of Milton, yeoman, or of Westburye under Playne, Wilts, weaver 0
4175907 2087049 2087049 defendant Grenhill John butcher 593171 593171 Grenhill, John, of Milton, yeoman, or of Westburye, Wilts, butcher 1
4180976 2088824 2088824 defendant Beamond George husbandman 593171 593171 Beamond, George, of Milton, husbandman 0
4187451 2091110 2091110 defendant Gatridge William yeoman 593171 593171 Gatridge, William, of Milton, yeoman 0
4194559 2093651 2093651 defendant Welsted Roger merchant 593171 593171 Welsted, Roger, of Milton, merchant 0
4194561 2093652 2093652 defendant Tregonwell John esq 593171 593171 Tregonwell, John, of Milton, esq 0
4204339 2097063 2097063 defendant Beamond George husbandman 593171 593171 Beamond, George, of Milton, husbandman 0
4204653 2097175 2097175 defendant Bearde Walter yeoman 593171 593171 Bearde, Walter, of Milton, yeoman 0
4206061 2097667 2097667 defendant Bearde Walter yeoman 593171 593171 Bearde, Walter, of Milton, yeoman 1
4215173 2100803 2100803 defendant Glasyer Thomas husbandman 593171 593171 Glasyer, Thomas, of Milton, collier, husbandman 0
4219125 2102185 2102185 defendant Hanley Roger cooper 593171 593171 Hanley, Roger, of Milton, cooper 1
4226317 2104678 2104678 defendant Lake John yeoman 593171 593171 Lake, John, of Milton, yeoman 0
4232386 2106835 2106835 defendant Childe Henry yeoman 593171 593171 Childe, Henry, of Milton, yeoman 0
4241130 2110020 2110020 defendant Locke William yeoman 593171 593171 Locke, William, of Milton, yeoman 0
4241132 2110021 2110021 defendant Payre John yeoman 593171 593171 Payre, John, of Milton, yeoman 0
4245782 2111567 2111567 defendant Meade John yeoman 593171 593171 Meade, John, of Milton, yeoman 0
4270074 2119571 2119571 defendant Child Henry yeoman 593171 593171 Child, Henry, of Milton, yeoman 0
4272870 2120490 2120490 defendant Meade John yeoman 593171 593171 Meade, John, of Milton, yeoman 0
4284986 2124679 2124679 defendant Fayeres or Fayer Richard butcher 593171 593171 Fayeres or Fayer, Richard, of Milton, butcher 0
4291595 2127072 2127072 defendant Rudle Robert glover 593171 593171 Rudle, Robert, of Milton, glover 0
4293967 2127916 2127916 defendant Holmes William chandler 593171 593171 Holmes, William, of Milton, chandler 3
4304252 2131623 2131623 defendant Dumbleton Richard husbandman 593171 593171 Dumbleton, Richard, of Milton, husbandman 0
4306490 2132409 2132409 defendant Beamont George husbandman 593171 593171 Beamont, George, of Milton, husbandman 0
4307287 2132687 2132687 defendant Bythewood Joan widow 593171 593171 Bythewood, Joan, of Milton, widow 0
4307288 2132687 2132687 defendant Salter Robert husbandman 593171 593171 Salter, Robert, of Milton, husbandman 1
4307289 2132687 2132687 defendant Welsteede Roger yeoman 593171 593171 Welsteede, Roger, of Milton, yeoman 2
4307920 2132911 2132911 defendant Bradbury Thomas, junior (legal representative) 593171 593171 Bradbury, Thomas, junior, of Milton, executor of 1
4307921 2132911 2132911 defendant Bradbury Thomas yeoman 593171 593171 Bradbury, Thomas, of Milton, yeoman 2
4308029 2132955 2132955 defendant Barber alias Prince Richard victualer 593171 593171 Barber alias Prince, Richard, of Milton, victualer 0
4308072 2132968 2132968 defendant Sheppard Thomas yeoman 593171 593171 Sheppard, Thomas, of Milton, yeoman 3
4345329 2145640 2145640 defendant Rogers William husbandman 593171 593171 Rogers, William, of Milton, husbandman 0
4349317 2147023 2147023 defendant Combe Thomas husbandman 593171 593171 Combe, Thomas, of Milton, husbandman 0
4358476 2150197 2150197 defendant Florence Edward gent 593171 593171 Florence, Edward, of Milton, gent 0
4358789 2150307 2150307 defendant Payer John yeoman 593171 593171 Payer, John, of Milton, yeoman 1
4371622 2154905 2154905 defendant Stickland John husbandman 593171 593171 Stickland, John, of Milton, husbandman 0
4371624 2154905 2154905 defendant Prince alias Barber Richard butcher 593171 593171 Prince alias Barber, Richard, of Milton, butcher 2
4387309 2160403 2160403 defendant Browne John laborer 593171 593171 Browne, John, of Milton, laborer 2
4393041 2162284 2162284 defendant Florence Edward gent 593171 593171 Florence, Edward, of Milton, gent 0
4393416 2162400 2162400 defendant Prynce Richard butcher 593171 593171 Prynce, Richard, of Milton, butcher 2
4393417 2162400 2162400 defendant Alforde William butcher 593171 593171 Alforde, William, of Milton, butcher 3

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