names

470 rows where place_id = 587082

✎ 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
3590416 1864645 1864645 defendant Starky Peter yeoman 587082 587082 Starky, Peter, of Watford, yeoman 2
3590420 1864646 1864646 defendant Starkey Peter yeoman 587082 587082 Starkey, Peter, of Watford, yeoman 2
3598191 1867064 1867064 defendant Philip Thomas laborer 587082 587082 Philip, Thomas, of Watford, laborer 2
3598192 1867064 1867064 defendant Philip William laborer 587082 587082 Philip, William, of Watford, laborer 3
3598933 1867295 1867295 defendant Melsha John (legal representative) 587082 587082 Melsha, John, of Watford, gent, executors of 0
3603021 1868612 1868612 defendant Barakyll Richard miller 587082 587082 Barakyll, Richard, of Watford, miller 0
3603025 1868613 1868613 defendant Barakyll Richard miller 587082 587082 Barakyll, Richard, of Watford, miller 0
3603029 1868614 1868614 defendant Dyche Richard fuller 587082 587082 Dyche, Richard, of Watford, fuller 0
3607170 1869908 1869908 defendant Melsham John gent 587082 587082 Melsham, John, of Watford, gent 0
3607171 1869908 1869908 defendant Fox alias Egleston William baker 587082 587082 Fox alias Egleston, William, of Watford, baker 1
3607172 1869908 1869908 defendant Clyff or Olyff Thomas baker 587082 587082 Clyff or Olyff, Thomas, of Watford, baker 2
3611848 1871367 1871367 defendant Gore William yeoman 587082 587082 Gore, William, of Watford, yeoman 0
3611849 1871367 1871367 defendant Manston William yeoman 587082 587082 Manston, William, of Watford, yeoman 1
3611850 1871367 1871367 defendant Gamon William yeoman 587082 587082 Gamon, William, of Watford, yeoman 2
3614337 1872138 1872138 defendant Bostone John glover 587082 587082 Bostone, John, of Watford, glover 3
3623633 1874923 1874923 defendant Hoberd Richard fletcher 587082 587082 Hoberd, Richard, of Watford, fletcher 0
3627261 1903372 1903372 defendant Johnson William clothier 587082 587082 Johnson, William, of Watford, clothier 1
3628088 1903639 1903639 defendant West William smith 587082 587082 West, William, of Watford, smith 1
3632451 1904966 1904966 defendant Brodebent William laborer 587082 587082 Brodebent, William, of Watford, laborer 2
3632464 1904970 1904970 defendant Johnson William clothman 587082 587082 Johnson, William, of Watford, clothman 0
3634370 1905548 1905548 defendant Kysby Thomas butcher 587082 587082 Kysby, Thomas, of Watford, butcher 0
3636290 1906141 1906141 defendant Kysby Thomas butcher 587082 587082 Kysby, Thomas, of Watford, butcher 1
3636291 1906141 1906141 defendant Blakwell Thomas husbandman 587082 587082 Blakwell, Thomas, of Watford, husbandman 2
3645955 1909127 1909127 defendant Phillype Thomas husbandman 587082 587082 Phillype, Thomas, of Watford, husbandman 2
3654882 1911787 1911787 defendant Hykman Roger yeoman 587082 587082 Hykman, Roger, of Watford, yeoman 0
3660892 1913673 1913673 defendant Wodward John husbandman 587082 587082 Wodward, John, of Watford, husbandman 0
3676196 1918600 1918600 defendant Heyward William tailor 587082 587082 Heyward, William, of Watford, tailor 0
3678795 1919436 1919436 defendant Stoneham George husbandman 587082 587082 Stoneham, George, of Watford, husbandman 0
3678796 1919436 1919436 defendant Robson James laborer 587082 587082 Robson, James, of Watford, laborer 1
3678797 1919436 1919436 defendant Benston Thomas smith 587082 587082 Benston, Thomas, of Watford, smith 2
3702431 1927020 1927020 defendant Burneby Thomas gent 587082 587082 Burneby, Thomas, of Watford, gent 0
3723553 1933638 1933638 defendant Ewar John mercer 587082 587082 Ewar, John, of Watford, mercer 1
3723554 1933639 1933639 plaintiff Pegge William gent 587082 587082 Pegge, William, of Watford, gent 0
3723555 1933639 1933639 defendant Burford Richard gent 587082 587082 Burford, Richard, of Watford, gent 0
3737203 1937867 1937867 defendant Kesby Thomas butcher 587082 587082 Kesby, Thomas, of Watford, butcher 0
3738662 1938301 1938301 defendant Flemmyng Richard yeoman 587082 587082 Flemmyng, Richard, of Watford, yeoman 0
3740596 1938918 1938918 defendant Burneby Thomas esq 587082 587082 Burneby, Thomas, of Watford, esq 0
3745472 1940490 1940490 defendant Burford Richard husbandman 587082 587082 Burford, Richard, of Watford, husbandman 0
3753902 1943168 1943168 defendant Hulle William shoemaker 587082 587082 Hulle, William, of Watford, shoemaker 0
3753903 1943168 1943168 defendant Sawnsun William smith 587082 587082 Sawnsun, William, of Watford, smith 1
3760511 1945293 1945293 defendant Warde alias Cokke William tailor 587082 587082 Warde alias Cokke, William, of Watford, tailor 1
3761301 1945538 1945538 defendant Bryggys William bucher 587082 587082 Bryggys, William, of Watford, bucher 0
3761302 1945538 1945538 defendant Gysby Thomas bucher 587082 587082 Gysby, Thomas, of Watford, bucher 1
3761303 1945538 1945538 defendant Davy Robert bucher 587082 587082 Davy, Robert, of Watford, bucher 2
3768410 1947766 1947766 defendant Colett John husbandman 587082 587082 Colett, John, of Watford, husbandman 1
3768416 1947768 1947768 defendant Colett John husbandman 587082 587082 Colett, John, of Watford, husbandman 1
3775105 1949946 1949946 defendant Dutton William tailor 587082 587082 Dutton, William, of Watford, tailor 0
3775106 1949946 1949946 defendant Dutton Thomas weaver 587082 587082 Dutton, Thomas, of Watford, weaver 1
3775107 1949946 1949946 defendant Dutton John weaver 587082 587082 Dutton, John, of Watford, weaver 2
3775411 1950055 1950055 plaintiff Blake Edmund   587082 587082 Blake, Edmund, of Watford 0
3775414 1950055 1950055 defendant Dutton Thomas weaver 587082 587082 Dutton, Thomas, of Watford, weaver 2
3781963 1952107 1952107 defendant Estfeld John brewer 587082 587082 Estfeld, John, of Watford, brewer 0
3781964 1952107 1952107 defendant Samson William smith 587082 587082 Samson, William, of Watford, smith 1
3781965 1952107 1952107 defendant Estfeld William yeoman 587082 587082 Estfeld, William, of Watford, yeoman 2
3781966 1952107 1952107 defendant Edmunde John tailor 587082 587082 Edmunde, John, of Watford, tailor 3
3781967 1952107 1952107 defendant Grey William butcher 587082 587082 Grey, William, of Watford, butcher 4
3781968 1952107 1952107 defendant Monk William baker 587082 587082 Monk, William, of Watford, baker 5
3781969 1952107 1952107 defendant Chylde Thomas mealman 587082 587082 Chylde, Thomas, of Watford, mealman 6
3783469 1952580 1952580 defendant Bryne Isabel widow 587082 587082 Bryne, Isabel, of Watford, widow 0
3783471 1952581 1952581 defendant Bryne Isabel widow 587082 587082 Bryne, Isabel, of Watford, widow 0
3790337 1954795 1954795 defendant Gysbye Thomas butcher 587082 587082 Gysbye, Thomas, of Watford, butcher 0
3790749 1954931 1954931 defendant Blake Edmund chapman 587082 587082 Blake, Edmund, of Watford, chapman 0
3791631 1955224 1955224 defendant Dutton Thomas weaver 587082 587082 Dutton, Thomas, of Watford, weaver 0
3792741 1955583 1955583 defendant Dutton William tailor 587082 587082 Dutton, William, of Watford, tailor 0
3792742 1955583 1955583 defendant Dutton Thomas weaver 587082 587082 Dutton, Thomas, of Watford, weaver 1
3792743 1955583 1955583 defendant Dutton John weaver 587082 587082 Dutton, John, of Watford, weaver 2
3793138 1955714 1955714 defendant Pyndon John miller 587082 587082 Pyndon, John, of Watford, miller 0
3793139 1955714 1955714 defendant Burgeys William butcher 587082 587082 Burgeys, William, of Watford, butcher 1
3793141 1955714 1955714 defendant Colett William laborer 587082 587082 Colett, William, of Watford, laborer 3
3796274 1956700 1956700 defendant Baylly William fletcher 587082 587082 Baylly, William, of Watford, fletcher 0
3796847 1956894 1956894 defendant Blakwell Robert husbandman 587082 587082 Blakwell, Robert, of Watford, husbandman 0
3797381 1957068 1957068 plaintiff Gelly Hugh gent 587082 587082 Gelly, Hugh, of Watford, gent 0
3797388 1957070 1957070 plaintiff Gelly John gent 587082 587082 Gelly, John, of Watford, gent 0
3797390 1957071 1957071 plaintiff Gelly John gent 587082 587082 Gelly, John, of Watford, gent 0
3798652 1957488 1957488 defendant Eton John laborer 587082 587082 Eton, John, of Watford, laborer 0
3809514 1960858 1960858 defendant Wylson Richard miller 587082 587082 Wylson, Richard, of Watford, miller 0
3816123 1962945 1962945 defendant Carter William glover 587082 587082 Carter, William, of Watford, glover 0
3816124 1962945 1962945 defendant Dutton Thomas weaver 587082 587082 Dutton, Thomas, of Watford, weaver 1
3841571 1970948 1970948 defendant Gysby Thomas butcher 587082 587082 Gysby, Thomas, of Watford, butcher 0
3859900 1976816 1976816 defendant Boddymer John husbandman 587082 587082 Boddymer, John, of Watford, husbandman 3
3861268 1977238 1977238 defendant Marten Thomas maltmaker 587082 587082 Marten, Thomas, of Watford, maltmaker 0
3861269 1977238 1977238 defendant Burford Richard husbandman 587082 587082 Burford, Richard, of Watford, husbandman 1
3863951 1978120 1978120 defendant Androwe William husbandman 587082 587082 Androwe, William, of Watford, husbandman 0
3877203 1982616 1982616 plaintiff Hill Geoffrey (legal representative) 587082 587082 Hill, Geoffrey, of Watford, husbandman, executors of 0
3905499 1992109 1992109 defendant Wright William husbandman 587082 587082 Wright, William, of Watford, husbandman 2
3916827 1995993 1995993 plaintiff Fynche William clothier 587082 587082 Fynche, William, of Watford, clothier 0
3923560 1998188 1998188 defendant Kyssebye Thomas butcher 587082 587082 Kyssebye, Thomas, of Watford, butcher 0
3941902 2004303 2004303 defendant More Katherine widow 587082 587082 More, Katherine, of Watford, widow 1
3962574 2011501 2011501 defendant Lennewes John shoemaker 587082 587082 Lennewes, John, of Watford, shoemaker 0
4014824 2030016 2030016 defendant Heydon John gent 587082 587082 Heydon, John, of Watford, gent 0
4063417 2047204 2047204 defendant Baldwyn William yeoman 587082 587082 Baldwyn, William, of Watford, yeoman 0
4128858 2070617 2070617 defendant Samon John butcher 587082 587082 Samon, John, of Watford, butcher 0
4155341 2079959 2079959 defendant Bateman Robert innholder 587082 587082 Bateman, Robert, of Watford, innholder 0
4156492 2080346 2080346 defendant Longe Alexander chandler 587082 587082 Longe, Alexander, of Watford, chandler 0
4202967 2096584 2096584 defendant Bateman Robert innholder 587082 587082 Bateman, Robert, of Watford, innholder 0
4220727 2102750 2102750 defendant Stubbs John innholder 587082 587082 Stubbs, John, of Watford, innholder 0
4239054 2109281 2109281 defendant Ewer Ralph tanner 587082 587082 Ewer, Ralph, of Watford, tanner 0
4278351 2122367 2122367 defendant Pygrame William husbandman 587082 587082 Pygrame, William, of Watford, husbandman 1
4280972 2123248 2123248 defendant Nightingale David gent 587082 587082 Nightingale, David, of Watford, gent 0
4280973 2123248 2123248 defendant Bateman Robert vintner 587082 587082 Bateman, Robert, of Watford, vintner 1

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