names

2,202 rows where place_id = 586033

✎ 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
3587745 1863813 1863813 defendant Hubert Richard vintner 586033 586033 Hubert, Richard, of Westminster, vintner 1
3588595 1864077 1864077 plaintiff Blakenale William grasier or butcher 586033 586033 Blakenale, William, of Westminster, grasier or butcher 0
3588596 1864077 1864077 defendant Stokyng John vintner 586033 586033 Stokyng, John, of Westminster, vintner 0
3588597 1864078 1864078 plaintiff Blakenall William grasier and butcher 586033 586033 Blakenall, William, of Westminster, grasier and butcher 0
3588598 1864078 1864078 defendant Stokyng John vintner 586033 586033 Stokyng, John, of Westminster, vintner 0
3589433 1864333 1864333 defendant Garthorn Thomas yeoman 586033 586033 Garthorn, Thomas, of Westminster, yeoman 1
3589436 1864333 1864333 defendant Crane Agnes widow 586033 586033 Crane, Agnes, of Westminster, widow 4
3589593 1864384 1864384 defendant Gerard John   586033 586033 Gerard, John, of Westminster, cook 0
3589594 1864384 1864384 defendant Ledell Alexander barber 586033 586033 Ledell, Alexander, of Westminster, barber 1
3591180 1864863 1864863 defendant Cornyssh Thomas gent 586033 586033 Cornyssh, Thomas, of Westminster, gent 4
3591204 1864872 1864872 defendant Andreweson Adam yeoman 586033 586033 Andreweson, Adam, of Westminster, yeoman 0
3591536 1864979 1864979 defendant Deysy William innholder 586033 586033 Deysy, William, of Westminster, merchant, or of Redyng, Berks, innholder 0
3591541 1864980 1864980 defendant Deysy William innholder 586033 586033 Deysy, William, of Westminster, merchant, or of Redyng, Berks, innholder 0
3591547 1864981 1864981 defendant Deysy William innholder 586033 586033 Deysy, William, of Westminster, merchant, or of Redyng, Berks, innholder 0
3592841 1865377 1865377 defendant Trestram William yeoman 586033 586033 Trestram, William, of Westminster, yeoman 0
3594769 1865989 1865989 defendant Shyrbek John glover 586033 586033 Shyrbek, John, of Westminster, glover 0
3595788 1866317 1866317 defendant Bancroft William bajer 586033 586033 Bancroft, William, of Westminster, bajer 0
3595857 1866343 1866343 defendant Slydale Elizabeth widow 586033 586033 Slydale, Elizabeth, of Westminster, widow 0
3595858 1866343 1866343 defendant Skelton John gent 586033 586033 Skelton, John, of Westminster, gent 1
3595860 1866344 1866344 defendant Slydale Elizabeth widow 586033 586033 Slydale, Elizabeth, of Westminster, widow 0
3595861 1866344 1866344 defendant Skelton John gent 586033 586033 Skelton, John, of Westminster, gent 1
3596131 1866418 1866418 defendant Kynge Robert scrivener 586033 586033 Kynge, Robert, of Westminster, scrivener 2
3597099 1866716 1866716 plaintiff Randolffe John (legal representative) 586033 586033 Randolffe, John, of Westminster, esq, executors of 0
3598705 1867220 1867220 defendant Reynold Henry gent 586033 586033 Reynold, Henry, of Westminster, gent 0
3598707 1867221 1867221 defendant Reynold Henry gent 586033 586033 Reynold, Henry, of Westminster, gent 0
3598709 1867222 1867222 defendant Reynold Henry gent 586033 586033 Reynold, Henry, of Westminster, gent 0
3598729 1867229 1867229 plaintiff Stone Richard gent 586033 586033 Stone, Richard, of Westminster, gent 0
3598734 1867230 1867230 plaintiff Stone Richard gent 586033 586033 Stone, Richard, of Westminster, gent 0
3598952 1867300 1867300 defendant Berde John yeoman 586033 586033 Berde, John, of Westminster, yeoman 0
3599350 1867439 1867439 defendant Mortymer Thomas gent 586033 586033 Mortymer, Thomas, of Westminster, gent 0
3600629 1867845 1867845 defendant Walshe John innholder 586033 586033 Walshe, John, of Westminster, innholder 0
3600630 1867845 1867845 defendant Averey William gent 586033 586033 Averey, William, of Westminster, gent 1
3600647 1867849 1867849 defendant Lowe Richard   586033 586033 Lowe, Richard, of Westminster, tallow chandler 0
3600648 1867849 1867849 defendant Smyth William laborer 586033 586033 Smyth, William, of Westminster, laborer 1
3602471 1868433 1868433 defendant Weste Thomas   586033 586033 Weste, Thomas, of Westminster, knight, Lord Lawarr 0
3603123 1868642 1868642 defendant Glyn David chaplain 586033 586033 Glyn, David, of Westminster, chaplain 1
3603130 1868643 1868643 defendant Kemys Thomas (legal representative) 586033 586033 Kemys, Thomas, of Westminster, esq, administrator of 2
3603131 1868643 1868643 defendant Kemys Roger gent 586033 586033 Kemys, Roger, of Westminster, gent 3
3603213 1868673 1868673 defendant Allese John glasier 586033 586033 Allese, John, of Westminster, glasier 0
3604214 1868983 1868983 defendant Manys Richard innholder or thatcher 586033 586033 Manys, Richard, of Westminster, innholder or thatcher 0
3605766 1869470 1869470 defendant Ly Katherine widow 586033 586033 Ly, Katherine, of Westminster, widow 1
3606996 1869852 1869852 defendant Bromfeld Richard clerk 586033 586033 Bromfeld, Richard, of Westminster, clerk 0
3607091 1869882 1869882 defendant Day Thomas   586033 586033 Day, Thomas, of Westminster, "fyshionter" 1
3607179 1869911 1869911 defendant Manfeld William waterman 586033 586033 Manfeld, William, of Westminster, waterman 0
3607212 1869920 1869920 defendant Swynerton John gent 586033 586033 Swynerton, John, of Westminster, gent 1
3607479 1869999 1869999 defendant Bradshawe Thomas yeoman 586033 586033 Bradshawe, Thomas, of Westminster, yeoman 0
3612503 1871542 1871542 defendant Walyngford Simon yeoman 586033 586033 Walyngford, Simon, of Westminster, yeoman 6
3613034 1871728 1871728 defendant Assheby Thomas brewer 586033 586033 Assheby, Thomas, of Westminster, brewer 0
3614144 1872089 1872089 defendant Atcleff William gent 586033 586033 Atcleff, William, of Westminster, gent 0
3614971 1872327 1872327 defendant Beauchamp Richard   586033 586033 Beauchamp, Richard, of Westminster, knight 0
3615636 1872532 1872532 defendant Scrope Robert gent 586033 586033 Scrope, Robert, of Westminster, gent 2
3616277 1872732 1872732 defendant Hikford William soldier 586033 586033 Hikford, William, of Westminster, yeoman, or of Berwike, soldier 0
3617694 1873159 1873159 defendant Lowe Richard salter 586033 586033 Lowe, Richard, of Westminster, salter 1
3618645 1873459 1873459 defendant Newell Philip   586033 586033 Newell, Philip, of Westminster, cook 0
3618646 1873459 1873459 defendant Eustas Potence widow 586033 586033 Eustas, Potence, of Westminster, widow 1
3619288 1873634 1873634 defendant Marten Richard yeoman of the crown 586033 586033 (Marten, Richard, of Westminster, yeoman of the crown 2
3619818 1873773 1873773 defendant Walker William yeoman 586033 586033 Walker, William, of Westminster, yeoman 0
3619820 1873774 1873774 defendant Walker William yeoman 586033 586033 Walker, William, of Westminster, yeoman 0
3619822 1873775 1873775 defendant Walker William yeoman 586033 586033 Walker, William, of Westminster, yeoman 0
3621042 1874138 1874138 defendant Brent Thomas clerk 586033 586033 (Brent, Thomas, of Westminster, clerk 3
3621290 1874200 1874200 defendant Jakson Thomas yeoman 586033 586033 Jakson, Thomas, of Westminster, yeoman 0
3621291 1874200 1874200 defendant Johnson Katherine spinster 586033 586033 Johnson, Katherine, of Westminster,spinster 1
3621292 1874200 1874200 defendant Fuller John fruiterer 586033 586033 Fuller, John, of Westminster, fruiterer 2
3621293 1874200 1874200 defendant Bysshop Maud spinster 586033 586033 Bysshop, Maud, of Westminster, spinster 3
3621992 1874421 1874421 defendant Twylly Thomas brewer 586033 586033 Twylly, Thomas, of Westminster, brewer 0
3623018 1874726 1874726 defendant Blaknall William grasier 586033 586033 Blaknall, William, of Westminster, grasier 0
3623022 1874728 1874728 defendant Blaknall William grasier 586033 586033 Blaknall, William, of Westminster, grasier 0
3623066 1874737 1874737 defendant Wycom Richard baker 586033 586033 Wycom, Richard, of Westminster, baker 0
3623431 1874862 1874862 defendant Heggeford William joiner 586033 586033 Heggeford, William, of Westminster, joiner 0
3625196 1875414 1875414 defendant Barker William tailor 586033 586033 Barker, William, of Westminster, tailor 0
3625203 1875417 1875417 defendant Ryder Thomas gent 586033 586033 Ryder, Thomas, of Westminster, gent 0
3625528 1875523 1875523 defendant Brent Thomas clerk 586033 586033 Brent, Thomas, of Westminster, clerk 0
3626355 1903102 1903102 plaintiff Atwell John gent 586033 586033 Atwell, John, of Westminster, gent 0
3626357 1903103 1903103 plaintiff Atwell John gent 586033 586033 Atwell, John, of Westminster, gent 0
3626358 1903103 1903103 plaintiff James John yeoman 586033 586033 James, John, of Westminster, yeoman 1
3628264 1903701 1903701 defendant Keyne Robert butcher 586033 586033 Keyne, Robert, of Westminster, butcher 0
3628319 1903718 1903718 defendant Westun Thomas yeoman 586033 586033 Westun, Thomas, of Westminster, yeoman 0
3628322 1903719 1903719 defendant Westun Thomas yeoman 586033 586033 Westun, Thomas, of Westminster, yeoman 0
3629683 1904137 1904137 defendant Atkyns William gent 586033 586033 Atkyns, William, of Westminster, gent 1
3630201 1904293 1904293 defendant ap Robert of Thomas gent 586033 586033 ap Robert, of Thomas, of Westminster, gent 0
3632015 1904830 1904830 defendant Arundell Christopher gent 586033 586033 Arundell, Christopher, of Westminster, gent 0
3632044 1904839 1904839 defendant Arundell Christopher gent 586033 586033 Arundell, Christopher, of Westminster, gent 0
3632315 1904927 1904927 defendant Arundell Christopher gent 586033 586033 Arundell, Christopher, of Westminster, gent 0
3633061 1905153 1905153 defendant Robertys Thomas gent 586033 586033 Robertys, Thomas, of Westminster, or of Uske, March of Wales, gent 0
3633080 1905158 1905158 defendant Gorden Robert yeoman 586033 586033 Gorden, Robert, of Westminster, yeoman 2
3633279 1905227 1905227 defendant Corbet Thomas gent 586033 586033 Corbet, Thomas, of Westminster, gent 0
3634939 1905729 1905729 plaintiff Newdyke Richard (legal representative) 586033 586033 Newdyke, Richard, of Westminster, gent, executors of 0
3635606 1905940 1905940 defendant Ashton Hugh clerk 586033 586033 (Ashton, Hugh, of Westminster, clerk 1
3635607 1905940 1905940 defendant Lichfeld William clerk 586033 586033 Lichfeld, William, of Westminster, clerk 2
3636199 1906110 1906110 defendant (not given) John rector of Whyte 586033 586033 Whyte, John, of Westminster, vicar of St Stephens Chapel, Westminster Palace, rector of Pryngast, Penbroke 0
3636968 1906358 1906358 defendant Warde John gent 586033 586033 Warde, John, of Westminster, gent 0
3638721 1906925 1906925 defendant Tuke Robert gent 586033 586033 Tuke, Robert, of Westminster, king's household, gent 1
3638722 1906925 1906925 defendant Vyncent Christopher gent 586033 586033 Vyncent, Christopher, of Westminster, gent 2
3642123 1907985 1907985 defendant Hendry John butcher 586033 586033 Hendry, John, of Westminster, butcher 1
3643256 1908316 1908316 defendant Wodshawe Alvered gent 586033 586033 Wodshawe, Alvered, of Westminster, gent 0
3644627 1908730 1908730 defendant Whyte John clerk 586033 586033 Whyte, John, of Westminster, clerk 3
3645024 1908851 1908851 defendant Whyte John clerk 586033 586033 Whyte, John, of Westminster, clerk 2
3646605 1909343 1909343 defendant Camden Richard fishmonger 586033 586033 Camden, Richard, of Westminster, fishmonger 0
3648722 1909987 1909987 defendant Trolope John vintner 586033 586033 Trolope, John, of Westminster, vintner 1
3648723 1909987 1909987 defendant Halle Robert barber 586033 586033 Halle, Robert, of Westminster, barber 2

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