names

132 rows where place_id = 588542

✎ 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
3594877 1866028 1866028 defendant Joby James yeoman 588542 588542 Joby, James, of Carleton Rode, yeoman 0
3606288 1869634 1869634 defendant Randolf John husbandman 588542 588542 Randolf, John, of Carleton Rode, husbandman 3
3606394 1869666 1869666 defendant Randolf John husbandman 588542 588542 Randolf, John, of Carleton Rode, husbandman 3
3709352 1929223 1929223 plaintiff Proo Thomas   588542 588542 Proo, Thomas, of Carleton Rode 0
3709353 1929223 1929223 plaintiff Joly Robert   588542 588542 Joly, Robert, of Carleton Rode 1
3783617 1952635 1952635 defendant More Thomas husbandman 588542 588542 More, Thomas, of Carleton Rode, husbandman 0
3791845 1955295 1955295 defendant Halle John husbandman 588542 588542 Halle, John, of Carleton Rode, husbandman 0
3814875 1962568 1962568 defendant More Thomas thatcher 588542 588542 More, Thomas, of Carleton Rode, thatcher 4
3843501 1971503 1971503 defendant Sherwyn Nicholas   588542 588542 Sherwyn, Nicholas, of Carleton Rode, collar maker 4
3857009 1975825 1975825 defendant More Thomas thatcher 588542 588542 More, Thomas, of Carleton Rode, thatcher 1
3857010 1975825 1975825 defendant Jowell Christopher husbandman 588542 588542 Jowell, Christopher, of Carleton Rode, husbandman 2
3866777 1979124 1979124 defendant Bryggis Richard husbandman 588542 588542 Bryggis, Richard, of Carleton Rode, husbandman 4
3875191 1981940 1981940 defendant Briggis Richard laborer 588542 588542 Briggis, Richard, of Carleton Rode, laborer 0
3889597 1986751 1986751 defendant Page John husbandman 588542 588542 Page, John, of Carleton Rode, husbandman 1
3891495 1987421 1987421 defendant Reynold Richard husbandman 588542 588542 Reynold, Richard, of Carleton Rode, husbandman 1
3898282 1989635 1989635 defendant Sherwyn Robert husbandman 588542 588542 Sherwyn, Robert, of Carleton Rode, husbandman 1
3902750 1991150 1991150 defendant Page John husbandman 588542 588542 Page, John, of Carleton Rode, husbandman 1
3902751 1991150 1991150 defendant Nuby John husbandman 588542 588542 Nuby, John, of Carleton Rode, husbandman 2
3907213 1992703 1992703 defendant Juby William husbandman 588542 588542 Juby, William, of Carleton Rode, husbandman 0
3907214 1992703 1992703 defendant Feke William   588542 588542 Feke, William, of Carleton Rode, wheelwright 1
3910326 1993772 1993772 defendant Nuby John husbandman 588542 588542 Nuby, John, of Carleton Rode, husbandman 0
3910327 1993772 1993772 defendant Page John husbandman 588542 588542 Page, John, of Carleton Rode, husbandman 1
3914828 1995306 1995306 defendant Sherwyn Nicholas   588542 588542 Sherwyn, Nicholas, of Carleton Rode, collar maker 2
3918969 1996666 1996666 plaintiff Joby John yeoman 588542 588542 Joby, John, of Carleton Rode, yeoman 0
3957889 2009820 2009820 defendant Jowell Christopher butcher 588542 588542 Jowell, Christopher, of Carleton Rode, butcher 1
3983830 2018987 2018987 defendant Randolf William   588542 588542 Randolf, William, of Carleton Rode, hoop maker 2
3987649 2020332 2020332 defendant Yongman John butcher 588542 588542 Yongman, John, of Carleton Rode, butcher 0
3987650 2020332 2020332 defendant Bowell William husbandman 588542 588542 Bowell, William, of Carleton Rode, husbandman 1
3987651 2020332 2020332 defendant Randoll William cooper 588542 588542 Randoll, William, of Carleton Rode, cooper 2
3990162 2021239 2021239 defendant Partryke Nicholas yeoman 588542 588542 Partryke, Nicholas, of Carleton Rode, yeoman 0
3990163 2021239 2021239 defendant Smyth Stephen carpenter 588542 588542 Smyth, Stephen, of Carleton Rode, carpenter 1
4017669 2031028 2031028 defendant Cooke Robert turner 588542 588542 Cooke, Robert, of Carleton Rode, turner 0
4017670 2031028 2031028 defendant Newman John husbandman 588542 588542 Newman, John, of Carleton Rode, husbandman 1
4024018 2033294 2033294 defendant Yongman Robert husbandman 588542 588542 (Yongman, Robert, of Carleton Rode, husbandman 1
4024019 2033294 2033294 defendant Ryngold Stephen husbandman 588542 588542 Ryngold, Stephen, of Carleton Rode, husbandman 2
4024026 2033297 2033297 plaintiff Bennett Margaret   588542 588542 Bennett, Margaret, of Carleton Rode 0
4059599 2045824 2045824 defendant Cobbe Richard husbandman 588542 588542 Cobbe, Richard, of Carleton Rode, husbandman 1
4115145 2065705 2065705 defendant Juby Robert yeoman 588542 588542 Juby, Robert, of Carleton Rode, yeoman 0
4115146 2065705 2065705 defendant Page William yeoman 588542 588542 Page, William, of Carleton Rode, yeoman 1
4187897 2091266 2091266 defendant Pattericke Nicholas, senior yeoman 588542 588542 Pattericke, Nicholas, senior, of Carleton Rode, yeoman 0
4187898 2091266 2091266 defendant Pattaricke Nicholas, junior singleman 588542 588542 Pattaricke, Nicholas, junior, of Carleton Rode, yeoman, singleman 1
4245254 2111396 2111396 defendant Moore John weaver 588542 588542 Moore, John, of Carleton Rode, weaver 1
4256431 2115120 2115120 defendant Drake Richard tailor 588542 588542 Drake, Richard, of Carleton Rode, tailor 1
4261269 2116735 2116735 defendant Flatman Robert tailor 588542 588542 Flatman, Robert, of Carleton Rode, tailor 0
4269277 2119319 2119319 defendant Machyn Thomas husbandman 588542 588542 Machyn, Thomas, of Carleton Rode, husbandman 0
4274064 2120873 2120873 defendant Longe William   588542 588542 Longe, William, of Carleton Rode, wheelwright 0
4274065 2120873 2120873 defendant Machyn Robert   588542 588542 Machyn, Robert, of Carleton Rode, wheelwright 1
4288192 2125823 2125823 defendant Bullitought John yeoman 588542 588542 Bullitought, John, of Carleton Rode, yeoman 3
4328902 2139979 2139979 defendant Newenham John yeoman 588542 588542 Newenham, John, of Carleton Rode, yeoman 2
4329948 2140317 2140317 defendant Youngman John   588542 588542 Youngman, John, of Carleton Rode, linen weaver 1
4340118 2143806 2143806 defendant Flatman Robert tailor 588542 588542 Flatman, Robert, of Carleton Rode, tailor 3
4345992 2145857 2145857 defendant Partrick Nicholas husbandman 588542 588542 Partrick, Nicholas, of Carleton Rode, husbandman 2
4349684 2147155 2147155 defendant Hilton Thomas yeoman 588542 588542 Hilton, Thomas, of Carleton Rode, yeoman 3
4376630 2156709 2156709 defendant Longe William   588542 588542 Longe, William, of Carleton Rode, wheelwright 3
4391077 2161635 2161635 defendant Jewby Richard yeoman 588542 588542 Jewby, Richard, of Carleton Rode, yeoman 1
4401914 2165236 2165236 defendant Hilton Thomas yeoman 588542 588542 Hilton, Thomas, of Carleton Rode, yeoman 3
4407597 2167107 2167107 defendant Claxton Robert yeoman 588542 588542 Claxton, Robert, of Carleton Rode, husbandman, or of Forncett St Peter, yeoman 1
4408783 2167535 2167535 defendant Benet William clerk 588542 588542 Benet, William, of Carleton Rode, clerk 0
4408784 2167535 2167535 defendant Benet Thomas yeoman 588542 588542 Benet, Thomas, of Carleton Rode, yeoman 1
4408787 2167536 2167536 defendant Benett William clerk 588542 588542 Benett, William, of Carleton Rode, clerk 0
4755229 2282023 2282023 defendant Pro John husbandman 588542 588542 Pro, John, of Carleton Rode, husbandman 3
4759970 2283456 2283456 defendant Bunewell Richard yeoman 588542 588542 Bunewell, Richard, of Carleton Rode, yeoman 0
4759971 2283456 2283456 defendant Bunewell William yeoman 588542 588542 Bunewell, William, of Carleton Rode, yeoman 1
4872465 2318348 2318348 defendant Pyle Thomas husbandman 588542 588542 Pyle, Thomas, of Carleton Rode, husbandman 1
4913503 2330720 2330720 defendant Florence Thomas husbandman 588542 588542 Florence, Thomas, of Carleton Rode, husbandman 0
4913504 2330720 2330720 defendant William alias Bydewelle John husbandman 588542 588542 William alias Bydewelle, John, of Carleton Rode, husbandman 1
4913505 2330720 2330720 defendant Randolf Richard husbandman 588542 588542 Randolf, Richard, of Carleton Rode, husbandman 2
4928444 2335319 2335319 defendant Edward Walter husbandman 588542 588542 Edward, Walter, of Carleton Rode, husbandman 1
4942605 2339657 2339657 defendant Pyle Thomas ploughman 588542 588542 Pyle, Thomas, of Carleton Rode, ploughman 0
4964543 2346303 2346303 defendant Frawenceys William husbandman 588542 588542 Frawenceys, William, of Carleton Rode, husbandman 2
4985360 2352542 2352542 defendant Pyle Simon husbandman 588542 588542 Pyle, Simon, of Carleton Rode, husbandman 0
5008669 2359427 2359427 defendant Bonewell Robert yeoman 588542 588542 Bonewell, Robert, of Carleton Rode, yeoman 2
5017028 2361875 2361875 defendant Lytster Thomas husbandman 588542 588542 Lytster, Thomas, of Carleton Rode, husbandman 0
5022665 2363536 2363536 defendant Clement Richard yeoman 588542 588542 Clement, Richard, of Carleton Rode, yeoman 0
5040256 2368684 2368684 defendant Feeke Henry   588542 588542 Feeke, Henry, of Carleton Rode, husbandma 5
5050210 2371683 2371683 defendant Pyle Thomas husbandman 588542 588542 Pyle, Thomas, of Carleton Rode, husbandman 2
5055196 2373132 2373132 defendant Feke Henry yeoman 588542 588542 Feke, Henry, of Carleton Rode, yeoman 0
5060359 2374675 2374675 plaintiff Fraunceys William gent 588542 588542 Fraunceys, William, of Carleton Rode, gent 0
5069020 2377232 2377232 defendant Feke Henry husbandman 588542 588542 Feke, Henry, of Carleton Rode, husbandman 1
5073413 2378532 2378532 defendant Pyle Thomas husbandman 588542 588542 Pyle, Thomas, of Carleton Rode, husbandman 0
5074780 2378961 2378961 defendant Pyle Simon yeoman 588542 588542 Pyle, Simon, of Carleton Rode, yeoman 0
5077684 2379821 2379821 defendant Feke Henry husbandman 588542 588542 Feke, Henry, of Carleton Rode, husbandman 0
5077685 2379821 2379821 defendant Sparwe or Sparowe John husbandman 588542 588542 Sparwe or Sparowe, John, of Carleton Rode, husbandman 1
5077686 2379821 2379821 defendant Wykys Thomas husbandman 588542 588542 Wykys, Thomas, of Carleton Rode, husbandman 2
5081332 2380923 2380923 defendant Buk Richard yeoman 588542 588542 Buk, Richard, of Carleton Rode, yeoman 1
5084011 2381720 2381720 defendant Pyle Simon husbandman 588542 588542 Pyle, Simon, of Carleton Rode, husbandman 0
5084015 2381721 2381721 plaintiff Fraunceys William gent 588542 588542 Fraunceys, William, of Carleton Rode, gent 0
5092589 2384208 2384208 defendant Bonewell Richard yeoman 588542 588542 Bonewell, Richard, of Carleton Rode, yeoman 4
5098424 2385967 2385967 defendant Ryngolf Simon husbandman 588542 588542 Ryngolf, Simon, of Carleton Rode, husbandman 0
5103735 2387514 2387514 defendant Smyth Robert husbandman 588542 588542 Smyth, Robert, of Carleton Rode, husbandman 2
5124239 2393541 2393541 defendant Godfrey Walter husbandman 588542 588542 Godfrey, Walter, of Carleton Rode, husbandman 5
5131901 2395813 2395813 defendant Pyle Simon husbandman 588542 588542 Pyle, Simon, of Carleton Rode, husbandman 0
5150524 2401292 2401292 defendant Pyle Simon yeoman 588542 588542 Pyle, Simon, of Carleton Rode, yeoman 0
5184409 2411178 2411178 defendant Grene William yeoman 588542 588542 Grene, William, of Carleton Rode, yeoman 3
5185076 2411374 2411374 defendant Fike Henry husbandman 588542 588542 Fike, Henry, of Carleton Rode, husbandman 3
5204318 2417015 2417015 defendant Grene William yeoman 588542 588542 Grene, William, of Carleton Rode, yeoman 3
5218513 2421146 2421146 defendant Pyle Simon husbandman 588542 588542 Pyle, Simon, of Carleton Rode, husbandman 1
5252606 2430931 2430931 defendant Larke William yeoman 588542 588542 Larke, William, of Carleton Rode, yeoman 1
5262665 2434070 2434070 defendant Fyke Richard husbandman 588542 588542 Fyke, Richard, of Carleton Rode, husbandman 0
5262669 2434070 2434070 defendant Dunwell William husbandman 588542 588542 Dunwell, William, of Carleton Rode, husbandman 4

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