names

1,803 rows where place_id = 586318

✎ 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
3588420 1864027 1864027 defendant Nasche John brasier 586318 586318 Nasche, John, of Worcester, brasier 1
3588421 1864027 1864027 defendant Adney John weaver 586318 586318 Adney, John, of Worcester, weaver 2
3588425 1864028 1864028 defendant Nasche John grasier 586318 586318 Nasche, John, of Worcester, grasier 1
3588426 1864028 1864028 defendant Adney John weaver 586318 586318 Adney, John, of Worcester, weaver 2
3589675 1864411 1864411 defendant Hanbery William chapman 586318 586318 Hanbery, William, of Worcester, chapman 0
3589680 1864412 1864412 defendant Hanbery William chapman 586318 586318 Hanbery, William, of Worcester, chapman 0
3590712 1864737 1864737 defendant Hambery William chapman 586318 586318 Hambery, William, of Worcester, chapman 2
3591043 1864826 1864826 defendant Bartram Monetus vintner 586318 586318 Bartram, Monetus, of Worcester, vintner 0
3592601 1865302 1865302 defendant Hambre William chapman 586318 586318 Hambre, William, of Worcester, chapman 3
3592607 1865303 1865303 defendant Hambre William chapman 586318 586318 Hambre, William, of Worcester, chapman 4
3594520 1865916 1865916 defendant Goodyere Edward husbandman 586318 586318 (Goodyere, Edward, of Worcester, husbandman 1
3594947 1866048 1866048 defendant Wade John, junior yeoman 586318 586318 Wade, John, junior, of Worcester, yeoman 1
3595207 1866135 1866135 defendant Spryng John yeoman 586318 586318 Spryng, John, of Worcester, yeoman 0
3595208 1866135 1866135 defendant Cane or Cave William yeoman 586318 586318 Cane or Cave, William, of Worcester, yeoman 1
3597453 1866822 1866822 defendant Taillour alias Werdbrake John yeoman 586318 586318 Taillour alias Werdbrake, John, of Worcester, yeoman 0
3600401 1867769 1867769 defendant Wayte John sherman 586318 586318 Wayte, John, of Worcester, sherman 0
3601538 1868137 1868137 defendant Hambery William mercer 586318 586318 Hambery, William, of Worcester, mercer 0
3602315 1868388 1868388 defendant Wodde Richard yeoman 586318 586318 Wodde, Richard, of Worcester, yeoman 1
3602983 1868599 1868599 defendant Malpas John mercer 586318 586318 Malpas, John, of Worcester, mercer 0
3602987 1868600 1868600 defendant Malpas John mercer 586318 586318 Malpas, John, of Worcester, mercer 0
3603118 1868640 1868640 defendant Frethorn Margaret butcher 586318 586318 Frethorn, Margaret, of Worcester, widow of Frethorn, John, of Worcester, butcher 0
3603256 1868690 1868690 defendant Gyse Thomas gent 586318 586318 Gyse, Thomas, of Worcester, gent 0
3603258 1868691 1868691 defendant Gyse Thomas gent 586318 586318 Gyse, Thomas, of Worcester, gent 0
3604693 1869130 1869130 defendant Turner William pewterer 586318 586318 Turner, William, of Worcester, pewterer 0
3605863 1869500 1869500 defendant Huys John cooper 586318 586318 Huys, John, of Worcester, cooper 0
3605864 1869500 1869500 defendant Glover John cordwainer 586318 586318 Glover, John, of Worcester, cordwainer 1
3606235 1869617 1869617 defendant Burghill Richard gent 586318 586318 Burghill, Richard, of Worcester, gent 0
3606239 1869618 1869618 defendant Burghill Richard gent 586318 586318 Burghill, Richard, of Worcester, gent 0
3607502 1870005 1870005 defendant Pereson John weaver or gent 586318 586318 Pereson, John, of Worcester, weaver or gent 0
3608242 1870233 1870233 defendant Broke Joan   586318 586318 Broke, Joan, of Worcester, widow of Broke, John, of Worcester 2
3608964 1870462 1870462 defendant Frethorn John (legal representative) 586318 586318 Frethorn, John, of Worcester, grasier, executrix of 0
3608965 1870462 1870462 defendant Frethorn Margaret widow 586318 586318 Frethorn, Margaret, of Worcester, widow 1
3611738 1871334 1871334 defendant Person John weaver 586318 586318 Person, John, of Worcester, weaver 0
3614285 1872131 1872131 defendant Porter John clothman 586318 586318 Porter, John, of Worcester, clothman 0
3615669 1872546 1872546 defendant Wellys William (legal representative) 586318 586318 Wellys, William, of Worcester, executors of 0
3615670 1872546 1872546 defendant Newebold Robert butcher 586318 586318 (Newebold, Robert, of Worcester, butcher 1
3616149 1872689 1872689 defendant Hanbury William mercer 586318 586318 Hanbury, William, of Worcester, mercer 0
3616150 1872689 1872689 defendant Strynger Ralph brewer 586318 586318 Strynger, Ralph, of Worcester, brewer 1
3616151 1872689 1872689 defendant Adys Edmund shoemaker 586318 586318 Adys, Edmund, of Worcester, shoemaker 2
3617737 1873172 1873172 defendant Malpace John mercer 586318 586318 Malpace, John, of Worcester, mercer 2
3618014 1873254 1873254 defendant Spryng John skinner 586318 586318 Spryng, John, of Worcester, skinner 0
3618130 1873295 1873295 plaintiff Grafton John (legal representative) 586318 586318 Grafton, John, of Worcester, executor of 0
3618132 1873295 1873295 defendant Broun Nicholas fuller 586318 586318 Broun, Nicholas, of Worcester, fuller 0
3618473 1873403 1873403 defendant Wynnesmor Christopher brewer 586318 586318 Wynnesmor, Christopher, of Worcester, brewer 0
3619481 1873657 1873657 defendant Wyn John dyer 586318 586318 Wyn, John, of Worcester, dyer 0
3619483 1873657 1873657 defendant Welles Richard mercer 586318 586318 Welles, Richard, of Worcester, mercer 2
3619484 1873657 1873657 defendant Welles Robert mercer 586318 586318 Welles, Robert, of Worcester, mercer 3
3620616 1874026 1874026 defendant Malpas Richard weaver 586318 586318 Malpas, Richard, of Worcester, weaver 0
3620620 1874027 1874027 defendant Banam Alice widow 586318 586318 Banam, Alice, of Worcester, widow 1
3621278 1874195 1874195 defendant Gorton William yeoman 586318 586318 Gorton, William, of Worcester, yeoman 0
3621280 1874196 1874196 defendant Gorton William yeoman 586318 586318 Gorton, William, of Worcester, yeoman 0
3621314 1874209 1874209 plaintiff Muclowe William   586318 586318 Muclowe, William, of Worcester 0
3622561 1874592 1874592 defendant Malpas John mercer 586318 586318 Malpas, John, of Worcester, mercer 2
3622563 1874592 1874592 defendant Welles Richard mercer 586318 586318 Welles, Richard, of Worcester, mercer 4
3627942 1903593 1903593 defendant Rumset Gilbert fishmonger 586318 586318 Rumset, Gilbert, of Worcester, fishmonger 0
3630205 1904295 1904295 defendant Colwyke Margery widow 586318 586318 Colwyke, Margery, of Worcester, widow 0
3631846 1904769 1904769 defendant Ibull Thomas yeoman 586318 586318 Ibull, Thomas, of Worcester, yeoman 0
3632904 1905107 1905107 defendant Rodenor Thomas (legal representative) 586318 586318 Rodenor, Thomas, of Worcester, brewer, administratrix of 0
3632905 1905107 1905107 defendant Rodenor Agnes widow 586318 586318 Rodenor, Agnes, of Worcester, widow 1
3637002 1906369 1906369 defendant Basse Richard mercer 586318 586318 Basse, Richard, of Worcester, mercer 0
3637576 1906563 1906563 defendant Williams John mercer 586318 586318 Williams, John, of Worcester, mercer 0
3637577 1906563 1906563 defendant Bylford Richard draper 586318 586318 Bylford, Richard, of Worcester, draper 1
3638068 1906725 1906725 defendant Rowse Matilda widow 586318 586318 Rowse, Matilda, of Worcester, widow 0
3638570 1906879 1906879 defendant Lane Agnes widow 586318 586318 Lane, Agnes, of Worcester, widow 0
3639900 1907292 1907292 defendant de la Place Gracyon yeoman 586318 586318 de la Place, Gracyon, of Worcester, yeoman 0
3642235 1908019 1908019 defendant Robynson alias Robertson John fishmonger 586318 586318 Robynson alias Robertson, John, of Worcester, fishmonger 0
3643012 1908262 1908262 defendant Walker Hugh yeoman 586318 586318 Walker, Hugh, of Worcester, yeoman 0
3643014 1908263 1908263 defendant Walker Hugh yeoman 586318 586318 Walker, Hugh, of Worcester, yeoman 0
3643540 1908409 1908409 plaintiff Dadycote Humphrey dyer 586318 586318 Dadycote, Humphrey, of Worcester, dyer 0
3643541 1908409 1908409 defendant Radnoure Richard   586318 586318 Radnoure, Richard, of Worcester, weaver, administrators of 0
3645132 1908884 1908884 defendant Porter William clothier 586318 586318 Porter, William, of Worcester, clothier 0
3646487 1909299 1909299 defendant Rodnore Thomas (legal representative) 586318 586318 Rodnore, Thomas, of Worcester, brewer, administratrix of 0
3646488 1909299 1909299 defendant Rodnore Agnes widow 586318 586318 Rodnore, Agnes, of Worcester, widow 1
3646905 1909431 1909431 plaintiff Kery David weaver 586318 586318 Kery, David, of Worcester, weaver 0
3646906 1909431 1909431 defendant Amys Thomas clerk 586318 586318 Amys, Thomas, of Worcester, clerk 0
3647633 1909645 1909645 defendant Wodyngton Thomas clerk 586318 586318 Wodyngton, Thomas, of Worcester, clerk 0
3648849 1910028 1910028 defendant Clerk John clothmaker 586318 586318 Clerk, John, of Worcester, clothmaker 0
3651313 1910777 1910777 defendant Kynges John cordwainer 586318 586318 Kynges, John, of Worcester, cordwainer 0
3652842 1911212 1911212 defendant Belyngeham John fishmonger 586318 586318 Belyngeham, John, of Worcester, fishmonger 0
3652952 1911253 1911253 plaintiff Weston Richard mercer 586318 586318 Weston, Richard, of Worcester, mercer 0
3653812 1911452 1911452 defendant Walcarr Robert gent 586318 586318 Walcarr, Robert, of Worcester, gent 1
3653825 1911457 1911457 defendant Farley Thomas brewer 586318 586318 Farley, Thomas, of Worcester, brewer 0
3654872 1911783 1911783 defendant Hawton John gent 586318 586318 Hawton, John, of Worcester, gent 0
3654873 1911783 1911783 defendant Tanner Richard   586318 586318 Tanner, Richard, of Worcester, "walker" 1
3656170 1912178 1912178 defendant Wyton Thomas clothman 586318 586318 Wyton, Thomas, of Worcester, clothman 0
3656205 1912187 1912187 defendant Johnson William dyer 586318 586318 Johnson, William, of Worcester, dyer 1
3656452 1912264 1912264 defendant Pycraste Hugh capper 586318 586318 Pycraste, Hugh, of Worcester, capper 1
3657184 1912512 1912512 defendant Richards Thomas walker 586318 586318 Richards, Thomas, of Worcester, walker 2
3657719 1912665 1912665 defendant Lemmynster Thomas weaver 586318 586318 Lemmynster, Thomas, of Worcester, weaver 1
3657930 1912731 1912731 defendant Parker Thomas pewterer 586318 586318 Parker, Thomas, of Worcester, pewterer 0
3657931 1912731 1912731 defendant Never Oliver pewterer 586318 586318 Never, Oliver, of Worcester, pewterer 1
3658087 1912783 1912783 defendant Amyes Thomas chaplain of St Nicholas the bishop 586318 586318 Amyes, Thomas, of Worcester, chaplain of St Nicholas the bishop 0
3658923 1913052 1913052 plaintiff Frewen Roger   586318 586318 Frewen, Roger, of Worcester 0
3659644 1913271 1913271 defendant Morys William mercer 586318 586318 Morys, William, of Worcester, mercer 2
3660811 1913646 1913646 defendant Lee John yeoman 586318 586318 Lee, John, of Worcester, yeoman 1
3661713 1913942 1913942 defendant Parker Thomas yeoman 586318 586318 Parker, Thomas, of Worcester, yeoman 0
3664670 1914902 1914902 defendant More Nicholas clothier 586318 586318 More, Nicholas, of Worcester, clothier 0
3664845 1914951 1914951 defendant Lewes David clerk 586318 586318 Lewes, David, of Worcester, clerk 0
3664847 1914951 1914951 defendant Lewes Morris tailor 586318 586318 Lewes, Morris, of Worcester, tailor 2
3664855 1914953 1914953 defendant Farley Thomas brewer 586318 586318 Farley, Thomas, of Worcester, brewer 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);