names

5,219 rows where place_id = 586859

✎ 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
3589820 1864456 1864456 defendant Whiterell Edmund tailor 586859 586859 Whiterell, Edmund, of Salisbury, tailor 0
3589821 1864456 1864456 defendant Hawekyns William merchant 586859 586859 Hawekyns, William, of Salisbury, merchant 1
3589836 1864462 1864462 plaintiff Chafyn John   586859 586859 Chafyn, John, of Salisbury 0
3591185 1864865 1864865 defendant Hall William gent 586859 586859 Hall, William, of Salisbury, gent 0
3592732 1865340 1865340 defendant Bethewyn William (legal representative) 586859 586859 Bethewyn, William, of Salisbury, "dubber", executor of 0
3592733 1865340 1865340 defendant Bethewyn John tanner 586859 586859 Bethewyn, John, of Salisbury, tanner 1
3592935 1865410 1865410 defendant Hogget Peter butcher 586859 586859 Hogget, Peter, of Salisbury, butcher 0
3595167 1866121 1866121 defendant Grene John saddler or innholder 586859 586859 Grene, John, of Salisbury, saddler or innholder 0
3595816 1866327 1866327 defendant Somer Thomas yeoman 586859 586859 Somer, Thomas, of Salisbury, yeoman 0
3596216 1866446 1866446 plaintiff Page William mercer 586859 586859 Page, William, of Salisbury, mercer 0
3596525 1866547 1866547 defendant Bokull Henry   586859 586859 Bokull, Henry, of Salisbury, cook 0
3596989 1866685 1866685 defendant Blake John butcher 586859 586859 Blake, John, of Salisbury, butcher 0
3598181 1867062 1867062 plaintiff Slegge William gent 586859 586859 Slegge, William, of Salisbury, gent 0
3599245 1867407 1867407 defendant Forget Tussan gent 586859 586859 Forget, Tussan, of Salisbury, gent 0
3602930 1868580 1868580 plaintiff Coke Thomas merchant 586859 586859 Coke, Thomas, of Salisbury, merchant 0
3602932 1868581 1868581 plaintiff Coke Thomas merchant 586859 586859 Coke, Thomas, of Salisbury, merchant 0
3603488 1868757 1868757 defendant Canyngis John   586859 586859 Canyngis, John, of Salisbury, physician 0
3603498 1868761 1868761 defendant Hanley or Hauley Walter hosier 586859 586859 Hanley or Hauley, Walter, of Salisbury, hosier 0
3605324 1869331 1869331 defendant Pole John clothier 586859 586859 Pole, John, of Salisbury, clothier 0
3606923 1869830 1869830 defendant Bentylley John, senior weaver 586859 586859 Bentylley, John, senior, of Salisbury, weaver 1
3608923 1870450 1870450 plaintiff Webbe William merchant 586859 586859 Webbe, William, of Salisbury, merchant 0
3609512 1870633 1870633 defendant Halle William gent 586859 586859 Halle, William, of Salisbury, gent 0
3610132 1870832 1870832 defendant Chaundeler John clerk 586859 586859 Chaundeler, John, of Salisbury, clerk 0
3610351 1870894 1870894 defendant Wykfale or Wyksale John brewer 586859 586859 Wykfale or Wyksale, John, of Salisbury, brewer 0
3614777 1872272 1872272 defendant ap Thomas alias Chamber William innholder 586859 586859 ap Thomas alias Chamber, William, of Salisbury, innholder 0
3614779 1872273 1872273 defendant ap Thomas alias Chamber William innholder 586859 586859 ap Thomas alias Chamber, William, of Salisbury, innholder 0
3615524 1872497 1872497 plaintiff Cocke Thomas mercer 586859 586859 Cocke, Thomas, of Salisbury, mercer 0
3615615 1872526 1872526 plaintiff Colman Roger   586859 586859 Colman, Roger, of Salisbury 0
3615617 1872527 1872527 plaintiff Colman Roger   586859 586859 Colman, Roger, of Salisbury 0
3615971 1872629 1872629 defendant Walsell alias Walser Thomas innholder 586859 586859 Walsell alias Walser, Thomas, of Salisbury, innholder 0
3617026 1872947 1872947 defendant Sawete John goldsmith 586859 586859 Sawete, John, of Salisbury, goldsmith 0
3617029 1872948 1872948 defendant Sawete John goldsmith 586859 586859 Sawete, John, of Salisbury, goldsmith 0
3617760 1873179 1873179 defendant Baker Thomas clerk 586859 586859 Baker, Thomas, of Salisbury, clerk 0
3618176 1873307 1873307 defendant Spryng Thomas clerk of works 586859 586859 Spryng, Thomas, of Salisbury, clerk of works 7
3618995 1873552 1873552 defendant Norwell Richard chapman 586859 586859 Norwell, Richard, of Salisbury, chapman 0
3621051 1874141 1874141 defendant Asshe John gent 586859 586859 Asshe, John, of Salisbury, gent 0
3622266 1874498 1874498 defendant Wales Robert   586859 586859 Wales, Robert, of Salisbury, wax chandler 2
3624062 1875056 1875056 defendant Walsale Thomas innholder 586859 586859 Walsale, Thomas, of Salisbury, innholder 0
3624063 1875056 1875056 defendant Bysshop Richard butcher 586859 586859 Bysshop, Richard, of Salisbury, butcher 1
3624271 1875124 1875124 defendant Rumsey Richard brewer 586859 586859 Rumsey, Richard, of Salisbury, brewer 1
3625992 1902988 1902988 defendant Blaunchard William   586859 586859 Blaunchard, William, of Salisbury, apothecary 0
3625995 1902988 1902988 defendant Beyngly John grocer 586859 586859 Beyngly, John, of Salisbury, grocer 3
3628304 1903715 1903715 defendant Slater John chapman 586859 586859 Slater, John, of Salisbury, chapman 2
3628547 1903799 1903799 defendant Payne Thomas, junior mercer 586859 586859 Payne, Thomas, junior, of Salisbury, mercer 0
3628549 1903800 1903800 defendant Crandon Thomas vintner 586859 586859 Crandon, Thomas, of Salisbury, vintner 0
3628551 1903801 1903801 defendant Ratclyff William barber 586859 586859 Ratclyff, William, of Salisbury, barber 0
3628881 1903909 1903909 plaintiff Coke Thomas mercer 586859 586859 Coke, Thomas, of Salisbury, mercer 0
3628885 1903910 1903910 plaintiff Coke Thomas merchant 586859 586859 Coke, Thomas, of Salisbury, merchant 0
3628887 1903911 1903911 plaintiff Coke Thomas merchant 586859 586859 Coke, Thomas, of Salisbury, merchant 0
3628889 1903912 1903912 plaintiff Coke Thomas merchant 586859 586859 Coke, Thomas, of Salisbury, merchant 0
3629479 1904074 1904074 defendant Pessom Angelus mercer 586859 586859 Pessom, Angelus, of Salisbury, mercer 0
3630252 1904310 1904310 defendant Cuff John clothier 586859 586859 Cuff, John, of Salisbury, clothier 0
3632491 1904982 1904982 defendant Baker John courser 586859 586859 Baker, John, of Salisbury, courser 0
3632942 1905119 1905119 plaintiff Husee Henry gent 586859 586859 Husee, Henry, of Salisbury, gent 0
3633273 1905224 1905224 defendant Broke John brewer 586859 586859 Broke, John, of Salisbury, brewer 0
3634332 1905535 1905535 defendant Cherite Richard merchant 586859 586859 Cherite, Richard, of Salisbury, merchant 2
3634797 1905683 1905683 defendant Priour John fishmonger 586859 586859 Priour, John, of Salisbury, fishmonger 0
3636192 1906108 1906108 defendant Crandon Thomas vintner 586859 586859 Crandon, Thomas, of Salisbury, vintner 0
3636498 1906208 1906208 plaintiff Reynold John yeoman 586859 586859 Reynold, John, of Salisbury, yeoman 0
3636499 1906208 1906208 defendant Richeford William gent 586859 586859 Richeford, William, of Salisbury, gent 0
3636611 1906242 1906242 defendant Chaffyn Nicholas mercer 586859 586859 Chaffyn, Nicholas, of Salisbury, mercer 1
3640539 1907478 1907478 defendant Swanneborough John cordwainer 586859 586859 Swanneborough, John, of Salisbury, cordwainer 0
3641007 1907628 1907628 defendant Wellys Richard yeoman 586859 586859 Wellys, Richard, of Salisbury, yeoman 0
3641008 1907628 1907628 defendant Maynard Thomas upholsterer 586859 586859 Maynard, Thomas, of Salisbury, upholsterer 1
3641009 1907628 1907628 defendant Stephens Thomas upholsterer 586859 586859 Stephens, Thomas, of Salisbury, upholsterer 2
3641014 1907629 1907629 defendant Scutte John tucker 586859 586859 Scutte, John, of Salisbury, tucker 1
3641023 1907632 1907632 defendant Couffe John clothman 586859 586859 Couffe, John, of Salisbury, clothman 0
3641025 1907633 1907633 defendant Couffe John clothman 586859 586859 Couffe, John, of Salisbury, clothman 0
3641174 1907690 1907690 defendant Kelley Thomas weaver 586859 586859 Kelley, Thomas, of Salisbury, weaver 0
3641176 1907691 1907691 defendant Kelley Thomas weaver 586859 586859 Kelley, Thomas, of Salisbury, weaver 0
3641748 1907871 1907871 plaintiff Brodgate Thomas merchant 586859 586859 Brodgate, Thomas, of Salisbury, merchant 0
3642900 1908230 1908230 plaintiff Coke Thomas mercer 586859 586859 Coke, Thomas, of Salisbury, mercer 0
3645227 1908914 1908914 defendant Crandon Thomas taverner 586859 586859 Crandon, Thomas, of Salisbury, taverner 0
3645599 1909018 1909018 defendant Muddell Stephen breweer 586859 586859 Muddell, Stephen, of Salisbury, breweer 0
3645600 1909019 1909019 plaintiff Gylpurne John merchant 586859 586859 Gylpurne, John, of Salisbury, merchant 0
3645602 1909020 1909020 plaintiff Gylpurne John merchant 586859 586859 Gylpurne, John, of Salisbury, merchant 0
3646697 1909369 1909369 defendant Smolcok Peter currier 586859 586859 Smolcok, Peter, of Salisbury, currier 0
3646699 1909370 1909370 defendant Smolcok Peter currier 586859 586859 Smolcok, Peter, of Salisbury, currier 0
3647165 1909503 1909503 defendant Brent John chapman 586859 586859 Brent, John, of Salisbury, chapman 0
3647925 1909748 1909748 defendant Lesard Nicholas embroiderer 586859 586859 Lesard, Nicholas, of Salisbury, embroiderer 0
3648128 1909809 1909809 defendant Rympyngden John gent 586859 586859 Rympyngden, John, of Salisbury, gent 0
3648350 1909884 1909884 defendant Pelison John beer brewer 586859 586859 Pelison, John, of Salisbury, beer brewer 0
3651750 1910900 1910900 defendant Wattys Richard   586859 586859 Wattys, Richard, of Salisbury, parson of Radepoll 0
3654358 1911624 1911624 defendant Bartylmewe John merchant 586859 586859 Bartylmewe, John, of Salisbury, merchant 0
3654591 1911698 1911698 defendant Edwardys Thomas tanner 586859 586859 Edwardys, Thomas, of Salisbury, tanner 3
3657452 1912590 1912590 defendant Watson Henry chapman 586859 586859 Watson, Henry, of Salisbury, dyer, Dawson, Edmund, of Kymolton, Hunts, chapman 1
3664560 1914870 1914870 defendant Aleyn William (legal representative) 586859 586859 Aleyn, William, of Salisbury, brewer, executors of 0
3664561 1914870 1914870 defendant Skynner alias Strowde John skinner 586859 586859 (Skynner alias Strowde, John, of Salisbury, skinner 1
3664562 1914870 1914870 defendant Aleyn John brewer 586859 586859 Aleyn, John, of Salisbury, brewer 2
3670288 1916656 1916656 plaintiff Broman John merchant 586859 586859 Broman, John, of Salisbury, merchant 0
3671547 1917084 1917084 plaintiff Coke Thomas mercer 586859 586859 Coke, Thomas, of Salisbury, mercer 0
3671549 1917085 1917085 plaintiff Coke Thomas mercer 586859 586859 Coke, Thomas, of Salisbury, mercer 0
3673283 1917660 1917660 plaintiff Elyot John mercer 586859 586859 Elyot, John, of Salisbury, mercer 0
3674009 1917911 1917911 defendant Harrys William gent 586859 586859 Harrys, William, of Salisbury, gent 0
3674352 1918023 1918023 plaintiff Godfrey John (legal representative) 586859 586859 Godfrey, John, of Salisbury, draper, executors of 0
3674537 1918088 1918088 defendant Marshall William glover 586859 586859 Marshall, William, of Salisbury, glover 4
3675413 1918347 1918347 defendant Lemman John tucker 586859 586859 Lemman, John, of Salisbury, tucker 1
3677826 1919117 1919117 defendant James Henry hardwareman 586859 586859 James, Henry, of Salisbury, hardwareman 0
3678325 1919274 1919274 defendant Wyllyams Walter fletcher 586859 586859 Wyllyams, Walter, of Salisbury, fletcher 1
3680324 1919922 1919922 defendant Puncherdon Robert yeoman 586859 586859 Puncherdon, Robert, of Salisbury, yeoman 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);