names

145 rows where place_id = 595471

✎ 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
3620598 1874018 1874018 defendant Sandford Randolph esq 595471 595471 Sandford, Randolph, of Whitwell, esq 0
3637039 1906382 1906382 defendant Wyn Richard chaplain 595471 595471 Wyn, Richard, of Whitwell, chaplain 1
3735264 1937263 1937263 defendant Southgate John, senior tanner 595471 595471 Southgate, John, senior, of Whitwell, tanner 0
3741947 1939348 1939348 defendant Hardwyk Thomas   595471 595471 Hardwyk, Thomas, of Whitwell, wheelwright 0
3861023 1977171 1977171 defendant Sowgate John, senior husbandman 595471 595471 Sowgate, John, senior, of Whitwell, husbandman 0
3911932 1994315 1994315 defendant Rye Brian gent 595471 595471 Rye, Brian, of Whitwell, gent 1
3916646 1995940 1995940 defendant Rye Brian gent 595471 595471 Rye, Brian, of Whitwell, gent 0
3943374 2004799 2004799 defendant Brees John yeoman 595471 595471 Brees, John, of Whitwell, yeoman 4
3949355 2006846 2006846 defendant Brese Robert yeoman 595471 595471 Brese, Robert, of Whitwell, yeoman 1
3951098 2007451 2007451 defendant Greaves John husbandman 595471 595471 Greaves, John, of Whitwell, husbandman 0
4039878 2038884 2038884 plaintiff Martyn William yeoman 595471 595471 Martyn, William, of Whitwell, yeoman 0
4048480 2041907 2041907 defendant Spofurthe Richard gent 595471 595471 Spofurthe, Richard, of Whitwell, gent 0
4048482 2041908 2041908 defendant Spofurth Richard gent 595471 595471 Spofurth, Richard, of Whitwell, gent 0
4081167 2053574 2053574 defendant Ballyvaunt Richard husbandman 595471 595471 Ballyvaunt, Richard, of Whitwell, husbandman 4
4116824 2066312 2066312 defendant Woodhed Oliver husbandman 595471 595471 Woodhed, Oliver, of Whitwell, husbandman 0
4116825 2066312 2066312 defendant Chapman alias Collyer William husbandman 595471 595471 Chapman alias Collyer, William, of Whitwell, husbandman 1
4116826 2066312 2066312 defendant Botheman alias Tonge Richard husbandman 595471 595471 Botheman alias Tonge, Richard, of Whitwell, husbandman 2
4116828 2066313 2066313 defendant Woodhedd Edmund husbandman 595471 595471 Woodhedd, Edmund, of Whitwell, husbandman 0
4116829 2066313 2066313 defendant Woodhed Oliver husbandman 595471 595471 Woodhed, Oliver, of Whitwell, husbandman 1
4127835 2070245 2070245 defendant Etherington Thomas gent 595471 595471 Etherington, Thomas, of Whitwell, gent 0
4146473 2076918 2076918 defendant Chapman Edmund shoemaker 595471 595471 Chapman, Edmund, of Whitwell, shoemaker 1
4153754 2079411 2079411 defendant Etherington Thomas gent 595471 595471 Etherington, Thomas, of Whitwell, gent 0
4181553 2089028 2089028 defendant Etherington Thomas gent 595471 595471 Etherington, Thomas, of Whitwell, gent 0
4216492 2101261 2101261 defendant Tiplaidie George gent 595471 595471 Tiplaidie, George, of Whitwell, gent 0
4216571 2101288 2101288 defendant Skilling Agnes widow 595471 595471 Skilling, Agnes, of Whitwell, widow 2
4224273 2103975 2103975 defendant Warde Ralph yeoman 595471 595471 Warde, Ralph, of Whitwell, yeoman 1
4224322 2103991 2103991 defendant Gilbert John husbandman 595471 595471 Gilbert, John, of Whitwell, husbandman 2
4226227 2104643 2104643 defendant Messenger Augustine yeoman 595471 595471 Messenger, Augustine, of Whitwell, yeoman 0
4229571 2105829 2105829 defendant Gilbert Thomas husbandman 595471 595471 Gilbert, Thomas, of Whitwell, husbandman 0
4241042 2109987 2109987 defendant Bert John gent 595471 595471 Bert, John, of Whitwell, or of Wooddallinge, gent 1
4241045 2109988 2109988 defendant Bert John gent 595471 595471 Bert, John, of Whitwell, or of Wooddallinge, gent 1
4241047 2109989 2109989 defendant Drury William baker 595471 595471 Drury, William, of Whitwell, baker 0
4242820 2110590 2110590 defendant Gylbert Thomas husbandman 595471 595471 Gylbert, Thomas, of Whitwell, husbandman 1
4242821 2110590 2110590 defendant Shilling Agnes widow 595471 595471 Shilling, Agnes, of Whitwell, widow 2
4261315 2116750 2116750 defendant Gilbert Thomas husbandman 595471 595471 Gilbert, Thomas, of Whitwell, husbandman 3
4266190 2118332 2118332 defendant Tipladie George gent 595471 595471 Tipladie, George, of Whitwell, gent 0
4285823 2124982 2124982 defendant Parke William husbandman 595471 595471 Parke, William, of Whitwell, husbandman 0
4285824 2124982 2124982 defendant Gilbert Thomas husbandman 595471 595471 Gilbert, Thomas, of Whitwell, husbandman 1
4294499 2128119 2128119 defendant Freman Ralph carpenter 595471 595471 Freman, Ralph, of Whitwell, carpenter 0
4318003 2136408 2136408 defendant Tiplady George gent 595471 595471 Tiplady, George, of Whitwell, gent 2
4320317 2137205 2137205 defendant Randall Robert husbandman 595471 595471 Randall, Robert, of Whitwell, husbandman 3
4321965 2137767 2137767 defendant Smyth John chapman 595471 595471 Smyth, John, of Whitwell, chapman 2
4325267 2138830 2138830 defendant Palmer Roger gent 595471 595471 Palmer, Roger, of Whitwell, gent 0
4335837 2142265 2142265 defendant Cooke George gent 595471 595471 Cooke, George, of Whitwell, gent 0
4335838 2142265 2142265 defendant Park Geoffrey husbandman 595471 595471 Park, Geoffrey, of Whitwell, husbandman 1
4342244 2144569 2144569 defendant Egmer Richard husbandman 595471 595471 Egmer, Richard, of Whitwell, husbandman 0
4342246 2144569 2144569 defendant Gylbert Thomas husbandman 595471 595471 Gylbert, Thomas, of Whitwell, husbandman 2
4345676 2145756 2145756 defendant Tiplady George gent 595471 595471 Tiplady, George, of Whitwell, gent 0
4350988 2147602 2147602 defendant Robert John husbandman 595471 595471 Robert, John, of Whitwell, husbandman 0
4352112 2147972 2147972 defendant Gylbert Thomas husbandman 595471 595471 Gylbert, Thomas, of Whitwell, husbandman 2
4352113 2147972 2147972 defendant Chevelye Margery widow 595471 595471 Chevelye, Margery, of Whitwell, widow 3
4365934 2152853 2152853 defendant Aslaby George gent 595471 595471 Aslaby, George, of Whitwell, gent 0
4365936 2152854 2152854 defendant Aislabye George gent 595471 595471 Aislabye, George, of Whitwell, gent 0
4365938 2152855 2152855 defendant Aslabye George gent 595471 595471 Aslabye, George, of Whitwell, gent 0
4392358 2162070 2162070 defendant Flower John, senior esq 595471 595471 Flower, John, senior, of Whitwell, esq 0
4405226 2166327 2166327 defendant Gylbert Thomas husbandman 595471 595471 Gylbert, Thomas, of Whitwell, husbandman 0
4464959 2189710 2189710 defendant Sturmy Alan   595471 595471 Sturmy, Alan, of Whitwell 4
4464960 2189710 2189710 defendant Shorte John   595471 595471 Shorte, John, of Whitwell 5
4604649 2232617 2232617 defendant Beleamy William   595471 595471 Beleamy, William, of Whitwell 1
4660279 2249046 2249046 defendant Hogeson John yeoman 595471 595471 Hogeson, John, of Whitwell, yeoman 3
4660280 2249046 2249046 defendant Holhed Robert yeoman 595471 595471 Holhed, Robert, of Whitwell, yeoman 4
4706915 2267543 2267543 defendant Kene Williamm husbandman 595471 595471 Kene, Williamm, of Whitwell, husbandman 0
4706916 2267543 2267543 defendant Coleman William husbandman 595471 595471 Coleman, William, of Whitwell, husbandman 1
4706917 2267543 2267543 defendant Dewe John husbandman 595471 595471 Dewe, John, of Whitwell, husbandman 2
4730543 2274752 2274752 defendant Coleman William husbandman 595471 595471 Coleman, William, of Whitwell, husbandman 1
4730544 2274752 2274752 defendant Dewe John husbandman 595471 595471 Dewe, John, of Whitwell, husbandman 2
4742728 2278380 2278380 defendant Shirokes Lambert yeoman 595471 595471 Shirokes, Lambert, of Whitwell, yeoman 0
4759243 2283232 2283232 defendant Shirokes Lambert yeoman 595471 595471 Shirokes, Lambert, of Whitwell, yeoman 0
4798593 2295740 2295740 defendant Roberd William tailor 595471 595471 Roberd, William, of Whitwell, tailor 1
4808493 2298825 2298825 defendant Atkynson Robert husbandman 595471 595471 Atkynson, Robert, of Whitwell, husbandman 0
4811441 2299689 2299689 defendant Cook John yeoman 595471 595471 Cook, John, of Whitwell, yeoman 0
4831055 2305743 2305743 defendant Gonell John husbandman 595471 595471 Gonell, John, of Whitwell, husbandman 0
4831056 2305743 2305743 defendant Whitwell William husbandman 595471 595471 Whitwell, William, of Whitwell, husbandman 1
4882238 2321353 2321353 defendant Stevenson William yeoman 595471 595471 Stevenson, William, of Whitwell, yeoman 0
4897768 2325968 2325968 defendant Newehall Thomas   595471 595471 Newehall, Thomas, of Whitwell, holy water clerk 5
4932913 2336683 2336683 defendant Belagh Peter husbandman 595471 595471 Belagh, Peter, of Whitwell, husbandman 3
4938314 2338363 2338363 defendant Stevenson William yeoman 595471 595471 Stevenson, William, of Whitwell, yeoman 0
5003282 2357858 2357858 defendant Tomson Robert yeoman 595471 595471 Tomson, Robert, of Whitwell, yeoman 2
5003289 2357859 2357859 defendant Tomson Robert yeoman 595471 595471 Tomson, Robert, of Whitwell, yeoman 2
5047852 2370974 2370974 defendant James William yeoman 595471 595471 James, William, of Whitwell, yeoman 0
5064064 2375786 2375786 plaintiff Dykkys Richard   595471 595471 Dykkys, Richard, of Whitwell 1
5121093 2392599 2392599 defendant Golke Thomas husbandman 595471 595471 together with Golke, Thomas, of Whitwell, husbandman 1
5128041 2394676 2394676 defendant Judde Thomas husbandman 595471 595471 Judde, Thomas, of Whitwell, husbandman 2
5128042 2394676 2394676 defendant Palfreman William husbandman 595471 595471 Palfreman, William, of Whitwell, husbandman 3
5156531 2403065 2403065 plaintiff Newerk John clerk 595471 595471 Newerk, John, of Whitwell, clerk 0
5165107 2405539 2405539 defendant Clyffe Nicholas   595471 595471 Clyffe, Nicholas, of Whitwell 0
5172714 2407749 2407749 plaintiff Newerk John   595471 595471 Newerk, John, of Whitwell clerk 0
5224909 2422958 2422958 defendant Reder Nicholas husbandman 595471 595471 Reder, Nicholas, of Whitwell, husbandman 0
5246817 2429234 2429234 defendant Reed Robert husbandman 595471 595471 Reed, Robert, of Whitwell, husbandman 0
5246818 2429234 2429234 defendant Miller Robert husbandman 595471 595471 Miller, Robert, of Whitwell, husbandman 1
5248770 2429761 2429761 defendant Mychell Robert husbandman 595471 595471 Mychell, Robert, of Whitwell, husbandman 11
5255836 2431948 2431948 defendant Rede Robert miller 595471 595471 Rede, Robert, of Whitwell, miller 4
5257313 2432412 2432412 defendant Palfreyman Thomas yeoman 595471 595471 Palfreyman, Thomas, of Whitwell, yeoman 0
5265570 2434987 2434987 defendant Michell Robert husbandman 595471 595471 Michell, Robert, of Whitwell, husbandman 6
5280053 2439240 2439240 defendant Skrymshyre Thomas gent 595471 595471 Skrymshyre, Thomas, of Whitwell, gent 0
5310909 2448293 2448293 defendant Reed Robert miller 595471 595471 Reed, Robert, of Whitwell, miller 0
5360064 2463186 2463186 defendant Denton Thomas clerk 595471 595471 Denton, Thomas, of Whitwell, clerk 0
5366926 2465307 2465307 defendant Duntyng William laborer 595471 595471 Duntyng, William, of Whitwell, laborer 0
5368809 2465833 2465833 defendant Eggemer John husbandman 595471 595471 Eggemer, John, of Whitwell, husbandman 8
5376217 2468156 2468156 defendant Smyth Richard yeoman 595471 595471 Smyth, Richard, of Whitwell, yeoman 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);