names

401 rows where place_id = 588645

✎ 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
3595145 1866113 1866113 plaintiff Malburgh John gent 588645 588645 Malburgh, John, of Clare, gent 0
3595146 1866113 1866113 defendant Hawe Robert butcher 588645 588645 Hawe, Robert, of Clare, butcher 0
3623643 1874927 1874927 defendant Kelyng William mercer 588645 588645 Kelyng, William, of Clare, mercer 0
3625973 1902981 1902981 defendant Barker William yeoman 588645 588645 Barker, William, of Clare, yeoman 0
3631439 1904645 1904645 defendant Barker John clothmaker 588645 588645 Barker, John, of Clare, clothmaker 0
3633577 1905313 1905313 defendant Nanson John barber 588645 588645 Nanson, John, of Clare, barber 0
3634857 1905701 1905701 defendant Barker William husbandman 588645 588645 Barker, William, of Clare, husbandman 0
3636483 1906204 1906204 defendant Gardiner John chaplain 588645 588645 Gardiner, John, of Clare, chaplain 0
3649316 1910177 1910177 defendant Ranenes Richard butcher 588645 588645 Ranenes, Richard, of Clare, butcher 0
3658118 1912796 1912796 defendant Stoke Hugh husbandman 588645 588645 Stoke, Hugh, of Clare, husbandman 2
3658730 1912983 1912983 defendant Gylbert John weaver 588645 588645 Gylbert, John, of Clare, weaver 0
3661466 1913857 1913857 defendant Danyell Hugh gent 588645 588645 Danyell, Hugh, of Clare, gent 0
3674284 1918001 1918001 plaintiff Gilbert John (legal representative) 588645 588645 Gilbert, John, of Clare, executrix of 0
3674397 1918037 1918037 defendant Rust Robert tanner 588645 588645 Rust, Robert, of Clare, tanner 0
3674398 1918037 1918037 defendant Bere John smith 588645 588645 Bere, John, of Clare, smith 1
3674399 1918037 1918037 defendant Ven Henry fuller 588645 588645 Ven, Henry, of Clare, fuller 2
3685599 1921648 1921648 defendant Skynner William fuller 588645 588645 Skynner, William, of Clare, fuller 4
3689530 1922879 1922879 defendant Gylbert William yeoman 588645 588645 Gylbert, William, of Clare, yeoman 0
3694207 1924391 1924391 defendant Woder George fuller 588645 588645 Woder, George, of Clare, fuller 5
3695666 1924876 1924876 defendant Skynner William clothman 588645 588645 Skynner, William, of Clare, clothman 2
3695671 1924877 1924877 defendant Skynner William shoemaker 588645 588645 Skynner, William, of Clare, shoemaker 2
3697860 1925552 1925552 defendant Keteryche William smith 588645 588645 Keteryche, William, of Clare, smith 0
3698560 1925767 1925767 defendant Barker John husbandman 588645 588645 Barker, John, of Clare, husbandman 0
3704107 1927573 1927573 defendant Gilbert William yeoman 588645 588645 Gilbert, William, of Clare, yeoman 0
3706086 1928195 1928195 defendant Gylbert Joan widow 588645 588645 Gylbert, Joan, of Clare, widow 3
3707707 1928706 1928706 plaintiff Marten John, junior   588645 588645 Marten, John, junior, of Clare 0
3707708 1928706 1928706 defendant Myller John yeoman 588645 588645 Myller, John, of Clare, yeoman 0
3708220 1928865 1928865 defendant Woder George fuller 588645 588645 Woder, George, of Clare, fuller 0
3711641 1929952 1929952 defendant Keteryche William smith 588645 588645 Keteryche, William, of Clare, smith 0
3718903 1932191 1932191 defendant Miller John yeoman 588645 588645 Miller, John, of Clare, yeoman 0
3718907 1932193 1932193 defendant Skynner William fuller 588645 588645 Skynner, William, of Clare, fuller 0
3724274 1933879 1933879 defendant Barker John husbandman 588645 588645 Barker, John, of Clare, husbandman 3
3725288 1934201 1934201 defendant Fen Henry clothman 588645 588645 Fen, Henry, of Clare, clothman 1
3734601 1937069 1937069 defendant Miller John yeoman 588645 588645 Miller, John, of Clare, yeoman 0
3757259 1944253 1944253 defendant Gylbert John (legal representative) 588645 588645 Gylbert, John, of Clare, husbandman, executors of 0
3760640 1945328 1945328 defendant Horrolde Thomas clothmaker 588645 588645 Horrolde, Thomas, of Clare, clothmaker 0
3763540 1946231 1946231 plaintiff Whatlok George   588645 588645 Whatlok, George, of Clare 3
3764144 1946435 1946435 defendant Hogge James clothmaker 588645 588645 Hogge, James, of Clare, clothmaker 0
3764485 1946555 1946555 defendant Lambe Rose widow 588645 588645 Lambe, Rose, of Clare, widow 1
3770581 1948483 1948483 defendant Fen Henry miller 588645 588645 Fen, Henry, of Clare, miller 0
3795625 1956516 1956516 defendant Gybberd or Gylberd William clothmaker 588645 588645 Gybberd or Gylberd, William, of Clare, clothmaker 0
3795626 1956516 1956516 defendant Colyn Edmund laborer 588645 588645 Colyn, Edmund, of Clare, laborer 1
3795627 1956516 1956516 defendant Carleton John fuller 588645 588645 Carleton, John, of Clare, fuller 2
3795633 1956517 1956517 defendant Wooder George sherman 588645 588645 Wooder, George, of Clare, sherman 2
3797510 1957113 1957113 defendant Lambard John shoemaker 588645 588645 Lambard, John, of Clare, shoemaker 2
3799185 1957655 1957655 defendant Pottowe Thomas butcher 588645 588645 Pottowe, Thomas, of Clare, butcher 1
3806268 1959880 1959880 defendant Myller John mercer 588645 588645 Myller, John, of Clare, mercer 0
3812402 1961769 1961769 defendant Jervys William weaver 588645 588645 Jervys, William, of Clare, weaver 3
3816130 1962948 1962948 defendant Stephyn John smith 588645 588645 Stephyn, John, of Clare, smith 0
3832623 1968129 1968129 defendant Fentforth Thomas tiler 588645 588645 Fentforth, Thomas, of Clare, tiler 1
3836239 1969247 1969247 defendant Awoode William husbandman 588645 588645 Awoode, William, of Clare, husbandman 0
3836240 1969247 1969247 defendant Hawke William husbandman 588645 588645 Hawke, William, of Clare, husbandman 1
3836241 1969247 1969247 defendant Brown William husbandman 588645 588645 Brown, William, of Clare, husbandman 2
3844469 1971816 1971816 defendant Kytteryche Robert butcher 588645 588645 Kytteryche, Robert, of Clare, butcher 2
3853826 1974829 1974829 defendant Davy William cordwainer 588645 588645 Davy, William, of Clare, cordwainer 1
3857598 1976010 1976010 plaintiff Bacon John   588645 588645 Bacon, John, of Clare 0
3860379 1976967 1976967 defendant Kytterych William smith 588645 588645 Kytterych, William, of Clare, smith 1
3862332 1977590 1977590 plaintiff Gylberd William clothmaker 588645 588645 Gylberd, William, of Clare, clothmaker 0
3872798 1981114 1981114 defendant Carleton John carpenter 588645 588645 Carleton, John, of Clare, carpenter 0
3872799 1981114 1981114 defendant Norffolke John   588645 588645 Norffolke, John, of Clare, tallow chandler 1
3874615 1981730 1981730 defendant Hokett Richard caryer 588645 588645 Hokett, Richard, of Clare, caryer 0
3874707 1981757 1981757 defendant Gilbert William clothier 588645 588645 Gilbert, William, of Clare, clothier 0
3874708 1981757 1981757 defendant Payne Robert laborer 588645 588645 Payne, Robert, of Clare, laborer 1
3874709 1981757 1981757 defendant Norman Christopher laborer 588645 588645 Norman, Christopher, of Clare, laborer 2
3874785 1981785 1981785 defendant Stevyn John smith 588645 588645 Stevyn, John, of Clare, smith 2
3875946 1982208 1982208 defendant Danyell William gent 588645 588645 Danyell, William, of Clare, gent 1
3875947 1982208 1982208 defendant Danyell Robert gent 588645 588645 Danyell, Robert, of Clare, gent 2
3875948 1982208 1982208 defendant Robynson James laborer 588645 588645 Robynson, James, of Clare, laborer 3
3875949 1982208 1982208 defendant Luke John laborer 588645 588645 Luke, John, of Clare, laborer 4
3875950 1982208 1982208 defendant Braser Robert yeoman 588645 588645 Braser, Robert, of Clare, yeoman 5
3875951 1982208 1982208 defendant Gyblon William laborer 588645 588645 Gyblon, William, of Clare, laborer 6
3875952 1982208 1982208 defendant Everard Thomas laborer 588645 588645 Everard, Thomas, of Clare, laborer 7
3876733 1982460 1982460 defendant Stevyns John smith 588645 588645 Stevyns, John, of Clare, smith 0
3887901 1986202 1986202 defendant Meton John clerk 588645 588645 Meton, John, of Clare, clerk 0
3895258 1988621 1988621 defendant Flowre John grocer 588645 588645 Flowre, John, of Clare, grocer 0
3901871 1990850 1990850 defendant Meton John clerk 588645 588645 Meton, John, of Clare, clerk 0
3904769 1991854 1991854 defendant Flower John grocer 588645 588645 Flower, John, of Clare, grocer 0
3911630 1994212 1994212 plaintiff Whatlok Margaret widow 588645 588645 Whatlok, Margaret, of Clare, widow 0
3911631 1994212 1994212 defendant Holborough William clothier 588645 588645 Holborough, William, of Clare, clothier 0
3913142 1994729 1994729 defendant Gylberd William clothmaker 588645 588645 Gylberd, William, of Clare, clothmaker 0
3914045 1995041 1995041 defendant Bacon Clement clothier 588645 588645 Bacon, Clement, of Clare, clothier 1
3919178 1996741 1996741 defendant Barker William clothmaker 588645 588645 Barker, William, of Clare, clothmaker 1
3921699 1997599 1997599 defendant Potto John butcher 588645 588645 Potto, John, of Clare, butcher 1
3950642 2007298 2007298 defendant Fysher Richard gent or tallow chandler 588645 588645 Fysher, Richard, of Clare, gent or tallow chandler 0
3988755 2020725 2020725 defendant Smyth Geoffrey tailor 588645 588645 Smyth, Geoffrey, of Clare, tailor 0
3998439 2024179 2024179 defendant Hardye Thomas sherman 588645 588645 Hardye, Thomas, of Clare, sherman 2
3999274 2024497 2024497 plaintiff Fryer John, junior   588645 588645 Fryer, John, junior, of Clare 0
3999275 2024497 2024497 defendant Fryer William gent 588645 588645 Fryer, William, of Clare, gent 0
3999276 2024498 2024498 plaintiff Fryer John, junior   588645 588645 Fryer, John, junior, of Clare 0
3999277 2024498 2024498 defendant Fryer William gent 588645 588645 Fryer, William, of Clare, gent 0
4005612 2026783 2026783 defendant Fen John yeoman 588645 588645 Fen, John, of Clare, yeoman 0
4009695 2028235 2028235 defendant Lambert Richard shoemaker 588645 588645 Lambert, Richard, of Clare, shoemaker 0
4045969 2041004 2041004 defendant Harrise Thomas miller 588645 588645 Harrise, Thomas, of Clare, miller 2
4064981 2047760 2047760 defendant Harvye Robert yeoman 588645 588645 Harvye, Robert, of Clare, yeoman 0
4072637 2050518 2050518 defendant Parmeter Thomas yeoman 588645 588645 Parmeter, Thomas, of Clare, yeoman 1
4094991 2058538 2058538 defendant Slograve John innholder 588645 588645 Slograve, John, of Clare, innholder 0
4118144 2066773 2066773 defendant Sadlington Thomas, junior yeoman 588645 588645 Sadlington, Thomas, junior, of Clare, yeoman 0
4118153 2066776 2066776 defendant Sheldrake William yeoman 588645 588645 Sheldrake, William, of Clare, yeoman 1
4119124 2067130 2067130 defendant Cadge John butcher 588645 588645 Cadge, John, of Clare, butcher 0
4127670 2070188 2070188 defendant Cadge John butcher 588645 588645 Cadge, John, of Clare, butcher 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);