names

3,486 rows where place_id = 586846

✎ 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
3589795 1864449 1864449 defendant Baron Thomas saddler 586846 586846 Baron, Thomas, of Lincoln, saddler 0
3589796 1864449 1864449 defendant Melburn Thomas smith 586846 586846 Melburn, Thomas, of Lincoln, smith 1
3590604 1864704 1864704 defendant Wytton James mercer 586846 586846 Wytton, James, of Lincoln, mercer 3
3591839 1865068 1865068 defendant (not given) John rector of Wygmore 586846 586846 Wygmore, John, of Lincoln, rector of Wadyngton 0
3592619 1865306 1865306 defendant Burgh Henry dyer 586846 586846 Burgh, Henry, of Lincoln, dyer 3
3594032 1865773 1865773 defendant Mores William fuller 586846 586846 Mores, William, of Lincoln, fuller 0
3595596 1866251 1866251 defendant Martyne Thomas (legal representative) 586846 586846 Martyne, Thomas, of Lincoln, glasier, executors of 0
3595597 1866251 1866251 defendant Dykson William draper 586846 586846 (Dykson, William, of Lincoln, draper 1
3596849 1866650 1866650 defendant Beche William baker 586846 586846 Beche, William, of Lincoln, baker 0
3597116 1866722 1866722 plaintiff Martyn William gent 586846 586846 Martyn, William, of Lincoln, gent 1
3597695 1866905 1866905 plaintiff Saynton John gent 586846 586846 Saynton, John, of Lincoln, gent 0
3597705 1866906 1866906 plaintiff Saynton John gent 586846 586846 Saynton, John, of Lincoln, gent 0
3597839 1866942 1866942 defendant Franke John chaplain 586846 586846 Franke, John, of Lincoln, chaplain 1
3598095 1867033 1867033 defendant Stanlowe John gent 586846 586846 Stanlowe, John, of Lincoln, gent 0
3599248 1867409 1867409 plaintiff Tofte William   586846 586846 Tofte, William, of Lincoln 0
3599629 1867527 1867527 defendant Sparowe John (legal representative) 586846 586846 Sparowe, John, of Lincoln, yeoman, executors of 0
3599630 1867527 1867527 defendant Darwent Thomas barker 586846 586846 (Darwent, Thomas, of Lincoln, barker 1
3599715 1867555 1867555 defendant Sparowe John (legal representative) 586846 586846 Sparowe, John, of Lincoln, yeoman, executors of 0
3599716 1867555 1867555 defendant Darwent Thomas barker 586846 586846 (Darwent, Thomas, of Lincoln, barker 1
3600527 1867811 1867811 defendant Langton Richard (legal representative) 586846 586846 Langton, Richard, of Lincoln, gent, executrix of 0
3600528 1867811 1867811 defendant Langton Joan widow 586846 586846 Langton, Joan, of Lincoln, widow 1
3600681 1867862 1867862 defendant Bele William merchant 586846 586846 Bele, William, of Lincoln, merchant 0
3601241 1868050 1868050 defendant Whitmore Robert (legal representative) 586846 586846 Whitmore, Robert, of Lincoln, merchant, administrator of 1
3601749 1868204 1868204 plaintiff Bele William merchant of the staple 586846 586846 Bele, William, of Lincoln, merchant of the staple 0
3602680 1868501 1868501 defendant Brereton Richard merchant 586846 586846 Brereton, Richard, of Lincoln, merchant 1
3603665 1868815 1868815 plaintiff Dysney Robert gent 586846 586846 Dysney, Robert, of Lincoln, gent 0
3604136 1868960 1868960 defendant Grantham John clerk 586846 586846 Grantham, John, of Lincoln, clerk 0
3605219 1869300 1869300 plaintiff Huddilston John (legal representative) 586846 586846 Huddilston, John, of Lincoln, executor of 0
3605263 1869313 1869313 defendant Horsham Thomas butcher 586846 586846 Horsham, Thomas, of Lincoln, butcher 0
3606842 1869807 1869807 defendant Halvester John dyer 586846 586846 Halvester, John, of Lincoln, dyer 0
3606843 1869807 1869807 defendant Bright Lawrence dyer 586846 586846 Bright, Lawrence, of Lincoln, dyer 1
3610287 1870873 1870873 defendant Bate Robert merchant 586846 586846 Bate, Robert, of Lincoln, merchant 0
3610289 1870874 1870874 defendant Bate Robert merchant 586846 586846 Bate, Robert, of Lincoln, merchant 0
3610445 1870927 1870927 defendant Johnson Richard chaplain 586846 586846 Johnson, Richard, of Lincoln, chaplain 0
3611293 1871207 1871207 defendant Bekford Oliver shoemaker 586846 586846 Bekford, Oliver, of Lincoln, shoemaker 0
3611294 1871207 1871207 defendant Hemyngburgh John shoemaker 586846 586846 Hemyngburgh, John, of Lincoln, shoemaker 1
3613232 1871793 1871793 defendant Taverner William vintner 586846 586846 Taverner, William, of Lincoln, vintner 0
3613725 1871943 1871943 plaintiff Bele William merchant of the staple 586846 586846 Bele, William, of Lincoln, gent, merchant of the staple 0
3613726 1871943 1871943 defendant Sutton Hamon esq 586846 586846 Sutton, Hamon, of Lincoln, esq 0
3613727 1871944 1871944 plaintiff Bele William merchant of the staple 586846 586846 Bele, William, of Lincoln, gent, merchant of the staple 0
3613729 1871944 1871944 defendant Smyth William bowyer 586846 586846 Smyth, William, of Lincoln, bowyer 1
3613730 1871945 1871945 plaintiff Bele William merchant 586846 586846 Bele, William, of Lincoln, merchant 0
3613892 1871999 1871999 defendant Saynton John gent 586846 586846 Saynton, John, of Lincoln, gent 0
3614605 1872217 1872217 defendant Sergeaunt William husbandman 586846 586846 Sergeaunt, William, of Lincoln, husbandman 0
3615193 1872398 1872398 defendant Rysom William clerk 586846 586846 Rysom, William, of Lincoln, clerk 0
3615194 1872398 1872398 defendant Smyth William bowyer 586846 586846 Smyth, William, of Lincoln, bowyer 1
3615195 1872398 1872398 defendant Hill Elizabeth laborer 586846 586846 Hill, Elizabeth, of Lincoln, laborer 2
3618244 1873330 1873330 plaintiff Grevys William   586846 586846 Grevys, William, of Lincoln 0
3619089 1873573 1873573 plaintiff Hodelston Robert, senior (legal representative) 586846 586846 Hodelston, Robert, senior, of Lincoln, executors of 0
3619092 1873573 1873573 defendant Sothell Arthur draper 586846 586846 Sothell, Arthur, of Lincoln, draper 0
3619093 1873573 1873573 defendant Disney Robert skinner 586846 586846 Disney, Robert, of Lincoln, skinner 1
3619094 1873573 1873573 defendant Othesee Robert yeoman 586846 586846 Othesee, Robert, of Lincoln, yeoman 2
3619095 1873573 1873573 defendant Sawer Thomas pewterer 586846 586846 Sawer, Thomas, of Lincoln, pewterer 3
3623403 1874852 1874852 plaintiff Seynton John   586846 586846 Seynton, John, of Lincoln 0
3623406 1874853 1874853 plaintiff Seynton John   586846 586846 Seynton, John, of Lincoln 0
3623703 1874946 1874946 defendant Hert William gent 586846 586846 Hert, William, of Lincoln, notary, gent 0
3624127 1875073 1875073 defendant Randall Robert sherman 586846 586846 Randall, Robert, of Lincoln, sherman 0
3625107 1875388 1875388 plaintiff Watkynson John (legal representative) 586846 586846 Watkynson, John, of Lincoln, mercer, executor of 0
3626877 1903258 1903258 defendant Willoughby Geoffrey clerk 586846 586846 Willoughby, Geoffrey, of Lincoln, clerk 0
3629828 1904182 1904182 plaintiff Dighton Robert draper 586846 586846 Dighton, Robert, of Lincoln, alderman, draper 0
3629934 1904219 1904219 defendant Smyth Edward butcher 586846 586846 Smyth, Edward, of Lincoln, butcher 0
3629935 1904219 1904219 defendant Goodknap Ralph tanner 586846 586846 Goodknap, Ralph, of Lincoln, tanner 1
3629936 1904219 1904219 defendant Fox William saddler 586846 586846 Fox, William, of Lincoln, saddler 2
3630124 1904271 1904271 plaintiff Dyghton Robert alderman 586846 586846 Dyghton, Robert, of Lincoln, alderman 0
3630602 1904399 1904399 defendant Banaster Richard dyer 586846 586846 Banaster, Richard, of Lincoln, dyer 4
3632095 1904855 1904855 plaintiff Hart William (legal representative) 586846 586846 Hart, William, of Lincoln, gent, executors of 0
3632655 1905030 1905030 defendant Vesey Thomas fishmonger 586846 586846 Vesey, Thomas, of Lincoln, fishmonger 0
3632656 1905030 1905030 defendant Kalgarth Robert brasier 586846 586846 Kalgarth, Robert, of Lincoln, brasier 1
3632657 1905030 1905030 defendant Sammes William   586846 586846 Sammes, William, of Lincoln, tallow chandler 2
3632658 1905030 1905030 defendant Sammes Richard yeoman 586846 586846 Sammes, Richard, of Lincoln, yeoman 3
3632659 1905030 1905030 defendant Atkynson William yeoman 586846 586846 Atkynson, William, of Lincoln, yeoman 4
3632660 1905030 1905030 defendant Brumpton Hamo yeoman 586846 586846 Brumpton, Hamo, of Lincoln, yeoman 5
3632661 1905030 1905030 defendant Hunston Richard gent 586846 586846 Hunston, Richard, of Lincoln, gent 6
3632662 1905030 1905030 defendant Awkelond Robert weaver 586846 586846 Awkelond, Robert, of Lincoln, weaver 7
3632663 1905030 1905030 defendant Souresby Christopher   586846 586846 Souresby, Christopher, of Lincoln, bottle maker 8
3632738 1905052 1905052 defendant Fyssher William fishmonger 586846 586846 Fyssher, William, of Lincoln, fishmonger 2
3633189 1905195 1905195 plaintiff Johnson Richard (legal representative) 586846 586846 Johnson, Richard, of Lincoln, fishmonger, executors of 0
3635055 1905763 1905763 defendant Efferd Peter gent 586846 586846 Efferd, Peter, of Lincoln, gent 1
3636492 1906206 1906206 defendant Wode Roger draper 586846 586846 Wode, Roger, of Lincoln, draper 0
3636953 1906353 1906353 defendant Downyng John laborer 586846 586846 Downyng, John, of Lincoln, laborer 0
3636955 1906354 1906354 defendant Wilfford William mercer 586846 586846 Wilfford, William, of Lincoln, mercer 0
3636956 1906354 1906354 defendant Hochenson William draper 586846 586846 Hochenson, William, of Lincoln, draper 1
3636957 1906354 1906354 defendant Smyth Robert butcher 586846 586846 Smyth, Robert, of Lincoln, butcher 2
3636958 1906354 1906354 defendant Schastowe Richard yeoman 586846 586846 Schastowe, Richard, of Lincoln, yeoman 3
3636959 1906354 1906354 defendant Parkar George yeoman 586846 586846 Parkar, George, of Lincoln, yeoman 4
3636960 1906354 1906354 defendant Downyng John yeoman 586846 586846 Downyng, John, of Lincoln, yeoman 5
3640414 1907434 1907434 plaintiff Alanson Robert jeweler 586846 586846 Alanson, Robert, of Lincoln, jeweler 0
3641086 1907655 1907655 defendant Dale John butcher 586846 586846 Dale, John, of Lincoln, butcher 0
3646041 1909160 1909160 defendant Willesford Bartholomew gent 586846 586846 Willesford, Bartholomew, of Lincoln, gent 0
3646252 1909218 1909218 plaintiff Hodegekynson Roger draper 586846 586846 Hodegekynson, Roger, of Lincoln, draper 0
3646385 1909264 1909264 plaintiff Horner Oliver (legal representative) 586846 586846 Horner, Oliver, of Lincoln, chaplain, executor of 0
3646774 1909399 1909399 defendant Irchenett alias Urchonhede William mercer 586846 586846 Irchenett alias Urchonhede, William, of Lincoln, mercer 0
3647692 1909668 1909668 defendant Bolle John clerk 586846 586846 Bolle, John, of Lincoln, clerk 3
3655219 1911890 1911890 defendant Motley Thomas butcher & beer brewer 586846 586846 Motley, Thomas, of Lincoln, butcher & beer brewer 0
3655220 1911890 1911890 defendant Wakman Alan tailor 586846 586846 Wakman, Alan, of Lincoln, tailor 1
3656391 1912244 1912244 plaintiff Castell John clerk 586846 586846 Castell, John, of Lincoln, clerk 0
3657602 1912640 1912640 defendant Massyngberd Christopher clerk & treasurer of the Cathedral 586846 586846 Massyngberd, Christopher, of Lincoln, clerk & treasurer of the Cathedral 0
3659694 1913288 1913288 plaintiff Gryffen William   586846 586846 Gryffen, William, of Lincoln, gent, son of John Gryffen alias Bayncroft, gent, deceased 0
3661293 1913809 1913809 defendant Downyng John yeoman 586846 586846 Downyng, John, of Lincoln, yeoman 0
3661294 1913809 1913809 defendant Stokbrig William yeoman 586846 586846 Stokbrig, William, of Lincoln, 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);