names

141 rows where place_id = 587161

✎ 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
3590634 1864713 1864713 defendant Flayschmond Walter gent 587161 587161 Flayschmond, Walter, of Cornewode, gent 0
3628941 1903927 1903927 defendant Rowe John yeoman 587161 587161 Rowe, John, of Cornewode, yeoman 2
3629254 1904017 1904017 defendant Cole Thomas gent 587161 587161 Cole, Thomas, of Cornewode, gent 0
3636768 1906293 1906293 defendant Rede William yeoman 587161 587161 Rede, William, of Cornewode, yeoman 0
3636770 1906293 1906293 defendant Rowe John husbandman 587161 587161 Rowe, John, of Cornewode, husbandman 2
3636771 1906293 1906293 defendant Towsan Nicholas husbandman 587161 587161 Towsan, Nicholas, of Cornewode, husbandman 3
3636772 1906293 1906293 defendant Wodeham John husbandman 587161 587161 Wodeham, John, of Cornewode, husbandman 4
3636773 1906293 1906293 defendant Donston Ralph husbandman 587161 587161 Donston, Ralph, of Cornewode, husbandman 5
3636774 1906293 1906293 defendant Toll Thomas yeoman 587161 587161 Toll, Thomas, of Cornewode, yeoman 6
3636775 1906293 1906293 defendant Romayn William   587161 587161 Romayn, William, of Cornewode, groom 7
3636776 1906293 1906293 defendant Larde Thomas   587161 587161 Larde, Thomas, of Cornewode, groom 8
3636777 1906293 1906293 defendant Sowton Robert   587161 587161 Sowton, Robert, of Cornewode, groom 9
3636778 1906293 1906293 defendant Foster Richard   587161 587161 Foster, Richard, of Cornewode, groom 10
3636779 1906293 1906293 defendant Miller George yeoman 587161 587161 Miller, George, of Cornewode, yeoman 11
3636780 1906293 1906293 defendant Towsan William   587161 587161 Towsan, William, of Cornewode, groom 12
3636781 1906293 1906293 defendant Weryng Thomas   587161 587161 Weryng, Thomas, of Cornewode, mason 13
3638025 1906710 1906710 defendant Rede William, junior yeoman 587161 587161 Rede, William, junior, of Cornewode, yeoman 0
3638027 1906711 1906711 defendant Rede William, junior yeoman 587161 587161 Rede, William, junior, of Cornewode, yeoman 0
3638029 1906712 1906712 defendant Rede William, junior yeoman 587161 587161 Rede, William, junior, of Cornewode, yeoman 0
3638031 1906713 1906713 defendant Rede William, junior yeoman 587161 587161 Rede, William, junior, of Cornewode, yeoman 0
3673816 1917841 1917841 defendant Hele Hugh   587161 587161 Hele, Hugh, of Cornewode, groom 0
3692158 1923715 1923715 defendant Colle John laborer 587161 587161 Colle, John, of Cornewode, laborer 8
3692159 1923715 1923715 defendant Baker William   587161 587161 Baker, William, of Cornewode, groom 9
3692160 1923715 1923715 defendant Slade Richard   587161 587161 Slade, Richard, of Cornewode, groom 10
3711206 1929809 1929809 defendant Hele Baldwin   587161 587161 Hele, Baldwin, of Cornewode, groom 0
3711207 1929809 1929809 defendant Hullond Thomas   587161 587161 Hullond, Thomas, of Cornewode, groom 1
3711208 1929809 1929809 defendant Wight Thomas husbandman 587161 587161 Wight, Thomas, of Cornewode, husbandman 2
3711209 1929809 1929809 defendant Flaysshemond John husbandman 587161 587161 Flaysshemond, John, of Cornewode, husbandman 3
3718345 1932023 1932023 defendant Hanger William husbandman 587161 587161 Hanger, William, of Cornewode, husbandman 0
3718346 1932023 1932023 defendant Hoper William husbandman 587161 587161 Hoper, William, of Cornewode, husbandman 1
3718347 1932023 1932023 defendant Hoper Walter yeoman 587161 587161 Hoper, Walter, of Cornewode, yeoman 2
3718348 1932023 1932023 defendant Geffray Robert   587161 587161 Geffray, Robert, of Cornewode, pedlar 3
3718353 1932024 1932024 defendant Hanger William husbandman 587161 587161 Hanger, William, of Cornewode, husbandman 0
3718354 1932024 1932024 defendant Hoper William husbandman 587161 587161 Hoper, William, of Cornewode, husbandman 1
3718355 1932024 1932024 defendant Hoper Walter yeoman 587161 587161 Hoper, Walter, of Cornewode, yeoman 2
3718356 1932024 1932024 defendant Geffray Robert   587161 587161 Geffray, Robert, of Cornewode, pedlar 3
3725866 1934365 1934365 defendant Hele Baldwin   587161 587161 Hele, Baldwin, of Cornewode, groom 0
3725867 1934365 1934365 defendant Hullond Thomas   587161 587161 Hullond, Thomas, of Cornewode, groom 1
3725868 1934365 1934365 defendant Wight Thomas husbandman 587161 587161 Wight, Thomas, of Cornewode, husbandman 2
3725869 1934365 1934365 defendant Flaysshemond John husbandman 587161 587161 Flaysshemond, John, of Cornewode, husbandman 3
3734048 1936898 1936898 defendant Hanger Walter husbandman 587161 587161 Hanger, Walter, of Cornewode, husbandman 0
3734049 1936898 1936898 defendant Hoper William husbandman 587161 587161 Hoper, William, of Cornewode, husbandman 1
3734050 1936898 1936898 defendant Hoper Walter yeoman 587161 587161 Hoper, Walter, of Cornewode, yeoman 2
3734051 1936898 1936898 defendant Geffray Robert   587161 587161 Geffray, Robert, of Cornewode, pedlar 3
3734098 1936917 1936917 defendant Cole John gent 587161 587161 Cole, John, of Cornewode, gent 0
3734099 1936917 1936917 defendant Brend Nicholas   587161 587161 Brend, Nicholas, of Cornewode, groom 1
3734100 1936917 1936917 defendant Ley Thomas husbandman 587161 587161 Ley, Thomas, of Cornewode, husbandman 2
3734101 1936917 1936917 defendant Kenycote William carpenter 587161 587161 Kenycote, William, of Cornewode, carpenter 3
3734102 1936917 1936917 defendant Kerswyll John husbandman 587161 587161 Kerswyll, John, of Cornewode, husbandman 4
3734103 1936917 1936917 defendant Hullond Thomas miller 587161 587161 Hullond, Thomas, of Cornewode, miller 5
3734104 1936917 1936917 defendant Jefferey Robert chapman 587161 587161 Jefferey, Robert, of Cornewode, chapman 6
3734105 1936917 1936917 defendant Iryshe John   587161 587161 Iryshe, John, of Cornewode, groom 7
3734106 1936917 1936917 defendant Hollond thomas, junior   587161 587161 Hollond, thomas, junior, of Cornewode, groom 8
3734107 1936917 1936917 defendant Cumppe Edward laborer 587161 587161 Cumppe, Edward, of Cornewode, laborer 9
3734108 1936917 1936917 defendant Hoper William laborer 587161 587161 Hoper, William, of Cornewode, laborer 10
3734109 1936917 1936917 defendant Hoper Walter   587161 587161 Hoper, Walter, of Cornewode, groom 11
3734110 1936917 1936917 defendant Flessheman John husbandman 587161 587161 Flessheman, John, of Cornewode, husbandman 12
3734112 1936917 1936917 defendant Stert Reginald husbandman 587161 587161 Stert, Reginald, of Cornewode, husbandman 14
3764587 1946580 1946580 defendant Rede George yeoman 587161 587161 Rede, George, of Cornewode, yeoman 0
3771885 1948898 1948898 defendant Cole John gent 587161 587161 Cole, John, of Cornewode, gent 0
3796955 1956929 1956929 defendant Hanger Walter husbandman 587161 587161 Hanger, Walter, of Cornewode, husbandman 0
3796956 1956929 1956929 defendant Hoper William husbandman 587161 587161 Hoper, William, of Cornewode, husbandman 1
3796957 1956929 1956929 defendant Hoper Walter yeoman 587161 587161 Hoper, Walter, of Cornewode, yeoman 2
3796958 1956929 1956929 defendant Geffrey Robert   587161 587161 Geffrey, Robert, of Cornewode, pedlar 3
3837869 1969759 1969759 defendant Abbott William   587161 587161 Abbott, William, of Cornewode, groom 0
3837870 1969759 1969759 defendant Abbott John yeoman 587161 587161 Abbott, John, of Cornewode, yeoman 1
3837871 1969759 1969759 defendant Smyth Henry yeoman 587161 587161 Smyth, Henry, of Cornewode, yeoman 2
3837872 1969759 1969759 defendant Denbawde William husbandman 587161 587161 Denbawde, William, of Cornewode, husbandman 3
3888077 1986266 1986266 defendant Hele Nicholas tinner 587161 587161 Hele, Nicholas, of Cornewode, tinner 0
3888079 1986267 1986267 defendant Hele Richard tinner 587161 587161 Hele, Richard, of Cornewode, tinner 0
3893846 1988164 1988164 defendant Jane Thomas tailor 587161 587161 Jane, Thomas, of Cornewode, tailor 0
3893848 1988164 1988164 defendant Somer John   587161 587161 Somer, John, of Cornewode, groom 2
3974467 2015646 2015646 plaintiff Hele Walter gent 587161 587161 Hele, Walter, of Cornewode, gent 0
3974470 2015647 2015647 plaintiff Hele Walter gent 587161 587161 Hele, Walter, of Cornewode, gent 0
3974471 2015647 2015647 plaintiff Hele John   587161 587161 Hele, John, of Cornewode, his son 1
4454783 2186507 2186507 plaintiff Mareys John   587161 587161 Mareys, John, of Cornewode, parson 0
4474230 2192592 2192592 defendant Colyton John de   587161 587161 Colyton, John de, of Cornewode, parson 0
4518306 2206100 2206100 defendant Colyton John de   587161 587161 Colyton, John de, of Cornewode, parson 0
4524328 2207945 2207945 defendant Gerveys John   587161 587161 Gerveys, John, of Cornewode 2
4711541 2268938 2268938 defendant Stapp Ralph smith 587161 587161 Stapp, Ralph, of Cornewode, smith 0
4757227 2282631 2282631 defendant Strode John husbandman 587161 587161 Strode, John, of Cornewode, husbandman 0
4762136 2284136 2284136 defendant Gode John husbandman 587161 587161 Gode, John, of Cornewode, husbandman 1
4769775 2286519 2286519 defendant Stappe Ralph smith 587161 587161 Stappe, Ralph, of Cornewode, smith 0
4780454 2289885 2289885 defendant Foster John husbandman 587161 587161 Foster, John, of Cornewode, husbandman 2
4826154 2304213 2304213 defendant Langham William   587161 587161 Langham, William, of Cornewode, franklin 0
4875981 2319448 2319448 defendant Fayschmond Benedict husbandman 587161 587161 Fayschmond, Benedict, of Cornewode, husbandman 0
4889317 2323447 2323447 defendant Ryplegh John clerk 587161 587161 Ryplegh, John, of Cornewode, clerk 0
4912761 2330493 2330493 defendant Forster John husbandman 587161 587161 Forster, John, of Cornewode, husbandman 0
4951351 2342386 2342386 defendant Fayschmound Benedict husbandman 587161 587161 Fayschmound, Benedict, of Cornewode, husbandman 0
4951352 2342386 2342386 defendant Fayschmound Walter husbandman 587161 587161 Fayschmound, Walter, of Cornewode, husbandman 1
4962103 2345571 2345571 defendant Flassheman Bonedon or Bovedon husbandman 587161 587161 Flassheman, Bonedon or Bovedon, of Cornewode, husbandman 2
4962104 2345571 2345571 defendant Flassheman Walter husbandman 587161 587161 Flassheman, Walter, of Cornewode, husbandman 3
4989279 2353725 2353725 defendant Ismay Thomas   587161 587161 Ismay, Thomas, of Cornewode, groom 1
5065918 2376329 2376329 defendant Ryplee John chaplain 587161 587161 Ryplee, John, of Cornewode, chaplain 0
5074131 2378750 2378750 defendant Flasshemond Reginald laborer 587161 587161 Flasshemond, Reginald, of Cornewode, laborer 0
5074133 2378750 2378750 defendant Topsam William husbandman 587161 587161 Topsam, William, of Cornewode, husbandman 2
5083851 2381672 2381672 defendant Sperkewell William tailor 587161 587161 Sperkewell, William, of Cornewode, tailor 0
5083853 2381673 2381673 defendant Sperkewill William tailor 587161 587161 Sperkewill, William, of Cornewode, tailor 0
5143486 2399229 2399229 defendant Cotewall John husbandman 587161 587161 Cotewall, John, of Cornewode, husbandman 0
5143488 2399230 2399230 defendant Cotewill John husbandman 587161 587161 Cotewill, John, of Cornewode, husbandman 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);