names

2,245 rows where place_id = 586901

✎ 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
3589934 1864492 1864492 defendant Wylbrame Robert chapman 586901 586901 Wylbrame, Robert, of Nottingham, chapman 3
3589940 1864493 1864493 defendant Wylbrame Robert chapman 586901 586901 Wylbrame, Robert, of Nottingham, chapman 3
3591404 1864937 1864937 defendant Lee William barker 586901 586901 Lee, William, of Nottingham, barker 0
3595091 1866097 1866097 plaintiff Lynde William (legal representative) 586901 586901 Lynde, William, of Nottingham, merchant of the staple, executors of 0
3595092 1866097 1866097 plaintiff Clerk John baker 586901 586901 (Clerk, John, of Nottingham, baker 1
3595267 1866154 1866154 defendant Selyok John brasier 586901 586901 Selyok, John, of Nottingham, brasier 1
3595488 1866224 1866224 plaintiff Mellor Richard   586901 586901 Mellor, Richard, of Nottingham, bell maker 0
3596608 1866573 1866573 defendant Payntour Wenefrid single woman 586901 586901 Payntour, Wenefrid, of Nottingham, single woman 0
3597568 1866863 1866863 defendant Bower John yeoman 586901 586901 Bower, John, of Nottingham, yeoman 0
3602772 1868534 1868534 plaintiff Clapam Brian gent 586901 586901 Clapam, Brian, of Nottingham, gent 0
3602873 1868566 1868566 plaintiff Clughe Richard yeoman 586901 586901 Clughe, Richard, of Nottingham, yeoman 0
3603489 1868757 1868757 defendant Plumptre John grocer 586901 586901 Plumptre, John, of Nottingham, grocer 1
3604700 1869133 1869133 defendant Damps William yeoman 586901 586901 Damps, William, of Nottingham, yeoman 0
3605341 1869338 1869338 plaintiff Inglissh Robert (legal representative) 586901 586901 Inglissh, Robert, of Nottingham, merchant, executors of 0
3607723 1870069 1870069 plaintiff Selyok John   586901 586901 Selyok, John, of Nottingham, bell founder 0
3607729 1870070 1870070 plaintiff Selyok John   586901 586901 Selyok, John, of Nottingham, bell founder 0
3610625 1870991 1870991 defendant Salmon Thomas gent 586901 586901 Salmon, Thomas, of Nottingham, gent 0
3610626 1870991 1870991 defendant Marshall John tailor 586901 586901 Marshall, John, of Nottingham, tailor 1
3612870 1871674 1871674 defendant Cost John mercer 586901 586901 Cost, John, of Nottingham, mercer 0
3612871 1871674 1871674 defendant Taverner Robert haberdasher 586901 586901 Taverner, Robert, of Nottingham, haberdasher 1
3612872 1871674 1871674 defendant Couper Robert draper 586901 586901 Couper, Robert, of Nottingham, draper 2
3612873 1871674 1871674 defendant Spenlove John glover 586901 586901 Spenlove, John, of Nottingham, glover 3
3612875 1871675 1871675 defendant Samon Thomas gent 586901 586901 Samon, Thomas, of Nottingham, gent 0
3612876 1871675 1871675 defendant Marshall John tailor 586901 586901 Marshall, John, of Nottingham, tailor 1
3612878 1871676 1871676 defendant Samon Thomas gent 586901 586901 Samon, Thomas, of Nottingham, gent 0
3612879 1871676 1871676 defendant Marshall John tailor 586901 586901 Marshall, John, of Nottingham, tailor 1
3614953 1872321 1872321 defendant Misterton John, senior gent 586901 586901 Misterton, John, senior, of Nottingham, gent 0
3615096 1872367 1872367 defendant Isot John dyer 586901 586901 Isot, John, of Nottingham, dyer 0
3615214 1872404 1872404 defendant Cokayn John esq 586901 586901 Cokayn, John, of Nottingham, esq 0
3615326 1872437 1872437 defendant Isotte Richard innholder 586901 586901 Isotte, Richard, of Nottingham, innholder 3
3618984 1873549 1873549 defendant Burton Thomas draper 586901 586901 Burton, Thomas, of Nottingham, draper 1
3619706 1873733 1873733 defendant Holyngworth John brasier 586901 586901 Holyngworth, John, of Nottingham, brasier 0
3620679 1874045 1874045 defendant Hagh Edmund walker 586901 586901 Hagh, Edmund, of Nottingham, walker 0
3620680 1874045 1874045 defendant Blythe Ralph walker 586901 586901 Blythe, Ralph, of Nottingham, walker 1
3622173 1874468 1874468 defendant Wydderley John butcher 586901 586901 Wydderley, John, of Nottingham, butcher 0
3623136 1874758 1874758 defendant Marshall John tailor 586901 586901 Marshall, John, of Nottingham, tailor 0
3623892 1875000 1875000 defendant Poge Miles gent 586901 586901 Poge, Miles, of Nottingham, gent 0
3624015 1875045 1875045 defendant Mapurley John gent 586901 586901 Mapurley, John, of Nottingham, gent 1
3625441 1875494 1875494 defendant Maperley John gent 586901 586901 Maperley, John, of Nottingham, gent 0
3626077 1903015 1903015 defendant Johnson William butcher 586901 586901 Johnson, William, of Nottingham, butcher 0
3626472 1903136 1903136 defendant Savage Richard esq 586901 586901 Savage, Richard, of Nottingham, esq 0
3630094 1904261 1904261 defendant Goggyn Thomas grocer 586901 586901 Goggyn, Thomas, of Nottingham, grocer 2
3633728 1905359 1905359 defendant Smyth Richard butcher 586901 586901 Smyth, Richard, of Nottingham, butcher 0
3634427 1905568 1905568 plaintiff Mellours Robert bellfounder 586901 586901 Mellours, Robert, of Nottingham, bellfounder 0
3637142 1906416 1906416 plaintiff Selyok Richard bellfounder 586901 586901 Selyok, Richard, of Nottingham, bellfounder 0
3639655 1907213 1907213 plaintiff Williamson John alderman 586901 586901 Williamson, John, of Nottingham, alderman 0
3640365 1907416 1907416 defendant Selyok Richard bellfounder 586901 586901 Selyok, Richard, of Nottingham, bellfounder 0
3645546 1909004 1909004 defendant Yates John skinner 586901 586901 Yates, John, of Nottingham, skinner 0
3645547 1909004 1909004 defendant Stanley Robert shoemaker 586901 586901 Stanley, Robert, of Nottingham, shoemaker 1
3646411 1909274 1909274 plaintiff Howet John alderman 586901 586901 Howet, John, of Nottingham, alderman 0
3646455 1909288 1909288 defendant Mellers Robert bellfounder 586901 586901 (Mellers, Robert, of Nottingham, bellfounder 1
3646456 1909288 1909288 defendant Inglysshe William merchant 586901 586901 Inglysshe, William, of Nottingham, merchant 2
3646773 1909399 1909399 plaintiff Johnson William butcher 586901 586901 Johnson, William, of Nottingham, butcher 0
3648024 1909784 1909784 plaintiff Mellours Robert   586901 586901 Mellours, Robert, of Nottingham, bell founder 0
3648035 1909785 1909785 plaintiff Mellours Robert   586901 586901 Mellours, Robert, of Nottingham, bell founder 0
3648046 1909786 1909786 plaintiff Mellours Robert bellfounder 586901 586901 Mellours, Robert, of Nottingham, bellfounder 0
3648050 1909787 1909787 plaintiff Mellours Robert bellfounder 586901 586901 Mellours, Robert, of Nottingham, bellfounder 0
3648052 1909788 1909788 plaintiff Mellours Robert bellfounder 586901 586901 Mellours, Robert, of Nottingham, bellfounder 0
3648054 1909789 1909789 plaintiff Mellours Robert bellfounder 586901 586901 Mellours, Robert, of Nottingham, bellfounder 0
3648253 1909851 1909851 defendant Selyok Richard   586901 586901 Selyok, Richard, of Nottingham, bell founder 0
3648908 1910046 1910046 defendant Plomptre John chapman 586901 586901 (Plomptre, John, of Nottingham, chapman 3
3649252 1910154 1910154 defendant Wasse Thomas baker 586901 586901 Wasse, Thomas, of Nottingham, baker 0
3650118 1910406 1910406 plaintiff Roos John alderman 586901 586901 Roos, John, of Nottingham, alderman 0
3653664 1911411 1911411 plaintiff Wylloughby Thomas   586901 586901 Wylloughby, Thomas, of Nottingham 0
3653669 1911412 1911412 plaintiff Wylloughby Thomas   586901 586901 Wylloughby, Thomas, of Nottingham 0
3653674 1911413 1911413 plaintiff Wylloughby Thomas   586901 586901 Wylloughby, Thomas, of Nottingham 0
3656202 1912186 1912186 defendant Selby Alexander laborer 586901 586901 Selby, Alexander, of Nottingham, laborer 0
3657822 1912697 1912697 defendant Smyth Richard butcher 586901 586901 Smyth, Richard, of Nottingham, butcher 0
3658751 1912991 1912991 defendant Savage Richard esq 586901 586901 Savage, Richard, of Nottingham, esq 0
3658757 1912993 1912993 defendant Savage Richard esq 586901 586901 Savage, Richard, of Nottingham, esq 0
3660036 1913403 1913403 defendant Styper Henry mercer 586901 586901 Styper, Henry, of Nottingham, mercer 0
3660048 1913405 1913405 defendant Selyok Richard   586901 586901 Selyok, Richard, of Nottingham, bell founder 0
3660187 1913447 1913447 defendant Rychardson Robert glover 586901 586901 Rychardson, Robert, of Nottingham, glover 3
3660860 1913665 1913665 defendant Holle John pewterer 586901 586901 Holle, John, of Nottingham, pewterer 0
3661509 1913871 1913871 defendant Langforth Richard gent 586901 586901 Langforth, Richard, of Nottingham, gent 0
3661510 1913871 1913871 defendant Wodde Roger smith 586901 586901 (Wodde, Roger, of Nottingham, smith 1
3662371 1914142 1914142 defendant Selyok Richard   586901 586901 Selyok, Richard, of Nottingham, bell founder 0
3662372 1914143 1914143 plaintiff Mellours Thomas mercer 586901 586901 Mellours, Thomas, of Nottingham, mercer 0
3662800 1914283 1914283 defendant Cost Henry   586901 586901 Cost, Henry, of Nottingham, fish monger 0
3665532 1915171 1915171 defendant Hardinge William yeoman 586901 586901 Hardinge, William, of Nottingham, yeoman 0
3667283 1915705 1915705 plaintiff Willoughby Thomas Alderman 586901 586901 Willoughby, Thomas, of Nottingham, Alderman 0
3667546 1915791 1915791 plaintiff Wryght John   586901 586901 Wryght, John, of Nottingham 0
3667665 1915831 1915831 plaintiff Wylloughby Thomas Alderman 586901 586901 Wylloughby, Thomas, of Nottingham, Alderman 0
3667667 1915832 1915832 plaintiff Wylloughby Thomas Alderman 586901 586901 Wylloughby, Thomas, of Nottingham, Alderman 0
3667669 1915833 1915833 plaintiff Wylloughby Thomas Alderman 586901 586901 Wylloughby, Thomas, of Nottingham, Alderman 0
3667676 1915836 1915836 plaintiff Wyllyamson John Alderman 586901 586901 Wyllyamson, John, of Nottingham, Alderman 0
3667678 1915837 1915837 plaintiff Wyllyamson John Alderman 586901 586901 Wyllyamson, John, of Nottingham, Alderman 0
3669886 1916525 1916525 defendant Selyok Richard bellfounder 586901 586901 Selyok, Richard, of Nottingham, bellfounder 0
3671019 1916907 1916907 defendant Inglysshe William merchant of the staple 586901 586901 Inglysshe, William, of Nottingham, merchant of the staple 0
3671025 1916908 1916908 defendant Inglysshe William merchant of the staple 586901 586901 Inglysshe, William, of Nottingham, merchant of the staple 0
3671031 1916909 1916909 defendant Inglyshe William merchant of the staple 586901 586901 Inglyshe, William, of Nottingham, merchant of the staple 0
3671037 1916910 1916910 defendant Inglyshe William merchant of the staple 586901 586901 Inglyshe, William, of Nottingham, merchant of the staple 0
3671043 1916911 1916911 defendant Inglyshe William merchant of the staple 586901 586901 Inglyshe, William, of Nottingham, merchant of the staple 0
3671049 1916912 1916912 defendant Inglysshe William merchant of the staple 586901 586901 Inglysshe, William,of Nottingham, merchant of the staple 0
3673431 1917711 1917711 defendant Smyth Richard butcher 586901 586901 Smyth, Richard, of Nottingham, butcher 0
3675367 1918333 1918333 defendant Mellours Robert   586901 586901 Mellours, Robert, of Nottingham 0
3678185 1919227 1919227 defendant Savage Richard esq 586901 586901 Savage, Richard, of Nottingham, esq 0
3678187 1919228 1919228 defendant Worseley William gent 586901 586901 Worseley, William, of Nottingham, gent 0
3678922 1919476 1919476 defendant Cobler Thomas yeoman 586901 586901 Cobler, Thomas, of Nottingham, yeoman 1
3678928 1919477 1919477 defendant Sponer William chapman 586901 586901 Sponer, William, of Nottingham, chapman 4

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