names

165 rows where place_id = 619663

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3731213 1935988 1935988 defendant Meyre William clothier 619663 619663 Meyre, William, of Sherborne, clothier 0
3731214 1935988 1935988 defendant Dudeney Robert husbandman 619663 619663 Dudeney, Robert, of Sherborne, husbandman 1
3789120 1954405 1954405 defendant Hall John clerk 619663 619663 Hall, John, of Sherborne, clerk 1
3811946 1961642 1961642 plaintiff Cokeman Robert tanner 619663 619663 Cokeman, Robert, of Sherborne, tanner 0
3851833 1974165 1974165 defendant Buckebryge William yeoman 619663 619663 Buckebryge, William, of Sherborne, yeoman 0
3955605 2009033 2009033 plaintiff Mayre William (legal representative) 619663 619663 Mayre, William, of Sherborne, gent, executrix of 0
3958599 2010079 2010079 defendant Whytehedde John draper 619663 619663 Whytehedde, John, of Sherborne, draper 0
3958601 2010080 2010080 defendant Enggleberd Nicholas yeoman 619663 619663 Enggleberd, Nicholas, of Sherborne, yeoman 0
3959720 2010489 2010489 defendant Moryn John tailor 619663 619663 Moryn, John, of Sherborne, tailor 0
3961525 2011131 2011131 defendant Standyche John tailor 619663 619663 Standyche, John, of Sherborne, tailor 0
3969417 2013908 2013908 defendant Pytman John yeoman 619663 619663 Pytman, John, of Sherborne, yeoman 0
3971488 2014586 2014586 defendant Dyer Richard butcher 619663 619663 Dyer, Richard, of Sherborne, butcher 0
3987830 2020393 2020393 defendant Standyshe John tailor 619663 619663 Standyshe, John, of Sherborne, tailor 0
3995419 2023103 2023103 plaintiff Cowper John tanner 619663 619663 Cowper, John, of Sherborne, tanner 0
3997444 2023832 2023832 defendant Towgood Thomas husbandman 619663 619663 Towgood, Thomas, of Sherborne, husbandman 0
3998921 2024374 2024374 plaintiff Foster Thomas (legal representative) 619663 619663 Foster, Thomas, of Sherborne, executors of 0
3998924 2024374 2024374 defendant Cooke William clothworker 619663 619663 Cooke, William, of Sherborne, clothworker 0
3998925 2024375 2024375 plaintiff Foster Thomas (legal representative) 619663 619663 Foster, Thomas, of Sherborne, husbandman, executors of 0
3998928 2024375 2024375 defendant Wase Robert yeoman 619663 619663 Wase, Robert, of Sherborne, yeoman 0
3998930 2024375 2024375 defendant Coke William clothworker 619663 619663 Coke, William, of Sherborne, clothworker 2
3999664 2024642 2024642 defendant Syms alias Lodge alias Yates Thomas shoemaker 619663 619663 Syms alias Lodge alias Yates, Thomas, of Sherborne, shoemaker 0
4002890 2025803 2025803 defendant Dyer Richard butcher 619663 619663 Dyer, Richard, of Sherborne, butcher 1
4002892 2025804 2025804 defendant Hull William butcher 619663 619663 Hull, William, of Sherborne, butcher 0
4003749 2026108 2026108 defendant Parswell Henry weaver 619663 619663 Parswell, Henry, of Sherborne, weaver 1
4003750 2026108 2026108 defendant Brock John tailor 619663 619663 Brock, John, of Sherborne, tailor 2
4003977 2026193 2026193 plaintiff Hutchyns Robert shoemaker 619663 619663 Hutchyns, Robert, of Sherborne, shoemaker 0
4005393 2026711 2026711 defendant Robert alias Woodale Richard yeoman 619663 619663 Robert alias Woodale, Richard, of Sherborne, yeoman 0
4016251 2030511 2030511 defendant Ledge alias Symes John husbandman 619663 619663 Ledge alias Symes, John, of Sherborne, husbandman 0
4018225 2031243 2031243 defendant Phylyps or Phelps John butcher 619663 619663 Phylyps or Phelps, John, of Sherborne, butcher 0
4018226 2031243 2031243 defendant Buller Thomas carpenter 619663 619663 Buller, Thomas, of Sherborne, carpenter 1
4030007 2035377 2035377 defendant Jenyng Robert shoemaker 619663 619663 Jenyng, Robert, of Sherborne, shoemaker 0
4030049 2035393 2035393 defendant Newman Richard husbandman 619663 619663 Newman, Richard, of Sherborne, husbandman 0
4033372 2036587 2036587 defendant Wase Robert yeoman 619663 619663 Wase, Robert, of Sherborne, yeoman 0
4033373 2036587 2036587 defendant Barnard William   619663 619663 Barnard, William, of Sherborne, parchment maker 1
4034025 2036825 2036825 defendant Newman John husbandman 619663 619663 Newman, John, of Sherborne, husbandman 0
4047500 2041559 2041559 plaintiff Stevens alias Tomes William haberdasher 619663 619663 Stevens alias Tomes, William, of Sherborne, haberdasher 0
4062459 2046864 2046864 defendant Jennyng Robert innholder 619663 619663 Jennyng, Robert, of Sherborne, innholder 0
4062461 2046865 2046865 defendant Jennynges Robert innholder 619663 619663 Jennynges, Robert, of Sherborne, innholder 0
4063972 2047395 2047395 plaintiff Stebens John, junior merchant 619663 619663 Stebens, John, junior, of Sherborne, merchant 1
4065426 2047926 2047926 defendant Knyght Walter husbandman 619663 619663 Knyght, Walter, of Sherborne, husbandman 0
4066037 2048141 2048141 defendant Wasse Robert yeoman 619663 619663 Wasse, Robert, of Sherborne, yeoman 0
4067665 2048748 2048748 defendant Rede John draper 619663 619663 Rede, John, of Sherborne, draper 0
4068334 2048974 2048974 defendant Hillary Thomas   619663 619663 Hillary, Thomas, of Sherborne, parchment maker 0
4069923 2049524 2049524 defendant Morrett John yeoman 619663 619663 Morrett, John, of Sherborne, yeoman 0
4073598 2050847 2050847 plaintiff Pope Richard draper 619663 619663 Pope, Richard, of Sherborne, draper 0
4073600 2050848 2050848 plaintiff Pope Richard   619663 619663 Pope, Richard, of Sherborne, woollen draper 0
4073602 2050849 2050849 plaintiff Pope Richard   619663 619663 Pope, Richard, of Sherborne, woollen draper 0
4081646 2053738 2053738 defendant Reade John   619663 619663 Reade, John, of Sherborne, woollen draper 0
4086207 2055341 2055341 defendant Wynnyff John yeoman 619663 619663 Wynnyff, John, of Sherborne, yeoman 0
4086830 2055582 2055582 defendant Denham Richard husbandman 619663 619663 Denham, Richard, of Sherborne, husbandman 0
4086831 2055582 2055582 defendant Denham Anthony   619663 619663 Denham, Anthony, of Sherborne, husbandman, his son 1
4090689 2056959 2056959 defendant Clench Robert husbandman 619663 619663 Clench, Robert, of Sherborne, or of Rympton, Soms, husbandman 0
4090690 2056959 2056959 defendant Hacker John husbandman 619663 619663 Hacker, John, of Sherborne, or of Brode Merston, Soms, husbandman 1
4096251 2058987 2058987 defendant Standishe John tailor 619663 619663 Standishe, John, of Sherborne, tailor 0
4097985 2059608 2059608 defendant Matherer John yeoman 619663 619663 Matherer, John, of Sherborne, yeoman 0
4097986 2059608 2059608 defendant Matherer Ralph yeoman 619663 619663 Matherer, Ralph, of Sherborne, yeoman 1
4097987 2059608 2059608 defendant Barnebowe John yeoman 619663 619663 Barnebowe, John, of Sherborne, yeoman 2
4098909 2059937 2059937 defendant Morrett John yeoman 619663 619663 Morrett, John, of Sherborne, yeoman 0
4101177 2060730 2060730 defendant Pytt Humphrey yeoman 619663 619663 Pytt, Humphrey, of Sherborne, yeoman 0
4108937 2063451 2063451 defendant Barkeston Edward, senior gent 619663 619663 Barkeston, Edward, senior, of Sherborne, gent 1
4110479 2064010 2064010 defendant Plympton Robert haberdasher 619663 619663 Plympton, Robert, of Sherborne, haberdasher 0
4110598 2064048 2064048 defendant Meryett John yeoman 619663 619663 Meryett, John, of Sherborne, yeoman 5
4111478 2064351 2064351 defendant Morrett John yeoman 619663 619663 Morrett, John, of Sherborne, yeoman 5
4114514 2065479 2065479 defendant Morrett John yeoman 619663 619663 Morrett, John, of Sherborne, yeoman 0
4118676 2066973 2066973 defendant Colmer William tailor 619663 619663 Colmer, William, of Sherborne, tailor 2
4119333 2067209 2067209 defendant Bockyng Brice husbandman 619663 619663 Bockyng, Brice, of Sherborne, husbandman 1
4119371 2067221 2067221 defendant Sydenham alias Codd Christopher gent 619663 619663 Sydenham alias Codd, Christopher, of Sherborne, gent 1
4123370 2068660 2068660 defendant Dunham Anthony husbandman 619663 619663 Dunham, Anthony, of Sherborne, husbandman 0
4123371 2068660 2068660 defendant Dunham John husbandman 619663 619663 Dunham, John, of Sherborne, husbandman 1
4135238 2072922 2072922 defendant Androes alias Ostler John innholder 619663 619663 Androes alias Ostler, John, of Sherborne, innholder 0
4136430 2073371 2073371 defendant Vyall alias Harrys Francis husbandman 619663 619663 Vyall alias Harrys, Francis, of Sherborne, husbandman 0
4141252 2075101 2075101 defendant Beley Robert husbandman 619663 619663 Beley, Robert, of Sherborne, husbandman 1
4147353 2077213 2077213 defendant Wheler William tailor 619663 619663 Wheler, William, of Sherborne, tailor 0
4149339 2077894 2077894 defendant Goodemowe Abraham shoemaker 619663 619663 Goodemowe, Abraham, of Sherborne, shoemaker 1
4149340 2077894 2077894 defendant Marshe Giles fletcher 619663 619663 Marshe, Giles, of Sherborne, fletcher 2
4149341 2077894 2077894 defendant Dowle Stephen shoemaker 619663 619663 Dowle, Stephen, of Sherborne, shoemaker 3
4151057 2078499 2078499 defendant Wheler William tailor 619663 619663 Wheler, William, of Sherborne, tailor 0
4152153 2078863 2078863 defendant Same Edward husbandman 619663 619663 Same, Edward, of Sherborne, husbandman 0
4152154 2078863 2078863 defendant Neale Jervase yeoman 619663 619663 Neale, Jervase, of Sherborne, yeoman 1
4152155 2078863 2078863 defendant Dayer Richard yeoman 619663 619663 Dayer, Richard, of Sherborne, yeoman 2
4156995 2080527 2080527 defendant Cole Brian merchant 619663 619663 Cole, Brian, of Sherborne, or of Isle of Wight, Hants, merchant 0
4158008 2080872 2080872 defendant Okeley John cordwainer 619663 619663 Okeley, John, of Sherborne, cordwainer 0
4160747 2081837 2081837 defendant Vyall alias Harris Francis husbandman 619663 619663 Vyall alias Harris, Francis, of Sherborne, husbandman 0
4160750 2081837 2081837 defendant Vyall alias Harris Francis   619663 619663 Vyall alias Harris, Francis, of Sherborne, husbandman, son of John 3
4161458 2082084 2082084 defendant Sydenham Christopher gent 619663 619663 Sydenham, Christopher, of Sherborne, or of Edington, gent 0
4163810 2082868 2082868 defendant Hemsworthe Thomas gent 619663 619663 Hemsworthe, Thomas, of Sherborne, gent 1
4176070 2087106 2087106 defendant Mere John gent 619663 619663 Mere, John, of Sherborne, or of Inner Temple, London, gent 0
4188099 2091339 2091339 defendant Martyne John yeoman 619663 619663 Martyne, John, of Sherborne, yeoman 1
4192643 2092984 2092984 defendant Bruer alias Moore George merchant 619663 619663 Bruer alias Moore, George, of Sherborne, merchant 0
4193204 2093192 2093192 defendant Hillarie Robert   619663 619663 Hillarie, Robert, of Sherborne, parchment maker 1
4195436 2093949 2093949 defendant Sheppard alias Forest William victualer 619663 619663 Sheppard alias Forest, William, of Sherborne, butcher, victualer 0
4195438 2093949 2093949 defendant Chipley John yeoman 619663 619663 Chipley, John, of Sherborne, yeoman 2
4199385 2095336 2095336 defendant Mere John gent 619663 619663 Mere, John, of Sherborne, or of Inner Temple, London, gent 0
4204716 2097195 2097195 defendant Jeanes Joan widow 619663 619663 Jeanes, Joan, of Sherborne, widow 4
4204720 2097196 2097196 defendant Hanley Henry fishmerman 619663 619663 Hanley, Henry, of Sherborne, fishmerman 2
4208766 2098613 2098613 defendant Sydenham Christopher gent 619663 619663 Sydenham, Christopher, of Sherborne, gent 0
4209970 2099050 2099050 defendant Chamberlyn Richard miller 619663 619663 Chamberlyn, Richard, of Sherborne, or of Wicke, Soms, miller 1
4210381 2099190 2099190 defendant Ingleberd or Engelberd Nicholas gent 619663 619663 Ingleberd or Engelberd, Nicholas, of Sherborne, gent 0
4210382 2099190 2099190 defendant Engelberd John gent 619663 619663 Engelberd, John, of Sherborne, gent 1
4210383 2099190 2099190 defendant Engelberd Hugh gent 619663 619663 Engelberd, Hugh, of Sherborne, gent 2

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