names

123 rows where place_id = 599449

✎ 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
3636822 1906309 1906309 defendant Cobbe John thatcher 599449 599449 Cobbe, John, of Est Barsham, thatcher 2
3673579 1917765 1917765 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3673582 1917766 1917766 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3673585 1917767 1917767 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3689609 1922910 1922910 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3689611 1922911 1922911 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3689613 1922912 1922912 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3689615 1922913 1922913 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3689618 1922914 1922914 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3689622 1922915 1922915 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3698422 1925726 1925726 defendant Lowen Richard (legal representative) 599449 599449 Lowen, Richard, of Est Barsham, husbandman, executors of 2
3704154 1927596 1927596 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3704156 1927597 1927597 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3704158 1927598 1927598 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3727262 1934801 1934801 defendant Nyghtyngale Robert chaplain 599449 599449 Nyghtyngale, Robert, of Est Barsham, chaplain 0
3748553 1941479 1941479 defendant Cowper James husbandman 599449 599449 (Cowper, James, of Est Barsham, husbandman 5
3761870 1945720 1945720 defendant Holdernes Thomas husbandman 599449 599449 Holdernes, Thomas, of Est Barsham, husbandman 3
3761993 1945759 1945759 defendant Howlett John husbandman 599449 599449 Howlett, John, of Est Barsham, husbandman 1
3761996 1945759 1945759 defendant Bright Christopher husbandman 599449 599449 Bright, Christopher, of Est Barsham, husbandman 4
3764264 1946481 1946481 defendant Howlett John husbandman 599449 599449 Howlett, John, of Est Barsham, husbandman 3
3779762 1951404 1951404 plaintiff Fermour Henry esq 599449 599449 Fermour, Henry, of Est Barsham, esq 0
3813891 1962255 1962255 plaintiff Fermour Henry gent 599449 599449 Fermour, Henry, of Est Barsham, gent 0
3816014 1962908 1962908 defendant Sumptor William husbandman 599449 599449 Sumptor, William, of Est Barsham, husbandman 2
3816016 1962908 1962908 defendant Sumpter William smith 599449 599449 Sumpter, William, of Est Barsham, smith 4
3831347 1967692 1967692 defendant Hypgam Robert husbandman 599449 599449 Hypgam, Robert, of Est Barsham, husbandman 2
3837564 1969657 1969657 defendant Fermour Henry (legal representative) 599449 599449 Fermour, Henry, of Est Barsham, knight, executors of 0
3837565 1969657 1969657 defendant Fermour William esq 599449 599449 (Fermour, William, of Est Barsham, esq 1
3851405 1974039 1974039 defendant Cowper James mercer 599449 599449 Cowper, James, of Est Barsham, mercer 0
3861247 1977234 1977234 plaintiff Fermour Henry (legal representative) 599449 599449 Fermour, Henry, of Est Barsham, knight, executors of 0
3862247 1977558 1977558 defendant Sumpter William smith 599449 599449 Sumpter, William, of Est Barsham, smith 1
3864319 1978261 1978261 defendant Hipgham Richard husbandman 599449 599449 Hipgham, Richard, of Est Barsham, husbandman 0
3865179 1978559 1978559 defendant Tylney Henry yeoman 599449 599449 Tylney, Henry, of Est Barsham, yeoman 0
3873351 1981304 1981304 defendant Trenche Edmund yeoman 599449 599449 Trenche, Edmund, of Est Barsham, yeoman 0
3874310 1981633 1981633 defendant Fermor William esq 599449 599449 Fermor, William, of Est Barsham, esq 1
3888751 1986492 1986492 plaintiff Fermour Henry (legal representative) 599449 599449 Fermour, Henry, of Est Barsham, knight, executor of 0
3888989 1986558 1986558 defendant Hypgame Robert husbandman 599449 599449 Hypgame, Robert, of Est Barsham, husbandman 0
3888990 1986558 1986558 defendant Fekys Thomas husbandman 599449 599449 Fekys, Thomas, of Est Barsham, husbandman 1
3889700 1986791 1986791 defendant Fokys John husbandman 599449 599449 Fokys, John, of Est Barsham, husbandman 0
3889701 1986791 1986791 defendant Fokys Thomas husbandman 599449 599449 Fokys, Thomas, of Est Barsham, husbandman 1
3889943 1986873 1986873 defendant Fokys Thomas husbandman 599449 599449 Fokys, Thomas, of Est Barsham, husbandman 1
3891141 1987304 1987304 defendant Oldeman John, junior husbandman 599449 599449 Oldeman, John, junior, of Est Barsham, husbandman 0
3896293 1988971 1988971 defendant Fermour William   599449 599449 Fermour, William, of Est Barsham, knight 1
3896779 1989134 1989134 defendant Hypgam Robert warrener 599449 599449 Hypgam, Robert, of Est Barsham, warrener 1
3902801 1991167 1991167 plaintiff Fermour William   599449 599449 Fermour, William, of Est Barsham, knight 0
3903756 1991491 1991491 defendant Fokys John husbandman 599449 599449 Fokys, John, of Est Barsham, husbandman 0
3903757 1991491 1991491 defendant Fokys Thomas husbandman 599449 599449 Fokys, Thomas, of Est Barsham, husbandman 1
3943242 2004759 2004759 defendant Barnard George husbandman 599449 599449 Barnard, George, of Est Barsham, husbandman 1
3944391 2005136 2005136 defendant Howlett Robert yeoman 599449 599449 Howlett, Robert, of Est Barsham, yeoman 0
3956228 2009243 2009243 defendant Howlett Robert husbandman 599449 599449 Howlett, Robert, of Est Barsham, husbandman 3
3968026 2013446 2013446 defendant Spylman Henry esq 599449 599449 Spylman, Henry, of Est Barsham, esq 0
4026182 2034012 2034012 defendant Hendrye Thomas yeoman 599449 599449 Hendrye, Thomas, of Est Barsham, yeoman 1
4029116 2035057 2035057 defendant Tyllett Randolph yeoman 599449 599449 Tyllett, Randolph, of East Barsham, yeoman 3
4029121 2035058 2035058 defendant Tyllett Reginald or Ranulph yeoman 599449 599449 Tyllett, Reginald or Ranulph, of East Barsham, yeoman 3
4031374 2035891 2035891 plaintiff Fermor Nicholas gent 599449 599449 Fermor, Nicholas, of East Barsham, gent 0
4031377 2035892 2035892 plaintiff Fermor Nicholas gent 599449 599449 Fermor, Nicholas, of East Barsham, gent 0
4031380 2035893 2035893 plaintiff Fermor Nicholas gent 599449 599449 Fermor, Nicholas, of Est Barsham, gent 0
4059690 2045859 2045859 defendant Hendrye Thomas yeoman 599449 599449 Hendrye, Thomas, of East Barsham, yeoman 0
4223574 2103734 2103734 defendant Dedham Daniel singleman 599449 599449 Dedham, Daniel, of East Barsham, singleman 0
4261782 2116896 2116896 defendant Fermour Thomas esq 599449 599449 Fermour, Thomas, of Est Barsham, esq 1
4286040 2125062 2125062 defendant Heasell Robert husbandman 599449 599449 Heasell, Robert, of Est Barsham, husbandman 0
4286041 2125062 2125062 defendant Ringsteed John husbandman 599449 599449 Ringsteed, John, of Est Barsham, husbandman 1
4286042 2125062 2125062 defendant Ponder or Pouder John   599449 599449 Ponder or Pouder, John, of Est Barsham, shepherd 2
4334360 2141768 2141768 defendant Fermor Thomas esq 599449 599449 Fermor, Thomas, of Est Barsham, or of Dunton, Norf, esq 2
4353564 2148470 2148470 defendant Fermor Thomas esq 599449 599449 Fermor, Thomas, of East Barsham, esq 1
4379119 2157614 2157614 defendant Haslewood Robert husbandman 599449 599449 Haslewood, Robert, of East Barsham, husbandman 0
4405683 2166469 2166469 defendant Fermor Thomas esq 599449 599449 Fermor, Thomas, of East Barsham, esq 1
4409155 2167664 2167664 defendant Haslewood Robert husbandman 599449 599449 Haslewood, Robert, of East Barsham, husbandman 0
4442518 2182607 2182607 defendant Pesemyn John   599449 599449 Pesemyn, John, of Est Barsham 2
4459297 2187956 2187956 defendant Haweve or Hawene Thomas   599449 599449 Haweve or Hawene, Thomas, of East Barsham 0
4467501 2190517 2190517 plaintiff Austyn Roger   599449 599449 Austyn, Roger, of East Barsham, parson 0
4551290 2216341 2216341 defendant Peron Thomas smith 599449 599449 Peron, Thomas, of East Barsham, smith 0
4551291 2216341 2216341 defendant Styward William   599449 599449 Styward, William, of East Barsham 1
4678789 2258970 2258970 defendant Perne Peter laborer 599449 599449 Perne, Peter, of East Barsham, laborer 1
4761905 2284067 2284067 defendant Pyke John husbandman 599449 599449 Pyke, John, of East Barsham, husbandman 0
4761906 2284067 2284067 defendant Mason Robert yeoman 599449 599449 Mason, Robert, of East Barsham, yeoman 1
4771030 2286919 2286919 plaintiff Rous Alan   599449 599449 Rous, Alan, of East Barsham 0
4771031 2286919 2286919 defendant Marshall John   599449 599449 Marshall, John, of East Barsham, mason 0
4771032 2286919 2286919 defendant Marchall Thomas yeoman 599449 599449 Marchall, Thomas, of East Barsham, yeoman 1
4912445 2330398 2330398 defendant Wattes Thomas husbandman 599449 599449 Wattes, Thomas, of East Barsham, husbandman 0
4912447 2330398 2330398 defendant Skarlet William husbandman 599449 599449 Skarlet, William, of East Barsham, husbandman 2
4916347 2331614 2331614 defendant Wyntere John yeoman 599449 599449 Wyntere, John, of East Barsham, yeoman 0
4916348 2331614 2331614 defendant Wyntere Richard yeoman 599449 599449 Wyntere, Richard, of East Barsham, yeoman 1
4916354 2331616 2331616 defendant Carell or Capell John yeoman 599449 599449 Carell or Capell, John, of East Barsham, yeoman 0
4923760 2333874 2333874 plaintiff Molle Richard yeoman 599449 599449 Molle, Richard, of East Barsham, yeoman 0
4978743 2350591 2350591 defendant Capell John husbandman 599449 599449 (Capell, John, of Est Barsham, husbandman 3
4978744 2350591 2350591 defendant Torell William husbandman 599449 599449 Torell, William, of Est Barsham, husbandman 4
5053412 2372625 2372625 defendant Chapell John husbandman 599449 599449 Chapell, John, of Est Barsham, husbandman 3
5085544 2382165 2382165 defendant Stalworth William   599449 599449 Stalworth, William, of Est Barsham, servant 0
5085545 2382165 2382165 defendant Bangot John   599449 599449 Bangot, John, of Est Barsham, servant 1
5085546 2382165 2382165 defendant Wode John esq 599449 599449 together with Wode, John, of Est Barsham, esq 2
5089642 2383345 2383345 defendant Sompter Roger husbandman 599449 599449 Sompter, Roger, of Est Barsham, husbandman 1
5099759 2386366 2386366 defendant Smyth William husbandman 599449 599449 Smyth, William, of Est Barsham, husbandman 0
5115883 2391073 2391073 defendant Wode John gent 599449 599449 Wode, John, of Est Barsham, gent 2
5142464 2398923 2398923 defendant Andrewys Simon husbandman 599449 599449 Andrewys, Simon, of East Barsham, husbandman 0
5163775 2405139 2405139 defendant Andrewys Simon husbandman 599449 599449 Andrewys, Simon, of East Barsham, husbandman 0
5177273 2409046 2409046 defendant Andrewys Simon husbandman 599449 599449 Andrewys, Simon, of East Barsham, husbandman 0
5211387 2419064 2419064 defendant Andrewys Simon husbandman 599449 599449 Andrewys, Simon, of East Barsham, husbandman 0
5230933 2424655 2424655 defendant Duntyngg Adam clerk 599449 599449 Duntyngg, Adam, of Est Barsham, clerk 0
5232331 2425034 2425034 defendant Somonde John smith 599449 599449 Somonde, John, of Est Barsham, smith 2
5232373 2425039 2425039 defendant Symonde John smith 599449 599449 Symonde, John, of Est Barsham, smith 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);