names

1,456 rows where place_id = 585947

✎ 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
3587551 1863755 1863755 defendant Bonand or Bovand Mathew husbandman 585947 585947 Bonand or Bovand, Mathew, of Hadley, husbandman 1
3592019 1865119 1865119 plaintiff Foord William merchant 585947 585947 Foord, William, of Hadley, merchant 0
3592159 1865167 1865167 defendant Telde Robert husbandman 585947 585947 Telde, Robert, of Hadley, husbandman 0
3592211 1865181 1865181 plaintiff Fulsnape Thomas clothmaker 585947 585947 Fulsnape, Thomas, of Hadley, clothmaker 0
3592215 1865182 1865182 plaintiff Fulsnape Thomas clothmaker 585947 585947 Fulsnape, Thomas, of Hadley, clothmaker 0
3594672 1865963 1865963 defendant Revers Seman husbandman 585947 585947 Revers, Seman, of Hadley, husbandman 2
3597114 1866721 1866721 defendant Wyllyot alias Spycer John fishmonger 585947 585947 Wyllyot alias Spycer, John, of Hadley, fishmonger 0
3597672 1866898 1866898 defendant Fen John husbandman 585947 585947 Fen, John, of Hadley, husbandman 0
3599868 1867609 1867609 defendant Marler Robert husbandman 585947 585947 Marler, Robert, of Hadley, husbandman 2
3601925 1868258 1868258 plaintiff Bloweboll William mercer 585947 585947 Bloweboll, William, of Hadley, mercer 0
3603205 1868669 1868669 defendant Loder Thomas clothmaker 585947 585947 Loder, Thomas, of Hadley, clothmaker 1
3603969 1868909 1868909 plaintiff Foord William merchant 585947 585947 Foord, William, of Hadley, merchant 0
3603980 1868912 1868912 plaintiff Ford William   585947 585947 Ford, William, of Hadley 0
3606119 1869581 1869581 defendant Isbell William barker 585947 585947 Isbell, William, of Hadley, barker 1
3607583 1870028 1870028 defendant Robynson William tiler 585947 585947 Robynson, William, of Hadley, tiler 0
3608980 1870467 1870467 defendant Fen John butcher 585947 585947 Fen, John, of Hadley, butcher 0
3609113 1870508 1870508 defendant Wellys John laborer 585947 585947 Wellys, John, of Hadley, laborer 2
3609117 1870509 1870509 defendant Wellys John laborer 585947 585947 Wellys, John, of Hadley, laborer 2
3609121 1870510 1870510 defendant Wellys John laborer 585947 585947 Wellys, John, of Hadley, laborer 2
3609310 1870570 1870570 defendant Blok William (legal representative) 585947 585947 Blok, William, of Hadley, fuller, executor of 0
3613301 1871810 1871810 defendant Balle Roger clothmaker 585947 585947 Balle, Roger, of Hadley, clothmaker 0
3613312 1871813 1871813 defendant Bromesmyth Andrew clothmaker 585947 585947 Bromesmyth, Andrew, of Hadley, clothmaker 2
3617378 1873054 1873054 defendant Munnyng Henry clothmaker 585947 585947 Munnyng, Henry, of Hadley, clothmaker 2
3617385 1873056 1873056 plaintiff Foorthe Robert merchant 585947 585947 Foorthe, Robert, of Hadley, merchant 0
3618423 1873396 1873396 defendant Becon John tailor 585947 585947 Becon, John, of Hadley, tailor 0
3618970 1873545 1873545 defendant Broune John yeoman 585947 585947 Broune, John, of Hadley, yeoman 0
3620091 1873859 1873859 defendant Breton John merchant 585947 585947 Breton, John, of Hadley, merchant 1
3620136 1873873 1873873 defendant Clerk Robert clothmaker 585947 585947 Clerk, Robert, of Hadley, clothmaker 0
3620137 1873873 1873873 defendant Clerk William clothmaker 585947 585947 Clerk, William, of Hadley, clothmaker 1
3622429 1874550 1874550 defendant Mannyng Thomas clothmaker 585947 585947 Mannyng, Thomas, of Hadley, clothmaker 3
3623641 1874926 1874926 defendant Beton John tailor 585947 585947 Beton, John, of Hadley, tailor 0
3626711 1903199 1903199 defendant Warde Robert burcher 585947 585947 Warde, Robert, of Hadley, burcher 4
3626712 1903199 1903199 defendant Dey John carrier 585947 585947 Dey, John, of Hadley, carrier 5
3626714 1903200 1903200 defendant Bendysshe John gent 585947 585947 Bendysshe, John, of Hadley, gent 0
3626715 1903201 1903201 plaintiff Barfote John, senior   585947 585947 Barfote, John, senior, of Hadley 0
3626716 1903201 1903201 defendant Bendysshe John gent 585947 585947 Bendysshe, John, of Hadley, gent 0
3627044 1903319 1903319 defendant Barfote John clothmaker 585947 585947 Barfote, John, of Hadley, clothmaker 0
3627239 1903366 1903366 defendant Quyntyn John, senior clothmaker 585947 585947 Quyntyn, John, senior, of Hadley, clothmaker 0
3627240 1903366 1903366 defendant Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 1
3627242 1903367 1903367 defendant Quyntyn John, senior clothmaker 585947 585947 Quyntyn, John, senior, of Hadley, clothmaker 0
3627243 1903367 1903367 defendant Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 1
3628632 1903829 1903829 defendant Smyth William clothmaker 585947 585947 Smyth, William, of Hadley, clothmaker 0
3630221 1904301 1904301 defendant Benall or Bevall John clothmaker 585947 585947 Benall or Bevall, John, of Hadley, clothmaker 0
3631039 1904529 1904529 defendant Sherman Peter sherman 585947 585947 Sherman, Peter, of Hadley, sherman 2
3631042 1904530 1904530 defendant Sherman Peter sherman 585947 585947 Sherman, Peter, of Hadley, sherman 0
3632313 1904926 1904926 defendant Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 1
3634384 1905553 1905553 defendant Hillary Robert clothmaker 585947 585947 Hillary, Robert, of Hadley, clothmaker 0
3634385 1905553 1905553 defendant Cowper Richard merchant 585947 585947 Cowper, Richard, of Hadley, merchant 1
3634386 1905553 1905553 defendant Goodale John asshburner 585947 585947 Goodale, John, of Hadley, asshburner 2
3634591 1905624 1905624 defendant Downyng John baker 585947 585947 Downyng, John, of Hadley, baker 1
3634958 1905735 1905735 defendant Amflete John husbandman 585947 585947 Amflete, John,of Hadley, husbandman 0
3635744 1905979 1905979 defendant Smyth John merchant 585947 585947 Smyth, John, of Hadley, merchant 0
3637446 1906519 1906519 defendant Reynham William singleman 585947 585947 Reynham, William, of Hadley, singleman 0
3637503 1906541 1906541 defendant Smyth John merchant 585947 585947 Smyth, John, of Hadley, merchant 0
3637504 1906541 1906541 defendant Bygley Thomas yeoman 585947 585947 Bygley, Thomas, of Hadley, yeoman 1
3637505 1906541 1906541 defendant Cavyll John yeoman 585947 585947 Cavyll, John, of Hadley, yeoman 2
3637757 1906624 1906624 defendant Mylyon Nicholas smith 585947 585947 Mylyon, Nicholas, of Hadley, smith 3
3638307 1906798 1906798 defendant Hasylden John husbandman 585947 585947 Hasylden, John, of Hadley, husbandman 2
3639438 1907142 1907142 defendant Kyng Richard   585947 585947 Kyng, Richard, of Hadley, card maker 1
3641274 1907722 1907722 defendant Man Richard husbandman 585947 585947 Man, Richard, of Hadley, husbandman 1
3643446 1908376 1908376 defendant Martyn Roger husbandman 585947 585947 Martyn, Roger, of Hadley, husbandman 0
3643447 1908376 1908376 defendant Martyn John husbandman 585947 585947 Martyn, John, of Hadley, husbandman 1
3643610 1908432 1908432 defendant Andrewe John husbandman 585947 585947 Andrewe, John, of Hadley, husbandman 1
3643611 1908432 1908432 defendant Norfolke homas husbandman 585947 585947 Norfolke, homas, of Hadley, husbandman 2
3645008 1908846 1908846 defendant Freman John yeoman 585947 585947 Freman, John, of Hadley, yeoman 0
3645009 1908846 1908846 defendant Breton John yeoman 585947 585947 Breton, John, of Hadley, yeoman 1
3646063 1909168 1909168 defendant Hall John carpenter 585947 585947 Hall, John, of Hadley, carpenter 1
3646065 1909168 1909168 defendant Bannand Joan widow 585947 585947 Bannand, Joan, of Hadley, widow 3
3647765 1909693 1909693 defendant Lungeys John fuller 585947 585947 Lungeys, John, of Hadley, fuller 0
3648835 1910024 1910024 defendant Luson Augustine husbandman 585947 585947 Luson, Augustine, of Hadley, husbandman 0
3648836 1910024 1910024 defendant Broke William clothmaker 585947 585947 Broke, William, of Hadley, clothmaker 1
3648839 1910025 1910025 defendant Veysy Robert clothmaker 585947 585947 Veysy, Robert, of Hadley, clothmaker 1
3648911 1910047 1910047 defendant Pascall Thomas weaver 585947 585947 Pascall, Thomas, of Hadley, weaver 1
3650336 1910481 1910481 defendant Smyth John clothmaker 585947 585947 Smyth, John, of Hadley, clothmaker 0
3650919 1910657 1910657 plaintiff Smyth William clothmaker 585947 585947 Smyth, William, of Hadley, clothmaker 0
3651638 1910872 1910872 defendant Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 1
3652279 1911051 1911051 defendant Bendyssh John gent 585947 585947 Bendyssh, John, of Hadley, gent 0
3653502 1911361 1911361 defendant Inglyssh John butcher 585947 585947 Inglyssh, John, of Hadley, butcher 0
3653503 1911361 1911361 defendant Tropnell William butcher 585947 585947 Tropnell, William, of Hadley, butcher 1
3654250 1911589 1911589 defendant Broun Robert laborer 585947 585947 Broun, Robert, of Hadley, laborer 0
3654697 1911727 1911727 defendant Wyff Thomas husbandman 585947 585947 Wyff, Thomas, of Hadley, husbandman 0
3654698 1911727 1911727 defendant Chall Robert husbandman 585947 585947 Chall, Robert, of Hadley, husbandman 1
3655249 1911899 1911899 plaintiff Blunte Philip gent 585947 585947 Blunte, Philip, of Hadley, gent 0
3655251 1911900 1911900 plaintiff Blwute Philip gent 585947 585947 Blwute, Philip, of Hadley, gent 0
3655850 1912085 1912085 defendant Colman William merchant 585947 585947 Colman, William, of Hadley, merchant 0
3655851 1912085 1912085 defendant Lelywhite John weaver 585947 585947 Lelywhite, John, of Hadley, weaver 1
3655853 1912085 1912085 defendant Cristmes Thomas, senior fuller 585947 585947 Cristmes, Thomas, senior, of Hadley, fuller 3
3655854 1912085 1912085 defendant Wylles John husbandman 585947 585947 Wylles, John, of Hadley, husbandman 4
3657324 1912551 1912551 defendant Geffreyson Christopher shoemaker 585947 585947 Geffreyson, Christopher, of Hadley, shoemaker 1
3657330 1912552 1912552 defendant Geffreyson Christopher shoemaker 585947 585947 Geffreyson, Christopher, of Hadley, shoemaker 1
3657492 1912604 1912604 defendant Carde John fuller 585947 585947 Carde, John, of Hadley, fuller 1
3657980 1912748 1912748 plaintiff Downyng John baker 585947 585947 Downyng, John, of Hadley, baker 0
3659438 1913212 1913212 defendant Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 0
3659440 1913213 1913213 defendant Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 0
3660394 1913508 1913508 defendant Byrde Nicholas smith 585947 585947 Byrde, Nicholas, of Hadley, smith 0
3660762 1913629 1913629 defendant Downyng John baker 585947 585947 Downyng, John, of Hadley, baker 0
3663279 1914440 1914440 defendant Freman John clothmaker 585947 585947 Freman, John, of Hadley, clothmaker 1
3665168 1915060 1915060 plaintiff Smyth William merchant 585947 585947 Smyth, William, of Hadley, merchant 0
3665171 1915060 1915060 defendant Martyn Thomas yeoman 585947 585947 Martyn, Thomas, of Hadley, yeoman 2
3665172 1915060 1915060 defendant Dey John carrier 585947 585947 Dey, John, of Hadley, carrier 3

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