names

341 rows where place_id = 586207

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588169 1863953 1863953 defendant Serell William smith 586207 586207 Serell, William, of basyngstoke, smith 0
3590134 1864551 1864551 defendant Janyn Edward mercer 586207 586207 Janyn, Edward, of Basyngstoke, mercer 0
3590136 1864552 1864552 defendant Jenyn Edward mercer 586207 586207 Jenyn, Edward, of Basyngstoke, mercer 0
3600371 1867761 1867761 defendant Warley Thomas hardwareman 586207 586207 Warley, Thomas, of Basyngstoke, hardwareman 0
3608911 1870445 1870445 defendant Talbote John (legal representative) 586207 586207 Talbote, John, of Basyngstoke, gent, executrix of 0
3622336 1874521 1874521 defendant Cordull John tanner 586207 586207 Cordull, John, of Basyngstoke, tanner 6
3622512 1874578 1874578 defendant Warley Thomas hardwareman 586207 586207 Warley, Thomas, of Basyngstoke, hardwareman 0
3622513 1874578 1874578 defendant Clerk John yeoman 586207 586207 Clerk, John, of Basyngstoke, yeoman 1
3637221 1906442 1906442 defendant A Kent John innholder 586207 586207 A Kent, John, of Basyngstoke, innholder 0
3648662 1909968 1909968 defendant Potton Robert yeoman 586207 586207 Potton, Robert, of Basyngstoke, yeoman 0
3655911 1912102 1912102 defendant Stoker Robert clothier 586207 586207 Stoker, Robert, of Basyngstoke, clothier 2
3655912 1912102 1912102 defendant Rumager John cordwainer & custodian of the goods & ornaments of Basingstoke parish church 586207 586207 Rumager, John, of Basyngstoke, cordwainer & custodian of the goods & ornaments of Basingstoke parish church 3
3655919 1912103 1912103 defendant Stoker Robert clothier 586207 586207 Stoker, Robert, of Basyngstoke, clothier 2
3655920 1912103 1912103 defendant Rumanger John   586207 586207 Rumanger, John, of Basyngstoke, cord wainer, custodian of church goods & ornaments 3
3657250 1912530 1912530 defendant Sharp Simon   586207 586207 Sharp, Simon, of Basyngstoke, inn holder 0
3658276 1912845 1912845 defendant Hore John laborer 586207 586207 Hore, John, of Basyngstoke, laborer 1
3658277 1912845 1912845 defendant Cotered Thomas laborer 586207 586207 Cotered, Thomas, of Basyngstoke, laborer 2
3658278 1912845 1912845 defendant Hopson Richard husbandman 586207 586207 Hopson, Richard, of Basyngstoke, husbandman 3
3658280 1912845 1912845 defendant Tanner Andrew husbandman 586207 586207 Tanner, Andrew, of Basyngstoke, husbandman 5
3667608 1915812 1915812 defendant Sheperd Henry dyer 586207 586207 Sheperd, Henry, of Basyngstoke, dyer 0
3670030 1916573 1916573 plaintiff Bowyar John   586207 586207 Bowyar, John, of Basyngstoke 0
3670721 1916802 1916802 defendant Gilbard William   586207 586207 Gilbard, William, of Basyngstoke 0
3679572 1919679 1919679 defendant Alye Henry clothier 586207 586207 Alye, Henry, of Basyngstoke, clothier 0
3679914 1919783 1919783 defendant Nores William esq 586207 586207 Nores, William, of Basyngstoke, esq 0
3695245 1924730 1924730 defendant Alye Henry clothier 586207 586207 Alye, Henry, of Basyngstoke, clothier 0
3701122 1926598 1926598 defendant Kent John (legal representative) 586207 586207 Kent, John, of Basyngstoke, innholder, executrix of 2
3746717 1940888 1940888 plaintiff Cowselet John   586207 586207 Cowselet, John, of Basyngstoke 0
3775303 1950014 1950014 defendant Walter John yeoman 586207 586207 Walter, John, of Basyngstoke, yeoman 0
3776658 1950446 1950446 defendant Kent Richard innholder 586207 586207 (Kent, Richard, of Basyngstoke, innholder 1
3776659 1950446 1950446 defendant Kent Geoffrey clerk 586207 586207 Kent, Geoffrey, of Basyngstoke, clerk 2
3782809 1952370 1952370 defendant Kent Richard innholder 586207 586207 Kent, Richard, of Basyngstoke, innholder 1
3792195 1955411 1955411 defendant Bowyer John yeoman 586207 586207 Bowyer, John, of Basyngstoke, yeoman 0
3795566 1956496 1956496 defendant Hanyton Richard fuller 586207 586207 Hanyton, Richard, of Basyngstoke, fuller 0
3804120 1959215 1959215 defendant Bye John clothier 586207 586207 Bye, John, of Basyngstoke, clothier 0
3804661 1959398 1959398 defendant Jenyns Edward mercer 586207 586207 Jenyns, Edward, of Basyngstoke, mercer 0
3804961 1959495 1959495 defendant Bye Gilbert clothman 586207 586207 Bye, Gilbert, of Basyngstoke, clothman 2
3807350 1960203 1960203 defendant Cordall Henry tailor 586207 586207 Cordall, Henry, of Basyngstoke, tailor 0
3807352 1960204 1960204 defendant Hoskyns Richard tailor 586207 586207 Hoskyns, Richard, of Basyngstoke, tailor 0
3807353 1960204 1960204 defendant Feld John fuller 586207 586207 Feld, John, of Basyngstoke, fuller 1
3809509 1960856 1960856 defendant Ryther John clothier 586207 586207 Ryther, John, of Basyngstoke, clothier 0
3817932 1963528 1963528 defendant Ryder John clothier 586207 586207 Ryder, John, of Basyngstoke, clothier 0
3822699 1965001 1965001 defendant Ryder John clothier 586207 586207 Ryder, John, of Basyngstoke, clothier 0
3827132 1966348 1966348 defendant Kent John (legal representative) 586207 586207 Kent, John, of Basyngstoke, executors of 0
3827134 1966348 1966348 defendant Kent Richard innholder 586207 586207 Kent, Richard, of Basyngstoke, innholder 2
3831835 1967853 1967853 defendant Swayne John butcher 586207 586207 Swayne, John, of Basyngstoke, butcher 0
3837284 1969568 1969568 defendant Hanyngton Richard clothier 586207 586207 Hanyngton, Richard, of Basyngstoke, clothier 0
3837286 1969569 1969569 defendant Perman John sherman 586207 586207 Perman, John, of Basyngstoke, sherman 0
3838547 1969980 1969980 defendant Hannyngton William clothmaker 586207 586207 Hannyngton, William, of Basyngstoke, clothmaker 1
3838550 1969981 1969981 defendant Hannyngton William clothmaker 586207 586207 Hannyngton, William, of Basyngstoke, clothmaker 1
3841357 1970874 1970874 defendant Stokker Robert clothmaker 586207 586207 Stokker, Robert, of Basyngstoke, clothmaker 0
3885899 1985540 1985540 defendant Stocker Thomas clothier 586207 586207 Stocker, Thomas, of Basyngstoke, clothier 1
3893295 1987987 1987987 defendant Belchamber William mercer 586207 586207 Belchamber, William, of Basyngstoke, mercer 0
3894823 1988474 1988474 defendant Stoker John fuller 586207 586207 Stoker, John, of Basyngstoke, fuller 0
3894824 1988474 1988474 defendant Stocker Robert fuller 586207 586207 Stocker, Robert, of Basyngstoke, fuller 1
3896334 1988986 1988986 defendant Hanyton Richard fuller 586207 586207 Hanyton, Richard, of Basyngstoke, fuller 0
3899760 1990135 1990135 defendant Stokker Thomas clothier 586207 586207 Stokker, Thomas, of Basyngstoke, clothier 1
3909942 1993631 1993631 defendant Stocker Richard fuller 586207 586207 Stocker, Richard, of Basyngstoke, fuller 0
3909943 1993631 1993631 defendant Stocker John fuller 586207 586207 Stocker, John, of Basyngstoke, fuller 1
3909944 1993631 1993631 defendant Lypscombe John butcher 586207 586207 Lypscombe, John, of Basyngstoke, butcher 2
3915691 1995622 1995622 plaintiff Dennett Alexander yeoman 586207 586207 Dennett, Alexander, of Basyngstoke, yeoman 0
3924188 1998400 1998400 defendant Berton William husbandman 586207 586207 Berton, William, of Basyngstoke, husbandman 0
3924189 1998400 1998400 defendant Bysshope William husbandman 586207 586207 Bysshope, William, of Basyngstoke, husbandman 1
3924190 1998400 1998400 defendant Hamonde John husbandman 586207 586207 Hamonde, John, of Basyngstoke, husbandman 2
3924191 1998400 1998400 defendant Dasche Richard husbandman 586207 586207 Dasche, Richard, of Basyngstoke, husbandman 3
3930888 2000670 2000670 defendant Kyng Robert (legal representative) 586207 586207 Kyng, Robert, of Basyngstoke, executrix of 4
3930897 2000672 2000672 defendant Holleway Robert beer brewer 586207 586207 Holleway, Robert, of Basyngstoke, beer brewer 4
3930898 2000672 2000672 defendant Kyng Agnes widow 586207 586207 Kyng, Agnes, of Basyngstoke, widow 5
3957334 2009627 2009627 defendant Hawtrell Peter carpenter 586207 586207 Hawtrell, Peter, of Basyngstoke, carpenter 0
3960230 2010678 2010678 plaintiff Stocker Gilbert (legal representative) 586207 586207 Stocker, Gilbert, of Basyngstoke, clothier, executors of 0
3960236 2010679 2010679 plaintiff Stocker Gilbert (legal representative) 586207 586207 Stocker, Gilbert, of Basyngstoke, clothier, executors of 0
3965659 2012604 2012604 plaintiff Belchanber Alexander yeoman 586207 586207 Belchanber, Alexander, of Basyngstoke, yeoman 0
3974993 2015816 2015816 plaintiff Holloway Roland mercer 586207 586207 Holloway, Roland, of Basyngstoke, mercer 0
4135031 2072852 2072852 defendant Lee John, junior   586207 586207 Lee, John, junior, of Basyngstoke, silk weaver 1
4135034 2072853 2072853 defendant Lee John   586207 586207 Lee, John, of Basyngstoke, silk weaver 1
4199094 2095239 2095239 defendant Hopkyns John innholder 586207 586207 Hopkyns, John, of Basyngstoke, innholder 0
4199095 2095239 2095239 defendant Pettye John clothier 586207 586207 Pettye, John, of Basyngstoke, clothier 1
4220211 2102572 2102572 defendant Scudamore Thomas esq 586207 586207 Scudamore, Thomas, of Basyngstoke, or of Howton, Herefs, esq 0
4221799 2103120 2103120 defendant Carter Philip clothier 586207 586207 Carter, Philip, of Basyngstoke, clothier 0
4222434 2103339 2103339 defendant Jower William yeoman 586207 586207 Jower, William, of Basyngstoke, or of Seale, Surrey, yeoman 0
4234420 2107580 2107580 defendant Phillips Augustine clothier 586207 586207 Phillips, Augustine, of Basyngstoke, clothier 0
4439468 2181607 2181607 defendant Farl Richard   586207 586207 Farl, Richard, of Basyngstoke 0
4439470 2181608 2181608 defendant Farl Richard   586207 586207 Farl, Richard, of Basyngstoke 0
4443010 2182776 2182776 defendant atte Nashe John   586207 586207 atte Nashe, John, of Basyngstoke 0
4446541 2183829 2183829 defendant Edelyne Richard   586207 586207 Edelyne, Richard, of Basyngstoke 0
4447245 2184046 2184046 defendant Trewelay Thomas   586207 586207 Trewelay, Thomas, of Basyngstoke 5
4447254 2184047 2184047 defendant Trewelay Thomas   586207 586207 Trewelay, Thomas, of Basyngstoke 5
4449809 2184890 2184890 plaintiff Gregory William   586207 586207 Gregory, William, of Basyngstoke 0
4449811 2184890 2184890 defendant Calewe Simon le   586207 586207 Calewe, Simon le, of Basyngstoke 1
4463380 2189237 2189237 defendant Aume Robert   586207 586207 Aume, Robert, of Basyngstoke 0
4464028 2189419 2189419 defendant Rede Roger   586207 586207 Rede, Roger, of Basyngstoke 1
4464031 2189420 2189420 defendant Rede Roger   586207 586207 Rede, Roger, of Basyngstoke 1
4464034 2189421 2189421 defendant Rede Roger   586207 586207 Rede, Roger, of Basyngstoke 1
4479131 2194131 2194131 plaintiff Hosteler Richard   586207 586207 Hosteler, Richard, of Basyngstoke 0
4490545 2197737 2197737 defendant Hill John   586207 586207 Hill, John, of Basyngstoke 0
4493364 2198628 2198628 defendant Parker John   586207 586207 Parker, John, of Basyngstoke 0
4496470 2199571 2199571 defendant Parker John   586207 586207 Parker, John, of Basyngstoke 3
4531525 2210140 2210140 plaintiff Pepirwhit John   586207 586207 Pepirwhit, John, of Basyngstoke 0
4539741 2212689 2212689 defendant Tauke John   586207 586207 Tauke, John, of Basyngstoke 4
4539749 2212690 2212690 defendant Tauke John   586207 586207 Tauke, John, of Basyngstoke 4
4541090 2213119 2213119 defendant Shepherd Henry   586207 586207 Shepherd, Henry, of Basyngstoke 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);