names

167 rows where place_id = 589133

✎ 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
3596640 1866584 1866584 defendant Mader Thomas husbandman 589133 589133 Mader, Thomas, of Marton, husbandman 0
3619157 1873595 1873595 defendant Calowys William smith 589133 589133 Calowys, William, of Marton, smith 1
3658313 1912854 1912854 defendant Emonson Robert husbandman 589133 589133 Emonson, Robert, of Marton, husbandman 3
3671801 1917174 1917174 defendant Ives John husbandman 589133 589133 Ives, John, of Marton, husbandman 0
3682174 1920530 1920530 defendant Fyche Thomas husbandman 589133 589133 Fyche, Thomas, of Marton, husbandman 1
3716599 1931488 1931488 defendant Ives Richard husbandman 589133 589133 Ives, Richard, of Marton, husbandman 0
3716600 1931488 1931488 defendant Bell John husbandman 589133 589133 Bell, John, of Marton, husbandman 1
3716601 1931488 1931488 defendant Brome Robert   589133 589133 Brome, Robert, of Marton 2
3716602 1931488 1931488 defendant Byllyngey John husbandman 589133 589133 Byllyngey, John, of Marton, husbandman 3
3719279 1932315 1932315 defendant Lancaster John yeoman 589133 589133 Lancaster, John, of Marton, yeoman 2
3737155 1937853 1937853 defendant Atkyns Thomas husbandman 589133 589133 Atkyns, Thomas, of Marton, husbandman 3
3773906 1949552 1949552 defendant Stowell John esq 589133 589133 Stowell, John, of Marton, esq 0
3804975 1959499 1959499 defendant Williams Richard butcher 589133 589133 Williams, Richard, of Marton, butcher 0
3834301 1968672 1968672 defendant Brownell George laborer 589133 589133 Brownell, George, of Marton, laborer 0
3834302 1968672 1968672 defendant Rowland Richard laborer 589133 589133 Rowland, Richard, of Marton, laborer 1
3834303 1968672 1968672 defendant Lambert John laborer 589133 589133 Lambert, John, of Marton, laborer 2
3834304 1968672 1968672 defendant Smyth William laborer 589133 589133 Smyth, William, of Marton, laborer 3
3834305 1968672 1968672 defendant Hanley Richard laborer 589133 589133 Hanley, Richard, of Marton, laborer 4
3834306 1968672 1968672 defendant Thurland Henry laborer 589133 589133 Thurland, Henry, of Marton, laborer 5
3838695 1970028 1970028 defendant Prist James   589133 589133 Prist, James, of Marton, wheelwright 2
3843695 1971558 1971558 defendant Copper Humphrey husbandman 589133 589133 Copper, Humphrey, of Marton, husbandman 1
3846674 1972516 1972516 defendant Coper Humphrey husbandman 589133 589133 Coper, Humphrey, of Marton, husbandman 0
3861204 1977223 1977223 defendant Westley Richard husbandman 589133 589133 Westley, Richard, of Marton, husbandman 0
3877643 1982763 1982763 defendant Pullen Stephen   589133 589133 Pullen, Stephen, of Marton, mason 2
3902617 1991108 1991108 plaintiff Estwode Thomas (legal representative) 589133 589133 Estwode, Thomas, of Marton, husbandman, executors of 0
3937689 2002937 2002937 defendant Edlyng John yeoman 589133 589133 Edlyng, John, of Marton, yeoman 0
3938633 2003263 2003263 defendant Newell Henry clerk 589133 589133 Newell, Henry, of Marton, clerk 4
3944927 2005320 2005320 defendant Jaxson George husbandman 589133 589133 Jaxson, George, of Marton, husbandman 0
3947014 2006019 2006019 defendant Jackson George husbandman 589133 589133 Jackson, George, of Marton, husbandman 0
3949806 2007008 2007008 defendant Beaneland or Beaueland Robert husbandman 589133 589133 Beaneland or Beaueland, Robert, of Marton, husbandman 1
3950714 2007323 2007323 defendant Agard William husbandman 589133 589133 Agard, William, of Marton, husbandman 0
3955664 2009055 2009055 defendant Thompson Alice widow 589133 589133 Thompson, Alice, of Marton, widow 0
3962477 2011469 2011469 defendant Hancocke Richard husbandman 589133 589133 Hancocke, Richard, of Marton, husbandman 0
3982851 2018641 2018641 plaintiff Sheperd Thomas husbandman 589133 589133 Sheperd, Thomas, of Marton, husbandman 0
3990479 2021347 2021347 plaintiff Blackburne Thomas gent 589133 589133 Blackburne, Thomas, of Marton, gent 0
3990481 2021348 2021348 plaintiff Blackburne Thomas gent 589133 589133 Blackburne, Thomas, of Marton, gent 0
3990483 2021349 2021349 plaintiff Blackburne Thomas gent 589133 589133 Blackburne, Thomas, of Marton, gent 0
3990485 2021350 2021350 plaintiff Blackburne Thomas gent 589133 589133 Blackburne, Thomas, of Marton, gent 0
3998452 2024185 2024185 defendant Browne William (legal representative) 589133 589133 Browne, William, of Marton, husbandman, executor of 0
4042575 2039811 2039811 defendant Gyttyns Edmund gent 589133 589133 Gyttyns, Edmund, of Marton, gent 0
4062544 2046896 2046896 defendant Hancox Thomas husbandman 589133 589133 Hancox, Thomas, of Marton, husbandman 0
4063617 2047276 2047276 defendant Bolde Hugh husbandman 589133 589133 Bolde, Hugh, of Marton, husbandman 0
4077320 2052172 2052172 defendant Walker William   589133 589133 Walker, William, of Marton miller 1
4098898 2059934 2059934 defendant Hanmer Roger gent 589133 589133 Hanmer, Roger, of Marton, gent 0
4099841 2060267 2060267 defendant Awderson James chapman 589133 589133 Awderson, James, of Marton, chapman 1
4099846 2060268 2060268 defendant Awderson James chapman 589133 589133 Awderson, James, of Marton, chapman 1
4111251 2064273 2064273 defendant Hancock Thomas husbandman 589133 589133 Hancock, Thomas, of Marton, husbandman 0
4123686 2068773 2068773 defendant Waters Hugh yeoman 589133 589133 Waters, Hugh, of Marton, yeoman 0
4123687 2068773 2068773 defendant Smyth Meredith yeoman 589133 589133 Smyth, Meredith, of Marton, yeoman 1
4128283 2070400 2070400 defendant Smythe Richard husbandman 589133 589133 Smythe, Richard, of Marton, husbandman 0
4128284 2070400 2070400 defendant Smythe Meredith husbandman 589133 589133 Smythe, Meredith, of Marton, husbandman 1
4128285 2070400 2070400 defendant Smythe David husbandman 589133 589133 Smythe, David, of Marton, husbandman 2
4128286 2070400 2070400 defendant John Richard husbandman 589133 589133 John, Richard, of Marton, husbandman 3
4146887 2077063 2077063 defendant Waters Hugh yeoman 589133 589133 Waters Hugh, of Marton, yeoman 0
4146888 2077063 2077063 defendant Smyth Meredith yeoman 589133 589133 Smyth, Meredith, of Marton, yeoman 1
4148716 2077675 2077675 defendant Marcer Richaerd tailor 589133 589133 Marcer, Richaerd, of Marton, tailor 1
4158998 2081214 2081214 defendant Hancox Thomas yeoman 589133 589133 Hancox, Thomas, of Marton, yeoman 0
4167296 2084062 2084062 defendant Blancherd John yeoman 589133 589133 Blancherd, John, of Marton, yeoman 6
4182774 2089455 2089455 defendant Westley Edward husbandman 589133 589133 Westley, Edward, of Marton, husbandman 0
4213401 2100205 2100205 defendant Hancocke Thomas yeoman 589133 589133 Hancocke, Thomas, of Marton, yeoman 0
4215274 2100838 2100838 defendant Maners Thomas husbandman 589133 589133 Maners, Thomas, of Marton, husbandman 1
4215465 2100903 2100903 defendant Dodington John gent 589133 589133 Dodington, John, of Marton, or of Corff Castell, Dorset, gent 0
4218882 2102100 2102100 defendant Taylor John yeoman 589133 589133 Taylor, John, of Marton, yeoman 0
4221888 2103153 2103153 defendant Kirke alias Shorte Hugh yeoman 589133 589133 Kirke alias Shorte, Hugh, of Marton, yeoman 1
4221889 2103153 2103153 defendant Kirke alias Shorte William yeoman 589133 589133 Kirke alias Shorte, William, of Marton, yeoman 2
4221890 2103153 2103153 defendant Kirke alias Shorte Vincent yeoman 589133 589133 Kirke alias Shorte, Vincent, of Marton, yeoman 3
4224700 2104112 2104112 defendant Maners Thomas husbandman 589133 589133 Maners, Thomas, of Marton, husbandman 1
4257843 2115598 2115598 defendant Laton Anthony gent 589133 589133 Laton, Anthony, of Marton, gent 1
4295872 2128618 2128618 defendant Bull William husbandman 589133 589133 Bull, William, of Marton, husbandman 0
4299417 2129882 2129882 defendant Kymson Thomas yeoman 589133 589133 Kymson, Thomas, of Marton, yeoman 0
4316924 2136034 2136034 defendant Tayler John yeoman 589133 589133 Tayler, John, of Marton, yeoman 0
4360665 2150986 2150986 defendant Tayler Thomas clerk 589133 589133 Tayler, Thomas, of Marton, clerk 1
4360670 2150987 2150987 defendant Fletcher Ralph husbandman 589133 589133 Fletcher, Ralph, of Marton, husbandman 2
4391507 2161771 2161771 defendant Cheseman William yeoman 589133 589133 Cheseman, William, of Marton, yeoman 0
4412009 2168609 2168609 defendant Swyer Christopher husbandman 589133 589133 Swyer, Christopher, of Marton, husbandman 0
4455617 2186767 2186767 plaintiff Morby John de   589133 589133 Morby, John de, of Marton, on his own account 0
4460669 2188396 2188396 defendant Scotte Walter   589133 589133 Scotte, Walter, of Marton 0
4475725 2193085 2193085 defendant Stanegrond Alan, junior   589133 589133 Stanegrond, Alan, junior, of Marton 0
4508115 2203012 2203012 defendant Cutelawe John   589133 589133 Cutelawe, John, of Marton 3
4508116 2203012 2203012 defendant Brynham John   589133 589133 Brynham, John, of Marton 4
4534791 2211162 2211162 plaintiff Seriaunt Robert   589133 589133 Seriaunt, Robert, of Marton 0
4539309 2212553 2212553 plaintiff Wace William   589133 589133 Wace, William, of Marton 0
4547880 2215274 2215274 defendant Cokhed John   589133 589133 Cokhed, John, of Marton 0
4552883 2216845 2216845 defendant Clerk John   589133 589133 Clerk, John, of Marton 1
4564612 2220490 2220490 defendant Brytall Thomas   589133 589133 Brytall, Thomas, of Marton 8
4564614 2220490 2220490 defendant Pokethorp Robert   589133 589133 Pokethorp, Robert, of Marton 10
4566336 2221042 2221042 defendant Fyssher Benedict   589133 589133 Fyssher, Benedict, of Marton 0
4567832 2221509 2221509 defendant Baker Richard   589133 589133 Baker, Richard, of Marton 8
4571778 2222759 2222759 defendant Styward William   589133 589133 Styward, William, of Marton 0
4587073 2227365 2227365 defendant Kychen John   589133 589133 Kychen, John, of Marton 3
4673169 2257249 2257249 plaintiff Crathorn Thomas   589133 589133 Crathorn, Thomas, of Marton 0
4705190 2266992 2266992 defendant Tournour John husbandman 589133 589133 Tournour, John, of Marton, husbandman 2
4726079 2273444 2273444 defendant Laysynby Thomas   589133 589133 Laysynby, Thomas, of Marton, franklin 0
4747522 2279780 2279780 defendant Hancok John husbandman 589133 589133 Hancok, John, of Marton, husbandman 1
4753956 2281619 2281619 defendant Monkton Thomas husbandman 589133 589133 Monkton, Thomas, of Marton, husbandman 2
4787609 2292196 2292196 defendant Rawelyn Thomas weaver 589133 589133 Rawelyn, Thomas, of Marton, weaver 2
4787610 2292196 2292196 defendant Clerk Robert husbandman 589133 589133 Clerk, Robert, of Marton, husbandman 3
4800273 2296263 2296263 defendant of Marton Howell husbandman 589133 589133 of Marton, Howell, of Marton, husbandman 2
4803182 2297188 2297188 defendant Strong John husbandman 589133 589133 Strong, John, of Marton, husbandman 0
4803183 2297188 2297188 defendant Wode Thomas carpenter 589133 589133 Wode, Thomas, of Marton, carpenter 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);