names

154 rows where place_id = 588882

✎ 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
3595892 1866350 1866350 defendant Sayer Thomas tanner 588882 588882 Sayer, Thomas, of Retherfeld, tanner 0
3595893 1866350 1866350 defendant Fermer Thomas tanner 588882 588882 Fermer, Thomas, of Retherfeld, tanner 1
3598050 1867014 1867014 defendant Knyght John (legal representative) 588882 588882 Knyght, John, of Retherfeld, gent, executrix of 2
3598051 1867014 1867014 defendant Knyght Alice widow 588882 588882 Knyght, Alice, of Retherfeld, widow 3
3623331 1874827 1874827 defendant Fermer John shingler 588882 588882 Fermer, John, of Retherfeld, shingler 0
3652670 1911167 1911167 defendant Hothlye Thomas husbandman 588882 588882 Hothlye, Thomas, of Retherfeld, husbandman 0
3652671 1911167 1911167 defendant Grangeman John husbandman 588882 588882 Grangeman, John, of Retherfeld, husbandman 1
3652672 1911167 1911167 defendant Farmar Robert husbandman 588882 588882 Farmar, Robert, of Retherfeld, husbandman 2
3658563 1912931 1912931 defendant Fuller Richard yeoman 588882 588882 Fuller, Richard, of Retherfeld, yeoman 1
3668376 1916057 1916057 defendant Fermour Thomas yeoman 588882 588882 Fermour, Thomas, of Retherfeld, yeoman 0
3682002 1920477 1920477 defendant Heyward John husbandman 588882 588882 Heyward, John, of Retherfeld, husbandman 0
3682003 1920477 1920477 defendant Sterre Thomas husbandman 588882 588882 Sterre, Thomas, of Retherfeld, husbandman 1
3694348 1924438 1924438 defendant Maynard William, senior husbandman 588882 588882 Maynard, William, senior, of Retherfeld, husbandman 0
3694349 1924438 1924438 defendant Hotheley Thomas husbandman 588882 588882 Hotheley, Thomas, of Retherfeld, husbandman 1
3698612 1925779 1925779 defendant Longley Thomas   588882 588882 Longley, Thomas, of Retherfeld, "trugger" 8
3698613 1925779 1925779 defendant Downe John trugger 588882 588882 Downe, John, of Retherfeld, trugger 9
3722714 1933371 1933371 defendant Maynard Richard yeoman 588882 588882 Maynard, Richard, of Retherfeld, yeoman 0
3738059 1938119 1938119 defendant Catte John husbandman 588882 588882 Catte, John, of Retherfeld, husbandman 0
3742424 1939501 1939501 defendant Aderwold Joan widow 588882 588882 Aderwold, Joan, of Retherfeld, widow 1
3753349 1942985 1942985 defendant Farmar John tailor 588882 588882 Farmar, John, of Retherfeld, tailor 3
3761270 1945528 1945528 defendant Bassok John clothier 588882 588882 Bassok, John, of Retherfeld, clothier 0
3792707 1955571 1955571 defendant Wylmesherst John weaver 588882 588882 Wylmesherst, John, of Retherfeld, weaver 3
3795434 1956446 1956446 defendant Mogylwyke William yeoman 588882 588882 Mogylwyke, William, of Retherfeld, yeoman 0
3796495 1956775 1956775 defendant Bassok John clothmaker 588882 588882 Bassok, John, of Retherfeld, clothmaker 0
3833196 1968315 1968315 defendant Colyn Thomas chapman 588882 588882 Colyn, Thomas, of Retherfeld, chapman 2
3833210 1968318 1968318 defendant Colyn Thomas chapman 588882 588882 Colyn, Thomas, of Retherfeld, chapman 2
3914574 1995219 1995219 defendant Holman Robert collier 588882 588882 Holman, Robert, of Retherfeld, collier 0
3952867 2008078 2008078 plaintiff Hothlye William   588882 588882 Hothlye, William, of Retherfeld 0
3952868 2008078 2008078 defendant Knyght Richard husbandman 588882 588882 Knyght, Richard, of Retherfeld, husbandman 0
3961487 2011115 2011115 defendant Sybley or Sybbell Henry butcher 588882 588882 Sybley or Sybbell, Henry, of Retherfeld, butcher 0
4002862 2025791 2025791 defendant Downe William   588882 588882 Downe, William, of Retherfeld, "trugger" or basket maker 0
4008999 2027983 2027983 defendant Farmer Alexander yeoman 588882 588882 Farmer, Alexander, of Retherfeld, yeoman 0
4077458 2052228 2052228 defendant Richard William husbandman 588882 588882 Richard, William, of Retherfeld, husbandman 0
4090451 2056866 2056866 defendant Atherall Nicholas yeoman 588882 588882 Atherall, Nicholas, of Retherfeld, yeoman 0
4103747 2061610 2061610 defendant Huggett John yeoman 588882 588882 Huggett, John, of Retherfeld, yeoman 0
4104379 2061848 2061848 defendant Richard John husbandman 588882 588882 Richard, John, of Retherfeld, husbandman 3
4104384 2061849 2061849 defendant Richard John husbandman 588882 588882 Richard, John, of Retherfeld, husbandman 3
4110509 2064019 2064019 defendant Aderoll Nicholas yeoman 588882 588882 (Aderoll, Nicholas, of Retherfeld, yeoman 1
4110510 2064019 2064019 defendant Aderoll Thomas yeoman 588882 588882 Aderoll, Thomas, of Retherfeld, yeoman 2
4119231 2067171 2067171 defendant Castleyn George husbandman 588882 588882 Castleyn, George, of Retherfeld, husbandman 0
4119232 2067171 2067171 defendant Hosmer Stephen husbandman 588882 588882 Hosmer, Stephen, of Retherfeld, husbandman 1
4130977 2071391 2071391 defendant Hylles George husbandman 588882 588882 Hylles, George, of Retherfeld, husbandman 0
4140075 2074695 2074695 defendant Yong Richard   588882 588882 Yong, Richard, of Retherfeld, sheath maker 0
4149313 2077885 2077885 defendant Johnson John   588882 588882 Johnson, John, of Retherfeld, gun founder 0
4149315 2077885 2077885 defendant Peryman George husbandman 588882 588882 Peryman, George, of Retherfeld, husbandman 2
4167004 2083962 2083962 defendant Muncke Henry husbandman 588882 588882 Muncke, Henry, of Retherfeld, husbandman 0
4175506 2086905 2086905 defendant Farmer George   588882 588882 Farmer, George, of Retherfeld, mason 0
4175507 2086905 2086905 defendant Atkyn George tailor 588882 588882 Atkyn, George, of Retherfeld, tailor 1
4175508 2086905 2086905 defendant A Lye Edward tailor 588882 588882 A Lye, Edward, of Retherfeld, tailor 2
4216003 2101090 2101090 defendant Terrey Ralph yeoman 588882 588882 Terrey, Ralph, of Retherfeld, yeoman 2
4219355 2102266 2102266 defendant Lucke Edward yeoman 588882 588882 Lucke, Edward, of Retherfeld, yeoman 0
4219370 2102273 2102273 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4226408 2104708 2104708 defendant Alchorne alias Allchyn Abraham husbandman 588882 588882 Alchorne alias Allchyn, Abraham, of Retherfeld, husbandman 2
4229078 2105653 2105653 defendant Terrye Ralph yeoman 588882 588882 Terrye, Ralph, of Retherfeld, yeoman 0
4237586 2108737 2108737 defendant Paler alias Cowper John, senior yeoman 588882 588882 Paler alias Cowper, John, senior, of Retherfeld, yeoman 0
4289875 2126439 2126439 defendant Paler John yeoman 588882 588882 Paler, John, of Retherfeld, yeoman 0
4297418 2129181 2129181 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4309377 2133438 2133438 defendant Alchorne William carpenter 588882 588882 Alchorne, William, of Retherfeld, carpenter 0
4318722 2136657 2136657 defendant Hilles George yeoman 588882 588882 Hilles, George, of Retherfeld, yeoman 1
4327104 2139398 2139398 defendant Luck Edward yeoman 588882 588882 Luck, Edward, of Retherfeld, yeoman 0
4327231 2139434 2139434 defendant Muddle John smith 588882 588882 Muddle, John, of Retherfeld, yeoman, smith 0
4330327 2140447 2140447 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4331177 2140725 2140725 defendant Paler alias Cooper John yeoman 588882 588882 Paler alias Cooper, John, of Retherfeld, yeoman 0
4331179 2140726 2140726 defendant Paler alias Cooper John yeoman 588882 588882 Paler alias Cooper, John, of Retherfeld, yeoman 0
4359828 2150678 2150678 defendant Brigman Lewis husbandman 588882 588882 Brigman, Lewis, of Retherfeld, husbandman 0
4364769 2152453 2152453 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4364772 2152454 2152454 defendant Goldsmyth John smith 588882 588882 Goldsmyth, John, of Retherfeld, smith 0
4368748 2153875 2153875 defendant Paler John yeoman 588882 588882 Paler, John, of Retherfeld, yeoman 0
4368750 2153876 2153876 defendant Farmer Alexander   588882 588882 Farmer, Alexander, of Retherfeld, yeoman, son of Thomas 0
4374381 2155904 2155904 defendant Stempe John gent 588882 588882 Stempe, John, of Retherfeld, gent 0
4375447 2156273 2156273 defendant Hylles George yeoman 588882 588882 Hylles, George, of Retherfeld, yeoman 0
4375448 2156273 2156273 defendant Paler alias Cooper John, senior yeoman 588882 588882 Paler alias Cooper, John, senior, of Retherfeld, yeoman 1
4379930 2157924 2157924 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4379933 2157925 2157925 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4379934 2157925 2157925 defendant Burges Nicholas yeoman 588882 588882 Burges, Nicholas, of Retherfeld, yeoman 1
4391934 2161928 2161928 defendant Modle or Muddle John smith 588882 588882 Modle or Muddle, John, of Retherfeld, smith 1
4409030 2167624 2167624 defendant Burges William clerk 588882 588882 Burges, William, of Retherfeld, clerk 0
4409032 2167625 2167625 defendant Stempe John yeoman 588882 588882 Stempe, John, of Retherfeld, yeoman 0
4444086 2183124 2183124 defendant Grey Robert   588882 588882 Grey, Robert, of Retherfeld, knight 0
4449935 2184934 2184934 defendant Blakkele John   588882 588882 Blakkele, John, of Retherfeld 0
4508852 2203245 2203245 defendant Doune Thomas   588882 588882 together with Doune, Thomas, of Retherfeld 4
4508854 2203245 2203245 defendant Chapman John   588882 588882 Chapman, John, of Retherfeld 6
4523968 2207829 2207829 defendant Hert John   588882 588882 Hert, John, of Retherfeld 0
4572030 2222819 2222819 defendant Daly John   588882 588882 Daly, John, of Retherfeld 2
4572054 2222825 2222825 defendant Baly John   588882 588882 Baly, John, of Retherfeld 6
4580172 2225287 2225287 defendant Catte Nicholas   588882 588882 Catte, Nicholas, of Retherfeld 1
4664992 2250532 2250532 defendant Salter Nicholas   588882 588882 Salter, Nicholas, of Retherfeld 0
4675311 2257888 2257888 plaintiff Filkenerssh Letitia   588882 588882 Filkenerssh, Letitia, of Retherfeld, formerly wife of Richard Filkenerssh 0
4675312 2257888 2257888 defendant Rynlegh or Ryvlegh Richard smith 588882 588882 Rynlegh or Ryvlegh, Richard, of Retherfeld, smith 0
4675345 2257898 2257898 defendant Bailly Ralph   588882 588882 Bailly, Ralph, of Retherfeld 4
4677297 2258518 2258518 defendant Maynard Richard husbandman 588882 588882 Maynard, Richard, of Retherfeld, husbandman 0
4677905 2258705 2258705 defendant Salter Nicholas   588882 588882 Salter, Nicholas, of Retherfeld 0
4678966 2259030 2259030 plaintiff Incherede Thomas   588882 588882 Incherede, Thomas, of Retherfeld 0
4690928 2262692 2262692 defendant Inchered Thomas draper 588882 588882 Inchered, Thomas, of Retherfeld, draper 2
4702531 2266204 2266204 defendant Cheseman William cynyer or cyvyer or seive maker 588882 588882 together with Cheseman, William, of Retherfeld, cynyer or cyvyer or seive maker 1
4715880 2270280 2270280 defendant Welyng John laborer 588882 588882 Welyng, John, of Retherfeld, laborer 0
4729671 2274491 2274491 defendant Fermour Walter shingler 588882 588882 Fermour, Walter, of Retherfeld, shingler 0
4748725 2280113 2280113 defendant Frye Thomas chapman 588882 588882 Frye, Thomas, of Retherfeld, chapman 0
4748726 2280113 2280113 defendant Frye John thatcher 588882 588882 Frye, John, of Retherfeld, thatcher 1
4748728 2280114 2280114 defendant Frye Thomas chapman 588882 588882 Frye, Thomas, of Retherfeld, chapman 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);