names

371 rows where place_id = 588486

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594664 1865961 1865961 defendant Beverley John husbandman 588486 588486 Beverley, John, of Wynterton, husbandman 1
3594665 1865961 1865961 defendant Welton Agnes widow 588486 588486 Welton, Agnes, of Wynterton, widow 2
3594938 1866045 1866045 defendant Geirlond William husbandman 588486 588486 Geirlond, William, of Wynterton, husbandman 0
3600011 1867657 1867657 defendant Grome Thomas husbandman 588486 588486 Grome, Thomas, of Wynterton, husbandman 0
3600014 1867658 1867658 defendant Grome Thomas husbandman 588486 588486 Grome, Thomas, of Wynterton, husbandman 0
3600671 1867857 1867857 defendant Rudde Richard gent 588486 588486 Rudde, Richard, of Wynterton, gent 0
3646768 1909396 1909396 defendant Selston alias Selsthorn Robert merchant 588486 588486 Selston alias Selsthorn, Robert, of Wynterton, merchant 0
3646770 1909397 1909397 defendant Selston alias Selsthorn Robert merchant 588486 588486 Selston alias Selsthorn, Robert, of Wynterton, merchant 0
3691216 1923413 1923413 defendant Bysshopp Edmund yeoman 588486 588486 Bysshopp, Edmund, of Wynterton, yeoman 3
3761333 1945551 1945551 defendant Blanke John mariner 588486 588486 Blanke, John, of Wynterton, mariner 0
3763010 1946061 1946061 defendant Warter John husbandman 588486 588486 Warter, John, of Wynterton, husbandman 0
3763013 1946062 1946062 defendant Warter John husbandman 588486 588486 Warter, John, of Wynterton, husbandman 0
3769591 1948149 1948149 defendant Crane Robert husbandman 588486 588486 Crane, Robert, of Wynterton, husbandman 2
3795299 1956397 1956397 defendant Harman Robert mercer 588486 588486 Harman, Robert, of Wynterton, mercer 1
3813910 1962260 1962260 defendant (not given) Thomas husbandman 588486 588486 Blank, Thomas, of Wynterton, husbandman 4
3818729 1963762 1963762 defendant Beetson James husbandman 588486 588486 Beetson, James, of Wynterton, husbandman 1
3820363 1964248 1964248 plaintiff Porter Thomas   588486 588486 Porter, Thomas, of Wynterton 0
3820364 1964248 1964248 defendant Banke Thomas mariner 588486 588486 Banke, Thomas, of Wynterton, mariner 0
3839542 1970292 1970292 defendant Amond Robert husbandman 588486 588486 Amond, Robert, of Wynterton, husbandman 3
3839549 1970293 1970293 defendant Blanke Thomas mariner 588486 588486 Blanke, Thomas, of Wynterton, mariner 3
3839727 1970351 1970351 defendant Topye John mariner 588486 588486 Topye, John, of Wynterton, mariner 0
3855628 1975400 1975400 defendant Annand Robert husbandman 588486 588486 Annand, Robert, of Wynterton, husbandman 0
3855629 1975400 1975400 defendant Sarse Richard mariner 588486 588486 Sarse, Richard, of Wynterton, mariner 1
3858421 1976293 1976293 defendant Porter Thomas innkeeper 588486 588486 Porter, Thomas, of Wynterton, innkeeper 0
3862798 1977750 1977750 defendant (not given) Thomas mariner 588486 588486 Blank, Thomas, of Wynterton, mariner 0
3868251 1979618 1979618 defendant Myller John   588486 588486 Myller, John, of Wynterton, worsted weaver 0
3875342 1981998 1981998 defendant Annott Robert husbandman 588486 588486 Annott, Robert, of Wynterton, husbandman 0
3894705 1988435 1988435 defendant Rede John husbandman 588486 588486 Rede, John, of Wynterton, husbandman 0
3937138 2002754 2002754 defendant Philipps Robert husbandman 588486 588486 Philipps, Robert, of Wynterton, husbandman 4
3944096 2005044 2005044 defendant Lewod Edmund tailor 588486 588486 Lewod, Edmund, of Wynterton, tailor 2
3948221 2006440 2006440 defendant Saunderston William clerk or merchant 588486 588486 Saunderston, William, of Wynterton, clerk or merchant 0
3953582 2008327 2008327 plaintiff Jaxson John yeoman 588486 588486 Jaxson, John, of Wynterton, yeoman 0
3953584 2008328 2008328 plaintiff Jaxson John yeoman 588486 588486 Jaxson, John, of Wynterton, yeoman 0
3957047 2009530 2009530 defendant Edon Edmund yeoman 588486 588486 Edon, Edmund, of Wynterton, yeoman 0
3959714 2010487 2010487 defendant Phyllypp Robert baker 588486 588486 Phyllypp, Robert, of Wynterton, baker 2
3984349 2019160 2019160 defendant Mulley or Morley John yeoman 588486 588486 Mulley or Morley, John, of Wynterton, yeoman 13
3991096 2021579 2021579 defendant Tompson Robert yeoman 588486 588486 Tompson, Robert, of Wynterton, yeoman 2
3992377 2022040 2022040 defendant Perry Edward husbandman 588486 588486 Perry, Edward, of Wynterton, husbandman 0
4002620 2025708 2025708 defendant Bendy Thomas innkeeper 588486 588486 Bendy, Thomas, of Wynterton, innkeeper 0
4011154 2028756 2028756 defendant Burton Thomas husbandman 588486 588486 Burton, Thomas, of Wynterton, husbandman 0
4011178 2028767 2028767 defendant Burton Thomas husbandman 588486 588486 Burton, Thomas, of Wynterton, husbandman 0
4027422 2034455 2034455 defendant Perye Edward yeoman 588486 588486 Perye, Edward, of Wynterton, yeoman 0
4028978 2035009 2035009 defendant Gye William sawyer 588486 588486 Gye, William, of Wynterton, sawyer 0
4030028 2035384 2035384 defendant Swyfte Anthony fisherman 588486 588486 Swyfte, Anthony, of Wynterton, fisherman 2
4069431 2049349 2049349 defendant Gybbys Edmund butcher 588486 588486 Gybbys, Edmund, of Wynterton, butcher 1
4076933 2052037 2052037 defendant Gybbes Edward yeoman 588486 588486 Gybbes, Edward, of Wynterton, yeoman 0
4078964 2052776 2052776 defendant Spanton William butcher 588486 588486 Spanton, William, of Wynterton, butcher 2
4079624 2053011 2053011 defendant Perry Edward yeoman 588486 588486 Perry, Edward, of Wynterton, yeoman 0
4080173 2053220 2053220 defendant Gybbes Edmund butcher 588486 588486 Gybbes, Edmund, of Wynterton, butcher 0
4090499 2056885 2056885 defendant Perry Edward yeoman 588486 588486 Perry, Edward, of Wynterton, yeoman 0
4091428 2057224 2057224 defendant Freman Mathew husbandman 588486 588486 Freman, Mathew, of Wynterton, husbandman 0
4091431 2057225 2057225 defendant Freman Mathew husbandman 588486 588486 Freman, Mathew, of Wynterton, husbandman 0
4091879 2057391 2057391 defendant Freman Mathew yeoman 588486 588486 Freman, Mathew, of Wynterton, yeoman 0
4128524 2070492 2070492 defendant Burton William yeoman 588486 588486 (Burton, William, of Wynterton, yeoman 1
4155116 2079882 2079882 defendant Smyth Alan smith 588486 588486 Smyth, Alan, of Wynterton, smith 1
4191128 2092462 2092462 defendant Hanny Robert husbandman 588486 588486 Hanny, Robert, of Wynterton, husbandman 0
4191130 2092462 2092462 defendant Burton Thomas husbandman 588486 588486 Burton, Thomas, of Wynterton, husbandman 2
4224461 2104037 2104037 defendant Duckill Stephen yeoman 588486 588486 Duckill, Stephen, of Wynterton, yeoman 0
4230437 2106138 2106138 defendant Norman John yeoman 588486 588486 Norman, John, of Wynterton, yeoman 1
4230571 2106188 2106188 defendant Keybrede or Keyberde Thomas yeoman 588486 588486 Keybrede or Keyberde, Thomas, of Wynterton, yeoman 0
4230874 2106295 2106295 defendant Kyberd Thomas yeoman 588486 588486 Kyberd, Thomas, of Wynterton, or of Yelverton, yeoman 3
4235037 2107806 2107806 defendant Cooke William yeoman 588486 588486 Cooke, William, of Wynterton, yeoman 0
4240983 2109968 2109968 defendant Salmon John fisherman 588486 588486 Salmon, John, of Wynterton, fisherman 0
4249772 2112906 2112906 defendant Garlonde John husbandman 588486 588486 Garlonde John, of Wynterton, husbandman 0
4282892 2123915 2123915 defendant Kyberd Thomas yeoman 588486 588486 Kyberd, Thomas, of Wynterton, or of Yelverton, yeoman 0
4285006 2124686 2124686 defendant Swanton Edward yeoman 588486 588486 Swanton, Edward, of Wynterton, yeoman 1
4286086 2125078 2125078 defendant Raye William yeoman 588486 588486 Raye, William, of Wynterton, yeoman 2
4288887 2126079 2126079 defendant Kyberd Thomas yeoman 588486 588486 Kyberd, Thomas, of Wynterton, yeoman 1
4289991 2126485 2126485 defendant Swanton William husbandman 588486 588486 Swanton, William, of Wynterton, husbandman 0
4292124 2127254 2127254 defendant Shancke John gent 588486 588486 Shancke, John, of Wynterton, gent 1
4294173 2127992 2127992 defendant Steper Richard yeoman 588486 588486 Steper, Richard, of Wynterton, yeoman 3
4316505 2135891 2135891 defendant Shank William gent 588486 588486 Shank, William, of Wynterton, gent 0
4316506 2135891 2135891 defendant Rake Robert husbandman 588486 588486 Rake, Robert, of Wynterton, husbandman 1
4322137 2137822 2137822 defendant Kyberd Thomas yeoman 588486 588486 Kyberd, Thomas, of Wynterton, or of Yelverton, yeoman 0
4331583 2140860 2140860 defendant Cressey Anthony tailor 588486 588486 Cressey, Anthony, of Wynterton, or of Est Somerton, tailor 0
4358819 2150316 2150316 defendant Cleisbie Richard baker 588486 588486 Cleisbie, Richard, of Wynterton, baker 1
4391985 2161948 2161948 defendant Gybbs William butcher 588486 588486 Gybbs, William, of Wynterton, butcher 2
4422529 2171906 2171906 defendant Patfyn John   588486 588486 Patfyn, John, of Wynterton 1
4451334 2185386 2185386 defendant Webstere Richard   588486 588486 Webstere, Richard, of Wynterton 0
4453616 2186143 2186143 defendant Garre William   588486 588486 Garre, William, of Wynterton 0
4453617 2186143 2186143 defendant Craak Richard   588486 588486 Craak, Richard, of Wynterton 1
4453618 2186143 2186143 defendant Fraunceys John   588486 588486 Fraunceys, John, of Wynterton 2
4453619 2186143 2186143 defendant Sleght John   588486 588486 Sleght, John, of Wynterton 3
4453620 2186143 2186143 defendant Halton John de   588486 588486 Halton, John de, of Wynterton 4
4461347 2188631 2188631 plaintiff Stalby Thomas de   588486 588486 Stalby, Thomas de, of Wynterton 0
4461348 2188631 2188631 defendant Dengas Robert   588486 588486 Dengas, Robert, of Wynterton 0
4475169 2192909 2192909 defendant Beverley John   588486 588486 Beverley, John, of Wynterton 0
4502635 2201406 2201406 defendant Alisaundre Robert   588486 588486 Alisaundre, Robert, of Wynterton 0
4505729 2202301 2202301 defendant Godfrey Thomas   588486 588486 Godfrey, Thomas, of Wynterton 0
4506420 2202507 2202507 defendant Faryby John   588486 588486 Faryby, John, of Wynterton 0
4512132 2204240 2204240 defendant Stake John   588486 588486 Stake, John, of Wynterton 1
4512799 2204437 2204437 defendant Broun Richard   588486 588486 Broun, Richard, of Wynterton 2
4512800 2204437 2204437 defendant Neweman Hugh   588486 588486 Neweman, Hugh, of Wynterton 3
4549887 2215898 2215898 plaintiff Craak Robert chaplain 588486 588486 Craak, Robert, of Wynterton, chaplain 0
4563928 2220290 2220290 defendant Hobson Thomas   588486 588486 Hobson, Thomas, of Wynterton 0
4575749 2223925 2223925 defendant Marle Henry   588486 588486 Marle, Henry, of Wynterton 0
4582897 2226079 2226079 defendant Feriby John de   588486 588486 Feriby, John de, of Wynterton 1
4583959 2226401 2226401 defendant Feriby John   588486 588486 Feriby, John, of Wynterton 2
4587923 2227625 2227625 defendant Feriby John   588486 588486 Feriby, John, of Wynterton 0
4592110 2228890 2228890 defendant Richer John   588486 588486 Richer, John, of Wynterton 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);