names

758 rows where place_id = 586696

✎ 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
3589391 1864321 1864321 defendant Been John tailor 586696 586696 Been, John, of Staunford, tailor 1
3589392 1864321 1864321 defendant Fauconer John hosier 586696 586696 Fauconer, John, of Staunford, hosier 2
3592311 1865209 1865209 defendant Parnell Thomas chapman 586696 586696 Parnell, Thomas, of Staunford, chapman 0
3592312 1865209 1865209 defendant Freman William husbandman 586696 586696 Freman, William, of Staunford, husbandman 1
3593065 1865458 1865458 plaintiff Spenser William   586696 586696 Spenser, William, of Staunford 1
3597048 1866700 1866700 defendant Billesdon Nicholas dyer 586696 586696 Billesdon, Nicholas, of Staunford, dyer 0
3612645 1871593 1871593 defendant Ratclyff William yeoman 586696 586696 Ratclyff, William, of Staunford, yeoman 0
3635805 1905999 1905999 plaintiff Philip Thomas (legal representative) 586696 586696 Philip, Thomas, of Staunford, draper, executor of 0
3635807 1905999 1905999 defendant Wallebef Robert merchant 586696 586696 Wallebef, Robert, of Staunford, merchant 0
3635813 1906002 1906002 plaintiff Phyllyppe Thomas draper 586696 586696 Phyllyppe, Thomas, of Staunford, draper 0
3636616 1906244 1906244 defendant Wynter John mercer 586696 586696 Wynter, John, of Staunford, mercer 0
3636617 1906244 1906244 defendant Thomson George butcher 586696 586696 Thomson, George, of Staunford, butcher 1
3691560 1923518 1923518 defendant Hochyn Elizabeth widow 586696 586696 Hochyn, Elizabeth, of Staunford, widow 2
3709516 1929282 1929282 plaintiff Rankyll William   586696 586696 Rankyll, William, of Staunford 0
3727986 1935021 1935021 defendant Cob Reginald gent 586696 586696 Cob, Reginald, of Staunford, gent 1
3735314 1937278 1937278 plaintiff Hardgrave John esq 586696 586696 Hardgrave, John, of Staunford, esq 0
3735315 1937278 1937278 defendant Byllysby Nicholas mercer 586696 586696 Byllysby, Nicholas, of Staunford, mercer 0
3736841 1937777 1937777 defendant Halyday William barber 586696 586696 Halyday, William, of Staunford, barber 0
3746064 1940673 1940673 defendant Cecill David gent 586696 586696 Cecill, David, of Staunford, gent 0
3750360 1942032 1942032 plaintiff Ley John alderman and mercer 586696 586696 Ley, John, of Staunford, alderman and mercer 0
3761523 1945614 1945614 defendant Armestrong Thomas tanner 586696 586696 Armestrong, Thomas, of Staunford, tanner 0
3787025 1953738 1953738 defendant Cobbe Reginald baker 586696 586696 (Cobbe, Reginald, of Staunford, baker 1
3787026 1953738 1953738 defendant Byard Robert yeoman 586696 586696 Byard, Robert, of Staunford, yeoman 2
3795992 1956609 1956609 plaintiff Rayclyff William gent 586696 586696 Rayclyff, William, of Staunford, gent 2
3800332 1958021 1958021 defendant Thomson Robert slater 586696 586696 Thomson, Robert, of Staunford, slater 0
3810563 1961201 1961201 defendant Whytfeld Thomas husbandman 586696 586696 Whytfeld, Thomas, of Staunford, husbandman 2
3813845 1962242 1962242 plaintiff Fenton John fishmonger 586696 586696 Fenton, John, of Staunford, fishmonger 0
3849289 1973371 1973371 plaintiff Lee John (legal representative) 586696 586696 Lee, John, of Staunford, executor of 0
3886646 1985786 1985786 defendant Joynes Thomas yeoman 586696 586696 Joynes, Thomas, of Staunford, yeoman 0
3892839 1987853 1987853 defendant Raskell Christopher draper 586696 586696 Raskell, Christopher, of Staunford, draper 3
3922843 1997941 1997941 defendant Massee John laborer 586696 586696 Massee, John, of Staunford, laborer 1
3924068 1998360 1998360 defendant Croke Thomas yeoman 586696 586696 Croke, Thomas, of Staunford, yeoman 1
3924506 1998511 1998511 plaintiff Trygge Thomas   586696 586696 Trygge, Thomas, of Staunford 0
3924507 1998511 1998511 defendant Austen Ambrose husbandman 586696 586696 Austen, Ambrose, of Staunford, husbandman 0
3924508 1998511 1998511 defendant Everton Thomas shoemaker 586696 586696 Everton, Thomas, of Staunford, shoemaker 1
3924509 1998511 1998511 defendant Scotte Thomas shoemaker 586696 586696 Scotte, Thomas, of Staunford, shoemaker 2
3925061 1998698 1998698 plaintiff Watson Thomas tanner 586696 586696 Watson, Thomas, of Staunford, tanner 0
3925062 1998698 1998698 defendant Fornes John blacksmith 586696 586696 Fornes, John, of Staunford, blacksmith 0
3925063 1998699 1998699 plaintiff Watson Thomas tanner 586696 586696 Watson, Thomas, of Staunford, tanner 0
3925064 1998699 1998699 defendant Harrat Ralph innkeeper 586696 586696 Harrat, Ralph, of Staunford, innkeeper 0
4015439 2030218 2030218 defendant Thorneff or Thorness Francis gent 586696 586696 Thorneff or Thorness, Francis, of Staunford, gent 0
4015440 2030218 2030218 defendant Barnes John butcher 586696 586696 Barnes, John, of Staunford, butcher 1
4016125 2030464 2030464 defendant Fenton Margaret widow 586696 586696 Fenton, Margaret, of Staunford, widow 0
4038342 2038353 2038353 defendant Anderson John chapman 586696 586696 Anderson, John, of Staunford, chapman 2
4141234 2075093 2075093 defendant Allyn John yeoman 586696 586696 Allyn, John, of Staunford, yeoman 0
4156129 2080218 2080218 defendant Beale William yeoman 586696 586696 Beale, William, of Staunford, yeoman 1
4156130 2080218 2080218 defendant Wyles Nicholas   586696 586696 Wyles, Nicholas, of Staunford, woollen draoer 2
4227245 2105008 2105008 defendant Sheryffe John husbandman 586696 586696 Sheryffe, John, of Staunford, husbandman 0
4230599 2106198 2106198 defendant Sheriffe John husbandman 586696 586696 Sheriffe, John, of Staunford, husbandman 0
4231203 2106418 2106418 defendant Sheriffe John chapman 586696 586696 Sheriffe, John, of Staunford, chapman 0
4236005 2108168 2108168 defendant Coye John husbandman 586696 586696 Coye, John, of Staunford, husbandman 0
4236006 2108168 2108168 defendant Dickonson Richard vintner 586696 586696 Dickonson, Richard, of Staunford, baker, vintner 1
4236012 2108169 2108169 defendant Sheryff John mercer 586696 586696 Sheryff, John, of Staunford, mercer 2
4237401 2108675 2108675 defendant Allen John yeoman 586696 586696 Allen, John, of Staunford, yeoman 0
4237402 2108675 2108675 defendant Coye John husbandman 586696 586696 Coye, John, of Staunford, husbandman 1
4267200 2118669 2118669 defendant Marston Barnaby skinner 586696 586696 Marston, Barnaby, of Staunford, skinner 0
4275302 2121296 2121296 defendant Sheriffe John chapman 586696 586696 Sheriffe, John, of Staunford, chapman 0
4275303 2121296 2121296 defendant Baker Richard draper 586696 586696 Baker, Richard, of Staunford, draper 1
4275304 2121296 2121296 defendant Southwell Mathew baker 586696 586696 Southwell, Mathew, of Staunford, baker 2
4275442 2121347 2121347 defendant Beale William husbandman 586696 586696 Beale, William, of Staunford, husbandman 0
4281732 2123516 2123516 defendant Whatton Robert yeoman 586696 586696 Whatton, Robert, of Staunford, yeoman 0
4287279 2125508 2125508 defendant Harrison Henry weaver 586696 586696 Harrison, Henry, of Staunford, weaver 1
4287280 2125508 2125508 defendant Tayler John plumber 586696 586696 Tayler, John, of Staunford, plumber 2
4290999 2126846 2126846 defendant Baker Richard draper 586696 586696 Baker, Richard, of Staunford, draper 0
4301180 2130531 2130531 defendant Dicconson Richard yeoman 586696 586696 Dicconson, Richard, of Staunford, yeoman 0
4350645 2147476 2147476 defendant Faiercliff John gent 586696 586696 Faiercliff, John, of Staunford, gent 0
4350646 2147476 2147476 defendant Atkinson John butcher 586696 586696 Atkinson, John, of Staunford, butcher 1
4351591 2147795 2147795 defendant Allen John gent 586696 586696 Allen, John, of Staunford, gent 0
4353859 2148571 2148571 defendant Deane William gent 586696 586696 Deane, William, of Staunford, gent 0
4353861 2148572 2148572 defendant Deane William gent 586696 586696 Deane, William, of Staunford, gent 0
4354415 2148776 2148776 defendant Greenebery Elizabeth widow 586696 586696 Greenebery, Elizabeth, of Staunford, widow 1
4358412 2150175 2150175 defendant Carle John yeoman 586696 586696 Carle, John, of Staunford, yeoman 2
4358413 2150175 2150175 defendant Dicconson Richard innholder 586696 586696 Dicconson, Richard, of Staunford, innholder 3
4360085 2150770 2150770 defendant Leeffe John, senior butcher 586696 586696 Leeffe, John, senior, of Staunford, butcher 1
4362523 2151647 2151647 defendant Dicconson Richard vintner 586696 586696 Dicconson, Richard, of Staunford, vintner 0
4374651 2155997 2155997 defendant Atkynson John butcher 586696 586696 Atkynson, John, of Staunford, butcher 0
4377113 2156889 2156889 defendant Dent Richard tailor 586696 586696 Dent, Richard, of Staunford, tailor 0
4377114 2156889 2156889 defendant Hunman Seth tailor 586696 586696 Hunman, Seth, of Staunford, tailor 1
4381017 2158327 2158327 defendant Deane William gent 586696 586696 Deane, William, of Staunford, gent 0
4381737 2158571 2158571 defendant Tyming John shoemaker 586696 586696 Tyming, John, of Staunford, shoemaker 0
4420087 2171184 2171184 defendant Thistelton Thomas de   586696 586696 Thistelton, Thomas de, of Staunford 1
4420597 2171344 2171344 defendant Crofham John de dyer 586696 586696 Crofham, John de, of Staunford, dyer 6
4422117 2171789 2171789 defendant Tredefloure Hugh merchant 586696 586696 Tredefloure, Hugh, of Staunford, merchant 0
4422668 2171946 2171946 plaintiff Faderman William   586696 586696 Faderman, William, of Staunford, son of Henry 0
4426233 2173011 2173011 plaintiff Norfolk John de   586696 586696 Norfolk, John de, of Staunford 0
4426961 2173256 2173256 defendant Rippes John de   586696 586696 Rippes, John de, of Staunford 0
4427123 2173306 2173306 defendant Preston John de   586696 586696 Preston, John de, of Staunford 0
4427125 2173307 2173307 defendant Stavelere Roger le   586696 586696 Stavelere, Roger le, of Staunford 0
4428526 2173732 2173732 defendant Aldenborgh John de   586696 586696 Aldenborgh, John de, of Staunford 2
4430219 2174230 2174230 defendant Ferour John   586696 586696 Ferour, John, of Staunford 2
4432746 2174996 2174996 defendant Tredefloure Hugh merchant 586696 586696 Tredefloure, Hugh, of Staunford, merchant 0
4439009 2181495 2181495 defendant Wilcok-brother Apethorp John   586696 586696 Wilcok-brother Apethorp, John, of Staunford 1
4442397 2182563 2182563 defendant Normanton Peter de   586696 586696 Normanton, Peter de, of Staunford 0
4452581 2185810 2185810 plaintiff Kent Robert de   586696 586696 Kent, Robert de, of Staunford 0
4455579 2186752 2186752 plaintiff Mons William   586696 586696 Mons, William, of Staunford 0
4455772 2186822 2186822 defendant Wryght Walter   586696 586696 Wryght, Walter, of Staunford 0
4455773 2186822 2186822 defendant Carvewryght William   586696 586696 Carvewryght, William, of Staunford 1
4457991 2187523 2187523 defendant Skirlek William   586696 586696 Skirlek, William, of Staunford 0
4459052 2187875 2187875 defendant Shephird William   586696 586696 Shephird, William, of Staunford 1
4459846 2188134 2188134 plaintiff Say Godfrey dyer 586696 586696 Say, Godfrey, of Staunford, dyer 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);