names

135 rows where place_id = 594060

✎ 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
3614419 1872160 1872160 defendant Bat James husbandman 594060 594060 Bat, James, of Whaddon, husbandman 0
3632331 1904933 1904933 defendant Medowys John husbandman 594060 594060 Medowys, John, of Whaddon, husbandman 2
3719273 1932313 1932313 defendant Longe Robert yeoman 594060 594060 Longe, Robert, of Whaddon, yeoman 2
3743806 1939947 1939947 defendant Pygott Elizabeth widow 594060 594060 Pygott, Elizabeth, of Whaddon, widow 1
3764697 1946621 1946621 defendant Pygot Elizabeth widow 594060 594060 Pygot, Elizabeth, of Whaddon, widow 0
3765085 1946744 1946744 defendant Pygot Elizabeth widow 594060 594060 Pygot, Elizabeth, of Whaddon, widow 0
3765087 1946745 1946745 defendant Pygot Elizabeth widow 594060 594060 Pygot, Elizabeth, of Whaddon, widow 0
3765089 1946746 1946746 defendant Pygot Elizabeth widow 594060 594060 Pygot, Elizabeth, of Whaddon, widow 0
3765090 1946746 1946746 defendant Wyllot Robert yeoman 594060 594060 Wyllot, Robert, of Whaddon, yeoman 1
3765092 1946747 1946747 defendant Pygott Elizabeth widow 594060 594060 Pygott, Elizabeth, of Whaddon, widow 0
3766142 1947062 1947062 defendant Lylly John husbandman 594060 594060 Lylly, John, of Whaddon, husbandman 0
3772122 1948974 1948974 defendant More John esq 594060 594060 More, John, of Whaddon, esq 0
3772125 1948974 1948974 defendant Tayllour Thomas laborer 594060 594060 Tayllour, Thomas, of Whaddon, laborer 3
3780566 1951651 1951651 defendant Lylly John husbandman 594060 594060 Lylly, John, of Whaddon, husbandman 0
3782674 1952323 1952323 defendant Pygott Elizabeth widow 594060 594060 Pygott, Elizabeth, of Whaddon, widow 0
3782679 1952324 1952324 defendant Pygott Elizabeth widow 594060 594060 Pygott, Elizabeth, of Whaddon, widow 0
3789778 1954635 1954635 defendant More John esq 594060 594060 More, John, of Whaddon, esq 0
3789781 1954635 1954635 defendant Tayllour Thomas laborer 594060 594060 Tayllour, Thomas, of Whaddon, laborer 3
3789783 1954636 1954636 defendant More John esq 594060 594060 More, John, of Whaddon, esq 0
3789786 1954636 1954636 defendant Tayllour Thomas laborer 594060 594060 Tayllour, Thomas, of Whaddon, laborer 3
3840523 1970596 1970596 defendant Wattys Henry gent 594060 594060 Wattys, Henry, of Whaddon, gent 0
4212389 2099882 2099882 defendant Moreley John gent 594060 594060 Moreley, John, of Whaddon, gent 0
4218764 2102062 2102062 defendant Churche Thomas husbandman 594060 594060 Churche, Thomas, of Whaddon, husbandman 0
4227879 2105233 2105233 defendant Churche Thomas husbandman 594060 594060 Churche, Thomas, of Whaddon, husbandman 0
4289985 2126482 2126482 defendant Ellysander William husbandman 594060 594060 Ellysander, William, of Whaddon, husbandman 0
4503067 2201530 2201530 defendant Chapman William   594060 594060 Chapman, William, of Whaddon 0
4574479 2223549 2223549 defendant Lilie John   594060 594060 Lilie, John, of Whaddon 0
4574482 2223550 2223550 defendant Lilie John   594060 594060 Lilie, John, of Whaddon 0
4586706 2227248 2227248 defendant Lylye John   594060 594060 Lylye, John, of Whaddon 0
4609114 2233957 2233957 defendant Lylye John   594060 594060 Lylye, John, of Whaddon 0
4617974 2236629 2236629 plaintiff Gyfford John   594060 594060 Gyfford, John, of Whaddon 0
4619057 2236953 2236953 defendant Lily John   594060 594060 Lily, John, of Whaddon 0
4641844 2243716 2243716 defendant Giffard John   594060 594060 Giffard, John, of Whaddon 0
4653669 2247075 2247075 defendant Dekon William husbandman 594060 594060 Dekon, William, of Whaddon, husbandman 0
4653670 2247075 2247075 defendant Smyth William smith 594060 594060 Smyth, William, of Whaddon, smith 1
4653671 2247075 2247075 defendant Rous John courser 594060 594060 Rous, John, of Whaddon, courser 2
4660027 2248984 2248984 defendant Smyth John husbandman 594060 594060 Smyth, John, of Whaddon, husbandman 0
4660028 2248984 2248984 defendant Baldewyn John husbandman 594060 594060 Baldewyn, John, of Whaddon, husbandman 1
4660029 2248984 2248984 defendant Person William husbandman 594060 594060 Person, William, of Whaddon, husbandman 2
4665799 2250779 2250779 defendant Rous John courser 594060 594060 Rous, John, of Whaddon, courser 2
4668296 2255798 2255798 defendant Catel Thomas husbandman 594060 594060 Catel, Thomas, of Whaddon, husbandman 1
4668304 2255801 2255801 defendant Catel Thomas husbandman 594060 594060 Catel, Thomas, of Whaddon, husbandman 1
4674602 2257663 2257663 defendant Barry Richard husbandman 594060 594060 with Barry, Richard, of Whaddon, husbandman 2
4682078 2260014 2260014 defendant Compere Nicholas carpneter 594060 594060 Compere, Nicholas, of Whaddon, carpneter 0
4690531 2262592 2262592 defendant Plesele William husbandman 594060 594060 Plesele, William, of Whaddon, husbandman 6
4700010 2265425 2265425 defendant Desthalers Thomas esq 594060 594060 Desthalers, Thomas, of Whaddon, esq 0
4726394 2273539 2273539 plaintiff Gyffard John   594060 594060 Gyffard, John, of Whaddon 0
4742494 2278305 2278305 defendant Compere John husbandman 594060 594060 Compere, John, of Whaddon, husbandman 0
4745939 2279316 2279316 plaintiff Gyffard John   594060 594060 Gyffard, John, of Whaddon 0
4827851 2304763 2304763 defendant Mold William husbandman 594060 594060 Mold, William, of Whaddon, husbandman 0
4830130 2305465 2305465 plaintiff Berford John   594060 594060 Berford, John, of Whaddon 0
4838094 2307837 2307837 defendant Flour Thomas husbandman 594060 594060 Flour, Thomas, of Whaddon, husbandman 0
4839582 2308299 2308299 defendant Goodeman Edmund yeoman 594060 594060 Goodeman, Edmund, of Whaddon, yeoman 2
4845036 2309964 2309964 defendant Mold William husbandman 594060 594060 Mold, William, of Whaddon, husbandman 0
4859861 2314455 2314455 defendant Nicoll William laborer 594060 594060 Nicoll, William, of Whaddon, laborer 0
4866801 2316580 2316580 defendant Godeman John husbandman 594060 594060 Godeman, John, of Whaddon, husbandman 2
4871157 2317955 2317955 defendant Mole William husbandman 594060 594060 Mole, William, of Whaddon, husbandman 0
4896650 2325612 2325612 defendant Pakker William laborer 594060 594060 Pakker, William, of Whaddon, laborer 2
4897130 2325758 2325758 defendant Wake William clerk 594060 594060 Wake, William, of Whaddon, clerk 0
4950351 2342075 2342075 defendant Alman John husbandman 594060 594060 Alman, John, of Whaddon, husbandman 1
5046543 2370607 2370607 defendant Shepard John husbandman 594060 594060 Shepard, John, of Whaddon, husbandman 0
5100853 2386664 2386664 defendant Hoket William husbandman 594060 594060 Hoket, William, of Whaddon, husbandman 2
5132434 2395982 2395982 defendant Taillour William husbandman 594060 594060 Taillour, William, of Whaddon, husbandman 0
5143598 2399264 2399264 defendant Dunham John yeoman 594060 594060 Dunham, John, of Whaddon, yeoman 2
5143619 2399268 2399268 defendant Dunham John yeoman 594060 594060 Dunham, John, of Whaddon, yeoman 2
5149916 2401109 2401109 defendant Reyd Gerard gent 594060 594060 Reyd, Gerard, of Whaddon, gent 0
5149917 2401109 2401109 defendant Lyly John butcher 594060 594060 Lyly, John, of Whaddon, butcher 1
5149918 2401109 2401109 defendant Smyth Henry smith 594060 594060 Smyth, Henry, of Whaddon, smith 2
5149920 2401109 2401109 defendant Hoket William husbandman 594060 594060 Hoket, William, of Whaddon, husbandman 4
5149921 2401109 2401109 defendant Chapman John husbandman 594060 594060 Chapman, John, of Whaddon, husbandman 5
5149922 2401109 2401109 defendant Scalys John laborer 594060 594060 Scalys, John, of Whaddon, laborer 6
5149923 2401109 2401109 defendant Wangeworth Richard laborer 594060 594060 Wangeworth, Richard, of Whaddon, laborer 7
5149924 2401109 2401109 defendant Spycer William husbandman 594060 594060 Spycer, William, of Whaddon, husbandman 8
5149925 2401109 2401109 defendant Loney William laborer 594060 594060 Loney, William, of Whaddon, laborer 9
5149926 2401109 2401109 defendant Lyly William laborer 594060 594060 Lyly, William, of Whaddon, laborer 10
5149927 2401109 2401109 defendant Broke William laborer 594060 594060 Broke, William, of Whaddon, laborer 11
5152061 2401740 2401740 defendant Dymok John husbandman 594060 594060 Dymok, John, of Whaddon, husbandman 0
5152063 2401740 2401740 defendant Martyn Walter husbandman 594060 594060 Martyn, Walter, of Whaddon, husbandman 2
5153834 2402279 2402279 defendant Reyd Gerard gent 594060 594060 Reyd, Gerard, of Whaddon, gent 0
5153835 2402279 2402279 defendant Lyly John butcher 594060 594060 Lyly, John, of Whaddon, butcher 1
5153837 2402279 2402279 defendant Chapman Christine widow 594060 594060 Chapman, Christine, of Whaddon, widow 3
5153838 2402279 2402279 defendant Smyth Henry smith 594060 594060 Smyth, Henry, of Whaddon, smith 4
5153840 2402279 2402279 defendant Hoket William husbandman 594060 594060 Hoket, William, of Whaddon, husbandman 6
5153841 2402279 2402279 defendant Chapman John husbandman 594060 594060 Chapman, John, of Whaddon, husbandman 7
5153842 2402279 2402279 defendant Scalys John laborer 594060 594060 Scalys, John, of Whaddon, laborer 8
5153843 2402279 2402279 defendant Wangeworth Richard laborer 594060 594060 Wangeworth, Richard, of Whaddon, laborer 9
5153844 2402279 2402279 defendant Spycer William husbandman 594060 594060 Spycer, William, of Whaddon, husbandman 10
5153845 2402279 2402279 defendant Loney Williamm laborer 594060 594060 Loney, Williamm, of Whaddon, laborer 11
5153846 2402279 2402279 defendant Ver William laborer 594060 594060 Ver, William, of Whaddon, laborer 12
5153847 2402279 2402279 defendant Broke William laborer 594060 594060 Broke, William, of Whaddon, laborer 13
5160493 2404160 2404160 defendant Hoket William husbandman 594060 594060 Hoket, William, of Whaddon, husbandman 0
5167288 2406163 2406163 defendant Ferrour John yeoman 594060 594060 Ferrour, John, of Whaddon, yeoman 0
5169983 2406955 2406955 defendant Martyn Walter husbandman 594060 594060 Martyn, Walter, of Whaddon, husbandman 1
5182659 2410682 2410682 defendant Ferrour John yeoman 594060 594060 Ferrour, John, of Whaddon, yeoman 0
5182773 2410710 2410710 defendant Dunham John yeoman 594060 594060 Dunham, John, of Whaddon, yeoman 4
5203556 2416792 2416792 defendant Dunham John yeoman 594060 594060 Dunham, John, of Whaddon, yeoman 4
5214305 2419917 2419917 defendant Barford John husbandman 594060 594060 Barford, John, of Whaddon, husbandman 1
5238837 2426949 2426949 defendant Dynnok John husbandman 594060 594060 Dynnok, John, of Whaddon, husbandman 0
5238840 2426949 2426949 defendant Barford Thomas husbandman 594060 594060 Barford, Thomas, of Whaddon, husbandman 3
5240733 2427499 2427499 defendant Dynnok John husbandman 594060 594060 Dynnok, John, of Whaddon, husbandman 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);