names

311 rows where place_id = 604261

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3657412 1912577 1912577 defendant Mortymer Nicholas dyer 604261 604261 Mortymer, Nicholas, of Wells, dyer 0
3657413 1912577 1912577 defendant Baset William yeoman 604261 604261 Baset, William, of Wells, yeoman 1
3712426 1930204 1930204 plaintiff Welshott John (legal representative) 604261 604261 Welshott, John, of Wells, mercer, executors of 0
3712430 1930205 1930205 plaintiff Welshott John (legal representative) 604261 604261 Welshott, John, of Wells, mercer, executors of 0
3718665 1932119 1932119 plaintiff Gardyner Walter butcher 604261 604261 Gardyner, Walter, of Wells, butcher 0
3755432 1943652 1943652 defendant Gane William (legal representative) 604261 604261 Gane, William, of Wells, husbandman, executors of 1
3853174 1974612 1974612 defendant Capper James butcher 604261 604261 Capper, James, of Wells, butcher 0
3928058 1999719 1999719 defendant Sherre Walter butcher 604261 604261 Sherre, Walter, of Wells, butcher 1
3928059 1999719 1999719 defendant Northome William glover 604261 604261 Northome, William, of Wells, glover 2
3930571 2000567 2000567 defendant Waters Jerome husbandman 604261 604261 Waters, Jerome, of Wells, husbandman 0
3933662 2001549 2001549 plaintiff Gytto Morgan yeoman 604261 604261 Gytto, Morgan, of Wells, yeoman 0
3935236 2002095 2002095 defendant Jones William clothier 604261 604261 Jones, William, of Wells, clothier 0
3938995 2003374 2003374 defendant Whyte Christopher brewer 604261 604261 Whyte, Christopher, of Wells, brewer 0
3941421 2004138 2004138 defendant Gregorye John draper 604261 604261 Gregorye, John, of Wells, draper 0
3946216 2005757 2005757 plaintiff Burston William (legal representative) 604261 604261 Burston, William, of Wells, yeoman, executors of 0
3963953 2011999 2011999 plaintiff Andrewes John yeoman 604261 604261 Andrewes, John, of Wells, yeoman 0
3985938 2019737 2019737 defendant Foster James yeoman 604261 604261 Foster, James, of Wells, yeoman 1
3985939 2019737 2019737 defendant Foster Christabell widow 604261 604261 Christabell his wife, alias Christabell Fulwell, of Wells, widow 2
3988993 2020803 2020803 defendant Clement John, senior husbandman 604261 604261 Clement, John, senior, of Wells, husbandman 0
4003248 2025920 2025920 plaintiff Honsigo John mariner 604261 604261 Honsigo, John, of Wells, mariner 0
4022111 2032637 2032637 plaintiff Androwes John yeoman 604261 604261 Androwes, John, of Wells, yeoman 0
4022302 2032699 2032699 plaintiff ap John William Jones ap Rees gent 604261 604261 ap John, William Jones ap Rees, of Wells, gent 0
4029432 2035164 2035164 plaintiff Dane John gent 604261 604261 Dane, John, of Wells, gent 0
4055533 2044372 2044372 defendant Gete Alexander smith 604261 604261 Gete, Alexander, of Wells, smith 0
4062467 2046868 2046868 defendant Aysshe Humphrey tailor 604261 604261 Aysshe, Humphrey, of Wells, tailor 0
4062871 2047021 2047021 defendant Mudwell Richard tailor 604261 604261 Mudwell, Richard, of Wells, tailor 0
4067002 2048495 2048495 defendant Hillacke Pollidore gent 604261 604261 Hillacke, Pollidore, of Wells, gent 0
4086513 2055460 2055460 defendant Budge John yeoman 604261 604261 Budge, John, of Wells, yeoman 0
4090050 2056725 2056725 defendant Goodman John victualer 604261 604261 Goodman, John, of Wells, victualer 1
4095534 2058730 2058730 defendant Danyell Robert butcher 604261 604261 Danyell, Robert, of Wells, butcher 1
4095544 2058733 2058733 defendant Selbye Robert saddler 604261 604261 Selbye, Robert, of Wells, saddler 0
4099158 2060025 2060025 defendant Anstye Richard chapman 604261 604261 Anstye, Richard, of Wells, chapman 0
4104272 2061805 2061805 defendant Harwood John gent 604261 604261 Harwood, John, of Wells, gent 0
4104274 2061806 2061806 defendant Harwoode John gent 604261 604261 Harwoode, John, of Wells, gent 0
4109934 2063809 2063809 defendant Helegar or Helligar Polidore gent 604261 604261 Helegar or Helligar, Polidore, of Wells, gent 1
4109937 2063810 2063810 defendant Helgar or Helligar Polidor gent 604261 604261 Helgar or Helligar, Polidor, of Wells, gent 1
4125660 2069460 2069460 defendant Morse John husbandman 604261 604261 Morse, John, of Wells, husbandman 0
4129526 2070864 2070864 defendant Hunt Osmund clothier 604261 604261 Hunt, Osmund, of Wells, clothier 0
4131079 2071434 2071434 defendant Warden Peter   604261 604261 Warden, Peter, of Wells, laborer, "grovyer" 1
4131080 2071434 2071434 defendant Pascall Henry   604261 604261 Pascall, Henry, of Wells, laborer, "grovyer" 2
4131081 2071434 2071434 defendant Davis John   604261 604261 Davis, John, of Wells, laborer, "grovyer" 3
4131087 2071436 2071436 defendant Warden or Warren Peter laborer 604261 604261 Warden or Warren, Peter, of Wells, laborer 2
4131088 2071436 2071436 defendant Pascall Henry laborer 604261 604261 Pascall, Henry, of Wells, laborer 3
4131710 2071661 2071661 defendant Kente James yeoman 604261 604261 Kente, James, of Wells, yeoman 1
4131713 2071662 2071662 defendant Kente James yeoman 604261 604261 Kente, James, of Wells, yeoman 1
4133877 2072453 2072453 defendant Myldon or Meldon Richard yeoman 604261 604261 Myldon or Meldon, Richard, of Wells, yeoman 0
4133878 2072453 2072453 defendant Ames alias Vygure William tailor 604261 604261 Ames alias Vygure, William, of Wells, tailor 1
4144949 2076393 2076393 defendant Coxe Thomas butcher 604261 604261 Coxe, Thomas, of Wells, butcher 2
4155919 2080148 2080148 defendant Carr Thomas butcher 604261 604261 Carr, Thomas, of Wells, butcher 1
4162717 2082515 2082515 defendant Gete or Jett Sander smith 604261 604261 Gete or Jett, Sander, of Wells, smith 2
4165320 2083377 2083377 defendant Hodson Miles yeoman 604261 604261 Hodson, Miles, of Wells, yeoman 0
4170271 2085096 2085096 defendant Hunte Osmund weaver 604261 604261 Hunte, Osmund, of Wells, weaver 0
4186316 2090699 2090699 defendant Lewellyn Thomas gent 604261 604261 Lewellyn, Thomas, of Wells, gent 1
4199564 2095396 2095396 defendant Nayshe William husbandman 604261 604261 Nayshe, William, of Wells, or of Eston, Soms, husbandman 3
4203414 2096745 2096745 defendant Durban John yeoman 604261 604261 Durban, John, of Wells, yeoman 0
4220913 2102809 2102809 defendant Smyth Robert yeoman 604261 604261 Smyth, Robert, of Wells, yeoman 1
4229812 2105911 2105911 defendant Payne Henry   604261 604261 Payne, Henry, of Wells, linen draper 0
4233807 2107350 2107350 defendant Godwyn Richard esq 604261 604261 Godwyn, Richard, of Wells, esq 0
4238537 2109093 2109093 defendant Sabbe William yeoman 604261 604261 Sabbe, William, of Wells, yeoman 0
4245171 2111373 2111373 defendant Halswell Richard gent 604261 604261 Halswell, Richard, of Wells, gent 0
4245175 2111374 2111374 defendant Halswell Richard gent 604261 604261 Halswell, Richard, of Wells, gent 0
4249680 2112878 2112878 defendant Atwood Thomas gent 604261 604261 Atwood, Thomas, of Wells, gent 0
4249681 2112878 2112878 defendant Caresbroke George yeoman 604261 604261 Caresbroke, George, of Wells, yeoman 1
4249682 2112878 2112878 defendant Cuff John husbandman 604261 604261 Cuff, John, of Wells, husbandman 2
4249683 2112878 2112878 defendant Woodyer John husbandman 604261 604261 Woodyer, John, of Wells, husbandman 3
4249685 2112879 2112879 defendant Gallington John yeoman 604261 604261 Gallington, John, of Wells, yeoman 0
4249686 2112879 2112879 defendant Foster John husbandman 604261 604261 Foster, John, of Wells, husbandman 1
4249688 2112880 2112880 defendant Rogers John husbandman 604261 604261 Rogers, John, of Wells, husbandman 0
4257930 2115625 2115625 defendant Cole Richard   604261 604261 Cole, Richard, of Wells, or of Bristol, marchant 0
4257931 2115625 2115625 defendant Hobbes Nicholas   604261 604261 Hobbes, Nicholas, of Wells vintner 1
4257932 2115625 2115625 defendant Tyler Thomas yeoman 604261 604261 Tyler, Thomas, of Wells, or of Bristol, yeoman 2
4257933 2115625 2115625 defendant Baker Walter yeoman 604261 604261 Baker, Walter, of Wells, or of Bristol, yeoman 3
4263241 2117372 2117372 defendant Webb Alice widow 604261 604261 Webb, Alice, of Wells, widow 2
4275363 2121319 2121319 defendant Hadnett William gent 604261 604261 Hadnett, William, of Wells, gent 0
4279706 2122819 2122819 defendant Watts Edmund clerk 604261 604261 Watts, Edmund, of Wells, clerk 0
4279811 2122856 2122856 defendant Nurton William yeoman 604261 604261 Nurton, William, of Wells, yeoman 0
4281750 2123520 2123520 defendant Wigmore William gent 604261 604261 Wigmore, William, of Wells, gent 0
4283764 2124234 2124234 defendant Loggen John tailor 604261 604261 Loggen, John, of Wells, tailor 0
4283765 2124234 2124234 defendant Brent Thomas   604261 604261 Brent, Thomas, of Wells, freemason 1
4283766 2124234 2124234 defendant Brent William   604261 604261 Brent, William, of Wells, freemason 2
4284262 2124423 2124423 defendant Nurton or Norton William innholder 604261 604261 Nurton or Norton, William, of Wells, innholder 0
4284264 2124424 2124424 defendant Nurton or Norton William innholder 604261 604261 Nurton or Norton, William, of Wells, innholder 0
4285388 2124822 2124822 defendant Kinge Robert yeoman 604261 604261 Kinge, Robert, of Wells, yeoman 0
4286050 2125066 2125066 defendant Nurton William innholder 604261 604261 Nurton, William, of Wells, innholder 0
4287413 2125549 2125549 defendant Sponer Robert blacksmith 604261 604261 Sponer, Robert, of Wells, blacksmith 2
4287933 2125731 2125731 defendant Morse John laborer or "grovyer" 604261 604261 Morse, John, of Wells, laborer or "grovyer" 0
4289372 2126258 2126258 defendant Mason Richard clerk 604261 604261 Mason, Richard, of Wells, clerk 1
4289374 2126258 2126258 defendant Gibbes John chapman 604261 604261 Gibbes, John, of Wells, chapman 3
4290627 2126705 2126705 defendant Wigmore William gent 604261 604261 Wigmore, William, of Wells, gent 0
4302256 2130905 2130905 defendant George Christopher butcher 604261 604261 George, Christopher, of Wells, butcher 0
4303835 2131472 2131472 defendant Smythe Robert innkeeper 604261 604261 Smythe, Robert, of Wells, innkeeper 0
4316264 2135801 2135801 defendant Crowche Walter gent 604261 604261 Crowche, Walter, of Wells, gent 0
4316325 2135824 2135824 defendant Hutchyns John yeoman 604261 604261 Hutchyns, John, of Wells, or of Est Horrington, yeoman 2
4316326 2135824 2135824 defendant Foxe Robert tailor 604261 604261 Foxe, Robert, of Wells, tailor 3
4318159 2136459 2136459 defendant Poore alias Hodges John   604261 604261 Poore alias Hodges, John, of Wells, woollen draper 3
4325194 2138806 2138806 defendant Jefferies Mathew clerk 604261 604261 Jefferies, Mathew, of Wells, clerk 1
4325941 2139051 2139051 defendant Beere Edward   604261 604261 Beere, Edward, of Wells, felt maker 0
4327328 2139464 2139464 defendant Disse John gent 604261 604261 Disse, John, of Wells, gent 0
4327329 2139464 2139464 defendant Bigge John yeoman 604261 604261 Bigge, John, of Wells, yeoman 1
4328723 2139917 2139917 defendant Williams alias Lambert Robert husbandman 604261 604261 Williams alias Lambert, Robert, of Wells, husbandman 0

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