names

210 rows where place_id = 594300

✎ 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
3615494 1872488 1872488 plaintiff Clonne or Cloune Thomas tailor 594300 594300 Clonne or Cloune, Thomas, of Frome, tailor 0
3660328 1913491 1913491 defendant Rokke Thomas husbandman 594300 594300 Rokke, Thomas, of Frome, husbandman 0
3684030 1921138 1921138 defendant Godsalf Thomas husbandman 594300 594300 Godsalf, Thomas, of Frome, husbandman 1
3684399 1921251 1921251 defendant Godsalf Thomas husbandman 594300 594300 Godsalf, Thomas, of Frome, husbandman 1
3977374 2016656 2016656 defendant Edgyll Nicholas glover 594300 594300 Edgyll, Nicholas, of Frome, glover 0
3982166 2018383 2018383 defendant George Thomas yeoman 594300 594300 George, Thomas, of Frome, yeoman 0
4036503 2037739 2037739 defendant Lovell George husbandman 594300 594300 Lovell, George, of Frome, husbandman 1
4131685 2071651 2071651 defendant Coles Walter husbandman 594300 594300 Coles, Walter, of Frome, husbandman 2
4248837 2112600 2112600 defendant Inxon or Juxon John gent 594300 594300 Inxon or Juxon, John, of Frome, gent 1
4262040 2116980 2116980 defendant Stibbes alias Saunders Robert tailor 594300 594300 Stibbes alias Saunders, Robert, of Frome, tailor 2
4262041 2116980 2116980 defendant Chubb William clerk 594300 594300 Chubb, William, of Frome, clerk 3
4287939 2125733 2125733 defendant Saunders Robert tailor 594300 594300 Saunders, Robert, of Frome, tailor 0
4308343 2133069 2133069 defendant Horsington Thomas husbandman 594300 594300 Horsington, Thomas, of Frome, husbandman 1
4373751 2155677 2155677 defendant Newboroughe George yeoman 594300 594300 Newboroughe, George, of Frome, yeoman 0
4373752 2155677 2155677 defendant Androwes William weaver 594300 594300 Androwes, William, of Frome, weaver 1
4385170 2159728 2159728 defendant Somner John butcher 594300 594300 Somner, John, of Frome, or of Seene, Wilts, butcher 0
4415620 2169765 2169765 defendant Fisshere Ralph le   594300 594300 Fisshere, Ralph le, of Frome 0
4446205 2183724 2183724 defendant Taillour Wiliam   594300 594300 Taillour, Wiliam, of Frome 0
4464575 2189589 2189589 defendant Gyffard Walter   594300 594300 Gyffard, Walter, of Frome, son of John 0
4468485 2190808 2190808 defendant Ruddok Walter   594300 594300 Ruddok, Walter, of Frome 0
4481949 2195061 2195061 defendant Crudemede Nicholas   594300 594300 Crudemede, Nicholas, of Frome 2
4483253 2195461 2195461 defendant Monk Robert   594300 594300 Monk, Robert, of Frome 4
4486319 2196429 2196429 defendant Sprot John   594300 594300 Sprot, John, of Frome 1
4495412 2199246 2199246 defendant Alyn John   594300 594300 Alyn, John, of Frome 0
4495628 2199316 2199316 defendant Crace Richard   594300 594300 Crace, Richard, of Frome 0
4495634 2199317 2199317 defendant Mann-- Edward   594300 594300 Mann--, Edward, of Frome 0
4495635 2199317 2199317 defendant Wycroft John   594300 594300 Wycroft, John, of Frome 1
4498454 2200167 2200167 defendant Cook John   594300 594300 Cook, John, of Frome 6
4498468 2200169 2200169 defendant Cook John   594300 594300 Cook, John, of Frome 6
4506195 2202445 2202445 defendant Vauntage Walter   594300 594300 Vauntage, Walter, of Frome 0
4511688 2204102 2204102 defendant Baker Robert taverner 594300 594300 Baker, Robert, of Frome, taverner 0
4516525 2205575 2205575 defendant Alyn John   594300 594300 Alyn, John, of Frome 0
4520422 2206732 2206732 defendant Heycroft Robert   594300 594300 Heycroft, Robert, of Frome 2
4520427 2206733 2206733 defendant Alyn John   594300 594300 Alyn, John, of Frome 3
4520432 2206734 2206734 defendant Alyn John   594300 594300 Alyn, John, of Frome 3
4530825 2209930 2209930 defendant Cosyn Nicholas goldsmith 594300 594300 Cosyn, Nicholas, of Frome, goldsmith 0
4535076 2211249 2211249 defendant Gybbys John   594300 594300 Gybbys, John, of Frome 0
4539626 2212655 2212655 defendant Yerde John   594300 594300 Yerde, John, of Frome 2
4539628 2212655 2212655 defendant Hypworth Thomas   594300 594300 Hypworth, Thomas, of Frome 4
4539640 2212658 2212658 defendant Yerde John   594300 594300 Yerde, John, of Frome 2
4539642 2212658 2212658 defendant Hypworth Thomas   594300 594300 Hypworth, Thomas, of Frome 4
4540493 2212925 2212925 defendant Carleton Richard   594300 594300 Carleton, Richard, of Frome 1
4540684 2212989 2212989 defendant Bigeman Thomas   594300 594300 Bigeman, Thomas, of Frome 0
4541258 2213162 2213162 defendant Bakere Robert   594300 594300 Bakere, Robert, of Frome 0
4543209 2213760 2213760 defendant Gylot John   594300 594300 Gylot, John, of Frome 0
4544834 2214303 2214303 defendant Russell William   594300 594300 Russell, William, of Frome 1
4544837 2214304 2214304 defendant Russell William   594300 594300 Russell, William, of Frome 1
4546134 2214738 2214738 defendant Beche John   594300 594300 Beche, John, of Frome 2
4547488 2215145 2215145 plaintiff Cable John   594300 594300 Cable, John, of Frome 0
4547491 2215146 2215146 plaintiff Cable John   594300 594300 Cable, John, of Frome 0
4547494 2215147 2215147 plaintiff Cable John   594300 594300 Cable, John, of Frome 0
4547497 2215148 2215148 plaintiff Cable John   594300 594300 Cable, John, of Frome 0
4547500 2215149 2215149 plaintiff Cable John   594300 594300 Cable, John, of Frome 0
4547502 2215150 2215150 plaintiff Cable John   594300 594300 Cable, John, of Frome 0
4548462 2215458 2215458 defendant Beche John   594300 594300 Beche, John, of Frome 0
4549572 2215809 2215809 defendant Ship John   594300 594300 Ship, John, of Frome 0
4549923 2215909 2215909 plaintiff Cras Richard   594300 594300 Cras, Richard, of Frome 0
4552547 2216749 2216749 defendant Gay William   594300 594300 Gay, William, of Frome 1
4552549 2216749 2216749 defendant Pole Thomas   594300 594300 Pole, Thomas, of Frome 3
4552555 2216751 2216751 defendant Denemede John   594300 594300 Denemede, John, of Frome 0
4552556 2216751 2216751 defendant Touker Robert   594300 594300 Touker, Robert, of Frome 1
4560964 2219384 2219384 plaintiff Osteler John   594300 594300 Osteler, John, of Frome 1
4560965 2219384 2219384 defendant Taillour Alice   594300 594300 Taillour, Alice, of Frome 0
4560966 2219384 2219384 defendant Cartere John   594300 594300 Cartere, John, of Frome 1
4560967 2219384 2219384 defendant Smyth Richard   594300 594300 Smyth, Richard, of Frome 2
4560968 2219384 2219384 defendant Abraham John   594300 594300 Abraham, John, of Frome 3
4564924 2220595 2220595 defendant Crodemede Nicholas   594300 594300 Crodemede, Nicholas, of Frome 0
4564925 2220595 2220595 defendant Mold Thomas   594300 594300 Mold, Thomas, of Frome 1
4564928 2220595 2220595 defendant Haytoft Robert   594300 594300 Haytoft, Robert, of Frome 4
4570854 2222451 2222451 defendant Orum wiliam   594300 594300 Orum, wiliam, of Frome 1
4570855 2222451 2222451 defendant dunkerton Henry   594300 594300 dunkerton, Henry, of Frome 2
4572711 2223005 2223005 defendant Neuport John   594300 594300 Neuport, John, of Frome 0
4572712 2223005 2223005 defendant Barbour Thomas   594300 594300 Barbour, Thomas, of Frome 1
4573484 2223234 2223234 defendant Mody Thomas   594300 594300 Mody, Thomas, of Frome 0
4573485 2223234 2223234 defendant Mody Walter   594300 594300 Mody, Walter, of Frome 1
4579696 2225137 2225137 plaintiff Craas Mathew (legal representative) 594300 594300 Craas, Mathew, of Frome, executors of 0
4579700 2225138 2225138 plaintiff Craas Mathew (legal representative) 594300 594300 Craas, Mathew, of Frome, executors of 0
4579704 2225138 2225138 defendant Coote Walter   594300 594300 Coote, Walter, of Frome 1
4581406 2225651 2225651 defendant Martyn John dyer 594300 594300 Martyn, John, of Frome, dyer 0
4581407 2225651 2225651 defendant Bakere Robert   594300 594300 Bakere, Robert, of Frome 1
4581409 2225651 2225651 defendant Splot John   594300 594300 Splot, John, of Frome 3
4587459 2227483 2227483 defendant Cabell John   594300 594300 Cabell, John, of Frome 0
4593602 2229272 2229272 defendant Crodemede Nicholas   594300 594300 Crodemede, Nicholas, of Frome 0
4596933 2230282 2230282 defendant Splot John fuller 594300 594300 Splot, John, of Frome, fuller 0
4598424 2230743 2230743 defendant Beche John   594300 594300 Beche, John, of Frome 1
4598480 2230762 2230762 defendant Gay William   594300 594300 Gay, William, of Frome 0
4598481 2230762 2230762 defendant Fadyr John   594300 594300 Fadyr, John, of Frome 1
4598492 2230764 2230764 defendant Abraham John   594300 594300 Abraham, John, of Frome 2
4599826 2231174 2231174 plaintiff Taillour Martin (legal representative) 594300 594300 Taillour, Martin, of Frome, executors of 0
4599827 2231174 2231174 plaintiff Taillour John   594300 594300 (Taillour, John, of Frome, son of Martin 1
4599830 2231174 2231174 defendant Roulys John   594300 594300 Roulys, John, of Frome, son of Thomas 0
4602555 2232019 2232019 defendant Raundes John   594300 594300 Raundes, John, of Frome 0
4603372 2232249 2232249 defendant Deye Thomas   594300 594300 Deye, Thomas, of Frome 1
4606123 2233026 2233026 defendant Milleward Thomas   594300 594300 Milleward, Thomas, of Frome 2
4610743 2234425 2234425 defendant Hylleman John   594300 594300 Hylleman, John, of Frome 1
4611493 2234657 2234657 defendant Hulman John   594300 594300 Hulman, John, of Frome 1
4611498 2234658 2234658 defendant Hulman John   594300 594300 Hulman, John, of Frome 1
4623869 2238443 2238443 defendant Stedman William   594300 594300 Stedman, William, of Frome 0
4623870 2238443 2238443 defendant Styl Thomas   594300 594300 Styl, Thomas, of Frome 1
4623872 2238443 2238443 defendant Denemede John   594300 594300 Denemede, John, of Frome 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);