names

134 rows where place_id = 589754

✎ 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
3598627 1867195 1867195 defendant Bakon John draper 589754 589754 (Bakon, John, of Harleston, Norf, draper 1
3617852 1873206 1873206 defendant Candy John grasier 589754 589754 Candy, John, of Harleston, Norf, grasier 6
3665132 1915045 1915045 defendant Coke Geoffrey yeoman 589754 589754 Coke, Geoffrey, of Harleston, Norf, yeoman 0
3676590 1918716 1918716 defendant Lambe Thomas scrivener 589754 589754 Lambe, Thomas, of Harleston, Norf, scrivener 4
3680246 1919893 1919893 defendant Godfrey Robert mercer 589754 589754 Godfrey, Robert, of Harleston, Norf, mercer 1
3702497 1927047 1927047 defendant Godfrey Edmund yeoman 589754 589754 Godfrey, Edmund, of Harleston, Norf, yeoman 0
3704709 1927759 1927759 defendant Sepas Robert husbandman 589754 589754 Sepas, Robert, of Harleston, Norf, husbandman 4
3719985 1932521 1932521 defendant Lambe Thomas scrivener 589754 589754 Lambe, Thomas, of Harleston, Norf, scrivener 1
3735674 1937392 1937392 defendant Lambe Thomas scrivener 589754 589754 Lambe, Thomas, of Harleston, Norf, scrivener 1
3740358 1938847 1938847 defendant Godfray Edmund innholder 589754 589754 (Godfray, Edmund, of Harleston, Norf, innholder 1
3745249 1940422 1940422 defendant Bunnyng John husbandman 589754 589754 Bunnyng, John, of Harleston, Norf, husbandman 1
3745433 1940476 1940476 defendant Payn John mercer 589754 589754 Payn, John, of Harleston, Norf, mercer 0
3755115 1943547 1943547 defendant Payne John mercer 589754 589754 Payne, John, of Harleston, Norf, mercer 0
3762229 1945832 1945832 defendant Payn John merchant 589754 589754 Payn, John, of Harleston, Norf, merchant 0
3762333 1945861 1945861 defendant Gawdy Thomas, junior gent 589754 589754 Gawdy, Thomas, junior, of Harleston, Norf, gent 0
3772662 1949141 1949141 defendant Payn John mercer 589754 589754 Payn, John, of Harleston, Norf, mercer 0
3787178 1953781 1953781 defendant Elwyse alias Ilwych William raffman 589754 589754 Elwyse alias Ilwych, William, of Harleston, Norf, raffman 0
3797314 1957048 1957048 defendant Gawdy Thomas, junior gent 589754 589754 Gawdy, Thomas, junior, of Harleston, Norf, gent 0
3816989 1963221 1963221 defendant Lambe Thomas scrivener 589754 589754 Lambe, Thomas, of Harleston, Norf, scrivener 1
3852390 1974348 1974348 defendant Godfrey Robert mercer 589754 589754 Godfrey, Robert, of Harleston, Norf, mercer 0
3858612 1976367 1976367 defendant Gandy Thomas gent 589754 589754 Gandy, Thomas, of Harleston, Norf, gent 0
3868498 1979702 1979702 defendant Payn John mercer 589754 589754 Payn, John, of Harleston, Norf, mercer 0
3885061 1985265 1985265 defendant Payne John yeoman 589754 589754 Payne, John, of Harleston, Norf, yeoman 0
3889097 1986591 1986591 defendant Bacon Robert gent 589754 589754 Bacon, Robert, of Harleston, Norf, gent 0
3898987 1989867 1989867 defendant Payne John mercer 589754 589754 Payne, John, of Harleston, Norf, mercer 2
3913104 1994714 1994714 defendant Payne John mercer 589754 589754 Payne, John, of Harleston, Norf, mercer 0
3916753 1995971 1995971 defendant Bacon Robert gent 589754 589754 Bacon, Robert, of Harleston, Norf, gent 0
3916758 1995972 1995972 defendant Bacon Robert gent 589754 589754 Bacon, Robert, of Harleston, Norf, gent 0
3932891 2001292 2001292 defendant Murrell Thomas merchant 589754 589754 Murrell, Thomas, of Harleston, Norf, merchant 0
3932902 2001294 2001294 defendant Barne John mercer 589754 589754 Barne, John, of Harleston, Norf, mercer 0
3937354 2002829 2002829 defendant Father George mercer 589754 589754 Father, George, of Harleston, Norf, mercer 1
3951002 2007417 2007417 defendant Todd John yeoman 589754 589754 Todd, John, of Harleston, Norf, yeoman 1
3965213 2012445 2012445 defendant Burley Christopher tailor 589754 589754 Burley, Christopher, of Harleston, Norf, tailor 1
3965859 2012675 2012675 defendant Cooke John saddler 589754 589754 Cooke, John, of Harleston, Norf, saddler 1
3967398 2013227 2013227 defendant Cocke Geoffrey yeoman 589754 589754 Cocke, Geoffrey, of Harleston, Norf, yeoman 0
3976366 2016308 2016308 defendant Morell Christopher chapman 589754 589754 Morell, Christopher, of Harleston, Norf, chapman 0
3986092 2019797 2019797 defendant Cocke Geoffrey yeoman 589754 589754 Cocke, Geoffrey, of Harleston, Norf, yeoman 0
3993041 2022260 2022260 defendant Nollothe Robert yeoman 589754 589754 Nollothe, Robert, of Harleston, Norf, or of Thorndon, Suff, yeoman 0
4000279 2024868 2024868 defendant Goose Robert tailor 589754 589754 Goose, Robert, of Harleston, Norf, tailor 0
4005213 2026644 2026644 plaintiff Kente Edward draper 589754 589754 Kente, Edward, of Harleston, Norf, draper 0
4010219 2028421 2028421 defendant Jurden Robert yeoman 589754 589754 Jurden, Robert, of Harleston, Norf, yeoman 1
4010222 2028422 2028422 defendant Jurden Robert yeoman 589754 589754 Jurden, Robert, of Harleston, Norf, yeoman 1
4017848 2031094 2031094 defendant Nolloth Robert yeoman 589754 589754 Nolloth, Robert, of Harleston, Norf, yeoman 0
4031405 2035902 2035902 plaintiff Ferrys William yeoman 589754 589754 Ferrys, William, of Harleston, Norf, yeoman 0
4031407 2035903 2035903 plaintiff Ferrys William yeoman 589754 589754 Ferrys, William, of Harleston, Norf, yeoman 0
4033158 2036508 2036508 defendant Goose Robert tailor 589754 589754 Goose, Robert, of Harleston, Norf, tailor 0
4043253 2040058 2040058 defendant Murryell Christopher clerk 589754 589754 Murryell, Christopher, of Harleston, Norf, clerk 0
4060152 2046031 2046031 defendant Browster Robert cutler 589754 589754 Browster, Robert, of Harleston, Norf, cutler 3
4070595 2049776 2049776 defendant Lancaster Thomas clerk 589754 589754 Lancaster, Thomas, of Harleston, Norf, clerk 0
4072072 2050313 2050313 defendant Barker Robert tailor 589754 589754 Barker, Robert, of Harleston, Norf, tailor 2
4072074 2050314 2050314 defendant Bradley Nicholas currier 589754 589754 Bradley, Nicholas, of Harleston, Norf, currier 0
4085979 2055263 2055263 defendant Whitynge Mathew innholder 589754 589754 Whitynge, Mathew, of Harleston, Norf, innholder 0
4085980 2055263 2055263 defendant Sponer Richard yeoman 589754 589754 Sponer, Richard, of Harleston, Norf, yeoman 1
4086659 2055517 2055517 defendant Churche Margaret spinster 589754 589754 Churche, Margaret, of Harleston, Norf, spinster 0
4096413 2059047 2059047 defendant Davye Robert tailor 589754 589754 Davye, Robert, of Harleston, norf, tailor 3
4106813 2062730 2062730 defendant Hynd Richard butcher 589754 589754 Hynd, Richard, of Harleston, Norf, butcher 2
4114342 2065414 2065414 defendant Whytyng Mathew yeoman 589754 589754 Whytyng, Mathew, of Harleston, Norf, yeoman 0
4115964 2065998 2065998 defendant Becham John chapman 589754 589754 Becham, John, of Harleston, Norf, chapman 0
4127484 2070124 2070124 defendant Muriell Robert gent 589754 589754 Muriell, Robert, of Harleston, Norf, gent 0
4138504 2074137 2074137 defendant Lancaster Thomas clerk 589754 589754 Lancaster, Thomas, of Harleston, Norf, clerk 0
4145278 2076507 2076507 defendant Horne Henry saddler 589754 589754 Horne, Henry, of Harleston, Norf, saddler 0
4147785 2077364 2077364 defendant Botewrighte Richard chapman 589754 589754 Botewrighte, Richard, of Harleston, Norf, chapman 0
4154852 2079792 2079792 defendant Crytott Charles yeoman 589754 589754 Crytott, Charles, of Harleston, Norf, yeoman 0
4168155 2084349 2084349 defendant Becham John yeoman 589754 589754 Becham, John, of Harleston, Norf, yeoman 0
4181708 2089084 2089084 defendant Skete John yeoman 589754 589754 Skete, John, of Harleston, Norf, yeoman 0
4193517 2093299 2093299 defendant Horne Henry yeoman 589754 589754 Horne, Henry, of Harleston, Norf, yeoman 0
4199975 2095540 2095540 defendant Davy Robert yeoman 589754 589754 Davy, Robert, of Harleston, Norf, yeoman 3
4202361 2096368 2096368 defendant Hollywell Robert saddler 589754 589754 Hollywell, Robert, of Harleston, Norf, saddler 1
4203961 2096937 2096937 defendant Palgrave John yeoman 589754 589754 Palgrave, John, of Harleston, Norf, yeoman 2
4233679 2107302 2107302 defendant Baxter Stephen yeoman 589754 589754 Baxter, Stephen, of Harleston, Norf, yeoman 0
4242254 2110403 2110403 defendant Baxter Stephen yeoman 589754 589754 Baxter, Stephen, of Harleston, Norf, yeoman 0
4249522 2112825 2112825 defendant Kirke Robert yeoman 589754 589754 Kirke, Robert, of Harleston, Norf, yeoman 0
4249524 2112826 2112826 defendant Kyrke Robert yeoman 589754 589754 Kyrke, Robert, of Harleston, Norf, yeoman 0
4326945 2139344 2139344 defendant Muriell Christopher, junior yeoman 589754 589754 Muriell, Christopher, junior, of Harleston, Norf, yeoman 0
4327762 2139609 2139609 defendant Doggett Richard butcher 589754 589754 Doggett, Richard, of Harleston, Norf, butcher 3
4327934 2139667 2139667 defendant Warde Walter butcher 589754 589754 Warde, Walter, of Harleston, Norf, butcher 3
4331141 2140715 2140715 defendant Hollowell Robert saddler 589754 589754 Hollowell, Robert, of Harleston, Norf, saddler 2
4349268 2147005 2147005 defendant Oxe Hugh tailor 589754 589754 Oxe, Hugh, of Harleston, Norf, tailor 3
4352916 2148246 2148246 defendant Moore Richard clerk 589754 589754 Moore, Richard, of Harleston, Norf, clerk 1
4354583 2148838 2148838 defendant Daynes Henry hatter 589754 589754 Daynes, Henry, of Harleston, Norf, hatter 0
4356034 2149331 2149331 defendant Botewright Richard yeoman 589754 589754 Botewright, Richard, of Harleston, Norf, yeoman 0
4385101 2159704 2159704 defendant Warde Thomas yeoman 589754 589754 Warde, Thomas, of Harleston, Norf, yeoman 0
4865147 2316073 2316073 defendant Howard William pedder 589754 589754 Howard, William, of Harleston, Norf, pedder 2
4866896 2316608 2316608 defendant Dolfyn William barker 589754 589754 Dolfyn, William, of Harleston, Norf, barker 1
4884105 2321939 2321939 defendant Howard William pedder 589754 589754 Howard, William, of Harleston, Norf, pedder 1
4899296 2326421 2326421 defendant Couper John husbandman 589754 589754 Couper, John, of Harleston, Norf, husbandman 1
4924792 2334187 2334187 defendant Barnard John draper 589754 589754 Barnard, John, of Harleston, Norf, draper 1
4929309 2335584 2335584 defendant Deye Thomas yeoman 589754 589754 Deye, Thomas, of Harleston, Norf, yeoman 2
4950003 2341972 2341972 defendant Wheymond John butcher 589754 589754 Wheymond, John, of Harleston, Norf, butcher 0
4955181 2343506 2343506 defendant Tysard John gent 589754 589754 Tysard, John, of Harleston, Norf, gent 0
4977828 2350325 2350325 defendant Tysard John yeoman 589754 589754 Tysard, John, of Harleston, Norf, yeoman 2
4989704 2353836 2353836 defendant Howard John husbandman 589754 589754 Howard, John, of Harleston, Norf, husbandman 6
5042387 2369332 2369332 defendant Dory John yeoman 589754 589754 Dory, John, of Harleston, Norf, yeoman 2
5059853 2374513 2374513 defendant Tysarard John yeoman 589754 589754 Tysarard, John, of Harleston, Norf, yeoman 1
5080325 2380607 2380607 defendant Hardegrave John chaplain 589754 589754 Hardegrave, John, of Harleston, Norf, chaplain 2
5082483 2381261 2381261 defendant Monke John skinner 589754 589754 Monke, John, of Harleston, Norf, skinner 0
5100140 2386480 2386480 defendant Stapilton Simon turner 589754 589754 Stapilton, Simon, of Harleston, Norf, turner 0
5109264 2389136 2389136 defendant Hauker or Hanker William butcher 589754 589754 Hauker or Hanker, William, of Harleston, Norf, butcher 0
5128832 2394918 2394918 defendant Dory John yeoman 589754 589754 Dory, John, of Harleston, Norf, yeoman 0
5131656 2395740 2395740 defendant Thurfeld Stephen chapman 589754 589754 Thurfeld, Stephen, of Harleston, Norf, chapman 1

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