names

153 rows where place_id = 586404

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588641 1864090 1864090 plaintiff Bloundell James esq 586404 586404 Bloundell, James, of Melles, esq 0
3607028 1869863 1869863 defendant Talbot Adam carpenter 586404 586404 Talbot, Adam, of Melles, carpenter 0
3613759 1871956 1871956 defendant Torre Robert clothier 586404 586404 Torre, Robert, of Melles, clothier 0
3614450 1872168 1872168 defendant Torre Robert, junior clothman 586404 586404 Torre, Robert, junior, of Melles, clothman 1
3624716 1875269 1875269 defendant Trippe John laborer 586404 586404 Trippe, John, of Melles, laborer 1
3624717 1875269 1875269 defendant Whetyngham Robert yeoman 586404 586404 Whetyngham, Robert, of Melles, yeoman 2
3624720 1875270 1875270 defendant Tryppe John   586404 586404 Tryppe, John, of Melles 1
3624721 1875270 1875270 defendant Whetyngham Robert yeoman 586404 586404 Whetyngham, Robert, of Melles, yeoman 2
3633341 1905243 1905243 defendant Yaxlee Anthony gent 586404 586404 Yaxlee, Anthony, of Melles, gent 0
3646878 1909421 1909421 defendant Lyster Robert husbandman 586404 586404 Lyster, Robert, of Melles, husbandman 0
3650553 1910540 1910540 defendant Wysdom William husbandman 586404 586404 Wysdom, William, of Melles, husbandman 2
3666699 1915532 1915532 defendant Almot Thomas gent 586404 586404 Almot, Thomas, of Melles, gent 1
3667162 1915663 1915663 defendant Ynglee John   586404 586404 Ynglee, John, of Melles, pedlar 2
3669474 1916392 1916392 defendant Burgh John yeoman 586404 586404 Burgh, John, of Melles, yeoman 1
3669475 1916392 1916392 defendant Fuller William laborer 586404 586404 Fuller, William, of Melles, laborer 2
3675930 1918508 1918508 defendant Payne John husbandman 586404 586404 Payne, John, of Melles, husbandman 4
3692641 1923886 1923886 defendant Wreton John husbandman 586404 586404 Wreton, John, of Melles, husbandman 2
3713241 1930447 1930447 defendant Kene Thomas yeoman 586404 586404 Kene, Thomas, of Melles, yeoman 0
3713243 1930448 1930448 defendant Kene Thomas yeoman 586404 586404 Kene, Thomas, of Melles, yeoman 0
3713245 1930449 1930449 defendant Kene Thomas yeoman 586404 586404 Kene, Thomas, of Melles, yeoman 0
3713247 1930450 1930450 defendant Kene Thomas yeoman 586404 586404 Kene, Thomas, of Melles, yeoman 0
3718298 1932008 1932008 defendant Reynberd John butcher 586404 586404 Reynberd, John, of Melles, butcher 1
3732493 1936393 1936393 defendant Blaunchard Augustine husbandman 586404 586404 Blaunchard, Augustine, of Melles, husbandman 0
3768994 1947950 1947950 plaintiff Pulham George, senior   586404 586404 Pulham, George, senior, of Melles 0
3844096 1971701 1971701 defendant Style William clothier 586404 586404 Style, William, of Melles, clothier 0
3856001 1975501 1975501 defendant Kene William husbandman 586404 586404 Kene, William, of Melles, husbandman 1
3863281 1977916 1977916 defendant Coppyng William husbandman 586404 586404 Coppyng, William, of Melles, husbandman 2
3867708 1979436 1979436 defendant Tryppe John yeoman 586404 586404 Tryppe, John, of Melles, yeoman 2
3878085 1982916 1982916 plaintiff Kene Thomas   586404 586404 Kene, Thomas, of Melles 0
3880630 1983785 1983785 defendant Strete Edith widow 586404 586404 Strete, Edith, of Melles, widow 1
3887444 1986065 1986065 defendant Borowe George husbandman 586404 586404 Borowe, George, of Melles, husbandman 0
3887546 1986086 1986086 defendant Borowe George husbandman 586404 586404 Borowe, George, of Melles, husbandman 0
3919170 1996738 1996738 defendant Wodcroft William husbandman 586404 586404 Wodcroft, William, of Melles, husbandman 0
3921799 1997638 1997638 plaintiff Pulham George   586404 586404 Pulham, George, of Melles, 0
3925319 1998779 1998779 defendant Coppyng William   586404 586404 Coppyng, William, of Melles, mill wright 1
3932026 2001012 2001012 defendant Bartlett John gent 586404 586404 Bartlett, John, of Melles, gent 2
3939272 2003439 2003439 defendant Pyke Richard gent 586404 586404 Pyke, Richard, of Melles, gent 0
3942694 2004562 2004562 defendant Roper John   586404 586404 Roper, John, of Melles, shoe maker 0
4049746 2042351 2042351 plaintiff Wace Thomas   586404 586404 Wace, Thomas, of Melles 0
4049748 2042352 2042352 plaintiff Wace Thomas   586404 586404 Wace, Thomas, of Melles 0
4061087 2046372 2046372 plaintiff Dover John yeoman 586404 586404 Dover, John, of Melles, yeoman 0
4067077 2048524 2048524 plaintiff Huntynge John widow 586404 586404 Huntynge, John, of Melles, widow 0
4067078 2048524 2048524 defendant Wasse Thomas yeoman 586404 586404 Wasse, Thomas, of Melles, yeoman 0
4068089 2048893 2048893 plaintiff Keble John husbandman 586404 586404 Keble, John, of Melles, husbandman 0
4075543 2051553 2051553 defendant Wasse Thomas yeoman 586404 586404 Wasse, Thomas, of Melles, yeoman 0
4075544 2051553 2051553 defendant Reade John joiner 586404 586404 Reade, John, of Melles, joiner 1
4089858 2056661 2056661 defendant Browne Stephen yeoman 586404 586404 Browne, Stephen, of Melles, yeoman 0
4119469 2067255 2067255 defendant Sprigg Thomas   586404 586404 Sprigg, Thomas, of Melles, lime burner 3
4276380 2121683 2121683 defendant Sendall Robert yeoman 586404 586404 Sendall, Robert, of Melles, or of Ameringhale, Norf, yeoman 0
4282777 2123881 2123881 defendant Mayer Michael husbandman 586404 586404 Mayer, Michael, of Melles, husbandman 2
4289371 2126258 2126258 defendant Risdowne John husbandman 586404 586404 Risdowne, John, of Melles, husbandman 0
4342298 2144584 2144584 defendant Alden Thomas tailor 586404 586404 Alden, Thomas, of Melles, tailor 3
4345434 2145673 2145673 defendant Buxton Stephen bowyer 586404 586404 Buxton, Stephen, of Melles, bowyer 0
4363526 2152029 2152029 defendant Clemente Edmund tailor 586404 586404 Clemente, Edmund, of Melles, tailor 0
4393192 2162330 2162330 defendant Tyler Thomas husbandman 586404 586404 Tyler, Thomas, of Melles, husbandman 2
4438935 2181468 2181468 defendant Smyth Henry   586404 586404 Smyth, Henry, of Melles 2
4496403 2199553 2199553 defendant Russell William   586404 586404 Russell, William, of Melles 0
4496404 2199553 2199553 defendant Russell John   586404 586404 Russell, John, of Melles 1
4498879 2200285 2200285 defendant Melles William   586404 586404 Melles, William, of Melles 0
4502965 2201497 2201497 defendant Lucas Stephen   586404 586404 Lucas, Stephen, of Melles 3
4508613 2203172 2203172 plaintiff Almot Richard   586404 586404 Almot, Richard, of Melles 0
4541808 2213326 2213326 defendant Coteler John   586404 586404 Coteler, John, of Melles 5
4545188 2214416 2214416 defendant Lucas Stephen   586404 586404 Lucas, Stephen, of Melles 1
4561821 2219632 2219632 defendant Lucas Stephen   586404 586404 Lucas, Stephen, of Melles 1
4585091 2226758 2226758 defendant Wyntout John   586404 586404 Wyntout, John, of Melles 0
4588046 2227661 2227661 defendant Whitlok John   586404 586404 Whitlok, John, of Melles 1
4602231 2231916 2231916 defendant Vyncent John   586404 586404 Vyncent, John, of Melles 1
4602232 2231916 2231916 defendant Norton William   586404 586404 Norton, William, of Melles 2
4612260 2234899 2234899 plaintiff Cornyssh William   586404 586404 Cornyssh, William, of Melles 0
4615827 2235944 2235944 defendant Cornysshe Stephen   586404 586404 Cornysshe, Stephen, of Melles 0
4625961 2239075 2239075 plaintiff Pilton William   586404 586404 Pilton, William, of Melles 0
4635723 2242017 2242017 plaintiff Almet John   586404 586404 Almet, John, of Melles 0
4635729 2242018 2242018 plaintiff Almot John   586404 586404 Almot, John, of Melles 0
4635730 2242018 2242018 defendant Lucas Stephen   586404 586404 Lucas, Stephen, of Melles 0
4636204 2242154 2242154 defendant Taillour Adam   586404 586404 Taillour, Adam, of Melles 2
4650977 2246304 2246304 defendant Lucas Stephen   586404 586404 Lucas, Stephen, of Melles 0
4651275 2246405 2246405 plaintiff Almot John   586404 586404 Almot, John, of Melles 0
4651276 2246405 2246405 defendant Lucas Stephen   586404 586404 Lucas, Stephen, of Melles 0
4652392 2246698 2246698 defendant Sammell John, senior   586404 586404 Sammell, John, senior, of Melles 0
4665924 2250819 2250819 defendant Sebere John smith 586404 586404 Sebere, John, of Melles, smith 0
4665928 2250820 2250820 defendant Severe John smith 586404 586404 Severe, John, of Melles, smith 0
4680488 2259511 2259511 defendant Croke John   586404 586404 Croke, John, of Melles, holy water clerk 2
4682281 2260082 2260082 defendant Preston John   586404 586404 Preston, John, of Melles, parson 0
4688468 2261961 2261961 defendant Beke John husbandman 586404 586404 Beke, John, of Melles, husbandman 1
4688471 2261961 2261961 defendant Blakker John husbandman 586404 586404 Blakker, John, of Melles, husbandman 4
4690332 2262532 2262532 defendant Samuell John gent 586404 586404 Samuell, John, of Melles, gent 0
4697053 2264558 2264558 defendant Pilton William   586404 586404 Pilton, William, of Melles 0
4705987 2267247 2267247 defendant Croke John   586404 586404 Croke, John, of Melles, holy water clerk 2
4713121 2269425 2269425 defendant Calwere Robert   586404 586404 Calwere, Robert, of Melles, parson 0
4722407 2272328 2272328 defendant Skouthare Geoffrey husbandman 586404 586404 Skouthare, Geoffrey, of Melles, husbandman 0
4743828 2278727 2278727 defendant Wrek Robert esq 586404 586404 Wrek, Robert, of Melles, esq 0
4764874 2284993 2284993 defendant Wyneld Robert husbandman 586404 586404 Wyneld, Robert, of Melles, husbandman 1
4767052 2285683 2285683 defendant Scowethare Geoffrey husbandman 586404 586404 Scowethare, Geoffrey, of Melles, husbandman 0
4788970 2292604 2292604 defendant Weynell or Weyvell Robert yeoman 586404 586404 Weynell or Weyvell, Robert, of Melles, yeoman 0
4791464 2293424 2293424 defendant Scouthare Geoffrey husbandman 586404 586404 Scouthare, Geoffrey, of Melles, husbandman 0
4802365 2296932 2296932 defendant Oky John yeoman 586404 586404 Oky, John, of Melles, yeoman 0
4808946 2298973 2298973 defendant Alberwe Gilbert chaplain 586404 586404 Alberwe, Gilbert, of Melles, chaplain 1
4812339 2299973 2299973 defendant Lyly John   586404 586404 Lyly, John, of Melles, parson 0
4820073 2302355 2302355 defendant Aldebergh Gilbert chaplain 586404 586404 Aldebergh, Gilbert, of Melles, chaplain 0
4843804 2309583 2309583 defendant Almot Robert gent 586404 586404 Almot, Robert, of Melles, 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);