names

143 rows where place_id = 599191

✎ 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
3635663 1905954 1905954 defendant Carneby William husbandman 599191 599191 Carneby, William, of Roughton, husbandman 2
3673820 1917842 1917842 defendant Aleward Thomas gent 599191 599191 Aleward, Thomas, of Roughton, gent 0
3678542 1919346 1919346 defendant Dene John husbandman 599191 599191 Dene, John, of Roughton, husbandman 2
3680434 1919963 1919963 defendant Leche Thomas yeoman 599191 599191 Leche, Thomas, of Roughton, yeoman 0
3682750 1920703 1920703 defendant Jakson William tailor 599191 599191 Jakson, William, of Roughton, tailor 3
3686570 1921950 1921950 defendant Broun George yeoman 599191 599191 Broun, George, of Roughton, yeoman 0
3686572 1921951 1921951 defendant Broun George yeoman 599191 599191 Broun, George, of Roughton, yeoman 0
3688030 1922418 1922418 defendant Mannyngham John yeoman 599191 599191 Mannyngham, John, of Roughton, yeoman 0
3690269 1923117 1923117 defendant Wake William husbandman 599191 599191 Wake, William, of Roughton, husbandman 1
3690479 1923188 1923188 defendant Hylle Humphrey husbandman 599191 599191 Hylle, Humphrey, of Roughton, husbandman 2
3712134 1930112 1930112 defendant Scottowe Thomas husbandman 599191 599191 Scottowe, Thomas, of Roughton, husbandman 0
3715209 1931050 1931050 defendant Aylward Thomas husbandman 599191 599191 Aylward, Thomas, of Roughton, husbandman 2
3715210 1931050 1931050 defendant Mundy Roger husbandman 599191 599191 Mundy, Roger, of Roughton, husbandman 3
3715211 1931050 1931050 defendant Mundy Richard carpenter 599191 599191 Mundy, Richard, of Roughton, carpenter 4
3717099 1931631 1931631 defendant Mundy Richard carpenter 599191 599191 Mundy, Richard, of Roughton, carpenter 2
3719735 1932438 1932438 defendant Mason John baker 599191 599191 Mason, John, of Roughton, baker 3
3745505 1940500 1940500 defendant Flemyng Henry husbandman 599191 599191 Flemyng, Henry, of Roughton, husbandman 1
3770532 1948467 1948467 defendant Leche Robert yeoman 599191 599191 Leche, Robert, of Roughton, yeoman 0
3776238 1950315 1950315 defendant Cotes Robert husbandman 599191 599191 Cotes, Robert, of Roughton, husbandman 0
3776239 1950315 1950315 defendant Gryffyn Thomas husbandman 599191 599191 Gryffyn, Thomas, of Roughton, husbandman 1
3776240 1950315 1950315 defendant Aylwarde Thomas husbandman 599191 599191 Aylwarde,Thomas, of Roughton, husbandman 2
3782840 1952383 1952383 defendant Leche Thomas yeoman 599191 599191 Leche, Thomas, of Roughton, yeoman 0
3785116 1953132 1953132 defendant Bokkyng John laborer 599191 599191 Bokkyng, John, of Roughton, laborer 0
3785117 1953132 1953132 defendant Hogon Richard laborer 599191 599191 Hogon, Richard, of Roughton, laborer 1
3806305 1959888 1959888 defendant Elwarde Thomas yeoman 599191 599191 Elwarde, Thomas, of Roughton, yeoman 2
3815713 1962832 1962832 defendant Leche George husbandman 599191 599191 Leche, George, of Roughton, husbandman 4
3817832 1963488 1963488 defendant Yate Joan widow 599191 599191 Yate, Joan, of Roughton, widow 0
3818723 1963760 1963760 defendant Flemyng Henry husbandman 599191 599191 Flemyng, Henry, of Roughton, husbandman 0
3820267 1964211 1964211 defendant Elward Thomas yeoman 599191 599191 Elward, Thomas, of Roughton, yeoman 1
3822751 1965016 1965016 defendant Elward Thomas yeoman 599191 599191 Elward, Thomas, of Roughton, yeoman 3
3828274 1966715 1966715 defendant Bacon John carpenter 599191 599191 Bacon, John, of Roughton, carpenter 0
3841799 1971018 1971018 defendant Appulby John husbandman 599191 599191 Appulby, John, of Roughton, husbandman 1
3843644 1971546 1971546 defendant Purryell Thomas draper 599191 599191 Purryell, Thomas, of Roughton, draper 0
3843898 1971631 1971631 defendant Purryell Thomas draper 599191 599191 Purryell, Thomas, of Roughton, draper 0
3845169 1972050 1972050 defendant Hogon Richard husbandman 599191 599191 Hogon, Richard, of Roughton, husbandman 0
3845170 1972050 1972050 defendant Stevynson Thomas   599191 599191 Stevynson, Thomas, of Roughton, net maker 1
3859767 1976766 1976766 defendant Hogon Richard husbandman 599191 599191 Hogon, Richard, of Roughton, husbandman 3
3860610 1977041 1977041 defendant Wodeward Edward husbandman 599191 599191 Wodeward, Edward, of Roughton, husbandman 0
3862764 1977738 1977738 defendant Browne Thomas husbandman 599191 599191 Browne, Thomas, of Roughton, husbandman 3
3862928 1977797 1977797 defendant Gryffyn Thomas husbandman 599191 599191 Gryffyn, Thomas, of Roughton, husbandman 0
3864971 1978489 1978489 defendant Bakon John carpenter 599191 599191 Bakon, John, of Roughton, carpenter 2
3874809 1981793 1981793 defendant Grenewey William, junior chaplain of Wykmere 599191 599191 Grenewey, William, junior, of Roughton, chaplain of Wykmere 0
3874811 1981794 1981794 defendant Hogon Richard husbandman 599191 599191 Hogon, Richard, of Roughton, husbandman 0
3874812 1981794 1981794 defendant Hogon Margaret spinster 599191 599191 Hogon, Margaret, of Roughton, spinster 1
3881832 1984177 1984177 defendant Rogerson John chaplain 599191 599191 Rogerson, John, of Roughton, chaplain 0
3891012 1987257 1987257 defendant Potter William husbandman 599191 599191 Potter, William, of Roughton, husbandman 0
3900731 1990473 1990473 defendant Bakon John carpenter 599191 599191 Bakon, John, of Roughton, carpenter 0
3908911 1993272 1993272 defendant Page Christopher husbandman 599191 599191 Page, Christopher, of Roughton, husbandman 3
3963191 2011727 2011727 defendant Webster William husbandman 599191 599191 Webster, William, of Roughton, husbandman 0
3963193 2011728 2011728 defendant Webster William husbandman 599191 599191 Webster, William, of Roughton, husbandman 0
3963194 2011728 2011728 defendant Webster John, junior husbandman 599191 599191 Webster, John, junior, of Roughton, husbandman 1
3963195 2011728 2011728 defendant Johnson Mathew shoemaker 599191 599191 Johnson, Mathew, of Roughton, shoemaker 2
3986089 2019796 2019796 plaintiff Webster William yeoman 599191 599191 Webster, William, of Roughton, yeoman 0
4024802 2033552 2033552 defendant Boyse William   599191 599191 Boyse, William, of Roughton, wheelwright 1
4083563 2054396 2054396 defendant Rugge Thomas gent 599191 599191 Rugge, Thomas, of Roughton, gent 0
4083564 2054396 2054396 defendant Smythe John gent 599191 599191 Smythe, John, of Roughton, gent 1
4093215 2057890 2057890 defendant Pall John husbandman 599191 599191 Pall, John, of Roughton, husbandman 0
4095923 2058874 2058874 defendant Warde John husbandman 599191 599191 Warde, John, of Roughton, husbandman 0
4104305 2061818 2061818 defendant Atwood John yeoman 599191 599191 Atwood, John, of Roughton, yeoman 2
4111782 2064463 2064463 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 1
4111996 2064541 2064541 defendant Bockynge Thomas husbandman 599191 599191 Bockynge, Thomas, of Roughton, husbandman 0
4157830 2080815 2080815 defendant Fermasley William husbandman 599191 599191 Fermasley, William, of Roughton, husbandman 2
4157835 2080816 2080816 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 3
4217238 2101525 2101525 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 0
4224006 2103881 2103881 defendant Bates Christopher yeoman 599191 599191 Bates, Christopher, of Roughton, yeoman 3
4225836 2104499 2104499 defendant Harryson Nicholas husbandman 599191 599191 (Harryson, Nicholas, of Roughton, husbandman 1
4226011 2104567 2104567 defendant Gorbolde Robert yeoman 599191 599191 Gorbolde, Robert, of Roughton, yeoman 0
4226015 2104568 2104568 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 2
4243325 2110758 2110758 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 0
4243326 2110758 2110758 defendant Huggon Thomas yeoman 599191 599191 Huggon, Thomas, of Roughton, yeoman 1
4243350 2110768 2110768 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 0
4243351 2110768 2110768 defendant Huggon Thomas yeoman 599191 599191 Huggon, Thomas, of Roughton, yeoman 1
4243504 2110819 2110819 defendant Webster Peter yeoman 599191 599191 Webster, Peter, of Roughton, yeoman 0
4243837 2110920 2110920 defendant Webster Peter husbandman 599191 599191 Webster, Peter, of Roughton, husbandman 0
4265131 2117977 2117977 defendant Hugdon Thomas husbandman 599191 599191 Hugdon, Thomas, of Roughton, husbandman 0
4276332 2121666 2121666 defendant Arger Barnard clerk 599191 599191 Arger, Barnard, of Roughton, clerk 0
4293298 2127664 2127664 defendant Martyndale William yeoman 599191 599191 Martyndale, William, of Roughton, yeoman 0
4299141 2129791 2129791 defendant Keale Robert husbandman 599191 599191 Keale, Robert, of Roughton, husbandman 0
4312815 2134611 2134611 defendant Warde William singleman 599191 599191 Warde, William, of Roughton, singleman 1
4323228 2138184 2138184 defendant Hugon Thomas husbandman 599191 599191 Hugon, Thomas, of Roughton, husbandman 0
4324117 2138472 2138472 defendant Godbold John gent 599191 599191 Godbold, John, of Roughton, gent 1
4326228 2139138 2139138 defendant Warde William singleman 599191 599191 Warde, William, of Roughton, yeoman, singleman 0
4333434 2141462 2141462 defendant Warde John yeoman 599191 599191 Warde, John, of Roughton, yeoman 0
4333435 2141462 2141462 defendant Syll Richard yeoman 599191 599191 Syll, Richard, of Roughton, yeoman 1
4333436 2141462 2141462 defendant Webster Thomas yeoman 599191 599191 Webster, Thomas, of Roughton, yeoman 2
4334562 2141832 2141832 defendant Hugon Thomas husbandman 599191 599191 Hugon, Thomas, of Roughton, husbandman 0
4341293 2144228 2144228 defendant Bowes John yeoman 599191 599191 Bowes, John, of Roughton, yeoman 0
4376997 2156845 2156845 defendant Smythe Thomas yeoman 599191 599191 Smythe, Thomas, of Roughton, yeoman 0
4387104 2160341 2160341 defendant Drury Barnaby husbandman 599191 599191 Drury, Barnaby, of Roughton, husbandman 3
4411635 2168488 2168488 defendant Godbold John yeoman 599191 599191 Godbold, John, of Roughton, yeoman 0
4438712 2181396 2181396 defendant Suty John   599191 599191 Suty, John, of Roughton 0
4442941 2182753 2182753 defendant atte Sirehenrys Beatrice   599191 599191 atte Sirehenrys, Beatrice, of Roughton 1
4488936 2197256 2197256 plaintiff Taillour Agnes   599191 599191 Taillour, Agnes, of Roughton, formerly wife of Roger 0
4595678 2229910 2229910 defendant Soutere William   599191 599191 Soutere, William, of Roughton 1
4696388 2264349 2264349 defendant Hendry William yeoman 599191 599191 Hendry, William, of Roughton, yeoman 0
4698763 2265095 2265095 defendant Bridale John clerk 599191 599191 Bridale, John, of Roughton, clerk 0
4700199 2265481 2265481 defendant Multon John smith 599191 599191 Multon, John, of Roughton, smith 0
4810452 2299416 2299416 defendant Reyner Thomas yeoman 599191 599191 Reyner, Thomas, of Roughton, yeoman 0
4814063 2300503 2300503 defendant Reyner Thomas yeoman 599191 599191 Reyner, Thomas, of Roughton, yeoman 0
4816212 2301155 2301155 defendant Patonson William yeoman 599191 599191 Patonson, William, of Roughton, yeoman 1

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);