names

190 rows where place_id = 587765

✎ 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
3592372 1865231 1865231 defendant Baron John butcher 587765 587765 Baron, John, of Horsmonden, butcher 1
3592373 1865231 1865231 defendant Elmer John husbandman 587765 587765 Elmer, John, of Horsmonden, husbandman 2
3592375 1865231 1865231 defendant Baron Henry laborer 587765 587765 Baron, Henry, of Horsmonden, laborer 4
3592378 1865232 1865232 defendant Baron John butcher 587765 587765 Baron, John, of Horsmonden, butcher 1
3592379 1865232 1865232 defendant Elmer John husbandman 587765 587765 Elmer, John, of Horsmonden, husbandman 2
3592381 1865232 1865232 defendant Baron Henry laborer 587765 587765 Baron, Henry, of Horsmonden, laborer 4
3595633 1866260 1866260 defendant Kene William sherman 587765 587765 Kene, William, of Horsmonden, sherman 2
3596359 1866494 1866494 defendant Gadmede or Eadmede Robert husbandman 587765 587765 Gadmede or Eadmede, Robert, of Horsmonden, husbandman 0
3604927 1869205 1869205 defendant Bexle Williamm tanner 587765 587765 Bexle, Williamm, of Horsmonden, tanner 6
3607722 1870068 1870068 defendant Hicmote Richard husbandman 587765 587765 Hicmote, Richard, of Horsmonden, husbandman 0
3609579 1870662 1870662 defendant Neweton Alexander husbandman 587765 587765 Neweton, Alexander, of Horsmonden, husbandman 0
3613782 1871964 1871964 defendant Alfewe William husbandman 587765 587765 Alfewe, William, of Horsmonden, husbandman 4
3620124 1873869 1873869 defendant Hillary Thomas   587765 587765 Hillary, Thomas, of Horsmonden shoemaker 1
3638761 1906942 1906942 defendant Brusshyng Richard laborer 587765 587765 Brusshyng, Richard, of Horsmonden, laborer 0
3640531 1907474 1907474 defendant Peynter Alexander clothmaker 587765 587765 Peynter, Alexander, of Horsmonden, clothmaker 1
3663665 1914570 1914570 defendant Pek Gilbert fuller 587765 587765 Pek, Gilbert, of Horsmonden, fuller 0
3664335 1914793 1914793 defendant Mugge William   587765 587765 Mugge, William, of Horsmonden, cloth maker 0
3666157 1915360 1915360 defendant Weller Alexander husbandman 587765 587765 Weller, Alexander, of Horsmonden, husbandman 0
3666158 1915360 1915360 defendant Wymsherst John husbandman 587765 587765 Wymsherst, John, of Horsmonden, husbandman 1
3666159 1915360 1915360 defendant a Stabill Robert husbandman 587765 587765 a Stabill, Robert, of Horsmonden, husbandman 2
3666160 1915360 1915360 defendant Bisshopp Thomas husbandman 587765 587765 Bisshopp, Thomas, of Horsmonden, husbandman 3
3668508 1916106 1916106 defendant Payntour John yeoman 587765 587765 Payntour, John, of Horsmonden, yeoman 1
3669301 1916336 1916336 defendant Clerke John husbandman 587765 587765 Clerke, John, of Horsmonden, husbandman 0
3674371 1918029 1918029 plaintiff Goffe John   587765 587765 Goffe, John, of Horsmonden 0
3674372 1918029 1918029 defendant Pate William clothmaker 587765 587765 Pate, William, of Horsmonden, clothmaker 0
3680779 1920069 1920069 defendant Weller Alexander husbandman 587765 587765 Weller, Alexander, of Horsmonden, husbandman 0
3681058 1920150 1920150 defendant Semy William cooper 587765 587765 Semy, William, of Horsmonden, cooper 0
3685901 1921748 1921748 defendant Harknap Thomas clothmaker 587765 587765 Harknap, Thomas, of Horsmonden, clothmaker 0
3690196 1923091 1923091 defendant Clerke John husbandman 587765 587765 Clerke, John, of Horsmonden, husbandman 0
3690764 1923276 1923276 defendant Paynter Alexander clothmaker 587765 587765 Paynter, Alexander, of Horsmonden, clothmaker 0
3693067 1924039 1924039 defendant Browne John husbandman 587765 587765 Browne, John, of Horsmonden, husbandman 1
3695000 1924647 1924647 defendant Woodland Robert millman 587765 587765 Woodland, Robert, of Horsmonden, millman 0
3705820 1928100 1928100 defendant Mengge John butcher 587765 587765 Mengge, John, of Horsmonden, butcher 0
3705821 1928100 1928100 defendant Clarke John husbandman 587765 587765 Clarke, John, of Horsmonden, husbandman 1
3707800 1928738 1928738 defendant Herknop Thomas clothmaker 587765 587765 Herknop, Thomas, of Horsmonden, clothmaker 0
3707803 1928738 1928738 defendant Wodland Robert clothier 587765 587765 Wodland, Robert, of Horsmonden, clothier 3
3714500 1930831 1930831 defendant Harknape Thomas clothman 587765 587765 Harknape, Thomas, of Horsmonden, clothman 0
3715084 1931014 1931014 defendant Alyson Andrew fuller 587765 587765 Alyson, Andrew, of Horsmonden, fuller 1
3717527 1931769 1931769 defendant Paynter Alexander beer brewer 587765 587765 Paynter, Alexander, of Horsmonden, beer brewer 1
3720640 1932742 1932742 defendant Paynter Alexander clothmaker 587765 587765 Paynter, Alexander, of Horsmonden, clothmaker 0
3729264 1935404 1935404 defendant Payntour John yeoman 587765 587765 Payntour, John, of Horsmonden, yeoman 0
3740639 1938934 1938934 defendant Musgrove William sawyer 587765 587765 Musgrove, William, of Horsmonden, sawyer 1
3747908 1941268 1941268 defendant Bowen Nicholas laborer 587765 587765 Bowen, Nicholas, of Horsmonden, laborer 0
3747909 1941268 1941268 defendant Lodenden John trenchermaker 587765 587765 Lodenden, John, of Horsmonden, trenchermaker 1
3754377 1943327 1943327 defendant Batherst Thomas fuller 587765 587765 Batherst, Thomas, of Horsmonden, fuller 0
3759214 1944870 1944870 defendant Hope John husbandman 587765 587765 Hope, John, of Horsmonden, husbandman 1
3764648 1946605 1946605 plaintiff Hykmott Henry   587765 587765 Hykmott, Henry, of Horsmonden, scythe smith 0
3771642 1948829 1948829 defendant Batherst Thomas fuller 587765 587765 Batherst, Thomas, of Horsmonden, fuller 0
3772200 1948990 1948990 defendant Gartforth Munell husbandman 587765 587765 Gartforth, Munell, of Horsmonden, husbandman 4
3778380 1950952 1950952 defendant Sampson Henry gent 587765 587765 (Sampson, Henry, of Horsmonden, gent 1
3792123 1955389 1955389 defendant Newynton John yeoman or beer brewer 587765 587765 Newynton, John, of Horsmonden, yeoman or beer brewer 0
3797316 1957049 1957049 defendant Goffe or Gowgh John fuller 587765 587765 Goffe or Gowgh, John, of Horsmonden, fuller 0
3798525 1957441 1957441 defendant Edwardes Andrew yeoman 587765 587765 Edwardes, Andrew, of Horsmonden, yeoman 0
3815948 1962892 1962892 defendant Edward Andrew yeoman 587765 587765 Edward, Andrew, of Horsmonden, yeoman 1
3815949 1962892 1962892 defendant Newenton John yeoman 587765 587765 Newenton, John, of Horsmonden, yeoman 2
3815950 1962892 1962892 defendant Edmede Thomas yeoman 587765 587765 Edmede, Thomas, of Horsmonden, yeoman 3
3815951 1962892 1962892 defendant A Stable Robert yeoman 587765 587765 A Stable, Robert, of Horsmonden, yeoman 4
3816788 1963158 1963158 defendant Edwardys alias Teyherst William clerk 587765 587765 Edwardys alias Teyherst, William, of Horsmonden, clerk 0
3826391 1966103 1966103 defendant Edward Andrew yeoman 587765 587765 Edward, Andrew, of Horsmonden, yeoman 0
3839276 1970212 1970212 defendant Menge Robert butcher 587765 587765 Menge, Robert, of Horsmonden, butcher 0
3852975 1974552 1974552 defendant Gregby William yeoman 587765 587765 Gregby, William, of Horsmonden, yeoman 0
3852976 1974552 1974552 defendant Hykmott Henry sawyer 587765 587765 Hykmott, Henry, of Horsmonden, sawyer 1
3866959 1979187 1979187 defendant Baldoke John clothier 587765 587765 Baldoke, John, of Horsmonden, clothier 3
3880055 1983588 1983588 defendant Baker John husbandman 587765 587765 Baker, John, of Horsmonden, husbandman 1
3891062 1987278 1987278 plaintiff Jurden Christopher (legal representative) 587765 587765 Jurden, Christopher, of Horsmonden, administratrix of 0
4080774 2053436 2053436 defendant Bowle Stephen husbandman 587765 587765 Bowle, Stephen, of Horsmonden, husbandman 0
4083964 2054541 2054541 defendant Baldcok Edward   587765 587765 Baldcok, Edward, of Horsmonden, sickle maker 0
4156943 2080507 2080507 defendant Aleye John brewer 587765 587765 Aleye, John, of Horsmonden, brewer 1
4160805 2081856 2081856 defendant Batherst Edward clothier 587765 587765 Batherst, Edward, of Horsmonden, clothier 0
4283125 2123999 2123999 defendant Huggatt Thomas yeoman 587765 587765 Huggatt, Thomas, of Horsmonden, yeoman 0
4291854 2127162 2127162 defendant Huggatt Thomas yeoman 587765 587765 Huggatt, Thomas, of Horsmonden, yeoman 0
4603399 2232253 2232253 defendant atte Wode Robert   587765 587765 atte Wode, Robert, of Horsmonden 3
4651953 2246547 2246547 defendant Beggebroke Thomas farmer 587765 587765 Beggebroke, Thomas, of Horsmonden, farmer 0
4667389 2255521 2255521 defendant Lodynden Nicholas laborer 587765 587765 Lodynden, Nicholas, of Horsmonden, laborer 1
4686999 2261541 2261541 defendant Lodynden Richard husbandman 587765 587765 Lodynden, Richard, of Horsmonden, husbandman 0
4703235 2266391 2266391 defendant Begetep Nicholas   587765 587765 Begetep, Nicholas, of Horsmonden, wheel wright 3
4703236 2266391 2266391 defendant Body Richard husbandman 587765 587765 Body, Richard, of Horsmonden, husbandman 4
4709971 2268474 2268474 defendant Leem John yeoman 587765 587765 Leem, John, of Horsmonden, yeoman 0
4740361 2277692 2277692 defendant Tylere Richard carpenter 587765 587765 Tylere, Richard, of Horsmonden, carpenter 0
4743614 2278661 2278661 defendant Edmede John tanner 587765 587765 Edmede, John, of Horsmonden, tanner 0
4761582 2283967 2283967 defendant Richard John laborer 587765 587765 Richard, John, of Horsmonden, laborer 0
4769095 2286316 2286316 defendant Tyler R_ laborer 587765 587765 Tyler, R_, of Horsmonden, laborer 1
4779429 2289548 2289548 defendant atte Wode Nicholas laborer 587765 587765 atte Wode, Nicholas, of Horsmonden, laborer 1
4779443 2289549 2289549 defendant Begeteppe Richard laborer 587765 587765 Begeteppe, Richard, of Horsmonden, laborer 4
4821580 2302831 2302831 defendant Bussh John husbandman 587765 587765 Bussh, John, of Horsmonden, husbandman 0
4833150 2306380 2306380 defendant Edmede John tanner 587765 587765 Edmede, John, of Horsmonden, tanner 0
4855646 2313135 2313135 defendant Fynchcok Thomas, junior laborer 587765 587765 together with Fynchcok, Thomas, junior, of Horsmonden, laborer 1
4855647 2313135 2313135 defendant Fynchcok Thomas, senior laborer 587765 587765 Fynchcok, Thomas, senior, of Horsmonden, laborer 2
4871326 2317998 2317998 defendant Joce Richard laborer 587765 587765 Joce, Richard, of Horsmonden, laborer 1
4904582 2328046 2328046 defendant Hugot Thomas husbandman 587765 587765 Hugot, Thomas, of Horsmonden, husbandman 0
4944739 2340341 2340341 plaintiff Sharynden Simon   587765 587765 Sharynden, Simon, of Horsmonden 2
4950153 2342014 2342014 defendant Wychynden Nicholas laborer 587765 587765 Wychynden, Nicholas, of Horsmonden, laborer 2
4974661 2349388 2349388 defendant Tydy William husbandman 587765 587765 Tydy, William, of Horsmonden, husbandman 0
5067445 2376764 2376764 defendant Horeman Richard husbandman 587765 587765 Horeman, Richard, of Horsmonden, husbandman 2
5088601 2383041 2383041 defendant Bakere John baker 587765 587765 Bakere, John, of Horsmonden, baker 0
5106317 2388287 2388287 defendant Hope Philip laborer 587765 587765 Hope, Philip, of Horsmonden, laborer 1
5106318 2388287 2388287 defendant Sampson John gent 587765 587765 together with Sampson, John, of Horsmonden, gent 2
5106320 2388288 2388288 defendant Sampson John gent 587765 587765 Sampson, John, of Horsmonden, gent 0
5106322 2388288 2388288 defendant Hope Philip laborer 587765 587765 Hope, Philip, of Horsmonden, laborer 2
5111042 2389621 2389621 defendant Faucot or Fancot John gent 587765 587765 Faucot or Fancot, John, of Horsmonden, gent 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);