names

162 rows where place_id = 603520

✎ 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
3654817 1911766 1911766 defendant Hampton Richard husbandman 603520 603520 Hampton, Richard, of Atherston, husbandman 0
3654990 1911823 1911823 defendant Hampton Richard husbandman 603520 603520 Hampton, Richard, of Atherston, husbandman 0
3711664 1929960 1929960 defendant Sutton John husbandman 603520 603520 Sutton, John, of Atherston, husbandman 0
3720056 1932548 1932548 plaintiff Hochynson alias Notyngham John   603520 603520 Hochynson alias Notyngham, John, of Atherston 0
3725639 1934308 1934308 defendant Edwardys Thomas shoemaker 603520 603520 Edwardys, Thomas, of Atherston, shoemaker 0
3725640 1934308 1934308 defendant Edward Richard shoemaker 603520 603520 Edward, Richard, of Atherston, shoemaker 1
3725641 1934308 1934308 defendant Hylley Robert shoemaker 603520 603520 Hylley, Robert, of Atherston, shoemaker 2
3756848 1944115 1944115 defendant Wode Thomas tanner 603520 603520 Wode, Thomas, of Atherston, tanner 0
3756849 1944115 1944115 defendant Wode Joan widow 603520 603520 Wode, Joan, of Atherston, widow 1
3756850 1944115 1944115 defendant Repyngton William weaver 603520 603520 Repyngton, William, of Atherston, weaver 2
3795288 1956394 1956394 defendant Grene Robert yeoman 603520 603520 Grene, Robert, of Atherston, yeoman 0
3807887 1960353 1960353 defendant Gruesby or Ernesby John butcher 603520 603520 Gruesby or Ernesby, John, of Atherston, butcher 0
3807888 1960353 1960353 defendant Gruesby or Ernesby Richard butcher 603520 603520 Gruesby or Ernesby, Richard, of Atherston, butcher 1
3851110 1973936 1973936 defendant Wall Ralph collier 603520 603520 Wall, Ralph, of Atherston, collier 0
3851115 1973936 1973936 defendant Baily John   603520 603520 Baily, John, of Atherston. Husbandman 5
3851117 1973936 1973936 defendant Bowet Robert collier 603520 603520 Bowet, Robert, of Atherston, collier 7
3903519 1991404 1991404 defendant Hochynson John mercer 603520 603520 Hochynson, John, of Atherston, mercer 0
3908572 1993165 1993165 defendant Hynkes alias Henoke Robert smith 603520 603520 Hynkes alias Henoke, Robert, of Atherston, smith 0
3911421 1994135 1994135 defendant Rydley Thomas smith 603520 603520 Rydley, Thomas, of Atherston, smith 0
3911422 1994135 1994135 defendant Greves John wheeler 603520 603520 Greves, John, of Atherston, wheeler 1
3927252 1999451 1999451 defendant Furner John draper 603520 603520 Furner, John, of Atherston, draper 0
3942802 2004596 2004596 defendant Hobemyns William glover 603520 603520 Hobemyns, William, of Atherston, glover 0
3945965 2005667 2005667 defendant Grene James yeoman 603520 603520 Grene, James, of Atherston, yeoman 0
3957896 2009824 2009824 plaintiff Pynchebecke Christopher husbandman 603520 603520 Pynchebecke, Christopher, of Atherston, husbandman 0
3958042 2009880 2009880 defendant Abell Hugh smith 603520 603520 Abell, Hugh, of Atherston, smith 0
3967608 2013305 2013305 defendant Abell Hugh yeoman or smith 603520 603520 Abell, Hugh, of Atherston, yeoman or smith 0
3972945 2015112 2015112 plaintiff Goodale Richard glover 603520 603520 Goodale, Richard, of Atherston, glover 0
3972946 2015112 2015112 defendant Bruche James gent 603520 603520 Bruche, James, of Atherston, gent 0
3972947 2015112 2015112 defendant Hyll Robert gent 603520 603520 Hyll, Robert, of Atherston, gent 1
3972948 2015112 2015112 defendant Holte Robert gent 603520 603520 Holte, Robert, of Atherston, gent 2
4004497 2026383 2026383 defendant Abell Francis fletcher 603520 603520 Abell, Francis, of Atherston, fletcher 0
4021228 2032312 2032312 defendant Wilson Thomas yeoman 603520 603520 Wilson, Thomas, of Atherston, yeoman 0
4055879 2044484 2044484 defendant Drayton Edward butcher 603520 603520 Drayton, Edward, of Atherston, butcher 0
4055880 2044484 2044484 defendant Dreyton John butcher 603520 603520 Dreyton, John, of Atherston, butcher 1
4056197 2044603 2044603 defendant Hotchkyns Christopher husbandman 603520 603520 Hotchkyns, Christopher, of Atherston, husbandman, son of William Hotchkyns, of Atherston, husbandman 0
4056201 2044604 2044604 defendant Hodgekyns William husbandman 603520 603520 Hodgekyns, William, of Atherston, husbandman 0
4056205 2044605 2044605 defendant Pynchbecke Christopher husbandman 603520 603520 Pynchbecke, Christopher, of Atherston, husbandman 0
4057522 2045067 2045067 defendant Hodgekyns William yeoman 603520 603520 Hodgekyns, William, of Atherston, yeoman 0
4074394 2051146 2051146 defendant Bandycott Joyce widow 603520 603520 Bandycott, Joyce, of Atherston, widow 0
4076982 2052051 2052051 defendant Trayton Christopher vintner 603520 603520 Trayton, Christopher, of Atherston, vintner 1
4084556 2054752 2054752 defendant Fysshe Edward tailor 603520 603520 Fysshe, Edward, of Atherston, tailor 0
4084557 2054752 2054752 defendant Hodgkynson Christopher glover 603520 603520 Hodgkynson, Christopher, of Atherston, glover 1
4084559 2054752 2054752 defendant Hodgkynson William glover 603520 603520 Hodgkynson, William, of Atherston, glover 3
4111943 2064521 2064521 defendant Walker Robert laborer 603520 603520 Walker, Robert, of Atherston, laborer 1
4162779 2082539 2082539 defendant Walker William yeoman 603520 603520 Walker, William, of Atherston, yeoman 0
4184238 2089984 2089984 defendant Cox William yeoman 603520 603520 Cox, William, of Atherston, yeoman 0
4266915 2118578 2118578 defendant Hill Robert gent 603520 603520 Hill, Robert, of Atherston, gent 0
4332748 2141235 2141235 defendant Turnor John gent 603520 603520 Turnor, John, of Atherston, gent 1
4332823 2141259 2141259 defendant Turnor Thomas gent 603520 603520 Turnor, Thomas, of Atherston, gent 2
4365343 2152669 2152669 defendant Drayton Edward butcher 603520 603520 Drayton, Edward, of Atherston, butcher 0
4365344 2152669 2152669 defendant Sutton Robert butcher 603520 603520 Sutton, Robert, of Atherston, butcher 1
4366863 2153197 2153197 defendant Hill Robert gent 603520 603520 Hill, Robert, of Atherston, gent 0
4366871 2153201 2153201 defendant Rampton Thomas yeoman 603520 603520 Rampton, Thomas, of Atherston, yeoman 0
4394453 2162742 2162742 defendant Holmes Thomas yeoman 603520 603520 Holmes, Thomas, of Atherston, yeoman 0
4426885 2173230 2173230 defendant Holtoo Robert   603520 603520 Holtoo, Robert, of Atherston 1
4440952 2182090 2182090 defendant Purs Richard   603520 603520 Purs, Richard, of Atherston 10
4446355 2183777 2183777 defendant Colier Robert   603520 603520 Colier, Robert, of Atherston 2
4484033 2195698 2195698 defendant White Thomas le   603520 603520 White, Thomas le, of Atherston 2
4484034 2195698 2195698 defendant Taillour Robert   603520 603520 Taillour, Robert, of Atherston 3
4536731 2211763 2211763 defendant Hebbe William   603520 603520 Hebbe, William, of Atherston 5
4539007 2212468 2212468 defendant Reve Geoffrey   603520 603520 Reve, Geoffrey, of Atherston 0
4546217 2214762 2214762 defendant Aylesward John   603520 603520 Aylesward, John, of Atherston 2
4556980 2218114 2218114 plaintiff Kendale John   603520 603520 Kendale, John, of Atherston 0
4559783 2219014 2219014 defendant Fale Richard   603520 603520 Fale, Richard, of Atherston 2
4569033 2221902 2221902 defendant Fale Richard   603520 603520 Fale, Richard, of Atherston 0
4569410 2222023 2222023 defendant Stratton John   603520 603520 Stratton, John, of Atherston 0
4569696 2222105 2222105 defendant Stretton John   603520 603520 Stretton, John, of Atherston 0
4666876 2255368 2255368 defendant Forster Simon yeoman 603520 603520 Forster, Simon, of Atherston, yeoman 0
4668575 2255880 2255880 defendant Reynald Robert husbandman 603520 603520 Reynald, Robert, of Atherston, husbandman 0
4680666 2259567 2259567 defendant Hurley Robert laborer 603520 603520 Hurley, Robert, of Atherston, laborer 0
4680735 2259592 2259592 defendant Lecok Richard weaver 603520 603520 Lecok, Richard, of Atherston, weaver 0
4680736 2259592 2259592 defendant Lecok John weaver 603520 603520 Lecok, John, of Atherston, weaver 1
4706315 2267357 2267357 defendant Bykenhill John   603520 603520 Bykenhill, John, of Atherston, shoe maker 0
4720333 2271699 2271699 defendant Meye William tailor 603520 603520 Meye, William, of Atherston, tailor 0
4720334 2271699 2271699 defendant Huggerdyn Roger weaver 603520 603520 Huggerdyn, Roger, of Atherston, weaver 1
4720335 2271699 2271699 defendant Bedenhale Thomas weaver 603520 603520 Bedenhale, Thomas, of Atherston, weaver 2
4722558 2272369 2272369 defendant Bedenhale William tailor 603520 603520 Bedenhale, William, of Atherston, tailor 3
4732336 2275290 2275290 defendant Leycok John weaver 603520 603520 Leycok, John, of Atherston, weaver 2
4780513 2289902 2289902 defendant Cook Thomas   603520 603520 Cook, Thomas, of Atherston, mason 0
4939534 2338751 2338751 defendant Salby John husbandman 603520 603520 Salby, John, of Atherston, husbandman 1
4940299 2338987 2338987 defendant Barbour John yeoman 603520 603520 Barbour, John, of Atherston, yeoman 5
4987451 2353203 2353203 defendant Milward Thomas   603520 603520 Milward, Thomas, of Atherston, mill ward 0
4991464 2354332 2354332 defendant Draper Clement yeoman 603520 603520 Draper, Clement, of Atherston, yeoman 0
5052588 2372368 2372368 defendant Draper Clement yeoman 603520 603520 Draper, Clement, of Atherston, yeoman 0
5059105 2374289 2374289 plaintiff Draper Clement   603520 603520 Draper, Clement, of Atherston 0
5059107 2374290 2374290 plaintiff Draper Clement   603520 603520 Draper, Clement, of Atherston 0
5155955 2402899 2402899 defendant Vale William yeoman 603520 603520 Vale, William, of Atherston, yeoman 0
5215229 2420180 2420180 defendant Barkby William yeoman 603520 603520 Barkby, William, of Atherston, yeoman 2
5279112 2438998 2438998 defendant Chapman Richard chapman 603520 603520 Chapman, Richard, of Atherston, chapman 1
5279113 2438998 2438998 defendant Mychell William tiler 603520 603520 Mychell, William, of Atherston, tiler 2
5279114 2438998 2438998 defendant Reynold Joan widow 603520 603520 Reynold, Joan, of Atherston, widow 3
5279115 2438998 2438998 defendant Mychell Henry yeoman 603520 603520 Mychell, Henry, of Atherston, yeoman 4
5279116 2438998 2438998 defendant Vale Ralph barker 603520 603520 Vale, Ralph, of Atherston, barker 5
5279117 2438998 2438998 defendant Drayton John butcher 603520 603520 Drayton, John, of Atherston, butcher 6
5279118 2438998 2438998 defendant Nevewe Nicholas barker 603520 603520 Nevewe, Nicholas, of Atherston, barker 7
5279119 2438998 2438998 defendant Bonde Thomas baker 603520 603520 Bonde, Thomas, of Atherston, baker 8
5279121 2438998 2438998 defendant Cowehoppe Robert tailor 603520 603520 Cowehoppe, Robert, of Atherston, tailor 10
5279122 2438998 2438998 defendant Nytynghale John shoemaker 603520 603520 Nytynghale, John, of Atherston, shoemaker 11
5279141 2439000 2439000 defendant Vale Ralph barker 603520 603520 Vale, Ralph, of Atherston, barker 1
5279142 2439000 2439000 defendant Pyper John chandler 603520 603520 Pyper, John, of Atherston, chandler 2

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