names

222 rows where place_id = 588305

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594054 1865781 1865781 defendant Gardener Ralph clerk 588305 588305 Gardener, Ralph, of Welles, Soms, clerk 0
3599626 1867524 1867524 defendant Gardener Ralph clerk 588305 588305 Gardener, Ralph, of Welles, Soms, clerk 0
3612976 1871706 1871706 defendant Mayowe John mercer 588305 588305 Mayowe, John, of Welles, Soms, mercer 1
3613515 1871875 1871875 defendant Parys John gent 588305 588305 Parys, John, of Welles, Soms, gent 3
3613520 1871876 1871876 defendant Parys John gent 588305 588305 Parys, John, of Welles, Soms, gent 3
3618269 1873340 1873340 defendant Draper John (legal representative) 588305 588305 Draper, John, of Welles, Soms, executrix of 0
3624940 1875334 1875334 defendant Whityng Robert yeoman 588305 588305 Whityng, Robert, of Welles, Soms, yeoman 1
3640281 1907393 1907393 defendant Edmondys John clerk 588305 588305 Edmondys, John, of Welles, Soms, clerk 0
3754439 1943345 1943345 defendant Storrage Henry yeoman 588305 588305 Storrage, Henry, of Welles, Soms, yeoman 2
3790526 1954861 1954861 plaintiff Welshot John (legal representative) 588305 588305 Welshot, John, of Welles, Soms, mercer, executor of 0
3797924 1957249 1957249 defendant Foxe John tucker 588305 588305 Foxe, John, of Welles, Soms, tucker 2
3954154 2008527 2008527 defendant White Christopher brewer 588305 588305 White, Christopher, of Welles, Soms, brewer 2
3959251 2010313 2010313 defendant Cole Richard yeoman 588305 588305 Cole, Richard, of Welles, Soms, yeoman 0
3961489 2011116 2011116 defendant Fulwell Thomes mercer 588305 588305 Fulwell, Thomes, of Welles, Soms, mercer 0
3967920 2013408 2013408 defendant Stevyn Leonard mercer 588305 588305 Stevyn, Leonard, of Welles, Soms, clerk, or of Devyses, mercer 0
3972073 2014791 2014791 defendant Well alias Lane John yeoman 588305 588305 Well alias Lane, John, of Welles, Soms, yeoman 0
3981396 2018115 2018115 defendant Slade John yeoman 588305 588305 Slade, John, of Welles, Soms, yeoman 0
3982530 2018527 2018527 defendant Dorsett William gent 588305 588305 Dorsett, William, of Welles, Soms, or of Clement Inn, Middx, gent 0
3990380 2021313 2021313 plaintiff Bevell Edward yeoman 588305 588305 Bevell, Edward, of Welles, Soms, yeoman 0
3990393 2021319 2021319 plaintiff Bevill Edward yeoman 588305 588305 Bevill, Edward, of Welles, Soms, yeoman 0
3996573 2023534 2023534 defendant Lewse William baker 588305 588305 Lewse, William, of Welles, Soms, baker 0
4005181 2026630 2026630 defendant Blan John, senior husbandman 588305 588305 Blan, John, senior, of Welles, Soms, husbandman 2
4011051 2028726 2028726 defendant Howssey Henry vintner 588305 588305 Howssey, Henry, of Welles, Soms, vintner 0
4012032 2029033 2029033 defendant Godwyn Adrian chapman 588305 588305 Godwyn, Adrian, of Welles, Soms, chapman 0
4013106 2029420 2029420 defendant Baylye Thomas clerk 588305 588305 Baylye, Thomas, of Welles, Soms, clerk 0
4024215 2033365 2033365 plaintiff Beveld or Befeld Edward yeoman 588305 588305 Beveld or Befeld, Edward, of Welles, Soms, yeoman 0
4035854 2037493 2037493 defendant Kynvyn William clerk 588305 588305 Kynvyn, William, of Welles, Soms, clerk 1
4046637 2041250 2041250 defendant Light William tanner 588305 588305 Light, William, of Welles, Soms, tanner 0
4046778 2041303 2041303 defendant Light William tanner 588305 588305 Light, William, of Welles, Soms, tanner 0
4058513 2045435 2045435 plaintiff Chipper Richard yeoman 588305 588305 Chipper, Richard, of Welles, Soms, yeoman 0
4076904 2052027 2052027 plaintiff Smyth John gent or yeoman 588305 588305 Smyth, John, of Welles, Soms, gent or yeoman 0
4086251 2055356 2055356 defendant Austey Richard chapman 588305 588305 Austey, Richard, of Welles, Soms, chapman 0
4095488 2058711 2058711 defendant Sherewood Christopher gent 588305 588305 Sherewood, Christopher, of Welles, Soms, gent 1
4096177 2058961 2058961 defendant Geatte Alexander smith 588305 588305 Geatte, Alexander, of Welles, Soms, smith 0
4100363 2060461 2060461 defendant Beavell Edward gent 588305 588305 Beavell, Edward, of Welles, Soms, gent 0
4107402 2062935 2062935 defendant Sparke John clerk 588305 588305 Sparke, John, of Welles, Soms, clerk 3
4120098 2067476 2067476 defendant Backer Richard husbandman 588305 588305 Backer, Richard, of Welles, Soms, husbandman 3
4121480 2067976 2067976 defendant Godwyn William gent 588305 588305 Godwyn, William, of Welles, Soms, gent 1
4131848 2071703 2071703 defendant Nayler Mathew   588305 588305 Nayler, Mathew, of Welles, Soms, clerk, vicar choral, Wells Cathedral 0
4132448 2071921 2071921 defendant Lynterne Ralph chapman 588305 588305 Lynterne, Ralph, of Welles, Soms, chapman 2
4137299 2073688 2073688 defendant Anstie or Austie Richard tailor 588305 588305 Anstie or Austie, Richard, of Welles, Soms, tailor 0
4147309 2077197 2077197 defendant Roynon John gent 588305 588305 Roynon, John, of Welles, Soms, gent 1
4147312 2077198 2077198 defendant Mudwell Richard yeoman 588305 588305 Mudwell, Richard, of Welles, Soms, yeoman 1
4147314 2077199 2077199 defendant Roynon John gent 588305 588305 Roynon, John, of Welles, Soms, gent 0
4150992 2078477 2078477 defendant Doye Thomas innholder 588305 588305 Doye, Thomas, of Welles, Soms, innholder 2
4161156 2081978 2081978 defendant Mores John   588305 588305 Mores, John, of Welles, Soms, "grovyer" 0
4161168 2081983 2081983 defendant Byrche Mathew yeoman 588305 588305 Byrche, Mathew, of Welles, Soms, yeoman 0
4161263 2082021 2082021 defendant Godwyn Richard esq 588305 588305 Godwyn, Richard, of Welles, Soms, or of Middle Temple, London, esq 0
4162187 2082331 2082331 defendant Sherwood Christopher gent 588305 588305 Sherwood, Christopher, of Welles, Soms, gent 1
4163383 2082720 2082720 defendant Batt Henry   588305 588305 Batt, Henry, of Welles, Soms, "mynderer" 0
4165241 2083351 2083351 defendant Sherewood Christopher gent 588305 588305 Sherewood, Christopher, of Welles, Soms, gent 1
4166729 2083859 2083859 defendant Gilberte John husbandman 588305 588305 Gilberte, John, of Welles, Soms, husbandman 0
4171429 2085470 2085470 defendant Stevens William husbandman 588305 588305 Stevens, William, of Welles, Soms, husbandman 3
4177340 2087546 2087546 defendant Durban John husbandman 588305 588305 Durban, John, of Welles, Soms, husbandman 0
4184311 2090014 2090014 defendant Goodwyn Richard, junior gent 588305 588305 Goodwyn, Richard, junior, of Welles, Soms, gent 0
4184823 2090201 2090201 defendant Busshell Richard yeoman 588305 588305 Busshell, Richard, of Welles, Soms, yeoman 1
4189132 2091690 2091690 defendant Batt Henry yeoman 588305 588305 Batt, Henry, of Welles, Soms, yeoman 0
4189989 2092001 2092001 defendant Durban John yeoman 588305 588305 Durban, John, of Welles, Soms, yeoman 0
4193890 2093424 2093424 defendant Kent James yeoman 588305 588305 Kent, James, of Welles, Soms, yeoman 3
4200536 2095749 2095749 defendant Durban John husbandman 588305 588305 Durban, John, of Welles, Soms, husbandman 0
4202422 2096388 2096388 defendant Bale Henry yeoman 588305 588305 Bale, Henry, of Welles, Soms, yeoman 0
4203062 2096620 2096620 defendant Wygmore William gent 588305 588305 Wygmore, William, of Welles, Soms, gent 0
4203090 2096630 2096630 defendant Perryman John tailor 588305 588305 Perryman, John, of Welles, Soms, tailor 0
4207483 2098172 2098172 defendant Palmer Peter yeoman 588305 588305 Palmer, Peter, of Welles, Soms, yeoman 0
4208137 2098401 2098401 defendant Lawnsdon Robert barber 588305 588305 Lawnsdon, Robert, of Welles, Soms, barber 0
4212319 2099855 2099855 defendant Wygmore William gent 588305 588305 Wygmore, William, of Welles, Soms, gent 1
4229238 2105708 2105708 defendant Ayshe John chapman 588305 588305 Ayshe, John, of Welles, Soms, chapman 3
4240473 2109793 2109793 defendant Cottington James   588305 588305 Cottington, James, of Welles, Soms, Doctor of Theology 0
4250889 2113277 2113277 defendant Mason Richard clerk 588305 588305 Mason, Richard, of Welles, Soms, clerk 1
4250894 2113278 2113278 defendant Miller Stephen tailor 588305 588305 Miller, Stephen, of Welles, Soms, tailor 1
4257986 2115641 2115641 defendant Hayward Thomas gent 588305 588305 Hayward, Thomas, of Welles, Soms, gent 0
4259088 2116010 2116010 defendant Ayshe John chapman 588305 588305 Ayshe, John, of Welles, Soms, chapman 3
4264944 2117911 2117911 defendant Mason Richard clerk 588305 588305 Mason, Richard, of Welles, Soms, clerk 1
4264949 2117912 2117912 defendant Miller Stephen tailor 588305 588305 Miller, Stephen, of Welles, Soms, tailor 1
4271247 2119958 2119958 defendant Cottington James   588305 588305 Cottington, James, of Welles, Soms, clerk, Doctor of Theology 0
4291349 2126979 2126979 defendant Slade Richard tailor 588305 588305 Slade, Richard, of Welles, Soms, tailor 1
4312280 2134430 2134430 defendant Carbrooke Robert yeoman 588305 588305 Carbrooke, Robert, of Welles, Soms, yeoman 0
4331394 2140799 2140799 defendant Brockynge John yeoman 588305 588305 Brockynge, John, of Welles, Soms, yeoman 2
4336577 2142520 2142520 defendant Brooking John chapman 588305 588305 Brooking, John, of Welles, Soms, chapman 0
4370201 2154404 2154404 defendant Morgan William gent 588305 588305 Morgan, William, of Welles, Soms, or of London, gent 0
4387312 2160404 2160404 defendant Bayley Humphrey clerk 588305 588305 Bayley, Humphrey, of Welles, Soms, clerk 1
4400179 2164651 2164651 defendant Brookin John gent 588305 588305 Brookin, John, of Welles, Soms, gent 2
4403452 2165726 2165726 defendant Cottington James   588305 588305 Cottington, James, of Welles, Soms, Doctor of Theology 0
4529160 2209398 2209398 defendant Davy Thomas   588305 588305 Davy, Thomas, of Welles, Soms 0
4558972 2218768 2218768 defendant Rouburgh John   588305 588305 Rouburgh, John, of Welles, Soms 0
4558977 2218769 2218769 defendant Rouburgh John   588305 588305 Rouburgh, John, of Welles, Soms 0
4666380 2250960 2250960 defendant Lambroke William clerk 588305 588305 Lambroke, William, of Welles, Soms, clerk 0
4666382 2250961 2250961 defendant Lambroke William clerk 588305 588305 Lambroke, William, of Welles, Soms, clerk 0
4674764 2257719 2257719 defendant Fulknapp Thomas carpenter 588305 588305 Fulknapp, Thomas, of Welles, Soms, carpenter 0
4675757 2258024 2258024 defendant Medeforde Walter   588305 588305 Medeforde, Walter, of Welles, Soms, Dean & clerk 0
4691017 2262715 2262715 defendant Pery William clerk 588305 588305 Pery, William, of Welles, Soms, clerk 0
4696511 2264385 2264385 defendant White John fuller 588305 588305 White, John, of Welles, Soms, fuller 1
4711877 2269046 2269046 defendant Bokkyng Richard brewer 588305 588305 Bokkyng, Richard, of Welles, Soms, brewer 0
4718871 2271244 2271244 defendant Pediwell John merchant 588305 588305 Pediwell, John, of Welles, Soms, merchant 0
4728269 2274086 2274086 defendant Coker John chapman 588305 588305 Coker, John, of Welles, Soms, chapman 1
4744032 2278778 2278778 defendant Metford Walter clerk 588305 588305 Metford, Walter, of Welles, Soms, clerk 7
4752892 2281298 2281298 defendant Chesilden Robert gent 588305 588305 Chesilden, Robert, of Welles, Soms, gent 1
4752899 2281301 2281301 defendant Chesilden Robert gent 588305 588305 Chesilden, Robert, of Welles, Soms, gent 1
4780263 2289828 2289828 defendant Somerset Richard fisher 588305 588305 Somerset, Richard, of Welles, Soms, fisher 0
4782143 2290417 2290417 defendant Chesulden Robert gent 588305 588305 Chesulden, Robert, of Welles, Soms, 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);