names

62 rows where place_id = 603202

✎ 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
3653850 1911467 1911467 defendant Alee Robert yeoman 603202 603202 Alee, Robert, of King's Lynn, yeoman 0
3654533 1911679 1911679 defendant Thursby Thomas gent 603202 603202 Thursby, Thomas, of King's Lynn, gent 0
3656220 1912193 1912193 defendant Alee Robert yeoman 603202 603202 Alee, Robert, of King's Lynn, yeoman 0
3657845 1912704 1912704 plaintiff Dey Thomas (legal representative) 603202 603202 Dey, Thomas, of King's Lynn, burgess, executor of 0
3659099 1913105 1913105 defendant Dyxson William   603202 603202 Dyxson, William, of King's Lynn, fish monger 0
3659100 1913105 1913105 defendant Wyett Alexander sheerman 603202 603202 Wyett, Alexander, of King's Lynn, sheerman 1
3661354 1913825 1913825 defendant Hepworth Agnes widow 603202 603202 Hepworth, Agnes, of King's Lynn, widow 0
3662966 1914329 1914329 defendant Hyegham Thomas yeoman 603202 603202 Thomas Hyegham, of King's Lynn, yeoman, executors of 0
3662967 1914329 1914329 defendant Nycollys Richard tailor 603202 603202 (Nycollys, Richard, of King's Lynn, tailor 1
3663906 1914653 1914653 defendant Felde John tailor 603202 603202 Felde, John, of King's Lynn, tailor 1
3665199 1915070 1915070 plaintiff Some Robert   603202 603202 Some, Robert, of King's Lynn, burgess 0
3666057 1915323 1915323 defendant Baker Robert brewer 603202 603202 Baker, Robert, of King's Lynn, brewer 1
3667142 1915656 1915656 defendant Plumbe John yeoman 603202 603202 Plumbe, John, of King's Lynn, yeoman 0
3667802 1915870 1915870 defendant Rose Thomas baker 603202 603202 Rose, Thomas, of King's Lynn, baker 1
3927805 1999639 1999639 defendant Sanderson Richard merchant 603202 603202 Sanderson, Richard, of King's Lynn, merchant 1
3927806 1999639 1999639 defendant Wrenche John merchant 603202 603202 Wrenche, John, of King's Lynn, merchant 2
3928015 1999708 1999708 defendant Jerves Robert merchant 603202 603202 Jerves, Robert, of King's Lynn, merchant 2
3928016 1999708 1999708 defendant Walden Silvester merchant 603202 603202 Walden, Silvester, of King's Lynn, merchant 3
3928017 1999708 1999708 defendant Wodam William butcher 603202 603202 Wodam, William, of King's Lynn, butcher 4
3928034 1999711 1999711 defendant Makendar John merchant 603202 603202 Makendar, John, of King's Lynn, merchant 3
3928036 1999711 1999711 defendant Pell John merchant 603202 603202 Pell, John, of King's Lynn, merchant 5
3929536 2000227 2000227 defendant Caunderson Richard merchant 603202 603202 Caunderson, Richard, of King's Lynn, merchant 1
3931954 2000985 2000985 defendant Ducke John sadler 603202 603202 Ducke, John, of King's Lynn, sadler 0
3934484 2001829 2001829 defendant Daune John chapman 603202 603202 Daune, John, of King's Lynn, chapman 1
3934796 2001936 2001936 defendant Dalby John yeoman 603202 603202 Dalby, John, of King's Lynn, yeoman 1
3935813 2002285 2002285 defendant Saunderson Richard merchant 603202 603202 Saunderson, Richard, of King's Lynn, merchant 0
3935965 2002345 2002345 plaintiff Lewyns James mariner 603202 603202 Lewyns, James, of King's Lynn, mariner 0
3936321 2002471 2002471 plaintiff Makenter John   603202 603202 Makenter, John, of King's Lynn 0
3936326 2002472 2002472 plaintiff Makenter John   603202 603202 Makenter, John, of King's Lynn 0
3939803 2003613 2003613 defendant Balwyn Anthony tailor 603202 603202 Balwyn, Anthony, of King's Lynn, tailor 0
3939876 2003638 2003638 defendant Butler William yeoman 603202 603202 Butler, William, of King's Lynn, yeoman 0
3939897 2003644 2003644 defendant Walden Silvester merchant 603202 603202 Walden, Silvester, of King's Lynn, merchant 0
3940529 2003843 2003843 defendant Walden Silvester merchant 603202 603202 Walden, Silvester, of King's Lynn, merchant 0
4540086 2212806 2212806 defendant Batkysham Robert   603202 603202 Batkysham, Robert, of King's Lynn, burgess 0
4674404 2257606 2257606 defendant Coude or Conde John dyer 603202 603202 Coude or Conde, John, of King's Lynn, dyer 0
5133417 2396264 2396264 defendant Pygot Simon merchant 603202 603202 Pygot, Simon, of King's Lynn, merchant 0
5137173 2397384 2397384 defendant (not given) John merchant & burgess 603202 603202 [vacat], John, of King's Lynn, merchant & burgess 0
5364444 2464542 2464542 plaintiff Amffles Richard   603202 603202 Amffles, Richard, of King's Lynn, burgess 0
5365826 2464965 2464965 defendant Jaye Thomas baker 603202 603202 Jaye, Thomas, of King's Lynn, baker 2
5366486 2465173 2465173 defendant Trotte John butcher 603202 603202 Trotte, John, of King's Lynn, butcher 2
5366490 2465175 2465175 defendant Trotte John butcher 603202 603202 Trotte, John, of King's Lynn, butcher 0
5367620 2465516 2465516 defendant Oldemedow John smith & Burgess 603202 603202 Oldemedow, John, of King's Lynn, smith & Burgess 0
5369451 2466036 2466036 defendant Halyday John, senior (legal representative) 603202 603202 Halyday, John, senior, of King's Lynn, merchant, administratrix of 0
5371963 2466822 2466822 defendant Dene John tanner 603202 603202 Dene, John, of King's Lynn, tanner 0
5373806 2467402 2467402 defendant Edward Anne widow 603202 603202 Edward, Anne, of King's Lynn, widow 0
5373807 2467402 2467402 defendant Watlot William chaplain 603202 603202 Watlot, William, of King's Lynn, chaplain 1
5374841 2467727 2467727 plaintiff Pepyr Edmund   603202 603202 Pepyr, Edmund, of King's Lynn, burgess & baker 0
5374842 2467727 2467727 defendant Whyte Edmund   603202 603202 Whyte, Edmund, of King's Lynn, rope maker 0
5375027 2467781 2467781 plaintiff Plandon or Plaudon Robert weaver 603202 603202 Plandon or Plaudon, Robert, of King's Lynn, weaver 0
5375028 2467781 2467781 defendant Warde Thomas merchant 603202 603202 Warde, Thomas, of King's Lynn, merchant 0
5375029 2467782 2467782 plaintiff Plandon Robert weaver 603202 603202 Plandon, Robert, of King's Lynn, weaver 0
5375443 2467907 2467907 plaintiff Pylly Robert merchant & Burgess 603202 603202 Pylly, Robert, of King's Lynn, merchant & Burgess 0
5376000 2468088 2468088 defendant Brekrop Thomas   603202 603202 Brekrop, Thomas, of King's Lynn, coverlet weaver 1
5376001 2468088 2468088 defendant Hopkyn John   603202 603202 Hopkyn, John, of King's Lynn, coverlet weaver 2
5376280 2468175 2468175 defendant Brymmyng John   603202 603202 Brymmyng, John, of King's Lynn, gold smith 1
5376465 2468237 2468237 defendant Britten Thomas yeoman 603202 603202 Britten, Thomas, of King's Lynn, yeoman 0
5376491 2468245 2468245 defendant Britton Thomas yeoman 603202 603202 Britton, Thomas, of King's Lynn, yeoman 0
5376957 2468389 2468389 plaintiff Soome John   603202 603202 Soome, John, of King's Lynn, burgess & mercer 0
5376959 2468390 2468390 plaintiff Soome John   603202 603202 Soome, John, of King's Lynn, burgess & mercer 0
5378460 2468848 2468848 plaintiff Munk William   603202 603202 Munk, William, of King's Lynn, burgess 1
5378789 2468953 2468953 plaintiff Walys William (legal representative) 603202 603202 Walys, William, of King's Lynn, merchant, executor of 0
5405591 2476677 2476677 plaintiff Scome or Soome John   603202 603202 Scome or Soome, John, of King's Lynn, burgess & merchant 0

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