names

311 rows where place_id = 586405

✎ 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
3588642 1864090 1864090 defendant Wode Mathew butcher 586405 586405 Wode, Mathew, of Nedham Market, butcher 0
3588643 1864090 1864090 defendant Wode Thomas butcher 586405 586405 Wode, Thomas, of Nedham Market, butcher 1
3590183 1864569 1864569 plaintiff Cole Joan widow 586405 586405 Cole, Joan, of Nedham Market, widow 0
3591968 1865102 1865102 plaintiff Flegge Robert (legal representative) 586405 586405 Flegge, Robert, of Nedham Market, clothmaker, executors of 0
3594196 1865826 1865826 defendant Jurdon Thomas husbandman 586405 586405 Jurdon, Thomas, of Nedham Market, husbandman 0
3596636 1866582 1866582 defendant Havell or Hanell William mercer 586405 586405 Havell or Hanell, William, of Nedham Market, mercer 0
3601926 1868258 1868258 defendant Hasyll John husbandman 586405 586405 Hasyll, John, of Nedham Market, husbandman 0
3602020 1868292 1868292 defendant Cole Margaret widow 586405 586405 Cole, Margaret, of Nedham Market, widow 0
3602021 1868292 1868292 defendant Cole Joan widow 586405 586405 Cole, Joan, of Nedham Market, widow 1
3602022 1868292 1868292 defendant Cole Robert husbandman 586405 586405 Cole, Robert, of Nedham Market, husbandman 2
3603553 1868782 1868782 plaintiff Dryver William husbandman 586405 586405 Dryver, William, of Nedham Market, husbandman 0
3603903 1868894 1868894 plaintiff Flegge Robert (legal representative) 586405 586405 Flegge, Robert, of Nedham Market, administrator of 0
3603907 1868895 1868895 plaintiff Flegge Robert (legal representative) 586405 586405 Flegge, Robert, of Nedham Market, administrator of 0
3603914 1868896 1868896 plaintiff Flegge Robert (legal representative) 586405 586405 Flegge, Robert, of Nedham Market, administrator of 0
3604694 1869131 1869131 plaintiff Hanell or Havell William mercer 586405 586405 Hanell or Havell, William, of Nedham Market, mercer 0
3608491 1870316 1870316 defendant Burton William carver 586405 586405 Burton, William, of Nedham Market, carver 0
3608492 1870316 1870316 defendant Hanell or Havell William mercer 586405 586405 Hanell or Havell, William, of Nedham Market, mercer 1
3613966 1872025 1872025 defendant Ravene Robert clotmaker 586405 586405 Ravene, Robert, of Nedham Market, clotmaker 0
3617673 1873152 1873152 plaintiff Fyllyng Gregory (legal representative) 586405 586405 Fyllyng, Gregory, of Nedham Market, executor of 0
3618002 1873250 1873250 defendant Burton William carver 586405 586405 Burton, William, of Nedham Market, carver 1
3619415 1873649 1873649 defendant Herne or Herve Henry tinker 586405 586405 Herne or Herve, Henry, of Nedham Market, tinker 1
3622653 1874616 1874616 plaintiff Raven Thomas   586405 586405 Raven, Thomas, of Nedham Market 0
3630111 1904266 1904266 defendant Honne Edmund yeoman 586405 586405 Honne, Edmund, of Nedham Market, yeoman 0
3635126 1905786 1905786 defendant Stood Richard mercer 586405 586405 Stood, Richard, of Nedham Market, mercer 0
3641513 1907801 1907801 defendant Sewall William laborer 586405 586405 Sewall, William, of Nedham Market, laborer 1
3645144 1908889 1908889 defendant Flegg John yeoman 586405 586405 Flegg, John, of Nedham Market, yeoman 0
3645315 1908944 1908944 defendant Woode Thomas butcher 586405 586405 Woode, Thomas, of Nedham Market, butcher 0
3658179 1912812 1912812 defendant Benson Leonard smith 586405 586405 Benson, Leonard, of Nedham Market, smith 6
3661706 1913939 1913939 defendant Flegge John gent 586405 586405 Flegge, John, of Nedham Market, gent 0
3662044 1914064 1914064 defendant Flegge John yeoman 586405 586405 Flegge, John, of Nedham Market, yeoman 0
3667775 1915862 1915862 defendant Flegge John yeoman 586405 586405 Flegge, John, of Nedham Market, yeoman 0
3673788 1917831 1917831 defendant Awode Thomas butcher 586405 586405 Awode, Thomas, of Nedham Market, butcher 0
3673789 1917831 1917831 defendant Bugge John husbandman 586405 586405 Bugge, John, of Nedham Market, husbandman 1
3686658 1921981 1921981 defendant Whytyng Richard tailor 586405 586405 Whytyng, Richard, of Nedham Market, tailor 1
3691365 1923459 1923459 defendant Woode Thomas, senior butcher 586405 586405 Woode, Thomas, senior, of Nedham Market, butcher 0
3694194 1924389 1924389 defendant Wood Thomas butcher 586405 586405 Wood, Thomas, of Nedham Market, butcher 0
3695031 1924657 1924657 defendant Bocher Thomas butcher 586405 586405 Bocher, Thomas, of Nedham Market, butcher 0
3695033 1924657 1924657 defendant Fuller John glover 586405 586405 Fuller, John, of Nedham Market, glover 2
3695034 1924657 1924657 defendant Sherwoode Thomas   586405 586405 Sherwoode, Thomas, of Nedham Market, collar maker 3
3701753 1926794 1926794 defendant Woode Thomas, senior butcher 586405 586405 Woode, Thomas, senior, of Nedham Market, butcher 0
3704469 1927693 1927693 defendant Gardener William yeoman 586405 586405 Gardener, William, of Nedham Market, yeoman 2
3704470 1927693 1927693 defendant Laundy John   586405 586405 Laundy, John, of Nedham Market, cook 3
3709016 1929115 1929115 defendant Sharwoode Thomas   586405 586405 Sharwoode, Thomas, of Nedham Market, collar maker 1
3709019 1929116 1929116 defendant Sharwoode Thomas   586405 586405 Sharwoode, Thomas, of Nedham Market, collar maker 1
3709542 1929292 1929292 plaintiff Ravyn Thomas   586405 586405 Ravyn, Thomas, of Nedham Market 0
3709544 1929292 1929292 defendant Crosse John fuller 586405 586405 Crosse, John, of Nedham Market, fuller 1
3722222 1933209 1933209 defendant Studde Richard cooper 586405 586405 Studde, Richard, of Nedham Market, cooper 1
3722223 1933209 1933209 defendant Rowght Richard tailor 586405 586405 Rowght, Richard, of Nedham Market, tailor 2
3737994 1938098 1938098 defendant Studde William laborer 586405 586405 Studde, William, of Nedham Market, laborer 0
3737995 1938098 1938098 defendant Studde Richard cooper 586405 586405 Studde, Richard, of Nedham Market, cooper 1
3769221 1948026 1948026 plaintiff Ravyn Thomas, senior   586405 586405 Ravyn, Thomas, senior, of Nedham Market 0
3769223 1948027 1948027 plaintiff Ravyn Thomasm senior   586405 586405 Ravyn, Thomasm senior, of Nedham Market 0
3769224 1948027 1948027 defendant Jacobbe Thomas mercer 586405 586405 Jacobbe, Thomas, of Nedham Market, mercer 0
3771458 1948765 1948765 defendant Jacobe Thomas mercer 586405 586405 Jacobe, Thomas, of Nedham Market, mercer 0
3774108 1949616 1949616 defendant Woode Thomas, senior butcher 586405 586405 Woode, Thomas, senior, of Nedham Market, butcher 0
3780715 1951700 1951700 defendant Cooley Roger weaver 586405 586405 Cooley, Roger, of Nedham Market, weaver 1
3787038 1953741 1953741 plaintiff Ravyn Thomas, senior   586405 586405 Ravyn, Thomas, senior, of Nedham Market 0
3792349 1955468 1955468 defendant Payn Walter clothmaker 586405 586405 Payn, Walter, of Nedham Market, clothmaker 2
3792355 1955469 1955469 defendant Payn Walter clothmaker 586405 586405 Payn, Walter, of Nedham Market, clothmaker 2
3795391 1956429 1956429 defendant Bocher Thomas butcher 586405 586405 Bocher, Thomas, of Nedham Market, butcher 2
3811267 1961420 1961420 defendant Brynwyn John clothmaker 586405 586405 Brynwyn, John, of Nedham Market, clothmaker 1
3812586 1961824 1961824 defendant Gryffyth Thomas cobbler 586405 586405 Gryffyth, Thomas, of Nedham Market, cobbler 1
3820165 1964185 1964185 defendant Jacob Thomas mercer 586405 586405 Jacob, Thomas, of Nedham Market, mercer 1
3822183 1964836 1964836 defendant Chychele William yeoman 586405 586405 Chychele, William, of Nedham Market, yeoman 1
3822186 1964838 1964838 plaintiff Sparowe John yeoman 586405 586405 Sparowe, John, of Nedham Market, yeoman 0
4045323 2040783 2040783 defendant Asheley John joiner 586405 586405 Asheley, John, of Nedham Market, joiner 0
4386717 2160233 2160233 defendant Revell Roger yeoman 586405 586405 Revell, Roger, of Nedham Market, yeoman 1
4583570 2226282 2226282 plaintiff Freykyn Thomas   586405 586405 Freykyn, Thomas, of Nedham Market 0
4608156 2233663 2233663 plaintiff Nowell William   586405 586405 Nowell, William, of Nedham Market 1
4608157 2233663 2233663 defendant Cole Robert   586405 586405 Cole, Robert, of Nedham Market 0
4614176 2235444 2235444 plaintiff Dowe Richard   586405 586405 Dowe, Richard, of Nedham Market 0
4614178 2235445 2235445 plaintiff Dowe Richard   586405 586405 Dowe, Richard, of Nedham Market 0
4624205 2238552 2238552 defendant Carter William barber 586405 586405 Carter, William, of Nedham Market, barber 1
4625977 2239080 2239080 defendant Sparwe Robert   586405 586405 Sparwe, Robert, of Nedham Market 1
4637567 2242538 2242538 plaintiff Bret John   586405 586405 Bret, John, of Nedham Market 0
4641992 2243762 2243762 defendant Cook John   586405 586405 Cook, John, of Nedham Market 2
4656064 2247776 2247776 defendant Gauter John husbandman 586405 586405 together with Gauter, John, of Nedham Market, husbandman 1
4656065 2247776 2247776 defendant Cole John husbandman 586405 586405 Cole, John, of Nedham Market, husbandman 2
4656066 2247776 2247776 defendant Taston Thomas husbandman 586405 586405 Taston, Thomas, of Nedham Market, husbandman 3
4656067 2247776 2247776 defendant Cook John husbandman 586405 586405 Cook, John, of Nedham Market, husbandman 4
4656069 2247777 2247777 defendant Gauter John husbandman 586405 586405 Gauter, John, of Nedham Market, husbandman 0
4656070 2247777 2247777 defendant Cole John husbandman 586405 586405 Cole, John, of Nedham Market, husbandman 1
4656071 2247777 2247777 defendant Taston Thomas husbandman 586405 586405 Taston, Thomas, of Nedham Market, husbandman 2
4656072 2247777 2247777 defendant Cook John husbandman 586405 586405 Cook, John, of Nedham Market, husbandman 3
4673916 2257459 2257459 defendant Nowell William yeoman 586405 586405 Nowell, William, of Nedham Market, yeoman 0
4678527 2258890 2258890 defendant Horald John   586405 586405 Horald, John, of Nedham Market, lime burner 1
4687012 2261545 2261545 defendant Wynde Thomas baker 586405 586405 Wynde, Thomas, of Nedham Market, baker 2
4701557 2265880 2265880 defendant Mellere Thomas husbandman 586405 586405 Mellere, Thomas, of Nedham market, husbandman 1
4701558 2265880 2265880 defendant Rygge Roger dyer 586405 586405 Rygge, Roger, of Nedham Market, dyer 2
4727824 2273946 2273946 defendant Newell William yeoman 586405 586405 Newell, William, of Nedham Market, yeoman 0
4742248 2278221 2278221 defendant Elyngham John, junior yeoman 586405 586405 Elyngham, John, junior, of Nedham Market, yeoman 1
4742249 2278221 2278221 defendant Elyngham John, senior yeoman 586405 586405 Elyngham, John, senior, of Nedham Market, yeoman 2
4745136 2279083 2279083 defendant But John thatcher 586405 586405 But, John, of Nedham Market, thatcher 0
4751448 2280906 2280906 plaintiff Skott Robert   586405 586405 Skott, Robert, of Nedham Market 0
4753230 2281395 2281395 plaintiff Wade Thomas   586405 586405 Wade, Thomas, of Nedham Market 0
4789307 2292717 2292717 defendant Dowe Geoffrey fuller 586405 586405 Dowe, Geoffrey, of Nedham Market, fuller 0
4790365 2293068 2293068 defendant Wynde Thomas baker 586405 586405 Wynde, Thomas, of Nedham Market, baker 2
4792637 2293786 2293786 defendant Taston Thomas, junior wooder 586405 586405 Taston, Thomas, junior, of Nedham Market, wooder 0
4795538 2294755 2294755 defendant Freman John weaver 586405 586405 Freman, John, of Nedham Market, weaver 0
4795540 2294756 2294756 defendant Brynkeley Peter carpenter 586405 586405 Brynkeley, Peter, of Nedham Market, carpenter 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);