names

117 rows where place_id = 588477

✎ 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
3594630 1865951 1865951 defendant Hegeson Thomas clerk 588477 588477 Hegeson, Thomas, of Foston, clerk 0
3594631 1865951 1865951 defendant Pereson Robert husbandman 588477 588477 Pereson, Robert, of Foston, husbandman 1
3594632 1865951 1865951 defendant Pereson John husbandman 588477 588477 Pereson, John, of Foston, husbandman 2
3594633 1865951 1865951 defendant Marton William smith 588477 588477 Marton, William, of Foston, smith 3
3594634 1865951 1865951 defendant Webster Robert husbandman 588477 588477 Webster, Robert, of Foston, husbandman 4
3594635 1865951 1865951 defendant Wilbarn William husbandman 588477 588477 Wilbarn, William, of Foston, husbandman 5
3594636 1865951 1865951 defendant Webster William husbandman 588477 588477 Webster, William, of Foston, husbandman 6
3609758 1870721 1870721 defendant Agard John   588477 588477 Agard, John, of Foston 1
3629401 1904051 1904051 defendant Marvyn Richard husbandman 588477 588477 Marvyn, Richard, of Foston, husbandman 0
3661642 1913920 1913920 plaintiff Lee Rowland   588477 588477 Lee, Rowland, of Foston, Rector 0
3661645 1913920 1913920 defendant Marton Richard husbandman 588477 588477 Marton, Richard, of Foston, husbandman 1
3661646 1913920 1913920 defendant Hecope William husbandman 588477 588477 Hecope, William, of Foston, husbandman 2
3663066 1914359 1914359 defendant Agard John (legal representative) 588477 588477 Agard, John, of Foston, executors of 0
3753803 1943131 1943131 defendant Marton William clerk 588477 588477 Marton, William, of Foston, clerk 0
3765343 1946822 1946822 defendant Agard John (legal representative) 588477 588477 Agard, John, of Foston, gent, executors of 0
3795532 1956484 1956484 defendant Gresley John gent 588477 588477 Gresley, John, of Foston, gent 0
3830424 1967399 1967399 defendant Patrike Robert yeoman 588477 588477 Patrike, Robert, of Foston, yeoman 1
3844416 1971805 1971805 defendant Dyconson Edmund smith 588477 588477 Dyconson, Edmund, of Foston, smith 0
3844417 1971805 1971805 defendant Dyconson Thomas laborer 588477 588477 Dyconson, Thomas, of Foston, laborer 1
3844418 1971805 1971805 defendant Durham Thomas husbandman 588477 588477 Durham, Thomas, of Foston, husbandman 2
3872187 1980928 1980928 defendant Benett William husbandman 588477 588477 Benett, William, of Foston, husbandman 0
3872190 1980929 1980929 defendant Benett William husbandman 588477 588477 Benett, William, of Foston, husbandman 0
3916116 1995775 1995775 defendant Ellys Christopher yeoman 588477 588477 Ellys, Christopher, of Foston, yeoman 0
3916118 1995776 1995776 defendant Ellys Christopher yeoman 588477 588477 Ellys, Christopher, of Foston, yeoman 0
3925500 1998841 1998841 plaintiff Wllys Christopher yeoman 588477 588477 Wllys, Christopher, of Foston, yeoman 0
3926335 1999131 1999131 defendant Coley Ralph clerk 588477 588477 Coley, Ralph, of Foston, clerk 0
3971658 2014650 2014650 defendant Foston John yeoman 588477 588477 Foston, John, of Foston, yeoman 2
3971684 2014658 2014658 defendant Foston John yeoman 588477 588477 Foston, John, of Foston, yeoman 2
3998936 2024377 2024377 defendant Hunter William yeoman 588477 588477 Hunter, William, of Foston, yeoman 0
4021765 2032512 2032512 plaintiff Agard William gent 588477 588477 Agard, William, of Foston, gent 0
4021767 2032513 2032513 plaintiff Agarde William gent 588477 588477 Agarde, William, of Foston, gent 0
4035662 2037432 2037432 defendant Grymme Augustine husbandman 588477 588477 Grymme, Augustine, of Foston, husbandman 0
4097257 2059340 2059340 defendant Brigham John yeoman 588477 588477 Brigham, John, of Foston, yeoman 0
4156874 2080482 2080482 defendant Jackson William yeoman 588477 588477 Jackson, William, of Foston, yeoman 7
4165811 2083540 2083540 defendant Brigham John yeoman 588477 588477 Brigham, John, of Foston, yeoman 4
4224173 2103943 2103943 defendant Boyes Christopher ferrier 588477 588477 Boyes Christopher, of Foston, ferrier 0
4224174 2103943 2103943 defendant Hewthwatt George yeoman 588477 588477 Hewthwatt, George, of Foston, yeoman 1
4258041 2115659 2115659 defendant Skelton Thomas gent 588477 588477 Skelton, Thomas, of Foston, gent 2
4264300 2117706 2117706 defendant Boyes Christopher ferrier 588477 588477 Boyes, Christopher, of Foston, ferrier 0
4264301 2117706 2117706 defendant Howthwatt George yeoman 588477 588477 Howthwatt, George, of Foston, yeoman 1
4270117 2119589 2119589 defendant Skelton Thomas gent 588477 588477 Skelton, Thomas, of Foston, gent 2
4383436 2159171 2159171 defendant Webster James yeoman 588477 588477 Webster, James, of Foston, yeoman 0
4392344 2162067 2162067 defendant Mellie Thomas husbandman 588477 588477 Mellie, Thomas, of Foston, husbandman 0
4413172 2168991 2168991 plaintiff atte Milne William chaplain 588477 588477 atte Milne, William, of Foston, chaplain 0
4413174 2168991 2168991 defendant Willardby John de chaplain 588477 588477 Willardby, John de, of Foston, chaplain 1
4419115 2170845 2170845 plaintiff atte Milne William chaplain 588477 588477 atte Milne, William, of Foston, chaplain 0
4419117 2170845 2170845 defendant Willardby John de chaplain 588477 588477 Willardby, John de, of Foston, chaplain 1
4430271 2174251 2174251 defendant atte Mylne William   588477 588477 atte Mylne, William, of Foston 0
4437659 2176536 2176536 defendant atte Milne William   588477 588477 atte Milne, William, of Foston 0
4463026 2189137 2189137 defendant Walssh John   588477 588477 Walssh, John, of Foston 5
4470886 2191546 2191546 plaintiff Burre Thomas   588477 588477 Burre, Thomas, of Foston 0
4478754 2194022 2194022 defendant Thorald Richard   588477 588477 Thorald, Richard, of Foston 0
4483190 2195439 2195439 defendant Geoffreyson Jacson John   588477 588477 Geoffreyson Jacson, John, of Foston 1
4503495 2201663 2201663 defendant Marsh John   588477 588477 Marsh, John, of Foston 1
4549717 2215846 2215846 plaintiff Couper Geoffrey   588477 588477 Couper, Geoffrey, of Foston 0
4566489 2221086 2221086 defendant Isok Thomas   588477 588477 Isok, Thomas, of Foston 3
4566491 2221086 2221086 defendant Isok John   588477 588477 Isok, John, of Foston 5
4569986 2222183 2222183 defendant atte Yate Roger   588477 588477 atte Yate, Roger, of Foston 0
4620686 2237456 2237456 defendant Forster John   588477 588477 Forster, John, of Foston 0
4624454 2238633 2238633 defendant Pete Henry   588477 588477 Pete, Henry, of Foston 0
4663821 2250169 2250169 defendant Wystowe Thomas husbandman 588477 588477 Wystowe, Thomas, of Foston, husbandman 0
4674669 2257686 2257686 defendant Tyler William yeoman 588477 588477 Tyler, William, of Foston, yeoman 3
4688734 2262034 2262034 defendant Smyth William, junior smith 588477 588477 Smyth, William, junior, of Foston, smith 0
4699784 2265375 2265375 defendant Porter John husbandman 588477 588477 Porter, John, of Foston, husbandman 0
4723714 2272721 2272721 defendant Foster John husbandman 588477 588477 Foster, John, of Foston, husbandman 2
4730284 2274676 2274676 defendant Tomlynson Henry yeoman 588477 588477 Tomlynson, Henry, of Foston, yeoman 1
4740444 2277720 2277720 defendant Wystowe Thomas husbandman 588477 588477 Wystowe, Thomas, of Foston, husbandman 0
4752599 2281222 2281222 defendant Shutare William tiler 588477 588477 Shutare, William, of Foston, tiler 0
4754934 2281924 2281924 defendant Forster John yeoman 588477 588477 Forster, John, of Foston, yeoman 0
4773213 2287590 2287590 defendant Hokurton Robert chaplain 588477 588477 Hokurton, Robert, of Foston, chaplain 0
4791350 2293388 2293388 defendant Forster John husbandman 588477 588477 Forster, John, of Foston, husbandman 1
4815363 2300914 2300914 defendant Geffes John, junior husbandman 588477 588477 Geffes, John, junior, of Foston, husbandman 1
4818278 2301794 2301794 defendant Colshill John yeoman 588477 588477 Colshill, John, of Foston, yeoman 2
4818282 2301795 2301795 defendant Colshyll John yeoman 588477 588477 Colshyll, John, of Foston, yeoman 2
4838750 2308045 2308045 defendant Forster John yeoman 588477 588477 Forster, John, of Foston, yeoman 0
4838753 2308046 2308046 defendant Forster John yeoman 588477 588477 Forster, John, of Foston, yeoman 0
4842266 2309114 2309114 defendant Lytyl Grey John husbandman 588477 588477 together with Lytyl Grey, John, of Foston, husbandman 4
4842271 2309115 2309115 defendant Lailgrey or Litilgrey John husbandman 588477 588477 Lailgrey or Litilgrey, John, of Foston, husbandman 3
4843720 2309558 2309558 defendant Forster John husbandman 588477 588477 Forster, John, of Foston, husbandman 1
4843810 2309585 2309585 defendant Belton William husbandman 588477 588477 together with Belton, William, of Foston, husbandman 1
4843812 2309585 2309585 defendant Alan William   588477 588477 Alan, William, of Foston 3
4843813 2309585 2309585 defendant Isek William   588477 588477 Isek, William, of Foston 4
4847122 2310602 2310602 defendant Gryndall Thomas   588477 588477 Gryndall, Thomas, of Foston, cart wright 1
4863313 2315492 2315492 defendant Forster John husbandman 588477 588477 Forster, John, of Foston, husbandman 2
4871097 2317936 2317936 defendant Forster John husbandman 588477 588477 together with Forster, John, of Foston, husbandman 1
4875041 2319143 2319143 defendant Langton Robert weaver 588477 588477 Langton, Robert, of Foston, husbandman, together with Langton, William, of Wykeston, weaver 0
4878743 2320288 2320288 defendant Grendale Thomas   588477 588477 Grendale, Thomas, of Foston, wright 5
4888543 2323215 2323215 defendant Geffys John, junior yeoman 588477 588477 Geffys, John, junior, of Foston, yeoman 0
4919147 2332500 2332500 defendant Brendall Thomas husbandman 588477 588477 Brendall, Thomas, of Foston, husbandman 0
4933276 2336799 2336799 plaintiff Wystowe Thomas   588477 588477 Wystowe, Thomas, of Foston 0
4968859 2347652 2347652 defendant Leyper William yeoman 588477 588477 Leyper, William, of Foston, yeoman 4
4975289 2349565 2349565 defendant Agard Thomas gent 588477 588477 Agard, Thomas, of Foston, gent 1
4999614 2356760 2356760 defendant Roos Henry   588477 588477 Roos, Henry, of Foston, parson 0
5001875 2357448 2357448 defendant Foster John husbandman 588477 588477 Foster, John, of Foston, husbandman 2
5008504 2359384 2359384 defendant Malkyn Thomas laborer 588477 588477 Malkyn, Thomas, of Foston, laborer 0
5012307 2360452 2360452 defendant Somer William husbandman 588477 588477 Somer, William, of Foston, husbandman 4
5019560 2362608 2362608 defendant Preston Peter husbandman 588477 588477 Preston, Peter, of Foston, husbandman 0
5094797 2384890 2384890 defendant Clerkeson John husbandman 588477 588477 Clerkeson, John, of Foston, husbandman 4
5368529 2465768 2465768 defendant Mylners Thomas yeoman 588477 588477 Mylners, Thomas, of Foston, yeoman 8
5368530 2465768 2465768 defendant Lyghtfote John yeoman 588477 588477 Lyghtfote, John, of Foston, yeoman 9

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