names

344 rows where place_id = 586119

✎ 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
3587978 1863893 1863893 defendant Lemman William fuller 586119 586119 Lemman, William, of Romsey, fuller 0
3641750 1907871 1907871 defendant Calker John, senior dyer 586119 586119 Calker, John, senior, of Romsey, dyer 1
3641751 1907871 1907871 defendant Calker John, junior merchant 586119 586119 Calker, John, junior, of Romsey, merchant 2
3652477 1911106 1911106 defendant Rey John merchant 586119 586119 Rey, John, of Romsey, merchant 0
3653004 1911270 1911270 defendant Hopwode Robert yeoman 586119 586119 Hopwode, Robert, of Romsey, yeoman 0
3660777 1913635 1913635 defendant Alymsham Richard smith 586119 586119 Alymsham, Richard, of Romsey, smith 0
3662433 1914163 1914163 defendant Norton Robert merchant 586119 586119 Norton, Robert, of Romsey, merchant 0
3679004 1919504 1919504 defendant Hill John yeoman 586119 586119 Hill, John, of Romsey, yeoman 0
3685581 1921642 1921642 defendant Norton Robert clothier 586119 586119 Norton, Robert, of Romsey, clothier 0
3692710 1923908 1923908 defendant Edmond John butcher 586119 586119 Edmond, John, of Romsey, butcher 0
3698959 1925885 1925885 defendant Androson Hans brewer 586119 586119 Androson, Hans, of Romsey, brewer 1
3698960 1925885 1925885 defendant Myller John brewer 586119 586119 Myller, John, of Romsey, brewer 2
3698961 1925885 1925885 defendant Hancok John dyer 586119 586119 Hancok, John, of Romsey, dyer 3
3698963 1925886 1925886 defendant Rychardys John brewer 586119 586119 Rychardys, John, of Romsey, brewer 0
3698964 1925886 1925886 defendant Andrewson Hans brewer 586119 586119 Andrewson, Hans, of Romsey, brewer 1
3698965 1925886 1925886 defendant Miller John brewer 586119 586119 Miller, John, of Romsey, brewer 2
3698966 1925886 1925886 defendant Hancok John dyer 586119 586119 Hancok, John, of Romsey, dyer 3
3699102 1925927 1925927 defendant Bull John brewer 586119 586119 Bull, John, of Romsey, brewer 0
3724851 1934060 1934060 plaintiff Segewike Nicholas merchant 586119 586119 Segewike, Nicholas, of Romsey, merchant 0
3727798 1934963 1934963 defendant Bull John brewer 586119 586119 Bull, John, of Romsey, brewer 0
3754220 1943269 1943269 defendant Ray John yeoman 586119 586119 Ray, John, of Romsey, yeoman 0
3765206 1946783 1946783 defendant Hall Ralph (legal representative) 586119 586119 Hall, Ralph, of Romsey, glover, executors of 0
3765208 1946783 1946783 defendant Knyght Nicholas weaver 586119 586119 Knyght, Nicholas, of Romsey, weaver 2
3765211 1946784 1946784 defendant Golderyng Richard shoemaker 586119 586119 (Golderyng, Richard, of Romsey, shoemaker 1
3765212 1946784 1946784 defendant Knyght Nicholas weaver 586119 586119 Knyght, Nicholas, of Romsey, weaver 2
3773983 1949577 1949577 defendant Norton Robert, junior yeoman 586119 586119 Norton, Robert, junior, of Romsey, yeoman 4
3777033 1950563 1950563 defendant Hall Ralph (legal representative) 586119 586119 Hall, Ralph, of Romsey, glover, executor of 0
3797344 1957059 1957059 defendant Hall Ralph (legal representative) 586119 586119 Hall, Ralph, of Romsey, glover, executor of 0
3903013 1991234 1991234 defendant Hore John sherman 586119 586119 Hore, John, of Romsey, sherman 5
3903376 1991352 1991352 defendant Warner Henry gent 586119 586119 Warner, Henry, of Romsey, gent 0
3903377 1991352 1991352 defendant Clercke Simon yeoman 586119 586119 Clercke, Simon, of Romsey, yeoman 1
4048763 2042006 2042006 defendant Sympson John tailor 586119 586119 Sympson, John, of Romsey, tailor 0
4048767 2042007 2042007 defendant Sympson John tailor 586119 586119 Sympson, John, of Romsey, tailor 0
4129016 2070680 2070680 defendant Parkyns Edith widow 586119 586119 Parkyns, Edith, of Romsey, widow 4
4129022 2070681 2070681 defendant Parkyns Edith widow 586119 586119 Parkyns, Edith, of Romsey, widow 4
4133649 2072368 2072368 defendant Brackeley John clothier 586119 586119 Brackeley, John, of Romsey, clothier 0
4133652 2072369 2072369 defendant Bracklye John clothier 586119 586119 Bracklye, John, of Romsey, clothier 0
4135783 2073125 2073125 defendant Wyndover William mercer 586119 586119 Wyndover, William, of Romsey, mercer 1
4137893 2073910 2073910 defendant Barton John clothier 586119 586119 Barton, John, of Romsey, clothier 1
4140901 2074983 2074983 defendant Brackley John clothier 586119 586119 Brackley, John, of Romsey, clothier 0
4140902 2074983 2074983 defendant Barton George draper 586119 586119 Barton, George, of Romsey, draper 1
4140903 2074983 2074983 defendant Parkyns John hatter 586119 586119 Parkyns, John, of Romsey, haberdasher, hatter 2
4170244 2085089 2085089 defendant Gauntlett John yeoman 586119 586119 Gauntlett, John, of Romsey, yeoman 1
4186863 2090892 2090892 defendant Rychardson Roger clerk 586119 586119 Rychardson, Roger, of Romsey, clerk 0
4190350 2092149 2092149 defendant Bloes John clothier 586119 586119 Bloes, John, of Romsey, clothier 0
4199920 2095522 2095522 defendant Gauntlett John mercer 586119 586119 Gauntlett, John, of Romsey, mercer 2
4200150 2095606 2095606 defendant Dowse George gent 586119 586119 Dowse, George, of Romsey, gent 0
4202639 2096466 2096466 defendant Flemmynge William esq 586119 586119 Flemmynge, William, of Romsey, or of Brodlande, esq 1
4234925 2107767 2107767 defendant Legge Henry beer brewer 586119 586119 Legge, Henry, of Romsey, beer brewer 0
4246668 2111863 2111863 defendant Titcheborne Roger (legal representative) 586119 586119 Titcheborne, Roger, of Romsey, gent, executor of 0
4274760 2121118 2121118 defendant Raynold John, junior yeoman 586119 586119 Raynold, John, junior, of Romsey, yeoman 0
4274761 2121118 2121118 defendant Raynold Robert tanner 586119 586119 Raynold, Robert, of Romsey, tanner 1
4295419 2128448 2128448 defendant Oxforde Robert yeoman 586119 586119 Oxforde, Robert, of Romsey, yeoman 3
4319441 2136907 2136907 defendant Raynold Robert yeoman 586119 586119 Raynold, Robert, of Romsey, yeoman 1
4322778 2138036 2138036 defendant Lavender John husbandman 586119 586119 Lavender, John, of Romsey, husbandman 0
4322779 2138036 2138036 defendant Smythe Anthony (legal representative) 586119 586119 Smythe, Anthony, of Romsey, yeoman, executrix of 1
4322780 2138036 2138036 defendant Smythe Agnes widow 586119 586119 Smythe, Agnes, of Romsey, widow 2
4327646 2139566 2139566 defendant Oxforde Robert yeoman 586119 586119 Oxforde, Robert, of Romsey, yeoman 3
4359606 2150598 2150598 defendant Collye John haberdasher 586119 586119 Collye, John, of Romsey, or of Winchester, haberdasher 0
4361357 2151224 2151224 defendant Vallence Andrew tanner 586119 586119 Vallence, Andrew, of Romsey, tanner 0
4362690 2151714 2151714 defendant Kingswell Anthony gent 586119 586119 Kingswell, Anthony, of Romsey, or of Shallden, gent 2
4365552 2152746 2152746 defendant Mills Geoffrey   586119 586119 Mills, Geoffrey, of Romsey, parchment maker 0
4367604 2153467 2153467 defendant Raynold John yeoman 586119 586119 Raynold, John, of Romsey, yeoman 0
4368846 2153911 2153911 defendant Earle Leonard yeoman 586119 586119 Earle, Leonard, of Romsey, yeoman 0
4369034 2153989 2153989 defendant (not given) Robert vicar of Patye 586119 586119 Patye, Robert, of Romsey, clerk, of vicar of Wymyringe 0
4369035 2153989 2153989 defendant Palmer John husbandman 586119 586119 Palmer, John, of Romsey, or of Cosham, Wymyringe, husbandman 1
4372603 2155275 2155275 defendant Jerome Robert painter 586119 586119 Jerome, Robert, of Romsey, painter 1
4374578 2155967 2155967 defendant Johnson William vintner 586119 586119 Johnson, William, of Romsey, or of Waymouth, vintner 0
4374916 2156088 2156088 defendant Mondey William yeoman 586119 586119 Mondey, William, of Romsey, yeoman 0
4377133 2156897 2156897 defendant Crooke Cuthbert innholder 586119 586119 Crooke, Cuthbert, of Romsey, innholder 0
4379381 2157709 2157709 defendant Man Oliver yeoman 586119 586119 Man, Oliver, of Romsey, or of New Alersford, yeoman 0
4379382 2157709 2157709 defendant Cole Henry yeoman 586119 586119 Cole, Henry, of Romsey, yeoman 1
4380704 2158211 2158211 defendant Barnard John victualer 586119 586119 Barnard, John, of Romsey, butcher, victualer 0
4380705 2158211 2158211 defendant Dalledowne Edward hosier 586119 586119 Dalledowne, Edward, of Romsey, hosier 1
4380706 2158211 2158211 defendant Jerom Robert painter 586119 586119 Jerom, Robert, of Romsey, painter 2
4446669 2183876 2183876 defendant Nichole Adam chapman 586119 586119 Nichole, Adam, of Romsey, chapman 0
4540001 2212780 2212780 defendant Sexteyn Stephen   586119 586119 Sexteyn, Stephen, of Romsey 1
4552114 2216610 2216610 plaintiff Everard Lucy   586119 586119 Everard, Lucy, of Romsey, abbess 0
4608861 2233873 2233873 defendant Pynchon John   586119 586119 Pynchon, John, of Romsey 0
4626354 2239195 2239195 plaintiff Preest Robert   586119 586119 Preest, Robert, of Romsey 0
4639536 2243074 2243074 defendant Marchall John   586119 586119 Marchall, John, of Romsey 4
4657793 2248323 2248323 defendant Kirkeby John   586119 586119 Kirkeby, John, of Romsey 0
4661131 2249307 2249307 defendant Bocher Robert butcher 586119 586119 Bocher, Robert, of Romsey, butcher 0
4661132 2249307 2249307 defendant Sadelere Thomas saddler 586119 586119 Sadelere, Thomas, of Romsey, saddler 1
4661133 2249307 2249307 defendant Whelere Richard wheeler 586119 586119 Whelere, Richard, of Romsey, wheeler 2
4672666 2257093 2257093 defendant Kyrkeby John esq 586119 586119 Kyrkeby, John, of Romsey, esq 0
4672669 2257094 2257094 defendant Kyrkeby John   586119 586119 Kyrkeby, John, of Romsey 0
4678605 2258914 2258914 defendant Love John   586119 586119 Love, John, of Romsey, surgeon 1
4678840 2258984 2258984 defendant Dunmer Richard chapman 586119 586119 (Dunmer, Richard, of Romsey, chapman 5
4682068 2260011 2260011 defendant Dounmere Richard husbandman 586119 586119 Dounmere, Richard, of Romsey, husbandman 0
4693930 2263607 2263607 defendant Godefelawe John fuller 586119 586119 Godefelawe, John, of Romsey, fuller 0
4705963 2267242 2267242 defendant Frogbroke John husbandman 586119 586119 Frogbroke, John, of Romsey, husbandman 0
4706219 2267325 2267325 plaintiff Long Simon dyer 586119 586119 Long, Simon, of Romsey, dyer 0
4718083 2270997 2270997 defendant Michell John smith 586119 586119 Michell, John, of Romsey, smith 0
4723722 2272724 2272724 defendant Balle John tailor 586119 586119 Balle, John, of Romsey, tailor 0
4728252 2274081 2274081 defendant Purdieu Richard fuller 586119 586119 Purdieu, Richard, of Romsey, fuller 0
4728253 2274081 2274081 defendant Purdieu William   586119 586119 Purdieu, William, of Romsey, fuller, servant of Richard 1
4728256 2274082 2274082 defendant Purdieu Richard fuller 586119 586119 Purdieu, Richard, of Romsey, fuller 0
4729630 2274479 2274479 defendant Gore Roger butcher 586119 586119 Gore, Roger, of Romsey, butcher 0
4733007 2275503 2275503 defendant Sextayn John   586119 586119 Sextayn, John, of Romsey, mason 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);