names

743 rows where place_id = 586748

✎ 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
3589521 1864359 1864359 defendant Grantham John dyer 586748 586748 Grantham, John, of Welles, dyer 2
3589522 1864359 1864359 defendant Brodyer John brasier 586748 586748 Brodyer, John, of Welles, brasier 3
3595397 1866192 1866192 plaintiff Matras Robert butcher 586748 586748 Matras, Robert, of Welles, butcher 0
3595398 1866192 1866192 defendant Amerden Thomas stainer 586748 586748 Amerden, Thomas, of Welles, stainer 0
3600348 1867753 1867753 defendant Grene William tucker 586748 586748 Grene, William, of Welles, tucker 0
3606211 1869612 1869612 defendant Foweles John baker 586748 586748 Foweles, John, of Welles, baker 0
3606335 1869649 1869649 defendant Trenche John baker 586748 586748 Trenche, John, of Welles, baker 1
3617644 1873141 1873141 defendant More Thomas tucker 586748 586748 More, Thomas, of Welles, tucker 0
3618270 1873340 1873340 defendant Draper Julia widow 586748 586748 Draper, Julia, of Welles, widow 1
3626785 1903224 1903224 defendant Baron John yeoman 586748 586748 Baron, John, of Welles, yeoman 1
3628057 1903629 1903629 defendant Grantham William drpaer 586748 586748 Grantham, William, of Welles, drpaer 0
3639143 1907061 1907061 defendant Pyttyn John baker 586748 586748 Pyttyn, John, of Welles, baker 0
3643312 1908333 1908333 defendant Champernon William clerk 586748 586748 Champernon, William, of Welles, clerk 0
3645291 1908936 1908936 defendant Chamber William, senior innholder 586748 586748 Chamber, William, senior, of Welles, innholder 1
3648624 1909958 1909958 defendant Cheryton William husbandman 586748 586748 Cheryton, William, of Welles, husbandman 0
3650130 1910410 1910410 defendant Mayowe John mercer 586748 586748 Mayowe, John, of Welles, mercer 0
3652266 1911047 1911047 defendant Mortemer Nicholas dyer 586748 586748 Mortemer, Nicholas, of Welles, dyer 0
3652267 1911047 1911047 defendant Grauntham William draper 586748 586748 Grauntham, William, of Welles, draper 1
3663019 1914347 1914347 defendant Burley Richard barber 586748 586748 Burley, Richard, of Welles, barber 0
3666620 1915502 1915502 defendant Goldsmyth William hsubandman 586748 586748 Goldsmyth, William, of Welles, hsubandman 0
3667970 1915922 1915922 defendant Gervys William brewer 586748 586748 Gervys, William, of Welles, brewer 0
3673148 1917613 1917613 plaintiff Deverell John   586748 586748 Deverell, John, of Welles 3
3675921 1918507 1918507 plaintiff Hoper Robert draper 586748 586748 Hoper, Robert, of Welles, draper 0
3675925 1918508 1918508 plaintiff Hoper Robert draper 586748 586748 Hoper, Robert, of Welles, draper 0
3693090 1924045 1924045 defendant Apowell Richard clothier 586748 586748 Apowell, Richard, of Welles, clothier 0
3705359 1927964 1927964 defendant Hoper Robert   586748 586748 Hoper, Robert, of Welles, Soms clothman 2
3709220 1929180 1929180 plaintiff Pomeray Richard chaplain 586748 586748 Pomeray, Richard, of Welles, chaplain 0
3709221 1929180 1929180 plaintiff Orchard John chaplain 586748 586748 Orchard, John, of Welles, chaplain 1
3747758 1941222 1941222 defendant Deane Thomas   586748 586748 Deane, Thomas, of Welles, "caryer" 0
3755201 1943578 1943578 defendant Mores Geoffrey yeoman 586748 586748 Mores, Geoffrey, of Welles, yeoman 0
3755949 1943812 1943812 defendant Mores Geoffrey yeoman 586748 586748 Mores, Geoffrey, of Welles, yeoman 0
3762787 1945999 1945999 defendant Boston Richard mercer 586748 586748 Boston, Richard, of Welles, mercer 1
3782967 1952420 1952420 plaintiff Johns John   586748 586748 Johns, John, of Welles 0
3790127 1954730 1954730 defendant Jeheler John husbandman 586748 586748 Jeheler, John, of Welles, husbandman 1
3823911 1965350 1965350 plaintiff Vowell William gent 586748 586748 Vowell, William, of Welles, gent 0
3842967 1971337 1971337 defendant Mason Thomas husbandman 586748 586748 Mason, Thomas, of Welles, husbandman 0
3842968 1971337 1971337 defendant Mason Robert   586748 586748 Mason, Robert, of Welles 1
3842969 1971337 1971337 defendant Mathewe Thomas laborer 586748 586748 Mathewe, Thomas, of Welles, laborer 2
3842973 1971337 1971337 defendant Thyrgatte Thomas husbandman 586748 586748 Thyrgatte, Thomas, of Welles, husbandman 6
3842974 1971337 1971337 defendant Burforde Robert husbandman 586748 586748 Burforde, Robert, of Welles, husbandman 7
3842975 1971337 1971337 defendant Burforde Thomas husbandman 586748 586748 Burforde, Thomas, of Welles, husbandman 8
3842977 1971338 1971338 defendant Mathewe Thomas laborer 586748 586748 Mathewe, Thomas, of Welles, laborer 0
3842982 1971338 1971338 defendant Burforde Robert husbandman 586748 586748 Burforde, Robert, of Welles, husbandman 5
3842983 1971338 1971338 defendant Burforde Thomas husbandman 586748 586748 Burforde, Thomas, of Welles, husbandman 6
3842984 1971338 1971338 defendant Mason Thomas husbandman 586748 586748 Mason, Thomas, of Welles, husbandman 7
3842985 1971338 1971338 defendant Mason Robert husbandman 586748 586748 Mason, Robert, of Welles, husbandman 8
3859671 1976732 1976732 defendant Gallyngton Richard husbandman 586748 586748 Gallyngton, Richard, of Welles, husbandman 0
3867257 1979285 1979285 plaintiff Ryngsted Christopher (legal representative) 586748 586748 Ryngsted, Christopher, of Welles, wax chandler, administratrix of 0
3867514 1979371 1979371 defendant Bradyere John brasier 586748 586748 Bradyere, John, of Welles, brasier 0
3869738 1980118 1980118 defendant Hoper Robert tailor 586748 586748 Hoper, Robert, of Welles, tailor 0
3874643 1981737 1981737 defendant Toppyng John yeoman 586748 586748 Toppyng, John, of Welles, yeoman 0
3890334 1987015 1987015 plaintiff Hillacre John gent 586748 586748 Hillacre, John, of Welles, gent 0
3890336 1987016 1987016 plaintiff Hillacre John gent 586748 586748 Hillacre, John, of Welles, gent 0
3907769 1992882 1992882 defendant Abbys Thomas merchant 586748 586748 Abbys, Thomas, of Welles, merchant 0
3918498 1996516 1996516 defendant Barton Hugh smith 586748 586748 Barton, Hugh, of Welles, smith 2
3918499 1996516 1996516 defendant Turner Jenry   586748 586748 Turner, Jenry, of Welles, lime burner 3
3918503 1996516 1996516 defendant Russell Richard carrier 586748 586748 Russell, Richard, of Welles, carrier 7
3918506 1996516 1996516 defendant Hooper John collier 586748 586748 Hooper, John, of Welles, collier 10
3929979 2000369 2000369 defendant Newton Agnes widow 586748 586748 Newton, Agnes, of Welles, widow 0
3933000 2001331 2001331 plaintiff Gitto Morgan yeoman 586748 586748 Gitto, Morgan, of Welles, yeoman 0
3933002 2001332 2001332 plaintiff Gitto Morgan yeoman 586748 586748 Gitto, Morgan, of Welles, yeoman 0
3939848 2003627 2003627 plaintiff Sheperd Robert mercer 586748 586748 Sheperd, Robert, of Welles, mercer 0
3940680 2003890 2003890 defendant Whyte Christopher brewer 586748 586748 Whyte, Christopher, of Welles, brewer 0
3941413 2004135 2004135 defendant Mylls Thomas   586748 586748 Mylls, Thomas, of Welles, Soms, gailor 0
3961907 2011259 2011259 plaintiff Wallett Robert waterman 586748 586748 Wallett, Robert, of Welles, waterman 0
3972072 2014791 2014791 plaintiff Foster Christabell widow 586748 586748 Christabell his wife, alias Christabel Fulwell, of Welles, widow 1
3981395 2018115 2018115 plaintiff Rawlyns John gent 586748 586748 Rawlyns, John, of Welles, gent 0
3981397 2018115 2018115 defendant Buttermer James yeoman 586748 586748 Buttermer, James, of Welles, yeoman 1
3996574 2023534 2023534 defendant Lewse Giles baker 586748 586748 Lewse, Giles, of Welles, baker 1
4006565 2027127 2027127 plaintiff Llewellen Thomas gent 586748 586748 Llewellen, Thomas, of Welles, gent 0
4051071 2042822 2042822 plaintiff White Christopher yeoman 586748 586748 White, Christopher, of Welles, yeoman 0
4053346 2043573 2043573 plaintiff Androwes John yeoman 586748 586748 Androwes, John, of Welles, yeoman 0
4053947 2043788 2043788 defendant Aysshe Humphrey tailor 586748 586748 Aysshe, Humphrey, of Welles, tailor 0
4053977 2043801 2043801 plaintiff Atwell Robert (legal representative) 586748 586748 Atwell, Robert, of Welles, yeoman, executors, executors of 0
4060404 2046121 2046121 plaintiff Dane John gent 586748 586748 Dane, John, of Welles, gent 0
4060406 2046122 2046122 plaintiff Dane John gent 586748 586748 Dane, John, of Welles, gent 0
4062183 2046763 2046763 defendant Joye John gent 586748 586748 Joye, John, of Welles, gent 3
4067300 2048606 2048606 defendant Galloppe Simon husbandman 586748 586748 Galloppe, Simon, of Welles, husbandman 0
4068720 2049100 2049100 defendant Alford Francis butcher 586748 586748 Alford, Francis, of Welles, butcher 0
4073767 2050907 2050907 defendant Pecke John yeoman 586748 586748 Pecke, John, of Welles, yeoman 1
4088620 2056231 2056231 defendant Llewellen Thomas gent 586748 586748 Llewellen, Thomas, of Welles, gent 0
4095545 2058733 2058733 defendant Budge John innholder 586748 586748 Budge, John, of Welles, innholder 1
4119641 2067311 2067311 defendant Bulman Cuthbert pewterer 586748 586748 Bulman, Cuthbert, of Welles, pewterer 0
4121481 2067976 2067976 defendant Sherwood Christopher yeoman 586748 586748 Sherwood, Christopher, of Welles, yeoman 2
4123064 2068544 2068544 defendant Kelway Hugh gent 586748 586748 Kelway, Hugh, of Welles, gent 0
4132136 2071807 2071807 defendant Kelwaye Thomas gent 586748 586748 Kelwaye, Thomas, of Welles, gent 0
4132137 2071807 2071807 defendant Vigar alias Ames William hosier 586748 586748 Vigar alias Ames, William, of Welles, hosier 1
4133556 2072334 2072334 defendant Sabbe William, senior mariner 586748 586748 Sabbe, William, senior, of Welles, mariner 0
4140265 2074762 2074762 defendant Kelwaye Hugh gent 586748 586748 Kelwaye, Hugh, of Welles, gent 0
4140266 2074762 2074762 defendant Roynon John gent 586748 586748 Roynon, John, of Welles, gent 1
4140463 2074833 2074833 defendant Hick John (legal representative) 586748 586748 Hick, John, of Welles, yeoman, executrix of 2
4146654 2076982 2076982 defendant Sherwood Christopher gent 586748 586748 Sherwood, Christopher, of Welles, gent 0
4147735 2077351 2077351 defendant Thorley William gent 586748 586748 Thorley, William, of Welles, or of Salisbury, gent 0
4152476 2078978 2078978 defendant Joye John yeoman 586748 586748 Joye, John, of Welles, yeoman 0
4165242 2083351 2083351 defendant Llewellinge Thomas gent 586748 586748 Llewellinge, Thomas, of Welles, gent 2
4165382 2083398 2083398 defendant Wigmore William gent 586748 586748 Wigmore, William, of Welles, gent 1
4168586 2084497 2084497 defendant Durban John yeoman 586748 586748 Durban, John, of Welles, yeoman 0
4168590 2084499 2084499 defendant Edwardes William husbandman 586748 586748 Edwardes, William, of Welles, husbandman 0
4170259 2085093 2085093 defendant Trowtell Thomas yeoman 586748 586748 Trowtell, Thomas, of Welles, yeoman 2
4171594 2085531 2085531 defendant Sherwood Christopher gent 586748 586748 Sherwood, Christopher, of Welles, gent 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);