names

101 rows where place_id = 591124

✎ 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
3603412 1868739 1868739 defendant Parke Henry husbandman 591124 591124 Parke, Henry, of Foxley, husbandman 1
3620977 1874122 1874122 defendant Foxley John gent 591124 591124 Foxley, John, of Foxley, gent 7
3624616 1875236 1875236 defendant Foxley John gent 591124 591124 Foxley, John, of Foxley, gent 7
3627820 1903561 1903561 defendant Pynchyn Thomas husbandman 591124 591124 Pynchyn, Thomas, of Foxley, husbandman 0
3646875 1909420 1909420 defendant Burwell alias Burwey Clement husbandman 591124 591124 Burwell alias Burwey, Clement, of Foxley, husbandman 3
3651810 1910925 1910925 defendant Burwey Leonard husbandman 591124 591124 Burwey, Leonard, of Foxley, husbandman 0
3670899 1916864 1916864 defendant White William husbandman 591124 591124 White, William, of Foxley, husbandman 2
3681710 1920377 1920377 defendant Hamond Thomas clerk 591124 591124 Hamond, Thomas, of Foxley, clerk 0
3708725 1929025 1929025 defendant Harte Robert husbandman 591124 591124 Harte, Robert, of Foxley, husbandman 6
3708726 1929025 1929025 defendant Branche Thomas husbandman 591124 591124 Branche, Thomas, of Foxley, husbandman 7
3738364 1938212 1938212 defendant Mayden John thatcher 591124 591124 Mayden, John, of Foxley, thatcher 1
3751005 1942244 1942244 defendant Flete John clerk 591124 591124 Flete, John, of Foxley, clerk 0
3775930 1950222 1950222 defendant Dalymott Henry husbandman 591124 591124 Dalymott, Henry, of Foxley, husbandman 0
3815453 1962749 1962749 defendant Hamond Thomas chaplain 591124 591124 Hamond, Thomas, of Foxley, chaplain 4
3850412 1973718 1973718 defendant Horte Robert yeoman 591124 591124 Horte, Robert, of Foxley, yeoman 0
3850413 1973718 1973718 defendant Horte Edmund husbandman 591124 591124 Horte, Edmund, of Foxley, husbandman 1
3869586 1980068 1980068 defendant Frankeleyn Lawrence cooper 591124 591124 Frankeleyn, Lawrence, of Foxley, cooper 0
3922083 1997715 1997715 defendant Lowthe Nicholas cooper 591124 591124 Lowthe, Nicholas, of Foxley, cooper 2
3944774 2005271 2005271 defendant Bolly Robert sawyer 591124 591124 Bolly, Robert, of Foxley, sawyer 1
3977027 2016533 2016533 defendant Wigett Robert husbandman 591124 591124 Wigett, Robert, of Foxley, husbandman 2
4001649 2025369 2025369 defendant Heyth Robert husbandman 591124 591124 Heyth, Robert, of Foxley, husbandman 0
4023803 2033217 2033217 defendant Blackwey Roger husbandman 591124 591124 Blackwey, Roger, of Foxley, husbandman 3
4054071 2043839 2043839 defendant Sheringham Humphrey butcher 591124 591124 Sheringham, Humphrey, of Foxley, butcher 1
4062723 2046966 2046966 defendant Sheringham Humphrey butcher 591124 591124 Sheringham, Humphrey, of Foxley, butcher 3
4065795 2048061 2048061 defendant Burwaye Clement husbandman 591124 591124 Burwaye, Clement, of Foxley, husbandman 2
4071629 2050148 2050148 defendant Burwell Clement yeoman 591124 591124 Burwell, Clement, of Foxley, yeoman 0
4079268 2052887 2052887 defendant Sheringham Humphrey singleman 591124 591124 Sheringham, Humphrey, of Foxley, butcher, singleman 1
4081602 2053724 2053724 defendant Davye Ralph cooper 591124 591124 Davye, Ralph, of Foxley, cooper 1
4089987 2056701 2056701 defendant Bygott William   591124 591124 Bygott, William, of Foxley, mason 0
4139090 2074347 2074347 defendant Lucas John butcher 591124 591124 Lucas, John, of Foxley, butcher 3
4149125 2077819 2077819 defendant Modye John gent 591124 591124 Modye, John, of Foxley, gent 0
4158207 2080940 2080940 defendant Lucas John butcher 591124 591124 Lucas, John, of Foxley, butcher 0
4159546 2081407 2081407 defendant Webbe John yeoman 591124 591124 Webbe, John, of Foxley, yeoman 0
4159641 2081440 2081440 defendant Webbe John yeoman 591124 591124 Webbe, John, of Foxley, yeoman 0
4168807 2084581 2084581 defendant Burwey Clement cooper 591124 591124 Burwey, Clement, of Foxley, cooper 0
4173471 2086178 2086178 defendant Sheryngham Humphrey yeoman 591124 591124 Sheryngham, Humphrey, of Foxley, yeoman 1
4195888 2094116 2094116 defendant Walker Thomas husbandman 591124 591124 Walker, Thomas, of Foxley, husbandman 2
4196802 2094430 2094430 defendant Sheringham Humphrey yeoman 591124 591124 Sheringham, Humphrey, of Foxley, yeoman 1
4213976 2100411 2100411 defendant Cooke Thomas husbandman 591124 591124 Cooke, Thomas, of Foxley, husbandman 1
4222414 2103332 2103332 defendant Hogen Thomas yeoman 591124 591124 Hogen, Thomas, of Foxley, yeoman 0
4222663 2103418 2103418 defendant Hyve Robert husbandman 591124 591124 Hyve, Robert, of Foxley, husbandman 0
4222664 2103418 2103418 defendant Beales George husbandman 591124 591124 Beales, George, of Foxley, husbandman 1
4222666 2103418 2103418 defendant Porter John yeoman 591124 591124 Porter, John, of Foxley, yeoman 3
4235047 2107810 2107810 defendant Paynter Thomas yeoman 591124 591124 Paynter, Thomas, of Foxley, yeoman 0
4235114 2107838 2107838 defendant Chete alas Foxley Francis gent 591124 591124 Chete alas Foxley, Francis, of Foxley, gent 0
4235116 2107839 2107839 defendant Chyles Robert yeoman 591124 591124 Chyles, Robert, of Foxley, yeoman 0
4235223 2107880 2107880 defendant Cheate alias Foxley Francis gent 591124 591124 Cheate alias Foxley, Francis, of Foxley, gent 0
4235224 2107880 2107880 defendant Paynter Thomas yeoman 591124 591124 Paynter, Thomas, of Foxley, yeoman 1
4235225 2107880 2107880 defendant Keeble Simon miller 591124 591124 Keeble, Simon, of Foxley, miller 2
4235226 2107880 2107880 defendant Chyles Robert yeoman 591124 591124 Chyles, Robert, of Foxley, yeoman 3
4235227 2107880 2107880 defendant Elkynes Richard husbandman 591124 591124 Elkynes, Richard, of Foxley, husbandman 4
4240612 2109843 2109843 defendant Cock Thomas husbandman 591124 591124 Cock, Thomas, of Foxley, husbandman 1
4240617 2109844 2109844 defendant Cock Thomas husbandman 591124 591124 Cock, Thomas, of Foxley, husbandman 1
4247910 2112284 2112284 defendant Hogen Thomas yeoman 591124 591124 Hogen, Thomas, of Foxley, yeoman 0
4254198 2114401 2114401 defendant Gyles Robert yeoman 591124 591124 Gyles, Robert, of Foxley, yeoman 0
4254202 2114403 2114403 defendant Poynter Thomas yeoman 591124 591124 Poynter, Thomas, of Foxley, yeoman 0
4254545 2114509 2114509 defendant Cheate alias Foxley Francis gent 591124 591124 Cheate alias Foxley, Francis, of Foxley , gent 0
4254546 2114509 2114509 defendant Paynter Thomas yeoman 591124 591124 Paynter, Thomas, of Foxley, yeoman 1
4254547 2114509 2114509 defendant Keble Simon miller 591124 591124 Keble, Simon, of Foxley, miller 2
4254548 2114509 2114509 defendant Chiles Robert yeoman 591124 591124 Chiles, Robert, of Foxley, yeoman 3
4254549 2114509 2114509 defendant Elkyns Richard husbandman 591124 591124 Elkyns, Richard, of Foxley, husbandman 4
4264260 2117693 2117693 defendant Sheryngham Humphrey butcher 591124 591124 Sheryngham, Humphrey, of Foxley, butcher 2
4275259 2121282 2121282 defendant Wanwright Richard yeoman 591124 591124 Wanwright, Richard, of Foxley, yeoman 3
4277260 2121977 2121977 defendant Horte Robert yeoman 591124 591124 Horte, Robert, of Foxley, yeoman 0
4286469 2125202 2125202 defendant Waynewright Richard yeoman 591124 591124 Waynewright, Richard, of Foxley, yeoman 1
4287414 2125549 2125549 defendant Stallenborough John carpenter 591124 591124 Stallenborough, John, of Foxley, carpenter 3
4290907 2126806 2126806 defendant Croche John yeoman 591124 591124 Croche, John, of Foxley, or of Hackford, yeoman 1
4326215 2139134 2139134 defendant Crotche John yeoman 591124 591124 Crotche, John, of Foxley, yeoman 0
4332731 2141230 2141230 defendant Sheringham Humphrey yeoman 591124 591124 Sheringham, Humphrey, of Foxley, yeoman 3
4345180 2145590 2145590 defendant Waynwright Richard yeoman 591124 591124 Waynwright, Richard, of Foxley, yeoman 1
4345181 2145590 2145590 defendant Hawes Stephen yeoman 591124 591124 Hawes, Stephen, of Foxley, yeoman 2
4352991 2148276 2148276 defendant Dallymond John husbandman 591124 591124 Dallymond, John, of Foxley, husbandman 1
4353620 2148487 2148487 defendant Stillamburgh John carpenter 591124 591124 Stillamburgh, John, of Foxley, carpenter 3
4356759 2149592 2149592 defendant Burwaye Humphrey weaver 591124 591124 Burwaye, Humphrey, of Foxley, weaver 2
4358695 2150278 2150278 defendant Sparrowe Richard yeoman 591124 591124 Sparrowe, Richard, of Foxley, yeoman 0
4358696 2150278 2150278 defendant Sparrowe Robert yeoman 591124 591124 Sparrowe, Robert, of Foxley, yeoman 1
4383737 2159270 2159270 defendant Waynewright Richard yeoman 591124 591124 Waynewright, Richard, of Foxley, yeoman 0
4386896 2160286 2160286 defendant Wanewright Richard yeoman 591124 591124 Wanewright, Richard, of Foxley, yeoman 0
4399093 2164280 2164280 defendant Burware Clement yeoman 591124 591124 Burware, Clement, of Foxley, yeoman 0
4399094 2164280 2164280 defendant Burware Humphrey yeoman 591124 591124 Burware, Humphrey, of Foxley, yeoman 1
4407431 2167047 2167047 defendant Stillenburth or Stillenburghe John carpenter 591124 591124 Stillenburth or Stillenburghe, John, of Foxley, carpenter 3
4409075 2167640 2167640 defendant Wanwright Richard yeoman 591124 591124 Wanwright, Richard, of Foxley, yeoman 2
4657090 2248112 2248112 defendant Balle William tiler 591124 591124 Balle, William, of Foxley, tiler 0
4820263 2302407 2302407 defendant Walssh Ralph clerk 591124 591124 Walssh, Ralph, of Foxley, clerk 0
4824077 2303605 2303605 defendant Walsshe Ralph   591124 591124 Walsshe, Ralph, of Foxley, parson 0
4922992 2333610 2333610 defendant Berkeley John husbandman 591124 591124 Berkeley, John, of Foxley, husbandman 1
5027617 2364953 2364953 defendant Muntegom William husbandman 591124 591124 Muntegom, William, of Foxley, husbandman 1
5084793 2381957 2381957 plaintiff Glottes John   591124 591124 Glottes, John, of Foxley 0
5219633 2421476 2421476 defendant Baymond John yeoman 591124 591124 Baymond, John, of Foxley, yeoman 1
5268536 2435916 2435916 defendant Hancokkys (illegible) husbandman 591124 591124 Hancokkys, ---, of Foxley, husbandman 8
5277258 2438427 2438427 defendant Chete Thomas gent 591124 591124 Chete, Thomas, of Foxley, gent 0
5297569 2444295 2444295 defendant Chete Thomas gent 591124 591124 Chete, Thomas, of Foxley, gent 0
5332017 2454651 2454651 defendant Thomas John yeoman 591124 591124 Thomas, John, of Foxley, yeoman 0
5339363 2456880 2456880 defendant Thomas John yeoman 591124 591124 Thomas, John, of Foxley, yeoman 0
5358049 2462585 2462585 defendant Sadde alias Kempe Hugh husbandman 591124 591124 Sadde alias Kempe, Hugh, of Foxley, or of Baldeswell, husbandman 1
5359832 2463115 2463115 defendant Baymond John husbandman 591124 591124 Baymond, John, of Foxley, husbandman 1
5543608 2518106 2518106 defendant Franklyng John husbandman 591124 591124 Franklyng, John, of Foxley, husbandman 0
5581184 2529182 2529182 defendant Pynson Nicholas husbandman 591124 591124 Pynson, Nicholas, of Foxley, husbandman 2
5585173 2530431 2530431 defendant Brokeman Aldelun husbandman 591124 591124 Brokeman, Aldelun, of Foxley, husbandman 0
5591083 2532189 2532189 defendant Horte Robert husbandman 591124 591124 Horte, Robert, of Foxley, husbandman 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);