names

224 rows where place_id = 587059

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590352 1864623 1864623 defendant Gele John laborer 587059 587059 Gele, John, of Stalham, laborer 2
3607264 1869935 1869935 defendant Wolff John yeoman 587059 587059 Wolff, John, of Stalham, yeoman 4
3685299 1921554 1921554 defendant Wolff Thomas yeoman 587059 587059 Wolff, Thomas, of Stalham, yeoman 0
3685300 1921554 1921554 defendant Gybbys William yeoman 587059 587059 Gybbys, William, of Stalham, yeoman 1
3692271 1923752 1923752 defendant Myghell Robert smith 587059 587059 Myghell, Robert, of Stalham, smith 4
3696291 1925060 1925060 defendant Mighill Robert smith 587059 587059 Mighill, Robert, of Stalham, smith 2
3696295 1925061 1925061 defendant Myghill Robert smith 587059 587059 Myghill, Robert, of Stalham, smith 1
3696301 1925063 1925063 defendant Mighill Robert smith 587059 587059 Mighill, Robert, of Stalham, smith 0
3699721 1926140 1926140 defendant Peke Bartholomew husbandman 587059 587059 Peke, Bartholomew, of Stalham, husbandman 1
3699729 1926142 1926142 defendant Peke Bartholomew husbandman 587059 587059 Peke, Bartholomew, of Stalham, husbandman 2
3725771 1934348 1934348 defendant Exnett Thomas husbandman 587059 587059 Exnett, Thomas, of Stalham, husbandman 0
3725772 1934348 1934348 defendant Dalby John husbandman 587059 587059 Dalby, John, of Stalham, husbandman 1
3725773 1934348 1934348 defendant Browne John husbandman 587059 587059 Browne, John, of Stalham, husbandman 2
3744411 1940154 1940154 defendant Bolt Richard yeoman 587059 587059 Bolt, Richard, of Stalham, yeoman 0
3763986 1946377 1946377 defendant Hert John husbandman 587059 587059 Hert, John, of Stalham, husbandman 1
3771837 1948882 1948882 defendant Wolff Thomas husbandman 587059 587059 Wolff, Thomas, of Stalham, husbandman 2
3771838 1948882 1948882 defendant Wyngfeld Richard husbandman 587059 587059 Wyngfeld, Richard, of Stalham, husbandman 3
3850988 1973899 1973899 defendant Hart John   587059 587059 Hart, John, of Stalham, worsted weaver 0
3876595 1982419 1982419 plaintiff Gybbis Thomas (legal representative) 587059 587059 Gybbis, Thomas, of Stalham, administrator of 0
3876597 1982419 1982419 defendant Bokkyng Ralph (legal representative) 587059 587059 Bokkyng, Ralph, of Stalham, chaplain, executor of 0
3876598 1982419 1982419 defendant Wyngfeld John cooper 587059 587059 Wyngfeld, John, of Stalham, cooper 1
3876603 1982422 1982422 plaintiff Gybbys Thomas (legal representative) 587059 587059 Gybbys, Thomas, of Stalham, husbandman, administrator of 0
3876605 1982422 1982422 defendant Bokkyng Robert (legal representative) 587059 587059 Bokkyng, Robert, of Stalham, chaplain, executor of 0
3876606 1982422 1982422 defendant Wyngfeld John cooper 587059 587059 Wyngfeld, John, of Stalham, cooper 1
3944873 2005301 2005301 defendant Fox Henry husbandman 587059 587059 Fox, Henry, of Stalham, husbandman 0
3961457 2011102 2011102 defendant Holle Thomas   587059 587059 Holle, Thomas, of Stalham, or of Tunsted, worsted weaver 0
4005379 2026705 2026705 defendant Towneshende John gent 587059 587059 Towneshende, John, of Stalham, gent 0
4011690 2028915 2028915 defendant Peeke Edmund tailor 587059 587059 Peeke, Edmund, of Stalham, tailor 1
4018325 2031281 2031281 defendant Smythe Andrew yeoman 587059 587059 Smythe, Andrew, of Stalham, yeoman 1
4044914 2040636 2040636 plaintiff Rogers Robert   587059 587059 Rogers, Robert, of Stalham, yeoman, administrators of 0
4046679 2041265 2041265 defendant Rogers Robert   587059 587059 Rogers, Robert, of Stalham, yeoman, administrators of 0
4056309 2044642 2044642 defendant Hart John husbandman 587059 587059 Hart, John, of Stalham, husbandman 0
4060444 2046137 2046137 defendant Sewell Thomas husbandman 587059 587059 Sewell, Thomas, of Stalham, husbandman 1
4065197 2047836 2047836 defendant Cheny William husbandman 587059 587059 Cheny, William, of Stalham, husbandman 0
4065198 2047836 2047836 defendant Boyse Alman husbandman 587059 587059 Boyse, Alman, of Stalham, husbandman 1
4076421 2051862 2051862 defendant Cuttyng John husbandman 587059 587059 Cuttyng, John, of Stalham, husbandman 0
4076422 2051862 2051862 defendant Foxe Henry husbandman 587059 587059 Foxe, Henry, of Stalham, husbandman 1
4076423 2051862 2051862 defendant Darling John husbandman 587059 587059 Darling, John, of Stalham, husbandman 2
4078126 2052482 2052482 defendant Sewell Thomas husbandman 587059 587059 Sewell, Thomas, of Stalham, husbandman 0
4097320 2059359 2059359 defendant Sewell Thomas husbandman 587059 587059 Sewell, Thomas, of Stalham, husbandman 0
4097321 2059359 2059359 defendant Cutting John husbandman 587059 587059 Cutting, John, of Stalham, husbandman 1
4107749 2063047 2063047 defendant Ward John butcher 587059 587059 Ward, John, of Stalham, butcher 1
4107965 2063121 2063121 defendant Mathewes William saddler 587059 587059 Mathewes, William, of Stalham, saddler 3
4107970 2063122 2063122 defendant Mathewes William saddler 587059 587059 Mathewes, William, of Stalham, saddler 3
4140661 2074900 2074900 defendant Mathewes William saddler 587059 587059 Mathewes, William, of Stalham, saddler 1
4148059 2077452 2077452 defendant Some Robert clerk 587059 587059 Some, Robert, of Stalham, clerk 2
4152224 2078888 2078888 defendant Cheney Thomas husbandman 587059 587059 Cheney, Thomas, of Stalham, husbandman 2
4153290 2079247 2079247 defendant Grene Giles husbandman 587059 587059 Grene, Giles, of Stalham, husbandman 3
4159354 2081341 2081341 defendant Warde John butcher 587059 587059 Warde, John, of Stalham, butcher 1
4160963 2081906 2081906 defendant Hart John husbandman 587059 587059 Hart, John, of Stalham, husbandman 2
4163306 2082692 2082692 defendant Harte Thomas yeoman 587059 587059 Harte, Thomas, of Stalham, yeoman 0
4163308 2082693 2082693 defendant Harte Thomas yeoman 587059 587059 Harte, Thomas, of Stalham, yeoman 0
4163310 2082694 2082694 defendant Harte Thomas yeoman 587059 587059 Harte, Thomas, of Stalham, yeoman 0
4164208 2083008 2083008 defendant Gymmyngham William carpenter 587059 587059 Gymmyngham, William, of Stalham, carpenter 3
4164211 2083009 2083009 defendant Foxe Richard weaver 587059 587059 Foxe, Richard, of Stalham, weaver 1
4166536 2083792 2083792 defendant Harte Robert   587059 587059 Harte, Robert, of Stalham, mason 1
4168754 2084561 2084561 defendant Warde John butcher 587059 587059 Warde, John, of Stalham, butcher 2
4178157 2087831 2087831 defendant Mathewes William saddler 587059 587059 Mathewes, William, of Stalham, saddler 1
4178160 2087832 2087832 defendant Mathewe William saddler 587059 587059 Mathewe, William, of Stalham, saddler 1
4192865 2093069 2093069 defendant Turnor James carpenter 587059 587059 Turnor, James, of Stalham, carpenter 0
4231404 2106486 2106486 defendant Pratt Ralph husbandman 587059 587059 Pratt, Ralph, of Stalham, husbandman 0
4249775 2112906 2112906 defendant Baspole Richard, senior gent 587059 587059 Baspole, Richard, senior, of Stalham, gent 3
4253688 2114224 2114224 defendant Lawes Thomas husbandman 587059 587059 Lawes, Thomas, of Stalham, husbandman 3
4255409 2114805 2114805 defendant Auger John butcher 587059 587059 Auger, John, of Stalham, butcher 0
4260743 2116557 2116557 defendant Sewell Cecily widow 587059 587059 Sewell, Cecily, of Stalham, widow 3
4287974 2125746 2125746 defendant Smyth Andrew yeoman 587059 587059 Smyth, Andrew, of Stalham, yeoman 0
4288418 2125905 2125905 defendant Auger John butcher 587059 587059 Auger, John, of Stalham, butcher 1
4312756 2134593 2134593 defendant Marche Thomas husbandman 587059 587059 Marche, Thomas, of Stalham, husbandman 1
4314765 2135275 2135275 defendant Howse Roland husbandman 587059 587059 Howse, Roland, of Stalham, husbandman 3
4327637 2139564 2139564 defendant Barnes Thomas husbandman 587059 587059 Barnes, Thomas, of Stalham, husbandman 1
4333659 2141537 2141537 defendant Goodear John blacksmith 587059 587059 Goodear, John, of Stalham, blacksmith 0
4333661 2141537 2141537 defendant Bridge or Brigge Robert blacksmith 587059 587059 Bridge or Brigge, Robert, of Stalham, blacksmith 2
4341494 2144303 2144303 defendant Wrighte William husbandman 587059 587059 Wrighte, William, of Stalham, husbandman 0
4352203 2148006 2148006 defendant Turner William blacksmith 587059 587059 Turner, William, of Stalham, blacksmith 0
4353603 2148484 2148484 defendant Bower John husbandman 587059 587059 Bower, John, of Stalham, husbandman 0
4353604 2148484 2148484 defendant Esshton Edward   587059 587059 Esshton, Edward, of Stalham, mason 1
4355674 2149206 2149206 defendant Taylor Thomas husbandman 587059 587059 Taylor, Thomas, of Stalham, husbandman 3
4386231 2160072 2160072 defendant Pratt Ralph   587059 587059 Pratt, Ralph, of Stalham, wheelwright 2
4416804 2170124 2170124 defendant Bonde Thomas   587059 587059 together with Bonde, Thomas, of Stalham, son of Andrew 2
4440701 2182004 2182004 defendant Brid Alexancer   587059 587059 Brid, Alexancer, of Stalham 0
4454364 2186381 2186381 defendant Berker Thomas   587059 587059 Berker, Thomas, of Stalham 3
4474784 2192782 2192782 plaintiff Dyboll William   587059 587059 Dyboll, William, of Stalham 0
4479195 2194147 2194147 defendant Talyour David   587059 587059 Talyour, David, of Stalham 1
4519518 2206463 2206463 defendant Walsheman David tailor 587059 587059 Walsheman, David, of Stalham, tailor 0
4528416 2209164 2209164 defendant Cokes Henry   587059 587059 Cokes, Henry, of Stalham 0
4539593 2212642 2212642 defendant Clobbe Edmund draper 587059 587059 Clobbe, Edmund, of Stalham, draper 2
4561217 2219470 2219470 defendant Gibbes Mathew   587059 587059 Gibbes, Mathew, of Stalham 0
4582610 2225999 2225999 defendant Millere Geoffrey   587059 587059 Millere, Geoffrey, of Stalham 4
4598195 2230675 2230675 defendant Collessone Alan   587059 587059 Collessone, Alan, of Stalham 2
4618638 2236838 2236838 plaintiff Haweys William   587059 587059 Haweys, William, of Stalham 0
4618640 2236839 2236839 plaintiff Haweys William   587059 587059 Haweys, William, of Stalham 0
4630155 2240342 2240342 defendant Wolstan William   587059 587059 Wolstan, William, of Stalham 1
4630156 2240342 2240342 defendant Fullere John   587059 587059 Fullere, John, of Stalham 2
4637539 2242529 2242529 defendant Bere John   587059 587059 Bere, John, of Stalham 1
4637540 2242529 2242529 defendant Fullere John   587059 587059 Fullere, John, of Stalham 2
4655984 2247751 2247751 defendant Cosull Richard yeoman 587059 587059 Cosull, Richard, of Stalham, yeoman 0
4655985 2247751 2247751 defendant Haddon Seman yeoman 587059 587059 Haddon, Seman, of Stalham, yeoman 1
4660654 2249156 2249156 defendant Crouxton John husbandman 587059 587059 Crouxton, John, of Stalham, husbandman 0
4669941 2256294 2256294 defendant Peke Roger (legal representative) 587059 587059 Peke, Roger, of Stalham, executors of 0
4669943 2256294 2256294 defendant Peke Cecilia widow 587059 587059 Peke, Cecilia, of Stalham, widow 2

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