names

675 rows where place_id = 587920

✎ 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
3592831 1865373 1865373 defendant Kyng Thomas merchant 587920 587920 Kyng, Thomas, of Maldon, merchant 0
3593098 1865469 1865469 defendant Kyng Thomas merchant 587920 587920 Kyng, Thomas, of Maldon, merchant 0
3595793 1866319 1866319 defendant Fraunceys Joan widow 587920 587920 Fraunceys, Joan, of Maldon, widow 0
3595794 1866319 1866319 defendant Hubberd John butcher 587920 587920 Hubberd, John, of Maldon, butcher 1
3596735 1866615 1866615 defendant Wedde John yeoman 587920 587920 Wedde, John, of Maldon, yeoman 1
3597473 1866830 1866830 defendant Fraunces Joan widow 587920 587920 Fraunces, Joan, of Maldon, widow 1
3605539 1869398 1869398 defendant Darellys Thomas gent 587920 587920 Darellys, Thomas, of Maldon, gent 0
3606594 1869736 1869736 plaintiff Ormesby John esq 587920 587920 Ormesby, John, of Maldon, esq 0
3606740 1869783 1869783 defendant Cappe John glover 587920 587920 Cappe, John, of Maldon, glover 3
3627137 1903345 1903345 defendant Morton John miller 587920 587920 Morton, John, of Maldon, miller 0
3632438 1904962 1904962 defendant Higham Thomas esq 587920 587920 Higham, Thomas, of Maldon, esq 0
3643365 1908352 1908352 defendant Cley Edmund yeoman 587920 587920 Cley, Edmund, of Maldon, yeoman 1
3644836 1908791 1908791 defendant Wylson David butcher 587920 587920 Wylson, David, of Maldon, butcher 0
3648770 1910003 1910003 defendant Skipwith Thomas esq 587920 587920 Skipwith, Thomas, of Maldon, esq 0
3648772 1910004 1910004 defendant Skypwith Thomas esq 587920 587920 Skypwith, Thomas, of Maldon, esq 0
3648774 1910005 1910005 defendant Skypwith Thomas esq 587920 587920 Skypwith, Thomas, of Maldon, esq 0
3648776 1910006 1910006 defendant Skypwyth Thomas esq 587920 587920 Skypwyth, Thomas, of Maldon, esq 0
3670017 1916568 1916568 defendant Stenye or Stevye William yeoman 587920 587920 Stenye or Stevye, William, of Maldon, yeoman 2
3670021 1916569 1916569 defendant Stenye William yeoman 587920 587920 Stenye, William, of maldon, yeoman 2
3672219 1917311 1917311 defendant Pynde Thomas merchant 587920 587920 Pynde, Thomas, of Maldon, merchant 0
3675571 1918395 1918395 defendant Nasshe John yeoman 587920 587920 Nasshe, John, of Maldon, yeoman 0
3675677 1918423 1918423 defendant Osborne Thomas husbandman 587920 587920 Osborne, Thomas, of Maldon, husbandman 0
3675679 1918424 1918424 defendant Wyborowe Thomas gent 587920 587920 Wyborowe, Thomas, of Maldon, gent 0
3675681 1918425 1918425 defendant Daves John yeoman 587920 587920 Daves, John, of Maldon, yeoman 0
3675682 1918425 1918425 defendant Nasshe John yeoman 587920 587920 Nasshe, John, of Maldon, yeoman 1
3687003 1922103 1922103 defendant Mathewson Richard yeoman 587920 587920 Mathewson, Richard, of Maldon, yeoman 1
3691538 1923509 1923509 defendant Nasshe John yeoman 587920 587920 Nasshe, John, of Maldon, yeoman 0
3696622 1925174 1925174 defendant Mathewson Richard yeoman 587920 587920 Mathewson, Richard, of Maldon, yeoman 0
3703151 1927258 1927258 defendant Heygate John gent 587920 587920 Heygate, John, of Maldon, gent 0
3705876 1928122 1928122 defendant Baynam Richard gent 587920 587920 Baynam, Richard, of Maldon, gent 0
3706934 1928454 1928454 defendant Nasshe John gent 587920 587920 Nasshe, John, of Maldon, gent 0
3714145 1930724 1930724 defendant Paget John yeoman 587920 587920 Paget, John, of Maldon, yeoman 3
3718739 1932140 1932140 plaintiff Gaywod Thomas   587920 587920 Gaywod, Thomas, of Maldon, gent, administrators of 0
3729493 1935470 1935470 defendant Pagett John yeoman 587920 587920 Pagett, John, of Maldon, yeoman 3
3734659 1937088 1937088 defendant Soome Thomas butcher 587920 587920 Soome, Thomas, of Maldon, butcher 0
3734768 1937118 1937118 defendant Solne or Solve Thomas butcher 587920 587920 Solne or Solve, Thomas, of Maldon, butcher 2
3735741 1937416 1937416 defendant Beynon Richard husbandman 587920 587920 Beynon, Richard, of Maldon, husbandman 2
3736368 1937617 1937617 defendant Raygat Thomas husbandman 587920 587920 Raygat, Thomas, of Maldon, husbandman 0
3747861 1941254 1941254 defendant Yott Thomas butcher 587920 587920 Yott, Thomas, of Maldon, butcher 1
3759010 1944805 1944805 defendant Soham Thomas butcher 587920 587920 Soham, Thomas, of Maldon, butcher 0
3759012 1944806 1944806 defendant Solme Thomas butcher 587920 587920 Solme, Thomas, of Maldon, butcher 0
3760559 1945304 1945304 defendant Solme or Soline Thomas butcher 587920 587920 Solme or Soline, Thomas, of Maldon, butcher 1
3763884 1946347 1946347 defendant Heygate John yeoman 587920 587920 Heygate, John, of Maldon, yeoman 0
3763890 1946348 1946348 defendant Heygatt John yeoman 587920 587920 Heygatt, John, of Maldon, yeoman 0
3764840 1946670 1946670 defendant Wyborowe Thomas gent 587920 587920 Wyborowe, Thomas, of Maldon, gent 0
3768070 1947651 1947651 plaintiff Pagett John yeoman 587920 587920 Pagett, John, of Maldon, yeoman 0
3770612 1948492 1948492 defendant Cotton William yeoman 587920 587920 Cotton, William, of Maldon, yeoman 0
3774055 1949601 1949601 defendant Reynold John smith 587920 587920 Reynold, John, of Maldon, smith 0
3774056 1949601 1949601 defendant Pelle John smith 587920 587920 Pelle, John, of Maldon, smith 1
3774058 1949601 1949601 defendant Cokshete John husbandman 587920 587920 Cokshete, John, of Maldon, husbandman 3
3778612 1951022 1951022 defendant Solme Thomas butcher 587920 587920 Solme, Thomas, of Maldon, butcher 1
3781635 1951993 1951993 defendant Solme Thomas butcher 587920 587920 Solme, Thomas, of Maldon, butcher 0
3781636 1951993 1951993 defendant Sherman John yeoman 587920 587920 Sherman, John, of Maldon, yeoman 1
3782488 1952267 1952267 defendant Becke Thomas yeoman 587920 587920 Becke, Thomas, of Maldon, yeoman 0
3784284 1952874 1952874 defendant Palmer John merchant 587920 587920 Palmer, John, of Maldon, merchant 0
3788231 1954116 1954116 defendant Heygate John yeoman 587920 587920 Heygate, John, of Maldon, yeoman 1
3788232 1954116 1954116 defendant Solme Thomas butcher 587920 587920 Solme, Thomas, of Maldon, butcher 2
3798281 1957358 1957358 defendant Davy Robert saddler 587920 587920 Davy, Robert, of Maldon, saddler 2
3798283 1957359 1957359 defendant Smyth Reginald butcher 587920 587920 Smyth, Reginald, of Maldon, butcher 0
3798319 1957373 1957373 defendant Heygate John yeoman 587920 587920 Heygate, John, of Maldon, yeoman 0
3804697 1959411 1959411 defendant Dawes John merchant 587920 587920 Dawes, John, of Maldon, merchant 0
3807802 1960324 1960324 defendant Fowle Reginald (legal representative) 587920 587920 Fowle, Reginald, of Maldon, executrix of 0
3819163 1963880 1963880 defendant Cokshott Robert husbandman 587920 587920 Cokshott, Robert, of Maldon, husbandman 1
3822149 1964823 1964823 defendant Dawes John merchant 587920 587920 Dawes, John, of Maldon, merchant 0
3826584 1966163 1966163 defendant Gate John yeoman 587920 587920 Gate, John, of Maldon, yeoman 1
3826613 1966171 1966171 defendant Smyth Reginald butcher 587920 587920 Smyth, Reginald, of Maldon, butcher 1
3826858 1966249 1966249 defendant Smyth alias Bocher Reginald butcher 587920 587920 Smyth alias Bocher, Reginald, of Maldon, butcher 0
3829528 1967123 1967123 defendant Beswell John gent 587920 587920 Beswell, John, of Maldon, gent 1
3837770 1969728 1969728 defendant Smyth alias Bocher Reginald butcher 587920 587920 Smyth alias Bocher, Reginald, of Maldon, butcher 0
3840767 1970678 1970678 defendant Lepar Richard husbandman 587920 587920 Lepar, Richard, of Maldon, husbandman 2
3841121 1970799 1970799 defendant Smyth Reginald butcher 587920 587920 Smyth, Reginald, of Maldon, butcher 0
3854911 1975180 1975180 defendant Cotton William yeoman 587920 587920 Cotton, William, of Maldon, yeoman 0
3856514 1975664 1975664 defendant Smyth Reginald butcher 587920 587920 Smyth, Reginald, of Maldon, butcher 0
3859053 1976518 1976518 defendant Bedfeld Simon tailor 587920 587920 Bedfeld, Simon, of Maldon, tailor 0
3859521 1976675 1976675 defendant Kettell Robert butcher 587920 587920 Kettell, Robert, of Maldon, butcher 0
3861047 1977178 1977178 plaintiff Elyott Robert carpenter 587920 587920 Elyott, Robert, of Maldon, carpenter 0
3861048 1977178 1977178 defendant Tayler alias Hardyng Thomas bricklayer 587920 587920 Tayler alias Hardyng, Thomas, of Maldon, bricklayer 0
3861050 1977179 1977179 plaintiff Elyott Robert carpenter 587920 587920 Elyott, Robert, of Maldon, carpenter 0
3861051 1977179 1977179 defendant Taylour alias Hardyng Thomas bricklayer 587920 587920 Taylour alias Hardyng, Thomas, of Maldon, bricklayer 0
3869145 1979928 1979928 defendant Cotton William yeoman 587920 587920 Cotton, William, of Maldon, yeoman 0
3877169 1982604 1982604 defendant Kettyll John butcher 587920 587920 Kettyll, John, of Maldon, butcher 0
3885505 1985407 1985407 defendant Webster Roger tiler 587920 587920 Webster, Roger, of Maldon, tiler 4
3899279 1989969 1989969 defendant Webster Roger tiler 587920 587920 Webster, Roger, of Maldon, tiler 4
3904381 1991712 1991712 defendant Wyelde John weaver 587920 587920 Wyelde, John, of Maldon, weaver 1
3913470 1994841 1994841 defendant Mapull Thomas yeoman 587920 587920 Mapull, Thomas, of Maldon, yeoman 0
3921129 1997418 1997418 defendant Leper Richard husbandman 587920 587920 Leper, Richard, of Maldon, husbandman 0
3928166 1999756 1999756 defendant Cotton Richard husbandman 587920 587920 Cotton, Richard, of Maldon, husbandman 0
3974975 2015808 2015808 defendant Eves Thomas chapman 587920 587920 Eves, Thomas, of Maldon, chapman 4
3982209 2018402 2018402 defendant Pechye Thomas merchant 587920 587920 Pechye, Thomas, of Maldon, merchant 0
4018362 2031297 2031297 defendant Fortescue Henry esq 587920 587920 Fortescue, Henry, of Maldon, esq 1
4034056 2036838 2036838 plaintiff Hall or Hale William yeoman 587920 587920 Hall or Hale, William, of Maldon, yeoman 0
4034084 2036851 2036851 plaintiff Hall William yeoman 587920 587920 Hall, William, of Maldon, yeoman 0
4049352 2042213 2042213 defendant Collyn Thomas clothier 587920 587920 Collyn, Thomas, of Maldon, Essex, clothier, servant with Thomas Clarke, of Maldon, clothier 0
4049354 2042214 2042214 defendant Collyn Thomas clothier 587920 587920 Collyn, Thomas, of Maldon, Essex, clothier, servant with Thomas Clarke, of Maldon, clothier 0
4050903 2042766 2042766 plaintiff West Thomas, senior gent 587920 587920 West, Thomas, senior, of Maldon, gent 0
4136706 2073474 2073474 defendant Allen Thomas yeoman 587920 587920 Allen, Thomas, of Maldon, yeoman 0
4179766 2088397 2088397 defendant Strowe Richard joiner 587920 587920 Strowe, Richard, of Maldon, joiner 0
4187567 2091152 2091152 defendant Warrame Richard stringer 587920 587920 Warrame, Richard, of Maldon, stringer 1
4232063 2106715 2106715 defendant Browninge Jonas   587920 587920 Browninge, Jonas, of Maldon, woollen draper 0
4239768 2109540 2109540 defendant Bantocke or Bantofte William yeoman 587920 587920 Bantocke or Bantofte, William, of Maldon, yeoman 1

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