names

267 rows where place_id = 590039

✎ 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
3599666 1867537 1867537 defendant Nicoll Philip husbandman 590039 590039 Nicoll, Philip, of Huntyngdon, husbandman 0
3599667 1867537 1867537 defendant ap Ivor Owen laborer 590039 590039 ap Ivor, Owen, of Huntyngdon, laborer 1
3612816 1871657 1871657 defendant Flete Hugh baker 590039 590039 Flete, Hugh, of Huntyngdon, baker 4
3618854 1873509 1873509 defendant Riche Robert husbandman 590039 590039 Riche, Robert, of Huntyngdon, husbandman 0
3626574 1903163 1903163 defendant Coryer John butcher 590039 590039 Coryer, John, of Huntyngdon, butcher 0
3636662 1906258 1906258 defendant Sudbury John yeoman 590039 590039 Sudbury, John, of Huntyngdon, yeoman 0
3641471 1907791 1907791 defendant Kyng William baker 590039 590039 Kyng, William, of Huntyngdon, baker 0
3665295 1915099 1915099 defendant Coryar John butcher 590039 590039 Coryar, John, of Huntyngdon, butcher 0
3673456 1917720 1917720 defendant Algar William yeoman 590039 590039 Algar, William, of Huntyngdon, yeoman 0
3673457 1917720 1917720 defendant Cotteston William smith 590039 590039 Cotteston, William, of Huntyngdon, smith 1
3680366 1919939 1919939 defendant Folke Walter   590039 590039 Folke, Walter, of Huntyngdon 0
3681580 1920329 1920329 defendant Parker Henry draper 590039 590039 Parker, Henry, of Huntyngdon, draper 0
3688950 1922705 1922705 plaintiff Drewre Richard (legal representative) 590039 590039 Drewre, Richard, of Huntyngdon, executors of 0
3699001 1925898 1925898 defendant Cowper William chapman 590039 590039 Cowper, William, of Huntyngdon, chapman 0
3705402 1927975 1927975 plaintiff Halle Thomas gent 590039 590039 Halle, Thomas, of Huntyngdon, gent 0
3705404 1927976 1927976 plaintiff Halle Thomas gent 590039 590039 Halle, Thomas, of Huntyngdon, gent 0
3718571 1932085 1932085 defendant Stevyns John husbandman 590039 590039 Stevyns, John, of Huntyngdon, husbandman 1
3718574 1932085 1932085 defendant Aldeford William husbandman 590039 590039 Aldeford, William, of Huntyngdon, husbandman 4
3720378 1932652 1932652 defendant Tayllour Thomas mercer 590039 590039 Tayllour, Thomas, of Huntyngdon, mercer 3
3720491 1932692 1932692 defendant Kysbe Richard fisher and gaoler 590039 590039 Kysbe, Richard, of Huntyngdon, fisher and gaoler 0
3735200 1937243 1937243 plaintiff Halle Thomas   590039 590039 Halle, Thomas, of Huntyngdon, doctor of medicine 0
3743293 1939772 1939772 defendant Cowper William chapman 590039 590039 Cowper, William, of Huntyngdon, chapman 0
3743516 1939848 1939848 defendant Walls Richard miller 590039 590039 Walls, Richard, of Huntyngdon, miller 1
3754282 1943290 1943290 defendant Hynd Thomas dyer 590039 590039 Hynd, Thomas, of Huntyngdon, dyer 0
3777430 1950689 1950689 defendant Stewcley Thomas gent 590039 590039 Stewcley, Thomas, of Huntyngdon, gent 0
3783074 1952462 1952462 defendant Horwod Thomas saddler 590039 590039 Horwod, Thomas, of Huntyngdon, saddler 0
3789287 1954467 1954467 defendant Steucley Thomas gent 590039 590039 Steucley, Thomas, of Huntyngdon, gent 0
3802740 1958755 1958755 plaintiff Phylippe John   590039 590039 Phylippe, John, of Huntyngdon 0
3802741 1958755 1958755 defendant Herford Robert gent 590039 590039 Herford, Robert, of Huntyngdon, gent 0
3809662 1960910 1960910 defendant Broune John husbandman 590039 590039 Broune, John, of Huntyngdon, husbandman 0
3809663 1960910 1960910 defendant Cowper William husbandman 590039 590039 Cowper, William, of Huntyngdon, husbandman 1
3862411 1977621 1977621 defendant Metcalfe Henry baker 590039 590039 Metcalfe, Henry, of Huntyngdon, baker 0
3889903 1986862 1986862 defendant Basse Francis chapman 590039 590039 Basse, Francis, of Huntyngdon, chapman 2
3892534 1987748 1987748 defendant Hande Thomas smith 590039 590039 Hande, Thomas, of Huntyngdon, smith 0
3894351 1988327 1988327 defendant Heyer Robert yeoman 590039 590039 Heyer, Robert, of Huntyngdon, yeoman 2
3896168 1988921 1988921 plaintiff Thonge William   590039 590039 Thonge, William, of Huntyngdon 0
3910429 1993804 1993804 defendant Harford Robert gent 590039 590039 Harford, Robert, of Huntyngdon, gent 0
3919063 1996700 1996700 defendant Cowper William (legal representative) 590039 590039 Cowper, William, of Huntyngdon, chapman, executrix of 0
3919603 1996888 1996888 defendant Drewry Linus mercer 590039 590039 Drewry, Linus, of Huntyngdon, mercer 0
3995296 2023058 2023058 defendant Edward Thomas   590039 590039 Edward, Thomas, of Huntyngdon, linen draper 0
3995297 2023058 2023058 defendant Barnarde Henry yeoman 590039 590039 Barnarde, Henry, of Huntyngdon, yeoman 1
3995299 2023059 2023059 defendant Edward Thomas   590039 590039 Edward, Thomas, of Huntyngdon, linen draper 0
3995300 2023059 2023059 defendant Burnarde Henry yeoman 590039 590039 Burnarde, Henry, of Huntyngdon, yeoman 1
3995301 2023059 2023059 defendant Taylor Robert weaver 590039 590039 Taylor, Robert, of Huntyngdon, weaver 2
3995303 2023060 2023060 defendant Edward Thomas yeoman 590039 590039 Edward, Thomas, of Huntyngdon, yeoman 0
4061212 2046417 2046417 defendant Lamkyn William pewterer 590039 590039 Lamkyn, William, of Huntyngdon, pewterer 0
4124183 2068939 2068939 defendant Yonge Thomas yeoman 590039 590039 Yonge, Thomas, of Huntyngdon, or of Abbatt Ripton, yeoman 0
4124184 2068939 2068939 defendant Walker Henry yeoman 590039 590039 Walker, Henry, of Huntyngdon, yeoman 1
4421523 2171635 2171635 defendant Nicholes William   590039 590039 Nicholes, William, of Huntyngdon 8
4421525 2171635 2171635 defendant atte Mersh John   590039 590039 atte Mersh, John, of Huntyngdon 10
4423217 2172118 2172118 defendant Hichene Robert de   590039 590039 Hichene, Robert de, of Huntyngdon, son of Robert 0
4427564 2173455 2173455 plaintiff Scot Roger   590039 590039 Scot, Roger, of Huntyngdon 0
4442728 2182678 2182678 defendant Cartere John   590039 590039 Cartere, John, of Huntyngdon 0
4449450 2184773 2184773 plaintiff Goddyng Ralph   590039 590039 Goddyng. Ralph, of Huntyngdon 0
4456335 2187005 2187005 defendant Luton John   590039 590039 Luton, John, of Huntyngdon 0
4459317 2187964 2187964 plaintiff Rudham Walter   590039 590039 Rudham, Walter, of Huntyngdon 0
4461683 2188714 2188714 defendant Taverner John   590039 590039 Taverner, John, of Huntyngdon 0
4471645 2191794 2191794 defendant Darell William   590039 590039 Darell, William, of Huntyngdon 4
4477566 2193653 2193653 plaintiff Gyddyng Ralph de   590039 590039 Gyddyng, Ralph de, of Huntyngdon 0
4494597 2199002 2199002 defendant Tanere John   590039 590039 Tanere, John, of Huntyngdon 0
4496688 2199632 2199632 defendant Prentys Richard   590039 590039 Prentys, Richard, of Huntyngdon 0
4502714 2201428 2201428 defendant Haukyn John   590039 590039 Haukyn, John, of Huntyngdon 2
4503913 2201784 2201784 plaintiff Prude Henry   590039 590039 Prude, Henry, of Huntyngdon, on his own account 0
4511455 2204027 2204027 defendant Eyre William   590039 590039 Eyre, William, of Huntyngdon 0
4515766 2205359 2205359 defendant Willesson Wattesson Richard   590039 590039 Willesson Wattesson, Richard, of Huntyngdon 2
4515776 2205360 2205360 defendant Willeson Watteson Richard   590039 590039 Willeson Watteson, Richard, of Huntyngdon 5
4534733 2211142 2211142 defendant Taverner John   590039 590039 Taverner, John, of Huntyngdon 0
4534735 2211143 2211143 defendant Taverner John   590039 590039 Taverner, John, of Huntyngdon 0
4540057 2212799 2212799 defendant Taverner John   590039 590039 Taverner, John, of Huntyngdon 0
4540058 2212799 2212799 defendant Burnham Thomas   590039 590039 Burnham, Thomas, of Huntyngdon 1
4572716 2223006 2223006 defendant Tavernere John   590039 590039 Tavernere, John, of Huntyngdon 0
4586659 2227239 2227239 defendant Capron Thomas   590039 590039 Capron, Thomas, of Huntyngdon 0
4586674 2227242 2227242 defendant Capron Thomas   590039 590039 Capron, Thomas, of Huntyngdon 0
4591199 2228604 2228604 defendant Taverner John   590039 590039 Taverner, John, of Huntyngdon 2
4597314 2230398 2230398 defendant Burgh Nicholas de   590039 590039 Burgh, Nicholas de, of Huntyngdon 0
4617983 2236632 2236632 defendant Wesebury John   590039 590039 Wesebury, John, of Huntyngdon, parson of St Andrew's church 0
4618782 2236874 2236874 defendant Breston John   590039 590039 Breston, John, of Huntyngdon 5
4623256 2238246 2238246 defendant Barbour Thomas   590039 590039 Barbour, Thomas, of Huntyngdon 4
4623257 2238246 2238246 defendant _laston Reginald tailor 590039 590039 _laston, Reginald, of Huntyngdon, tailor 5
4623258 2238246 2238246 defendant Cook William taverner 590039 590039 Cook, William, of Huntyngdon, taverner 6
4625479 2238934 2238934 plaintiff Pecke Robert   590039 590039 Pecke, Robert, of Huntyngdon 0
4631108 2240627 2240627 plaintiff Syth Roger   590039 590039 Syth, Roger, of Huntyngdon 0
4645754 2244823 2244823 defendant Smyth Roger   590039 590039 Smyth, Roger, of Huntyngdon 0
4649649 2245926 2245926 defendant Turnour John furbisher 590039 590039 Turnour, John, of Huntyngdon, furbisher 0
4654408 2247253 2247253 defendant Giddyng George gent 590039 590039 Giddyng, George, of Huntyngdon, gent 0
4654409 2247253 2247253 defendant Pekke Robert   590039 590039 Pekke, Robert, of Huntyngdon, yeoman, bailiffs of Huntingdon 1
4654411 2247254 2247254 defendant Giddyng George gent 590039 590039 Giddyng, George, of Huntyngdon, gent 0
4654412 2247254 2247254 defendant Pekke Robert   590039 590039 Pekke, Robert, of Huntyngdon, yeoman, bailiffs of the town 1
4654803 2247381 2247381 plaintiff Bourgeys Thomas   590039 590039 Bourgeys, Thomas, of Huntyngdon 0
4655776 2247689 2247689 defendant Foxton John glover 590039 590039 Foxton, John, of Huntyngdon, glover 0
4655777 2247689 2247689 defendant Pekke Robert yeoman 590039 590039 Pekke, Robert, of Huntyngdon, yeoman 1
4655778 2247689 2247689 defendant Devyll John merchant 590039 590039 Devyll, John, of Huntyngdon, merchant 2
4663183 2249951 2249951 defendant Gregory John spicer 590039 590039 Gregory, John, of Huntyngdon, spicer 0
4663184 2249951 2249951 defendant Bocher John husbandman 590039 590039 Bocher, John, of Huntyngdon, husbandman 1
4690723 2262645 2262645 defendant Darell William esq 590039 590039 Darell, William, of Huntyngdon, esq 3
4690732 2262646 2262646 defendant Darell William esq 590039 590039 Darell, William, of Huntyngdon, esq 3
4692236 2263087 2263087 defendant Barbour Thomas yeoman 590039 590039 Barbour, Thomas, of Huntyngdon, yeoman 0
4692245 2263089 2263089 defendant Gottes William husbandman 590039 590039 Gottes, William, of Huntyngdon, husbandman 2
4692694 2263224 2263224 defendant Fuller Robert fuller 590039 590039 Fuller, Robert, of Huntyngdon, fuller 2
4701637 2265905 2265905 plaintiff Downham Walter   590039 590039 Downham, Walter, of Huntyngdon 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);