names

185 rows where place_id = 586994

✎ 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
3590179 1864567 1864567 defendant Rednes Robert yeoman 586994 586994 Rednes, Robert, of Haylesham, yeoman 0
3596713 1866607 1866607 defendant Harrys Thomas husbandman 586994 586994 Harrys, Thomas, of Haylesham, husbandman 1
3599965 1867644 1867644 defendant Twyt Robert laborer 586994 586994 Twyt, Robert, of Haylesham, laborer 0
3605058 1869247 1869247 defendant Poyle Morgan husbandman 586994 586994 Poyle, Morgan, of Haylesham, husbandman 0
3659589 1913258 1913258 defendant Willard Robert husbandman 586994 586994 Willard, Robert, of Haylesham, husbandman 3
3672953 1917552 1917552 defendant Willard Thomas husbandman 586994 586994 Willard, Thomas, of Haylesham, husbandman 0
3690242 1923108 1923108 defendant Warre Richard yeoman 586994 586994 Warre, Richard, of Haylesham, yeoman 0
3690243 1923108 1923108 defendant Frye John yeoman 586994 586994 Frye, John, of Haylesham, yeoman 1
3706597 1928348 1928348 defendant Snowe Peter husbandman 586994 586994 Snowe, Peter, of Haylesham, husbandman 2
3748583 1941487 1941487 defendant Hunt Richard husbandman 586994 586994 Hunt, Richard, of Haylesham, husbandman 1
3778861 1951103 1951103 defendant Drew John husbandman 586994 586994 Drew, John, of Haylesham, husbandman 1
3943075 2004696 2004696 defendant Maryner Robert husbandman 586994 586994 Maryner, Robert, of Haylesham, husbandman 2
3945239 2005420 2005420 defendant Kensley John yeoman 586994 586994 Kensley, John, of Haylesham, yeoman 0
3945240 2005420 2005420 defendant Kensley Richard yeoman 586994 586994 Kensley, Richard, of Haylesham, yeoman 1
3945244 2005421 2005421 defendant Kensley John yeoman 586994 586994 Kensley, John, of Haylesham, yeoman 0
3945245 2005421 2005421 defendant Kensley Richard yeoman 586994 586994 Kensley, Richard, of Haylesham, yeoman 1
3972075 2014792 2014792 defendant Foster Edmund yeoman 586994 586994 Foster, Edmund, of Haylesham, yeoman 0
3982157 2018379 2018379 defendant Twysden John yeoman 586994 586994 Twysden, John, of Haylesham, yeoman 2
4028185 2034727 2034727 defendant Foster Nicholas yeoman 586994 586994 Foster, Nicholas, of Haylesham, yeoman 2
4030293 2035488 2035488 defendant Foote Edward yeoman 586994 586994 Foote, Edward, of Haylesham, yeoman 2
4049390 2042226 2042226 defendant Foster Nicholas yeoman 586994 586994 Foster, Nicholas, of Haylesham, yeoman 0
4049391 2042226 2042226 defendant Tutt John, senior yeoman 586994 586994 Tutt, John, senior, of Haylesham, yeoman 1
4070628 2049791 2049791 defendant Twysden John husbandman 586994 586994 Twysden, John, of Haylesham, husbandman 1
4070631 2049792 2049792 defendant Fourner Patrick shoemaker 586994 586994 Fourner, Patrick, of Haylesham, shoemaker 0
4070632 2049792 2049792 defendant Twysden John husbandman 586994 586994 Twysden, John, of Haylesham, husbandman 1
4070633 2049792 2049792 defendant Kensley Richard yeoman 586994 586994 Kensley, Richard, of Haylesham, or of Downeashe, yeoman 2
4096333 2059020 2059020 defendant Kensley William yeoman 586994 586994 Kensley, William, of Haylesham, yeoman 0
4097939 2059591 2059591 defendant Avennell John yeoman 586994 586994 Avennell, John, of Haylesham, yeoman 0
4097940 2059591 2059591 defendant Sampton Henry yeoman 586994 586994 Sampton, Henry, of Haylesham, yeoman 1
4122380 2068314 2068314 defendant Furner Patrick shoemaker 586994 586994 Furner, Patrick, of Haylesham, shoemaker 1
4122848 2068465 2068465 defendant Nowell James tailor 586994 586994 Nowell, James, of Haylesham, tailor 0
4130910 2071368 2071368 defendant Gurse John husbandman 586994 586994 Gurse, John, of Haylesham, husbandman 3
4139664 2074548 2074548 defendant Foster Nicholas yeoman 586994 586994 Foster, Nicholas, of Haylesham, yeoman 0
4139666 2074549 2074549 defendant Foster Nicholas yeoman 586994 586994 Foster, Nicholas, of Haylesham, yeoman 0
4164459 2083088 2083088 defendant Foster Thomas yeoman 586994 586994 Foster, Thomas, of Haylesham, yeoman 1
4169272 2084755 2084755 defendant Putland John yeoman 586994 586994 Putland, John, of Haylesham, yeoman 0
4170328 2085114 2085114 defendant Smythe John husbandman 586994 586994 Smythe, John, of Haylesham, husbandman 0
4170554 2085197 2085197 defendant Furner Patrick shoemaker 586994 586994 Furner, Patrick, of Haylesham, shoemaker 0
4182230 2089264 2089264 defendant Hussey Humphrey yeoman 586994 586994 Hussey, Humphrey, of Haylesham, or of Herstmounceux, yeoman 0
4217008 2101444 2101444 defendant Kensley Richard yeoman 586994 586994 Kensley, Richard, of Haylesham, yeoman 2
4231500 2106517 2106517 defendant Coburne or Colbourne Mathew yeoman 586994 586994 Coburne or Colbourne, Mathew, of Haylesham, yeoman 0
4233988 2107412 2107412 defendant Beelande John glover 586994 586994 Beelande, John, of Haylesham, glover 2
4296302 2128774 2128774 defendant Peckham John husbandman 586994 586994 Peckham, John, of Haylesham, husbandman 0
4310804 2133922 2133922 defendant Warham Thomas husbandman 586994 586994 Warham, Thomas, of Haylesham, husbandman 0
4319803 2137035 2137035 defendant Goffe Abraham yeoman 586994 586994 Goffe, Abraham, of Haylesham, yeoman 0
4328447 2139828 2139828 defendant Foster Alexander husbandman 586994 586994 Foster, Alexander, of Haylesham, husbandman 1
4364828 2152474 2152474 defendant Foote Edward husbandman 586994 586994 Foote, Edward, of Haylesham, husbandman 0
4365457 2152713 2152713 defendant Hodson Michael clerk 586994 586994 Hodson, Michael, of Haylesham, clerk 0
4365458 2152713 2152713 defendant Tharkra Gawin laborer 586994 586994 Tharkra, Gawin, of Haylesham, laborer 1
4365459 2152713 2152713 defendant Swane Thomas laborer 586994 586994 Swane, Thomas, of Haylesham, laborer 2
4365480 2152721 2152721 defendant Smyth Samuel cooper 586994 586994 Smyth, Samuel, of Haylesham, cooper 1
4368128 2153656 2153656 defendant Smythe Richard bricklayer 586994 586994 Smythe, Richard, of Haylesham, bricklayer 0
4379844 2157891 2157891 defendant Smyth Samuel cooper 586994 586994 Smyth, Samuel, of Haylesham, cooper 0
4403221 2165648 2165648 defendant Wynter John victualer 586994 586994 Wynter, John, of Haylesham, victualer 2
4484317 2195798 2195798 plaintiff Peplesham Thomas   586994 586994 Peplesham, Thomas, of Haylesham 0
4512928 2204477 2204477 defendant Spymer Simon   586994 586994 Spymer, Simon, of Haylesham 3
4572706 2223003 2223003 defendant Somer John   586994 586994 Somer, John, of Haylesham 3
4622407 2237989 2237989 defendant Dreu John   586994 586994 Dreu, John, of Haylesham 0
4622408 2237989 2237989 defendant Drey Stephen   586994 586994 Drey, Stephen, of Haylesham 1
4652081 2246589 2246589 defendant Page John tanner 586994 586994 Page, John, of Haylesham, tanner 0
4652082 2246589 2246589 defendant Page Richard tanner 586994 586994 Page, Richard, of Haylesham, tanner 1
4653462 2247014 2247014 defendant Longe John shoemaker 586994 586994 Longe, John, of Haylesham, shoemaker 0
4653463 2247014 2247014 defendant Frye Thomas laborer 586994 586994 Frye, Thomas, of Haylesham, laborer 1
4653464 2247014 2247014 defendant Waryn John smith 586994 586994 Waryn, John, of Haylesham, smith 2
4710117 2268518 2268518 defendant Twyt Richard husbandman 586994 586994 Twyt, Richard, of Haylesham, husbandman 0
4710118 2268518 2268518 defendant Sandre Robert husbandman 586994 586994 Sandre, Robert, of Haylesham, husbandman 1
4757078 2282583 2282583 defendant Willard William   586994 586994 Willard, William, of Haylesham, shoe maker 0
4761175 2283845 2283845 defendant Baker John laborer 586994 586994 Baker, John, of Haylesham, laborer 1
4761176 2283845 2283845 defendant Greslond John laborer 586994 586994 Greslond, John, of Haylesham, laborer 2
4763696 2284635 2284635 defendant Sandre Robert husbandman 586994 586994 Sandre, Robert, of Haylesham, husbandman 1
4763697 2284635 2284635 defendant Osbern John laborer 586994 586994 Osbern, John, of Haylesham, laborer 2
4784539 2291170 2291170 defendant Bakere John laborer 586994 586994 Bakere, John, of Haylesham, laborer 0
4784540 2291170 2291170 defendant Greslond John laborer 586994 586994 Greslond, John, of Haylesham, laborer 1
4787354 2292116 2292116 defendant Sandre Robert husbandman 586994 586994 Sandre, Robert, of Haylesham, husbandman 1
4787355 2292116 2292116 defendant Osbern John laborer 586994 586994 Osbern, John, of Haylesham, laborer 2
4787360 2292117 2292117 defendant Sandre Robert husbandman 586994 586994 Sandre, Robert, of Haylesham, husbandman 1
4787361 2292117 2292117 defendant Osbern John laborer 586994 586994 Osbern, John, of Haylesham, laborer 2
4799705 2296094 2296094 defendant Chilly Simon husbandman 586994 586994 Chilly, Simon, of Haylesham, husbandman 0
4811373 2299666 2299666 defendant atte Doune John yeoman 586994 586994 atte Doune, John, of Haylesham, yeoman 0
4819811 2302269 2302269 defendant Blakstok John butcher 586994 586994 Blakstok, John, of Haylesham, butcher 0
4828966 2305103 2305103 plaintiff atte Wode Thomas   586994 586994 atte Wode, Thomas, of Haylesham 0
4830736 2305641 2305641 defendant Waunemere William husbandman 586994 586994 Waunemere, William, of Haylesham, husbandman 0
4839370 2308235 2308235 defendant Threel Geoffrey laborer 586994 586994 Threel, Geoffrey, of Haylesham, laborer 0
4845338 2310054 2310054 defendant Adune John yeoman 586994 586994 Adune, John, of Haylesham, yeoman 1
4855711 2313159 2313159 defendant Pepelysham Thomas gent 586994 586994 Pepelysham, Thomas, of Haylesham, gent 0
4855729 2313165 2313165 defendant Wannemere William laborer 586994 586994 Wannemere, William, of Haylesham, laborer 0
4857591 2313763 2313763 defendant Wannemere William husbandman 586994 586994 Wannemere, William, of Haylesham, husbandman 0
4861612 2315004 2315004 defendant Smyth Andrew smith 586994 586994 Smyth, Andrew, of Haylesham, smith 0
4864176 2315773 2315773 defendant atte Lyght Simon laborer 586994 586994 atte Lyght, Simon, of Haylesham, laborer 0
4864253 2315797 2315797 defendant Fagham John, junior laborer 586994 586994 Fagham, John, junior, of Haylesham, laborer 0
4864254 2315797 2315797 defendant Hokeby John laborer 586994 586994 Hokeby, John, of Haylesham, laborer 1
4864255 2315797 2315797 defendant Chilly John laborer 586994 586994 Chilly, John, of Haylesham, laborer 2
4864259 2315797 2315797 defendant Chilly William laborer 586994 586994 Chilly, William, of Haylesham, laborer 6
4865297 2316117 2316117 defendant Tyllys William tailor 586994 586994 Tyllys, William, of Haylesham, tailor 0
4866107 2316372 2316372 defendant Eylone pr Eylove Richard   586994 586994 Eylone pr Eylove, Richard, of Haylesham, bailiff 1
4881273 2321047 2321047 defendant Wamsemere Thomas husbandman 586994 586994 Wamsemere, Thomas, of Haylesham, husbandman 1
4882426 2321417 2321417 defendant A Doune John gent 586994 586994 A Doune, John, of Haylesham, gent 0
4884171 2321958 2321958 defendant Facam John gent 586994 586994 Facam, John, of Haylesham, gent 0
4891740 2324159 2324159 defendant Hokeby John butcher 586994 586994 Hokeby, John, of Haylesham, butcher 3
4894441 2324937 2324937 defendant Wannemere Thomas husbandman 586994 586994 Wannemere, Thomas, of Haylesham, husbandman 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);