names

284 rows where place_id = 603511

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654790 1911757 1911757 defendant Horspole William clerk 603511 603511 Horspole, William, of Peterborough, clerk 0
3690962 1923336 1923336 defendant Panke Robert butcher 603511 603511 Panke, Robert, of Peterborough, butcher 0
3694372 1924443 1924443 defendant Gregory Thomas mercer 603511 603511 Gregory, Thomas, of Peterborough, mercer 4
3756088 1943860 1943860 defendant Rovenson alias Baker Richard baker 603511 603511 Rovenson alias Baker, Richard, of Peterborough, baker 1
3768249 1947709 1947709 defendant Alysson Christopher waterman 603511 603511 Alysson, Christopher, of Peterborough, waterman 0
3768250 1947709 1947709 defendant Grenold Thomas yeoman 603511 603511 Grenold, Thomas, of Peterborough, yeoman 1
3832731 1968161 1968161 defendant Robynson Richard baker 603511 603511 Robynson, Richard, of Peterborough, baker 0
3832733 1968162 1968162 defendant Robynson Richard baker 603511 603511 Robynson, Richard, of Peterborough, baker 0
3856739 1975735 1975735 defendant Walker Roger husbandman 603511 603511 Walker, Roger, of Peterborough, husbandman 0
3866253 1978940 1978940 defendant Culles Robert chandler 603511 603511 Culles, Robert, of Peterborough, chandler 0
3867920 1979504 1979504 defendant Panke Robert butcher 603511 603511 Panke, Robert, of Peterborough, butcher 0
3867921 1979504 1979504 defendant Clerke Robert butcher 603511 603511 Clerke, Robert, of Peterborough, butcher 1
3867922 1979504 1979504 defendant Hanche Thomas butcher 603511 603511 Hanche, Thomas, of Peterborough, butcher 2
3909534 1993492 1993492 defendant Baldewyn John butcher 603511 603511 Baldewyn, John, of Peterborough, butcher 0
3930091 2000410 2000410 defendant Robynson alias Baker Lawrence yeoman 603511 603511 Robynson alias Baker, Lawrence, of Peterborough, yeoman 0
3932767 2001262 2001262 defendant Peerson Robert clerk & prebendary 603511 603511 Peerson, Robert, of Peterborough, clerk & prebendary 1
3932768 2001262 2001262 defendant White Richard   603511 603511 White, Richard, of Peterborough, prebendary in the Cathedral 2
3955263 2008907 2008907 defendant Capstock Roger gent 603511 603511 Capstock, Roger, of Peterborough, gent 0
3957522 2009697 2009697 defendant Shyppe John   603511 603511 Shyppe, John, of Peterborough, Nhants yeoman 0
3988674 2020690 2020690 defendant Norrice Thomas chapman 603511 603511 Norrice, Thomas, of Peterborough, chapman 0
4001133 2025183 2025183 plaintiff Hacke Thomas gent 603511 603511 Hacke, Thomas, of Peterborough, gent 0
4018996 2031530 2031530 defendant Norrys Thomas smith 603511 603511 Norrys, Thomas, of Peterborough, smith 1
4021577 2032445 2032445 defendant Bowe Thomas   603511 603511 Bowe, Thomas, of Peterborough, Nhants vintner 0
4030239 2035466 2035466 defendant Norres Thomas ironmonger 603511 603511 Norres, Thomas, of Peterborough, ironmonger 0
4036176 2037622 2037622 defendant Norrys John waterman 603511 603511 Norrys, John, of Peterborough, waterman 3
4070135 2049608 2049608 plaintiff Manestie John   603511 603511 Manestie, John, of Peterborough, tallow chandler 0
4074579 2051211 2051211 defendant Norres Thomas waterman 603511 603511 Norres, Thomas, of Peterborough, waterman 0
4074580 2051211 2051211 defendant Taylor John yeoman 603511 603511 Taylor, John, of Peterborough, yeoman 1
4074581 2051211 2051211 defendant Wood William weaver 603511 603511 Wood, William, of Peterborough, weaver 2
4151881 2078769 2078769 defendant Tytley William yeoman 603511 603511 Tytley, William, of Peterborough, yeoman 0
4178063 2087798 2087798 defendant Mylner Alan fishmonger 603511 603511 Mylner, Alan, of Peterborough, fishmonger 1
4178066 2087799 2087799 defendant Mylner Allan fishmonger 603511 603511 Mylner, Allan, of Peterborough, fishmonger 1
4193319 2093230 2093230 defendant Ince Richard tailor 603511 603511 Ince, Richard, of Peterborough, tailor 2
4223236 2103618 2103618 defendant Manestie Thomas husbandman 603511 603511 Manestie, Thomas, of Peterborough, husbandman 1
4236807 2108450 2108450 defendant Thorpe Richard husbandman 603511 603511 Thorpe, Richard, of Peterborough, or of Farsett, Hunts, husbandman 0
4257436 2115460 2115460 defendant Thorpe Richard husbandman 603511 603511 Thorpe, Richard, of Peterborough, or of Farsett, Hunts, husbandman 0
4345796 2145793 2145793 defendant James William gent 603511 603511 James, William, of Peterborough, gent 0
4345798 2145794 2145794 defendant James John gent 603511 603511 James, John, of Peterborough, gent 0
4345800 2145795 2145795 defendant Rawson Augustine yeoman 603511 603511 Rawson, Augustine, of Peterborough, yeoman 0
4345802 2145796 2145796 defendant Ewesdale William yeoman 603511 603511 Ewesdale, William, of Peterborough, yeoman 0
4356465 2149490 2149490 defendant Carier Robert yeoman 603511 603511 Carier, Robert, of Peterborough, yeoman 1
4421397 2171595 2171595 defendant Lawys Walter   603511 603511 Lawys, Walter, of Peterborough 0
4442745 2182685 2182685 plaintiff Burton William   603511 603511 Burton, William, of Peterborough 0
4453416 2186074 2186074 plaintiff Leccheworth John   603511 603511 Leccheworth, John, of Peterborough 0
4455157 2186614 2186614 plaintiff Melton Helen de   603511 603511 Melton, Helen de, of Peterborough 0
4457516 2187362 2187362 defendant Clopton William chaplain 603511 603511 Clopton, William, of Peterborough, chaplain 0
4459486 2188020 2188020 plaintiff Sadeler Thomas   603511 603511 Sadeler, Thomas, of Peterborough 0
4459500 2188025 2188025 plaintiff Sadelere Thomas   603511 603511 Sadelere, Thomas, of Peterborough, linen draper 0
4459501 2188025 2188025 defendant Glatton John tanner 603511 603511 Glatton, John, of Peterborough, tanner 0
4490704 2197794 2197794 plaintiff Wartre John   603511 603511 Wartre, John, of Peterborough 0
4500485 2200773 2200773 defendant Newerk William   603511 603511 Newerk, William, of Peterborough 0
4501698 2201135 2201135 plaintiff Lynne John   603511 603511 Lynne, John, of Peterborough 0
4507325 2202754 2202754 plaintiff Wartre John   603511 603511 Wartre, John, of Peterborough 0
4527646 2208927 2208927 defendant Lynne John   603511 603511 Lynne, John, of Peterborough 0
4537677 2212056 2212056 defendant Botelbrygge John   603511 603511 Botelbrygge, John, of Peterborough 1
4550905 2216219 2216219 defendant Patynmaker John   603511 603511 Patynmaker, John, of Peterborough 0
4553315 2216971 2216971 plaintiff Garton Robert   603511 603511 Garton, Robert, of Peterborough 0
4553316 2216971 2216971 defendant Balsham Ralph   603511 603511 Balsham, Ralph, of Peterborough 0
4553451 2217007 2217007 defendant Burgh William   603511 603511 Burgh, William, of Peterborough 1
4565969 2220909 2220909 defendant Munstrechaumbre John   603511 603511 Munstrechaumbre, John, of Peterborough 0
4602975 2232145 2232145 defendant Dunysby Thomas   603511 603511 Dunysby, Thomas, of Peterborough 0
4602976 2232146 2232146 plaintiff Whitye Robert   603511 603511 Whitye, Robert, of Peterborough 0
4604450 2232560 2232560 defendant Dunysby Thomas   603511 603511 Dunysby, Thomas, of Peterborough 0
4609322 2234016 2234016 defendant Avenand John   603511 603511 Avenand, John, of Peterborough 0
4619133 2236980 2236980 plaintiff Hervy Richard   603511 603511 Hervy, Richard, of Peterborough 0
4630436 2240430 2240430 defendant Freston Richard   603511 603511 Freston, Richard, of Peterborough 0
4633298 2241278 2241278 plaintiff Wartre John   603511 603511 Wartre, John, of Peterborough 0
4646920 2245163 2245163 plaintiff Roos John   603511 603511 Roos, John, of Peterborough 0
4646921 2245163 2245163 defendant Newerke John   603511 603511 Newerke, John, of Peterborough 0
4669778 2256247 2256247 defendant Plomer Reginald laborer 603511 603511 Plomer, Reginald, of Peterborough, laborer 3
4681280 2259771 2259771 plaintiff Martyn John   603511 603511 Martyn, John, of Peterborough 0
4683764 2260527 2260527 defendant Oyward or Cyward Richard chapman 603511 603511 Oyward or Cyward, Richard, of Peterborough, chapman 0
4685287 2260994 2260994 defendant Ingram John butcher 603511 603511 Ingram, John, of Peterborough, butcher 0
4686415 2261356 2261356 plaintiff Skynner William   603511 603511 Skynner, William, of Peterborough 0
4686774 2261476 2261476 plaintiff Spaldyng William (legal representative) 603511 603511 Spaldyng, William, of Peterborough, executors of 0
4686780 2261477 2261477 plaintiff Spaldyng William (legal representative) 603511 603511 Spaldyng, William, of Peterborough, executors of 0
4692423 2263149 2263149 plaintiff atte Brygge Richard   603511 603511 atte Brygge, Richard, of Peterborough 0
4692426 2263150 2263150 plaintiff atte Brygge Richard   603511 603511 atte Brygge, Richard, of Peterborough 0
4706052 2267268 2267268 plaintiff Lewys John   603511 603511 Lewys, John, of Peterborough 0
4709583 2268356 2268356 defendant Forster John mercer 603511 603511 Forster, John, of Peterborough, mercer 0
4743901 2278744 2278744 plaintiff Deeping John   603511 603511 Deeping, John, of Peterborough, abbot 0
4743905 2278745 2278745 plaintiff Deeping John   603511 603511 Deeping, John, of Peterborough, abbot 0
4749876 2280436 2280436 defendant Dunnesby William husbandman 603511 603511 Dunnesby, William, of Peterborough, husbandman 0
4749879 2280437 2280437 defendant Wodeward John butcher 603511 603511 Wodeward, John, of Peterborough, butcher 1
4749880 2280437 2280437 defendant Cope John butcher 603511 603511 Cope, John, of Peterborough, butcher 2
4765875 2285322 2285322 defendant Temple Thomas de   603511 603511 Temple, Thomas de, of Peterborough, glove maker 0
4771254 2286991 2286991 defendant Marche John tailor 603511 603511 Marche, John, of Peterborough, tailor 0
4772329 2287310 2287310 defendant Wollewynder William   603511 603511 Wollewynder, William, of Peterborough, wool winder 0
4773194 2287585 2287585 defendant Wirkman John laborer 603511 603511 Wirkman, John, of Peterborough, laborer 0
4775427 2288311 2288311 defendant Gyldale Richard gent 603511 603511 Gyldale, Richard, of Peterborough, gent 0
4775799 2288428 2288428 defendant Bulwer John husbandman 603511 603511 Bulwer, John, of Peterborough, husbandman 0
4792013 2293607 2293607 defendant Wryght Robert   603511 603511 Wryght, Robert, of Peterborough, wright 0
4796706 2295123 2295123 defendant Stranglyon John   603511 603511 Stranglyon, John, of Peterborough, wright 1
4797468 2295379 2295379 defendant Wollewynder William woolwinder 603511 603511 Wollewynder, William, of Peterborough, woolwinder 0
4800547 2296353 2296353 defendant Avenant John skinner 603511 603511 Avenant, John, of Peterborough, skinner 0
4808978 2298983 2298983 plaintiff Deeping John   603511 603511 Deeping, John, of Peterborough, abbot of the monastery 0
4823002 2303275 2303275 defendant Marche John draper 603511 603511 Marche, John, of Peterborough, draper 1
4823966 2303570 2303570 defendant Wykeley Henry butcher 603511 603511 Wykeley, Henry, of Peterborough, butcher 2
4823967 2303570 2303570 defendant Lymbet Henry husbandman 603511 603511 Lymbet, Henry, of Peterborough, husbandman 3
4839060 2308145 2308145 defendant Grygge Henry shoemaker 603511 603511 Grygge, Henry, of Peterborough, shoemaker 1

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