names

183 rows where place_id = 594054

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614392 1872150 1872150 defendant Smalwode Isabel widow 594054 594054 Smalwode, Isabel, of Barkyng, widow 0
3628853 1903899 1903899 defendant Burre Thomas   594054 594054 Burre, Thomas, of Barkyng 0
3638285 1906792 1906792 defendant Gaysham John yeoman 594054 594054 Gaysham, John, of Barkyng, yeoman 0
3642059 1907968 1907968 defendant Gold William tanner 594054 594054 Gold, William, of Barkyng, tanner 0
3642060 1907968 1907968 defendant Fayne Thomas laborer 594054 594054 Fayne, Thomas, of Barkyng, laborer 1
3642061 1907968 1907968 defendant Hyll Thomas laborer 594054 594054 Hyll, Thomas, of Barkyng, laborer 2
3642062 1907968 1907968 defendant A More John tailor 594054 594054 A More, John, of Barkyng, tailor 3
3642063 1907968 1907968 defendant Neuport William laborer 594054 594054 Neuport, William, of Barkyng, laborer 4
3653153 1911320 1911320 defendant Gaysham John yeoman 594054 594054 Gaysham, John, of Barkyng, yeoman 0
3653500 1911360 1911360 defendant Gaysh John yeoman 594054 594054 Gaysh, John, of Barkyng, yeoman 0
3655981 1912122 1912122 defendant Benet John tailor 594054 594054 Benet, John, of Barkyng, tailor 0
3655982 1912122 1912122 defendant Buteler Andrew   594054 594054 Buteler, Andrew, of Barkyng, cord wainer 1
3655984 1912122 1912122 defendant Botcley Robert laborer 594054 594054 Botcley, Robert, of Barkyng, laborer 3
3655985 1912122 1912122 defendant Newport Thomas laborer 594054 594054 Newport, Thomas, of Barkyng, laborer 4
3667377 1915734 1915734 defendant Gaysham John yeoman 594054 594054 Gaysham, John, of Barkyng, yeoman 0
3667471 1915767 1915767 defendant Gaysham John yeoman 594054 594054 Gaysham, John, of Barkyng, yeoman 0
3667784 1915866 1915866 plaintiff Wyott William gent 594054 594054 Wyott, William, of Barkyng, gent 0
3667788 1915866 1915866 defendant Hooley Richard laborer 594054 594054 Hooley, Richard, of Barkyng, laborer 3
3667789 1915866 1915866 defendant Benet John tailor 594054 594054 Benet, John, of Barkyng, tailor 4
3675113 1918246 1918246 defendant Wyncham Thomas butcher 594054 594054 Wyncham, Thomas, of Barkyng, butcher 0
3676182 1918595 1918595 defendant Nycoll John yeoman 594054 594054 Nycoll, John, of Barkyng, yeoman 0
3676183 1918595 1918595 defendant Thomson William miller 594054 594054 Thomson, William, of Barkyng, miller 1
3678825 1919446 1919446 defendant Yonge William yeoman 594054 594054 Yonge, William, of Barkyng, yeoman 0
3678827 1919446 1919446 defendant Russell Henry tiler 594054 594054 Russell, Henry, of Barkyng, tiler 2
3678828 1919446 1919446 defendant Goulde William tanner 594054 594054 Goulde, William, of Barkyng, tanner 3
3678830 1919446 1919446 defendant Bonyngton or Bovyngton Isabel widow 594054 594054 Bonyngton or Bovyngton, Isabel, of Barkyng, widow 5
3679909 1919782 1919782 defendant Bramley Richard tailor 594054 594054 Bramley, Richard, of Barkyng, tailor 0
3680119 1919851 1919851 plaintiff Rande William gent 594054 594054 Rande, William, of Barkyng, gent 0
3681736 1920384 1920384 defendant Broke John husbandman 594054 594054 Broke, John, of Barkyng, husbandman 0
3682044 1920493 1920493 defendant Claxston William laborer 594054 594054 Claxston, William, of Barkyng, laborer 0
3682815 1920731 1920731 defendant Coke alias Fyssher Richard laborer 594054 594054 Coke alias Fyssher, Richard, of Barkyng, laborer 0
3682816 1920731 1920731 defendant Coke alias Fyssher Thomas laborer 594054 594054 Coke alias Fyssher, Thomas, of Barkyng, laborer 1
3684288 1921219 1921219 defendant Hemmyng Robert butcher 594054 594054 Hemmyng, Robert, of Barkyng, butcher 0
3684289 1921219 1921219 defendant Hokley Richard carpenter 594054 594054 Hokley, Richard, of Barkyng, carpenter 1
3684290 1921219 1921219 defendant Stamp Robert laborer 594054 594054 Stamp, Robert, of Barkyng, laborer 2
3688722 1922634 1922634 defendant Reynold Richard husbandman 594054 594054 Reynold, Richard, of Barkyng, husbandman 0
3694170 1924382 1924382 defendant Bugge Robert husbandman 594054 594054 Bugge, Robert, of Barkyng, husbandman 1
3694497 1924485 1924485 defendant Hooke Thomas yeoman 594054 594054 Hooke, Thomas, of Barkyng, yeoman 0
3695583 1924847 1924847 plaintiff Rand William gent 594054 594054 Rand, William, of Barkyng, gent 0
3695594 1924851 1924851 plaintiff Rande William gent 594054 594054 Rande, William, of Barkyng, gent 0
3699065 1925914 1925914 defendant Estwell Richard tanner 594054 594054 Estwell, Richard, of Barkyng, tanner 0
3702659 1927101 1927101 defendant Garbach Robert husbandman 594054 594054 Garbach, Robert, of Barkyng, husbandman 0
3705827 1928103 1928103 defendant Burre Thomas tanner 594054 594054 Burre, Thomas, of Barkyng, tanner 0
3709015 1929115 1929115 defendant Broun John husbandman 594054 594054 Broun, John, of Barkyng, husbandman 0
3709018 1929116 1929116 defendant Broun John husbandman 594054 594054 Broun, John, of Barkyng, husbandman 0
3714124 1930718 1930718 defendant Bugge Robert husbandman 594054 594054 Bugge, Robert, of Barkyng, husbandman 0
3715481 1931128 1931128 defendant Barrowe Thomas tanner 594054 594054 Barrowe, Thomas, of Barkyng, tanner 0
3715483 1931129 1931129 defendant Barrowe Thomas tanner 594054 594054 Barrowe, Thomas, of Barkyng, tanner 0
3717211 1931669 1931669 defendant Busshell Henry laborer 594054 594054 Busshell, Henry, of Barkyng, laborer 1
3717212 1931669 1931669 defendant Middelton Thomas tanner 594054 594054 Middelton, Thomas, of Barkyng, tanner 2
3719953 1932509 1932509 defendant Stephyn John yeoman 594054 594054 Stephyn, John, of Barkyng, yeoman 1
3721417 1933006 1933006 defendant Lucas Robert carpenter 594054 594054 Lucas, Robert, of Barkyng, carpenter 0
3721418 1933006 1933006 defendant Fakenbrigge Thomas carpenter 594054 594054 Fakenbrigge, Thomas, of Barkyng, carpenter 1
3721419 1933006 1933006 defendant Sykys Richard carpenter 594054 594054 Sykys, Richard, of Barkyng, carpenter 2
3721420 1933006 1933006 defendant Rogers Robert carpenter 594054 594054 Rogers, Robert, of Barkyng, carpenter 3
3730624 1935813 1935813 defendant Smyth Henry laborer 594054 594054 Smyth, Henry, of Barkyng, laborer 0
3730625 1935813 1935813 defendant Gery John reeder 594054 594054 Gery, John, of Barkyng, reeder 1
3730627 1935813 1935813 defendant Dawhurst John laborer 594054 594054 Dawhurst, John, of Barkyng, laborer 3
3743849 1939962 1939962 defendant Laraunce Christopher gent 594054 594054 Laraunce, Christopher, of Barkyng, gent 0
3743850 1939962 1939962 defendant Person Michael tanner 594054 594054 Person, Michael, of Barkyng, tanner 1
3743852 1939962 1939962 defendant Gold William tanner 594054 594054 Gold, William, of Barkyng, tanner 3
3748736 1941536 1941536 defendant Wright John yeoman 594054 594054 Wright, John, of Barkyng, yeoman 0
3753839 1943145 1943145 defendant Wryght alias Avery John baker 594054 594054 Wryght alias Avery, John, of Barkyng, baker 0
3755608 1943712 1943712 defendant Laurens Christopher gent 594054 594054 Laurens, Christopher, of Barkyng, gent 0
3759426 1944938 1944938 defendant Wynslowe Richard mariner 594054 594054 Wynslowe, Richard, of Barkyng, mariner 0
3759640 1945003 1945003 defendant Harlewyn William husbandman 594054 594054 Harlewyn, William, of Barkyng, husbandman 2
3759641 1945003 1945003 defendant Damott Thomas husbandman 594054 594054 Damott, Thomas, of Barkyng, husbandman 3
3759827 1945070 1945070 defendant Nevett John laborer 594054 594054 Nevett, John, of Barkyng, laborer 2
3761098 1945472 1945472 defendant Pegion John fisherman 594054 594054 Pegion, John, of Barkyng, fisherman 0
3762525 1945922 1945922 defendant Bugge Robert husbandman 594054 594054 Bugge, Robert, of Barkyng, husbandman 3
3765193 1946778 1946778 defendant Severne William butcher 594054 594054 Severne, William, of Barkyng, butcher 0
3768077 1947653 1947653 defendant Lawrence Christopher yeoman 594054 594054 Lawrence, Christopher, of Barkyng, yeoman 1
3773578 1949448 1949448 defendant Laurens Christopher gent 594054 594054 Laurens, Christopher, of Barkyng, gent 0
3773581 1949449 1949449 defendant Laurens Christopher gent 594054 594054 Laurens, Christopher, of Barkyng, gent 0
3774278 1949675 1949675 defendant Stane Thomas husbandman 594054 594054 Stane, Thomas, of Barkyng, husbandman 0
3775869 1950206 1950206 defendant Blakesley Michael husbandman 594054 594054 Blakesley, Michael, of Barkyng, husbandman 0
3777647 1950758 1950758 defendant Glascok William husbandman 594054 594054 Glascok, William, of Barkyng, husbandman 0
3780714 1951700 1951700 defendant Damett Thomas husbandman 594054 594054 Damett, Thomas, of Barkyng, husbandman 0
3782338 1952230 1952230 defendant Walworth William laborer 594054 594054 Walworth, William, of Barkyng, laborer 0
3782339 1952230 1952230 defendant Cawkyn John butcher 594054 594054 Cawkyn, John, of Barkyng, butcher 1
3782340 1952230 1952230 defendant Blak Thomas laborer 594054 594054 Blak, Thomas, of Barkyng, laborer 2
3782341 1952230 1952230 defendant Nargate John laborer 594054 594054 Nargate, John, of Barkyng, laborer 3
3786312 1953510 1953510 defendant Parson Thomas tanner 594054 594054 Parson, Thomas, of Barkyng, tanner 0
3790179 1954747 1954747 defendant Den Thomas laborer 594054 594054 Den, Thomas, of Barkyng, laborer 2
3792608 1955547 1955547 defendant Yong Thomas weaver 594054 594054 Yong, Thomas, of Barkyng, weaver 2
3795412 1956437 1956437 defendant Whaleys Agnes widow 594054 594054 Whaleys, Agnes, of Barkyng, widow 0
3798958 1957587 1957587 defendant Hunt John laborer 594054 594054 Hunt, John, of Barkyng, laborer 0
3798959 1957587 1957587 defendant Cawkyng John laborer 594054 594054 Cawkyng, John, of Barkyng, laborer 1
3798960 1957587 1957587 defendant Humfrey John carpenter 594054 594054 Humfrey, John, of Barkyng, carpenter 2
3798961 1957587 1957587 defendant Phelyppe Richard laborer 594054 594054 Phelyppe, Richard, of Barkyng, laborer 3
3798962 1957587 1957587 defendant Hunteley george   594054 594054 Hunteley, george, of Barkyng, cook 4
3800879 1958184 1958184 defendant Stodderd John husbandman 594054 594054 Stodderd, John, of Barkyng, husbandman 1
3800880 1958184 1958184 defendant Northbrue Robert fisherman 594054 594054 Northbrue, Robert, of Barkyng, fisherman 2
3804397 1959312 1959312 defendant Tonbroke Barnard beer brewer 594054 594054 Tonbroke, Barnard, of Barkyng, beer brewer 0
3812228 1961727 1961727 defendant Damot Thomas husbandman 594054 594054 Damot, Thomas, of Barkyng, husbandman 0
3821958 1964761 1964761 defendant Roberd John husbandman 594054 594054 Roberd, John, of Barkyng, husbandman 2
3822520 1964943 1964943 defendant Estwell Agnes widow 594054 594054 Estwell, Agnes, of Barkyng, widow 1
3829168 1967005 1967005 defendant Payn Thomas husbandman 594054 594054 Payn, Thomas, of Barkyng, husbandman 4
3841035 1970767 1970767 defendant Goldyng Thomas butcher 594054 594054 Goldyng, Thomas, of Barkyng, butcher 0
3843023 1971347 1971347 defendant Armested William husbandman 594054 594054 Armested, William, of Barkyng, 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);