names

67 rows where place_id = 601850

✎ 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
3647280 1909534 1909534 defendant Hedney John yeoman 601850 601850 Hedney, John, of Bridgewater, yeoman 1
3860256 1976926 1976926 defendant Tyrrell Richard merchant 601850 601850 Tyrrell, Richard, of Bridgewater, merchant 0
3860257 1976926 1976926 defendant Skelton Alexander merchant 601850 601850 Skelton, Alexander, of Bridgewater, merchant 1
3887396 1986048 1986048 defendant Tyrrell Richard merchant 601850 601850 Tyrrell, Richard, of Bridgewater, merchant 0
3950895 2007379 2007379 defendant Holcombe John tailor 601850 601850 Holcombe, John, of Bridgewater, tailor 0
3968609 2013660 2013660 defendant Chapman John baker 601850 601850 Chapman, John, of Bridgewater, baker 0
3971117 2014454 2014454 defendant Horne John butcher 601850 601850 Horne, John, of Bridgewater, butcher 0
3987945 2020435 2020435 defendant Hunt Thomas tucker 601850 601850 Hunt, Thomas, of Bridgewater, tucker 0
3990197 2021250 2021250 defendant Oder John draper 601850 601850 Oder, John, of Bridgewater, draper 1
3999576 2024615 2024615 plaintiff Galhampton or Gallyngton John merchant 601850 601850 Galhampton or Gallyngton, John, of Bridgewater, merchant 0
4013088 2029412 2029412 defendant Raburde or Radbarde Barnard merchant 601850 601850 Raburde or Radbarde, Barnard, of Bridgewater, merchant 0
4017949 2031134 2031134 defendant Radforde or Radbarde Barnard merchant 601850 601850 Radforde or Radbarde, Barnard, of Bridgewater, merchant 0
4027769 2034581 2034581 defendant Jones Alexander merchant 601850 601850 Jones, Alexander, of Bridgewater, merchant 0
4046087 2041040 2041040 defendant Rynston or Ronson John baker 601850 601850 Rynston or Ronson, John, of Bridgewater, baker 0
4049175 2042151 2042151 defendant Radbarde Barnard merchant 601850 601850 Radbarde, Barnard, of Bridgewater, merchant 0
4055295 2044292 2044292 defendant Jones Henry clothier 601850 601850 Jones, Henry, of Bridgewater, clothier 0
4089792 2056643 2056643 defendant Fyshe Richard shoemaker 601850 601850 Fyshe, Richard, of Bridgewater, shoemaker 1
4089793 2056643 2056643 defendant Dozens Geoffrey tailor 601850 601850 Dozens, Geoffrey, of Bridgewater, tailor 2
4089808 2056647 2056647 defendant Popham George gent 601850 601850 Popham, George, of Bridgewater, gent 1
4089812 2056648 2056648 defendant Popham George gent 601850 601850 Popham, George, of Bridgewater, gent 1
4089844 2056656 2056656 defendant Fyshe Richard cordwainer 601850 601850 Fyshe, Richard, of Bridgewater, cordwainer 1
4089845 2056656 2056656 defendant Abbott Humphrey husbandman 601850 601850 Abbott, Humphrey, of Bridgewater, husbandman 2
4092127 2057479 2057479 defendant Watkyns or Watt John gent 601850 601850 Watkyns or Watt, John, of Bridgewater, gent 2
4097463 2059420 2059420 defendant Demes or Deines Robert glasier 601850 601850 Demes or Deines, Robert, of Bridgewater, glasier 1
4106061 2062459 2062459 defendant Dussens Godfrey tailor 601850 601850 Dussens, Godfrey, of Bridgewater, tailor 0
4111317 2064296 2064296 defendant Watkyns John yeoman 601850 601850 Watkyns, John, of Bridgewater, yeoman 0
4114750 2065563 2065563 defendant Watkyns John gent 601850 601850 Watkyns, John, of Bridgewater, gent 0
4115412 2065799 2065799 defendant Popham George merchant 601850 601850 Popham, George, of Bridgewater, merchant 0
4116241 2066097 2066097 defendant Chappell John merchant 601850 601850 Chappell, John, of Bridgewater, merchant 2
4141622 2075235 2075235 defendant Shercombe Geoffrey gent 601850 601850 Shercombe, Geoffrey, of Bridgewater, gent 2
4152583 2079017 2079017 defendant Chapell John merchant 601850 601850 Chapell, John, of Bridgewater, merchant 1
4157924 2080842 2080842 defendant Cleves Mathew innholder 601850 601850 Cleves, Mathew, of Bridgewater, innholder 1
4208344 2098466 2098466 defendant Galhampton John merchant 601850 601850 Galhampton, John, of Bridgewater, yeoman, merchant 0
4244713 2111216 2111216 defendant Lawrence Mathew gent 601850 601850 Lawrence, Mathew, of Bridgewater, or of Devizes, Wilts, gent 0
4246864 2111925 2111925 defendant Culverwell Leonard tailor 601850 601850 Culverwell, Leonard, of Bridgewater, tailor 2
4302362 2130946 2130946 defendant Massye Walter carpenter 601850 601850 Massye, Walter, of Bridgewater, carpenter 0
4314747 2135270 2135270 defendant Hooper alias Govett Richard   601850 601850 Hooper alias Govett, Richard, of Bridgewater 0
4344698 2145425 2145425 defendant Gilbert Giles (legal representative) 601850 601850 Gilbert, Giles, of Bridgewater, yeoman, executrix of 0
4344699 2145425 2145425 defendant Gilbert Joan widow 601850 601850 Gilbert, Joan, of Bridgewater, widow 1
4351003 2147608 2147608 defendant Jeynckyns or Jenkins Thomas gent 601850 601850 Jeynckyns or Jenkins, Thomas, of Bridgewater, or of Gotehurste, gent 0
4363294 2151943 2151943 defendant Berifielde Roger butcher 601850 601850 Berifielde, Roger, of Bridgewater, butcher 0
4363299 2151945 2151945 defendant Stradlinge Richard merchant 601850 601850 Stradlinge, Richard, of Bridgewater, merchant 1
4363557 2152038 2152038 defendant Haberfeilde George yeoman 601850 601850 Haberfeilde, George, of Bridgewater, yeoman 1
4372551 2155254 2155254 defendant Mathewes Thomas   601850 601850 Mathewes, Thomas, of Bridgewater, Soms, sailor 0
4391313 2161712 2161712 defendant Jones Alexander merchant 601850 601850 Jones, Alexander, of Bridgewater, merchant 1
4391314 2161712 2161712 defendant Jones Henry merchant 601850 601850 Jones, Henry, of Bridgewater, merchant 2
4439979 2181788 2181788 defendant Came William master of the hospital of St John Baptist 601850 601850 Came, William, of Bridgewater, master of the hospital of St John Baptist 0
4450369 2185073 2185073 defendant Tomer William   601850 601850 Tomer, William, of Bridgewater 0
4521697 2207119 2207119 defendant Henton John   601850 601850 Henton, John, of Bridgewater 0
4522105 2207255 2207255 defendant Sydenham John   601850 601850 Sydenham, John, of Bridgewater 0
4523567 2207695 2207695 defendant Fote Thomas   601850 601850 Fote, Thomas, of Bridgewater 0
4524612 2208031 2208031 defendant Mathewe John   601850 601850 Mathewe, John, of Bridgewater 1
4533883 2210869 2210869 plaintiff Ruddok Walter   601850 601850 Ruddok, Walter, of Bridgewater 0
4538812 2212412 2212412 defendant Matheu John   601850 601850 Matheu, John, of Bridgewater 1
4555734 2217727 2217727 defendant Westlegh Adam   601850 601850 Westlegh, Adam, of Bridgewater, burgess 0
4555735 2217727 2217727 defendant Marchall John   601850 601850 Marchall, John, of Bridgewater, burgess 1
4562440 2219814 2219814 defendant Reyany John   601850 601850 Reyany, John, of Bridgewater 1
4590934 2228519 2228519 defendant Loine William   601850 601850 Loine, William, of Bridgewater 0
5299689 2444879 2444879 defendant Bolcomb Joan widow 601850 601850 Bolcomb, Joan, of Bridgewater, widow 1
5299690 2444879 2444879 defendant Bulcomb Thomas yeoman 601850 601850 Bulcomb, Thomas, of Bridgewater, yeoman 2
5300080 2444988 2444988 defendant Bandryp or Baudryp John fuller 601850 601850 Bandryp or Baudryp, John, of Bridgewater, fuller 0
5300081 2444988 2444988 defendant Bruer John baker 601850 601850 Bruer, John, of Bridgewater, baker 1
5300088 2444989 2444989 defendant Bruer John baker 601850 601850 Bruer, John, of Bridgewater, baker 1
5396141 2473982 2473982 defendant Anable Thomas mariner 601850 601850 Anable, Thomas, of Bridgewater, mariner 1
5431702 2484446 2484446 defendant Lane Thomas yeoman 601850 601850 Lane,Thomas, of Bridgewater, yeoman 0
5446070 2488710 2488710 defendant Bette John   601850 601850 Bette, John, of Bridgewater 0
5470280 2496030 2496030 defendant Oder John merchant 601850 601850 Oder, John, of Bridgewater, merchant 2

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