names

144 rows where place_id = 593923

✎ 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
3591902 1865081 1865081 defendant Smethys Robert, junior   593923 593923 Smethys, Robert, junior, of Saxthorp, husbandman, son of Smethys, William, of Saxthorp 0
3602356 1868397 1868397 defendant Smyth Robert   593923 593923 Smyth, Robert, of Saxthorp, husbandman, son of Smyth, William 0
3603659 1868813 1868813 defendant Smyth Robert husbandman 593923 593923 Smyth, Robert, of Saxthorp, husbandman, son of Smyth, William, of Saxthorp, husbandman 2
3613851 1871988 1871988 defendant Martyns William, senior husbandman 593923 593923 Martyns, William, senior, of Saxthorp, husbandman 0
3613852 1871988 1871988 defendant Martyns John laborer 593923 593923 Martyns, John, of Saxthorp, laborer 1
3613853 1871988 1871988 defendant Smyth Thomas butcher 593923 593923 Smyth, Thomas, of Saxthorp, butcher 2
3613984 1872032 1872032 defendant Scarlet Thomas husbandman 593923 593923 Scarlet, Thomas, of Saxthorp, husbandman 3
3616675 1872845 1872845 defendant Scothowe Edmund husbandman 593923 593923 Scothowe, Edmund, of Saxthorp, husbandman 2
3623990 1875035 1875035 defendant Scothowe Edmund husbandman 593923 593923 Scothowe, Edmund, of Saxthorp, husbandman 2
3633113 1905167 1905167 defendant Hall Henry   593923 593923 Hall, Henry, of Saxthorp, worsted weaver 4
3633174 1905188 1905188 defendant Smyth Robert husbandman 593923 593923 Smyth, Robert, of Saxthorp, husbandman 0
3663003 1914341 1914341 defendant Hall Robert chaplain 593923 593923 Hall, Robert, of Saxthorp, chaplain 2
3719679 1932421 1932421 defendant Smythe Robert husbandman 593923 593923 Smythe, Robert, of Saxthorp, husbandman 0
3735419 1937316 1937316 defendant Smyth Robert husbandman 593923 593923 Smyth, Robert, of Saxthorp, husbandman 0
3738601 1938281 1938281 defendant Hill alias Roper Nicholas husbandman 593923 593923 Hill alias Roper, Nicholas, of Saxthorp, husbandman 0
3758867 1944763 1944763 defendant Smyth Thomas yeoman 593923 593923 Smyth, Thomas, of Saxthorp, yeoman 0
3759737 1945038 1945038 defendant Juet John husbandman 593923 593923 Juet, John, of Saxthorp, husbandman 0
3783170 1952492 1952492 defendant Reky Simon laborer 593923 593923 Reky, Simon, of Saxthorp, laborer 3
3783175 1952493 1952493 defendant Jeky Simon laborer 593923 593923 Jeky, Simon, of Saxthorp, laborer 3
3802221 1958588 1958588 defendant Brydde John husbandman 593923 593923 Brydde, John, of Saxthorp, husbandman 0
3840125 1970483 1970483 defendant Debell or Devell Robert yeoman 593923 593923 Debell or Devell, Robert, of Saxthorp, yeoman 0
3844276 1971761 1971761 defendant Jexes Robert tanner 593923 593923 Jexes, Robert, of Saxthorp, tanner 0
3858364 1976276 1976276 plaintiff Borne John   593923 593923 Borne, John, of Saxthorp 0
3862665 1977707 1977707 defendant Borne John husbandman 593923 593923 Borne, John, of Saxthorp, husbandman 0
3865216 1978571 1978571 defendant Empson Richard husbandman 593923 593923 Empson, Richard, of Saxthorp, husbandman 1
3957954 2009846 2009846 defendant Howlyng John blacksmith 593923 593923 Howlyng, John, of Saxthorp, blacksmith 0
3999131 2024448 2024448 defendant Bound William husbandman 593923 593923 Bound, William, of Saxthorp, husbandman 2
4005701 2026812 2026812 defendant Grey Thomas fishmonger 593923 593923 Grey, Thomas, of Saxthorp, fishmonger 0
4014976 2030071 2030071 defendant Adamson Robert clerk 593923 593923 Adamson, Robert, of Saxthorp, clerk 2
4024208 2033361 2033361 defendant Dey Thomas gent 593923 593923 Dey, Thomas, of Saxthorp, gent 0
4024210 2033362 2033362 defendant Dey Thomas gent 593923 593923 Dey, Thomas, of Saxthorp, gent 0
4052118 2043180 2043180 defendant Graye Thomas fishmonger 593923 593923 Graye, Thomas, of Saxthorp, fishmonger 3
4070517 2049748 2049748 defendant Daye Thomas merchant 593923 593923 Daye, Thomas, of Saxthorp, merchant 0
4084023 2054562 2054562 defendant Copledyke Humphrey gent 593923 593923 Copledyke, Humphrey, of Saxthorp, gent 0
4213994 2100416 2100416 defendant Bacon William gent 593923 593923 Bacon, William, of Saxthorp, gent 3
4274960 2121195 2121195 defendant Burlingham Thomas miller 593923 593923 Burlingham, Thomas, of Saxthorp, miller 0
4410802 2168202 2168202 defendant Rix Geoffrey miller 593923 593923 Rix, Geoffrey, of Saxthorp, miller 0
4434195 2175459 2175459 defendant Halleman Ralph   593923 593923 Halleman, Ralph, of Saxthorp 0
4452493 2185779 2185779 plaintiff Kempe Edmund   593923 593923 Kempe, Edmund, of Saxthorp 0
4493194 2198573 2198573 defendant Barkere Thomas   593923 593923 Barkere, Thomas, of Saxthorp 3
4493199 2198574 2198574 defendant Bakere Thomas   593923 593923 Bakere, Thomas, of Saxthorp 3
4516647 2205620 2205620 plaintiff Cook John   593923 593923 Cook, John, of Saxthorp 0
4564247 2220389 2220389 defendant Freman Robert   593923 593923 Freman, Robert, of Saxthorp 0
4564797 2220554 2220554 defendant Fre_ Robert   593923 593923 Fre_, Robert, of Saxthorp 3
4572480 2222931 2222931 defendant Millere Roger   593923 593923 Millere, Roger, of Saxthorp 3
4702161 2266085 2266085 defendant Bonde John yeoman 593923 593923 Bonde, John, of Saxthorp, yeoman 1
4716390 2270445 2270445 defendant Pynnyng John weaver 593923 593923 Pynnyng, John, of Saxthorp, weaver 4
4718497 2271126 2271126 defendant Grom John chaplain 593923 593923 Grom, John, of Saxthorp, husbandman, brother of Thomas Qwicke, of Saxthorp, chaplain 0
4718501 2271128 2271128 defendant Qwicke Thomas chaplain 593923 593923 Qwicke, Thomas, of Saxthorp, chaplain 0
4726255 2273498 2273498 plaintiff Grom John   593923 593923 Grom, John, of Saxthorp 0
4736642 2276590 2276590 defendant Grom John yeoman 593923 593923 Grom, John, of Saxthorp, yeoman 0
4752078 2281091 2281091 defendant Grom John yeoman 593923 593923 Grom, John, of Saxthorp, yeoman 2
4755802 2282196 2282196 defendant Morys John   593923 593923 Morys, John, of Saxthorp, shoe maker 2
4768827 2286228 2286228 defendant Broun John husbandman 593923 593923 Broun, John, of Saxthorp, husbandman 0
4787367 2292119 2292119 defendant Reede Thomas miller 593923 593923 Reede, Thomas, of Saxthorp, miller 0
4793342 2294016 2294016 defendant Broun John husbandman 593923 593923 Broun, John, of Saxthorp, husbandman 0
4797004 2295223 2295223 defendant Grome John husbandman 593923 593923 Grome, John, of Saxthorp, husbandman 0
4804968 2297759 2297759 defendant Bonde Thomas chaplain 593923 593923 Bonde, Thomas, of Saxthorp, chaplain 0
4813388 2300302 2300302 defendant Fydge William laborer 593923 593923 Fydge, William, of Saxthorp, laborer 1
4817120 2301448 2301448 defendant Grome John butcher 593923 593923 Grome, John, of Saxthorp, butcher 4
4838815 2308069 2308069 defendant Pose William yeoman 593923 593923 Pose, William, of Saxthorp, yeoman 1
4838821 2308071 2308071 defendant Pese William yeoman 593923 593923 Pese, William, of Saxthorp, yeoman 1
4838865 2308086 2308086 plaintiff Grome John   593923 593923 Grome, John, of Saxthorp 0
4838867 2308087 2308087 plaintiff Grome John   593923 593923 Grome, John, of Saxthorp 0
4840064 2308442 2308442 defendant Fygge William thatcher 593923 593923 Fygge, William, of Saxthorp, thatcher 3
4851939 2312041 2312041 defendant Poso William husbandman 593923 593923 Poso, William, of Saxthorp, husbandman 2
4855652 2313137 2313137 defendant Pose William yeoman 593923 593923 Pose, William, of Saxthorp, yeoman 1
4856018 2313254 2313254 defendant Grome John, junior yeoman 593923 593923 Grome, John, junior, of Saxthorp, yeoman 2
4859349 2314306 2314306 defendant Grom John husbandman 593923 593923 Grom, John, of Saxthorp, husbandman 0
4865172 2316082 2316082 defendant Martyns Geoffrey husbandman 593923 593923 Martyns, Geoffrey, of Saxthorp, husbandman 0
4865351 2316132 2316132 defendant Grome John butcher 593923 593923 Grome, John, of Saxthorp, butcher 3
4865627 2316214 2316214 defendant Boonde Thomas clerk 593923 593923 Boonde, Thomas, of Saxthorp, clerk 1
4866088 2316365 2316365 defendant Robert Henry yeoman 593923 593923 Robert, Henry, of Saxthorp, yeoman 2
4866089 2316366 2316366 plaintiff Grom John   593923 593923 Grom, John, of Saxthorp 0
4866091 2316367 2316367 plaintiff Grome John   593923 593923 Grome, John, of Saxthorp 0
4866099 2316370 2316370 plaintiff Groom John   593923 593923 Groom, John, of Saxthorp 0
4870930 2317882 2317882 defendant Bonde John husbandman 593923 593923 Bonde, John, of Saxthorp, husbandman 4
4895370 2325212 2325212 defendant Noloth John miller 593923 593923 Noloth, John, of Saxthorp, miller 0
4895371 2325212 2325212 defendant Pose William husbandman 593923 593923 Pose, William, of Saxthorp, husbandman 1
4902475 2327389 2327389 plaintiff Bettes Thomas   593923 593923 Bettes, Thomas, of Saxthorp 0
4904425 2327997 2327997 defendant Noloth John miller 593923 593923 Noloth, John, of Saxthorp, miller 0
4904426 2327997 2327997 defendant Pose William husbandman 593923 593923 Pose, William, of Saxthorp, husbandman 1
4911159 2330000 2330000 defendant Pese William sonmer 593923 593923 Pese, William, of Saxthorp, sonmer 13
4927908 2335163 2335163 defendant Heer Thomas, junior husbandman 593923 593923 Heer, Thomas, junior, of Saxthorp, husbandman 1
4949860 2341940 2341940 defendant Martynes Geoffrey husbandman 593923 593923 Martynes, Geoffrey, of Saxthorp, husbandman 12
4949861 2341940 2341940 defendant Smyth William husbandman 593923 593923 Smyth, William, of Saxthorp, husbandman 13
4959596 2344829 2344829 defendant Thirston Thomas husbandman 593923 593923 Thirston, Thomas, of Saxthorp, husbandman 0
4962122 2345577 2345577 defendant Grom John, junior husbandman 593923 593923 Grom, John, junior, of Saxthorp, husbandman 0
4965535 2346611 2346611 defendant Poose William husbandman 593923 593923 Poose, William, of Saxthorp, husbandman 0
4967576 2347244 2347244 defendant Taillon John husbandman 593923 593923 Taillon, John, of Saxthorp, husbandman 2
4967577 2347244 2347244 defendant Smyth John husbandman 593923 593923 Smyth, John, of Saxthorp, husbandman 3
4984500 2352299 2352299 defendant Gyllyng Simon   593923 593923 Gyllyng, Simon, of Saxthorp, shepherd 0
4985634 2352619 2352619 defendant Grom John husbandman 593923 593923 Grom, John, of Saxthorp, husbandman 0
4987630 2353262 2353262 defendant Taillour John yeoman 593923 593923 Taillour, John, of Saxthorp, yeoman 0
5014799 2361202 2361202 defendant Here Thomas husbandman 593923 593923 Here, Thomas, of Saxthorp, husbandman 0
5017774 2362076 2362076 defendant Grom John, senior husbandman 593923 593923 Grom, John, senior, of Saxthorp, husbandman 2
5017775 2362076 2362076 defendant Grom John, junior husbandman 593923 593923 Grom, John, junior, of Saxthorp, husbandman 3
5029183 2365413 2365413 defendant Taylour John yeoman 593923 593923 Taylour, John, of Saxthorp, yeoman 0
5031524 2366080 2366080 defendant Carter John yeoman 593923 593923 Carter, John, of Saxthorp, yeoman 2
5065048 2376076 2376076 defendant Mylam Richard   593923 593923 Mylam, Richard, of Saxthorp, collar maker 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);