names

241 rows where place_id = 606953

✎ 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
3667093 1915641 1915641 defendant Chepsey William chapman 606953 606953 Chepsey, William, of Northampton, Nhants, chapman 3
3929627 2000258 2000258 defendant Barnarde William chapman 606953 606953 Barnarde, William, of Northampton, Nhants, chapman 0
3937204 2002774 2002774 defendant Bowers Richard   606953 606953 Bowers, Richard, of Northampton, Nhants, inn holder 2
4410204 2168014 2168014 defendant Glover John yeoman 606953 606953 Glover, John, of Northampton, Nhants, yeoman 2
4670003 2256316 2256316 defendant Beggeworth William taverner 606953 606953 Beggeworth, William, of Northampton, Nhants, taverner 0
4670312 2256421 2256421 defendant Sutton Thomas chapman 606953 606953 Sutton, Thomas, of Northampton, Nhants, chapman 2
4674912 2257764 2257764 defendant Lak Thomas mercer 606953 606953 Lak, Thomas, of Northampton, Nhants, mercer 0
4677339 2258532 2258532 defendant Mey Richard mercer 606953 606953 Mey, Richard, of Northampton, Nhants, mercer 0
4680493 2259512 2259512 defendant Carvell William esq 606953 606953 Carvell, William, of Northampton, Nhants, esq 0
4682258 2260074 2260074 defendant Palmer John yeoman 606953 606953 Palmer, John, of Northampton, Nhants, yeoman 0
4682261 2260075 2260075 defendant Palmer John, senior yeoman 606953 606953 Palmer, John, senior, of Northampton, Nhants, yeoman 0
4684603 2260783 2260783 defendant Ferers Edmund husbandman 606953 606953 Ferers, Edmund, of Northampton, Nhants, husbandman 0
4686153 2261263 2261263 defendant Beston Thomas gent 606953 606953 Beston, Thomas, of Northampton, Nhants, gent 2
4686156 2261264 2261264 defendant Beeston Thomas gent 606953 606953 with Beeston, Thomas, of Northampton, Nhants, gent 1
4688979 2262110 2262110 defendant Bryghtwell William husbandman 606953 606953 Bryghtwell, William, of Northampton, Nhants, husbandman 0
4692343 2263122 2263122 defendant Sutton Thomas draper 606953 606953 Sutton, Thomas, of Northampton, Nhants, draper 0
4692345 2263123 2263123 defendant Sutton Thomas draper 606953 606953 Sutton, Thomas, of Northampton, Nhants, draper 0
4695572 2264099 2264099 defendant Fererres Edmund husbandman 606953 606953 Fererres, Edmund, of Northampton, Nhants, husbandman 0
4697701 2264773 2264773 defendant Spencer William merchant 606953 606953 Spencer, William, of Northampton, Nhants, merchant 0
4697703 2264774 2264774 defendant Spencer William merchant 606953 606953 Spencer, William, of Northampton, Nhants, merchant 0
4700062 2265442 2265442 defendant Clerk Roger barber 606953 606953 Clerk, Roger, of Northampton, Nhants, barber 0
4702219 2266103 2266103 defendant Clerk Roger barber 606953 606953 Clerk, Roger, of Northampton, Nhants, barber 0
4704430 2266760 2266760 defendant Mokes Thomas dyer 606953 606953 Mokes, Thomas, of Northampton, Nhants, dyer 1
4705291 2267027 2267027 defendant Northborw John painter 606953 606953 Northborw, John, of Northampton, Nhants, painter 1
4718664 2271177 2271177 defendant Bartram John mercer 606953 606953 Bartram, John, of Northampton, Nhants, mercer 0
4720546 2271763 2271763 defendant Fererres Edmund husbandman 606953 606953 Fererres, Edmund, of Northampton, Nhants, husbandman 0
4724091 2272830 2272830 defendant Ferrers Edmund gent 606953 606953 Ferrers, Edmund, of Northampton, Nhants, gent 0
4724575 2272983 2272983 defendant Carvell William esq 606953 606953 Carvell, William, of Northampton, Nhants, esq 0
4725276 2273195 2273195 defendant Blaby Thomas merchant 606953 606953 Blaby, Thomas, of Northampton, Nhants, merchant 3
4725522 2273273 2273273 defendant Wedon John smith 606953 606953 Wedon, John, of Northampton, Nhants, smith 0
4725971 2273408 2273408 defendant Keche Robert husbandman 606953 606953 Keche, Robert, of Northampton, Nhants, husbandman 2
4727138 2273748 2273748 defendant Serle Geoffrey shoemaker 606953 606953 Serle, Geoffrey, of Northampton, Nhants, shoemaker 0
4739441 2277420 2277420 defendant Newene Ralph yeoman 606953 606953 Newene, Ralph, of Northampton, Nhants, yeoman 1
4744200 2278830 2278830 defendant Ferris Edmund   606953 606953 Ferris, Edmund, of Northampton, Nhants, franklin 0
4744203 2278831 2278831 defendant Ferrys Edmund   606953 606953 Ferrys, Edmund, of Northampton, Nhants, franklin 0
4744261 2278844 2278844 defendant Blaby Thomas mercer 606953 606953 Blaby, Thomas, of Northampton, Nhants, mercer 1
4744698 2278967 2278967 defendant Shawe William chapman 606953 606953 Shawe, William, of Northampton, Nhants, chapman 2
4749259 2280265 2280265 defendant Apethorpe John yeoman 606953 606953 Apethorpe, John, of Northampton, Nhants, yeoman 2
4752334 2281143 2281143 defendant Fabiane Richard singer 606953 606953 (Fabiane, Richard, of Northampton, Nhants, singer 1
4754376 2281749 2281749 defendant Neuton William   606953 606953 Neuton, William, of Northampton, Nhants, leche 0
4760868 2283739 2283739 defendant Iremonger Thomas husbandman 606953 606953 Iremonger, Thomas, of Northampton, Nhants, husbandman 0
4761890 2284063 2284063 defendant Hogekyns Thomas chapman 606953 606953 Hogekyns, Thomas, of Northampton, Nhants, chapman 0
4763213 2284482 2284482 defendant Ferrers Edmund merchant 606953 606953 Ferrers, Edmund, of Northampton, Nhants, merchant 0
4766205 2285422 2285422 defendant Colshull William   606953 606953 Colshull, William, of Northampton, Nhants, shoe maker 0
4767134 2285706 2285706 defendant Mokes Thomas dyer 606953 606953 Mokes, Thomas, of Northampton, Nhants, dyer 0
4769577 2286463 2286463 defendant Kynge John butcher 606953 606953 Kynge, John, of Northampton, Nhants, butcher 0
4772939 2287507 2287507 defendant Fordyngton William   606953 606953 Fordyngton, William, of Northampton, Nhants, physician 0
4775136 2288217 2288217 defendant Revele or Renele John dyer 606953 606953 Revele or Renele, John, of Northampton, Nhants, dyer 2
4803432 2297261 2297261 defendant Wynnewyk William clerk 606953 606953 Wynnewyk, William, of Northampton, Nhants, clerk 0
4803834 2297376 2297376 defendant Braunston John vintner 606953 606953 Braunston, John, of Northampton, Nhants, vintner 0
4803836 2297377 2297377 defendant Braunston John vintner 606953 606953 Braunston, John, of Northampton, Nhants, vintner 0
4804920 2297742 2297742 defendant Boseworthe John drover 606953 606953 Boseworthe, John, of Northampton, Nhants, drover 0
4805532 2297943 2297943 defendant Donce John shoemaker 606953 606953 Donce, John, of Northampton, Nhants, shoemaker 0
4805534 2297944 2297944 defendant Donce John shoemaker 606953 606953 Donce, John, of Northampton, Nhants, shoemaker 0
4808030 2298690 2298690 defendant Torald Ralph spicer 606953 606953 Torald, Ralph, of Northampton, Nhants, spicer 0
4808230 2298750 2298750 defendant Balderwell Ralph   606953 606953 Balderwell, Ralph, of Northampton, Nhants 1
4810370 2299389 2299389 defendant Forshagh Gilbert mercer 606953 606953 Forshagh, Gilbert, of Northampton, Nhants, mercer 0
4810372 2299390 2299390 defendant Forshagh Gilbert mercer 606953 606953 Forshagh, Gilbert, of Northampton, Nhants, mercer 0
4823039 2303288 2303288 plaintiff Spryggy John draper 606953 606953 Spryggy, John, of Northampton, Nhants, draper 0
4824443 2303695 2303695 defendant Parkhous Thomas yeoman 606953 606953 Parkhous, Thomas, of Northampton, Nhants, yeoman 1
4825590 2304044 2304044 defendant Bowedon John dyer 606953 606953 Bowedon, John, of Northampton, Nhants, dyer 0
4825592 2304045 2304045 defendant Bowedon John dyer 606953 606953 Bowedon, John, of Northampton, Nhants, dyer 0
4825594 2304046 2304046 defendant Baker John dyer 606953 606953 Baker, John, of Northampton, Nhants, dyer 0
4825598 2304048 2304048 defendant Baker John dyer 606953 606953 Baker, John, of Northampton, Nhants, dyer 0
4827919 2304788 2304788 defendant Doweman Thomas dyer 606953 606953 Doweman, Thomas, of Northampton, Nhants, dyer 0
4828214 2304868 2304868 defendant Bertram John mercer 606953 606953 Bertram, John, of Northampton, Nhants, mercer 0
4828818 2305049 2305049 defendant Spencer William   606953 606953 Spencer, William, of Northampton, Nhants, wool man 0
4831696 2305941 2305941 defendant Boseworth John chapman 606953 606953 Boseworth, John, of Northampton, Nhants, chapman 0
4836868 2307490 2307490 defendant Taillour Richard chapman 606953 606953 Taillour, Richard, of Northampton, Nhants, chapman 4
4839957 2308409 2308409 defendant Fauken John dyer 606953 606953 Fauken, John, of Northampton, Nhants, dyer 0
4842729 2309263 2309263 defendant Boseworth John chapman 606953 606953 Boseworth, John, of Northampton, Nhants, chapman 0
4851573 2311927 2311927 defendant Faucon John dyer 606953 606953 Faucon, John, of Northampton, Nhants, dyer 0
4851579 2311928 2311928 defendant Fanton John dyer 606953 606953 Fanton, John, of Northampton, Nhants, dyer 0
4852553 2312220 2312220 defendant Doweman Thomas dyer 606953 606953 Doweman, Thomas, of Northampton, Nhants, dyer 0
4852568 2312225 2312225 defendant Doweman Thomas dyer 606953 606953 Doweman, Thomas, of Northampton, Nhants, dyer 0
4852583 2312229 2312229 defendant Doweman Thomas dyer 606953 606953 Doweman, Thomas, of Northampton, Nhants, dyer 0
4853040 2312369 2312369 defendant Scheshe Gerard gent 606953 606953 Scheshe, Gerard, of Northampton, Nhants, gent 2
4853047 2312371 2312371 defendant Schesse Gerard gent 606953 606953 Schesse, Gerard, of Northampton, Nhants, gent 1
4853952 2312645 2312645 defendant Boseworth John yeoman 606953 606953 Boseworth, John, of Northampton, Nhants, yeoman 2
4853958 2312646 2312646 defendant Boseworth John yeoman 606953 606953 Boseworth, John, of Northampton, Nhants, yeoman 2
4913044 2330575 2330575 defendant Cotesbroke John skinner 606953 606953 Cotesbroke, John, of Northampton, Nhants, skinner 0
4913567 2330740 2330740 defendant Doweman Thomas   606953 606953 Doweman, Thomas, of Northampton, Nhants 0
4916841 2331770 2331770 defendant Clerk John jeweller 606953 606953 Clerk, John, of Northampton, Nhants, jeweller 0
4917925 2332121 2332121 defendant Arnold Hugh fuller 606953 606953 Arnold, Hugh, of Northampton, Nhants, fuller 0
4917927 2332122 2332122 defendant Fysshe Richard tailor 606953 606953 Fysshe, Richard, of Northampton, Nhants, tailor 0
4919096 2332485 2332485 defendant Spriggy John gent 606953 606953 Spriggy, John, of Northampton, Nhants, gent 0
4922668 2333502 2333502 defendant Hancok Thomas chapman 606953 606953 Hancok, Thomas, of Northampton, Nhants, chapman 0
4924025 2333952 2333952 defendant Man William   606953 606953 Man, William, of Northampton, Nhants 3
4924670 2334152 2334152 defendant Spriggy John esq 606953 606953 Spriggy, John, of Northampton, Nhants, esq 0
4924674 2334153 2334153 defendant Spryggy John esq 606953 606953 Spryggy, John, of Northampton, Nhants, esq 0
4924749 2334175 2334175 defendant Clerk John chapman 606953 606953 Clerk, John, of Northampton, Nhants, chapman 2
4925217 2334319 2334319 defendant Marchall John drover 606953 606953 Marchall, John, of Northampton, Nhants, drover 0
4925340 2334357 2334357 defendant Spryggy John esq 606953 606953 Spryggy, John, of Northampton, Nhants, esq 0
4927606 2335072 2335072 defendant Spriggy John draper 606953 606953 Spriggy, John, of Northampton, Nhants, draper 0
4927962 2335177 2335177 defendant Hoggekyn Thomas chapman 606953 606953 Hoggekyn, Thomas, of Northampton, Nhants, chapman 0
4928091 2335218 2335218 defendant Swan Edmund chandler 606953 606953 Swan, Edmund, of Northampton, Nhants, chandler 0
4928899 2335461 2335461 plaintiff Spryggy John draper 606953 606953 Spryggy, John, of Northampton, Nhants, draper 0
4930330 2335886 2335886 defendant Dowenam Thomas dyer 606953 606953 Dowenam, Thomas, of Northampton, Nhants, dyer 0
4989235 2353714 2353714 defendant Longe Robert gent 606953 606953 Longe, Robert, of Northampton, Nhants, gent 1
4991925 2354474 2354474 defendant Selusby William gent 606953 606953 Selusby, William, of Northampton, Nhants, gent 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);