names

388 rows where place_id = 586274

✎ 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
3588323 1863999 1863999 defendant Colyford John yeoman 586274 586274 Colyford, John, of Barnestaple, yeoman 0
3588324 1863999 1863999 defendant Uppecote John yeoman 586274 586274 Uppecote, John, of Barnestaple, yeoman 1
3597623 1866881 1866881 defendant Aphowell Mathew tailor 586274 586274 Aphowell, Mathew, of Barnestaple, tailor 0
3599407 1867456 1867456 defendant Jenkyn Richard merchant 586274 586274 Jenkyn, Richard, of Barnestaple, merchant 0
3599410 1867457 1867457 defendant Jenkyn Richard merchant 586274 586274 Jenkyn, Richard, of Barnestaple, merchant 0
3622774 1874654 1874654 defendant Roper John mercer 586274 586274 Roper, John, of Barnestaple, mercer 1
3638208 1906769 1906769 defendant Elyott Thomas glover 586274 586274 Elyott, Thomas, of Barnestaple, glover 0
3643464 1908383 1908383 defendant Swayne John painter 586274 586274 Swayne, John, of Barnestaple, painter 1
3643467 1908383 1908383 defendant Dodrygge Thomas yeoman 586274 586274 Dodrygge, Thomas, of Barnestaple, yeoman 4
3660833 1913654 1913654 defendant Martyn John dyer 586274 586274 Martyn, John, of Barnestaple, dyer 1
3684901 1921412 1921412 defendant Hogge Thomas yeoman 586274 586274 Hogge, Thomas, of Barnestaple, yeoman 1
3732132 1936285 1936285 defendant Lyttelstone John mercer 586274 586274 Lyttelstone, John, of Barnestaple, mercer 0
3732800 1936488 1936488 defendant Thomas Robert tanner 586274 586274 Thomas, Robert, of Barnestaple, tanner 0
3790284 1954778 1954778 defendant Howay John merchant 586274 586274 Howay, John, of Barnestaple, merchant 0
3795023 1956307 1956307 defendant Ruckeleve John yeoman 586274 586274 Ruckeleve, John, of Barnestaple, yeoman 0
3813121 1962015 1962015 defendant Mathewe Stephen yeoman 586274 586274 Mathewe, Stephen, of Barnestaple, yeoman 1
3819809 1964076 1964076 defendant Skynner Richard merchant 586274 586274 Skynner, Richard, of Barnestaple, merchant 2
3819810 1964076 1964076 defendant Draper John tanner 586274 586274 Draper, John, of Barnestaple, tanner 3
3822078 1964797 1964797 defendant Lang Robert capper 586274 586274 (Lang, Robert, of Barnestaple, capper 1
3822585 1964968 1964968 defendant Lyttell John carrier 586274 586274 Lyttell, John, of Barnestaple, carrier 0
3873408 1981320 1981320 defendant Salysbury John merchant 586274 586274 Salysbury, John, of Barnestaple, merchant 0
3895757 1988790 1988790 defendant Blake Thomas smith 586274 586274 Blake, Thomas, of Barnestaple, smith 0
3900315 1990338 1990338 defendant Hamond Philip laborer 586274 586274 Hamond, Philip, of Barnestaple, laborer 0
3912857 1994631 1994631 plaintiff Averey Mark merchant 586274 586274 Averey, Mark, of Barnestaple, merchant 0
3916262 1995823 1995823 defendant Hollond John grocer 586274 586274 Hollond, John, of Barnestaple, merchant, servant with Gerveys, John, of Bristol, grocer 0
3948549 2006554 2006554 plaintiff Darte John merchant 586274 586274 Darte, John, of Barnestaple, merchant 0
3964802 2012298 2012298 defendant Ayre Bartholomew merchant 586274 586274 Ayre, Bartholomew, of Barnestaple, merchant 0
3970293 2014206 2014206 plaintiff Dart John merchant 586274 586274 Dart, John, of Barnestaple, merchant 0
3970295 2014207 2014207 plaintiff Dart John merchant 586274 586274 Dart, John, of Barnestaple, merchant 0
3970297 2014208 2014208 plaintiff Dart John merchant 586274 586274 Dart, John, of Barnestaple, merchant 0
3971599 2014627 2014627 defendant Horwood Philip weaver 586274 586274 Horwood, Philip, of Barnestaple, weaver 0
3971600 2014627 2014627 defendant Collybeare William merchant 586274 586274 Collybeare, William, of Barnestaple, merchant 1
3986346 2019857 2019857 plaintiff Welsshe John merchant 586274 586274 Welsshe, John, of Barnestaple, merchant 0
3987147 2020148 2020148 plaintiff Wychehals Nicholas merchant 586274 586274 Wychehals, Nicholas, of Barnestaple, merchant 0
3987149 2020149 2020149 plaintiff Wychehals Nicholas merchant 586274 586274 Wychehals, Nicholas, of Barnestaple, merchant 0
3987151 2020150 2020150 plaintiff Wychehalse Nicholas merchant 586274 586274 Wychehalse, Nicholas, of Barnestaple, merchant 0
3987153 2020151 2020151 plaintiff Wychehalse Nicholas merchant 586274 586274 Wychehalse, Nicholas, of Barnestaple, merchant 0
3987499 2020278 2020278 plaintiff Wytheridge Richard cordwainer 586274 586274 Wytheridge, Richard, of Barnestaple, cordwainer 0
3991390 2021675 2021675 plaintiff Brasyer Hugh merchant 586274 586274 Brasyer, Hugh, of Barnestaple, merchant 0
3991391 2021675 2021675 plaintiff Beaple Thomas merchant 586274 586274 Beaple, Thomas, of Barnestaple, merchant 1
4005905 2026883 2026883 plaintiff Landman John, junior   586274 586274 Landman, John, junior, of Barnestaple 0
4005907 2026884 2026884 plaintiff Landman John, junior   586274 586274 Landman, John, junior, of Barnestaple 0
4020314 2031987 2031987 plaintiff Wichehalse Mary widow 586274 586274 Wichehalse, Mary, of Barnestaple, widow 0
4029895 2035335 2035335 defendant Parker John weaver 586274 586274 Parker, John, of Barnestaple, weaver 0
4029897 2035336 2035336 defendant Parker John weaver 586274 586274 Parker, John, of Barnestaple, weaver 0
4034878 2037151 2037151 defendant Honye or Hovye Richard, junior cordwainer 586274 586274 Honye or Hovye, Richard, junior, of Barnestaple, cordwainer 1
4034879 2037151 2037151 defendant Hony or Hovy John cordwainer 586274 586274 Hony or Hovy, John, of Barnestaple, cordwainer 2
4034896 2037156 2037156 defendant Puggesleigh Henry butcher 586274 586274 Puggesleigh, Henry, of Barnestaple, butcher 1
4034907 2037160 2037160 plaintiff Hayne John, junior   586274 586274 Hayne, John, junior, of Barnestaple 0
4034910 2037161 2037161 plaintiff Hayne John, junior   586274 586274 Hayne, John, junior, of Barnestaple 0
4039067 2038597 2038597 defendant Puggesley Henry butcher 586274 586274 Puggesley, Henry, of Barnestaple, butcher 0
4050068 2042451 2042451 plaintiff Walshe John merchant 586274 586274 Walshe, John, of Barnestaple, merchant 0
4050167 2042491 2042491 defendant Myll Simon tailor 586274 586274 Myll, Simon, of Barnestaple, tailor 0
4063765 2047325 2047325 defendant Skynner Thomas yeoman 586274 586274 Skynner, Thomas, of Barnestaple, yeoman 0
4071174 2049995 2049995 defendant Beaple Thomas (legal representative) 586274 586274 Beaple, Thomas, of Barnestaple, merchant, executor of 0
4071175 2049995 2049995 defendant Beare Roger merchant 586274 586274 Beare, Roger, of Barnestaple, merchant 1
4080957 2053503 2053503 defendant Sparrowe James merchant 586274 586274 Sparrowe, James, of Barnestaple, merchant 0
4080989 2053517 2053517 plaintiff Welshe John merchant 586274 586274 Welshe, John, of Barnestaple, merchant 0
4080991 2053518 2053518 plaintiff Welshe John merchant 586274 586274 Welshe, John, of Barnestaple, merchant 0
4088949 2056349 2056349 defendant Courtys William glover 586274 586274 Courtys, William, of Barnestaple, glover 1
4088950 2056349 2056349 defendant Sparrowe James merchant 586274 586274 Sparrowe, James, of Barnestaple, merchant 2
4097735 2059521 2059521 defendant Witheridge John merchant 586274 586274 Witheridge, John, of Barnestaple, merchant 0
4110266 2063934 2063934 defendant Arscott Mary widow 586274 586274 Arscott, Mary, of Barnestaple, widow 0
4110267 2063934 2063934 defendant Arscott William merchant 586274 586274 Arscott, William, of Barnestaple, merchant 1
4110269 2063935 2063935 defendant Parker Thomas yeoman 586274 586274 Parker, Thomas, of Barnestaple, yeoman 0
4117161 2066444 2066444 defendant Merywether James haberdasher 586274 586274 Merywether, James, of Barnestaple, haberdasher 0
4120497 2067610 2067610 defendant Merewether James hatter 586274 586274 Merewether, James, of Barnestaple, felt maker, hatter 0
4125163 2069286 2069286 defendant Beaple Roger tanner 586274 586274 Beaple, Roger, of Barnestaple, tanner 0
4125165 2069287 2069287 defendant Wichehals Mary widow 586274 586274 Wichehals, Mary, of Barnestaple, widow 0
4131779 2071682 2071682 defendant Kytt John   586274 586274 Kytt, John, of Barnestaple, felt maker 1
4136022 2073220 2073220 defendant Brasyer Richard merchant 586274 586274 Brasyer, Richard, of Barnestaple, merchant 0
4148317 2077541 2077541 defendant Beaple Roger tanner 586274 586274 Beaple, Roger, of Barnestaple, tanner 0
4155107 2079880 2079880 defendant Drewe Richard blacksmith 586274 586274 Drewe, Richard, of Barnestaple, horse courser, blacksmith 0
4155148 2079893 2079893 defendant Beaple Thomas merchant 586274 586274 Beaple, Thomas, of Barnestaple, merchant executor of 0
4163178 2082653 2082653 defendant Thorne John weaver 586274 586274 Thorne, John, of Barnestaple, weaver 0
4167212 2084034 2084034 defendant Salisberye Robert merchant 586274 586274 Salisberye, Robert, of Barnestaple, merchant 1
4179682 2088367 2088367 defendant Sherman Walter merchant 586274 586274 Sherman, Walter, of Barnestaple, merchant 0
4179691 2088369 2088369 defendant Hille Richard yeoman 586274 586274 Hille, Richard, of Barnestaple, yeoman 1
4179692 2088369 2088369 defendant Jule James glover 586274 586274 Jule, James, of Barnestaple, glover 2
4190989 2092411 2092411 defendant Sparrowe Philip chapman 586274 586274 Sparrowe, Philip, of Barnestaple, chapman 1
4196534 2094332 2094332 defendant Beaple Roger tanner 586274 586274 Beaple, Roger, of Barnestaple, tanner 0
4196882 2094460 2094460 defendant Welshe John merchant 586274 586274 Welshe, John, of Barnestaple, merchant 0
4200031 2095562 2095562 defendant Taylor John tailor 586274 586274 Taylor, John, of Barnestaple, tailor 0
4200901 2095872 2095872 defendant Knyll John merchant 586274 586274 Knyll, John, of Barnestaple, merchant 0
4203129 2096643 2096643 defendant Sherman Walter merchant 586274 586274 Sherman, Walter, of Barnestaple, merchant 0
4203134 2096645 2096645 defendant Hille Richard yeoman 586274 586274 Hille, Richard, of Barnestaple, yeoman 1
4203135 2096645 2096645 defendant Jule James glover 586274 586274 Jule, James, of Barnestaple, glover 2
4203798 2096884 2096884 defendant Beaple Thomas (legal representative) 586274 586274 Beaple, Thomas, of Barnestaple merchant, executors of 0
4203799 2096884 2096884 defendant Beare Roger gent 586274 586274 (Beare, Roger, of Barnestaple, gent 1
4205806 2097578 2097578 defendant Knyll John merchant 586274 586274 Knyll, John, of Barnestaple, merchant 0
4206951 2097974 2097974 defendant Horwood David weaver 586274 586274 Horwood, David, of Barnestaple, weaver 2
4206958 2097977 2097977 defendant Delbridge Roger grocer 586274 586274 Delbridge, Roger, of Barnestaple, grocer 1
4209022 2098708 2098708 defendant Martyn Richard tailor 586274 586274 Martyn, Richard, of Barnestaple, tailor 0
4219500 2102320 2102320 defendant Pyne George gent 586274 586274 Pyne, George, of Barnestaple, gent 0
4244498 2111140 2111140 defendant Jenkyn Robert dyer 586274 586274 Jenkyn, Robert, of Barnestaple, dyer 0
4247052 2111988 2111988 defendant Hunte William tucker 586274 586274 Hunte, William, of Barnestaple, tucker 1
4247055 2111989 2111989 defendant Hunte William tucker 586274 586274 Hunte, William, of Barnestaple, tucker 1
4248265 2112410 2112410 defendant Norrys John merchant 586274 586274 Norrys, John, of Barnestaple, merchant 1
4255938 2114961 2114961 defendant Horwoode John weaver 586274 586274 Horwoode, John, of Barnestaple, linen draper, weaver 0
4257759 2115567 2115567 defendant Pyne George gent 586274 586274 Pyne, George, of Barnestaple, gent 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);