names

142 rows where place_id = 588831

✎ 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
3595731 1866295 1866295 defendant Piers Nicholas smith 588831 588831 Piers, Nicholas, of Egerton, smith 0
3598517 1867165 1867165 defendant Pemyll Michael husbandman 588831 588831 Pemyll, Michael, of Egerton, husbandman 0
3627061 1903325 1903325 defendant Nynne Robert yeoman 588831 588831 Nynne, Robert, of Egerton, yeoman 0
3657755 1912678 1912678 defendant Nyne Robert yeoman 588831 588831 Nyne, Robert, of Egerton, yeoman 0
3672205 1917307 1917307 defendant Pyx John yeoman 588831 588831 Pyx, John, of Egerton, yeoman 0
3672912 1917541 1917541 defendant Barett James yeoman 588831 588831 Barett, James, of Egerton, yeoman 0
3680520 1919988 1919988 defendant Pyx John husbandman 588831 588831 Pyx, John, of Egerton, husbandman 0
3703844 1927481 1927481 defendant Pyx Thomas yeoman 588831 588831 Pyx, Thomas, of Egerton, yeoman 1
3705569 1928023 1928023 defendant Spyce Thomas butcher 588831 588831 Spyce, Thomas, of Egerton, butcher 2
3712598 1930255 1930255 defendant Keytterell John butcher 588831 588831 Keytterell, John, of Egerton, butcher 2
3717681 1931825 1931825 defendant Pyx Thomas yeoman 588831 588831 Pyx, Thomas, of Egerton, yeoman 1
3718480 1932059 1932059 defendant Keterell John butcher 588831 588831 Keterell, John, of Egerton, butcher 0
3720250 1932610 1932610 defendant Munde Robert clothmaker 588831 588831 Munde, Robert, of Egerton, clothmaker 1
3761882 1945725 1945725 defendant Atwater Edmund husbandman 588831 588831 Atwater, Edmund, of Egerton, husbandman 0
3761973 1945752 1945752 defendant Keterell John butcher 588831 588831 Keterell, John, of Egerton, butcher 1
3763748 1946307 1946307 defendant Kyng Thomas weaver 588831 588831 Kyng, Thomas, of Egerton, weaver 2
3769000 1947952 1947952 defendant Atwater Edmund husbandman 588831 588831 Atwater, Edmund, of Egerton, husbandman 0
3780139 1951511 1951511 defendant Keterell John butcher 588831 588831 Keterell, John, of Egerton, butcher 2
3781133 1951834 1951834 defendant at Water Edmund husbandman 588831 588831 at Water, Edmund, of Egerton, husbandman 0
3784288 1952876 1952876 defendant Water Edmund husbandman 588831 588831 Water, Edmund, of Egerton, husbandman 0
3786827 1953677 1953677 defendant Peers John yeoman 588831 588831 Peers, John, of Egerton, yeoman 0
3803105 1958874 1958874 defendant Pers John clothmaker 588831 588831 Pers, John, of Egerton, clothmaker 0
3820761 1964383 1964383 defendant Syswyke Thomas tailor 588831 588831 Syswyke, Thomas, of Egerton, tailor 0
3834213 1968642 1968642 defendant Monde Robert fuller 588831 588831 Monde, Robert, of Egerton, fuller 0
3845931 1972285 1972285 defendant Lovelet William butcher 588831 588831 Lovelet, William, of Egerton, butcher 0
3862091 1977508 1977508 defendant Water Edmund husbandman 588831 588831 Water, Edmund, of Egerton, husbandman 0
3899596 1990084 1990084 defendant Adam Peter laborer 588831 588831 Adam, Peter, of Egerton, laborer 1
3899748 1990130 1990130 plaintiff Borram Thomas   588831 588831 Borram, Thomas, of Egerton 0
3928336 1999813 1999813 defendant Burwassh George   588831 588831 Burwassh, George, of Egerton, cloth maker 0
3937969 2003033 2003033 defendant Pers Edward clothier 588831 588831 Pers, Edward, of Egerton, clothier 0
3937972 2003034 2003034 defendant Pers Edward clothier 588831 588831 Pers, Edward, of Egerton, clothier 0
3971939 2014744 2014744 defendant Bacheler John husbandman 588831 588831 Bacheler, John, of Egerton, husbandman 0
3976143 2016223 2016223 defendant Hames or Haines Anthony yeoman 588831 588831 Hames or Haines, Anthony, of Egerton, yeoman 0
3991988 2021897 2021897 defendant Chamber Gilbert clothworker 588831 588831 Chamber, Gilbert, of Egerton, clothworker 0
3991990 2021898 2021898 defendant Chamber Gilbert clothworker 588831 588831 Chamber, Gilbert, of Egerton, clothworker 0
4119950 2067424 2067424 defendant Hudson Ralph husbandman 588831 588831 Hudson, Ralph, of Egerton, husbandman 0
4120402 2067573 2067573 defendant Elson Ralph yeoman 588831 588831 Elson, Ralph, of Egerton, yeoman 1
4134623 2072714 2072714 defendant Elmeston Ralph butcher 588831 588831 Elmeston, Ralph, of Egerton, butcher 0
4140806 2074948 2074948 defendant Spice Robert yeoman 588831 588831 Spice, Robert, of Egerton, yeoman 2
4140862 2074968 2074968 defendant Spice Robert yeoman 588831 588831 Spice, Robert, of Egerton, yeoman 2
4142050 2075393 2075393 defendant Sudwick alias Sixeweek George husbandman 588831 588831 Sudwick alias Sixeweek, George, of Egerton, husbandman 1
4143013 2075725 2075725 defendant Hudson Christopher yeoman 588831 588831 Hudson, Christopher, of Egerton, yeoman 0
4143014 2075725 2075725 defendant Adman Thomas tailor 588831 588831 Adman, Thomas, of Egerton, tailor 1
4143015 2075725 2075725 defendant Harpe Stephen carpenter 588831 588831 Harpe, Stephen, of Egerton, carpenter 2
4158713 2081121 2081121 defendant Wolton Simon yeoman 588831 588831 Wolton, Simon, of Egerton, yeoman 0
4158714 2081121 2081121 defendant Elson Ralph butcher 588831 588831 Elson, Ralph, of Egerton, butcher 1
4167903 2084260 2084260 defendant Luckas John yeoman 588831 588831 Luckas, John, of Egerton, yeoman 0
4174488 2086544 2086544 defendant Gyles Richard butcher 588831 588831 Gyles, Richard, of Egerton, butcher 0
4181006 2088834 2088834 defendant Mond Henry husbandman 588831 588831 Mond, Henry, of Egerton, husbandman 0
4181007 2088834 2088834 defendant Mond John, senior husbandman 588831 588831 Mond, John, senior, of Egerton, husbandman 1
4181008 2088834 2088834 defendant Bocher Abraham yeoman 588831 588831 Bocher, Abraham, of Egerton, yeoman 2
4181009 2088834 2088834 defendant Pierse Edward yeoman 588831 588831 Pierse, Edward, of Egerton, yeoman 3
4210710 2099303 2099303 defendant Elson Ralph butcher 588831 588831 Elson, Ralph, of Egerton, butcher 0
4210711 2099303 2099303 defendant Adams John yeoman 588831 588831 Adams, John, of Egerton, yeoman 1
4210712 2099303 2099303 defendant Stonehouse Nathaniel yeoman 588831 588831 Stonehouse, Nathaniel, of Egerton, yeoman 2
4231941 2106671 2106671 defendant Elson Ralph   588831 588831 Elson, Ralph, of Egerton 0
4320876 2137394 2137394 defendant Spyce Christopher yeoman 588831 588831 Spyce, Christopher, of Egerton, yeoman 0
4370921 2154655 2154655 defendant Bacheler James weaver 588831 588831 Bacheler, James, of Egerton, weaver 1
4376574 2156693 2156693 defendant Spice Christopher yeoman 588831 588831 Spice, Christopher, of Egerton, yeoman 0
4382108 2158705 2158705 defendant Godden Anthony clothier 588831 588831 Godden, Anthony, of Egerton, clothier 1
4398724 2164153 2164153 defendant Bacheler James weaver 588831 588831 Bacheler, James, of Egerton, weaver 1
4531148 2210018 2210018 defendant Swyft Stephen   588831 588831 Swyft, Stephen, of Egerton 0
4531149 2210018 2210018 defendant Munde Thomas   588831 588831 Munde, Thomas, of Egerton 1
4536571 2211713 2211713 defendant Swyft Stephen   588831 588831 Swyft, Stephen, of Egerton 0
4566752 2221174 2221174 defendant Baldok Thomas   588831 588831 Baldok, Thomas, of Egerton 0
4566753 2221174 2221174 defendant Baldok John   588831 588831 Baldok, John, of Egerton 1
4693312 2263410 2263410 defendant atte Lee Henry farmer 588831 588831 atte Lee, Henry, of Egerton, farmer 0
4705460 2267075 2267075 defendant Newe William fuller 588831 588831 Newe, William, of Egerton, fuller 0
4718378 2271087 2271087 defendant Chylton William husbandman 588831 588831 Chylton, William, of Egerton, husbandman 0
4727743 2273921 2273921 defendant Chilton Thomas laborer 588831 588831 Chilton, Thomas, of Egerton, laborer 2
4740571 2277756 2277756 defendant Pemyl atte Cruche John husbandman 588831 588831 Pemyl atte Cruche, John, of Egerton, husbandman 2
4749820 2280422 2280422 defendant Telden Thomas laborer 588831 588831 Telden, Thomas, of Egerton, laborer 0
4759138 2283205 2283205 defendant Pamyll John laborer 588831 588831 Pamyll, John, of Egerton, laborer 1
4759144 2283206 2283206 defendant Pemyll John laborer 588831 588831 Pemyll, John, of Egerton, laborer 1
4774224 2287919 2287919 defendant atte Lee Henry laborer 588831 588831 atte Lee, Henry, of Egerton, laborer 0
4799683 2296085 2296085 defendant atte Lee Henry laborer 588831 588831 atte Lee, Henry, of Egerton, laborer 0
4799686 2296086 2296086 defendant atte Lee Henry laborer 588831 588831 atte Lee, Henry, of Egerton, laborer 0
4819073 2302050 2302050 defendant Godard John husbandman 588831 588831 Godard, John, of Egerton, husbandman 0
4850395 2311580 2311580 defendant Nynne Robert husbandman 588831 588831 Nynne, Robert, of Egerton, husbandman 0
4873617 2318687 2318687 defendant Gylnot Robert carpenter 588831 588831 Gylnot, Robert, of Egerton, carpenter 1
4878357 2320177 2320177 defendant Roberd John carpenter 588831 588831 together with Roberd, John, of Egerton, carpenter 3
4883709 2321816 2321816 defendant Aleyn Thomas farmer 588831 588831 Aleyn, Thomas, of Egerton, farmer 0
4906553 2328634 2328634 defendant Cotlond William farmer 588831 588831 Cotlond, William, of Egerton, farmer 7
4924634 2334141 2334141 plaintiff Nynne William   588831 588831 Nynne, William, of Egerton 0
4932425 2336535 2336535 defendant bocher John husbandman 588831 588831 bocher, John, of Egerton, husbandman 2
4936724 2337866 2337866 defendant Petynden Thomas husbandman 588831 588831 Petynden, Thomas, of Egerton, husbandman 3
4964679 2346342 2346342 defendant Smedyot John husbandman 588831 588831 (Smedyot, John, of Egerton, husbandman 1
4964680 2346342 2346342 defendant Knokke Henry husbandman 588831 588831 Knokke, Henry, of Egerton, husbandman 2
4966524 2346921 2346921 defendant Nyn John smith 588831 588831 Nyn, John, of Egerton, smith 0
4988657 2353563 2353563 defendant Petynfend Thomas husbandman 588831 588831 Petynfend, Thomas, of Egerton, husbandman 1
5067332 2376738 2376738 plaintiff Nynne William   588831 588831 Nynne, William, of Egerton 0
5074611 2378908 2378908 defendant Jekyn Richard fuller 588831 588831 Jekyn, Richard, of Egerton, fuller 0
5083306 2381507 2381507 defendant Marchall John miller 588831 588831 Marchall, John, of Egerton, miller 4
5086975 2382574 2382574 defendant Pemyll John butcher 588831 588831 Pemyll, John, of Egerton, butcher 1
5120134 2392324 2392324 defendant Barlyng Nicholas yeoman 588831 588831 Barlyng, Nicholas, of Egerton, yeoman 0
5137063 2397356 2397356 plaintiff Pemell John   588831 588831 Pemell, John, of Egerton 0
5137065 2397356 2397356 defendant atte Welle James husbandman 588831 588831 atte Welle, James, of Egerton, husbandman 1
5157676 2403376 2403376 plaintiff Pemell John   588831 588831 Pemell, John, of Egerton 0
5157678 2403376 2403376 defendant atte Welle James husbandman 588831 588831 atte Welle, James, of Egerton, husbandman 1
5173502 2407952 2407952 plaintiff Penell John   588831 588831 Penell, John, of Egerton 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);