names

297 rows where place_id = 590901

✎ 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
3602667 1868498 1868498 defendant Larke Thomas chapman 590901 590901 Larke, Thomas, of Thetford, Norf, chapman 1
3602677 1868500 1868500 defendant Larke Thomas chapman 590901 590901 Larke, Thomas, of Thetford, Norf, chapman 0
3603065 1868625 1868625 defendant Larke Peter mercer 590901 590901 Larke, Peter, of Thetford, Norf, mercer 0
3605716 1869450 1869450 defendant Arteys John yeoman 590901 590901 Arteys, John, of Thetford, Norf, yeoman 0
3606074 1869566 1869566 defendant Halwyke Richard innholder 590901 590901 Halwyke, Richard, of Thetford, Norf, innholder 0
3606076 1869567 1869567 defendant Halwyke Richard innholder 590901 590901 Halwyke, Richard, of Thetford, Norf, innholder 0
3607270 1869937 1869937 defendant Hegge Richard husbandman 590901 590901 Hegge, Richard, of Thetford, Norf, husbandman 2
3608686 1870377 1870377 defendant Skepper William yeoman 590901 590901 Skepper, William, of Thetford, Norf, yeoman 0
3608691 1870378 1870378 defendant Skepper William yeoman 590901 590901 Skepper, William, of Thetford, Norf, yeoman 0
3616249 1872723 1872723 defendant Witherley Richard yeoman 590901 590901 Witherley, Richard, of Thetford, Norf, yeoman 1
3617219 1873010 1873010 defendant Craske Thomas chapman 590901 590901 Craske, Thomas, of Thetford, Norf, chapman 1
3619868 1873789 1873789 defendant Craske Stephen chapman 590901 590901 Craske, Stephen, of Thetford, Norf, chapman 0
3619878 1873791 1873791 defendant Craske Stephen chapman 590901 590901 Craske, Stephen, of Thetford, Norf, chapman 2
3620845 1874082 1874082 defendant Crask Stephen mercer 590901 590901 Crask, Stephen, of Thetford, Norf, mercer 2
3621139 1874162 1874162 defendant Germyn Thomas yeoman 590901 590901 Germyn, Thomas, of Thetford, Norf, yeoman 22
3628986 1903942 1903942 defendant Monford John chapman 590901 590901 Monford, John, of Thetford, Norf, chapman 1
3632712 1905049 1905049 defendant Spenser John shoemaker 590901 590901 Spenser, John, of Thetford, Norf, shoemaker 0
3634195 1905496 1905496 defendant Gardener John husbandman 590901 590901 Gardener, John, of Thetford, Norf, husbandman 2
3636137 1906094 1906094 defendant Pere John   590901 590901 Pere, John, of Thetford, Norf, coverlet weaver 0
3638271 1906789 1906789 defendant George John warrener 590901 590901 George, John, of Thetford, Norf, warrener 2
3639148 1907062 1907062 defendant Corker William yeoman 590901 590901 Corker, William, of Thetford, Norf, yeoman 0
3639904 1907294 1907294 defendant Pere John   590901 590901 Pere, John, of Thetford, Norf, coverlet weaver 0
3643995 1908554 1908554 defendant Aleyn John gent 590901 590901 Aleyn, John, of Thetford, Norf, gent 0
3645957 1909128 1909128 defendant Freman Arthur draper 590901 590901 Freman, Arthur, of Thetford, Norf, draper 0
3656420 1912252 1912252 defendant Carter Andrew mercer 590901 590901 Carter, Andrew, of Thetford, Norf, mercer 4
3661370 1913831 1913831 defendant Luke Edmund husbandman 590901 590901 Luke, Edmund, of Thetford, Norf, husbandman 0
3661609 1913908 1913908 defendant Freman Arthur draper 590901 590901 Freman, Arthur, of Thetford, Norf, draper 0
3661611 1913909 1913909 defendant Fryston Robert yeoman 590901 590901 Fryston, Robert, of Thetford, Norf, yeoman 0
3664118 1914729 1914729 defendant Swarfton John mercer 590901 590901 Swarfton, John, of Thetford, Norf, mercer 0
3664960 1914985 1914985 defendant Dey Thomas mercer 590901 590901 Dey, Thomas, of Thetford, Norf, mercer 2
3677158 1918896 1918896 defendant Aleyn John yeoman 590901 590901 Aleyn, John, of Thetford, Norf, yeoman 0
3677164 1918899 1918899 defendant Freman Arthur tailor 590901 590901 Freman, Arthur, of Thetford, Norf, tailor 0
3677166 1918900 1918900 defendant Freston Robert tailor 590901 590901 Freston, Robert, of Thetford, norf, tailor 0
3678563 1919352 1919352 defendant Mere William gent 590901 590901 Mere, William, of Thetford, Norf, gent 1
3685139 1921501 1921501 plaintiff Atmere William   590901 590901 Atmere, William, of Thetford, Norf 0
3695543 1924832 1924832 defendant Barowe John innholder 590901 590901 Barowe, John, of Thetford, Norf, innholder 0
3697226 1925352 1925352 defendant Aleyn John   590901 590901 Aleyn, John, of Thetford, Norf 0
3709541 1929291 1929291 defendant Freman Arthur draper 590901 590901 Freman, Arthur, of Thetford, Norf, draper 3
3732229 1936318 1936318 defendant Alen Geoffrey yeoman 590901 590901 Alen, Geoffrey, of Thetford, Norf, yeoman 0
3733895 1936848 1936848 defendant Alyn Geoffrey gent 590901 590901 Alyn, Geoffrey, of Thetford, Norf, gent 3
3744463 1940172 1940172 plaintiff Ballys Katherine singlewoman 590901 590901 Ballys, Katherine, of Thetford, Norf, singlewoman 0
3747055 1940994 1940994 defendant Tolton Richard husbandman 590901 590901 Tolton, Richard, of Thetford, Norf, husbandman 1
3762499 1945913 1945913 defendant Reddych John capper 590901 590901 Reddych, John, of Thetford, Norf, capper 3
3766355 1947132 1947132 defendant Mosse Robert tailor 590901 590901 Mosse, Robert, of Thetford, Norf, tailor 2
3771762 1948871 1948871 defendant Russell Robert fishmonger 590901 590901 Russell, Robert, of Thetford, Norf, fishmonger 2
3771767 1948872 1948872 defendant Russhell Robert fishmonger 590901 590901 Russhell, Robert, of Thetford, Norf, fishmonger 2
3771770 1948873 1948873 defendant Russell Robert fishmonger 590901 590901 Russell, Robert, of Thetford, Norf, fishmonger 0
3771788 1948876 1948876 defendant Russell Robert fishmonger 590901 590901 Russell, Robert, of Thetford, Norf, fishmonger 2
3771791 1948877 1948877 defendant Russell Robert fishmonger 590901 590901 Russell, Robert, of Thetford, Norf, fishmonger 0
3771798 1948878 1948878 defendant Russell Robert fishmonger 590901 590901 Russell, Robert, of Thetford, Norf, fishmonger 2
3812607 1961830 1961830 defendant May John yeoman 590901 590901 May, John, of Thetford, Norf, yeoman 0
3830241 1967351 1967351 defendant Baxster Simon gent 590901 590901 Baxster, Simon, of Thetford, Norf, gent 3
3832780 1968181 1968181 defendant Maye John yeoman 590901 590901 Maye, John, of Thetford, Norf, yeoman 0
3833112 1968280 1968280 defendant Maye John yeoman 590901 590901 Maye, John, of Thetford, Norf, yeoman 0
3836328 1969270 1969270 defendant Clyffar John mercer 590901 590901 Clyffar, John, of Thetford, Norf, mercer 0
3838114 1969834 1969834 defendant May John yeoman 590901 590901 May, John, of Thetford, Norf, yeoman 0
3846425 1972435 1972435 defendant Salter Thomas tailor 590901 590901 Salter, Thomas, of Thetford, Norf, tailor 4
3847417 1972755 1972755 defendant Thurmode Robert chandler 590901 590901 Thurmode, Robert, of Thetford, Norf, chandler 0
3849266 1973364 1973364 defendant Byxley John butcher 590901 590901 Byxley, John, of Thetford, Norf, butcher 0
3867206 1979268 1979268 defendant Vale John grocer 590901 590901 Vale, John, of Thetford, Norf, grocer 0
3867208 1979269 1979269 defendant Vale John grocer 590901 590901 Vale, John, of Thetford, Norf, grocer 0
3867210 1979270 1979270 defendant Vale John grocer 590901 590901 Vale, John, of Thetford, Norf, grocer 0
3872176 1980925 1980925 defendant Mannyng Richard shoemaker 590901 590901 Mannyng, Richard, of Thetford, Norf, shoemaker 1
3873773 1981449 1981449 defendant Oryce Robert yeoman 590901 590901 Oryce, Robert, of Thetford, Norf, yeoman 1
3873777 1981450 1981450 defendant Oryce Robert yeoman or warrener 590901 590901 Oryce, Robert, of Thetford, Norf, yeoman or warrener 2
3877782 1982808 1982808 defendant Busshe Thomas yeoman 590901 590901 Busshe, Thomas, of Thetford, Norf, yeoman 1
3912025 1994346 1994346 defendant Aleyn Geoffrey gent 590901 590901 Aleyn, Geoffrey, of Thetford, Norf, gent 1
3925318 1998779 1998779 defendant Lord Robert husbandman 590901 590901 Lord, Robert, of Thetford, Norf, husbandman 0
3927527 1999549 1999549 defendant Grene Thomas   590901 590901 Grene, Thomas, of Thetford, Norf, inn keeper 4
3927721 1999609 1999609 defendant Olwyn John gent 590901 590901 Olwyn, John, of Thetford, Norf, gent 1
3931134 2000716 2000716 defendant Fulmerston Richard gent 590901 590901 Fulmerston, Richard, of thetford, Norf, gent 1
3939566 2003536 2003536 defendant Robartes Ralph chapman 590901 590901 Robartes, Ralph, of Thetford, Norf, chapman 0
3949070 2006741 2006741 defendant Harman John innkeeper 590901 590901 Harman, John, of Thetford, Norf, innkeeper 0
3951677 2007640 2007640 defendant Torr Henry dyer 590901 590901 Torr, Henry, of Thetford, Norf, dyer 0
3957380 2009646 2009646 defendant Harman John innholder 590901 590901 Harman, John, of Thetford, Norf, innholder 1
3960751 2010862 2010862 defendant Heyward Thomas gent 590901 590901 Heyward, Thomas, of Thetford, Norf, gent 0
3967707 2013341 2013341 defendant Russhmere Richard chapman 590901 590901 Russhmere, Richard, of Thetford, Norf, chapman 0
3970598 2014305 2014305 defendant Sharpe John yeoman 590901 590901 Sharpe, John, of Thetford, Norf, yeoman 1
3970607 2014306 2014306 defendant Grymston John gent 590901 590901 Grymston, John, of Thetford, Norf, gent 3
3974956 2015806 2015806 defendant Fenwyll Thomas chapman 590901 590901 Fenwyll, Thomas, of Thetford, Norf, chapman 0
3993938 2022582 2022582 defendant Brundisshe George singleman 590901 590901 Brundisshe, George, of Thetford, Norf, yeoman, or of Felsam, Norf, singleman 0
3995118 2023002 2023002 defendant Hyllarye Robert yeoman or gent 590901 590901 Hyllarye, Robert, of Thetford, Norf, yeoman or gent 0
4054791 2044102 2044102 defendant Eden Edward gent 590901 590901 Eden, Edward, of Thetford, Norf, gent 1
4054794 2044103 2044103 defendant Eden Edward gent 590901 590901 Eden, Edward, of Thetford, Norf, gent 1
4073870 2050945 2050945 defendant Sherwyn John yeoman 590901 590901 Sherwyn, John, of Thetford, Norf, yeoman 0
4170051 2085019 2085019 defendant Rayneberd Nicholas yeoman 590901 590901 Rayneberd, Nicholas, of Thetford, Norf, yeoman 0
4171845 2085612 2085612 defendant Eldred Walter   590901 590901 Eldred, Walter, of Thetford, Norf, locksmith 0
4196470 2094309 2094309 defendant Beckles Edward chapman 590901 590901 Beckles, Edward, of Thetford, Norf, chapman 0
4204457 2097105 2097105 defendant Shelton Thomas gent 590901 590901 Shelton, Thomas, of Thetford, Norf, surgeon, gent 0
4208076 2098384 2098384 defendant More John chapman 590901 590901 More, John, of Thetford, Norf, chapman 2
4209480 2098863 2098863 defendant Smythe John yeoman 590901 590901 Smythe, John, of Thetford, Norf, yeoman 1
4234083 2107447 2107447 defendant Eden Edward gent 590901 590901 Eden, Edward, of Thetford, Norf, gent 0
4252213 2113730 2113730 defendant Haward or Heyward William gent 590901 590901 Haward or Heyward, William, of Thetford, Norf, gent 0
4262849 2117244 2117244 defendant Warren Thomas brasier 590901 590901 Warren, Thomas, of Thetford, Norf, brasier 0
4262853 2117245 2117245 defendant Waren Thomas brasier 590901 590901 Waren, Thomas, of Thetford, Norf, brasier 0
4265505 2118100 2118100 defendant Humpston Robert clerk 590901 590901 Humpston, Robert, of Thetford, Norf, or of Ketleby, Leics, clerk 0
4271736 2120125 2120125 defendant Wisbiche John blacksmith 590901 590901 Wisbiche, John, of Thetford, Norf, blacksmith 1
4331402 2140799 2140799 defendant Hollingworth John yeoman 590901 590901 Hollingworth, John, of Thetford, Norf, yeoman 10
4334859 2141922 2141922 defendant Riche Edwin esq 590901 590901 Riche, Edwin, of Thetford, Norf, esq 0
4341960 2144468 2144468 defendant Saye John chapman 590901 590901 Saye, John, of Thetford, Norf, chapman 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);