names

154 rows where place_id = 587000

✎ 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
3590195 1864574 1864574 defendant Dyne or Dyve Thomas husbandman 587000 587000 Dyne or Dyve, Thomas, of Marden, husbandman 0
3590198 1864575 1864575 defendant at Nasshe John, senior husbandman 587000 587000 at Nasshe, John, senior, of Marden, husbandman 0
3597258 1866763 1866763 defendant Bixbeche William husbandman 587000 587000 Bixbeche, William, of Marden, husbandman 0
3597982 1866993 1866993 defendant Yonge John husbandman 587000 587000 Yonge, John, of Marden, husbandman 0
3599243 1867406 1867406 defendant Asten Thomas husbandman 587000 587000 Asten, Thomas, of Marden, husbandman 0
3629967 1904226 1904226 defendant Spenser Ralph butcher 587000 587000 Spenser, Ralph, of Marden, butcher 0
3629973 1904227 1904227 defendant Spensser Ralph butcher 587000 587000 Spensser, Ralph, of Marden, butcher 0
3633305 1905232 1905232 defendant Marrant Thomas yeoman 587000 587000 Marrant, Thomas, of Marden, yeoman 0
3638303 1906797 1906797 defendant Marden William butcher 587000 587000 Marden, William, of Marden, butcher 0
3638861 1906976 1906976 defendant Bigg John yeoman 587000 587000 Bigg, John, of Marden, yeoman 0
3642672 1908153 1908153 defendant Marden Thomas butcher 587000 587000 Marden, Thomas, of Marden, butcher 0
3650583 1910550 1910550 defendant Marden William butcher 587000 587000 Marden, William, of Marden, butcher 2
3664568 1914872 1914872 defendant Hakket Roger yeoman 587000 587000 Hakket, Roger, of Marden, yeoman 1
3664569 1914872 1914872 defendant Paye William yeoman 587000 587000 Paye, William, of Marden, yeoman 2
3675270 1918305 1918305 defendant Langley William yeoman 587000 587000 Langley, William, of Marden, yeoman 0
3678603 1919366 1919366 defendant ap Rees David husbandman 587000 587000 ap Rees, David, of Marden, husbandman 0
3691229 1923417 1923417 defendant Harper John gent 587000 587000 Harper, John, of Marden, gent 0
3694116 1924364 1924364 defendant Hoskyns John husbandman 587000 587000 Hoskyns, John, of Marden, husbandman 0
3698441 1925731 1925731 defendant Shepard John husbandman 587000 587000 Shepard, John, of Marden, husbandman 2
3706196 1928225 1928225 defendant Colt George butcher 587000 587000 Colt, George, of Marden, butcher 0
3708093 1928831 1928831 defendant Hoyskyns John husbandman 587000 587000 Hoyskyns, John, of Marden, husbandman 3
3712822 1930330 1930330 plaintiff Wolford Richard gent 587000 587000 Wolford, Richard, of Marden, gent 0
3712823 1930330 1930330 defendant Hossey John husbandman 587000 587000 Hossey, John, of Marden, husbandman 0
3712824 1930330 1930330 defendant Shepard John husbandman 587000 587000 Shepard, John, of Marden, husbandman 1
3730925 1935900 1935900 defendant Middilton Thomas   587000 587000 Middilton, Thomas, of Marden, scythe smith 0
3731362 1936031 1936031 defendant Sheparde John husbandman 587000 587000 Sheparde, John, of Marden, husbandman 1
3736379 1937620 1937620 defendant ap Res David husbandman 587000 587000 ap Res, David, of Marden, husbandman 0
3736380 1937620 1937620 defendant Hossey Henry husbandman 587000 587000 Hossey, Henry, of Marden, husbandman 1
3736381 1937620 1937620 defendant Shepard John husbandman 587000 587000 Shepard, John, of Marden, husbandman 2
3742903 1939635 1939635 defendant Hossey John husbandman 587000 587000 Hossey, John, of Marden, husbandman 2
3749222 1941685 1941685 defendant Stokys Richard butcher 587000 587000 Stokys, Richard, of Marden, butcher 0
3749223 1941685 1941685 defendant Mayo William cordwainer 587000 587000 Mayo, William, of Marden, cordwainer 1
3749224 1941685 1941685 defendant Sewell Richard currier 587000 587000 Sewell, Richard, of Marden, currier 2
3749225 1941685 1941685 defendant Tebold John husbandman 587000 587000 Tebold, John, of Marden, husbandman 3
3749226 1941685 1941685 defendant Sperlyng Robert husbandman 587000 587000 Sperlyng, Robert, of Marden, husbandman 4
3758407 1944623 1944623 defendant Colyer Henry weaver 587000 587000 Colyer, Henry, of Marden, weaver 1
3758408 1944623 1944623 defendant Colyer William weaver 587000 587000 Colyer, William, of Marden, weaver 2
3766383 1947140 1947140 defendant Feraffe Stephen yeoman 587000 587000 Feraffe, Stephen, of Marden, yeoman 0
3785032 1953100 1953100 defendant Marden William butcher 587000 587000 Marden, William, of Marden, butcher 0
3788271 1954127 1954127 defendant ap Thomas alias Duston William husbandman 587000 587000 ap Thomas alias Duston, William, of Marden, husbandman 1
3788272 1954127 1954127 defendant Shepard John husbandman 587000 587000 Shepard, John, of Marden, husbandman 2
3791198 1955080 1955080 defendant Sheperd John pardoner 587000 587000 Sheperd, John, of Marden, pardoner 0
3795715 1956528 1956528 defendant Feraff Stephen yeoman 587000 587000 Feraff, Stephen, of Marden, yeoman 1
3802007 1958524 1958524 defendant Feraff Stephen   587000 587000 Feraff, Stephen, of Marden, yeoman, bailiff 0
3812902 1961930 1961930 defendant Fereff Stephen yeoman 587000 587000 Fereff, Stephen, of Marden, yeoman 0
3813558 1962158 1962158 defendant Aleyn Giles smith 587000 587000 Aleyn, Giles, of Marden, smith 2
3819507 1963980 1963980 defendant Feress Stephen   587000 587000 Feress, Stephen, of Marden, yeoman, bailiff 0
3838622 1970006 1970006 defendant Turke John   587000 587000 Turke, John, of Marden, mason 3
3856096 1975529 1975529 defendant Wotton Thomas clerk 587000 587000 Wotton, Thomas, of Marden, clerk 0
3873011 1981187 1981187 defendant Edwyn John husbandman 587000 587000 Edwyn, John, of Marden, husbandman 0
3883527 1984763 1984763 defendant Shepard John yeoman 587000 587000 Shepard, John, of Marden, yeoman 0
3897106 1989250 1989250 defendant Mayos Richard husbandman 587000 587000 Mayos, Richard, of Marden, husbandman 3
3897119 1989253 1989253 defendant Matty John husbandman 587000 587000 Matty, John, of Marden, husbandman 1
3897812 1989470 1989470 defendant Edmede John husbandman 587000 587000 Edmede, John, of Marden, husbandman 0
3953774 2008395 2008395 defendant Vaughan alias Morys Edward laborer 587000 587000 Vaughan alias Morys, Edward, of Marden, laborer 0
3954100 2008507 2008507 defendant Usborne James mercer 587000 587000 Usborne, James, of Marden, mercer 0
3966867 2013044 2013044 defendant Noradge Arthur yeoman 587000 587000 Noradge, Arthur, of Marden, yeoman 0
3989221 2020885 2020885 plaintiff Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 0
3989224 2020886 2020886 plaintiff Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 0
3993951 2022586 2022586 defendant Drowley alias Crowley John husbandman 587000 587000 Drowley alias Crowley, John, of Marden, husbandman 3
4022962 2032933 2032933 plaintiff Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 0
4026828 2034243 2034243 defendant Love Lawrence yeoman 587000 587000 Love, Lawrence, of Marden, yeoman 0
4026898 2034270 2034270 defendant Love Lawrence yeoman 587000 587000 Love, Lawrence, of Marden, yeoman 0
4032379 2036245 2036245 defendant Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 8
4032380 2036245 2036245 defendant Edwyns Walter yeoman 587000 587000 Edwyns, Walter, of Marden, yeoman 9
4032399 2036248 2036248 defendant Edwyns Walter yeoman 587000 587000 Edwyns, Walter, of Marden, yeoman 5
4049522 2042273 2042273 plaintiff Usborne James mercer 587000 587000 Usborne, James, of Marden, mercer 0
4054215 2043893 2043893 plaintiff Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 0
4054216 2043893 2043893 defendant Norton Robert yeoman 587000 587000 Norton, Robert, of Marden, yeoman 0
4073896 2050956 2050956 defendant Hyll John laborer 587000 587000 Hyll, John, of Marden, laborer 0
4083905 2054519 2054519 plaintiff Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 0
4083906 2054519 2054519 defendant Norton Robert yeoman 587000 587000 Norton, Robert, of Marden, yeoman 0
4083907 2054520 2054520 plaintiff Baker Philip yeoman 587000 587000 Baker, Philip, of Marden, yeoman 0
4090439 2056862 2056862 defendant Norton Robert yeoman 587000 587000 Norton, Robert, of Marden, yeoman 0
4090440 2056862 2056862 defendant Davys Lewis yeoman 587000 587000 Davys, Lewis, of Marden, yeoman 1
4101192 2060736 2060736 defendant Norton Robert yeoman 587000 587000 Norton, Robert, of Marden, yeoman 0
4108481 2063289 2063289 defendant Dutson Henry yeoman 587000 587000 Dutson, Henry, of Marden, yeoman 1
4113715 2065188 2065188 defendant Harrenden Richard husbandman 587000 587000 Harrenden, Richard, of Marden, husbandman 1
4145117 2076453 2076453 defendant Assheton or Asshdowne John yeoman 587000 587000 Assheton or Asshdowne, John, of Marden, yeoman 0
4145119 2076453 2076453 defendant Durkyn John husbandman 587000 587000 Durkyn, John, of Marden, husbandman 2
4145121 2076454 2076454 defendant Cockes Anthony yeoman 587000 587000 Cockes, Anthony, of Marden, yeoman 0
4146874 2077060 2077060 defendant Browne George smith 587000 587000 Browne, George, of Marden, smith 1
4172539 2085855 2085855 defendant Mayos William laborer 587000 587000 Mayos, William, of Marden, laborer 10
4183131 2089583 2089583 defendant Butte Thomas yeoman 587000 587000 Butte, Thomas, of Marden, yeoman 0
4183136 2089584 2089584 defendant Butte Thomas yeoman 587000 587000 Butte, Thomas, of Marden, yeoman 0
4204067 2096973 2096973 defendant Mercer Richard yeoman 587000 587000 Mercer, Richard, of Marden, yeoman 2
4214436 2100557 2100557 defendant Dower James yeoman 587000 587000 Dower, James, of Marden, yeoman 0
4214437 2100557 2100557 defendant Edwyn Walter yeoman 587000 587000 Edwyn, Walter, of Marden, yeoman 1
4214720 2100654 2100654 defendant Matye John yeoman 587000 587000 Matye, John, of Marden, yeoman 0
4217088 2101470 2101470 defendant Dower James yeoman 587000 587000 Dower, James, of Marden, yeoman 3
4223658 2103761 2103761 defendant Taylor Timothy clothier 587000 587000 Taylor, Timothy, of Marden, clothier 0
4223995 2103879 2103879 defendant Dower James yeoman 587000 587000 Dower, James, of Marden, yeoman 0
4223996 2103879 2103879 defendant Edwym Walter yeoman 587000 587000 Edwym Walter, of Marden, yeoman 1
4224690 2104108 2104108 defendant Crosseland William husbandman 587000 587000 Crosseland, William, of Marden, husbandman 0
4224692 2104109 2104109 defendant Stone George clothier 587000 587000 Stone, George, of Marden, clothier 0
4225319 2104322 2104322 defendant Lewer William merchant 587000 587000 Lewer, William, of Marden, merchant 1
4229130 2105670 2105670 defendant Crosseland William   587000 587000 Crosseland, William, of Marden, kersey maker 1
4230912 2106311 2106311 defendant Collyer William husbandman 587000 587000 Collyer, William, of Marden, husbandman 0
4231045 2106358 2106358 defendant Bailie Thomas clothier 587000 587000 Bailie, Thomas, of Marden, clothier 0
4240649 2109854 2109854 defendant Lyngen John gent 587000 587000 Lyngen, John, of Marden, 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);