names

268 rows where place_id = 592026

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606341 1869651 1869651 defendant Selers William fisher 592026 592026 Selers, William, of Baldok, fisher 0
3606342 1869651 1869651 defendant Domynyk William fisher 592026 592026 Domynyk, William, of Baldok, fisher 1
3606343 1869651 1869651 defendant Knot Thomas butcher 592026 592026 Knot, Thomas, of Baldok, butcher 2
3609122 1870511 1870511 plaintiff Wilkokkys John yeoman 592026 592026 Wilkokkys, John, of Baldok, yeoman 0
3613555 1871888 1871888 defendant Sheldon Richard (legal representative) 592026 592026 Sheldon, Richard, of Baldok, gent, executors of 0
3622624 1874605 1874605 defendant Symondes John yeoman 592026 592026 Symondes, John, of Baldok, yeoman 0
3625376 1875477 1875477 plaintiff Wilcok John   592026 592026 Wilcok, John, of Baldok 0
3625611 1875543 1875543 plaintiff Wylcok John   592026 592026 Wylcok, John, of Baldok 0
3629165 1903992 1903992 defendant Plomer Roger laborer 592026 592026 Plomer, Roger, of Baldok, laborer 0
3629860 1904192 1904192 defendant Glaunfeld alias Nevylle Richard husbandman 592026 592026 Glaunfeld alias Nevylle, Richard, of Baldok, husbandman 0
3630010 1904238 1904238 defendant Ipgrave William laborer 592026 592026 Ipgrave, William, of Baldok, laborer 1
3633641 1905332 1905332 defendant Eyer John laborer 592026 592026 Eyer, John, of Baldok, laborer 0
3637195 1906433 1906433 defendant Skrevener Richard husbandman 592026 592026 Skrevener, Richard, of Baldok, husbandman 0
3637196 1906433 1906433 defendant Ramerwyke William husbandman 592026 592026 Ramerwyke, William, of Baldok, husbandman 1
3637423 1906509 1906509 defendant Barnand William summoner 592026 592026 Barnand, William, of Baldok, summoner 2
3641569 1907821 1907821 defendant Glandfeld Richard husbandman 592026 592026 Glandfeld, Richard, of Baldok, husbandman 0
3645100 1908876 1908876 plaintiff Gate William   592026 592026 Gate, William, of Baldok 0
3645104 1908876 1908876 defendant Hyde John husbandman 592026 592026 Hyde, John, of Baldok, husbandman 3
3645641 1909036 1909036 defendant Boner Thomas shoemaker 592026 592026 Boner, Thomas, of Baldok, shoemaker 0
3649868 1910322 1910322 defendant Sawyer William sawyer 592026 592026 Sawyer, William, of Baldok, sawyer 2
3649869 1910322 1910322 defendant Plummer Roger hakneyman 592026 592026 Plummer, Roger, of Baldok, hakneyman 3
3649870 1910322 1910322 defendant Eyre John laborer 592026 592026 Eyre, John, of Baldok, laborer 4
3650066 1910388 1910388 defendant Phelyppe John mercer 592026 592026 Phelyppe, John, of Baldok, mercer 0
3650230 1910442 1910442 defendant Wylson James yeoman 592026 592026 Wylson, James, of Baldok, yeoman 0
3650232 1910443 1910443 defendant Wylson James yeoman 592026 592026 Wylson, James, of Baldok, yeoman 0
3653619 1911396 1911396 defendant Barnard William yeoman 592026 592026 Barnard, William, of Baldok, yeoman 1
3653701 1911421 1911421 plaintiff Wylson Richard   592026 592026 Wylson, Richard, of Baldok 0
3654785 1911755 1911755 plaintiff Barton Thomas miller 592026 592026 Barton, Thomas, of Baldok, miller 0
3659142 1913116 1913116 defendant Baker Robert yeoman 592026 592026 Baker, Robert, of Baldok, yeoman 0
3662914 1914314 1914314 defendant Everard John miller 592026 592026 Everard, John, of Baldok, miller 0
3666568 1915481 1915481 defendant Underwod alias Skrevener Richard husbandman 592026 592026 Underwod alias Skrevener, Richard, of Baldok, husbandman 0
3666569 1915481 1915481 defendant Sawer William sawer 592026 592026 Sawer, William, of Baldok, sawer 1
3677387 1918977 1918977 defendant Gregory Robert baker 592026 592026 Gregory, Robert, of Baldok, baker 0
3684240 1921203 1921203 defendant Plomer John butcher 592026 592026 (Plomer, John, of Baldok, butcher 1
3684242 1921203 1921203 defendant Everard John   592026 592026 Everard, John, of Baldok, "otmel maker" 3
3684384 1921247 1921247 defendant Abbot Nicholas courser 592026 592026 Abbot, Nicholas, of Baldok, courser 0
3684385 1921247 1921247 defendant Gregory Robert baker 592026 592026 Gregory, Robert, of Baldok, baker 1
3688954 1922706 1922706 defendant Eyre John husbandman 592026 592026 Eyre, John, of Baldok, husbandman 0
3688955 1922706 1922706 defendant Smyth alias Bocher Robert husbandman 592026 592026 Smyth alias Bocher, Robert, of Baldok, husbandman 1
3688956 1922706 1922706 defendant Fynche John innholder 592026 592026 Fynche, John, of Baldok, innholder 2
3688957 1922706 1922706 defendant Atkynson Peter clerk 592026 592026 Atkynson, Peter, of Baldok, clerk 3
3691145 1923393 1923393 plaintiff Hankyn or Haukyn alias Cornelys John   592026 592026 Hankyn or Haukyn alias Cornelys, John, of Baldok 0
3694599 1924513 1924513 defendant Rotheram Richard maltman 592026 592026 (Rotheram, Richard, of Baldok, maltman 1
3695880 1924946 1924946 defendant Wydney Thomas yeoman 592026 592026 Wydney, Thomas, of Baldok, yeoman 0
3695882 1924947 1924947 defendant Wylson James yeoman 592026 592026 Wylson, James, of Baldok, yeoman 0
3695884 1924948 1924948 defendant Wylson James yeoman 592026 592026 Wylson, James, of Baldok, yeoman 0
3700300 1926332 1926332 defendant Cadwall Ralph husbandman 592026 592026 Cadwall, Ralph, of Baldok, husbandman 1
3712129 1930110 1930110 defendant Mortymer John husbandman 592026 592026 Mortymer, John, of Baldok, husbandman 4
3718717 1932132 1932132 plaintiff Gatys William   592026 592026 Gatys, William, of Baldok 0
3718721 1932133 1932133 plaintiff Gatys William   592026 592026 Gatys, William, of Baldok 0
3741164 1939098 1939098 plaintiff Smyth John   592026 592026 Smyth, John, of Baldok 0
3762456 1945901 1945901 defendant Horsley John shoemaker 592026 592026 Horsley, John, of Baldok, shoemaker 0
3764457 1946545 1946545 defendant Gregory Robert baker 592026 592026 Gregory, Robert, of Baldok, baker 0
3777977 1950823 1950823 defendant Gregory Robert baker 592026 592026 Gregory, Robert, of Baldok, baker 0
3782624 1952306 1952306 defendant Hankym Robert yeoman 592026 592026 Hankym, Robert, of Baldok, yeoman 0
3782626 1952307 1952307 defendant Horsley John husbandman 592026 592026 Horsley, John, of Baldok, husbandman 0
3782736 1952345 1952345 plaintiff Ireland John husbandman 592026 592026 Ireland, John, of Baldok, husbandman 0
3798866 1957561 1957561 defendant Gregory Robert baker 592026 592026 Gregory, Robert, of Baldok, baker 0
3803468 1958988 1958988 defendant Wydney Thomas husbandman 592026 592026 Wydney, Thomas, of Baldok, husbandman 0
3820865 1964419 1964419 defendant Wyddeney Thomas husbandman 592026 592026 Wyddeney, Thomas, of Baldok, husbandman 0
3820867 1964420 1964420 defendant Wyddeney Thomas husbandman 592026 592026 Wyddeney, Thomas, of Baldok, husbandman 0
3823212 1965173 1965173 defendant Bowlys John esq 592026 592026 Bowlys, John, of Baldok, esq 0
3863543 1978002 1978002 defendant Hankyn John husbandman 592026 592026 Hankyn, John, of Baldok, husbandman 0
3863544 1978002 1978002 defendant Irelond John husbandman 592026 592026 Irelond, John, of Baldok, husbandman 1
3863545 1978002 1978002 defendant Browne alias Heyriche John tailor 592026 592026 Browne alias Heyriche, John, of Baldok, tailor 2
3863546 1978002 1978002 defendant Candell James husbandman 592026 592026 Candell, James, of Baldok, husbandman 3
3863547 1978002 1978002 defendant Newman Thomas laborer 592026 592026 Newman, Thomas, of Baldok, laborer 4
3880002 1983572 1983572 plaintiff Parker Richard   592026 592026 Parker, Richard,of Baldok 0
3880003 1983572 1983572 defendant Steward Nicholas innkeeper 592026 592026 Steward, Nicholas, of Baldok, innkeeper 0
3905056 1991954 1991954 plaintiff Irelond John   592026 592026 Irelond, John, of Baldok 1
3921928 1997680 1997680 plaintiff Randall James (legal representative) 592026 592026 Randall, James, of Baldok, gent, executors of 0
3950856 2007364 2007364 plaintiff Godfrey Robert   592026 592026 Godfrey, Robert, of Baldok 0
3958416 2010016 2010016 plaintiff Rocheford John maltster 592026 592026 Rocheford, John, of Baldok, maltster 0
4417550 2170376 2170376 defendant Coupere John   592026 592026 Coupere, John, of Baldok 0
4420805 2171404 2171404 plaintiff Catel Margaret   592026 592026 Catel, Margaret, of Baldok, formerly wife of John 0
4422540 2171910 2171910 defendant Waleys John   592026 592026 Waleys, John, of Baldok 0
4433118 2175110 2175110 defendant Barat Thomas   592026 592026 Barat, Thomas, of Baldok 0
4433251 2175151 2175151 defendant Barat John   592026 592026 Barat, John, of Baldok 0
4444230 2183179 2183179 plaintiff Clifton Richard, junior   592026 592026 Clifton, Richard, junior, of Baldok 0
4444231 2183179 2183179 defendant Semon John   592026 592026 Semon, John, of Baldok 0
4444258 2183190 2183190 plaintiff Clyfton Richard, junior   592026 592026 Clyfton, Richard, junior, of Baldok, on his own account 0
4444259 2183190 2183190 defendant Gernoun John   592026 592026 Gernoun, John, of Baldok 0
4457489 2187355 2187355 plaintiff Pertrych John   592026 592026 Pertrych, John, of Baldok 0
4463009 2189134 2189134 defendant Vynter William   592026 592026 Vynter, William, of Baldok 1
4463010 2189134 2189134 defendant Basset Richard   592026 592026 Basset, Richard, of Baldok 2
4463011 2189134 2189134 defendant Ropere Robert   592026 592026 Ropere, Robert, of Baldok 3
4463014 2189135 2189135 defendant Vynter William   592026 592026 Vynter, William, of Baldok 1
4463015 2189135 2189135 defendant Basset Richard   592026 592026 Basset, Richard, of Baldok 2
4463016 2189135 2189135 defendant Rope Robert   592026 592026 Rope, Robert, of Baldok 3
4474702 2192752 2192752 plaintiff Dun Hugh   592026 592026 Dun, Hugh, of Baldok 0
4474704 2192753 2192753 plaintiff Dun Hugh   592026 592026 Dun, Hugh, of Baldok 0
4483307 2195479 2195479 defendant Draper John   592026 592026 Draper, John, of Baldok 1
4493037 2198521 2198521 plaintiff atte Boure John   592026 592026 atte Boure, John, of Baldok 0
4496506 2199583 2199583 plaintiff Coupere John   592026 592026 Coupere, John, of Baldok 0
4496507 2199583 2199583 defendant Everard John   592026 592026 Everard, John, of Baldok 0
4514049 2204819 2204819 defendant Clifton Richard   592026 592026 Clifton, Richard, of Baldok 0
4552752 2216810 2216810 defendant Aynho John   592026 592026 Aynho, John, of Baldok, formerly vicar 3
4552763 2216812 2216812 defendant Aynho John   592026 592026 Aynho, John, of Baldok, formerly vicar 4
4607867 2233576 2233576 defendant Bate William butcher 592026 592026 Bate, William, of Baldok, butcher 0
4615905 2235971 2235971 defendant Beneworth Richard   592026 592026 Beneworth, Richard, of Baldok 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);