names

178 rows where place_id = 591382

✎ 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
3604253 1868993 1868993 defendant Barbour William barber 591382 591382 Barbour, William, of New Malton, barber 0
3611617 1871302 1871302 defendant Wryght Roger miller 591382 591382 Wryght, Roger, of New Malton, miller 0
3629039 1903960 1903960 defendant Hanse or Hause John butcher 591382 591382 Hanse or Hause, John, of New Malton, butcher 0
3640409 1907431 1907431 defendant Grymbald Robert tanner 591382 591382 Grymbald, Robert, of New Malton, tanner 1
3653551 1911378 1911378 defendant Henbury William mercer 591382 591382 Henbury, William, of New Malton, mercer 0
3672361 1917358 1917358 defendant Lynton John husbandman 591382 591382 Lynton, John, of New Malton, husbandman 0
3703575 1927394 1927394 defendant Langdale William yeoman 591382 591382 Langdale, William, of New Malton, yeoman 2
3703579 1927395 1927395 defendant Langdale William yeoman 591382 591382 Langdale, William, of New Malton, yeoman 2
3720305 1932630 1932630 defendant Jenkynson David (legal representative) 591382 591382 Jenkynson, David, of New Malton, barber, executors of 0
3720306 1932630 1932630 defendant Frere William yeoman 591382 591382 (Frere, William, of New Malton, yeoman 1
3724101 1933821 1933821 defendant Curdikie William merchant 591382 591382 Curdikie, William, of New Malton, merchant 0
3728667 1935204 1935204 defendant Curdaxe William pedder 591382 591382 Curdaxe, William, of New Malton, pedder 0
3728669 1935205 1935205 defendant Curdaye William pedder 591382 591382 Curdaye, William, of New Malton, pedder 0
3788796 1954299 1954299 defendant Best Robert cooper 591382 591382 Best, Robert, of New Malton, cooper 0
3828499 1966786 1966786 defendant Fowe Nicholas butcher 591382 591382 Fowe, Nicholas, of New Malton, butcher 1
3890235 1986978 1986978 defendant Strynger Thomas yeoman 591382 591382 Strynger, Thomas, of New Malton, yeoman 1
3890236 1986978 1986978 defendant Hansbye William yeoman 591382 591382 Hansbye, William, of New Malton, yeoman 2
3948245 2006445 2006445 defendant Bygott Edmund gent 591382 591382 Bygott, Edmund, of New Malton, gent 0
4044821 2040599 2040599 defendant Saule Henry yeoman 591382 591382 Saule, Henry, of New Malton, yeoman 0
4053839 2043750 2043750 defendant Raysyn Elizabeth widow 591382 591382 Raysyn, Elizabeth, of New Malton, widow 0
4053840 2043750 2043750 defendant Feeton Robert gent 591382 591382 Feeton, Robert, of New Malton, gent 1
4053841 2043750 2043750 defendant Andrewe Isabel spinster 591382 591382 Andrewe, Isabel, of New Malton, spinster 2
4057124 2044933 2044933 defendant Franke Charles draper 591382 591382 Franke, Charles, of New Malton, draper 0
4057127 2044934 2044934 defendant Franke Charles draper 591382 591382 Franke, Charles, of New Malton, draper 0
4068511 2049028 2049028 defendant Jackson John tapyter or tapestry maker 591382 591382 Jackson, John, of New Malton, tapyter or tapestry maker 0
4068512 2049028 2049028 defendant Barker William   591382 591382 Barker, William, of New Malton, tapestry maker 1
4068513 2049028 2049028 defendant Blackhouse John   591382 591382 Blackhouse, John, of New Malton, tapestry maker 2
4071863 2050235 2050235 defendant Raysyng Elizabeth widow 591382 591382 Raysyng, Elizabeth, of New Malton, widow 0
4081258 2053605 2053605 defendant Tomson Robert yeoman 591382 591382 Tomson, Robert, of New Malton, yeoman 1
4082099 2053892 2053892 defendant Rasynge William gent 591382 591382 Rasynge, William, of New Malton, gent 1
4087229 2055724 2055724 defendant Thompson Robert   591382 591382 Thompson, Robert, of New malton yeoman 0
4091335 2057191 2057191 defendant Sawle Henry yeoman 591382 591382 Sawle, Henry, of New Malton, yeoman 0
4091337 2057192 2057192 defendant Sawle Henry yeoman 591382 591382 Sawle, Henry, of New Malton, yeoman 0
4094175 2058250 2058250 defendant Ingledewe John tailor 591382 591382 Ingledewe, John, of New Malton, tailor 0
4094177 2058251 2058251 defendant Ingledewe John tailor 591382 591382 Ingledewe, John, of New Malton, tailor 0
4095041 2058554 2058554 defendant Hall John joiner 591382 591382 Hall, John, of New Malton, joiner 2
4105543 2062263 2062263 defendant Yoward William draper 591382 591382 Yoward, William, of New Malton, draper 1
4105785 2062358 2062358 defendant Yoward William draper 591382 591382 Yoward, William, of New Malton, draper 1
4151572 2078669 2078669 defendant Poole Thomas yeoman 591382 591382 Poole, Thomas, of New Malton, yeoman 0
4159446 2081370 2081370 defendant Gurwoode John tanner 591382 591382 Gurwoode, John, of New Malton, tanner 0
4163653 2082807 2082807 defendant Inglande Thomas joiner 591382 591382 Inglande, Thomas, of New Malton, joiner 0
4168083 2084325 2084325 defendant Bulmer John gent 591382 591382 Bulmer, John, of New Malton, gent 0
4173116 2086053 2086053 defendant Sawle Henry yeoman 591382 591382 Sawle, Henry, of New Malton, yeoman 0
4173117 2086053 2086053 defendant Bell Roger yeoman 591382 591382 Bell, Roger, of New Malton, yeoman 1
4175137 2086766 2086766 defendant Yowart William   591382 591382 Yowart, William, of New Malton, yeoman, woollen draper 1
4175138 2086766 2086766 defendant Meynesforthe John shoemaker 591382 591382 Meynesforthe, John, of New Malton, yeoman, shoemaker 2
4185752 2090518 2090518 defendant Dybney John chapman 591382 591382 Dybney, John, of New Malton, chapman 1
4206010 2097647 2097647 defendant Kighley Walter gent 591382 591382 Kighley, Walter, of New Malton, gent 0
4220772 2102762 2102762 defendant Fryer William merchant 591382 591382 Fryer, William, of New Malton, merchant 0
4220773 2102762 2102762 defendant Atlaye Ralph merchant 591382 591382 Atlaye, Ralph, of New Malton, merchant 1
4220774 2102762 2102762 defendant Atlaye Lancelot merchant 591382 591382 Atlaye, Lancelot, of New Malton, merchant 2
4253088 2114028 2114028 defendant Yoward William draper 591382 591382 Yoward, William, of New Malton, draper 0
4260518 2116485 2116485 defendant Duddinge George yeoman 591382 591382 Duddinge, George, of New Malton, yeoman 0
4260519 2116485 2116485 defendant Shippard Edmund yeoman 591382 591382 Shippard, Edmund, of New Malton, yeoman 1
4260598 2116512 2116512 defendant Duddinge George yeoman 591382 591382 Duddinge, George, of New Malton, yeoman 1
4260599 2116512 2116512 defendant Shippard Edmund yeoman 591382 591382 Shippard, Edmund, of New Malton, yeoman 2
4275772 2121476 2121476 defendant Sawle Henry yeoman 591382 591382 Sawle, Henry, of New Malton, yeoman 3
4286375 2125168 2125168 defendant Heslerton John gent 591382 591382 Heslerton, John, of New Malton, gent 0
4294650 2128173 2128173 defendant Freare William merchant 591382 591382 Freare, William, of New Malton, merchant 0
4299266 2129833 2129833 defendant Duddinge George yeoman 591382 591382 Duddinge, George, of New Malton, yeoman 0
4299267 2129833 2129833 defendant Shippard Edmund   591382 591382 Shippard, Edmund, of New Malton 1
4299349 2129859 2129859 defendant Stubbes Robert yeoman 591382 591382 Stubbes, Robert, of New Malton, yeoman 0
4299350 2129859 2129859 defendant Dyddinge George yeoman 591382 591382 Dyddinge, George, of New Malton, yeoman 1
4301353 2130592 2130592 defendant Best William yeoman 591382 591382 Best, William, of New Malton, or of Towthropp onn le Woulde, yeoman 0
4302443 2130974 2130974 defendant Sleightholme William yeoman 591382 591382 Sleightholme, William, of New Malton, yeoman 0
4303445 2131334 2131334 defendant Hesleton John gent 591382 591382 Hesleton, John, of New Malton, gent 0
4305969 2132226 2132226 defendant Nesse James yeoman 591382 591382 Nesse, James, of New Malton, yeoman 0
4307249 2132674 2132674 defendant Ustler Ralph yeoman 591382 591382 Ustler, Ralph, of New Malton, yeoman 0
4308660 2133179 2133179 defendant Chappell Francis yeoman 591382 591382 Chappell, Francis, of New Malton, yeoman 0
4308662 2133180 2133180 defendant Ustler Ralph yeoman 591382 591382 Ustler, Ralph, of New Malton, yeoman 0
4308897 2133262 2133262 defendant Nesse James yeoman 591382 591382 Nesse, James, of New Malton, yeoman 0
4316117 2135750 2135750 defendant Hall William laborer 591382 591382 Hall, William, of New Malton, laborer 0
4316118 2135750 2135750 defendant Throssell John yeoman 591382 591382 Throssell, John, of New Malton, yeoman 1
4316119 2135750 2135750 defendant Morwyn John saddler 591382 591382 Morwyn, John, of New Malton, saddler 2
4316203 2135779 2135779 defendant Gower Ralph laborer 591382 591382 Gower, Ralph, of New Malton, laborer 0
4316205 2135780 2135780 defendant Throssell John yeoman 591382 591382 Throssell, John, of New Malton, yeoman 0
4318378 2136535 2136535 defendant Hustler Ralph yeoman 591382 591382 Hustler, Ralph, of New Malton, yeoman 0
4319013 2136765 2136765 defendant Williamson John miller 591382 591382 Williamson, John, of New Malton, miller 0
4338897 2143360 2143360 defendant Storye William yeoman 591382 591382 Storye, William, of New Malton, yeoman 0
4338898 2143360 2143360 defendant Nixon John currier 591382 591382 Nixon, John, of New Malton, currier 1
4338899 2143360 2143360 defendant Ingland Thomas joiner 591382 591382 Ingland, Thomas, of New Malton, joiner 2
4338900 2143360 2143360 defendant Stott Roger cordwainer 591382 591382 Stott, Roger, of New Malton, cordwainer 3
4338902 2143361 2143361 defendant Jackson William innholder 591382 591382 Jackson, William, of New Malton, innholder 0
4338903 2143361 2143361 defendant Rasinge Thomas gent 591382 591382 Rasinge, Thomas, of New Malton, gent 1
4338904 2143361 2143361 defendant Pollye or Pillye Lawrence glasier 591382 591382 Pollye or Pillye, Lawrence, of New Malton, glasier 2
4345725 2145773 2145773 defendant Newlove Peter yeoman 591382 591382 Newlove, Peter, of New Malton, yeoman 0
4345727 2145773 2145773 defendant Ludsley Thomas glover 591382 591382 Ludsley, Thomas, of New Malton, glover 2
4345729 2145773 2145773 defendant Skynner Andrew butcher 591382 591382 Skynner, Andrew, of New Malton, butcher 4
4351384 2147734 2147734 defendant Turner Ralph yeoman 591382 591382 together with Turner, Ralph, of New Malton, yeoman 1
4373889 2155730 2155730 defendant Rasing Christopher vintner 591382 591382 Rasing, Christopher, of New Malton, vintner 0
4381646 2158545 2158545 defendant Hansby John   591382 591382 Hansby, John, of New Malton gent 0
4383505 2159192 2159192 defendant Saule Henry yeoman 591382 591382 Saule, Henry, of New Malton, yeoman 1
4383506 2159192 2159192 defendant Watson Thomas yeoman 591382 591382 Watson, Thomas, of New Malton, yeoman 2
4383507 2159192 2159192 defendant Bland John yeoman 591382 591382 Bland, John, of New Malton, yeoman 3
4385564 2159856 2159856 defendant Saule Henry innholder 591382 591382 Saule, Henry, of New Malton, innholder 2
4393241 2162344 2162344 defendant Dobbie William laborer 591382 591382 Dobbie, William, of New Malton, laborer 2
4399779 2164515 2164515 defendant Throssell John merchant 591382 591382 Throssell, John, of New Malton, merchant 0
4399908 2164557 2164557 defendant Ingland Thomas joiner 591382 591382 Ingland, Thomas, of New Malton, joiner 1
4401854 2165218 2165218 defendant Lampton Ralph gent 591382 591382 Lampton, Ralph, of New Malton, gent 0
4410957 2168255 2168255 defendant Best William yeoman 591382 591382 Best, William, of New Malton, yeoman 2

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