names

616 rows where place_id = 596298

✎ 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
3624083 1875062 1875062 defendant Wode Robert, junior yeoman 596298 596298 Wode, Robert, junior, of Beccles, yeoman 0
3624084 1875062 1875062 defendant Neve Thomas shoemaker 596298 596298 Neve, Thomas, of Beccles, shoemaker 1
3654298 1911603 1911603 defendant Broke Leonard tailor 596298 596298 Broke, Leonard, of Beccles, tailor 0
3660145 1913433 1913433 defendant Powle Robert   596298 596298 Powle, Robert, of Beccles, ship wright 2
3660195 1913449 1913449 defendant Fulcher Thomas   596298 596298 Fulcher, Thomas, of Beccles, shoe maker 2
3663642 1914561 1914561 plaintiff Pery Robert (legal representative) 596298 596298 Pery, Robert, of Beccles, woolman, executors of 0
3664919 1914973 1914973 defendant Sekgly John yeoman 596298 596298 Sekgly, John, of Beccles, yeoman 1
3666709 1915533 1915533 defendant Brunwyn Robert husbandman 596298 596298 Brunwyn, Robert, of Beccles, husbandman 7
3667561 1915796 1915796 defendant Shanke John weaver 596298 596298 Shanke, John, of Beccles, weaver 1
3667563 1915797 1915797 defendant Vanse Henry laborer 596298 596298 Vanse, Henry, of Beccles, laborer 0
3667567 1915799 1915799 defendant Vawce Henry laborer 596298 596298 Vawce, Henry, of Beccles, laborer 0
3683062 1920817 1920817 defendant Calthorp Robert butcher 596298 596298 Calthorp, Robert, of Beccles, butcher 0
3705678 1928058 1928058 defendant Townesend John butcher 596298 596298 Townesend, John, of Beccles, butcher 0
3820843 1964410 1964410 plaintiff Wolcy Robert   596298 596298 Wolcy, Robert, of Beccles 1
3835382 1969004 1969004 defendant Grene Richard yeoman 596298 596298 Grene, Richard, of Beccles, yeoman 1
3835384 1969005 1969005 defendant Grene Robert yeoman 596298 596298 Grene, Robert, of Beccles, yeoman 0
3857341 1975928 1975928 defendant Cove Robert gent 596298 596298 Cove, Robert, of Beccles, gent 0
3869567 1980062 1980062 defendant Tounesend John butcher 596298 596298 Tounesend, John, of Beccles, butcher 1
3902265 1990993 1990993 defendant Derik alias Symond Richard miller 596298 596298 Derik alias Symond, Richard, of Beccles, miller 1
3902266 1990993 1990993 defendant Laurence Richard yeoman 596298 596298 Laurence, Richard, of Beccles, yeoman 2
3912049 1994353 1994353 plaintiff Sherman Gilbert   596298 596298 (Sherman, Gilbert, of Beccles 1
3917413 1996182 1996182 defendant Broun Thomas yeoman 596298 596298 Broun, Thomas, of Beccles, yeoman 3
3923142 1998046 1998046 defendant Laurence William yeoman 596298 596298 Laurence, William, of Beccles, yeoman 0
3927916 1999676 1999676 plaintiff Baron Robert   596298 596298 Baron, Robert, of Beccles 0
3929256 2000127 2000127 defendant Wryght Martin yeoman 596298 596298 Wryght, Martin, of Beccles, yeoman 0
3929720 2000277 2000277 defendant Tower Robert fisherman 596298 596298 Tower, Robert, of Beccles, fisherman 0
3930221 2000457 2000457 defendant Wade Richard butcher 596298 596298 Wade, Richard, of Beccles, butcher 0
3931307 2000760 2000760 defendant Platfote William yeoman 596298 596298 Platfote, William, of Beccles, yeoman 0
3932745 2001253 2001253 defendant Smyth Robert barber 596298 596298 Smyth, Robert, of Beccles, barber 0
3936092 2002393 2002393 plaintiff Love Robert fuller of cloth 596298 596298 Love, Robert, of Beccles, fuller of cloth 0
3936093 2002393 2002393 defendant Mannyng Robert yeoman 596298 596298 Mannyng, Robert, of Beccles, yeoman 0
3936213 2002437 2002437 defendant Wade Richard butcher 596298 596298 Wade, Richard, of Beccles, butcher 0
3938931 2003354 2003354 defendant Rede John merchant 596298 596298 Rede, John, of Beccles, merchant 1
3938942 2003357 2003357 defendant Rede John merchant 596298 596298 Rede, John, of Beccles, merchant 1
3938946 2003359 2003359 defendant Smythe Robert barber 596298 596298 Smythe, Robert, of Beccles, barber 0
3940146 2003722 2003722 defendant Platfote William gent 596298 596298 Platfote, William, of Beccles, gent 0
3943879 2004967 2004967 defendant Can James, junior mercer 596298 596298 Can, James, junior, of Beccles, mercer, son of Can, James, senior, of Beccles, mercer 1
3943880 2004967 2004967 defendant Can Thomas, senior   596298 596298 Can, Thomas, senior, of Beccles, son of James Can, senior 2
3949018 2006723 2006723 plaintiff Downyng Nicholas mercer 596298 596298 Downyng, Nicholas, of Beccles, mercer 0
3949020 2006724 2006724 plaintiff Downyng Thomas draper 596298 596298 Downyng, Thomas, of Beccles, draper 0
3949021 2006724 2006724 defendant Bradley Robert tanner 596298 596298 Bradley, Robert, of Beccles, tanner 0
3949207 2006791 2006791 defendant Adyson James tanner 596298 596298 Adyson, James, of Beccles, tanner 1
3956903 2009485 2009485 plaintiff Parker Robert yeoman 596298 596298 Parker, Robert, of Beccles, yeoman 0
3956905 2009485 2009485 defendant Parker Robert clothier 596298 596298 Parker, Robert, of Beccles, clothier 1
3957911 2009829 2009829 plaintiff Pynfolde Anthony tailor 596298 596298 Pynfolde, Anthony, of Beccles, tailor 0
3958680 2010109 2010109 defendant Wade Richard butcher 596298 596298 Wade, Richard, of Beccles, butcher 2
3958843 2010174 2010174 plaintiff Rypynge Francis yeoman 596298 596298 Rypynge, Francis, of Beccles, yeoman 0
3963605 2011881 2011881 defendant Dodson John pedder 596298 596298 Dodson, John, of Beccles, pedder 0
3963607 2011881 2011881 defendant Derynge George   596298 596298 Derynge, George, of Beccles, "knacker" 2
3967348 2013208 2013208 defendant Rypyng Francis yeoman 596298 596298 Rypyng, Francis, of Beccles, yeoman 0
3968182 2013497 2013497 defendant Canne John merchant 596298 596298 Canne, John, of Beccles, merchant 1
3969277 2013861 2013861 plaintiff Cooke John barber 596298 596298 Cooke, John, of Beccles, barber 0
3969280 2013862 2013862 plaintiff Cooke John barber 596298 596298 Cooke, John, of Beccles, barber 0
3969281 2013862 2013862 defendant Allyson William sherman 596298 596298 Allyson, William, of Beccles, sherman 0
3970687 2014338 2014338 plaintiff Dixe Alan (legal representative) 596298 596298 Dixe, Alan, of Beccles, administrator of 0
3972216 2014841 2014841 defendant Rypyng Francis yeoman or innholder 596298 596298 Rypyng, Francis, of Beccles, yeoman or innholder 0
3973668 2015363 2015363 defendant Rypynge Francis yeoman 596298 596298 Rypynge, Francis, of Beccles, yeoman 0
3973697 2015374 2015374 plaintiff Haddenham Thomas clothmaker 596298 596298 Haddenham, Thomas, of Beccles, clothmaker 0
3974611 2015684 2015684 defendant Haddenham Thomas clothmaker 596298 596298 Haddenham, Thomas, of Beccles, clothmaker 0
3974612 2015684 2015684 defendant Ermytage Edward sherman 596298 596298 Ermytage, Edward, of Beccles, sherman 1
3980562 2017813 2017813 plaintiff Philip Adam   596298 596298 Philip, Adam, of Beccles 0
3981013 2017968 2017968 defendant Goldspryncke David shoemaker 596298 596298 Goldspryncke, David, of Beccles, shoemaker 0
3981594 2018173 2018173 defendant Base Everard yeoman 596298 596298 Base, Everard, of Beccles, yeoman 0
3982608 2018551 2018551 plaintiff Seger William yeoman 596298 596298 Seger, William, of Beccles, yeoman 0
3982649 2018564 2018564 plaintiff Seman George   596298 596298 Seman, George, of Beccles gent 0
3982654 2018565 2018565 plaintiff Seman George gent 596298 596298 Seman, George, of Beccles, gent 0
3986530 2019924 2019924 plaintiff Whetham Thomas (legal representative) 596298 596298 Whetham, Thomas, of Beccles, executrix of 0
3986533 2019925 2019925 plaintiff Whetham Thomas (legal representative) 596298 596298 Whetham, Thomas, of Beccles, executrix of 0
3993049 2022263 2022263 defendant Tebold William yeoman 596298 596298 Tebold, William, of Beccles, yeoman 0
3996626 2023553 2023553 defendant Hurleston Thomas saddler 596298 596298 Hurleston, Thomas, of Beccles, saddler 0
3996977 2023686 2023686 defendant Cotton John keelman 596298 596298 Cotton, John, of Beccles, keelman 2
3996979 2023687 2023687 plaintiff Downyng Thomas draper 596298 596298 Downyng, Thomas, of Beccles, draper 0
3996980 2023687 2023687 defendant Myddelton Thomas tailor 596298 596298 Myddelton, Thomas, of Beccles, tailor 0
3996985 2023689 2023689 plaintiff Downyng William   596298 596298 Downyng, William, of Beccles 0
3996995 2023693 2023693 plaintiff Downynge Thomas draper 596298 596298 Downynge, Thomas, of Beccles, draper 0
3996996 2023693 2023693 defendant Myddelton Richard tailor 596298 596298 Myddelton, Richard, of Beccles, tailor 0
3996997 2023694 2023694 plaintiff Downynge William   596298 596298 Downynge, William, of Beccles 0
3999903 2024735 2024735 defendant Ewen Thomas tailor 596298 596298 Ewen, Thomas, of Beccles, tailor 0
3999905 2024735 2024735 defendant Sponer Thomas yeoman 596298 596298 Sponer, Thomas, of Beccles, yeoman 2
3999906 2024735 2024735 defendant Cowper William laborer 596298 596298 Cowper, William, of Beccles, laborer 3
4000114 2024809 2024809 plaintiff Goddes William   596298 596298 Goddes, William, of Beccles, bachelor 0
4000115 2024809 2024809 defendant Fraunces John tailor 596298 596298 Fraunces, John, of Beccles, butcher Brydges, Thomas, of Beccles, tailor 0
4000116 2024809 2024809 defendant Wakefeld Thomas tailor 596298 596298 Wakefeld, Thomas, of Beccles, tailor 1
4003396 2025977 2025977 plaintiff Horne Andrew keelman 596298 596298 Horne, Andrew, of Beccles, keelman 0
4011706 2028922 2028922 plaintiff Porter Robert   596298 596298 Porter, Robert, of Beccles 0
4013877 2029692 2029692 defendant Fraunces John butcher 596298 596298 Fraunces, John, of Beccles, butcher 0
4018403 2031314 2031314 defendant Alynston William sherman 596298 596298 Alynston, William, of Beccles, sherman 2
4029595 2035221 2035221 defendant Wright Martin yeoman 596298 596298 Wright, Martin, of Beccles, yeoman 2
4031866 2036061 2036061 defendant Brigg Roger tailor 596298 596298 Brigg, Roger, of Beccles, tailor 1
4032360 2036242 2036242 plaintiff Garnett Nicholas tailor 596298 596298 Garnett, Nicholas, of Beccles, tailor 0
4032361 2036242 2036242 defendant Cooke John barber 596298 596298 Cooke, John, of Beccles, barber 0
4032365 2036243 2036243 defendant Cocke John barber 596298 596298 Cocke, John, of Beccles, barber 0
4032540 2036286 2036286 defendant Garnet Nicholas husbandman 596298 596298 Garnet, Nicholas, of Beccles, husbandman 0
4032851 2036404 2036404 defendant Whycke Richard husbandman 596298 596298 Whycke, Richard, of Beccles, husbandman 0
4033104 2036490 2036490 defendant Cooke John barber 596298 596298 Cooke, John, of Beccles, barber 0
4034501 2037010 2037010 defendant More David   596298 596298 More, David, of Beccles, "swylmaker" 1
4035887 2037508 2037508 plaintiff Horne Andrew keelman 596298 596298 Horne, Andrew, of Beccles, keelman 0
4035889 2037509 2037509 plaintiff Horne Andrew keelman 596298 596298 Horne, Andrew, of Beccles, keelman 0
4039566 2038772 2038772 defendant Dyckes Thomas, junior butcher 596298 596298 Dyckes, Thomas, junior, of Beccles, butcher 0
4043887 2040263 2040263 defendant Cooke John barber 596298 596298 Cooke, John, of Beccles, barber 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);