names

814 rows where place_id = 589851

✎ 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
3598988 1867315 1867315 defendant Hulle John merchant 589851 589851 Hulle, John, of Dorchester, merchant 0
3614574 1872208 1872208 defendant Lyd Thomas innholder 589851 589851 Lyd, Thomas, of Dorchester, innholder 0
3614577 1872209 1872209 defendant Lyd Thomas innholder 589851 589851 Lyd, Thomas, of Dorchester, innholder 0
3614860 1872301 1872301 defendant Wulffe John merchant 589851 589851 Wulffe, John, of Dorchester, merchant 0
3621913 1874395 1874395 defendant Willyam Richard merchant 589851 589851 Willyam, Richard, of Dorchester, merchant 0
3623090 1874745 1874745 defendant Browne Alexander saddler 589851 589851 Browne, Alexander, of Dorchester, saddler 0
3623091 1874745 1874745 defendant Stone William innholder 589851 589851 Stone, William, of Dorchester, innholder 1
3625693 1875573 1875573 defendant Russell William merchant 589851 589851 Russell, William, of Dorchester, merchant 0
3641389 1907760 1907760 defendant Somersby William husbandman 589851 589851 Somersby, William, of Dorchester, husbandman 1
3642741 1908177 1908177 defendant Garlond John mercer 589851 589851 Garlond, John, of Dorchester, mercer 0
3645223 1908912 1908912 defendant Legens John tanner 589851 589851 Legens, John, of Dorchester, tanner 1
3646405 1909271 1909271 plaintiff Howell Roger   589851 589851 Howell, Roger, of Dorchester 0
3653658 1911408 1911408 plaintiff Wylliams John, junior merchant 589851 589851 Wylliams, John, junior, of Dorchester, merchant 0
3653660 1911409 1911409 plaintiff Wylliams John, junior merchant 589851 589851 Wylliams, John, junior, of Dorchester, merchant 0
3653715 1911425 1911425 plaintiff Wylyams John (legal representative) 589851 589851 Wylyams, John, of Dorchester, merchant, executor of 0
3660239 1913465 1913465 plaintiff Hayward Richard merchant 589851 589851 Hayward, Richard, of Dorchester, merchant 0
3663900 1914651 1914651 defendant Stone William   589851 589851 Stone, William, of Dorchester, "chacman" 0
3675846 1918481 1918481 defendant Perche John innholder 589851 589851 Perche, John, of Dorchester, innholder 0
3675922 1918507 1918507 defendant Plommer John plumber 589851 589851 Plommer, John, of Dorchester, plumber 0
3704656 1927743 1927743 defendant Garlond John yeoman 589851 589851 Garlond, John, of Dorchester, yeoman 0
3711213 1929811 1929811 defendant Garland John innholder 589851 589851 Garland, John, of Dorchester, innholder 0
3711216 1929812 1929812 defendant Garland John innholder 589851 589851 Garland, John, of Dorchester, innholder 0
3724743 1934024 1934024 defendant Garland John yeoman or innholder 589851 589851 Garland, John, of Dorchester, yeoman or innholder 0
3751625 1942424 1942424 defendant Stratford John goldsmith 589851 589851 Stratford, John, of Dorchester, goldsmith 0
3767667 1947525 1947525 defendant Olyver John glover 589851 589851 Olyver, John, of Dorchester, glover 1
3767996 1947627 1947627 defendant Stratford John goldsmith 589851 589851 Stratford, John, of Dorchester, goldsmith 0
3768618 1947833 1947833 defendant Garland John merchant 589851 589851 Garland, John, of Dorchester, merchant 2
3777254 1950632 1950632 defendant Hutton Robert husbandman 589851 589851 Hutton, Robert, of Dorchester, husbandman 0
3788124 1954080 1954080 defendant Hutton Robert chapman 589851 589851 Hutton, Robert, of Dorchester, chapman 0
3795527 1956482 1956482 defendant Hutton Robert mercer 589851 589851 Hutton, Robert, of Dorchester, mercer 0
3811418 1961467 1961467 defendant Hytton Robert mercer 589851 589851 Hytton, Robert, of Dorchester, mercer 2
3865248 1978585 1978585 defendant Lancaster John shoemaker 589851 589851 Lancaster, John, of Dorchester, shoemaker 0
3873567 1981380 1981380 defendant James Robert merchant 589851 589851 James, Robert, of Dorchester, merchant 2
3878298 1982990 1982990 defendant Eston John hardwareman 589851 589851 Eston, John, of Dorchester, hardwareman 0
3879515 1983402 1983402 defendant Rugcaster John shoemaker 589851 589851 Rugcaster, John, of Dorchester, shoemaker 0
3884658 1985142 1985142 defendant Pyng William merchant 589851 589851 Pyng, William, of Dorchester, merchant 0
3884660 1985143 1985143 defendant Pyng William merchant 589851 589851 Pyng, William, of Dorchester, merchant 0
3888240 1986325 1986325 defendant Ilbery Richard husbandman 589851 589851 Ilbery, Richard, of Dorchester, husbandman 0
3892030 1987584 1987584 defendant Pyng William chapman 589851 589851 Pyng, William, of Dorchester, chapman 0
3892299 1987675 1987675 defendant Goldyng Nicholas mercer 589851 589851 Goldyng, Nicholas, of Dorchester, mercer 0
3899273 1989968 1989968 defendant Pyng William mercer 589851 589851 Pyng, William, of Dorchester, mercer 0
3901168 1990618 1990618 defendant Goldyng Nicholas mercer 589851 589851 Goldyng, Nicholas, of Dorchester, mercer 0
3902321 1991008 1991008 defendant Ilbury Richard innholder 589851 589851 Ilbury, Richard, of Dorchester, innholder 0
3902323 1991008 1991008 defendant Bare William shoemaker 589851 589851 Bare, William, of Dorchester, shoemaker 2
3902564 1991092 1991092 defendant Eston John mercer 589851 589851 Eston, John, of Dorchester, mercer 0
3902565 1991092 1991092 defendant Davy John innholder 589851 589851 Davy, John, of Dorchester, innholder 1
3902566 1991092 1991092 defendant Goldyng Nicholas mercer 589851 589851 Goldyng, Nicholas, of Dorchester, mercer 2
3905717 1992190 1992190 defendant Pynge William chapman 589851 589851 Pynge, William, of Dorchester, chapman 0
3908511 1993145 1993145 defendant Rowleyn Reginald merchant 589851 589851 Rowleyn, Reginald, of Dorchester, merchant 0
3908977 1993297 1993297 defendant Pyng William chapman 589851 589851 Pyng, William, of Dorchester, chapman 0
3914938 1995346 1995346 defendant Golden alias Goldyng Nicholas haberdasher 589851 589851 Golden alias Goldyng, Nicholas, of Dorchester, haberdasher 0
3914939 1995346 1995346 defendant Fleccher John yeoman 589851 589851 Fleccher, John, of Dorchester, yeoman 1
3914940 1995346 1995346 defendant Tardy William tailor 589851 589851 Tardy, William, of Dorchester, tailor 2
3926503 1999195 1999195 defendant Pyng William merchant 589851 589851 Pyng, William, of Dorchester, merchant 0
3938512 2003224 2003224 defendant Rallyngson John merchant 589851 589851 Rallyngson, John, of Dorchester, merchant 0
3941788 2004267 2004267 defendant Churchyll John draper 589851 589851 Churchyll, John, of Dorchester, draper 0
3941790 2004268 2004268 defendant Whythorne Thomas yeoman 589851 589851 Whythorne, Thomas, of dorchester, yeoman 0
3950676 2007310 2007310 plaintiff Gaye Thomas (legal representative) 589851 589851 Gaye, Thomas, of Dorchester, yeoman, executors of 0
3952178 2007836 2007836 plaintiff Haywarde John   589851 589851 Haywarde, John, of Dorchester 0
3960371 2010724 2010724 plaintiff Stratford Richard goldsmith 589851 589851 Stratford, Richard, of Dorchester, goldsmith 0
3960373 2010724 2010724 defendant Stone Leonard merchant 589851 589851 Stone, Leonard, of Dorchester, merchant 1
3960374 2010725 2010725 plaintiff Stratford Richard goldsmith 589851 589851 Stratford, Richard, of Dorchester, goldsmith 0
3960375 2010725 2010725 plaintiff Stratford Lawrence goldsmith 589851 589851 Stratford, Lawrence, of Dorchester, goldsmith 1
3960377 2010726 2010726 plaintiff Stratford Richard goldsmith 589851 589851 Stratford, Richard, of Dorchester, goldsmith 0
3960378 2010726 2010726 plaintiff Stratford Lawrence goldsmith 589851 589851 Stratford, Lawrence, of Dorchester, goldsmith 1
3960380 2010727 2010727 plaintiff Stratforde Richard goldsmith 589851 589851 Stratforde, Richard, of Dorchester, goldsmith 0
3963384 2011797 2011797 defendant Idyng William merchant 589851 589851 Idyng, William, of Dorchester, merchant 2
3965737 2012633 2012633 defendant Bannaster Thomas miller 589851 589851 Bannaster, Thomas, of Dorchester, miller 2
3968393 2013578 2013578 defendant Palmer John fuller 589851 589851 Palmer, John, of Dorchester, fuller 0
3970939 2014395 2014395 defendant Corbyn Ralph baker 589851 589851 Corbyn, Ralph, of Dorchester, baker 0
3970941 2014395 2014395 defendant Corbyn John (legal representative) 589851 589851 Corbyn, John, of Dorchester, baker, administrator of 2
3970944 2014396 2014396 defendant Corbyn Ralph baker 589851 589851 Corbyn, Ralph, of Dorchester, baker 0
3970946 2014396 2014396 defendant Corbyn John (legal representative) 589851 589851 Corbyn, John, of Dorchester, baker, administrator of 2
3970947 2014396 2014396 defendant Corbyn John baker 589851 589851 Corbyn, John, of Dorchester, baker 3
3971343 2014535 2014535 defendant Chubbe John merchant 589851 589851 Chubbe, John, of Dorchester, merchant 0
3974499 2015659 2015659 plaintiff Hennyng John mercer 589851 589851 Hennyng, John, of Dorchester, mercer 0
3974501 2015660 2015660 plaintiff Hennyng John mercer 589851 589851 Hennyng, John, of Dorchester, mercer 0
3977193 2016592 2016592 defendant Genge Robert pewterer 589851 589851 Genge, Robert, of Dorchester, pewterer 0
3986555 2019932 2019932 defendant Marten Nicholas mercer 589851 589851 Marten, Nicholas, of Dorchester, mercer 0
3987825 2020391 2020391 plaintiff Adyn alias Barbet Luke draper 589851 589851 Adyn alias Barbet, Luke, of Dorchester, draper 0
3987829 2020393 2020393 plaintiff Adyn William   589851 589851 Adyn, William, of Dorchester, woollen draper, senior bailiff of Dorchester 0
3987832 2020393 2020393 defendant Gaye Reginald weaver 589851 589851 Gaye, Reginald, of Dorchester, weaver 2
3990240 2021264 2021264 defendant Edward Thomas yeoman 589851 589851 Edward, Thomas, of Dorchester, yeoman 0
3991459 2021698 2021698 plaintiff Brent Stephen gent 589851 589851 Brent, Stephen, of Dorchester, gent 0
3993769 2022523 2022523 plaintiff Chirchell William   589851 589851 Chirchell, William, of Dorchester, woollen draper 0
3993771 2022524 2022524 plaintiff Chirchill William   589851 589851 Chirchill, William, of Dorchester, woollen draper 0
3996228 2023402 2023402 defendant Hooper Henry yeoman 589851 589851 Hooper, Henry, of Dorchester, yeoman 0
3996229 2023402 2023402 defendant Crymell John yeoman 589851 589851 Crymell, John, of Dorchester, yeoman 1
3998817 2024330 2024330 defendant Edwardes Thomas husbandman 589851 589851 Edwardes, Thomas, of Dorchester, yeoman, or Osmyngton, husbandman 0
3999396 2024545 2024545 defendant Strongman John   589851 589851 Strongman, John, of Dorchester, gent, mayor and aldermen of London ex parte 0
4002188 2025569 2025569 plaintiff Hayne Morgan merchant 589851 589851 Hayne, Morgan, of Dorchester, merchant 0
4002189 2025569 2025569 plaintiff Adyn Luke draper 589851 589851 Adyn, Luke, of Dorchester, draper 1
4002214 2025575 2025575 defendant Evame or Evaine Thomas   589851 589851 Evame or Evaine, Thomas, of Dorchester, hat maker 3
4004429 2026363 2026363 defendant Tailer alias Barber Michael barber 589851 589851 Tailer alias Barber, Michael, of Dorchester, barber 0
4010293 2028447 2028447 defendant Lancester John shoemaker 589851 589851 Lancester, John, of Dorchester, shoemaker 0
4010336 2028462 2028462 plaintiff Palmer John fuller 589851 589851 Palmer John, of Dorchester, fuller 0
4011058 2028729 2028729 defendant Edwardes Thomas yeoman 589851 589851 Edwardes, Thomas, of Dorchester, yeoman 1
4021960 2032582 2032582 defendant Chubbe Robert butcher 589851 589851 Chubbe, Robert, of Dorchester, butcher 0
4023740 2033192 2033192 plaintiff Baylye Roger tailor 589851 589851 Baylye, Roger, of Dorchester, tailor 0
4024139 2033337 2033337 defendant Cole James yeoman 589851 589851 Cole, James, of Dorchester, yeoman 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);