names

176 rows where place_id = 597465

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608989 1870468 1870468 defendant Rede William   597465 597465 Rede, William, of Ely, Cams, yeoman, servant of Grey, William 3
3628686 1903846 1903846 defendant Shenkwyn alias Brewer John yeoman 597465 597465 Shenkwyn alias Brewer, John, of Ely, Cams, yeoman 0
3635856 1906013 1906013 defendant Shunkwyn John brewer 597465 597465 Shunkwyn, John, of Ely, Cams, brewer 0
3636173 1906101 1906101 defendant Thompson Richard yeoman 597465 597465 Thompson, Richard, of Ely, Cams, yeoman 3
3647128 1909494 1909494 defendant Bryon John baker 597465 597465 Bryon, John, of Ely, Cams, baker 0
3649497 1910230 1910230 defendant Laurens Richard waterman 597465 597465 Laurens, Richard, of Ely, Cams, waterman 4
3650849 1910631 1910631 defendant Chapman William yeoman 597465 597465 Chapman, William, of Ely, Cams, yeoman 0
3669489 1916396 1916396 defendant Chirche John yeoman 597465 597465 Chirche, John, of Ely, Cams, yeoman 2
3683336 1920912 1920912 defendant Shynkwyn John brewer 597465 597465 Shynkwyn, John, of Ely, Cams, brewer 0
3690139 1923074 1923074 defendant Middylton Charles husbandman 597465 597465 (Middylton, Charles, of Ely, Cams, husbandman 1
3704596 1927726 1927726 defendant Middelton Charles gent 597465 597465 Middelton, Charles, of Ely, Cams, gent 0
3711469 1929893 1929893 defendant Brown Thomas laborer 597465 597465 Brown, Thomas, of Ely, Cams, laborer 1
3711584 1929932 1929932 defendant Redle Lancelot innholder 597465 597465 Redle, Lancelot, of Ely, Cams, innholder 0
3713905 1930647 1930647 defendant Greye John, junior waterman 597465 597465 Greye, John, junior, of Ely, Cams, waterman 0
3715043 1931001 1931001 defendant Slowe James brewer 597465 597465 Slowe, James, of Ely, Cams, brewer 0
3730011 1935630 1935630 defendant Humfrey Edmund fishmonger 597465 597465 Humfrey, Edmund, of Ely, Cams, fishmonger 1
3752538 1942720 1942720 defendant Alen John   597465 597465 Alen, John, of Ely, Cams, "pekemonger" 2
3757216 1944239 1944239 defendant Craye John, junior yeoman 597465 597465 Craye, John, junior, of Ely, Cams, yeoman 1
3781108 1951828 1951828 defendant Wolmaw Robert yeoman 597465 597465 Wolmaw, Robert, of Ely, Cams, yeoman 1
3781560 1951968 1951968 defendant Day John butcher 597465 597465 Day, John, of Ely, Cams, butcher 1
3783271 1952520 1952520 defendant Mershe Robert saddler 597465 597465 Mershe, Robert, of Ely, Cams, saddler 0
3790536 1954864 1954864 defendant Johnson Jamon yeoman 597465 597465 Johnson, Jamon, of Ely, Cams, yeoman 0
3802141 1958565 1958565 defendant Person William yeoman 597465 597465 (Person, William, of Ely, Cams, yeoman 1
3847455 1972766 1972766 defendant Megges Thomas gent 597465 597465 Megges, Thomas, of Ely, Cams, gent 3
3847629 1972828 1972828 defendant Megges Thomas gent 597465 597465 Megges, Thomas, of Ely, Cams, gent 3
3847842 1972901 1972901 defendant Sygerson Thomas yeoman 597465 597465 Sygerson, Thomas, of Ely, Cams, yeoman 0
3877364 1982675 1982675 defendant Sygarson Thomas yeoman 597465 597465 Sygarson, Thomas, of Ely, Cams, yeoman 0
3881676 1984118 1984118 defendant Myddylton Robert skinner 597465 597465 Myddylton, Robert, of Ely, Cams, skinner 0
3885099 1985275 1985275 defendant Alyn Thomas draper 597465 597465 Alyn, Thomas, of Ely, Cams, draper 0
3886520 1985744 1985744 defendant Dey William butcher 597465 597465 Dey, William, of Ely, Cams, butcher 0
3886527 1985745 1985745 defendant Dey William butcher 597465 597465 Dey, William, of Ely, Cams, butcher 0
3889440 1986700 1986700 plaintiff Gooderik John esq 597465 597465 Gooderik, John, of Ely, Cams, esq 0
3895698 1988766 1988766 defendant Tye Christopher gent 597465 597465 Tye, Christopher, of Ely, Cams, gent 0
3897981 1989532 1989532 defendant Aleyn Thomas draper 597465 597465 Aleyn, Thomas, of Ely, Cams, draper 1
3944237 2005090 2005090 defendant Tye Christopher gent 597465 597465 Tye, Christopher, of Ely, Cams, gent 0
3950938 2007396 2007396 plaintiff Goodricke Thomas gent 597465 597465 Goodricke, Thomas, of Ely, Cams, gent 0
3974952 2015805 2015805 defendant Buck Robert chapman 597465 597465 Buck, Robert, of Ely, Cams, chapman 1
3979007 2017247 2017247 defendant Utley William clerk 597465 597465 Utley, William, of Ely, Cams, clerk 0
3982810 2018625 2018625 defendant Love Richard yeoman 597465 597465 Love, Richard, of Ely, Cams, yeoman 0
4000248 2024859 2024859 plaintiff Goodrycke Thomas gent 597465 597465 Goodrycke, Thomas, of Ely, Cams, gent 0
4027560 2034503 2034503 defendant Strynger Richard husbandman or innkeeper 597465 597465 Strynger, Richard, of Ely, Cams, husbandman or innkeeper 0
4027562 2034504 2034504 defendant Strynger Richard husbandman or innkeeper 597465 597465 Strynger, Richard, of Ely, Cams, husbandman or innkeeper 0
4033792 2036735 2036735 defendant Slater Geoffrey yeoman 597465 597465 Slater, Geoffrey, of Ely, Cams, yeoman 0
4036177 2037622 2037622 defendant Moyre Robert waterman 597465 597465 Moyre, Robert, of Ely, Cams, waterman 4
4040221 2039007 2039007 defendant Smythe William chapman 597465 597465 Smythe, William, of Ely, Cams, chapman 0
4048258 2041818 2041818 defendant Christian Thomas yeoman 597465 597465 Christian, Thomas, of Ely, Cams, yeoman 0
4048260 2041819 2041819 defendant Christian Thomas yeoman 597465 597465 Christian, Thomas, of Ely, Cams, yeoman 0
4058725 2045513 2045513 defendant Keyesbye Richard husbandman 597465 597465 Keyesbye, Richard, of Ely, Cams, husbandman 0
4062990 2047067 2047067 defendant Rudston John gent 597465 597465 Rudston, John, of Ely, Cams, gent 0
4078160 2052492 2052492 defendant Flower Lancelot husbandman 597465 597465 Flower, Lancelot, of Ely, Cams, husbandman 6
4089105 2056398 2056398 defendant Brakyn Richard gent 597465 597465 Brakyn, Richard, of Ely, Cams, gent 0
4093996 2058181 2058181 defendant Payne Robert husbandman 597465 597465 Payne, Robert, of Ely, Cams, husbandman 0
4095461 2058700 2058700 defendant Baskyn Richard esq 597465 597465 Baskyn, Richard, of Ely, Cams, esq 0
4103821 2061640 2061640 defendant Brakyn Robert esq 597465 597465 Brakyn, Robert, of Ely, Cams, esq 1
4112183 2064614 2064614 defendant Anger Nicholas yeoman 597465 597465 Anger, Nicholas, of Ely, Cams, yeoman 0
4119119 2067128 2067128 defendant Sayer Henry yeoman 597465 597465 Sayer, Henry, of Ely, Cams, yeoman 1
4122520 2068361 2068361 defendant Darnell Thomas, senior chapman 597465 597465 Darnell, Thomas, senior, of Ely, Cams, chapman 0
4132439 2071918 2071918 defendant Darnell Thomas, senior draper 597465 597465 Darnell, Thomas, senior, of Ely, Cams, draper 0
4139695 2074558 2074558 defendant Dalton Thomas yeoman 597465 597465 Dalton, Thomas, of Ely, Cams, yeoman 0
4147121 2077136 2077136 defendant Kysbye Richard yeoman 597465 597465 Kysbye, Richard, of Ely, Cams, yeoman 0
4147129 2077137 2077137 defendant Sylvertopp Robert yeoman 597465 597465 Sylvertopp, Robert, of Ely, Cams, yeoman 0
4168928 2084626 2084626 defendant Maldyn Andrew yeoman 597465 597465 Maldyn, Andrew, of Ely, Cams, yeoman 0
4182466 2089346 2089346 defendant Flower Lancelot yeoman 597465 597465 Flower, Lancelot, of Ely, Cams, yeoman 0
4185761 2090520 2090520 defendant Cheyney John gent 597465 597465 Cheyney, John, of Ely, Cams, gent 0
4201801 2096171 2096171 defendant Rudston Thomas gent 597465 597465 Rudston, Thomas, of Ely, Cams, gent 18
4206783 2097915 2097915 defendant Jurden William yeoman 597465 597465 Jurden, William, of Ely, Cams, yeoman 2
4219317 2102252 2102252 defendant Brakin Richard esq 597465 597465 Brakin, Richard, of Ely, Cams, esq 0
4227792 2105202 2105202 defendant Jarvens Thomas gent 597465 597465 Jarvens, Thomas, of Ely, Cams, gent 0
4228612 2105491 2105491 defendant Brakyn Richard esq 597465 597465 Brakyn, Richard, of Ely, Cams, esq 0
4233253 2107143 2107143 defendant Olcorne or Oldcorne William draper 597465 597465 Olcorne or Oldcorne, William, of Ely, Cams, draper 0
4237099 2108558 2108558 defendant Brakyn Richard esq 597465 597465 Brakyn, Richard, of Ely, Cams, esq 0
4244212 2111050 2111050 defendant Massye Nicholas gent 597465 597465 Massye, Nicholas, of Ely, Cams, gent 0
4255354 2114787 2114787 defendant Massye Nicholas gent 597465 597465 Massye, Nicholas, of Ely, Cams, gent 0
4255518 2114834 2114834 defendant Chadborn John shoemaker 597465 597465 Chadborn, John, of Ely, Cams, shoemaker 0
4256364 2115097 2115097 defendant Blake Thomas draper 597465 597465 Blake, Thomas, of Ely, Cams, draper 0
4256468 2115131 2115131 defendant Jarvies Thomas gent 597465 597465 Jarvies, Thomas, of Ely, Cams, gent 0
4267914 2118904 2118904 defendant Chadborne John shoemaker 597465 597465 Chadborne, John, of Ely, Cams, shoemaker 0
4270549 2119731 2119731 defendant Braken Richard esq 597465 597465 Braken, Richard, of Ely, Cams, esq 0
4278186 2122306 2122306 defendant Lewys Dorothy widow 597465 597465 Lewys, Dorothy, of Ely, Cams, widow 0
4287166 2125467 2125467 defendant Sibley Robert yeoman 597465 597465 Sibley, Robert, of Ely, Cams, yeoman 0
4288055 2125775 2125775 defendant Bowell Thomas gent 597465 597465 Bowell, Thomas, of Ely, Cams, gent 0
4289628 2126358 2126358 defendant Arkinstall Richard gent 597465 597465 Arkinstall, Richard, of Ely, Cams, gent 0
4290651 2126714 2126714 defendant Lewys Dorothy widow 597465 597465 Lewys, Dorothy, of Ely, Cams, widow 1
4290654 2126715 2126715 defendant Lewys Dorothy widow 597465 597465 Lewys, Dorothy, of Ely, Cams, widow 1
4291535 2127046 2127046 defendant Nicholas John miller 597465 597465 Nicholas, John, of Ely, Cams, miller 0
4295119 2128338 2128338 defendant Bradford Nicholas haberdasher 597465 597465 Bradford, Nicholas, of Ely, Cams, haberdasher 0
4298443 2129545 2129545 defendant Arkinstall Richard gent 597465 597465 Arkinstall, Richard, of Ely, Cams, gent 0
4302087 2130852 2130852 defendant Blake Thomas draper 597465 597465 Blake, Thomas, of Ely, Cams, draper 0
4306428 2132388 2132388 defendant Lewys Dorothy widow 597465 597465 Lewys, Dorothy, of Ely, Cams, widow 1
4309223 2133378 2133378 defendant Brakyn Richard esq 597465 597465 Brakyn, Richard, of Ely, Cams, esq 0
4315102 2135396 2135396 defendant Lewys Dorothy widow 597465 597465 Lewys, Dorothy, of Ely, Cams, widow 0
4327336 2139466 2139466 defendant Massye Nicholas gent 597465 597465 Massye, Nicholas, of Ely, Cams, gent 0
4333766 2141574 2141574 defendant Arkinstall Richard gent 597465 597465 Arkinstall, Richard, of Ely, Cams, gent 0
4336995 2142667 2142667 defendant Blake Thomas draper 597465 597465 Blake, Thomas, of Ely, Cams, draper 0
4360286 2150848 2150848 defendant Blake Thomas draper 597465 597465 Blake, Thomas, of Ely, Cams, draper 0
4361034 2151118 2151118 defendant Arthure Richard yeoman 597465 597465 Arthure, Richard, of Ely, Cams, yeoman 0
4368024 2153616 2153616 defendant Daye John yeoman 597465 597465 Daye, John, of Ely, Cams, yeoman 0
4394248 2162677 2162677 defendant Brackyn Richard esq 597465 597465 Brackyn, Richard, of Ely, Cams, esq 0
4400289 2164689 2164689 defendant Blake Thomas draper 597465 597465 Blake, Thomas, of Ely, Cams, draper 0
4402248 2165338 2165338 defendant Pyggott Michael gent 597465 597465 Pyggott, Michael, of Ely, Cams, gent 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);