names

122 rows where place_id = 586122

✎ 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
3587983 1863895 1863895 defendant Meryherst John yeoman 586122 586122 Meryherst, John, of Dudley, Worcs, yeoman 0
3621269 1874192 1874192 defendant Fysshe Emma widow 586122 586122 Fysshe, Emma, of Dudley, Worcs, widow 2
3662551 1914203 1914203 defendant Smyth William   586122 586122 Smyth, William, of Dudley, Worcs 3
3704228 1927620 1927620 defendant Smyth William smith 586122 586122 Smyth, William, of Dudley, Worcs, smith 4
3754535 1943375 1943375 defendant Stevyns Edward husbandman 586122 586122 Stevyns, Edward, of Dudley, Worcs, husbandman 0
3806636 1959974 1959974 defendant Anneslowe Humphrey gent 586122 586122 Anneslowe, Humphrey, of Dudley, Worcs, gent 0
3806646 1959975 1959975 defendant Anneslowe Humphrey gent 586122 586122 Anneslowe, Humphrey, of Dudley, Worcs, gent 0
3824228 1965456 1965456 defendant Jones Richard yeoman 586122 586122 Jones, Richard, of Dudley, Worcs, yeoman 1
3840165 1970496 1970496 defendant Colborne James gent 586122 586122 Colborne, James, of Dudley, Worcs, gent 1
3840170 1970497 1970497 defendant Colborne James gent 586122 586122 Colborne, James, of Dudley, Worcs, gent 1
3850531 1973754 1973754 defendant Colborne James gent 586122 586122 Colborne, James, of Dudley, Worcs, gent 1
3850536 1973755 1973755 defendant Colborne James gent 586122 586122 Colborne, James, of Dudley, Worcs, gent 1
3874602 1981727 1981727 defendant Smart Robert tailor 586122 586122 Smart, Robert, of Dudley, Worcs, tailor 1
3878564 1983076 1983076 defendant Persehowse Adam yeoman 586122 586122 Persehowse, Adam, of Dudley, Worcs, yeoman 0
3884866 1985208 1985208 defendant Smarte Robert tailor 586122 586122 Smarte, Robert, of Dudley, Worcs, tailor 2
3892915 1987878 1987878 defendant Heley Richard yeoman 586122 586122 Heley, Richard, of Dudley, Worcs, yeoman 0
3915934 1995708 1995708 defendant Wylson William butcher 586122 586122 Wylson, William, of Dudley, Worcs, butcher 1
3915938 1995710 1995710 defendant Wylson William butcher 586122 586122 Wylson, William, of Dudley, Worcs, butcher 0
3937173 2002764 2002764 defendant Belman Stephen yeoman 586122 586122 Belman, Stephen, of Dudley, Worcs, yeoman 0
3947661 2006243 2006243 defendant Parke John nailer 586122 586122 Parke, John, of Dudley, Worcs, nailer 1
3975119 2015860 2015860 defendant Parkes Thomas ironmonger 586122 586122 Parkes, Thomas, of Dudley, Worcs, ironmonger 0
4011560 2028890 2028890 defendant Parke John nailer 586122 586122 Parke, John, of Dudley, Worcs, nailer 0
4041881 2039580 2039580 defendant Fyssher Thomas yeoman 586122 586122 Fyssher, Thomas, of Dudley, Worcs, yeoman 0
4041885 2039582 2039582 defendant Shawe George yeoman 586122 586122 Shawe, George, of Dudley, Worcs, yeoman 0
4041890 2039584 2039584 defendant Bradley John yeoman 586122 586122 Bradley, John, of Dudley, Worcs, yeoman 0
4041892 2039585 2039585 defendant Juk alias Duk Humphrey blacksmith 586122 586122 Juk alias Duk, Humphrey, of Dudley, Worcs, yeoman, blacksmith 0
4041894 2039586 2039586 defendant Robynson alias Mason John yeoman 586122 586122 Robynson alias Mason, John, of Dudley, Worcs, yeoman 0
4043028 2039980 2039980 defendant Fyssher Thomas nailer 586122 586122 Fyssher, Thomas, of Dudley, Worcs, nailer 0
4043059 2039984 2039984 defendant Fyssher Thomas nailer 586122 586122 Fyssher, Thomas, of Dudley, Worcs, nailer 0
4051015 2042803 2042803 defendant Patyngham Margaret widow 586122 586122 (Patyngham, Margaret, of Dudley, Worcs, widow 1
4051020 2042804 2042804 defendant Patyngham Margaret widow 586122 586122 (Patyngham, Margaret, of Dudley, Worcs, widow 1
4060281 2046075 2046075 defendant Harryes Richard husbandman 586122 586122 Harryes, Richard, of Dudley, Worcs, husbandman 3
4061878 2046644 2046644 defendant Hawkes William butcher 586122 586122 Hawkes, William, of Dudley, Worcs, butcher 1
4063797 2047337 2047337 defendant Persepowse alias A Parke John yeoman 586122 586122 Persepowse alias A Parke, John, of Dudley, Worcs, yeoman 2
4065936 2048107 2048107 defendant Knowles William tailor 586122 586122 Knowles, William, of Dudley, Worcs, tailor 0
4071596 2050136 2050136 defendant Favell Richard husbandman 586122 586122 Favell, Richard, of Dudley, Worcs, husbandman 2
4074618 2051224 2051224 defendant Harrison Thomas nailer 586122 586122 Harrison, Thomas, of Dudley, Worcs, nailer 3
4077596 2052275 2052275 defendant Bradley John nailer 586122 586122 Bradley, John, of Dudley, Worcs, nailer 0
4081393 2053653 2053653 plaintiff Shawe George nailer 586122 586122 Shawe, George, of Dudley, Worcs, nailer 1
4089408 2056498 2056498 defendant Pratt Humphrey tailor 586122 586122 Pratt, Humphrey, of Dudley, Worcs, tailor 2
4096014 2058904 2058904 defendant Parke alias Parsus John yeoman 586122 586122 Parke alias Parsus, John, of Dudley, Worcs, yeoman 0
4106926 2062770 2062770 defendant Atkys William yeoman 586122 586122 Atkys, William, of Dudley, Worcs, yeoman 0
4124626 2069105 2069105 defendant Robynson alias Mason Humphrey laborer 586122 586122 Robynson alias Mason, Humphrey, of Dudley, Worcs, laborer 0
4127011 2069951 2069951 defendant Pattingham William nailer 586122 586122 Pattingham, William, of Dudley, Worcs, yeoman, nailer 0
4148065 2077454 2077454 defendant Harrison Richard yeoman 586122 586122 Harrison, Richard, of Dudley, Worcs, yeoman 1
4148068 2077455 2077455 defendant Harryson Richard yeoman 586122 586122 Harryson, Richard, of Dudley, Worcs, yeoman 1
4149404 2077919 2077919 defendant Atkes William yeoman 586122 586122 Atkes, William, of Dudley, Worcs, yeoman 0
4151732 2078719 2078719 defendant Patingham William yeoman 586122 586122 Patingham, William, of Dudley, Worcs, yeoman 0
4154804 2079775 2079775 defendant Grove Robert nailer 586122 586122 Grove, Robert, of Dudley, Worcs, nailer 0
4165720 2083508 2083508 defendant Sutton alias Dudleu Thomas esq 586122 586122 Sutton alias Dudleu, Thomas, of Dudley, Worcs, esq 0
4175634 2086948 2086948 defendant Carie John gent 586122 586122 Carie, John, of Dudley, Worcs, gent 2
4185392 2090403 2090403 defendant Grove Robert nailer 586122 586122 Grove, Robert, of Dudley, Worcs, nailer 0
4219216 2102218 2102218 defendant Colburne Roger gent 586122 586122 Colburne, Roger, of Dudley, Worcs, gent 0
4219957 2102483 2102483 defendant Richard William baker 586122 586122 Richard, William, of Dudley, Worcs, baker 2
4220119 2102537 2102537 defendant Pattyngham Thomas yeoman 586122 586122 Pattyngham, Thomas, of Dudley, Worcs, yeoman 0
4228248 2105362 2105362 defendant Colborne Roger gent 586122 586122 Colborne, Roger, of Dudley, Worcs, gent 0
4257159 2115371 2115371 defendant Dudley Thomas gent 586122 586122 Dudley, Thomas, of Dudley, Worcs, gent 0
4263274 2117382 2117382 defendant Hamnett Richard yeoman 586122 586122 Hamnett, Richard, of Dudley, Worcs, yeoman 0
4273885 2120811 2120811 defendant Hamnett Richard yeoman 586122 586122 Hamnett, Richard, of Dudley, Worcs, yeoman 0
4284121 2124366 2124366 defendant Hamnett Richard yeoman 586122 586122 Hamnett, Richard, of Dudley, Worcs, yeoman 0
4300818 2130390 2130390 defendant Colborne Roger gent 586122 586122 Colborne, Roger, of Dudley, Worcs, gent, son of Richard Colborne, of Dudley, gent 0
4308077 2132970 2132970 defendant Colborne Roger gent 586122 586122 Colborne, Roger, of Dudley, Worcs, gent 0
4320864 2137390 2137390 defendant Colborne Roger gent 586122 586122 Colborne, Roger, of Dudley, Worcs, gent 0
4331184 2140728 2140728 defendant Heeley Richard bloomer 586122 586122 Heeley, Richard, of Dudley, Worcs, bloomer 0
4353387 2148411 2148411 defendant Lane Robert nailer 586122 586122 Lane, Robert, of Dudley, Worcs, nailer 0
4353389 2148412 2148412 defendant Jewkes Richard stringer 586122 586122 Jewkes, Richard, of Dudley, Worcs, stringer 0
4356541 2149519 2149519 defendant Hopkys John nailer 586122 586122 Hopkys, John, of Dudley, Worcs, nailer 0
4403902 2165878 2165878 defendant Smyth William clerk 586122 586122 Smyth, William, of Dudley, Worcs, clerk 0
4409874 2167905 2167905 defendant Tomlinson William   586122 586122 Tomlinson, William, of Dudley, Worcs, wood collier 0
4677632 2258620 2258620 defendant Turnour Richard butcher 586122 586122 Turnour, Richard, of Dudley, Worcs, butcher 1
4794600 2294451 2294451 defendant Cornewaille Henry   586122 586122 Cornewaille, Henry, of Dudley, Worcs, gemt 3
4822679 2303170 2303170 defendant Strynger Thomas smith 586122 586122 Strynger, Thomas, of Dudley, Worcs, smith 1
5027282 2364853 2364853 defendant Clerk John yeoman 586122 586122 Clerk, John, of Dudley, Worcs, yeoman 0
5027284 2364854 2364854 defendant Clerk John yeoman 586122 586122 Clerk, John, of Dudley, Worcs, yeoman 0
5039451 2368450 2368450 defendant Fraunceys Richard yeoman 586122 586122 Fraunceys, Richard, of Dudley, Worcs, yeoman 0
5116673 2391309 2391309 defendant Atkyn Richard yeoman 586122 586122 Atkyn, Richard, of Dudley, Worcs, yeoman 3
5136334 2397148 2397148 defendant Patyngham William   586122 586122 Patyngham, William, of Dudley, Worcs, chapamn 4
5156690 2403117 2403117 defendant Patyngham William chapman 586122 586122 Patyngham, William, of Dudley, Worcs, chapman 3
5172802 2407780 2407780 defendant Patyngham William chapman 586122 586122 Patyngham, William, of Dudley, Worcs, chapman 2
5192628 2413580 2413580 defendant Patyngham William chapman 586122 586122 Patyngham, William, of Dudley, Worcs, chapman 1
5261283 2433640 2433640 defendant Patyngham alias Elcok William yeoman 586122 586122 Patyngham alias Elcok, William, of Dudley, Worcs, yeoman 1
5275150 2437808 2437808 defendant Patyng Thomas chapman 586122 586122 Patyng, Thomas, of Dudley, Worcs, chapman 0
5275154 2437809 2437809 defendant Patynger Thomas chapman 586122 586122 Patynger, Thomas, of Dudley, Worcs, chapman 0
5292756 2442879 2442879 defendant Meryhurst William chapman 586122 586122 Meryhurst, William, of Dudley, Worcs, chapman 0
5292762 2442880 2442880 defendant Meryhurst William chapman 586122 586122 Meryhurst, William, of Dudley, Worcs, chapman 0
5293572 2443088 2443088 defendant Patengeham Thomas chapman 586122 586122 Patengeham, Thomas, of Dudley, Worcs, chapman 1
5293577 2443089 2443089 defendant Patengeham Thomas chapman 586122 586122 Patengeham, Thomas, of Dudley, Worcs, chapman 1
5308250 2447500 2447500 defendant Staresmore William gent 586122 586122 Staresmore, William, of Dudley, Worcs, gent 0
5308251 2447500 2447500 defendant Asshehurst John chapman 586122 586122 Asshehurst, John, of Dudley, Worcs, chapman 1
5308252 2447500 2447500 defendant Meriheyst William butcher 586122 586122 Meriheyst, William, of Dudley, Worcs, butcher 2
5315337 2449643 2449643 defendant Patyncham William yeoman 586122 586122 Patyncham, William, of Dudley, Worcs, yeoman 0
5315339 2449644 2449644 defendant Patyncham William yeoman 586122 586122 Patyncham, William, of Dudley, Worcs, yeoman 0
5322491 2451800 2451800 defendant Hill Robert smith 586122 586122 Hill, Robert, of Dudley, Worcs, smith 0
5322494 2451801 2451801 defendant Hill Robert smith 586122 586122 Hill, Robert, of Dudley, Worcs, smith 0
5328067 2453464 2453464 defendant Patyngham Thomas nailman 586122 586122 Patyngham, Thomas, of Dudley, Worcs, nailman 0
5342362 2457806 2457806 defendant Frensshe William fishmonger 586122 586122 Frensshe, William, of Dudley, Worcs, fishmonger 2
5353649 2461212 2461212 defendant Moklowe William yeoman or ironmonger 586122 586122 Moklowe, William, of Dudley, Worcs, yeoman or ironmonger 0
5353655 2461213 2461213 defendant Moklowe William yeoman or ironmonger 586122 586122 Moklowe, William, of Dudley, Worcs, yeoman or ironmonger 0
5359209 2462919 2462919 defendant Patyngham Thomas yeoman 586122 586122 Patyngham, Thomas, of Dudley, Worcs, yeoman 0
5359213 2462920 2462920 defendant Patyngham Thomas yeoman 586122 586122 Patyngham, Thomas, of Dudley, Worcs, 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);