names

255 rows where place_id = 587559

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591751 1865042 1865042 defendant Bulcle Ralph gent 587559 587559 Bulcle, Ralph, of Bampton, gent 0
3591752 1865042 1865042 defendant Atlond Roger husbandman 587559 587559 Atlond, Roger, of Bampton, husbandman 1
3591753 1865042 1865042 defendant Bulcle Ralph   587559 587559 Bulcle, Ralph, of Bampton, groom 2
3591754 1865042 1865042 defendant Pope John husbandman 587559 587559 Pope, John, of Bampton, husbandman 3
3591755 1865042 1865042 defendant Holyprest Lawrence laborer 587559 587559 Holyprest, Lawrence, of Bampton, laborer 4
3591756 1865042 1865042 defendant Wever Hugh weaver 587559 587559 Wever, Hugh, of Bampton, weaver 5
3591757 1865042 1865042 defendant Stodham Richard tailor 587559 587559 Stodham, Richard, of Bampton, tailor 6
3591758 1865042 1865042 defendant Wynok Thomas   587559 587559 Wynok, Thomas, of Bampton, groom 7
3622779 1874655 1874655 defendant Sparkehayne John, junior husbandman 587559 587559 Sparkehayne, John, junior, of Bampton, husbandman 2
3622780 1874655 1874655 defendant Helyer John yeoman 587559 587559 Helyer, John, of Bampton, yeoman 3
3673427 1917709 1917709 defendant Heydok Thomas gent 587559 587559 Heydok, Thomas, of Bampton, gent 0
3712856 1930341 1930341 defendant Arnolde John husbandman 587559 587559 Arnolde, John, of Bampton, husbandman 1
3712857 1930341 1930341 defendant Shawe William husbandman 587559 587559 Shawe, William, of Bampton, husbandman 2
3743544 1939856 1939856 defendant Arnolde John husbandman 587559 587559 Arnolde, John, of Bampton, husbandman 1
3743545 1939856 1939856 defendant Shawe William husbandman 587559 587559 Shawe, William, of Bampton, husbandman 2
3767817 1947571 1947571 defendant Helyer John yeoman 587559 587559 Helyer, John, of Bampton, yeoman 0
3774740 1949829 1949829 defendant Dobbys John husbandman 587559 587559 Dobbys, John, of Bampton, husbandman 1
3829440 1967092 1967092 defendant Frenche Robert husbandman 587559 587559 Frenche, Robert, of Bampton, husbandman 0
3841306 1970860 1970860 defendant Helyer John yeoman 587559 587559 Helyer, John, of Bampton, yeoman 0
3855739 1975429 1975429 defendant Helyer John gent 587559 587559 Helyer, John, of Bampton, gent 0
3959836 2010531 2010531 defendant Elyott John laborer 587559 587559 Elyott, John, of Bampton, laborer 0
3979167 2017300 2017300 defendant Dyer Stephen yeoman 587559 587559 Dyer, Stephen, of Bampton, yeoman 0
3979168 2017300 2017300 defendant Kympe Robert husbandman 587559 587559 Kympe, Robert, of Bampton, husbandman 1
3979169 2017300 2017300 defendant Hill John husbandman 587559 587559 Hill, John, of Bampton, husbandman 2
3979170 2017300 2017300 defendant Crosse Edmund husbandman 587559 587559 Crosse, Edmund, of Bampton, husbandman 3
3986873 2020047 2020047 defendant Mondaye John yeoman or fishmonger 587559 587559 Mondaye, John, of Bampton, yeoman or fishmonger 0
4024809 2033555 2033555 defendant Wade Thomas husbandman 587559 587559 Wade, Thomas, of Bampton, husbandman 0
4063358 2047185 2047185 plaintiff Gear Robert yeoman 587559 587559 Gear, Robert, of Bampton, yeoman 0
4078433 2052583 2052583 defendant Rixson John laborer 587559 587559 Rixson, John, of Bampton, laborer 0
4078434 2052583 2052583 defendant Tayler alias Coles John husbandman 587559 587559 Tayler alias Coles, John, of Bampton, husbandman 1
4150075 2078164 2078164 defendant Smythe Joan widow 587559 587559 Joan his wife, formerly Joan Harrys, of Bampton, widow 1
4160368 2081702 2081702 defendant David Watkin yeoman 587559 587559 David, Watkin, of Bampton, yeoman 0
4164106 2082971 2082971 defendant Hill alias Doddiscomb Christopher husbandman 587559 587559 Hill alias Doddiscomb, Christopher, of Bampton, husbandman 0
4180203 2088558 2088558 defendant Badcocke Robert blacksmith 587559 587559 Badcocke, Robert, of Bampton, blacksmith 0
4180205 2088559 2088559 defendant Rombellowe William butcher 587559 587559 Rombellowe, William, of Bampton, butcher 0
4197380 2094637 2094637 defendant Tristram James yeoman 587559 587559 Tristram, James, of Bampton, yeoman 0
4211260 2099489 2099489 defendant Trystram William yeoman 587559 587559 Trystram, William, of Bampton, yeoman 0
4213735 2100318 2100318 defendant Rickett Edward yeoman 587559 587559 Rickett, Edward, of Bampton, yeoman 1
4222658 2103417 2103417 defendant Dyer alias Tristram John husbandman 587559 587559 Dyer alias Tristram, John, of Bampton, husbandman 0
4222659 2103417 2103417 defendant Gryneslade John husbandman 587559 587559 Gryneslade, John, of Bampton, husbandman 1
4222660 2103417 2103417 defendant Roper alias Sutter James husbandman 587559 587559 together with Roper alias Sutter, James, of Bampton, husbandman 2
4222661 2103417 2103417 defendant Hodye John husbandman 587559 587559 Hodye, John, of Bampton, husbandman 3
4262138 2117012 2117012 defendant Dyer alias Tristram John husbandman 587559 587559 Dyer alias Tristram, John, of Bampton, husbandman 0
4262139 2117012 2117012 defendant Gryneslade John husbandman 587559 587559 Gryneslade, John, of Bampton, husbandman 1
4337700 2142931 2142931 defendant Stokes John husbandman 587559 587559 Stokes, John, of Bampton, husbandman 2
4337701 2142931 2142931 defendant Jellijohn Nicholas fisher 587559 587559 Jellijohn, Nicholas, of Bampton, fisher 3
4348786 2146835 2146835 defendant Tristram John gent 587559 587559 Tristram, John, of Bampton, gent 1
4409231 2167687 2167687 defendant Wade Roger yeoman 587559 587559 Wade, Roger, of Bampton, yeoman 1
4442478 2182595 2182595 defendant Walkere John   587559 587559 Walkere, John, of Bampton 0
4447162 2184020 2184020 defendant Wenser Ellis   587559 587559 Wenser, Ellis, of Bampton 1
4457235 2187271 2187271 defendant Patrik John walker 587559 587559 Patrik, John, of Bampton, walker 2
4465679 2189942 2189942 defendant Walker John   587559 587559 Walker, John, of Bampton 1
4487490 2196805 2196805 plaintiff Smyth Mathew   587559 587559 Smyth, Mathew, of Bampton 0
4497483 2199858 2199858 defendant Coke Henry   587559 587559 Coke, Henry, of Bampton 0
4508683 2203197 2203197 defendant Capenore John   587559 587559 Capenore, John, of Bampton 0
4511070 2203914 2203914 defendant Taillour Stephen   587559 587559 Taillour, Stephen, of Bampton 0
4511072 2203914 2203914 defendant Capenore John   587559 587559 Capenore, John, of Bampton 2
4537412 2211969 2211969 defendant Hardyng John   587559 587559 Hardyng, John, of Bampton 0
4537961 2212154 2212154 defendant Kyngeman William (legal representative) 587559 587559 Kyngeman, William, of Bampton, executors of 3
4539647 2212659 2212659 defendant Bokelond John   587559 587559 Bokelond, John, of Bampton 0
4543025 2213708 2213708 defendant Nobill John   587559 587559 Nobill, John, of Bampton 0
4545550 2214532 2214532 defendant Fremantell William   587559 587559 Fremantell, William, of Bampton 0
4555307 2217596 2217596 defendant Bakster Joan   587559 587559 Bakster, Joan, of Bampton, formerly wife of Walter 0
4555412 2217627 2217627 defendant Beteson John   587559 587559 Beteson, John, of Bampton 0
4567220 2221309 2221309 defendant Meleward John   587559 587559 Meleward, John, of Bampton 0
4573971 2223380 2223380 defendant Norman William   587559 587559 Norman, William, of Bampton 0
4575649 2223895 2223895 defendant Stoke Robert   587559 587559 Stoke, Robert, of Bampton 0
4610959 2234500 2234500 defendant Cokkull John   587559 587559 Cokkull, John, of Bampton 0
4616385 2236118 2236118 plaintiff Fremantell William   587559 587559 Fremantell, William, of Bampton 0
4616387 2236119 2236119 plaintiff Fremantell William   587559 587559 Fremantell, William, of Bampton 0
4624678 2238700 2238700 defendant Dalderby John   587559 587559 Dalderby, John, of Bampton 0
4631215 2240660 2240660 defendant Milward John   587559 587559 Milward, John, of Bampton 7
4635000 2241792 2241792 defendant Chapman John   587559 587559 Chapman, John, of Bampton 3
4635001 2241792 2241792 defendant Neweman John   587559 587559 Neweman, John, of Bampton 4
4640468 2243323 2243323 defendant Freman John   587559 587559 Freman, John, of Bampton 0
4645097 2244635 2244635 defendant Rous Robert   587559 587559 Rous, Robert, of Bampton 0
4645593 2244781 2244781 defendant Dalderby John   587559 587559 Dalderby, John, of Bampton 1
4648655 2245662 2245662 defendant Leche William   587559 587559 Leche, William, of Bampton 0
4648664 2245665 2245665 defendant Skynner Richard   587559 587559 Skynner, Richard, of Bampton 1
4648670 2245665 2245665 defendant Milward John   587559 587559 Milward, John, of Bampton 7
4660198 2249024 2249024 defendant Bakster William husbandman 587559 587559 Bakster, William, of Bampton, husbandman 6
4660199 2249024 2249024 defendant Baxster Henry husbandman 587559 587559 Baxster, Henry, of Bampton, husbandman 7
4660200 2249024 2249024 defendant Hotblak John Tomson husbandman 587559 587559 Hotblak, John Tomson, of Bampton, husbandman 8
4665598 2250713 2250713 defendant Wodell John, junior yeoman 587559 587559 Wodell, John, junior, of Bampton, yeoman 2
4679046 2259054 2259054 defendant Burgh John yeoman 587559 587559 Burgh, John, of Bampton, yeoman 4
4687644 2261717 2261717 defendant Leche John husbandman 587559 587559 Leche, John, of Bampton, husbandman 2
4709917 2268460 2268460 defendant Lemmde John husbandman 587559 587559 Lemmde, John, of Bampton, husbandman 0
4709918 2268460 2268460 defendant Bampton Barthomomew   587559 587559 Bampton, Barthomomew, of Bampton husbandman 1
4709919 2268460 2268460 defendant Panter William husbandman 587559 587559 Panter, William, of Bampton, husbandman 2
4714122 2269746 2269746 defendant Betson John yeoman 587559 587559 Betson, John, of Bampton, yeoman 3
4721991 2272207 2272207 defendant Walker Robert yeoman 587559 587559 Walker, Robert, of Bampton, yeoman 0
4721992 2272207 2272207 defendant Jacson Robert yeoman 587559 587559 together with Jacson, Robert, of Bampton, yeoman 1
4723219 2272571 2272571 plaintiff Dalby Thomas   587559 587559 Dalby, Thomas, of Bampton 0
4723220 2272571 2272571 defendant Assheford William   587559 587559 Assheford, William, of Bampton, holy water clerk 0
4732432 2275316 2275316 defendant Mathewson Roger yeoman 587559 587559 Mathewson, Roger, of Bampton, yeoman 1
4732433 2275316 2275316 defendant Mathewson William yeoman 587559 587559 Mathewson, William, of Bampton, yeoman 2
4741409 2277983 2277983 defendant Cordewainer John baker 587559 587559 (Cordewainer, John, of Bampton, baker 2
4749269 2280267 2280267 defendant Bocher John butcher 587559 587559 Bocher, John, of Bampton, butcher 1
4761938 2284080 2284080 defendant Hopere William   587559 587559 Hopere, William, of Bampton, vicar 0
4765031 2285039 2285039 plaintiff Hoper William   587559 587559 Hoper, William, of Bampton, vicar 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);