names

216 rows where place_id = 599063

✎ 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
3635056 1905763 1905763 defendant Hall Thomas gent 599063 599063 Hall, Thomas, of Huntingdon, gent 2
3646536 1909317 1909317 defendant Parker Henry draper 599063 599063 Parker, Henry, of Huntingdon, draper 2
3659891 1913350 1913350 defendant Cowper William mercer 599063 599063 Cowper, William, of Huntingdon, mercer 1
3718060 1931943 1931943 plaintiff Feldyng Peter gent 599063 599063 Feldyng, Peter, of Huntingdon, gent 0
3752258 1942628 1942628 defendant Cowper William gent 599063 599063 Cowper, William, of Huntingdon, gent 3
3825508 1965828 1965828 defendant Hartford Robert brewer 599063 599063 Hartford, Robert, of Huntingdon, brewer 0
3825510 1965829 1965829 defendant Hartford Robert brewer 599063 599063 Hartford, Robert, of Huntingdon, brewer 0
3831258 1967662 1967662 defendant Herrys John smith 599063 599063 Herrys, John, of Huntingdon, smith 0
3895171 1988592 1988592 defendant Berns Simon beer brewer 599063 599063 Berns, Simon, of Huntingdon, beer brewer 2
3918794 1996612 1996612 defendant Edward John chapman 599063 599063 Edward, John, of Huntingdon, chapman 0
3926469 1999184 1999184 defendant Cowper William (legal representative) 599063 599063 Cowper, William, of Huntingdon, chapman, executors of 0
3949429 2006874 2006874 plaintiff Edward Thomas merchant 599063 599063 Edward, Thomas, of Huntingdon, merchant 0
3949430 2006874 2006874 plaintiff Alyngton Henry merchant 599063 599063 Alyngton, Henry, of Huntingdon, merchant 1
3990534 2021366 2021366 defendant Bedford Thomas chapman 599063 599063 Bedford, Thomas, of Huntingdon, chapman 1
3995305 2023061 2023061 defendant Lampkyn William pewterer 599063 599063 Lampkyn, William, of Huntingdon, pewterer 0
3999881 2024726 2024726 plaintiff Gaye William yeoman 599063 599063 Gaye, William, of Huntingdon, yeoman 0
4049366 2042219 2042219 defendant Jackson Anne widow 599063 599063 Anne his wife, formerly Anne Blinckecarne, of Huntingdon, widow 1
4049367 2042220 2042220 plaintiff Turpyn John gent 599063 599063 Turpyn, John, of Huntingdon, gent 0
4049370 2042220 2042220 defendant Jackson Anne widow 599063 599063 Anne his wife, formerly Anne Blinckecarne, of Huntingdon, widow 1
4066422 2048286 2048286 defendant Whitlame Simon yeoman 599063 599063 Whitlame, Simon, of Huntingdon, yeoman 0
4106463 2062602 2062602 defendant Jaye Richard chandler 599063 599063 Jaye, Richard, of Huntingdon, chandler 2
4115897 2065970 2065970 defendant Barlie Richard gent 599063 599063 Barlie, Richard, of Huntingdon, or of Barnards Inn, Holborn, gent 0
4132398 2071904 2071904 defendant Butterworth William yeoman 599063 599063 Butterworth, William, of Huntingdon, or of Rokingham, Nhants, yeoman 0
4137698 2073838 2073838 defendant Barnard Thomas brewer 599063 599063 Barnard, Thomas, of Huntingdon, brewer 2
4162458 2082430 2082430 defendant Collye Thomas yeoman 599063 599063 Collye, Thomas, of Huntingdon, yeoman 0
4191927 2092737 2092737 defendant Norton William yeoman 599063 599063 Norton, William, of Huntingdon, or of Stamforde, Lincs, yeoman 0
4191928 2092737 2092737 defendant Thomson William yeoman 599063 599063 Thomson, William, of Huntingdon, yeoman 1
4191929 2092737 2092737 defendant Parker Robert yeoman 599063 599063 Parker, Robert, of Huntingdon, or of Water Breach, Cams, yeoman 2
4191931 2092738 2092738 defendant Norton William yeoman 599063 599063 Norton, William, of Huntingdon, or of Staunforde, Lincs, yeoman 0
4191932 2092738 2092738 defendant Thomson William yeoman 599063 599063 Thomson, William, of Huntingdon, or of Staunforde, yeoman 1
4191933 2092738 2092738 defendant Parker Eobert yeoman 599063 599063 Parker, Eobert, of Huntingdon, or of Waterbeach, Cams, yeoman 2
4198793 2095138 2095138 defendant Baxter William yeoman 599063 599063 Baxter, William, of Huntingdon, yeoman 2
4200059 2095571 2095571 defendant Danford Thomas baker 599063 599063 Danford, Thomas, of Huntingdon, or of Rockingam, Nhants, baker 0
4200060 2095571 2095571 defendant Barnard Richard gent 599063 599063 Barnard, Richard, of Huntingdon, or of Corbie, Nhants, gent 1
4200062 2095572 2095572 defendant Danford Thomas baker 599063 599063 Danford, Thomas, of Huntingdon, or of Rockingham, Nhants, baker 0
4203598 2096814 2096814 defendant Goodman George yeoman 599063 599063 Goodman, George, of Huntingdon, or of West Langton, Leics, yeoman 0
4203600 2096815 2096815 defendant Goodman George yeoman 599063 599063 Goodman, George, of Huntingdon, or of West Langton, Leics, yeoman 0
4241350 2110092 2110092 defendant Lewens alias Gawyne Peter yeoman 599063 599063 Lewens alias Gawyne, Peter, of Huntingdon, yeoman 1
4241354 2110093 2110093 defendant Lewens alias Gawyne Peter yeoman 599063 599063 Lewens alias Gawyne, Peter, of Huntingdon, yeoman 1
4252048 2113674 2113674 defendant Edwardes Richard woolman 599063 599063 Edwardes, Richard, of Huntingdon, woolman 0
4252049 2113674 2113674 defendant Langley William clothier 599063 599063 Langley, William, of Huntingdon, clothier 1
4252052 2113675 2113675 defendant Edwardes Richard woolman 599063 599063 Edwardes, Richard, of Huntingdon, woolman 0
4252053 2113675 2113675 defendant Laughley William clothier 599063 599063 Laughley, William, of Huntingdon, clothier 1
4256127 2115030 2115030 defendant Newman alias Turner William yeoman 599063 599063 Newman alias Turner, William, of Huntingdon, or of Sudbury, Suff, yeoman 1
4257427 2115457 2115457 defendant Jaye Robert, senior   599063 599063 Jaye, Robert, senior, of Huntingdon, tallow chandler 0
4335830 2142263 2142263 defendant Ambrie Richard husbandman 599063 599063 Ambrie, Richard, of Huntingdon, or of Roxston, Beds, husbandman 0
4337154 2142722 2142722 defendant Wyseman Samuel gent 599063 599063 Wyseman, Samuel, of Huntingdon, gent 0
4339942 2143744 2143744 defendant Wiseman Samuel gent 599063 599063 Wiseman, Samuel, of Huntingdon, gent 0
4340532 2143954 2143954 defendant Slade Thomas (legal representative) 599063 599063 Slade, Thomas, of Huntingdon, esq, administratrix of 0
4347278 2146306 2146306 defendant Wiseman Samuel gent 599063 599063 Wiseman, Samuel, of Huntingdon, gent 0
4347282 2146307 2146307 defendant Mosgrave Original tailor 599063 599063 Mosgrave, Original, of Huntingdon, tailor 2
4378256 2157289 2157289 defendant Lamkyne William pewterer 599063 599063 Lamkyne, William, of Huntingdon, pewterer 0
4405192 2166313 2166313 defendant Whyffyn John yeoman 599063 599063 Whyffyn, John, of Huntingdon, or of Hatfield Brodock, Essex, yeoman 0
4419202 2170880 2170880 defendant Bykeleswade William   599063 599063 Bykeleswade, William, of Huntingdon 0
4423214 2172117 2172117 defendant Hicchene Peter master of the hospital of St John 599063 599063 Hicchene, Peter, of Huntingdon, master of the hospital of St John 0
4428282 2173678 2173678 plaintiff Stilton John ironmonger 599063 599063 Stilton, John, of Huntingdon, ironmonger 0
4439766 2181713 2181713 defendant Cristemesse William   599063 599063 Cristemesse, William, of Huntingdon 0
4443029 2182781 2182781 defendant Chapman James   599063 599063 Chapman, James, of Huntingdon 0
4457130 2187240 2187240 defendant Chaundeler Richard   599063 599063 Chaundeler, Richard, of Huntingdon 0
4457131 2187240 2187240 defendant Drayton Edmund   599063 599063 Drayton, Edmund, of Huntingdon 1
4457132 2187240 2187240 defendant Goldsmyth John   599063 599063 together with Goldsmyth, John, of Huntingdon 2
4467077 2190374 2190374 defendant Foxton John   599063 599063 Foxton, John, of Huntingdon 0
4476310 2193254 2193254 plaintiff Freng John   599063 599063 Freng, John, of Huntingdon 0
4477564 2193652 2193652 plaintiff Gyddyng Ralph de   599063 599063 Gyddyng, Ralph de, of Huntingdon 0
4492914 2198485 2198485 defendant Prentys Richard   599063 599063 Prentys, Richard, of Huntingdon 3
4492915 2198485 2198485 defendant Foxton John, senior   599063 599063 Foxton, John, senior, of Huntingdon 4
4516220 2205481 2205481 defendant Pantrye Thomas de draper 599063 599063 Pantrye, Thomas de, of Huntingdon, draper 0
4518065 2206024 2206024 defendant Cristemesse Emma   599063 599063 Cristemesse, Emma, of Huntingdon 0
4522362 2207338 2207338 defendant Verdon John   599063 599063 Verdon, John, of Huntingdon, esquire 0
4532392 2210398 2210398 defendant Carleell William barber 599063 599063 Carleell, William, of Huntingdon, barber 0
4533616 2210782 2210782 plaintiff (not given) Henry prior of Rokesdon 599063 599063 Rokesdon, Henry, of Huntingdon, prior of the church of the BM 0
4586681 2227243 2227243 defendant Neuton Ambrose   599063 599063 Neuton, Ambrose, of Huntingdon 0
4586688 2227245 2227245 defendant Capron Thomas   599063 599063 Capron, Thomas, of Huntingdon 0
4586695 2227246 2227246 defendant Neuton Ambrose   599063 599063 Neuton, Ambrose, of Huntingdon 0
4587450 2227479 2227479 defendant Trappe Nicholas master of the hospital of St John 599063 599063 Trappe, Nicholas, of Huntingdon, master of the hospital of St John 0
4587452 2227480 2227480 defendant Trappe Nicholas clerk 599063 599063 Trappe, Nicholas, of Huntingdon, clerk 0
4592277 2228931 2228931 defendant Spicer William   599063 599063 Spicer, William, of Huntingdon 0
4593906 2229370 2229370 defendant Sayer John   599063 599063 Sayer, John, of Huntingdon 6
4597317 2230399 2230399 defendant Burgh Nicholas de   599063 599063 Burgh, Nicholas de, of Huntingdon 0
4608788 2233853 2233853 defendant Bocher Hugh   599063 599063 Bocher, Hugh, of Huntingdon 1
4608790 2233853 2233853 defendant Coupere John   599063 599063 Coupere, John, of Huntingdon 3
4617981 2236631 2236631 defendant Wesebury John   599063 599063 Wesebury, John, of Huntingdon, parson of St Andrew's church 0
4623255 2238246 2238246 defendant Litster John   599063 599063 Litster, John, of Huntingdon 3
4628527 2239844 2239844 defendant Foxton John, sen   599063 599063 Foxton, John, sen, of Huntingdon 0
4635669 2242004 2242004 defendant Lauerence R_   599063 599063 Lauerence, R_, of Huntingdon 1
4635671 2242004 2242004 defendant Caux John   599063 599063 Caux, John, of Huntingdon 3
4635672 2242004 2242004 defendant Fuller Robert   599063 599063 Fuller, Robert, of Huntingdon 4
4635673 2242004 2242004 defendant Hawkyn John   599063 599063 Hawkyn, John, of Huntingdon 5
4635674 2242004 2242004 defendant cuttler John   599063 599063 cuttler, John, of Huntingdon 6
4635987 2242088 2242088 defendant Draper Thomas   599063 599063 Draper, Thomas, of Huntingdon 0
4637257 2242446 2242446 defendant Coteleyr John   599063 599063 Coteleyr, John, of Huntingdon 4
4640365 2243296 2243296 defendant Cokkes Richard draper 599063 599063 Cokkes, Richard, of Huntingdon, draper 1
4642603 2243953 2243953 defendant Breston John   599063 599063 Breston, John, of Huntingdon 4
4644853 2244562 2244562 defendant Litster John   599063 599063 Litster, John, of Huntingdon 3
4644854 2244562 2244562 defendant Barbour Thomas   599063 599063 Barbour, Thomas, of Huntingdon 4
4644856 2244562 2244562 defendant Cook William taverner 599063 599063 Cook, William, of Huntingdon, taverner 6
4646436 2245022 2245022 plaintiff Preston John   599063 599063 Preston, John, of Huntingdon 0
4647702 2245385 2245385 defendant Bochere Hugh   599063 599063 Bochere, Hugh, of Huntingdon 0
4649644 2245925 2245925 defendant Turnour John furbisher 599063 599063 Turnour, John, of Huntingdon, furbisher 0
4655771 2247688 2247688 defendant Curriour John cordwainer 599063 599063 Curriour, John, of Huntingdon, cordwainer 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);