names

236 rows where place_id = 591495

✎ 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
3604566 1869092 1869092 defendant Stalworthe William husbandman 591495 591495 Stalworthe, William, of Dodyngton, husbandman 2
3604567 1869092 1869092 defendant Fyssher Simon   591495 591495 Fyssher, Simon, of Dodyngton, shepherd 3
3604568 1869092 1869092 defendant Lynne Robert husbandman 591495 591495 Lynne, Robert, of Dodyngton, husbandman 4
3613953 1872020 1872020 defendant Wykes John (legal representative) 591495 591495 Wykes, John, of Dodyngton, executor of 0
3624441 1875179 1875179 defendant Whitlok William yeoman 591495 591495 Whitlok, William, of Dodyngton, yeoman 0
3626249 1903066 1903066 defendant Phylyp John draper 591495 591495 Phylyp, John, of Dodyngton, draper 2
3667985 1915926 1915926 defendant Bircombe John husbandman 591495 591495 Bircombe, John, of Dodyngton, husbandman 4
3671138 1916942 1916942 defendant Smyth Thomas laborer 591495 591495 Smyth, Thomas, of Dodyngton, laborer 0
3684661 1921335 1921335 defendant Bircombe John husbandman 591495 591495 Bircombe, John, of Dodyngton, husbandman 7
3705722 1928073 1928073 defendant Amery Henry butcher 591495 591495 Amery, Henry, of Dodyngton, butcher 0
3726810 1934653 1934653 defendant Amerey Henry butcher 591495 591495 Amerey, Henry, of Dodyngton, butcher 0
3734714 1937106 1937106 defendant Sutton Thomas husbandman 591495 591495 Sutton, Thomas, of Dodyngton, husbandman 0
3734715 1937106 1937106 defendant Cradok Thomas husbandman 591495 591495 Cradok, Thomas, of Dodyngton, husbandman 1
3734716 1937106 1937106 defendant Clement Ralph husbandman 591495 591495 Clement, Ralph, of Dodyngton, husbandman 2
3734717 1937106 1937106 defendant Bowdon Stephen husbandman 591495 591495 Bowdon, Stephen, of Dodyngton, husbandman 3
3734718 1937106 1937106 defendant Bowdon Ralph husbandman 591495 591495 Bowdon, Ralph, of Dodyngton, husbandman 4
3734719 1937106 1937106 defendant Newton Robert husbandman 591495 591495 Newton, Robert, of Dodyngton, husbandman 5
3742051 1939381 1939381 defendant Wykys Nicholas esq 591495 591495 Wykys, Nicholas, of Dodyngton, esq 0
3751594 1942413 1942413 defendant Chesshyre John husbandman 591495 591495 Chesshyre, John, of Dodyngton, Conndover, husbandman 0
3754361 1943321 1943321 defendant Wylkys Nicholas esq 591495 591495 Wylkys, Nicholas, of Dodyngton, esq 0
3756615 1944051 1944051 defendant Reve Nicholas carpenter 591495 591495 Reve, Nicholas, of Dodyngton, carpenter 2
3764773 1946647 1946647 defendant Cobbe Henry husbandman 591495 591495 Cobbe, Henry, of Dodyngton, husbandman 2
3776423 1950381 1950381 defendant A Born James yeoman 591495 591495 A Born, James, of Dodyngton, yeoman 1
3776674 1950451 1950451 plaintiff Byllyng William   591495 591495 Byllyng, William, of Dodyngton 0
3788326 1954147 1954147 defendant Cobbe Henry husbandman 591495 591495 Cobbe, Henry, of Dodyngton, husbandman 1
3819633 1964018 1964018 defendant Aubrey Henry butcher 591495 591495 Aubrey, Henry, of Dodyngton, butcher 2
3821377 1964581 1964581 defendant Torre Thomas husbandman 591495 591495 Torre, Thomas, of Dodyngton, husbandman 0
3825783 1965910 1965910 defendant Strete John smith 591495 591495 Strete, John, of Dodyngton, smith 0
3825784 1965910 1965910 defendant Mawndy John laborer 591495 591495 Mawndy, John, of Dodyngton, laborer 1
3845734 1972213 1972213 defendant Wykes Nicholas esq 591495 591495 Wykes, Nicholas, of Dodyngton, esq 0
3882136 1984284 1984284 defendant Sey John yeoman 591495 591495 Sey, John, of Dodyngton, yeoman 0
3883566 1984775 1984775 defendant Coler Thomas yeoman 591495 591495 Coler, Thomas, of Dodyngton, yeoman 0
3883600 1984785 1984785 defendant Coler Thomas yeoman 591495 591495 Coler, Thomas, of Dodyngton, yeoman 0
3886607 1985771 1985771 plaintiff Byllyng William (legal representative) 591495 591495 Byllyng, William, of Dodyngton, executors of 0
3897768 1989460 1989460 plaintiff Wykes Nicholas esq 591495 591495 Wykes, Nicholas, of Dodyngton, esq 0
3925586 1998870 1998870 defendant Long Robert yeoman 591495 591495 Long, Robert, of Dodyngton, yeoman 0
3942747 2004578 2004578 plaintiff Wykes Nicholas   591495 591495 Wykes, Nicholas, of Dodyngton, esquire 0
3948931 2006693 2006693 plaintiff Dosen Margaret spinster 591495 591495 Margaret his wife, alias Margaret Hall, of Dodyngton, spinster 1
3950351 2007204 2007204 defendant Mylton Robert yeoman 591495 591495 Mylton, Robert, of Dodyngton, yeoman 1
3953416 2008266 2008266 defendant Inkys or Jukys Roger (legal representative) 591495 591495 Inkys or Jukys, Roger, of Dodyngton, executors of 0
3960666 2010831 2010831 defendant Barlyng John clerk 591495 591495 Barlyng, John, of Dodyngton, clerk 0
3987201 2020167 2020167 plaintiff Wykes Robert esq 591495 591495 Wykes, Robert, of Dodyngton, esq 0
3992512 2022080 2022080 defendant Dighton Gilbert gent 591495 591495 Dighton, Gilbert, of Dodyngton, or of Staynfeld, gent 0
3992594 2022100 2022100 defendant Dighton Gilbert gent 591495 591495 Dighton, Gilbert, of Dodyngton, or of Staynfeld, Lincs, gent 0
4148195 2077503 2077503 defendant Bedmanton Thomas tailor 591495 591495 Bedmanton, Thomas, of Dodyngton, tailor 0
4190764 2092331 2092331 defendant Baker alias Myllett William smith 591495 591495 Baker alias Myllett, William, of Dodyngton, smith 1
4192419 2092903 2092903 defendant Mogges Edward laborer 591495 591495 Mogges, Edward, of Dodyngton, laborer 1
4200740 2095818 2095818 defendant Yate John gent 591495 591495 Yate, John, of Dodyngton, gent 0
4307024 2132597 2132597 defendant Lynnett alias Myller John vintner 591495 591495 Lynnett alias Myller, John, of Dodyngton, vintner 1
4308118 2132984 2132984 defendant Mace   tailor 591495 591495 Mace, , of Dodyngton, tailor 3
4420578 2171339 2171339 defendant Ounesby William de   591495 591495 Ounesby, William de, of Dodyngton, parson 1
4438839 2181439 2181439 plaintiff atte Lane Henry clerk 591495 591495 atte Lane, Henry, of Dodyngton, clerk 0
4438841 2181440 2181440 plaintiff atte Lane Henry clerk 591495 591495 atte Lane, Henry, of Dodyngton, clerk, on his own account 0
4439793 2181721 2181721 defendant Stanbourne Richard   591495 591495 Stanbourne, Richard, of Dodyngton 0
4463331 2189223 2189223 defendant Clerk John   591495 591495 Clerk, John, of Dodyngton 0
4494812 2199065 2199065 defendant Bron John   591495 591495 Bron, John, of Dodyngton 0
4515961 2205414 2205414 defendant Bertelot William   591495 591495 Bertelot, William, of Dodyngton 1
4545168 2214410 2214410 plaintiff Bernard William   591495 591495 Bernard, William, of Dodyngton 0
4545170 2214410 2214410 defendant Alcote William   591495 591495 Alcote, William, of Dodyngton, servant of Richard Alcote 1
4558096 2218468 2218468 defendant Shepherd William   591495 591495 Shepherd, William, of Dodyngton 0
4558097 2218468 2218468 defendant Smyth John   591495 591495 Smyth, John, of Dodyngton 1
4558098 2218468 2218468 defendant Neleman John   591495 591495 Neleman, John, of Dodyngton 2
4558099 2218468 2218468 defendant atte Well William   591495 591495 atte Well, William, of Dodyngton 3
4584769 2226661 2226661 defendant Scotte John chaplain 591495 591495 Scotte, John, of Dodyngton, chaplain 0
4586862 2227290 2227290 defendant Beston Lawrence   591495 591495 Beston, Lawrence, of Dodyngton 0
4593119 2229158 2229158 plaintiff Page John   591495 591495 Page, John, of Dodyngton 0
4593915 2229373 2229373 plaintiff Perye John (legal representative) 591495 591495 Perye, John, of Dodyngton, parson, executors of 0
4609787 2234154 2234154 defendant Bourne Bartholomew   591495 591495 Bourne, Bartholomew, of Dodyngton 0
4613085 2235148 2235148 defendant Smyth Nicholas   591495 591495 Smyth, Nicholas, of Dodyngton 9
4615338 2235805 2235805 defendant Warde John   591495 591495 Warde, John, of Dodyngton 1
4615772 2235929 2235929 defendant Dunnyng John   591495 591495 Dunnyng, John, of Dodyngton 0
4615773 2235929 2235929 defendant Treulove Richard   591495 591495 Treulove, Richard, of Dodyngton 1
4615774 2235929 2235929 defendant Treulove Thomas   591495 591495 Treulove, Thomas, of Dodyngton 2
4615775 2235929 2235929 defendant Massyngham John   591495 591495 Massyngham, John, of Dodyngton 3
4615776 2235929 2235929 defendant Fole John   591495 591495 Fole, John, of Dodyngton 4
4621918 2237835 2237835 defendant Beston Lawrence   591495 591495 Beston, Lawrence, of Dodyngton 0
4621919 2237835 2237835 defendant Paget Thomas   591495 591495 Paget, Thomas, of Dodyngton 1
4621922 2237835 2237835 defendant Pole John   591495 591495 Pole, John, of Dodyngton 4
4625822 2239029 2239029 plaintiff Perye John (legal representative) 591495 591495 Perye, John, of Dodyngton, parson, executors of 0
4627371 2239499 2239499 plaintiff Robertson John   591495 591495 Robertson, John, of Dodyngton 0
4630253 2240372 2240372 defendant Don Richard   591495 591495 Don, Richard, of Dodyngton 1
4632176 2240944 2240944 defendant Redhed John   591495 591495 Redhed, John, of Dodyngton 0
4634090 2241510 2241510 plaintiff Dawndelyn John   591495 591495 (Dawndelyn, John, of Dodyngton 1
4635153 2241840 2241840 plaintiff Dawndelyn John   591495 591495 (Dawndelyn, John, of Dodyngton 1
4640018 2243207 2243207 defendant Baxster John   591495 591495 Baxster, John, of Dodyngton 0
4652803 2246810 2246810 defendant Kyng Nicholas husbandman 591495 591495 Kyng, Nicholas, of Dodyngton, husbandman 3
4657001 2248080 2248080 defendant Meke John husbandman 591495 591495 Meke, John, of Dodyngton, husbandman 4
4665419 2250660 2250660 defendant Claxton John smith 591495 591495 Claxton, John, of Dodyngton, smith 1
4676280 2258194 2258194 defendant atte Scathe William husbandman 591495 591495 atte Scathe, William, of Dodyngton, husbandman 1
4676282 2258194 2258194 defendant Tent John laborer 591495 591495 Tent, John, of Dodyngton, laborer 3
4676284 2258194 2258194 defendant Wade John laborer 591495 591495 Wade, John, of Dodyngton, laborer 5
4676285 2258194 2258194 defendant Berebat Lawrence laborer 591495 591495 Berebat, Lawrence, of Dodyngton, laborer 6
4681824 2259926 2259926 defendant Hunte Thomas husbandman 591495 591495 Hunte, Thomas, of Dodyngton, husbandman 1
4683369 2260399 2260399 defendant Hykkelyng Lewis parker 591495 591495 Hykkelyng, Lewis, of Dodyngton, parker 2
4683370 2260399 2260399 defendant Man Henry husbandman 591495 591495 Man, Henry, of Dodyngton, husbandman 3
4688185 2261871 2261871 defendant Hore William husbandman 591495 591495 Hore, William, of Dodyngton, husbandman 0
4688516 2261973 2261973 defendant Athelave John husbandman 591495 591495 Athelave, John, of Dodyngton, husbandman 0
4693418 2263442 2263442 defendant Colyns Robert husbandman 591495 591495 Colyns, Robert, of Dodyngton, husbandman 1
4701541 2265877 2265877 defendant atte Seathe William husbandman 591495 591495 atte Seathe, William, of Dodyngton, husbandman 1
4701543 2265877 2265877 defendant Tent John laborer 591495 591495 Tent, John, of Dodyngton, laborer 3

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