names

104 rows where place_id = 605578

✎ 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
3662215 1914099 1914099 defendant Hakelett Thomas clerk 605578 605578 Hakelett, Thomas, of Wells, Soms, clerk 1
3942393 2004468 2004468 defendant Briges John chapman 605578 605578 Briges, John, of Wells, Soms, chapman 1
3946218 2005757 2005757 defendant Edgyll Edward innholder 605578 605578 Edgyll, Edward, of Wells, Soms, innholder 0
3966944 2013070 2013070 defendant Goodman William yeoman 605578 605578 Goodman, William, of Wells, Soms, yeoman 0
3975400 2015961 2015961 defendant Dodderell William chapman 605578 605578 Dodderell, William, of Wells, Soms, chapman 3
4002375 2025624 2025624 plaintiff Hellyker William gent 605578 605578 Hellyker, William, of Wells, Soms, gent 0
4004950 2026551 2026551 defendant Collens John brewer 605578 605578 Collens, John, of Wells, Soms, or of Salisbury, brewer 1
4004953 2026552 2026552 defendant Collens John brewer 605578 605578 Collens, John, of Wells, Soms, or of Salisbury, brewer 1
4005967 2026908 2026908 defendant Lleuellyn Thomas yeoman 605578 605578 Lleuellyn, Thomas, of Wells, Soms, yeoman 0
4007928 2027601 2027601 defendant Dane John gent 605578 605578 Dane, John, of Wells, Soms, gent 0
4023826 2033228 2033228 plaintiff Beavell Edward yeoman 605578 605578 Beavell, Edward, of Wells, Soms, yeoman 0
4024227 2033367 2033367 plaintiff Bevell Edward yeoman 605578 605578 Bevell, Edward, of Wells, Soms, yeoman 0
4024229 2033368 2033368 plaintiff Bevell Edward yeoman 605578 605578 Bevell, Edward, of Wells, Soms, yeoman 0
4024231 2033369 2033369 plaintiff Bevell Edward yeoman 605578 605578 Bevell, Edward, of Wells, Soms, yeoman 0
4024233 2033370 2033370 plaintiff Bevell Edward yeoman 605578 605578 Bevell, Edward, of Wells, Soms, yeoman 0
4024235 2033371 2033371 plaintiff Bevell Edward yeoman 605578 605578 Bevell, Edward, of Wells, Soms, yeoman 0
4029434 2035165 2035165 plaintiff Dane John gent 605578 605578 Dane, John, of Wells, Soms, gent 0
4029436 2035166 2035166 plaintiff Dane John gent 605578 605578 Dane, John, of Wells, Soms, gent 0
4055539 2044375 2044375 defendant Rugge John clerk 605578 605578 Rugge, John, of Wells, Soms, clerk 0
4064437 2047561 2047561 defendant Brengwell Edmund dyer 605578 605578 Brengwell, Edmund, of Wells, Soms, dyer 0
4065314 2047878 2047878 defendant Hillicar or Hillnar Polidorus gent 605578 605578 Hillicar or Hillnar, Polidorus, of Wells, Soms, gent 0
4083196 2054277 2054277 defendant Gunter William chapman 605578 605578 Gunter, William, of Wells, Soms, chapman 2
4102780 2061295 2061295 defendant Whytynge Thomas gent 605578 605578 Whytynge, Thomas, of Wells, Soms, gent 0
4109933 2063809 2063809 defendant Godwyn Richard, junior gent 605578 605578 Godwyn, Richard, junior, of Wells, Soms, gent 0
4109936 2063810 2063810 defendant Godwyn Richard, junior gent 605578 605578 Godwyn, Richard, junior, of Wells, Soms, gent 0
4130686 2071287 2071287 defendant Sherwood Christopher gent 605578 605578 Sherwood, Christopher, of Wells, Soms, gent 0
4131086 2071436 2071436 defendant Joye John yeoman 605578 605578 Joye, John, of Wells, Soms, yeoman 1
4133710 2072390 2072390 defendant Payne Henry draper 605578 605578 Payne, Henry, of Wells, Soms, draper 1
4138690 2074205 2074205 defendant Baker Robert   605578 605578 Baker, Robert, of Wells, Soms, Doctor of Medicine 1
4139704 2074562 2074562 defendant Gunter William mercer 605578 605578 Gunter, William, of Wells, Soms, mercer 1
4139813 2074602 2074602 defendant Frye Christopher gent 605578 605578 Frye, Christopher, of Wells, Soms, gent 0
4140924 2074990 2074990 defendant Ronyon John gent 605578 605578 Ronyon, John, of Wells, Soms, gent 2
4154903 2079810 2079810 defendant Goodwyn Richard esq 605578 605578 Goodwyn, Richard, of Wells, Soms, esq 0
4159853 2081513 2081513 defendant Godwyn Richard esq 605578 605578 Godwyn, Richard, of Wells, Soms, esq 0
4169988 2084996 2084996 defendant Roynon Belliganus gent 605578 605578 Roynon, Belliganus, of Wells, Soms, gent 0
4169993 2084997 2084997 defendant Roynon Belliganus gent 605578 605578 Roynon, Belliganus, of Wells, Soms, gent 0
4170343 2085119 2085119 defendant Llewellyn John tailor 605578 605578 Llewellyn, John, of Wells, Soms, tailor 0
4170345 2085120 2085120 defendant Smyth John   605578 605578 Smyth, John, of Wells, Soms, notary public 0
4190080 2092033 2092033 defendant Kent John merchant 605578 605578 Kent, John, of Wells, Soms, merchant 0
4197229 2094582 2094582 defendant Ronyon John gent 605578 605578 Ronyon, John, of Wells, Soms, gent 0
4200836 2095852 2095852 defendant Godwyn William gent 605578 605578 Godwyn, William, of Wells, Soms, gent 1
4201257 2095993 2095993 defendant Erlye Humphrey butcher 605578 605578 Erlye, Humphrey, of Wells, Soms, butcher 2
4211506 2099581 2099581 defendant Dawes or Dees Richard innholder 605578 605578 Dawes or Dees, Richard, of Wells, Soms, innholder 2
4238289 2109002 2109002 defendant Foxe Robert chapman 605578 605578 Foxe, Robert, of Wells, Soms, chapman 0
4246131 2111685 2111685 defendant Hasswell Richard gent 605578 605578 Hasswell, Richard, of Wells, Soms, gent 2
4246136 2111686 2111686 defendant Halswell Richard gent 605578 605578 Halswell, Richard, of Wells, Soms, gent 2
4259793 2116248 2116248 defendant Godwyn Richard gent 605578 605578 Godwyn, Richard, of Wells, Soms, gent 1
4263767 2117539 2117539 defendant Sherwood Thomas yeoman 605578 605578 Sherwood, Thomas, of Wells, Soms, yeoman 0
4273443 2120676 2120676 defendant Cottington     605578 605578 Cottington, , of Wells, Soms, Doctor of Theology 2
4278915 2122559 2122559 defendant Morgan William gent 605578 605578 Morgan, William, of Wells, Soms, gent 1
4287186 2125475 2125475 defendant Seadinam or Seadenham Richard gent 605578 605578 Seadinam or Seadenham, Richard, of Wells, Soms, gent 1
4288889 2126080 2126080 defendant Saunders John   605578 605578 Saunders, John, of Wells, Soms, clerk, resident canon in Wells Cathedral 0
4295235 2128381 2128381 defendant Saunders John clerk 605578 605578 Saunders, John, of Wells, Soms, clerk 2
4300493 2130269 2130269 defendant Upton George esq 605578 605578 Upton, George, of Wells, Soms, esq 0
4304082 2131562 2131562 defendant Nurton William innholder 605578 605578 Nurton, William, of Wells, Soms, innholder 0
4305163 2131943 2131943 defendant Nurton William innholder 605578 605578 Nurton, William, of Wells, Soms, innholder 0
4306256 2132326 2132326 defendant Jenkyns Henry dyer 605578 605578 Jenkyns, Henry, of Wells, Soms, dyer 0
4313983 2134997 2134997 defendant Haleswell Richard gent 605578 605578 Haleswell, Richard, of Wells, Soms, gent 0
4325170 2138798 2138798 defendant Saunders John clerk 605578 605578 (Saunders, John, of Wells, Soms, clerk 2
4327471 2139509 2139509 defendant Saunders John clerk 605578 605578 Saunders, John, of Wells, Soms, clerk 2
4329828 2140276 2140276 defendant Bartlett Thomas gent 605578 605578 Bartlett, Thomas, of Wells, Soms, gent 0
4349471 2147079 2147079 defendant Whytinge David mercer 605578 605578 Whytinge, David, of Wells, Soms, mercer 0
4354322 2148743 2148743 defendant Whittinge David   605578 605578 Whittinge, David, of Wells, Soms, linen draper 3
4378613 2157423 2157423 defendant Godwyn Michael gent 605578 605578 Godwyn, Michael, of Wells, Soms, gent 2
4387292 2160398 2160398 defendant Morrys Thomas tailor 605578 605578 Morrys, Thomas, of Wells, Soms, tailor 0
4411630 2168486 2168486 defendant Tuggle Thomas vintner 605578 605578 Tuggle, Thomas, of Wells, Soms, vintner 0
4471173 2191645 2191645 defendant Ferreys John   605578 605578 Ferreys, John, of Wells, Soms 1
4682338 2260099 2260099 defendant Horewode John (legal representative) 605578 605578 Horewode, John, of Wells, Soms, clothier, executors of 3
4691020 2262716 2262716 defendant Perye William clerk 605578 605578 Perye, William, of Wells, Soms, clerk 0
4691746 2262951 2262951 defendant Edmund Roger baker 605578 605578 Edmund, Roger, of Wells, Soms, baker 0
4696288 2264322 2264322 defendant Honythorn Robert husbandman 605578 605578 Honythorn, Robert, of Wells, Soms, husbandman 0
4728637 2274195 2274195 defendant Pekyngton William clerk 605578 605578 Pekyngton, William, of Wells, Soms, clerk 2
4759994 2283464 2283464 defendant Burgh Robert clerk 605578 605578 (Burgh, Robert, of Wells, Soms, clerk 1
4760241 2283555 2283555 defendant Soper Thomas cardmaker 605578 605578 Soper, Thomas, of Wells, Soms, cardmaker 3
4768940 2286267 2286267 defendant Pedewelle John chapman 605578 605578 Pedewelle, John, of Wells, Soms, chapman 0
4770059 2286607 2286607 defendant Bailly Simon merchant 605578 605578 Bailly, Simon, of Wells, Soms, merchant 1
4772986 2287524 2287524 defendant Gosselyn Ralph   605578 605578 Gosselyn, Ralph, of Wells, Soms, burgess & merchant 0
4814989 2300798 2300798 defendant Bradford John merchant 605578 605578 Bradford, John, of Wells, Soms, merchant 1
4816873 2301382 2301382 defendant Bathe John   605578 605578 Bathe, John, of Wells, Soms, canon of the cathedral church 0
4832107 2306071 2306071 defendant Hall Richard merchant 605578 605578 Hall, Richard, of Wells, Soms, merchant 0
4844006 2309636 2309636 defendant Wexe William chapman 605578 605578 Wexe, William, of Wells, Soms, chapman 1
4896498 2325574 2325574 defendant Dylverton Walter merchant 605578 605578 Dylverton, Walter, of Wells, Soms, merchant 0
4896502 2325576 2325576 defendant Dylverton Walter merchant 605578 605578 Dylverton, Walter, of Wells, Soms, merchant 0
4908687 2329269 2329269 defendant Golde John chaplain 605578 605578 Golde, John, of Wells, Soms, chaplain 0
4908698 2329270 2329270 defendant Bolde John chaplain 605578 605578 Bolde, John, of Wells, Soms, chaplain 0
4919901 2332732 2332732 defendant Poule John merchant 605578 605578 Poule, John, of Wells, Soms, merchant 1
5049516 2371485 2371485 defendant Dylverton Walter merchant 605578 605578 Dylverton, Walter, of Wells, Soms, merchant 0
5049521 2371486 2371486 defendant Selwode Henry merchant 605578 605578 Selwode, Henry, of Wells, Soms, merchant 0
5124777 2393719 2393719 defendant Vowell Richard gent 605578 605578 Vowell, Richard, of Wells, Soms, gent 1
5124796 2393725 2393725 defendant Vowell Richard gent 605578 605578 Vowell, Richard, of Wells, Soms, gent 1
5131509 2395698 2395698 defendant Medylton John clerk 605578 605578 (Medylton, John, of Wells, Soms, clerk 1
5131556 2395711 2395711 defendant Bridee John   605578 605578 Bridee, John, of Wells, Soms, burgess & glover 0
5132040 2395860 2395860 defendant Medilton John   605578 605578 (Medilton, John, of Wells, Soms 1
5174217 2408157 2408157 defendant Horewode Thomas chapman 605578 605578 Horewode, Thomas, of Wells, Soms, chapman 0
5194524 2414130 2414130 defendant Sporwell William barber 605578 605578 Sporwell, William, of Wells, Soms, barber 2
5206008 2417489 2417489 defendant Poule John brewer alias clothier 605578 605578 Poule, John, of Wells, Soms, brewer alias clothier 1
5208783 2418294 2418294 defendant Sporwell William barber 605578 605578 Sporwell, William, of Wells, Soms, barber 2
5257534 2432476 2432476 defendant Smyth alias Philpot John smith 605578 605578 Smyth alias Philpot, John, of Wells, Soms, smith 2
5284212 2440402 2440402 defendant Smyth Robert smith 605578 605578 Smyth, Robert, of Wells, Soms, smith 3
5306104 2446813 2446813 defendant Heywod Thomas clothier 605578 605578 Heywod, Thomas, of Wells, Soms, clothier 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);