names

104 rows where place_id = 597761

✎ 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
3629747 1904153 1904153 defendant Symondys Alice widow 597761 597761 Symondys, Alice, of Barnestaple, Devon, widow 1
3709905 1929412 1929412 defendant Symondys Alice widow 597761 597761 Symondys, Alice, of Barnestaple, Devon, widow 0
3715970 1931283 1931283 defendant Champeneys Peter chapman 597761 597761 Champeneys, Peter, of Barnestaple, Devon, chapman 0
3820063 1964154 1964154 defendant Heydon Richard gent 597761 597761 Heydon, Richard, of Barnestaple, Devon, gent 0
3822484 1964930 1964930 defendant Symons Alice widow 597761 597761 Symons, Alice, of Barnestaple, Devon, widow 0
4019759 2031799 2031799 defendant Witherudge John merchant 597761 597761 Witherudge, John, of Barnestaple, Devon, merchant 0
4019763 2031801 2031801 plaintiff Welshe John merchant 597761 597761 Welshe, John, of Barnestaple, Devon, merchant 0
4022971 2032937 2032937 plaintiff Baker Richard gent 597761 597761 Baker, Richard, of Barnestaple, Devon, gent 0
4024968 2033593 2033593 defendant Landman John, junior yeoman 597761 597761 Landman, John, junior, of Barnestaple, Devon, yeoman 0
4049708 2042334 2042334 defendant Landman John, junior yeoman 597761 597761 Landman, John, junior, of Barnestaple, Devon, yeoman 0
4050815 2042728 2042728 defendant Collybeare John merchant 597761 597761 Collybeare, John, of Barnestaple, Devon, merchant 2
4056403 2044675 2044675 plaintiff Brasier John merchant 597761 597761 Brasier, John, of Barnestaple, Devon, merchant 0
4059123 2045662 2045662 plaintiff Coliber William merchant 597761 597761 Coliber, William, of Barnestaple, Devon, merchant 0
4059125 2045663 2045663 plaintiff Coliber William merchant 597761 597761 Coliber, William, of Barnestaple, Devon, merchant 0
4080984 2053514 2053514 defendant Loder Robert   597761 597761 Loder, Robert, of Barnestaple, Devon 0
4085730 2055168 2055168 defendant Brasier John merchant 597761 597761 Brasier, John, of Barnestaple, Devon, merchant 0
4088948 2056349 2056349 defendant Arscott William merchant 597761 597761 Arscott, William, of Barnestaple, Devon, merchant 0
4098354 2059737 2059737 defendant Aire Bartholomew merchant 597761 597761 Aire, Bartholomew, of Barnestaple, Devon, merchant 0
4099093 2060001 2060001 defendant Hooper John merchant 597761 597761 Hooper, John, of Barnestaple, Devon, merchant 0
4101781 2060946 2060946 defendant Parker Edward yeoman 597761 597761 Parker, Edward, of Barnestaple, Devon, yeoman 0
4104028 2061714 2061714 defendant Deyman John merchant 597761 597761 Deyman, John, of Barnestaple, Devon, merchant 0
4110709 2064088 2064088 defendant Pleylond Edward tailor 597761 597761 Pleylond, Edward, of Barnestaple, Devon, tailor 0
4115292 2065759 2065759 defendant Beare Roger yeoman 597761 597761 Beare, Roger, of Barnestaple, Devon, yeoman 3
4115487 2065825 2065825 defendant Ferys Philip merchant 597761 597761 Ferys, Philip, of Barnestaple, Devon, merchant 0
4117157 2066442 2066442 defendant Bery Andrew merchant 597761 597761 Bery, Andrew, of Barnestaple, Devon, merchant 0
4117159 2066443 2066443 defendant Bright Henry dyer 597761 597761 Bright, Henry, of Barnestaple, Devon, dyer 0
4117510 2066560 2066560 defendant Hooper John chapman 597761 597761 Hooper, John, of Barnestaple, Devon, chapman 0
4117567 2066578 2066578 defendant Pearse George chapman 597761 597761 Pearse, George, of Barnestaple, Devon, chapman 0
4117573 2066580 2066580 defendant Welshe Richard chapman 597761 597761 Welshe, Richard, of Barnestaple, Devon, chapman 0
4118031 2066733 2066733 defendant Woodroff James merchant 597761 597761 Woodroff, James, of Barnestaple, Devon, merchant 0
4123631 2068754 2068754 defendant Snytall or Snedall John gent 597761 597761 Snytall or Snedall, John, of Barnestaple, Devon, gent 0
4133272 2072223 2072223 defendant Snytall John gent 597761 597761 Snytall, John, of Barnestaple, Devon, gent 0
4133303 2072235 2072235 defendant Snytall John gent 597761 597761 Snytall, John, of Barnestaple, Devon, gent 0
4140418 2074816 2074816 defendant Stephens alias Loder John yeoman 597761 597761 Stephens alias Loder, John, of Barnestaple, Devon, yeoman 0
4140421 2074817 2074817 defendant Stephens alias Loder Thomas yeoman 597761 597761 Stephens alias Loder, Thomas, of Barnestaple, Devon, yeoman 0
4142234 2075459 2075459 defendant Parker Edward yeoman 597761 597761 Parker, Edward, of Barnestaple, Devon, yeoman 0
4142415 2075520 2075520 defendant Ferreis Philip merchant 597761 597761 Ferreis, Philip, of Barnestaple, Devon, merchant 0
4155149 2079893 2079893 defendant Beare Roger merchant 597761 597761 Beare, Roger, of Barnestaple, Devon, merchant 1
4155349 2079962 2079962 defendant Peard Oliver (legal representative) 597761 597761 Peard, Oliver, of Barnestaple, Devon, merchant, executrix of 0
4167214 2084035 2084035 defendant Salisburye Robert merchant 597761 597761 Salisburye, Robert, of Barnestaple, Devon, merchant 0
4176965 2087417 2087417 defendant Brasyer Richard merchant 597761 597761 Brasyer, Richard, of Barnestaple, Devon, merchant 0
4179695 2088370 2088370 defendant Sparrowe Philip merchant 597761 597761 Sparrowe, Philip, of Barnestaple, Devon, merchant 0
4181203 2088903 2088903 defendant Cowte John yeoman 597761 597761 Cowte, John, of Barnestaple, Devon, yeoman 0
4190988 2092411 2092411 defendant Demon or Deymonde John chapman 597761 597761 Demon or Deymonde, John, of Barnestaple, Devon, chapman 0
4191045 2092433 2092433 defendant Sparrowe Philip chapman 597761 597761 Sparrowe, Philip, of Barnestaple, Devon, chapman 0
4195064 2093837 2093837 defendant Snytall John gent 597761 597761 Snytall, John, of Barnestaple, Devon, gent 0
4200993 2095905 2095905 defendant Sparrowe Philip chapman 597761 597761 Sparrowe, Philip, of Barnestaple, Devon, chapman 0
4205187 2097364 2097364 defendant Sallysbury Robert merchant 597761 597761 Sallysbury, Robert, of Barnestaple, Devon, merchant 1
4206957 2097977 2097977 defendant Delbridge Philip grocer 597761 597761 Delbridge, Philip, of Barnestaple, Devon, grocer 0
4208224 2098426 2098426 defendant Delbridge Roger chapman 597761 597761 Delbridge, Roger, of Barnestaple, Devon, chapman 0
4224785 2104136 2104136 defendant Hill Richard merchant 597761 597761 Hill, Richard, of Barnestaple, Devon, merchant 0
4229237 2105708 2105708 defendant Sparrowe James merchant 597761 597761 Sparrowe, James, of Barnestaple, Devon, merchant 2
4229406 2105766 2105766 defendant Lange John vintner 597761 597761 Lange, John, of Barnestaple, Devon, vintner 0
4232352 2106824 2106824 defendant Brasier John merchant 597761 597761 Brasier, John, of Barnestaple, Devon, merchant 0
4232356 2106825 2106825 defendant Delbridge George mercer 597761 597761 Delbridge, George, of Barnestaple, Devon, mercer 0
4241158 2110030 2110030 defendant Davie Thomas merchant 597761 597761 Davie, Thomas, of Barnestaple, Devon, merchant 0
4243193 2110715 2110715 defendant Norrys John merchant 597761 597761 Norrys, John, of Barnestaple, Devon, merchant 0
4243196 2110716 2110716 defendant Norrys John merchant 597761 597761 Norrys, John, of Barnestaple, Devon, merchant 0
4243858 2110928 2110928 defendant Sherman Walter merchant 597761 597761 Sherman, Walter, of Barnestaple, Devon, merchant 1
4245165 2111371 2111371 defendant Crosse Henry gent 597761 597761 Crosse, Henry, of Barnestaple, Devon, merchant, gent 0
4246894 2111935 2111935 defendant Harrys Richard merchant 597761 597761 Harrys, Richard, of Barnestaple, Devon, merchant 1
4247051 2111988 2111988 defendant Hill alias Spurway Walter merchant 597761 597761 Hill alias Spurway, Walter, of Barnestaple, Devon, merchant 0
4247054 2111989 2111989 defendant Hill alias Spurwaye Walter merchant 597761 597761 Hill alias Spurwaye, Walter, of Barnestaple, Devon, merchant 0
4247478 2112141 2112141 defendant Parker Thomas yeoman 597761 597761 Parker, Thomas, of Barnestaple, Devon, yeoman 0
4250150 2113029 2113029 defendant Davye Thomas merchant 597761 597761 Davye, Thomas, of Barnestaple, Devon, merchant 0
4254572 2114518 2114518 defendant Sherman Walter merchant 597761 597761 Sherman, Walter, of Barnestaple, Devon, merchant 1
4259087 2116010 2116010 defendant Sparrowe James merchant 597761 597761 Sparrowe, James, of Barnestaple, Devon, merchant 2
4259365 2116108 2116108 defendant Lange John vintner 597761 597761 Lange, John, of Barnestaple, Devon, vintner 0
4262603 2117159 2117159 defendant Palmer William merchant 597761 597761 Palmer, William, of Barnestaple, Devon, merchant 0
4264333 2117718 2117718 defendant Brasier John merchant 597761 597761 Brasier, John, of Barnestaple, Devon, merchant 0
4264341 2117720 2117720 defendant Delbridge George mercer 597761 597761 Delbridge, George, of Barnestaple, Devon, mercer 0
4264345 2117721 2117721 defendant Delbridge Roger merchant 597761 597761 Delbridge, Roger, of Barnestaple, Devon, merchant 0
4269376 2119349 2119349 defendant Taylor Stephen yeoman 597761 597761 Taylor, Stephen, of Barnestaple, Devon, yeoman 0
4280840 2123204 2123204 defendant Delbridge Philip chapman 597761 597761 Delbridge, Philip, of Barnestaple, Devon, chapman 0
4288822 2126057 2126057 defendant Yeo William chapman 597761 597761 Yeo, William, of Barnestaple, Devon, chapman 0
4290110 2126528 2126528 defendant Yeo William chapman 597761 597761 Yeo, William, of Barnestaple, Devon, chapman 0
4297094 2129060 2129060 defendant Harrys Richard mariner 597761 597761 Harrys, Richard, of Barnestaple, Devon, mariner 0
4301761 2130740 2130740 defendant Jenkyn William dyer 597761 597761 Jenkyn, William, of Barnestaple, Devon, dyer 0
4302494 2130991 2130991 defendant Hale Edward weaver 597761 597761 Hale, Edward, of Barnestaple, Devon, weaver 2
4304240 2131618 2131618 defendant Brasyer John merchant 597761 597761 Brasyer, John, of Barnestaple, Devon, merchant 0
4306550 2132428 2132428 defendant Thorne John, junior chapman 597761 597761 Thorne, John, junior, of Barnestaple, Devon, chapman 0
4318396 2136542 2136542 defendant Yeo William chapman 597761 597761 Yeo, William, of Barnestaple, Devon, chapman 2
4326472 2139216 2139216 defendant Downeman William, senior tailor 597761 597761 Downeman, William, senior, of Barnestaple, Devon, tailor 0
4326502 2139225 2139225 defendant Davie Thomas merchant 597761 597761 Davie, Thomas, of Barnestaple, Devon, merchant 0
4327735 2139601 2139601 defendant Yeo William chapman 597761 597761 Yeo, William, of Barnestaple, Devon, chapman 0
4344887 2145491 2145491 defendant Hill Richard merchant 597761 597761 Hill, Richard, of Barnestaple, Devon, merchant 0
4347682 2146438 2146438 defendant Norrys John merchant 597761 597761 Norrys, John, of Barnestaple, Devon, merchant 0
4355574 2149172 2149172 defendant Trender John clerk 597761 597761 Trender, John, of Barnestaple, Devon, clerk 0
4379492 2157749 2157749 defendant Yarde John   597761 597761 Yarde, John, of Barnestaple, Devon,, surgeon 1
4384934 2159651 2159651 defendant Yeo William mercer 597761 597761 Yeo, William, of Barnestaple, Devon, mercer 0
4384936 2159652 2159652 defendant Yeo John mercer 597761 597761 Yeo, John, of Barnestaple, Devon, mercer 0
4395394 2163041 2163041 defendant Smith John merchant 597761 597761 Smith, John, of Barnestaple, Devon, merchant 0
4398882 2164209 2164209 defendant Spurryer John chapman 597761 597761 Spurryer, John, of Barnestaple, Devon, chapman 0
4412447 2168754 2168754 defendant Downe Richard merchant 597761 597761 Downe, Richard, of Barnestaple, Devon, merchant 0
4809301 2299083 2299083 defendant Cole John, junior dyer 597761 597761 Cole, John, junior, of Barnestaple, Devon, dyer 0
4884893 2322171 2322171 defendant Cole John merchant 597761 597761 Cole, John, of Barnestaple, Devon, merchant 0
4886913 2322759 2322759 defendant Cole John merchant 597761 597761 Cole, John, of Barnestaple, Devon, merchant 0
4949517 2341844 2341844 defendant Hollam William dyer 597761 597761 Hollam, William, of Barnestaple, Devon, dyer 3
4975299 2349568 2349568 defendant Passeware Joan   597761 597761 Passeware, Joan, of Barnestaple, Devon, widow of Passeware, Thomas, alias widow of Ford, Roger, of Southon Dertemouth, Devon 0
5073087 2378436 2378436 defendant Gaynecote or Baynecote Walter merchant 597761 597761 Gaynecote or Baynecote, Walter, of Barnestaple, Devon, merchant 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);