names

104 rows where place_id = 589569

✎ 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
3598025 1867007 1867007 defendant Grundesburgh William yeoman 589569 589569 Grundesburgh, William, of Westwyk, yeoman 0
3598028 1867008 1867008 defendant Grundesburgh William yeoman 589569 589569 Grundesburgh, William, of Westwyk, yeoman 0
3639847 1907277 1907277 plaintiff Wulcy Nicholas   589569 589569 Wulcy, Nicholas, of Westwyk 0
3639850 1907277 1907277 defendant Deye John   589569 589569 Deye, John, of Westwyk, worsted weaver 2
3704365 1927667 1927667 defendant Cok Thomas   589569 589569 Cok, Thomas, of Westwyk, worsted weaver 0
3704381 1927670 1927670 defendant Cok Thomas   589569 589569 Cok, Thomas, of Westwyk, worsted weaver 2
3737293 1937901 1937901 plaintiff Leny or Levy William   589569 589569 (Leny or Levy, William, of Westwyk 1
3737295 1937901 1937901 defendant Cok John   589569 589569 Cok, John, of Westwyk, worsted weaver 0
3740167 1938783 1938783 defendant Coke John   589569 589569 Coke, John, of Westwyk, worsted weaver 0
3740177 1938786 1938786 defendant Bronde Robert   589569 589569 Bronde, Robert, of Westwyk, worsted weaver 3
3750312 1942013 1942013 defendant Bolt Robert   589569 589569 Bolt, Robert, of Westwyk, worsted weaver 0
3768824 1947896 1947896 defendant Boltte Robert   589569 589569 Boltte, Robert, of Westwyk, worsted weaver 4
3783051 1952452 1952452 defendant Cok John   589569 589569 Cok, John, of Westwyk, worsted weaver 0
3783052 1952452 1952452 defendant Bolt Robert (legal representative) 589569 589569 Bolt, Robert, of Westwyk, worsted weaver, executors of 1
3783053 1952452 1952452 defendant Nobold Thomas husbandman 589569 589569 (Nobold, Thomas, of Westwyk, husbandman 2
3805524 1959668 1959668 defendant Cok John   589569 589569 Cok, John, of Westwyk, worsted weaver 0
3805526 1959669 1959669 defendant Cok John   589569 589569 Cok, John, of Westwyk, worsted weaver 0
3810035 1961027 1961027 defendant Cok John   589569 589569 Cok, John, of Westwyk, worsted weaver 1
3831862 1967860 1967860 defendant Cok Edward clerk 589569 589569 Cok, Edward, of Westwyk, clerk 0
3833175 1968306 1968306 defendant Thorne Thomas yeoman 589569 589569 Thorne, Thomas, of Westwyk, yeoman 0
3848664 1973167 1973167 defendant Coke John   589569 589569 Coke, John, of Westwyk, worsted weaver 0
3848665 1973167 1973167 defendant Coke Thomas   589569 589569 Coke, Thomas, of Westwyk, worsted weaver 1
3851259 1973990 1973990 defendant Wymer Thomas   589569 589569 Wymer, Thomas, of Westwyk, worsted weaver 0
3854063 1974906 1974906 defendant Wymer Thomas   589569 589569 Wymer, Thomas, of Westwyk, worsted weaver 0
4489896 2197547 2197547 defendant Page Richard   589569 589569 Page, Richard, of Westwyk 0
4517300 2205812 2205812 defendant Tooke Thomas weaver 589569 589569 Tooke, Thomas, of Westwyk, weaver 0
4545264 2214440 2214440 defendant Whyght John weaver 589569 589569 Whyght, John, of Westwyk, weaver 0
4550062 2215958 2215958 defendant Page Richard   589569 589569 Page, Richard, of Westwyk 0
4550063 2215958 2215958 defendant Page Thomas   589569 589569 Page, Thomas, of Westwyk 1
4550065 2215959 2215959 defendant Page Richard   589569 589569 Page, Richard, of Westwyk 0
4550066 2215959 2215959 defendant Page Thomas   589569 589569 Page, Thomas, of Westwyk 1
4565804 2220861 2220861 defendant Colt Richard   589569 589569 Colt, Richard, of Westwyk 1
4604934 2232705 2232705 defendant dorkyn William   589569 589569 dorkyn, William, of Westwyk, parson 0
4619054 2236952 2236952 defendant Belabouche Richard   589569 589569 Belabouche, Richard, of Westwyk 0
4630356 2240402 2240402 defendant Cok Richard   589569 589569 Cok, Richard, of Westwyk 1
4680167 2259406 2259406 plaintiff Ledes Eleanor de esq 589569 589569 Ledes, Eleanor de, of Westwyk, formerly wife of Thomas de Ledes, esq 0
4680171 2259407 2259407 plaintiff Ledes Eleanor de esq 589569 589569 Ledes, Eleanor de, of Westwyk, formerly wife of Thomas de Ledes, esq, on her own account 0
4696738 2264457 2264457 defendant Pauncesford John husbandman 589569 589569 Pauncesford, John, of Westwyk, husbandman 1
4733526 2275661 2275661 defendant Cuttyng John   589569 589569 Cuttyng, John, of Westwyk, parson 0
4739347 2277393 2277393 defendant Marten John yeoman 589569 589569 Marten, John, of Westwyk, yeoman 1
4742100 2278182 2278182 defendant Herw--- Thomas yeoman 589569 589569 Herw---, Thomas, of Westwyk, yeoman 4
4782721 2290611 2290611 defendant Herward Thomas husbandman 589569 589569 Herward, Thomas, of Westwyk, husbandman 0
4789668 2292838 2292838 plaintiff Cuttyng John   589569 589569 Cuttyng, John, of Westwyk 3
4839077 2308151 2308151 defendant Baker Clement husbandman 589569 589569 Baker, Clement, of Westwyk, husbandman 0
4839080 2308152 2308152 defendant Baker Clement husbandman 589569 589569 Baker, Clement, of Westwyk, husbandman 0
4856989 2313566 2313566 defendant Sterlyng John, junior weaver 589569 589569 Sterlyng, John, junior, of Westwyk, weaver 2
4872334 2318310 2318310 defendant Bere William husbandman 589569 589569 Bere, William, of Westwyk, husbandman 0
4943306 2339879 2339879 defendant Copeland Thomas merchant 589569 589569 Copeland, Thomas, of Westwyk, gent, or of York, merchant 4
4952468 2342695 2342695 defendant Coupeland Thomas gent 589569 589569 Coupeland, Thomas, of Westwyk, gent 3
4984630 2352334 2352334 defendant Pampyng John chapman 589569 589569 Pampyng, John, of Westwyk, chapman 4
4984636 2352335 2352335 defendant Pampyng John chapman 589569 589569 Pampyng, John, of Westwyk, chapman 4
4984671 2352343 2352343 defendant Hole Richard husbandman 589569 589569 Hole, Richard, of Westwyk, husbandman 7
4996107 2355693 2355693 plaintiff Grondesburgh John   589569 589569 Grondesburgh, John, of Westwyk 2
4997757 2356185 2356185 defendant Ledes Thomas esq 589569 589569 Ledes, Thomas, of Westwyk, esq 0
5060362 2374676 2374676 defendant Cok Thomas worstedman 589569 589569 Cok, Thomas, of Westwyk, worstedman 0
5092945 2384322 2384322 defendant Cok Thomas   589569 589569 Cok, Thomas, of Westwyk, worsted man 0
5105458 2388038 2388038 defendant Bolt Richard husbandman 589569 589569 Bolt, Richard, of Westwyk, husbandman 0
5105466 2388040 2388040 defendant Jullys William   589569 589569 Jullys, William, of Westwyk, worsted weaver 0
5116245 2391182 2391182 plaintiff Oldebarley Thomas   589569 589569 Oldebarley, Thomas, of Westwyk 0
5130664 2395457 2395457 defendant Groundesburgh John husbandman 589569 589569 Groundesburgh, John, of Westwyk, husbandman 5
5136891 2397309 2397309 defendant Frank Adam husbandman 589569 589569 Frank, Adam, of Westwyk, husbandman 3
5144617 2399583 2399583 defendant Wyrme William laborer 589569 589569 Wyrme, William, of Westwyk, laborer 3
5157449 2403314 2403314 defendant Frank Adam husbandman 589569 589569 Frank, Adam, of Westwyk, husbandman 3
5157456 2403315 2403315 defendant Frank Adam husbandman 589569 589569 Frank, Adam, of Westwyk, husbandman 3
5160541 2404175 2404175 plaintiff Smyth John (legal representative) 589569 589569 Smyth, John, of Westwyk, executors of 0
5175308 2408471 2408471 plaintiff Smyth John (legal representative) 589569 589569 Smyth, John, of Westwyk, executors of 0
5182573 2410657 2410657 plaintiff Cok Thomas   589569 589569 Cok, Thomas, of Westwyk 0
5199991 2415752 2415752 defendant Ledes Thomas gent 589569 589569 Ledes, Thomas, of Westwyk, gent 0
5199992 2415752 2415752 defendant Ledes Roger gent 589569 589569 Ledes, Roger, of Westwyk, gent 1
5220474 2421684 2421684 defendant Deyney or Deyvey Nicholas husbandman 589569 589569 Deyney or Deyvey, Nicholas, of Westwyk, husbandman 0
5239982 2427269 2427269 defendant Groundeburgh John yeoman 589569 589569 Groundeburgh, John, of Westwyk, yeoman 0
5270627 2436506 2436506 defendant Inglet John   589569 589569 Inglet, John, of Westwyk, worsted weaver 3
5271465 2436748 2436748 plaintiff Groundisburgh John   589569 589569 Groundisburgh, John, of Westwyk 0
5336957 2456125 2456125 defendant Suthed Thomas baker 589569 589569 Suthed, Thomas, of Westwyk, baker 0
5336958 2456125 2456125 defendant Tober or Touer Robert husbandman 589569 589569 Tober or Touer, Robert, of Westwyk, husbandman 1
5344999 2458597 2458597 defendant Merston John husbandman 589569 589569 Merston, John, of Westwyk, husbandman 0
5357488 2462408 2462408 defendant Harryes Henry husbandman 589569 589569 Harryes, Henry, of Westwyk, husbandman 1
5358419 2462684 2462684 defendant Lullys John   589569 589569 Lullys, John, of Westwyk, worsted weaver 3
5359161 2462903 2462903 defendant Heynes Nicholas baker 589569 589569 Heynes, Nicholas, of Westwyk, baker 1
5371031 2466528 2466528 defendant Feyth John yeoman 589569 589569 Feyth, John, of Westwyk, yeoman 0
5380966 2469613 2469613 defendant Feyth John   589569 589569 Feyth, John, of Westwyk, chief worsted weaver 1
5394313 2473440 2473440 defendant Feyth John yeoman 589569 589569 Feyth, John, of Westwyk, yeoman 0
5395881 2473909 2473909 defendant Feyth John   589569 589569 Feyth, John, of Westwyk, worsted weaver 0
5420744 2481130 2481130 defendant Feyth John yeoman 589569 589569 Feyth, John, of Westwyk, yeoman 0
5448434 2489427 2489427 defendant Gase John husbandman 589569 589569 Gase, John, of Westwyk, husbandman 4
5450067 2489909 2489909 defendant (illegible) Thomas clerk 589569 589569 _, Thomas, of Westwyk, clerk 3
5460742 2493158 2493158 defendant Gase John husbandman 589569 589569 Gase, John, of Westwyk, husbandman 4
5460765 2493165 2493165 defendant Gase John husbandman 589569 589569 Gase, John, of Westwyk, husbandman 4
5462239 2493608 2493608 defendant Oldman Thomas clerk 589569 589569 Oldman, Thomas, of Westwyk, clerk 2
5472339 2496693 2496693 defendant Gase John husbandman 589569 589569 Gase, John, of Westwyk, husbandman 3
5472346 2496694 2496694 defendant Base John husbandman 589569 589569 Base, John, of Westwyk, husbandman 4
5478096 2498475 2498475 defendant Feyth John   589569 589569 Feyth, John, of Westwyk, worsted weaver 0
5478100 2498477 2498477 defendant Feyth John   589569 589569 Feyth, John, of Westwyk, worsted weaver 0
5484926 2500415 2500415 defendant Bolt Henry   589569 589569 Bolt, Henry, of Westwyk, worsted weaver 0
5484933 2500416 2500416 defendant Bolt Henry   589569 589569 Bolt, Henry, of Westwyk, worsted weaver 0
5484939 2500416 2500416 defendant Gardyner John laborer 589569 589569 Gardyner, John, of Westwyk, laborer 6
5485001 2500435 2500435 defendant Gardener John laborer 589569 589569 Gardener, John, of Westwyk, laborer 2
5485003 2500435 2500435 defendant Bolte Henry   589569 589569 together with Bolte, Henry, of Westwyk, worsted weaver 4
5485163 2500482 2500482 defendant Oldman Thomas clerk 589569 589569 Oldman, Thomas, of Westwyk, clerk 3
5488023 2501308 2501308 defendant Bolt Henry   589569 589569 Bolt, Henry, of Westwyk, worsted weaver 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);