names

119 rows where place_id = 585908

✎ 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
3587470 1863728 1863728 defendant Amy William husbandman 585908 585908 Amy, William, of Hyllyngton, husbandman 1
3616009 1872641 1872641 defendant Miller John yeoman 585908 585908 Miller, John, of Hyllyngton, yeoman 0
3624467 1875188 1875188 defendant Barker Richard husbandman 585908 585908 Barker, Richard, of Hyllyngton, husbandman 1
3634886 1905712 1905712 defendant Fysshe Adam barker 585908 585908 Fysshe, Adam, of Hyllyngton, barker 1
3644618 1908728 1908728 defendant Myddelton Robert tiler 585908 585908 Myddelton, Robert, of Hyllyngton, tiler 1
3644619 1908728 1908728 defendant Fynemore John laborer 585908 585908 Fynemore, John, of Hyllyngton, laborer 2
3671587 1917098 1917098 defendant Baker Katherine widow 585908 585908 Baker, Katherine, of Hyllyngton, widow 0
3700762 1926491 1926491 defendant Proberd Richard yeoman 585908 585908 Proberd, Richard, of Hyllyngton, yeoman 0
3700763 1926491 1926491 defendant Wylson William clerk 585908 585908 Wylson, William, of Hyllyngton, clerk 1
3700764 1926491 1926491 defendant Cheney Edmund husbandman 585908 585908 Cheney, Edmund, of Hyllyngton, husbandman 2
3734699 1937100 1937100 defendant Adamson Thomas tailor 585908 585908 Adamson, Thomas, of Hyllyngton, tailor 0
3737210 1937870 1937870 defendant Dalton John husbandman 585908 585908 Dalton, John, of Hyllyngton, husbandman 0
3749438 1941740 1941740 defendant Prowberd Richard yeoman 585908 585908 Prowberd, Richard, of Hyllyngton, yeoman 0
3758504 1944656 1944656 defendant Thursby Thomas gent 585908 585908 Thursby, Thomas, of Hyllyngton, gent 0
3758779 1944733 1944733 defendant Thursby Thomas gent 585908 585908 Thursby, Thomas, of Hyllyngton, gent 0
3758787 1944737 1944737 defendant Thursby Thomas gent 585908 585908 Thursby, Thomas, of Hyllyngton, gent 0
3762130 1945797 1945797 defendant Crathorn William husbandman 585908 585908 Crathorn, William, of Hyllyngton, husbandman 3
3777345 1950659 1950659 defendant Haye William clerk 585908 585908 Haye, William, of Hyllyngton, clerk 0
3788132 1954083 1954083 defendant Alde Robert husbandman 585908 585908 Alde, Robert, of Hyllyngton, husbandman 1
3794078 1956012 1956012 defendant Jermyn William husbandman 585908 585908 Jermyn, William, of Hyllyngton, husbandman 0
3795298 1956397 1956397 defendant Atteffeld Barnard   585908 585908 Atteffeld, Barnard, of Hyllyngton, worsted weaver 0
3803900 1959132 1959132 defendant Thurresby Thomas gent 585908 585908 Thurresby, Thomas, of Hyllyngton, gent 0
3805819 1959760 1959760 defendant Thursby Thomas gent 585908 585908 Thursby, Thomas, of Hyllyngton, gent 0
3806863 1960054 1960054 defendant Crathorn William husbandman 585908 585908 Crathorn, William, of Hyllyngton, husbandman 0
3821426 1964595 1964595 defendant Newman Thomas husbandman 585908 585908 Newman, Thomas, of Hyllyngton, husbandman 0
3829971 1967268 1967268 defendant Grey Robert miller 585908 585908 Grey, Robert, of Hyllyngton, miller 1
3834874 1968847 1968847 defendant Grey Robert miller 585908 585908 Grey, Robert, of Hyllyngton, miller 4
3834879 1968848 1968848 defendant Grey Robert miller 585908 585908 Grey, Robert, of Hyllyngton, miller 3
3854513 1975051 1975051 defendant Baker John gent 585908 585908 Baker, John, of Hyllyngton, gent 0
3856357 1975609 1975609 defendant Awnderson William husbandman 585908 585908 Awnderson, William, of Hyllyngton, husbandman 0
3863029 1977834 1977834 defendant Rosen Robert laborer 585908 585908 Rosen, Robert, of Hyllyngton, laborer 1
3871083 1980582 1980582 defendant Newman Thomas husbandman 585908 585908 Newman, Thomas, of Hyllyngton, husbandman 0
3877110 1982586 1982586 defendant Baker Martin yeoman 585908 585908 Baker, Martin, of Hyllyngton, yeoman 1
3888761 1986494 1986494 defendant Jary Robert yeoman 585908 585908 Jary, Robert, of Hyllyngton, yeoman 0
3890449 1987062 1987062 defendant Baker Martin yeoman 585908 585908 Baker, Martin, of Hyllyngton, yeoman 2
3902796 1991164 1991164 defendant Jary Robert yeoman 585908 585908 Jary, Robert, of Hyllyngton, yeoman 0
3912556 1994530 1994530 defendant Jary Robert husbandman 585908 585908 Jary, Robert, of Hyllyngton, husbandman 2
3912947 1994661 1994661 defendant Jary Robert yeoman 585908 585908 Jary, Robert, of Hyllyngton, yeoman 0
3914945 1995348 1995348 defendant Jary Robert gent 585908 585908 Jary, Robert, of Hyllyngton, gent 1
3930204 2000449 2000449 defendant Mowsdale Robert yeoman 585908 585908 Mowsdale, Robert, of Hyllyngton, yeoman 0
3932288 2001103 2001103 defendant Lyngeye Godfrey husbandman 585908 585908 Lyngeye, Godfrey, of Hyllyngton, husbandman 1
3933071 2001354 2001354 defendant Rutland Simons tailor 585908 585908 Rutland, Simons, of Hyllyngton, tailor 3
3940422 2003815 2003815 defendant Platffote William gent 585908 585908 Platffote, William, of Hyllyngton, gent 0
3940436 2003822 2003822 defendant Platfote Richard yeoman 585908 585908 Platfote, Richard, of Hyllyngton, yeoman 0
3940438 2003823 2003823 defendant Platfote William gent 585908 585908 Platfote, William, of Hyllyngton, gent 0
3940439 2003823 2003823 defendant Platfote Richard yeoman 585908 585908 Platfote, Richard, of Hyllyngton, yeoman 1
3940440 2003823 2003823 defendant Vynt or Vyut Peter yeoman 585908 585908 Vynt or Vyut, Peter, of Hyllyngton, yeoman 2
3944492 2005175 2005175 plaintiff Bastard Edmund   585908 585908 Bastard, Edmund, of Hyllyngton 0
3977863 2016830 2016830 defendant Wryght Peter   585908 585908 Wryght, Peter, of Hyllyngton, shepherd 1
3989243 2020894 2020894 defendant Haddon Thomas husbandman 585908 585908 Haddon, Thomas, of Hyllyngton, husbandman 0
4011377 2028846 2028846 plaintiff Platfote Richard (legal representative) 585908 585908 Platfote, Richard, of Hyllyngton, yeoman, executors of 0
4011381 2028846 2028846 defendant Bastard Edmund (legal representative) 585908 585908 Bastard, Edmund, of Hyllyngton, yeoman, executors of 0
4037962 2038224 2038224 defendant Waller John husbandman 585908 585908 Waller, John, of Hyllyngton, husbandman 1
4046004 2041015 2041015 defendant Cheney Hugh husbandman 585908 585908 Cheney, Hugh, of Hyllyngton, husbandman 2
4046005 2041015 2041015 defendant Fowle Ralph yeoman 585908 585908 Fowle, Ralph, of Hyllyngton, yeoman 3
4047037 2041389 2041389 defendant Fowle Ralph yeoman 585908 585908 Fowle, Ralph, of Hyllyngton, yeoman 1
4075961 2051698 2051698 defendant Fowle Ralph yeoman 585908 585908 Fowle, Ralph, of Hyllyngton, yeoman 8
4077367 2052190 2052190 defendant Flegg Thomas yeoman 585908 585908 Flegg, Thomas, of Hyllyngton, yeoman 0
4110752 2064104 2064104 defendant Flegg Thomas gent 585908 585908 Flegg, Thomas, of Hyllyngton, gent 1
4274541 2121040 2121040 defendant Heath Henry yeoman 585908 585908 Heath, Henry, of Hyllyngton, yeoman 1
4274542 2121040 2121040 defendant Humfry Alexander yeoman 585908 585908 Humfry, Alexander, of Hyllyngton, yeoman 2
4278510 2122418 2122418 defendant Stede William gent 585908 585908 Stede, William, of Hyllyngton, gent 0
4281534 2123446 2123446 defendant Stede William yeoman 585908 585908 Stede, William, of Hyllyngton, yeoman 0
4282024 2123613 2123613 defendant Steade William yeoman 585908 585908 Steade, William, of Hyllyngton, yeoman 0
4283900 2124279 2124279 defendant Humfrey Alexander yeoman 585908 585908 Humfrey, Alexander, of Hyllyngton, yeoman 2
4286658 2125276 2125276 defendant Humfry Alexander yeoman 585908 585908 Humfry, Alexander, of Hyllyngton, yeoman 0
4323335 2138224 2138224 defendant Stede William yeoman 585908 585908 Stede, William, of Hyllyngton, yeoman 0
4939377 2338697 2338697 defendant Ingleger John husbandman 585908 585908 Ingleger, John, of Hyllyngton, husbandman 1
4991860 2354451 2354451 defendant Hypgame Roger husbandman 585908 585908 Hypgame, Roger, of Hyllyngton, husbandman 0
4991862 2354451 2354451 defendant Hypgame John laborer 585908 585908 Hypgame, John, of Hyllyngton, laborer 2
5038096 2368027 2368027 defendant Gymer or Eymer Robert husbandman 585908 585908 Gymer or Eymer, Robert, of Hyllyngton, husbandman 0
5048745 2371262 2371262 defendant Home Thomas gent 585908 585908 Home, Thomas, of Hyllyngton, gent 0
5148753 2400757 2400757 defendant Berewyk William husbandman 585908 585908 Berewyk, William, of Hyllyngton, husbandman 0
5167901 2406324 2406324 defendant Yope John laborer 585908 585908 Yope, John, of Hyllyngton, laborer 0
5223722 2422623 2422623 defendant Thweyt Thomas yeoman 585908 585908 Thweyt, Thomas, of Hyllyngton, yeoman 2
5223723 2422623 2422623 defendant Gymer or Eymer Robert yeoman 585908 585908 Gymer or Eymer, Robert, of Hyllyngton, yeoman 3
5223728 2422624 2422624 defendant Thweyt Thomas yeoman 585908 585908 Thweyt, Thomas, of Hyllyngton, yeoman 2
5223729 2422624 2422624 defendant Gymer or Eymer Robert yeoman 585908 585908 Gymer or Eymer, Robert, of Hyllyngton, yeoman 3
5233003 2425234 2425234 defendant Twayte Thomas yeoman 585908 585908 Twayte, Thomas, of Hyllyngton, yeoman 3
5233016 2425238 2425238 defendant Thweyte Thomas yeoman 585908 585908 Thweyte, Thomas, of Hyllyngton, yeoman 1
5233017 2425238 2425238 defendant Pollard John yeoman 585908 585908 Pollard, John, of Hyllyngton, yeoman 2
5236884 2426371 2426371 defendant Yope John husbandman 585908 585908 Yope, John, of Hyllyngton, husbandman 0
5242474 2428007 2428007 defendant Home Thomas gent 585908 585908 Home, Thomas, of Hyllyngton, gent 1
5246087 2429021 2429021 defendant Thwayte Thomas yeoman 585908 585908 Thwayte, Thomas, of Hyllyngton, yeoman 0
5250306 2430203 2430203 defendant Hoberd Thomas yeoman 585908 585908 Hoberd, Thomas, of Hyllyngton, yeoman 1
5251780 2430666 2430666 defendant Sygon Thomas husbandman 585908 585908 Sygon, Thomas, of Hyllyngton, husbandman 0
5260826 2433509 2433509 defendant Hoberd Thomas husbandman 585908 585908 Hoberd, Thomas, of Hyllyngton, husbandman 0
5263953 2434487 2434487 defendant Sygon Thomas baker 585908 585908 Sygon, Thomas, of Hyllyngton, baker 0
5263954 2434487 2434487 defendant Grome Thomas husbandman 585908 585908 Grome, Thomas, of Hyllyngton, husbandman 1
5277411 2438472 2438472 defendant Sygon Thomas yeoman 585908 585908 Sygon, Thomas, of Hyllyngton, yeoman 1
5277596 2438525 2438525 plaintiff Asshemole Nicholas   585908 585908 Asshemole, Nicholas, of Hyllyngton 0
5277597 2438525 2438525 defendant Pymond Thomas weaver 585908 585908 Pymond, Thomas, of Hyllyngton, weaver 0
5282754 2440015 2440015 defendant Lawes alias Goodman John yeoman 585908 585908 Lawes alias Goodman, John, of Hyllyngton, yeoman 1
5282762 2440016 2440016 defendant Prowet Robert   585908 585908 Prowet, Robert, of Hyllyngton, shepherd 2
5285449 2440765 2440765 defendant Hoberd Thomas husbandman 585908 585908 Hoberd, Thomas, of Hyllyngton, husbandman 2
5293667 2443112 2443112 defendant Mercheburn alias Asshmole Nicholas yeoman 585908 585908 Mercheburn alias Asshmole, Nicholas, of Hyllyngton, yeoman 0
5296577 2443987 2443987 defendant Aysshmoll alias Melcheburn Nicholas yeoman 585908 585908 Aysshmoll alias Melcheburn, Nicholas, of Hyllyngton, yeoman 2
5305328 2446599 2446599 defendant Hobberd Thomas yeoman 585908 585908 Hobberd, Thomas, of Hyllyngton, yeoman 0
5306133 2446824 2446824 defendant Phelip Thomas husbandman 585908 585908 Phelip, Thomas, of Hyllyngton, husbandman 0
5306365 2446888 2446888 defendant Pycher William laborer 585908 585908 Pycher, William, of Hyllyngton, laborer 1

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