names

196 rows where place_id = 594969

✎ 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
3618296 1873351 1873351 defendant Rygh John weaver 594969 594969 Rygh, John, of Dedham, weaver 0
3652824 1911208 1911208 plaintiff Webbe John clothmaker 594969 594969 Webbe, John, of Dedham, clothmaker 0
3652826 1911209 1911209 plaintiff Webbe John clothmaker 594969 594969 Webbe, John, of Dedham, clothmaker 0
3652838 1911212 1911212 plaintiff Webbe Thomas (legal representative) 594969 594969 Webbe, Thomas, of Dedham, clothier, executors of 0
3658942 1913059 1913059 defendant Potwell Robert   594969 594969 Potwell, Robert, of Dedham, cloth maker 1
3665607 1915193 1915193 defendant Veysy William carver 594969 594969 Veysy, William, of Dedham, carver 0
3672213 1917309 1917309 defendant Barbour John clothmaker 594969 594969 Barbour, John, of Dedham, clothmaker 1
3710606 1929640 1929640 defendant Kyng Thomas clothmaker 594969 594969 Kyng, Thomas, of Dedham, clothmaker 0
3734660 1937088 1937088 defendant Barbour John sherman 594969 594969 Barbour, John, of Dedham, sherman 1
3734661 1937088 1937088 defendant Barker William butcher 594969 594969 Barker, William, of Dedham, butcher 2
3753919 1943173 1943173 defendant Bocher Richard butcher 594969 594969 Bocher, Richard, of Dedham, butcher 2
3769389 1948083 1948083 defendant Pecher John clothmaker 594969 594969 Pecher, John, of Dedham, clothmaker 1
3831940 1967886 1967886 defendant Cradok John mariner 594969 594969 Cradok, John, of Dedham, mariner 0
3835266 1968969 1968969 defendant Newton John clothier 594969 594969 Newton, John, of Dedham, clothier 0
3842255 1971121 1971121 defendant Walle William sherman 594969 594969 Walle, William, of Dedham, sherman 3
3848307 1973043 1973043 defendant Everard Simon smith 594969 594969 Everard, Simon, of Dedham, smith 0
3862900 1977786 1977786 defendant Sprall Giles clothier 594969 594969 Sprall, Giles, of Dedham, clothier 0
3876337 1982331 1982331 plaintiff Gorden John clothmaker 594969 594969 Gorden, John, of Dedham, clothmaker 0
3882604 1984447 1984447 plaintiff Thorn William, junior   594969 594969 Thorn, William, junior, of Dedham 0
3901744 1990805 1990805 defendant Cayan Richard alias Robert clothier 594969 594969 Cayan, Richard alias Robert, of Dedham, clothier 1
3904359 1991706 1991706 defendant Cane Richard Essex, clothier 594969 594969 Cane Richard, of Dedham, Essex, clothier 0
3917748 1996291 1996291 defendant Warner William clothier 594969 594969 Warner, William, of Dedham, clothier 1
3923971 1998329 1998329 defendant Smythe Richard yeoman 594969 594969 Smythe, Richard, of Dedham, yeoman 0
3962253 2011379 2011379 defendant Browne Henry clothier 594969 594969 Browne, Henry, of Dedham, clothier 2
3968788 2013711 2013711 defendant Woodhowse John clothier 594969 594969 Woodhowse, John, of Dedham, clothier 1
3968790 2013712 2013712 defendant Orres Thomas (legal representative) 594969 594969 Orres, Thomas, of Dedham, clothier, executors of 0
3968792 2013712 2013712 defendant Bigges George clothier 594969 594969 Bigges, George, of Dedham, clothier 2
3975649 2016041 2016041 defendant Warner William clothier 594969 594969 Warner, William, of Dedham, clothier 0
3999464 2024573 2024573 defendant Somer John yeoman 594969 594969 Somer, John, of Dedham, yeoman 0
4006892 2027241 2027241 defendant Ravens Henry sherman 594969 594969 Ravens, Henry, of Dedham, sherman 0
4006894 2027242 2027242 defendant Thorne Oliver weaver 594969 594969 Thorne, Oliver, of Dedham, weaver 0
4014777 2029998 2029998 plaintiff Sherman Henry clothier 594969 594969 Sherman, Henry, of Dedham, clothier 0
4015860 2030359 2030359 plaintiff Upcher Michael   594969 594969 Upcher, Michael, of Dedham 1
4016121 2030463 2030463 plaintiff Starlyng Robert clothier 594969 594969 Starlyng, Robert, of Dedham, clothier 1
4031609 2035968 2035968 defendant Bode Thomas butcher 594969 594969 Bode, Thomas, of Dedham, butcher 2
4038172 2038293 2038293 defendant Lanham William weaver 594969 594969 Lanham, William, of Dedham, weaver 2
4038197 2038296 2038296 defendant Langham William weaver 594969 594969 Langham, William, of Dedham, weaver 2
4039191 2038643 2038643 plaintiff Lufkyn John, junior clothier and weaver 594969 594969 Lufkyn, John, junior, of Dedham, clothier and weaver 0
4039192 2038643 2038643 defendant Webbe Thomas clothier and sherman 594969 594969 Webbe, Thomas, of Dedham, clothier and sherman 0
4039205 2038648 2038648 plaintiff Luskyn John, junior clothier and weaver 594969 594969 Luskyn, John, junior, of Dedham, clothier and weaver 0
4039206 2038648 2038648 defendant Webbe John clothier and sherman 594969 594969 Webbe, John, of Dedham, clothier and sherman 0
4045084 2040694 2040694 defendant Gedney James blacksmith 594969 594969 Gedney, James, of Dedham, blacksmith 0
4045085 2040694 2040694 defendant Ravens Henry yeoman 594969 594969 Ravens, Henry, of Dedham, yeoman 1
4045086 2040694 2040694 defendant Bygge John husbandman 594969 594969 Bygge, John, of Dedham, husbandman 2
4045088 2040695 2040695 defendant Gedney James blacksmith 594969 594969 Gedney, James, of Dedham, blacksmith 0
4057553 2045080 2045080 plaintiff Butter William clothier 594969 594969 Butter, William, of Dedham, clothier 0
4075077 2051388 2051388 defendant Barker Thomas husbandman 594969 594969 Barker, Thomas, of Dedham, husbandman 0
4080048 2053169 2053169 defendant Podde Thomas barber 594969 594969 Podde, Thomas, of Dedham, barber 1
4080049 2053169 2053169 defendant Lufkyn Thomas weaver 594969 594969 Lufkyn, Thomas, of Dedham, weaver 2
4080050 2053169 2053169 defendant Johnson John miller 594969 594969 Johnson, John, of Dedham, miller 3
4087775 2055920 2055920 defendant Lufkyn John sherman 594969 594969 Lufkyn, John, of Dedham, sherman 0
4100288 2060438 2060438 defendant Coote William husbandman 594969 594969 Coote, William, of Dedham, husbandman 0
4110670 2064073 2064073 defendant Starlyng Robert yeoman 594969 594969 Starlyng, Robert, of Dedham, yeoman 0
4120637 2067658 2067658 defendant Fuller William laborer 594969 594969 Fuller, William, of Dedham, laborer 0
4127463 2070115 2070115 defendant Dunton William clothier 594969 594969 Dunton, William, of Dedham, clothier 0
4130732 2071301 2071301 defendant Lewes William   594969 594969 Lewes, William, of Dedham, gent, Bachelor of Law 1
4131075 2071433 2071433 defendant Lewys William gent 594969 594969 Lewys, William, of Dedham, gent 0
4131076 2071433 2071433 defendant Person Edmund clothier 594969 594969 Person, Edmund, of Dedham, clothier 1
4131115 2071447 2071447 defendant Lewys William gent 594969 594969 Lewys, William, of Dedham, gent 0
4131116 2071447 2071447 defendant Person Edmund clothier 594969 594969 Person, Edmund, of Dedham, clothier 1
4131120 2071448 2071448 defendant Kynge Richard bricklayer 594969 594969 Kynge, Richard, of Dedham, bricklayer 1
4166928 2083931 2083931 defendant Dunton William clothier 594969 594969 Dunton, William, of Dedham, clothier 0
4169131 2084704 2084704 defendant Tree Richard clothier 594969 594969 Tree, Richard, of Dedham, clothier 0
4178928 2088108 2088108 defendant Lewys William gent 594969 594969 Lewys, William, of Dedham, gent 0
4181381 2088967 2088967 defendant Wrenche William laborer 594969 594969 Wrenche, William, of Dedham, laborer 1
4214564 2100600 2100600 defendant Upcher Richard clothier 594969 594969 Upcher, Richard, of Dedham, clothier 1
4217403 2101582 2101582 defendant Lewes William gent 594969 594969 Lewes, William, of Dedham, gent 0
4221546 2103027 2103027 defendant Warner William, junior (legal representative) 594969 594969 Warner, William, junior, of Dedham, clothier, administratrix of 0
4221547 2103027 2103027 defendant Warner Margaret widow 594969 594969 Warner, Margaret, of Dedham, widow 1
4233304 2107162 2107162 defendant Colman Henry gent 594969 594969 Colman, Henry, of Dedham, gent 1
4239225 2109343 2109343 defendant Freman Robert clothier 594969 594969 Freman, Robert, of Dedham, clothier 2
4239226 2109343 2109343 defendant Clarke Thomas clothier 594969 594969 Clarke, Thomas, of Dedham, clothier 3
4241613 2110180 2110180 defendant Alderton John husbandman 594969 594969 Alderton, John, of Dedham, husbandman 3
4255552 2114841 2114841 defendant Crowe Thomas clothier 594969 594969 Crowe, Thomas, of Dedham, clothier 1
4259003 2115983 2115983 defendant Harrison Ralph clothier 594969 594969 Harrison, Ralph, of Dedham, clothier 0
4259004 2115983 2115983 defendant Warner William (legal representative) 594969 594969 Warner, William, of Dedham, clothier, administratrix of 1
4259005 2115983 2115983 defendant Warner Margaret widow 594969 594969 Warner, Margaret, of Dedham, widow 2
4261065 2116667 2116667 defendant Brasier Peter bricklayer 594969 594969 Brasier, Peter, of Dedham, bricklayer 0
4261377 2116770 2116770 defendant Clarke Thomas clothier 594969 594969 Clarke, Thomas, of Dedham, clothier 2
4261381 2116771 2116771 defendant Freman Robert clothier 594969 594969 Freman, Robert, of Dedham, clothier 2
4261382 2116771 2116771 defendant Clarke Thomas clothier 594969 594969 Clarke, Thomas, of Dedham, clothier 3
4267935 2118907 2118907 defendant Crowe Thomas clothier 594969 594969 Crowe, Thomas, of Dedham, clothier 1
4276427 2121698 2121698 defendant Sharpe Thomas clothier 594969 594969 Sharpe, Thomas, of Dedham, clothier 3
4277032 2121899 2121899 defendant Strachie James yeoman 594969 594969 Strachie, James, of Dedham, yeoman 0
4279725 2122827 2122827 defendant Felix Thomas yeoman 594969 594969 Felix, Thomas, of Dedham, yeoman 0
4282194 2123673 2123673 defendant Ambler Lawrence yeoman 594969 594969 Ambler, Lawrence, of Dedham, yeoman 1
4282454 2123766 2123766 defendant Lewes William gent 594969 594969 Lewes, William, of Dedham, gent 0
4307533 2132772 2132772 defendant Butter Thomas clothier 594969 594969 Butter, Thomas, of Dedham, clothier 1
4331594 2140865 2140865 defendant Morphell John clothier 594969 594969 Morphell, John, of Dedham, clothier 0
4331595 2140865 2140865 defendant Luffkyn Nathaniel clothier 594969 594969 Luffkyn, Nathaniel, of Dedham, clothier 1
4331597 2140866 2140866 defendant Watson George clothier 594969 594969 Watson, George, of Dedham, clothier 0
4331598 2140866 2140866 defendant Staunton John clothier 594969 594969 Staunton, John, of Dedham, clothier 1
4360547 2150940 2150940 defendant Wylson Thomas Master of Arts 594969 594969 Wylson, Thomas, of Dedham, gent, or of Trinity Hall, Cambridge Univesity, Master of Arts 2
4364110 2152220 2152220 defendant Sharpe Thomas clothier 594969 594969 Sharpe, Thomas, of Dedham, clothier 0
4364111 2152220 2152220 defendant Clarke Richard yeoman 594969 594969 Clarke, Richard, of Dedham, yeoman 1
4373641 2155643 2155643 defendant Watson George clothier 594969 594969 Watson, George, of Dedham, or of Ardleigh, clothier 0
4378507 2157384 2157384 defendant Sydaye Edward gent 594969 594969 Sydaye, Edward, of Dedham, gent 0
4382212 2158746 2158746 defendant Cole Thomas clothier 594969 594969 Cole, Thomas, of Dedham, clothier 0
4389044 2160966 2160966 defendant Wayte Henry yeoman 594969 594969 Wayte, Henry, of Dedham, yeoman 1
4407871 2167197 2167197 defendant Rande Thomas clothier 594969 594969 Rande, Thomas, of Dedham, clothier 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);