names

175 rows where place_id = 598185

✎ 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
3631480 1904660 1904660 defendant Chapell Elizabeth widow 598185 598185 Chapell, Elizabeth, of Charde, widow 1
3642986 1908255 1908255 defendant Alston Thomas chapman 598185 598185 Alston, Thomas, of Charde, chapman 0
3648014 1909780 1909780 defendant Cutteler Richard merchant 598185 598185 Cutteler, Richard, of Charde, merchant 0
3683423 1920939 1920939 defendant Ivery John, junior baker 598185 598185 Ivery, John, junior, of Charde, baker 1
3695210 1924722 1924722 defendant Pollard John tailor 598185 598185 Pollard, John, of Charde, tailor 1
3698664 1925799 1925799 defendant Whitthorne William dyer 598185 598185 Whitthorne, William, of Charde, dyer 1
3717757 1931855 1931855 defendant Drake Richard yeoman 598185 598185 Drake, Richard, of Charde, yeoman 1
3720529 1932702 1932702 defendant Jefferey John baker 598185 598185 Jefferey, John, of Charde, baker 1
3725421 1934246 1934246 defendant Cogan Nicholas pinner 598185 598185 Cogan, Nicholas, of Charde, pinner 0
3727796 1934962 1934962 defendant Bruer John merchant 598185 598185 Bruer, John, of Charde, merchant 1
3736311 1937598 1937598 defendant Whythorne William dyer 598185 598185 Whythorne, William, of Charde, dyer 0
3736312 1937598 1937598 defendant Symmes John yeoman 598185 598185 Symmes, John, of Charde, yeoman 1
3741370 1939170 1939170 defendant Cogan Nicholas pinner 598185 598185 Cogan, Nicholas, of Charde, pinner 0
3745264 1940427 1940427 defendant Cogan Hugh mercer 598185 598185 Cogan, Hugh, of Charde, mercer 0
3745265 1940427 1940427 defendant Walshe Thomas baker 598185 598185 Walshe, Thomas, of Charde, baker 1
3767651 1947521 1947521 defendant Appoyll Robert husbandman 598185 598185 Appoyll, Robert, of Charde, husbandman 0
3767652 1947521 1947521 defendant Drake Richard yeoman 598185 598185 Drake, Richard, of Charde, yeoman 1
3767653 1947521 1947521 defendant Ivery John baker 598185 598185 Ivery, John, of Charde, baker 2
3768614 1947832 1947832 defendant Polard John tailor 598185 598185 Polard, John, of Charde, tailor 3
3772013 1948939 1948939 defendant Cogan Nicholas mercer 598185 598185 Cogan, Nicholas, of Charde, mercer 0
3780516 1951635 1951635 defendant Juggeler Thomas dyer 598185 598185 Juggeler, Thomas, of Charde, dyer 0
3838339 1969910 1969910 plaintiff Toker Richard   598185 598185 Toker, Richard, of Charde 0
3840059 1970460 1970460 defendant Kerver Joan widow 598185 598185 Kerver, Joan, of Charde, widow 0
3866022 1978868 1978868 defendant Legge John tanner 598185 598185 Legge, John, of Charde, tanner 0
3880329 1983676 1983676 defendant Ivery John baker 598185 598185 Ivery, John, of Charde, baker 0
3880330 1983676 1983676 defendant Pollard John tailor 598185 598185 Pollard, John, of Charde, tailor 1
3882687 1984476 1984476 plaintiff Toker Richard   598185 598185 Toker, Richard, of Charde 0
3906522 1992474 1992474 defendant Peter Robert yeoman 598185 598185 Peter, Robert, of Charde, yeoman 0
3908770 1993228 1993228 defendant Kyche John miller 598185 598185 Kyche, John, of Charde, miller 0
3914935 1995345 1995345 plaintiff Cogeyn Richard mercer 598185 598185 Cogeyn, Richard, of Charde, mercer 0
3922375 1997800 1997800 defendant Clapp Nicholas clothier 598185 598185 Clapp, Nicholas, of Charde, clothier 1
3927229 1999443 1999443 defendant Clappe Nicholas clothier 598185 598185 Clappe, Nicholas, of Charde, clothier 0
3929658 2000270 2000270 defendant Peter Robert mercer 598185 598185 Peter, Robert, of Charde, mercer 0
3929659 2000270 2000270 defendant Cleppe Nicholas merchant 598185 598185 Cleppe, Nicholas, of Charde, merchant 1
3937947 2003024 2003024 defendant Whytehorne John clothier 598185 598185 Whytehorne, John, of Charde, clothier 0
3945969 2005669 2005669 defendant Payne John yeoman 598185 598185 Payne, John, of Charde, yeoman 0
3945970 2005670 2005670 plaintiff Bruer Thomas merchant 598185 598185 Bruer, Thomas, of Charde, merchant 0
3945971 2005670 2005670 plaintiff Mychell Richard merchant 598185 598185 Mychell, Richard, of Charde, merchant 1
3953598 2008334 2008334 defendant Clepe Oliver chapman 598185 598185 Clepe, Oliver, of Charde, chapman 0
3961928 2011268 2011268 plaintiff Walrond Humphrey gent 598185 598185 Walrond, Humphrey, of Charde, gent 0
3963457 2011824 2011824 defendant Walrond Austa widow 598185 598185 Austa his wife, alias Austa Symes, of Charde, widow 1
3968849 2013734 2013734 plaintiff Cogan Thomas merchant 598185 598185 Cogan, Thomas, of Charde, merchant 0
3976496 2016356 2016356 plaintiff Kerforde Richard merchant 598185 598185 Kerforde, Richard, of Charde, merchant 0
3978580 2017086 2017086 plaintiff Michell Richard merchant 598185 598185 Michell, Richard, of Charde, merchant 0
3978583 2017087 2017087 plaintiff Michell Richard merchant 598185 598185 Michell, Richard, of Charde, merchant 0
3980241 2017699 2017699 plaintiff Peell Thomas innholder 598185 598185 Peell, Thomas, of Charde, innholder 1
3983729 2018953 2018953 defendant Selwode Thomas merchant 598185 598185 Selwode, Thomas, of Charde, merchant 0
3983730 2018953 2018953 defendant Mantell John husbandman 598185 598185 together with Mantell, John, of Charde, husbandman 1
3985714 2019651 2019651 defendant Morren alias Pers William smith 598185 598185 Morren alias Pers, William, of Charde, smith 1
3994392 2022748 2022748 plaintiff Cogan Thomas merchant 598185 598185 Cogan, Thomas, of Charde, merchant 0
3994396 2022749 2022749 plaintiff Cogan Thomas merchant 598185 598185 Cogan, Thomas, of Charde, merchant 0
4000065 2024789 2024789 defendant Clapp Nicholas tucker 598185 598185 Clapp, Nicholas, of Charde, tucker 0
4003307 2025941 2025941 defendant Bagg Roger yeoman or victualer 598185 598185 Bagg, Roger, of Charde, or of Wensom, Soms, yeoman or victualer 0
4010790 2028636 2028636 defendant Bagge Roger innholder 598185 598185 Bagge, Roger, of Charde, innholder 0
4015562 2030262 2030262 defendant Brett Eleanor widow 598185 598185 Brett, Eleanor, of Charde, widow 0
4035790 2037473 2037473 defendant Bagg Roger yeoman or victualer 598185 598185 Bagg, Roger, of Charde, or of Wenson, Soms, yeoman or victualer 0
4047779 2041653 2041653 defendant Wyatt Walter miller 598185 598185 Wyatt, Walter, of Charde, miller 1
4047780 2041653 2041653 defendant Wyatt Thomas miller 598185 598185 Wyatt, Thomas, of Charde, miller 2
4049997 2042430 2042430 defendant Brewer alias Moore John merchant 598185 598185 Brewer alias Moore, John, of Charde, merchant 0
4049998 2042430 2042430 defendant Lawes Philip gent 598185 598185 Lawes, Philip, of Charde, gent 1
4057824 2045183 2045183 defendant Bagg Roger innholder 598185 598185 Bagg, Roger, of Charde, innholder 0
4059021 2045623 2045623 plaintiff Cogan Thomas clothier 598185 598185 Cogan, Thomas, of Charde, clothier 0
4059023 2045624 2045624 plaintiff Cogan Thomas mercer 598185 598185 Cogan, Thomas, of Charde, mercer 0
4059025 2045625 2045625 plaintiff Cogan Thomas merchant 598185 598185 Cogan, Thomas, of Charde, merchant 0
4060898 2046305 2046305 plaintiff Dighte John (legal representative) 598185 598185 Dighte, John, of Charde, merchant, executors of 0
4063154 2047121 2047121 defendant Pulman William merchant 598185 598185 Pulman, William, of Charde, merchant 0
4074939 2051337 2051337 defendant Stephens John sherman 598185 598185 Stephens, John, of Charde, sherman 1
4080267 2053253 2053253 defendant Mychell Richard merchant 598185 598185 Mychell, Richard, of Charde, merchant 0
4085305 2055024 2055024 defendant Atkyns Henry yeoman 598185 598185 Atkyns, Henry, of Charde, or of Brodwynsore, Dorset, yeoman 1
4086681 2055525 2055525 defendant Wythorne John clothier 598185 598185 Wythorne, John, of Charde, clothier 1
4088132 2056048 2056048 defendant Sprake John clothier 598185 598185 Sprake, John, of Charde, clothier 0
4089612 2056576 2056576 defendant Cotlle or Cortle Robert yeoman 598185 598185 Cotlle or Cortle, Robert, of Charde, yeoman 0
4089831 2056653 2056653 defendant Sprake John clothier 598185 598185 Sprake, John, of Charde, clothier 0
4089832 2056653 2056653 defendant Coggan John merchant 598185 598185 Coggan, John, of Charde, merchant 1
4089851 2056658 2056658 defendant Collyar John husbandman 598185 598185 Collyar, John, of Charde, or of Yearcombe, Devon, husbandman 0
4089852 2056658 2056658 defendant Smyth Robert smith 598185 598185 Smyth, Robert, of Charde, or of Yearcombe, smith 1
4092123 2057478 2057478 defendant Alstone John yeoman 598185 598185 Alstone, John, of Charde, yeoman 2
4092907 2057774 2057774 defendant Lanwarne Robert innholder 598185 598185 Lanwarne, Robert, of Charde, yeoman, or of Oxford, innholder 0
4092908 2057774 2057774 defendant Lanwarne John yeoman 598185 598185 Lanwarne, John, of Charde, or of Shaftesbury, Dorset, yeoman 1
4092909 2057774 2057774 defendant Chiverton Richard gent 598185 598185 Chiverton, Richard, of Charde, gent 2
4092910 2057774 2057774 defendant Broke David yeoman 598185 598185 Broke, David, of Charde, or of Donnott, Wilts, yeoman 3
4093427 2057966 2057966 defendant Balch Nicholas gent 598185 598185 Balch, Nicholas, of Charde, or of Horton, Ilmyster, gent 0
4096974 2059247 2059247 defendant Cogan Robert merchant 598185 598185 Cogan, Robert, of Charde, merchant 0
4096975 2059247 2059247 defendant Payne Henry barber 598185 598185 Payne, Henry, of Charde, barber 1
4096976 2059247 2059247 defendant Luff Thomas tucker 598185 598185 Luff, Thomas, of Charde, tucker 2
4099825 2060262 2060262 defendant Eton Hugh   598185 598185 Eton, Hugh, of Charde, yeoman, or of Salisbury, felt maker 0
4105368 2062201 2062201 defendant Raceson William husbandman 598185 598185 Raceson, William, of Charde, yeoman, or of Stoke under Hamdon, husbandman 0
4105369 2062201 2062201 defendant Axe John, senior widow 598185 598185 Axe, John, senior, of Charde, yeoman, or of Stoke, husbandman, son of Alice Axe, widow 1
4105370 2062201 2062201 defendant Cannon John, senior husbandman 598185 598185 Cannon, John, senior, of Charde, or of Bowre Benton, husbandman 2
4123515 2068714 2068714 defendant Samford Richard innholder or merchant 598185 598185 Samford, Richard, of Charde, innholder or merchant 0
4123581 2068735 2068735 defendant Fabyan John saddler 598185 598185 Fabyan, John, of Charde, or of Welles, saddler 0
4123583 2068736 2068736 defendant Fabyan John saddler 598185 598185 Fabyan, John, of Charde, or of Welles, Soms, saddler 0
4124869 2069187 2069187 defendant Marche Edward gent 598185 598185 Marche, Edward, of Charde, or of Knolle, Dorset, gent 0
4125205 2069301 2069301 defendant Bagge Roger innholder 598185 598185 Bagge, Roger, of Charde, innholder 1
4125339 2069347 2069347 defendant Coggan Walter chapman 598185 598185 Coggan, Walter, of Charde, chapman 0
4130705 2071291 2071291 defendant Sprake John clothier 598185 598185 Sprake, John, of Charde, clothier 2
4131534 2071597 2071597 defendant Marrock Robert yeoman 598185 598185 Marrock, Robert, of Charde, or of Yartcombe, Devon, yeoman 0
4131535 2071597 2071597 defendant Bagg Roger yeoman or innholder 598185 598185 Bagg, Roger, of Charde, yeoman or innholder 1
4131537 2071597 2071597 defendant Browninge Paul yeoman 598185 598185 Browninge, Paul, of Charde, or of Yartcombe, yeoman 3
4131539 2071598 2071598 defendant Morse Roger shoemaker 598185 598185 Morse, Roger, of Charde, yeoman, or of Taunton, shoemaker 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);