names

53 rows where place_id = 593850

✎ 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
3613590 1871896 1871896 defendant Johnson Oliver yeoman 593850 593850 Johnson, Oliver, of Lanam, yeoman 0
3617152 1872988 1872988 defendant Wyse alias Pope William   593850 593850 Wyse alias Pope, William, of Lanam, tile maker 0
3628444 1903763 1903763 defendant Stevynson Robert yeoman 593850 593850 Stevynson, Robert, of Lanam, yeoman 3
3659668 1913280 1913280 plaintiff Grome Robert   593850 593850 Grome, Robert, of Lanam 0
3665365 1915121 1915121 plaintiff Sprynge Thomas gent 593850 593850 Sprynge, Thomas, of Lanam, gent 0
3697288 1925374 1925374 defendant Barker William butcher 593850 593850 Barker, William, of Lanam, butcher 0
3732731 1936468 1936468 plaintiff Crytoft Robert, senior clothmaker 593850 593850 Crytoft, Robert, senior, of Lanam, clothmaker 0
3746902 1940948 1940948 plaintiff Crytoft Robert, senior clothmaker 593850 593850 Crytoft, Robert, senior, of Lanam, clothmaker 0
3758410 1944624 1944624 defendant Brett William yeoman 593850 593850 Brett, William, of Lanam, yeoman 0
3758414 1944626 1944626 defendant Brett William yeoman 593850 593850 Brett, William, of Lanam, yeoman 0
3799237 1957675 1957675 defendant Holland Richard   593850 593850 Holland, Richard, of Lanam clerk 0
3814342 1962399 1962399 defendant Chapman Thomas tailor 593850 593850 Chapman, Thomas, of Lanam, tailor 0
3815100 1962643 1962643 plaintiff Grome Robert   593850 593850 Grome, Robert, of Lanam 0
3815104 1962644 1962644 plaintiff Grome Robert   593850 593850 Grome, Robert, of Lanam 0
3902391 1991031 1991031 defendant Breten Roger yeoman 593850 593850 Breten, Roger, of Lanam, yeoman 2
3932885 2001289 2001289 defendant Regyll Roger clothier 593850 593850 Regyll, Roger, of Lanam, clothier 1
3959191 2010302 2010302 defendant Pye George Suff, clothier 593850 593850 Pye. George, of Lanam, Suff, clothier 0
4640772 2243404 2243404 defendant Taverner William   593850 593850 Taverner, William, of Lanam 0
4754258 2281710 2281710 defendant Marshall Richard husbandman 593850 593850 Marshall, Richard, of Lanam, husbandman 0
4864454 2315857 2315857 defendant Fleshewer William husbandman 593850 593850 Fleshewer, William, of Lanam, husbandman 2
4902662 2327452 2327452 defendant Peres Robert husbandman 593850 593850 Peres, Robert, of Lanam, husbandman 2
5010392 2359906 2359906 defendant Wade William husbandman 593850 593850 Wade, William, of Lanam, husbandman 1
5010393 2359906 2359906 defendant Foucher William yeoman 593850 593850 Foucher, William, of Lanam, yeoman 2
5087564 2382743 2382743 defendant Gilby William, senior   593850 593850 Gilby, William, senior, of Lanam, husbandma 1
5109058 2389067 2389067 defendant Emson John husbandman 593850 593850 Emson, John, of Lanam, husbandman 5
5206336 2417589 2417589 plaintiff Joly Robert   593850 593850 Joly, Robert, of Lanam 0
5229675 2424299 2424299 defendant Belamy William husbandman 593850 593850 Belamy, William, of Lanam, husbandman 1
5259723 2433167 2433167 defendant Belamy William husbandman 593850 593850 Belamy, William, of Lanam, husbandman 0
5271525 2436767 2436767 defendant Bumpstede Robert fuller 593850 593850 Bumpstede, Robert, of Lanam, fuller 0
5271526 2436767 2436767 defendant Lely Thomas weaver 593850 593850 Lely, Thomas, of Lanam, weaver 1
5271527 2436767 2436767 defendant Starteoute Thomas fuller 593850 593850 Starteoute, Thomas, of Lanam, fuller 2
5316012 2449865 2449865 plaintiff Curby John (legal representative) 593850 593850 Curby, John, of Lanam, husbandman, executors of 0
5318902 2450747 2450747 defendant Bumstede Robert fuller 593850 593850 Bumstede, Robert, of Lanam, fuller 0
5318903 2450747 2450747 defendant Cadewold Simon weaver 593850 593850 Cadewold, Simon, of Lanam, weaver 1
5318904 2450747 2450747 defendant Startowe or Scartowe Thomas fuller 593850 593850 Startowe or Scartowe, Thomas, of Lanam, fuller 2
5318905 2450747 2450747 defendant Lille Thomas weaver 593850 593850 Lille, Thomas, of Lanam, weaver 3
5318909 2450748 2450748 defendant Bumstede Robert fuller 593850 593850 Bumstede, Robert, of Lanam, fuller 0
5318910 2450748 2450748 defendant Startowe or Scartowe Thomas fuller 593850 593850 Startowe or Scartowe, Thomas, of Lanam, fuller 1
5318914 2450749 2450749 defendant Cadewold Simon weaver 593850 593850 Cadewold, Simon, of Lanam, weaver 0
5318915 2450749 2450749 defendant Startowte Thomas fuller 593850 593850 Startowte, Thomas, of Lanam, fuller 1
5318916 2450749 2450749 defendant Lille Thomas weaver 593850 593850 Lille, Thomas, of Lanam, weaver 2
5320276 2451151 2451151 defendant Causton Thomas clothmaker 593850 593850 Causton, Thomas, of Lanam, clothmaker 0
5320278 2451152 2451152 defendant Dister Alan clothmaker 593850 593850 Dister, Alan, of Lanam, clothmaker 0
5320280 2451153 2451153 defendant Lynche John clothmaker 593850 593850 Lynche, John, of Lanam, clothmaker 0
5346925 2459197 2459197 defendant Bomstede Robert fuller 593850 593850 Bomstede, Robert, of Lanam, fuller 1
5377901 2468664 2468664 defendant Hoggeson Christopher yeoman 593850 593850 Hoggeson, Christopher, of Lanam, yeoman 0
5384268 2470588 2470588 defendant Praty Thomas husbandman 593850 593850 Praty, Thomas, of Lanam, husbandman 1
5489577 2501763 2501763 defendant Bonyfa- Thomas painter 593850 593850 Bonyfa-, Thomas, of Lanam, painter 3
5516157 2509897 2509897 defendant Barker William (legal representative) 593850 593850 Barker, William, of Lanam, executors of 3
5587011 2530965 2530965 plaintiff Mason Thomas   593850 593850 Mason, Thomas, of Lanam 0
5587014 2530966 2530966 plaintiff Mason Thomas   593850 593850 Mason, Thomas, of Lanam 0
5588563 2531429 2531429 defendant Tomkyn John Waren yeoman 593850 593850 Tomkyn, John Waren, of Lanam, yeoman 1
5602318 2535620 2535620 plaintiff Mason Thomas   593850 593850 Mason, Thomas, of Lanam 0

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