names

913 rows where place_id = 585934

✎ 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
3587529 1863748 1863748 defendant Moys John butcher 585934 585934 Moys, John, of Becclys, butcher 0
3587898 1863866 1863866 defendant Horne John husbandman 585934 585934 Horne, John, of Becclys, husbandman 0
3589222 1864271 1864271 defendant Boteswayn Richard baker 585934 585934 Boteswayn, Richard, of Becclys, baker 0
3589912 1864485 1864485 defendant Seyve Robert   585934 585934 Seyve, Robert, of Becclys, mason 0
3594112 1865801 1865801 defendant Moyse John butcher 585934 585934 Moyse, John, of Becclys, butcher 1
3596138 1866420 1866420 defendant Wryght William butcher 585934 585934 Wryght, William, of Becclys, butcher 3
3596139 1866420 1866420 defendant Wylde Thomas butcher 585934 585934 Wylde, Thomas, of Becclys, butcher 4
3596563 1866560 1866560 defendant Eye John butcher 585934 585934 Eye, John, of Becclys, butcher 1
3597033 1866696 1866696 defendant Brundale William husbandman 585934 585934 Brundale, William, of Becclys, husbandman 0
3597034 1866696 1866696 defendant Byrlyngham Thomas raffman 585934 585934 Byrlyngham, Thomas, of Becclys, raffman 1
3599618 1867520 1867520 defendant Deryng Robert butcher 585934 585934 Deryng, Robert, of Becclys, butcher 0
3599619 1867520 1867520 defendant Marley John shoemaker 585934 585934 Marley, John, of Becclys, shoemaker 1
3600323 1867747 1867747 defendant Wryght William butcher 585934 585934 Wryght, William, of Becclys, butcher 2
3600324 1867747 1867747 defendant Humfray John butcher 585934 585934 Humfray, John, of Becclys, butcher 3
3600328 1867748 1867748 defendant Wright William butcher 585934 585934 Wright, William, of Becclys, butcher 1
3600697 1867869 1867869 defendant Burnham Henry tailor 585934 585934 Burnham, Henry, of Becclys, tailor 0
3606617 1869742 1869742 defendant Hawe Robert   585934 585934 Hawe, Robert, of Becclys, sieve maker 3
3606823 1869804 1869804 defendant Burnham Thomas pedder 585934 585934 Burnham, Thomas, of Becclys, pedder 1
3606825 1869804 1869804 defendant Grene William potter 585934 585934 Grene, William, of Becclys, potter 3
3608762 1870405 1870405 defendant Moys John butcher 585934 585934 Moys, John, of Becclys, butcher 0
3608970 1870463 1870463 defendant Laurence William yeoman 585934 585934 Laurence, William, of Becclys, yeoman 3
3609201 1870539 1870539 defendant Moyse John butcher 585934 585934 Moyse, John, of Becclys, butcher 0
3609261 1870558 1870558 defendant Draper John tailor 585934 585934 Draper, John, of Becclys, tailor 5
3609272 1870561 1870561 defendant Laurence William yeoman 585934 585934 Laurence, William, of Becclys, yeoman 2
3609278 1870562 1870562 defendant Laurence William yeoman 585934 585934 Laurence, William, of Becclys, yeoman 2
3617092 1872970 1872970 defendant Baker Walter husbandman 585934 585934 Baker, Walter, of Becclys, husbandman 1
3617093 1872970 1872970 defendant Dowe Henry barker 585934 585934 Dowe, Henry, of Becclys, barker 2
3617188 1873000 1873000 defendant Sparchet Geoffrey husbandman 585934 585934 Sparchet, Geoffrey, of Becclys, husbandman 0
3619011 1873556 1873556 defendant Herrygate John carpenter 585934 585934 Herrygate, John, of Becclys, carpenter 0
3621961 1874411 1874411 defendant Neve Thomas shoemaker 585934 585934 Neve, Thomas, of Becclys, shoemaker 1
3621965 1874412 1874412 defendant Neve Thomas shoemaker 585934 585934 Neve, Thomas, of Becclys, shoemaker 1
3622718 1874633 1874633 defendant Grene William potter 585934 585934 Grene, William, of Becclys, potter 3
3625557 1875529 1875529 defendant Eye or Gye John butcher 585934 585934 Eye or Gye, John, of Becclys, butcher 3
3625559 1875529 1875529 defendant Davy John husbandman 585934 585934 (Davy, John, of Becclys, husbandman 5
3625560 1875529 1875529 defendant Laurence Alice widow 585934 585934 Laurence, Alice, of Becclys, widow 6
3626282 1903077 1903077 plaintiff Askeby Thomas (legal representative) 585934 585934 Askeby, Thomas, of Becclys, administratrix of 0
3626742 1903209 1903209 defendant Broke Leonard tailor 585934 585934 Broke, Leonard, of Becclys, tailor 0
3627089 1903333 1903333 defendant Boure Thomas painter 585934 585934 Boure, Thomas, of Becclys, painter 0
3628658 1903838 1903838 defendant Grey Alexander baker 585934 585934 Grey, Alexander, of Becclys, baker 1
3629057 1903966 1903966 defendant Calthorp Robert butcher 585934 585934 Calthorp, Robert, of Becclys, butcher 0
3630441 1904353 1904353 defendant Garard John scrivener 585934 585934 Garard, John, of Becclys, scrivener 2
3631394 1904630 1904630 defendant Fraunceys Edmund yeoman 585934 585934 Fraunceys, Edmund, of Becclys, yeoman 0
3633334 1905241 1905241 defendant Notte John   585934 585934 Notte, John, of Becclys, worsted weaver 1
3636413 1906178 1906178 defendant Stanfeld Richard yeoman 585934 585934 Stanfeld, Richard, of Becclys, yeoman 0
3636539 1906223 1906223 plaintiff Robardys Richard   585934 585934 Robardys, Richard, of Becclys 0
3638263 1906787 1906787 defendant Moyse Reginald butcher 585934 585934 Moyse, Reginald, of Becclys, butcher 3
3639527 1907171 1907171 defendant More William shragger 585934 585934 More, William, of Becclys, shragger 0
3639529 1907171 1907171 defendant Calthorp Robert butcher 585934 585934 Calthorp, Robert, of Becclys, butcher 2
3639593 1907194 1907194 defendant Whyte John thatcher 585934 585934 Whyte, John, of Becclys, thatcher 0
3640433 1907439 1907439 defendant Calthorp Robert, senior butcher 585934 585934 Calthorp, Robert, senior, of Becclys, butcher 0
3641915 1907925 1907925 defendant Goodlard Simon pedder 585934 585934 Goodlard, Simon, of Becclys, pedder 0
3642760 1908184 1908184 defendant Holte Hugh (legal representative) 585934 585934 Holte, Hugh, of Becclys, embroiderer, executor of 0
3642761 1908184 1908184 defendant Burnham Thomas tailor 585934 585934 Burnham, Thomas, of Becclys, tailor 1
3646641 1909355 1909355 defendant Calthorp Robert, senior butcher 585934 585934 Calthorp, Robert, senior, of Becclys, butcher 0
3646779 1909401 1909401 defendant Hyll William yeoman 585934 585934 Hyll, William, of Becclys, yeoman 0
3650025 1910376 1910376 defendant Stanfeld Richard yeoman 585934 585934 Stanfeld, Richard, of Becclys, yeoman 1
3650224 1910439 1910439 defendant Dodde John yeoman 585934 585934 Dodde, John, of Becclys, yeoman 1
3652596 1911148 1911148 defendant Belynger Peter husbandman 585934 585934 Belynger, Peter, of Becclys, husbandman 0
3652598 1911148 1911148 defendant Colte Henry tanner 585934 585934 Colte, Henry, of Becclys, tanner 2
3653209 1911339 1911339 defendant Chidley Katherine widow 585934 585934 Chidley, Katherine, of Becclys, widow 0
3653212 1911340 1911340 defendant Frede John dyer 585934 585934 Frede, John, of Becclys, dyer 0
3653214 1911341 1911341 defendant Sele Robert husbandman 585934 585934 Sele, Robert, of Becclys, husbandman 0
3653216 1911342 1911342 defendant Wance Henry laborer 585934 585934 Wance, Henry, of Becclys, laborer 0
3653540 1911374 1911374 defendant Colt Henry husbandman 585934 585934 Colt, Henry, of Becclys, husbandman 0
3653648 1911405 1911405 defendant Prykyll Walter husbandman 585934 585934 Prykyll, Walter, of Becclys, husbandman 0
3667565 1915798 1915798 defendant Vauwse Henry laborer 585934 585934 Vauwse, Henry, of Becclys, laborer 0
3670993 1916900 1916900 defendant Fraunceys Edmund yeoman 585934 585934 Fraunceys, Edmund, of Becclys, yeoman 0
3670994 1916900 1916900 defendant Burnham Thomas tailor 585934 585934 Burnham, Thomas, of Becclys, tailor 1
3673271 1917656 1917656 defendant Skynner Thomas glover 585934 585934 Skynner, Thomas, of Becclys, glover 0
3673272 1917656 1917656 defendant Gerrard John glover 585934 585934 Gerrard, John, of Becclys, glover 1
3673869 1917860 1917860 defendant Benselyn Richard   585934 585934 Benselyn, Richard, of Becclys, minstrel 0
3677257 1918934 1918934 plaintiff Leeke John yeoman 585934 585934 Leeke, John, of Becclys, yeoman 0
3678416 1919303 1919303 defendant Calthorpe Robert, senior butcher 585934 585934 Calthorpe, Robert, senior, of Becclys, butcher 0
3678418 1919303 1919303 defendant Moundforth John laborer 585934 585934 Moundforth, John, of Becclys, laborer 2
3678662 1919390 1919390 defendant Tyde Richard   585934 585934 Tyde, Richard, of Becclys, collar maker 0
3678663 1919390 1919390 defendant Colydore William   585934 585934 Colydore, William, of Becclys, groom 1
3680244 1919893 1919893 plaintiff Rede William merchant 585934 585934 Rede, William, of Becclys, merchant 0
3681199 1920202 1920202 defendant Calthorp Robert butcher 585934 585934 Calthorp, Robert, of Becclys, butcher 0
3681393 1920266 1920266 defendant Trette John tanner 585934 585934 Trette, John, of Becclys, tanner 1
3682487 1920626 1920626 plaintiff Tebold John   585934 585934 Tebold, John, of Becclys 0
3684249 1921206 1921206 defendant Burnham John clerk 585934 585934 Burnham, John, of Becclys, clerk 0
3684251 1921207 1921207 defendant Shanke John weaver 585934 585934 Shanke, John, of Becclys, weaver 0
3689946 1923015 1923015 plaintiff Fraunces Gregory   585934 585934 Fraunces, Gregory, of Becclys 0
3690220 1923100 1923100 defendant Wryght Michael keelman 585934 585934 Wryght, Michael, of Becclys, keelman 0
3690540 1923208 1923208 defendant Palmere William husbandman 585934 585934 Palmere, William, of Becclys, husbandman 0
3691173 1923402 1923402 defendant Wylde Thomas butcher 585934 585934 Wylde, Thomas, of Becclys, butcher 0
3691176 1923402 1923402 defendant Calthorp Robert butcher 585934 585934 Calthorp, Robert, of Becclys, butcher 3
3691177 1923402 1923402 defendant Taylour Thomas husbandman 585934 585934 Taylour, Thomas, of Becclys, husbandman 4
3695771 1924908 1924908 defendant More William shragger 585934 585934 More, William, of Becclys, shragger 0
3695772 1924908 1924908 defendant Sarson Nicholas tailor 585934 585934 Sarson, Nicholas, of Becclys, tailor 1
3695773 1924908 1924908 defendant Ingott Thomas, junior   585934 585934 Ingott, Thomas, junior, of Becclys, collar maker 2
3695783 1924912 1924912 defendant Nytynghale William husbandman 585934 585934 Nytynghale, William, of Becclys, husbandman 1
3695784 1924913 1924913 plaintiff Rede William, senior merchant 585934 585934 Rede, William, senior, of Becclys, merchant 0
3695785 1924913 1924913 defendant Rolff Henry   585934 585934 Rolff, Henry, of Becclys, worsted weaver 0
3695877 1924945 1924945 defendant Kyppyng Nicholas laborer 585934 585934 Kyppyng, Nicholas, of Becclys, laborer 2
3697457 1925424 1925424 defendant Frede John fuller 585934 585934 Frede, John, of Becclys, fuller 0
3697458 1925424 1925424 defendant Lesslyn Thomas husbandman 585934 585934 Lesslyn, Thomas, of Becclys, husbandman 1
3697629 1925483 1925483 defendant Symmys Robert husbandman 585934 585934 Symmys, Robert, of Becclys, husbandman 0
3698160 1925651 1925651 defendant Calthorp Robert butcher 585934 585934 Calthorp, Robert, of Becclys, butcher 0
3700436 1926374 1926374 defendant Cove Robert   585934 585934 Cove, Robert, of Becclys, court holder 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);