names

95 rows where place_id = 601222

✎ 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
3644367 1908656 1908656 defendant Dene Ralph yeoman 601222 601222 Dene, Ralph, of Lowestofte, yeoman 0
3659436 1913211 1913211 defendant Lobbys Geoffrey yeoman 601222 601222 Lobbys, Geoffrey, of Lowestofte, yeoman 2
3668795 1916177 1916177 defendant Shottysham Thomas butcher 601222 601222 Shottysham, Thomas, of Lowestofte, butcher 0
3689299 1922817 1922817 defendant Skarlett Richard yeoman 601222 601222 Skarlett, Richard, of Lowestofte, yeoman 0
3692381 1923791 1923791 defendant Dene Ralph draper 601222 601222 Dene, Ralph, of Lowestofte, draper 0
3695786 1924913 1924913 defendant Den Ralph yeoman 601222 601222 Den, Ralph, of Lowestofte, yeoman 1
3697523 1925447 1925447 defendant Den Ralph tailor 601222 601222 Den, Ralph, of Lowestofte, tailor 0
3705255 1927930 1927930 defendant Robson John mariner 601222 601222 Robson, John, of Lowestofte, mariner 0
3706309 1928260 1928260 defendant Symond alias Dyryk John (legal representative) 601222 601222 Symond alias Dyryk, John, of Lowestofte, tailor, executors of 3
3706310 1928260 1928260 defendant Chener or Chever Robert husbandman 601222 601222 (Chener or Chever, Robert, of Lowestofte, husbandman 4
3709640 1929323 1929323 defendant Lobbys Geoffrey yeoman 601222 601222 Lobbys, Geoffrey, of Lowestofte, yeoman 2
3713311 1930474 1930474 defendant Dene Ralph draper 601222 601222 Dene, Ralph, of Lowestofte, draper 1
3744516 1940186 1940186 defendant Downyng John mercer 601222 601222 Downyng, John, of Lowestofte, mercer 0
3747520 1941139 1941139 defendant Skarlet Richard yeoman 601222 601222 Skarlet, Richard, of Lowestofte, yeoman 0
3748176 1941359 1941359 defendant Awoode John husbandman 601222 601222 Awoode, John, of Lowestofte, husbandman 1
3770363 1948405 1948405 defendant Flye Robert cordwainer 601222 601222 Flye, Robert, of Lowestofte, cordwainer 0
3770525 1948465 1948465 defendant Hendry William mariner 601222 601222 Hendry, William, of Lowestofte, mariner 0
3774823 1949853 1949853 defendant Cullas William baker 601222 601222 Cullas, William, of Lowestofte, baker 0
3780467 1951623 1951623 defendant Den Ralph draper 601222 601222 Den, Ralph, of Lowestofte, draper 0
3795375 1956423 1956423 defendant Pyle Thomas husbandman 601222 601222 Pyle, Thomas, of Lowestofte, husbandman 0
3812762 1961884 1961884 defendant Hulle William baker 601222 601222 Hulle, William, of Lowestofte, baker 2
3840319 1970541 1970541 plaintiff Aleyn Robert draper 601222 601222 Aleyn, Robert, of Lowestofte, draper 0
3855449 1975346 1975346 defendant Dyxe John butcher 601222 601222 Dyxe, John, of Lowestofte, butcher 2
3869566 1980062 1980062 defendant Dyxe John butcher 601222 601222 Dyxe, John, of Lowestofte, butcher 0
3870595 1980406 1980406 defendant Bottysswayne John baker 601222 601222 Bottysswayne, John, of Lowestofte, baker 0
3918966 1996664 1996664 defendant Dowe John miller 601222 601222 Dowe, John, of Lowestofte, miller 0
3920930 1997347 1997347 defendant Denton Robert shoemaker 601222 601222 Denton, Robert, of Lowestofte, shoemaker 0
3924270 1998425 1998425 defendant Shanke John (legal representative) 601222 601222 Shanke, John, of Lowestofte, weaver, administratrix of 0
3927319 1999478 1999478 plaintiff Annott Thomas   601222 601222 Annott, Thomas, of Lowestofte 0
3931636 2000877 2000877 plaintiff Drawer Thomas merchant 601222 601222 Drawer, Thomas, of Lowestofte, merchant 0
3931639 2000878 2000878 plaintiff Drawer Thomas merchant 601222 601222 Drawer, Thomas, of Lowestofte, merchant 0
3935147 2002065 2002065 defendant Annott Thomas yeoman 601222 601222 Annott, Thomas, of Lowestofte, yeoman 0
3943426 2004816 2004816 defendant Fulwood Thomas merchant 601222 601222 Fulwood, Thomas, of Lowestofte, merchant 0
3946201 2005750 2005750 plaintiff Burgys Thomas merchant 601222 601222 Burgys, Thomas, of Lowestofte, merchant 0
3946203 2005751 2005751 plaintiff Burgys Thomas merchant 601222 601222 Burgys, Thomas, of Lowestofte, merchant 0
3947894 2006327 2006327 defendant Woodshyde Robert merchant 601222 601222 Woodshyde, Robert, of Lowestofte, merchant 1
3967057 2013104 2013104 defendant Grudgefelde John merchant 601222 601222 Grudgefelde, John, of Lowestofte, merchant 0
3970689 2014338 2014338 defendant Annott Thomas merchant 601222 601222 Annott, Thomas, of Lowestofte, merchant 0
3971994 2014764 2014764 plaintiff Forman Edward mariner 601222 601222 Forman, Edward, of Lowestofte, mariner 0
3971995 2014764 2014764 defendant Beselle John alias Thomas mariner 601222 601222 Beselle, John alias Thomas, of Lowestofte, mariner 0
4060159 2046033 2046033 defendant Smythe John butcher 601222 601222 Smythe, John, of Lowestofte, butcher 1
4061143 2046394 2046394 defendant Roden John butcher 601222 601222 Roden, John, of Lowestofte, butcher 1
4067584 2048724 2048724 defendant Pyckenett Robert innholder 601222 601222 Pyckenett, Robert, of Lowestofte, innholder 0
4067585 2048724 2048724 defendant Bocher Thomas husbandman 601222 601222 Bocher, Thomas, of Lowestofte, husbandman 1
4071531 2050112 2050112 defendant Woode Robert beer brewer 601222 601222 Woode, Robert, of Lowestofte, beer brewer 0
4071536 2050113 2050113 defendant Lovell Walter gent 601222 601222 Lovell, Walter, of Lowestofte, gent 0
4071537 2050113 2050113 defendant Davy Edward draper 601222 601222 Davy, Edward, of Lowestofte, draper 1
4091149 2057123 2057123 defendant Burrell Stephen draper 601222 601222 Burrell, Stephen, of Lowestofte, draper 0
4104992 2062060 2062060 defendant Townesend John butcher 601222 601222 Townesend, John, of Lowestofte, butcher 0
4109376 2063615 2063615 defendant Wells William mariner 601222 601222 Wells, William, of Lowestofte, mariner 2
4117281 2066483 2066483 defendant Davye Edward merchant 601222 601222 Davye, Edward, of Lowestofte, merchant 1
4135888 2073166 2073166 defendant Benyngfeld Peter yeoman 601222 601222 Benyngfeld, Peter, of Lowestofte, yeoman 1
4135889 2073166 2073166 defendant Parker Robert yeoman 601222 601222 Parker, Robert, of Lowestofte, yeoman 2
4171073 2085363 2085363 defendant Rugge George yeoman 601222 601222 Rugge, George, of Lowestofte, yeoman 1
4180880 2088791 2088791 defendant Donne or Doune Robert yeoman 601222 601222 Donne or Doune, Robert, of Lowestofte, or of Loddon, Norf, yeoman 0
4192405 2092898 2092898 defendant Gooche William   601222 601222 Gooche, William, of Lowestofte, sailor 2
4199174 2095268 2095268 defendant Doe Robert yeoman 601222 601222 Doe, Robert, of Lowestofte, or of Thrandeston, yeoman 0
4208504 2098527 2098527 defendant Well Simon merchant 601222 601222 Well, Simon, of Lowestofte, merchant 0
4208713 2098598 2098598 defendant Sellynge Richard mariner 601222 601222 Sellynge, Richard, of Lowestofte, mariner 0
4208714 2098598 2098598 defendant White Thomas blacksmith 601222 601222 White, Thomas, of Lowestofte, blacksmith 1
4208715 2098598 2098598 defendant Gayes John cooper 601222 601222 Gayes, John, of Lowestofte, cooper 2
4241418 2110115 2110115 defendant Mewse Thomas butcher 601222 601222 Mewse, Thomas, of Lowestofte, butcher 0
4243483 2110813 2110813 defendant Nicholl James (legal representative) 601222 601222 Nicholl, James, of Lowestofte, singleman, executors of 0
4258430 2115786 2115786 defendant Kervill Edmund gent 601222 601222 Kervill, Edmund, of Lowestofte, gent 0
4258432 2115786 2115786 defendant Mewse Thomas butcher 601222 601222 Mewse, Thomas, of Lowestofte, butcher 2
4275247 2121280 2121280 defendant Rooke John tailor 601222 601222 Rooke, John, of Lowestofte, tailor 1
4315019 2135365 2135365 defendant Andrewes Robert yeoman 601222 601222 Andrewes, Robert, of Lowestofte, yeoman 0
4321262 2137529 2137529 defendant Fulwoode Mathew yeoman 601222 601222 Fulwoode, Mathew, of Lowestofte, yeoman 0
4332517 2141165 2141165 defendant Helwys George husbandman 601222 601222 Helwys, George, of Lowestofte, husbandman 0
4353968 2148614 2148614 defendant Vivians Richard butcher 601222 601222 Vivians, Richard, of Lowestofte, butcher 0
4356288 2149425 2149425 defendant Carothers Andrew baker 601222 601222 Carothers, Andrew, of Lowestofte, baker 0
4356291 2149425 2149425 defendant Irelande Margaret widow 601222 601222 Irelande, Margaret, of Lowestofte, widow 3
4380405 2158101 2158101 defendant Irelande Margaret widow 601222 601222 Irelande, Margaret, of Lowestofte, widow 2
4385065 2159694 2159694 defendant Keble John husbandman 601222 601222 Keble, John, of Lowestofte, husbandman 0
4387802 2160557 2160557 defendant Bamforthe William husbandman 601222 601222 Bamforthe, William, of Lowestofte, husbandman 3
4391451 2161757 2161757 defendant Flatman John yeoman 601222 601222 Flatman, John, of Lowestofte, yeoman 0
4397051 2163581 2163581 defendant Smythe William tinker 601222 601222 Smythe, William, of Lowestofte, tinker 0
4410705 2168172 2168172 defendant Goslinge Peter tanner 601222 601222 Goslinge, Peter, of Lowestofte, tanner 0
4739056 2277308 2277308 plaintiff Writhe John butcher 601222 601222 Writhe, John, of Lowestofte, butcher 0
4904610 2328054 2328054 defendant Parker alias Barbour William yeoman 601222 601222 Parker alias Barbour, William, of Lowestofte, yeoman 3
4936181 2337717 2337717 defendant Gisbrightesson Titeman beer brewer 601222 601222 Gisbrightesson, Titeman, of Lowestofte, beer brewer 0
5083415 2381537 2381537 defendant Heygham John (legal representative) 601222 601222 Heygham, John, of Lowestofte, merchant, administratrix of 0
5083416 2381537 2381537 defendant Heygham Maud widow 601222 601222 Heygham, Maud, of Lowestofte, widow 1
5235837 2426061 2426061 defendant Mundes John merchant 601222 601222 Mundes, John, of Lowestofte, merchant 0
5288591 2441683 2441683 defendant Mundus Margaret   601222 601222 Mundus, Margaret, of Lowestofte, widow of Mundus, John, of Lowestoft 0
5532104 2514585 2514585 defendant Coweper John carter 601222 601222 Coweper, John, of Lowestofte, carter 0
5532108 2514585 2514585 defendant Steyngate John husbandman 601222 601222 Steyngate, John, of Lowestofte, husbandman 4
5543194 2517989 2517989 defendant Alen Simon husbandman 601222 601222 Alen, Simon, of Lowestofte, husbandman 0
5544358 2518343 2518343 defendant Gall Richard husbandman 601222 601222 Gall, Richard, of Lowestofte, husbandman 0
5546146 2518864 2518864 defendant Hughson Nicholas merchant 601222 601222 Hughson, Nicholas, of Lowestofte, merchant 0
5548212 2519506 2519506 defendant Hedley alias Tabourer William smith 601222 601222 Hedley alias Tabourer, William, of Lowestofte, smith 0
5553025 2520924 2520924 defendant Cutbert Robert butcher 601222 601222 Cutbert, Robert, of Lowestofte, butcher 0
5554874 2521425 2521425 defendant Cutbert Robert butcher 601222 601222 Cutbert, Robert, of Lowestofte, butcher 0
5554875 2521425 2521425 defendant Cove Robert butcher 601222 601222 Cove, Robert, of Lowestofte, butcher 1
5561395 2523309 2523309 defendant Johnson Derick beer brewer 601222 601222 Johnson, Derick, of Lowestofte, beer brewer 0

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);