names

95 rows where place_id = 596981

✎ 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
3626818 1903238 1903238 defendant Austen John husbandman 596981 596981 Austen, John, of Yardeley, husbandman 1
3630012 1904238 1904238 defendant Parker William husbandman 596981 596981 Parker, William, of Yardeley, husbandman 3
3630235 1904304 1904304 defendant Tiler John, senior tiler 596981 596981 Tiler, John, senior, of Yardeley, tiler 3
3630236 1904304 1904304 defendant Tiler John, junior tiler 596981 596981 Tiler, John, junior, of Yardeley, tiler 4
3632665 1905031 1905031 defendant Pake Thomas laborer 596981 596981 Pake, Thomas, of Yardeley, laborer 0
3633126 1905171 1905171 defendant Praty John yeoman 596981 596981 Praty, John, of Yardeley, yeoman 0
3635488 1905896 1905896 defendant Lytton alias Froste William husbandman 596981 596981 Lytton alias Froste, William, of Yardeley, husbandman 0
3635489 1905896 1905896 defendant Lytton alias Froste George husbandman 596981 596981 Lytton alias Froste, George, of Yardeley, husbandman 1
3639990 1907324 1907324 defendant Gayler George husbandman 596981 596981 Gayler, George, of Yardeley, husbandman 0
3645458 1908986 1908986 defendant Rygge Henry yeoman 596981 596981 Rygge, Henry, of Yardeley, yeoman 1
3645468 1908987 1908987 defendant Rygge Henry yeoman 596981 596981 Rygge, Henry, of Yardeley, yeoman 4
3656973 1912439 1912439 defendant Genyn William husbandman 596981 596981 Genyn, William, of Yardeley, husbandman 0
3656974 1912439 1912439 defendant Lodyngton Robert husbandman 596981 596981 Lodyngton, Robert, of Yardeley, husbandman 1
3656975 1912439 1912439 defendant Oswestur Thomas husbandman 596981 596981 Oswestur, Thomas, of Yardeley, husbandman 2
3675507 1918377 1918377 defendant Barker Christopher yeoman 596981 596981 Barker, Christopher, of Yardeley, yeoman 0
3692163 1923716 1923716 defendant Colyns Hugh   596981 596981 Colyns, Hugh, of Yardeley, minstrel 0
3692174 1923721 1923721 defendant Gaylard George husbandman 596981 596981 Gaylard, George, of Yardeley, husbandman 0
3696579 1925163 1925163 defendant Cryar Nicholas tailor 596981 596981 Cryar, Nicholas, of Yardeley, tailor 1
3710661 1929655 1929655 defendant Jeffreys John yeoman 596981 596981 Jeffreys, John, of Yardeley, yeoman 0
3720810 1932799 1932799 defendant johnson John pardoner 596981 596981 johnson, John, of Yardeley, pardoner 0
3724807 1934043 1934043 defendant Gaylard George yeoman 596981 596981 Gaylard, George, of Yardeley, yeoman 0
3737401 1937937 1937937 defendant Pensell William wheeler 596981 596981 Pensell, William, of Yardeley, wheeler 0
3740887 1939009 1939009 defendant Smalbroke Robert   596981 596981 Smalbroke, Robert, of Yardeley, gent, administrators of 0
3740888 1939009 1939009 defendant Thomas Griffin gent 596981 596981 (Thomas, Griffin, of Yardeley, gent 1
3753167 1942930 1942930 defendant Hill Richard yeoman 596981 596981 Hill, Richard, of Yardeley, yeoman 2
3770683 1948513 1948513 defendant Banes Miles tailor 596981 596981 Banes, Miles, of Yardeley, tailor 0
3779638 1951361 1951361 defendant Jeffrey Thomas wheeler 596981 596981 Jeffrey, Thomas, of Yardeley, wheeler 0
3779639 1951361 1951361 defendant Jeffrey Thomas, junior wheeler 596981 596981 Jeffrey, Thomas, junior, of Yardeley, wheeler 1
3779640 1951361 1951361 defendant Thomas Griffin gent 596981 596981 Thomas, Griffin, of Yardeley, gent 2
3797144 1956990 1956990 defendant Jeffreys John husbandman 596981 596981 Jeffreys, John, of Yardeley, husbandman 0
3801164 1958284 1958284 defendant Norres Hugh   596981 596981 Norres, Hugh, of Yardeley 1
3816722 1963136 1963136 defendant Butler William yeoman 596981 596981 Butler, William,of Yardeley, yeoman 1
3821762 1964693 1964693 defendant Smalbroke Robert (legal representative) 596981 596981 Smalbroke, Robert, of Yardeley, executrix of 4
3830112 1967318 1967318 defendant Geffrey John husbandman 596981 596981 Geffrey, John, of Yardeley, husbandman 0
3846773 1972543 1972543 defendant Swyft William husbandman 596981 596981 Swyft, William, of Yardeley, husbandman 1
3854104 1974919 1974919 defendant Gedyll John smith 596981 596981 Gedyll, John, of Yardeley, smith 0
3858452 1976302 1976302 defendant Corser Thomas yeoman 596981 596981 Corser, Thomas, of Yardeley, yeoman 1
3862269 1977567 1977567 defendant Byssell John smith 596981 596981 Byssell, John, of Yardeley, smith 0
3862272 1977568 1977568 defendant Swyfte William husbandman 596981 596981 Swyfte, William, of Yardeley, husbandman 1
3867575 1979391 1979391 defendant Lane William husbandman 596981 596981 Lane, William, of Yardeley, husbandman 0
3877575 1982740 1982740 plaintiff Humerston Leonard   596981 596981 Humerston, Leonard, of Yardeley 0
3901089 1990589 1990589 defendant Shepard Edward husbandman 596981 596981 Shepard, Edward, of Yardeley, husbandman 0
3901241 1990639 1990639 defendant Butler William yeoman 596981 596981 Butler, William, of Yardeley, yeoman 3
3901290 1990657 1990657 defendant Elson John husbandman 596981 596981 Elson, John, of Yardeley, husbandman 0
3902610 1991106 1991106 defendant Butler William yeoman 596981 596981 Butler, William, of Yardeley, yeoman 0
3906159 1992352 1992352 defendant Pensell William   596981 596981 Pensell, William, of Yardeley, wheelwright 2
3906909 1992598 1992598 defendant Watton Thomas smith 596981 596981 Watton, Thomas, of Yardeley, smith 0
3906974 1992620 1992620 defendant Jeffereys John husbandman 596981 596981 Jeffereys, John, of Yardeley, husbandman 0
3908012 1992972 1992972 defendant Est Edward gent 596981 596981 Est, Edward, of Yardeley, gent 0
3908055 1992990 1992990 plaintiff Prety John gent 596981 596981 Prety, John, of Yardeley, gent 0
3908056 1992990 1992990 defendant Arnam alias Baker Richard   596981 596981 Arnam alias Baker, Richard, of Yardeley, husbandman, exercutors of 0
3908057 1992990 1992990 defendant Hopkyns Thomas yeoman 596981 596981 (Hopkyns, Thomas, of Yardeley, yeoman 1
3911418 1994134 1994134 defendant Knyght Humphrey yeoman 596981 596981 Knyght, Humphrey, of Yardeley, yeoman 0
3917174 1996105 1996105 defendant Benford Daniel gent 596981 596981 Benford, Daniel, of Yardeley, gent 0
3920719 1997277 1997277 defendant Pype John husbandman 596981 596981 Pype, John, of Yardeley, husbandman 1
3922494 1997840 1997840 defendant Acocky Richard yeoman 596981 596981 Acocky, Richard, of Yardeley, yeoman 1
3922499 1997842 1997842 defendant Prattye John wheeler 596981 596981 Prattye, John, of Yardeley, wheeler 0
3924420 1998478 1998478 defendant Thomas Griffin yeoman 596981 596981 Thomas, Griffin, of Yardeley, yeoman 0
3925752 1998928 1998928 defendant Pype John yeoman 596981 596981 Pype, John, of Yardeley, yeoman 0
3932632 2001208 2001208 defendant Watton Thomas blacksmith 596981 596981 Watton, Thomas, of Yardeley, blacksmith 0
3954116 2008513 2008513 defendant Holmes John, senior (legal representative) 596981 596981 Holmes, John, senior, of Yardeley, yeoman, executrix of 0
3966349 2012858 2012858 defendant Acocke Richard Worcs, yeoman 596981 596981 Acocke Richard, of Yardeley, Worcs, yeoman 0
3966691 2012985 2012985 defendant Shotebolte Thomas gent 596981 596981 Shotebolte, Thomas, of Yardeley, gent 0
3980389 2017755 2017755 defendant Swyfte Richard smith 596981 596981 Swyfte, Richard, of Yardeley, smith 0
4025385 2033737 2033737 defendant Smythe Robert butcher 596981 596981 Smythe, Robert, of Yardeley, butcher 2
4063686 2047303 2047303 defendant Halfhyde Richard yeoman 596981 596981 Halfhyde, Richard, of Yardeley, yeoman 1
4075255 2051454 2051454 defendant Delphen Ralph husbandman 596981 596981 Delphen, Ralph, of Yardeley, husbandman 1
4075256 2051454 2051454 defendant Havard Ralph smith 596981 596981 Havard, Ralph, of Yardeley, smith 2
4088873 2056322 2056322 defendant Myles Thomas carpenter 596981 596981 Myles, Thomas, of Yardeley, carpenter 0
4088875 2056323 2056323 defendant Myles Thomas carpenter 596981 596981 Myles, Thomas, of Yardeley, carpenter 0
4101190 2060735 2060735 defendant Jennyns John shoemaker 596981 596981 Jennyns, John, of Yardeley, shoemaker 2
4132544 2071956 2071956 defendant Watton William yeoman 596981 596981 Watton, William, of Yardeley, yeoman 0
4154801 2079774 2079774 defendant Bolton Thomas smith 596981 596981 Bolton, Thomas, of Yardeley, or of Sherleye, Warks, smith 0
4154802 2079774 2079774 defendant Watton Richard smith 596981 596981 Watton, Richard, of Yardeley, smith 1
4179124 2088173 2088173 defendant Bolton Thomas smith 596981 596981 Bolton, Thomas, of Yardeley, or of Shearleaye, Worcs, smith 0
4180487 2088656 2088656 defendant Watton William yeoman 596981 596981 Watton, William, of Yardeley, yeoman 0
4189289 2091750 2091750 defendant Byddell Thomas wheeler 596981 596981 Byddell, Thomas, of Yardeley, wheeler 0
4189291 2091750 2091750 defendant Dowler Thomas cooper 596981 596981 Dowler, Thomas, of Yardeley, cooper 2
4214984 2100742 2100742 defendant Mylles Thomas carpenter 596981 596981 Mylles, Thomas, of Yardeley, carpenter 1
4295963 2128655 2128655 defendant Wayte Thomas   596981 596981 Wayte, Thomas, of Yardeley, tile maker 0
4324127 2138474 2138474 defendant Chakett or Chetchett Robert cooper 596981 596981 Chakett or Chetchett, Robert, of Yardeley, cooper 0
4324128 2138474 2138474 defendant Wayte Thomas   596981 596981 Wayte, Thomas, of Yardeley, tile maker 1
5216318 2420512 2420512 defendant Coterell William husbandman 596981 596981 Coterell, William, of Yardeley, husbandman 0
5319168 2450829 2450829 plaintiff Harreys Lawrence   596981 596981 Harreys, Lawrence, of Yardeley 0
5368008 2465619 2465619 plaintiff Cotrell William, senior   596981 596981 Cotrell, William, senior, of Yardeley 0
5379844 2469281 2469281 defendant Dolfyn Richard husbandman 596981 596981 Dolfyn, Richard, of Yardeley, husbandman 0
5389836 2472156 2472156 defendant Dolfyn Richard husbandman 596981 596981 Dolfyn, Richard, of Yardeley, husbandman 0
5389837 2472156 2472156 defendant Dolvyn John husbandman 596981 596981 Dolvyn, John, of Yardeley, husbandman 1
5402624 2475825 2475825 defendant Nele John husbandman 596981 596981 Nele, John, of Yardeley, husbandman 0
5419010 2480613 2480613 defendant Ponyar John husbandman 596981 596981 Ponyar, John, of Yardeley, husbandman 0
5448142 2489334 2489334 defendant Nele John husbandman 596981 596981 Nele, John, of Yardeley, husbandman 0
5459784 2492853 2492853 plaintiff Holder Robert (legal representative) 596981 596981 Holder, Robert, of Yardeley, executors of 0
5480727 2499198 2499198 plaintiff Dolphyn John   596981 596981 Dolphyn, John, of Yardeley 0
5579926 2528802 2528802 defendant Adams Robert yeoman 596981 596981 Adams, Robert, of Yardeley, yeoman 1
5583969 2530060 2530060 defendant Shotbolt William yeoman 596981 596981 Shotbolt, William, of Yardeley, yeoman 0

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);