names

63 rows where place_id = 600392

✎ 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
3640859 1907585 1907585 defendant London John husbandman 600392 600392 London, John, of Sherborne, Dorset, husbandman 2
3707271 1928563 1928563 defendant Ley Richard skinner 600392 600392 Ley, Richard, of Sherborne, Dorset, skinner 0
3707275 1928564 1928564 defendant Ley Richard skinner 600392 600392 Ley, Richard, of Sherborne, Dorset, skinner 0
3844026 1971674 1971674 defendant Moren John tailor 600392 600392 Moren, John, of Sherborne, Dorset, tailor 4
3859350 1976619 1976619 defendant Bowman Robert yeoman 600392 600392 Bowman, Robert, of Sherborne, Dorset, yeoman 4
3859360 1976622 1976622 defendant Bowman Robert yeoman 600392 600392 Bowman, Robert, of Sherborne, Dorset, yeoman 4
3872159 1980920 1980920 defendant Bucbrege William yeoman 600392 600392 Bucbrege, William, of Sherborne, Dorset, yeoman 0
3872161 1980921 1980921 defendant Bucbrege William yeoman 600392 600392 Bucbrege,William, of Sherborne, Dorset, yeoman 0
3919990 1997025 1997025 defendant Yngelberd Nicholas chapman 600392 600392 Yngelberd, Nicholas, of Sherborne, Dorset, chapman 0
3955610 2009035 2009035 plaintiff Meare or Mayor William (legal representative) 600392 600392 Meare or Mayor, William, of Sherborne, Dorset, yeoman, executrix of 0
3955613 2009036 2009036 plaintiff Meare William (legal representative) 600392 600392 Meare, William, of Sherborne, Dorset, draper, gent, executrix of 0
3968429 2013591 2013591 defendant Dalaber Anthony gent 600392 600392 Dalaber, Anthony, of Sherborne, Dorset, gent 1
3968432 2013592 2013592 defendant Dalaber Anthony gent 600392 600392 Dalaber, Anthony, of Sherborne, Dorset, gent 1
3998920 2024373 2024373 defendant Ingleberd Hugh gent 600392 600392 Ingleberd, Hugh, of Sherborne, Dorset, gent 0
4003978 2026193 2026193 defendant Fraunces Richard shoemaker 600392 600392 Fraunces, Richard, of Sherborne, Dorset, shoemaker 0
4003980 2026194 2026194 defendant Fraunces Richard shoemaker 600392 600392 Fraunces, Richard, of Sherborne, Dorset, shoemaker 0
4006755 2027194 2027194 plaintiff Wyneff John gent 600392 600392 Wyneff, John, of Sherborne, Dorset, gent 1
4009871 2028306 2028306 defendant Engleberd Nicholas yeoman 600392 600392 Engleberd, Nicholas, of Sherborne, Dorset, yeoman 0
4017798 2031077 2031077 defendant Rede John draper 600392 600392 Rede, John, of Sherborne, Dorset, draper 0
4017801 2031078 2031078 defendant Rede John draper 600392 600392 Rede, John, of Sherborne, Dorset, draper 0
4018460 2031335 2031335 defendant Asheley Gervase gent 600392 600392 Asheley, Gervase, of Sherborne, Dorset, gent 2
4024392 2033402 2033402 defendant Barton Thomas draper 600392 600392 Barton, Thomas, of Sherborne, Dorset, draper 0
4058287 2045349 2045349 defendant Chafyn Thomas esq 600392 600392 Chafyn, Thomas, of Sherborne, Dorset, esq 0
4065459 2047936 2047936 defendant Wynnyff John gent 600392 600392 Wynnyff, John, of Sherborne, Dorset, gent 0
4066109 2048167 2048167 defendant Jones Nicholas innholder 600392 600392 Jones, Nicholas, of Sherborne, Dorset, innholder 0
4096018 2058906 2058906 defendant Ingleberde Anne widow 600392 600392 Ingleberde, Anne, of Sherborne, Dorset, widow 0
4098419 2059762 2059762 defendant Rawlinges Henry yeoman 600392 600392 Rawlinges, Henry, of Sherborne, Dorset, yeoman 2
4107703 2063030 2063030 defendant Yetman John victualer 600392 600392 Yetman, John, of Sherborne, Dorset, yeoman, victualer 0
4109627 2063701 2063701 defendant Standich John tailor 600392 600392 Standich, John, of Sherborne, Dorset, tailor 1
4113956 2065274 2065274 defendant Wase Robert husbandman 600392 600392 Wase, Robert, of Sherborne, Dorset, husbandman 0
4117549 2066573 2066573 defendant Yonge William gent 600392 600392 Yonge, William, of Sherborne, Dorset, gent 1
4125187 2069295 2069295 defendant Cole Brian merchant 600392 600392 Cole, Brian, of Sherborne, Dorset, or of Newporte, Isle of Wight, merchant 0
4125191 2069297 2069297 defendant Wyniffe or Wynisse John gent 600392 600392 Wyniffe or Wynisse, John, of Sherborne, Dorset, gent 0
4145848 2076702 2076702 defendant More George merchant 600392 600392 More, George, of Sherborne, Dorset, merchant 0
4160897 2081883 2081883 defendant Stone Philip tailor 600392 600392 Stone, Philip, of Sherborne, Dorset, tailor 0
4161063 2081945 2081945 defendant Chaplyn alias Reynold Henry husbandman 600392 600392 Chaplyn alias Reynold, Henry, of Sherborne, Dorset, husbandman 0
4181866 2089137 2089137 defendant Cole Brian gent 600392 600392 Cole, Brian, of Sherborne, Dorset, gent 0
4193203 2093192 2093192 defendant Hillarie Thomas yeoman 600392 600392 Hillarie, Thomas, of Sherborne, Dorset, yeoman 0
4206406 2097783 2097783 defendant Downeham Anthony husbandman 600392 600392 Downeham, Anthony, of Sherborne, Dorset, husbandman 0
4210444 2099211 2099211 defendant Sydenham alias Codde Christopher gent 600392 600392 Sydenham alias Codde, Christopher, of Sherborne, Dorset, gent 2
4211089 2099434 2099434 defendant Wynnyffe John gent 600392 600392 Wynnyffe, John, of Sherborne, Dorset, gent 0
4286171 2125107 2125107 defendant Raleighe Walter   600392 600392 Raleighe, Walter, of Sherborne, Dorset, knight 0
4291130 2126894 2126894 defendant Philipps John   600392 600392 Philipps, John, of Sherborne, Dorset, mason 3
4296742 2128932 2128932 defendant Pope Richard yeoman 600392 600392 Pope, Richard, of Sherborne, Dorset, yeoman 0
4299772 2130003 2130003 defendant Taylor Adam yeoman 600392 600392 Taylor, Adam, of Sherborne, Dorset, yeoman 0
4302917 2131142 2131142 defendant Pownser Motleys or Motley husbandman 600392 600392 Pownser, Motleys or Motley, of Sherborne, Dorset, husbandman 2
4324877 2138705 2138705 defendant Thorne John draper 600392 600392 Thorne, John, of Sherborne, Dorset, draper 0
4332494 2141156 2141156 defendant Yetman John yeoman 600392 600392 Yetman, John, of Sherborne, Dorset, yeoman 0
4332992 2141320 2141320 defendant Starre William dyer 600392 600392 Starre, William, of Sherborne, Dorset, dyer 0
4355239 2149053 2149053 defendant Star William dyer 600392 600392 Star, William, of Sherborne, Dorset, dyer 0
4368071 2153635 2153635 defendant Dolberye Robert gent 600392 600392 Dolberye, Robert, of Sherborne, Dorset, gent 0
4375375 2156247 2156247 defendant Taverner Thomas clothworker 600392 600392 Taverner, Thomas, of Sherborne, Dorset, clothworker 1
4386291 2160092 2160092 defendant Meere John gent 600392 600392 Meere, John, of Sherborne, Dorset, gent 0
4399751 2164504 2164504 defendant Taverner Thomas clothworker 600392 600392 Taverner, Thomas, of Sherborne, Dorset, yeoman, or of London, clothworker 0
4401872 2165223 2165223 defendant Owlde Bartholomew chapman 600392 600392 Owlde, Bartholomew, of Sherborne, Dorset, chapman 1
4401873 2165223 2165223 defendant Cowthe Richard chapman 600392 600392 Cowthe, Richard, of Sherborne, Dorset, chapman 2
4408387 2167379 2167379 defendant Tucker John yeoman 600392 600392 Tucker, John, of Sherborne, Dorset, yeoman 0
4412750 2168858 2168858 defendant Stevens Henry chapman 600392 600392 Stevens, Henry, of Sherborne, Dorset, chapman 0
5014851 2361221 2361221 defendant Parche John chapman 600392 600392 Parche, John, of Sherborne, Dorset, chapman 1
5156653 2403101 2403101 defendant Sherborne alias Ilberd John gent 600392 600392 Sherborne alias Ilberd, John, of Sherborne, Dorset, gent 1
5172778 2407769 2407769 defendant Ilberd John gent 600392 600392 Ilberd, John, of Sherborne, Dorset, gent 1
5192589 2413565 2413565 defendant Sherborne alias Ilberd John gent 600392 600392 Sherborne alias Ilberd, John, of Sherborne, Dorset, gent 1
5489965 2501887 2501887 defendant Furcke Elias chapman 600392 600392 Furcke, Elias, of Sherborne, Dorset, chapman 1

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