names

89 rows where place_id = 588315

✎ 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
3594080 1865790 1865790 defendant Foule Richard cooper 588315 588315 Foule, Richard, of Sandherst, cooper 0
3594657 1865958 1865958 defendant Wylget Vincent baker 588315 588315 Wylget, Vincent, of Sandherst, baker 0
3595237 1866145 1866145 defendant Foule Richard cooper 588315 588315 Foule, Richard, of Sandherst, cooper 0
3597291 1866773 1866773 defendant Welles John yeoman 588315 588315 Welles, John, of Sandherst, yeoman 3
3597292 1866773 1866773 defendant Bechyng William fuller 588315 588315 Bechyng, William, of Sandherst, fuller 4
3622203 1874479 1874479 plaintiff Petter Thomas   588315 588315 Petter, Thomas, of Sandherst 0
3625623 1875548 1875548 defendant Sharp Thomas clothmaker 588315 588315 Sharp, Thomas, of Sandherst, clothmaker 0
3723265 1933548 1933548 defendant Wayrd William clothier 588315 588315 Wayrd, William, of Sandherst, clothier 0
3734326 1936974 1936974 defendant Petter Vincent husbandman 588315 588315 Petter, Vincent, of Sandherst, husbandman 0
3739299 1938507 1938507 defendant Stokes Thomas husbandman 588315 588315 Stokes, Thomas, of Sandherst, husbandman 0
3759821 1945068 1945068 defendant Petter Vincent yeoman 588315 588315 Petter, Vincent, of Sandherst, yeoman 0
3762137 1945800 1945800 defendant Elys George   588315 588315 Elys, George, of Sandherst, wood setter 0
3762139 1945801 1945801 defendant Whithed John clothmaker 588315 588315 Whithed, John, of Sandherst, clothmaker 0
3765847 1946984 1946984 defendant Scotte John yeoman 588315 588315 Scotte, John, of Sandherst, yeoman 0
3843235 1971417 1971417 defendant Bukker Thomas tailor 588315 588315 Bukker, Thomas, of Sandherst, tailor 0
3843981 1971660 1971660 defendant Bukler Thomas tailor 588315 588315 Bukler, Thomas, of Sandherst, tailor 0
3877028 1982558 1982558 defendant Stable John husbandman 588315 588315 (Stable, John, of Sandherst, husbandman 1
3877029 1982558 1982558 defendant Stephen Edmund   588315 588315 Stephen, Edmund, of Sandherst, "repper" 2
3880121 1983605 1983605 plaintiff Pavys James (legal representative) 588315 588315 Pavys, James, of Sandherst, executrix of 0
3880124 1983605 1983605 defendant Stabull John laborer 588315 588315 Stabull, John, of Sandherst, laborer 1
3891106 1987292 1987292 defendant Pavys Alice widow 588315 588315 Pavys, Alice, of Sandherst, widow 0
3891107 1987292 1987292 defendant Pavys John laborer 588315 588315 Pavys, John, of Sandherst, laborer 1
3891108 1987292 1987292 defendant Pavys Edward laborer 588315 588315 Pavys, Edward, of Sandherst, laborer 2
3891109 1987292 1987292 defendant Pavys Richard laborer 588315 588315 Pavys, Richard, of Sandherst, laborer 3
3891110 1987292 1987292 defendant Pavys Thomas laborer 588315 588315 Pavys, Thomas, of Sandherst, laborer 4
3891111 1987292 1987292 defendant Pavys Clement laborer 588315 588315 Pavys, Clement, of Sandherst, laborer 5
3891113 1987293 1987293 defendant Pavys John laborer 588315 588315 Pavys, John, of Sandherst, laborer 0
3954855 2008764 2008764 defendant Bretle Clement yeoman 588315 588315 Bretle, Clement, of Sandherst, yeoman 1
3959291 2010328 2010328 defendant Basscok Richard husbandman 588315 588315 Basscok, Richard, of Sandherst, husbandman 0
4099753 2060234 2060234 defendant Crothole Henry tailor 588315 588315 Crothole, Henry, of Sandherst, tailor 0
4119899 2067407 2067407 defendant Twysden Richard husbandman 588315 588315 Twysden, Richard, of Sandherst, husbandman 1
4142973 2075713 2075713 defendant Twysden Richard husbandman 588315 588315 Twysden, Richard, of Sandherst, husbandman 1
4167782 2084221 2084221 defendant Bate George husbandman 588315 588315 Bate, George, of Sandherst, husbandman 1
4284841 2124623 2124623 defendant Watt William, junior husbandman 588315 588315 Watt, William, junior, of Sandherst, husbandman 0
4309832 2133595 2133595 defendant Holnest Thomas yeoman 588315 588315 Holnest, Thomas, of Sandherst, yeoman 0
4379496 2157751 2157751 defendant Fowle Richard   588315 588315 Fowle, Richard, of Sandherst, Kent husbandman 0
4387422 2160437 2160437 defendant Watt William, junior husbandman 588315 588315 Watt, William, junior, of Sandherst, husbandman 0
4470152 2191319 2191319 defendant Hamme John de   588315 588315 Hamme, John de, of Sandherst 0
4477819 2193730 2193730 plaintiff Hamme John   588315 588315 Hamme, John, of Sandherst 0
4530779 2209917 2209917 defendant atte Crouche Nicholas   588315 588315 atte Crouche, Nicholas, of Sandherst 2
4551995 2216573 2216573 defendant Boxherst Thomas   588315 588315 Boxherst, Thomas, of Sandherst 0
4551996 2216573 2216573 defendant Sone Robert   588315 588315 Sone, Robert, of Sandherst 1
4556820 2218068 2218068 defendant atte Hamme John   588315 588315 atte Hamme, John, of Sandherst 0
4608511 2233769 2233769 plaintiff Bourne William   588315 588315 Bourne, William, of Sandherst 0
4668801 2255948 2255948 defendant Sone or Sove Robert husbandman 588315 588315 Sone or Sove, Robert, of Sandherst, husbandman 0
4727412 2273819 2273819 defendant Mungeham William, sen laborer 588315 588315 Mungeham, William, sen, of Sandherst, laborer 0
4727415 2273819 2273819 defendant Munngeham John laborer 588315 588315 Munngeham, John, of Sandherst, laborer 3
4750592 2280659 2280659 defendant Austyn Richard weaver 588315 588315 Austyn, Richard, of Sandherst, weaver 0
4828890 2305076 2305076 defendant Robard Simon husbandman 588315 588315 Robard, Simon, of Sandherst, husbandman 0
4880108 2320689 2320689 plaintiff Warde Thomas (legal representative) 588315 588315 Warde, Thomas, of Sandherst, executors of 0
4913758 2330804 2330804 defendant Fordman Thomas   588315 588315 Fordman, Thomas, of Sandherst, nail maker 0
4913759 2330804 2330804 defendant Fordman John laborer 588315 588315 Fordman, John, of Sandherst, laborer 1
4939163 2338635 2338635 defendant Jacob John cordwainer 588315 588315 Jacob, John, of Sandherst, cordwainer 0
4939165 2338636 2338636 defendant Watte John yeoman 588315 588315 Watte, John, of Sandherst, yeoman 0
4960454 2345090 2345090 defendant White William   588315 588315 White, William, of Sandherst, groom 0
4996231 2355728 2355728 defendant Mongeham William husbandman 588315 588315 Mongeham, William, of Sandherst, husbandman 1
5016345 2361672 2361672 defendant Badcok John husbandman 588315 588315 Badcok, John, of Sandherst, husbandman 0
5034357 2366907 2366907 defendant Hychecok William husbandman 588315 588315 Hychecok, William, of Sandherst, husbandman 0
5034358 2366907 2366907 defendant Colet Stephen husbandman 588315 588315 Colet, Stephen, of Sandherst, husbandman 1
5036763 2367626 2367626 defendant Wytheges John clothmaker 588315 588315 Wytheges, John, of Sandherst, clothmaker 1
5065882 2376317 2376317 defendant Mongeham William yeoman 588315 588315 Mongeham, William, of Sandherst, yeoman 0
5067333 2376738 2376738 defendant Jacop John shoemaker 588315 588315 Jacop, John, of Sandherst, shoemaker 0
5078754 2380133 2380133 defendant Brygges William husbandman 588315 588315 Brygges, William, of Sandherst, husbandman 6
5105731 2388127 2388127 defendant Fordman William husbandman 588315 588315 Fordman, William, of Sandherst, husbandman 0
5105735 2388127 2388127 defendant Bate John husbandman 588315 588315 Bate, John, of Sandherst, husbandman 4
5113806 2390430 2390430 defendant Sprynget Robert smith 588315 588315 Sprynget, Robert, of Sandherst, smith 1
5113812 2390431 2390431 defendant Sprynget Robert smith 588315 588315 Sprynget, Robert, of Sandherst, smith 1
5131559 2395712 2395712 defendant Murleyn James laborer 588315 588315 Murleyn, James, of Sandherst, laborer 1
5151027 2401440 2401440 defendant Murleyn James laborer 588315 588315 Murleyn, James, of Sandherst, laborer 1
5218239 2421064 2421064 defendant Rede John husbandman 588315 588315 Rede, John, of Sandherst, husbandman 3
5219565 2421456 2421456 defendant Godard Margery widow 588315 588315 Godard, Margery, of Sandherst, widow 0
5225668 2423178 2423178 defendant Scot John husbandman 588315 588315 Scot, John, of Sandherst, husbandman 0
5254364 2431493 2431493 defendant Vaghan David husbandman 588315 588315 Vaghan, David, of Sandherst, husbandman 1
5254366 2431493 2431493 defendant Fyssher John husbandman 588315 588315 Fyssher, John, of Sandherst, husbandman 3
5267146 2435483 2435483 defendant Wilgehet Richard laborer 588315 588315 Wilgehet, Richard, of Sandherst, laborer 0
5284499 2440478 2440478 defendant Sone or Sove Thomas laborer 588315 588315 Sone or Sove, Thomas, of Sandherst, laborer 0
5368225 2465687 2465687 defendant Mungeham William husbandman 588315 588315 Mungeham, William, of Sandherst, husbandman 0
5369679 2466101 2466101 defendant Bate William husbandman 588315 588315 Bate, William, of Sandherst, husbandman 4
5369680 2466101 2466101 defendant Bound Robert husbandman 588315 588315 Bound, Robert, of Sandherst, husbandman 5
5369681 2466101 2466101 defendant Jacobbe John husbandman 588315 588315 Jacobbe, John, of Sandherst, husbandman 6
5394550 2473501 2473501 defendant Kyne Henry husbandman 588315 588315 Kyne, Henry, of Sandherst, husbandman 1
5486065 2500716 2500716 defendant Wellys John chapman 588315 588315 Wellys, John, of Sandherst, chapman 1
5486066 2500716 2500716 defendant Wylget Vincent yeoman 588315 588315 Wylget, Vincent, of Sandherst, yeoman 2
5496557 2503883 2503883 defendant Bourne William husbandman 588315 588315 (Bourne, William, of Sandherst, husbandman 1
5523534 2512189 2512189 defendant Waterman William chapman 588315 588315 Waterman, William, of Sandherst, chapman 2
5553538 2521064 2521064 defendant Bekerynge John yeoman 588315 588315 Bekerynge, John, of Sandherst, yeoman 0
5568775 2525417 2525417 defendant Petter Vincent yeoman 588315 588315 Petter, Vincent, of Sandherst, yeoman 0
5602728 2535732 2535732 defendant Rede William butcher 588315 588315 Rede, William, of Sandherst, butcher 0
5603448 2535967 2535967 defendant Fynch Henry gent 588315 588315 Fynch, Henry, of Sandherst, gent 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);