names

151 rows where place_id = 604131

✎ 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
3656953 1912432 1912432 defendant Jemys John carrier 604131 604131 Jemys, John, of Winchester, Hants, carrier 1
3662899 1914309 1914309 defendant Burley James yeoman 604131 604131 Burley, James, of Winchester, Hants, yeoman 0
3726449 1934540 1934540 defendant Charde John carpenter 604131 604131 Charde, John, of Winchester, Hants, carpenter 0
3785655 1953304 1953304 defendant Marteyn Thomas baker 604131 604131 Marteyn, Thomas, of Winchester, Hants, baker 0
3866907 1979169 1979169 defendant Bedham Stephen clothier 604131 604131 Bedham, Stephen, of Winchester, Hants, clothier 1
3930884 2000670 2000670 defendant Poynell John   604131 604131 Poynell, John, of Winchester, Hants 0
3930894 2000672 2000672 defendant Poynett John clerk 604131 604131 (Poynett, John, of Winchester, Hants, clerk 1
4038345 2038354 2038354 defendant Bowrde Richard chapman 604131 604131 Bowrde, Richard, of Winchester, Hants, chapman 1
4244181 2111037 2111037 defendant Warneforde Richard gent 604131 604131 Warneforde, Richard, of Winchester, Hants, gent 0
4267745 2118843 2118843 defendant Warneforde Richard gent 604131 604131 Warneforde, Richard, of Winchester, Hants, gent 0
4292297 2127309 2127309 defendant Cotton Henry clerk 604131 604131 Cotton, Henry, of Winchester, Hants, clerk 2
4668710 2255928 2255928 defendant Parker Richard yeoman 604131 604131 Parker, Richard, of Winchester, Hants, yeoman 1
4671025 2256607 2256607 plaintiff Byngham William   604131 604131 Byngham, William, of Winchester, Hants 0
4671027 2256608 2256608 plaintiff Byngham William   604131 604131 Byngham, William, of Winchester, Hants 0
4685113 2260946 2260946 defendant Pomeray Richard sanger 604131 604131 Pomeray, Richard, of Winchester, Hants, sanger 0
4694449 2263757 2263757 defendant Frenshe John mercer 604131 604131 Frenshe, John, of Winchester, Hants, mercer 0
4709631 2268375 2268375 defendant Colvyle Richard carrier 604131 604131 Colvyle, Richard, of Winchester, Hants, carrier 0
4711832 2269029 2269029 defendant Frensshe John husbandman 604131 604131 Frensshe, John, of Winchester, Hants, husbandman 0
4719658 2271494 2271494 defendant Frensshe John mercer 604131 604131 Frensshe, John, of Winchester, Hants, mercer 0
4722760 2272435 2272435 defendant Hayne Thomas   604131 604131 Hayne, Thomas, of Winchester, Hants, brass worker 0
4723011 2272506 2272506 defendant Frye William   604131 604131 (Frye, William, of Winchester, Hants, cook 6
4745313 2279141 2279141 defendant Move or Mone John   604131 604131 Move or Mone, John, of Winchester, Hants, tapestry maker 4
4751109 2280802 2280802 defendant Ferrour Thomas yeoman 604131 604131 Ferrour, Thomas, of Winchester, Hants, yeoman 3
4751115 2280803 2280803 defendant Ferrour Thomas yeoman 604131 604131 Ferrour, Thomas, of Winchester, Hants, yeoman 3
4758797 2283104 2283104 defendant Colpays Robert husbandman 604131 604131 (Colpays, Robert, of Winchester, Hants, husbandman 1
4760309 2283577 2283577 defendant Battes Felicia widow 604131 604131 Battes, Felicia, of Winchester, Hants, widow 0
4766044 2285369 2285369 defendant Choude John merchant 604131 604131 Choude, John, of Winchester, Hants, merchant 2
4768708 2286191 2286191 defendant Brasyer Thomas   604131 604131 Brasyer, Thomas, of Winchester, Hants, brass worker 2
4769652 2286485 2286485 defendant Colvyle Richard carrier 604131 604131 Colvyle, Richard, of Winchester, Hants, carrier 0
4770191 2286649 2286649 defendant Cager Roger butcher 604131 604131 Cager, Roger, of Winchester, Hants, butcher 0
4809161 2299042 2299042 defendant Frounmond William merchant 604131 604131 Frounmond, William, of winchester, Hants, merchant 0
4809163 2299043 2299043 defendant Frommond William merchant 604131 604131 Frommond, William, of Winchester, Hants, merchant 0
4810219 2299341 2299341 defendant Peverell Thomas chapman 604131 604131 Peverell, Thomas, of Winchester, Hants, chapman 1
4821210 2302714 2302714 defendant Gardyner Thomas   604131 604131 Gardyner, Thomas, of Winchester, Hants, wen--- 0
4824071 2303602 2303602 defendant Mathewe William chandler 604131 604131 Mathewe, William, of Winchester, Hants, chandler 0
4826207 2304232 2304232 defendant Lospmasse John de merchant 604131 604131 Lospmasse, John de, of Winchester, Hants, merchant 0
4834045 2306653 2306653 defendant Colkewe John merchant 604131 604131 Colkewe, John, of Winchester, hants, merchant 0
4838912 2308101 2308101 defendant Keswyk Henry gent 604131 604131 Keswyk, Henry, of Winchester, Hants, gent 0
4838914 2308102 2308102 defendant Kestwyk Henry gent 604131 604131 Kestwyk, Henry, of Winchester, Hants, gent 0
4840837 2308670 2308670 plaintiff Hulle Peter fuller 604131 604131 Hulle, Peter, of Winchester, Hants, fuller 0
4843991 2309633 2309633 defendant Rungevere John chapman 604131 604131 Rungevere, John, of Winchester, Hants, chapman 2
4844013 2309637 2309637 defendant Rungevere of Rungebere John chapman 604131 604131 Rungevere of Rungebere, John, of Winchester, Hants, chapman 2
4845657 2310153 2310153 defendant Laweney Thomas dyer 604131 604131 Laweney, Thomas, of Winchester, Hants, dyer 0
4987016 2353059 2353059 defendant Alceter John husbandman 604131 604131 (Alceter, John, of Winchester, Hants, husbandman 1
5002415 2357615 2357615 defendant Wellys William yeoman 604131 604131 Wellys, William, of Winchester, Hants, yeoman 0
5003500 2357920 2357920 defendant Wolstone Ralph skinner 604131 604131 Wolstone, Ralph, of Winchester, Hants, skinner 1
5003506 2357921 2357921 defendant Wolstone Ralph skinner 604131 604131 Wolstone, Ralph, of Winchester, Hants, skinner 2
5004943 2358341 2358341 defendant Gylford Robert yeoman 604131 604131 Gylford, Robert, of Winchester, Hants, yeoman 1
5004946 2358342 2358342 defendant Gylford Robert yeoman 604131 604131 Gylford, Robert, of Winchester, Hants, yeoman 1
5011919 2360339 2360339 plaintiff Wryther John   604131 604131 Wryther, John, of Winchester, Hants 0
5040411 2368735 2368735 defendant Kent Thomas butcher 604131 604131 Kent, Thomas, of Winchester, Hants, butcher 0
5040488 2368763 2368763 defendant Dyer John chaplain 604131 604131 Dyer, John, of Winchester, Hants, chaplain 0
5044314 2369931 2369931 defendant Lee Henry butcher 604131 604131 Lee, Henry, of Winchester, Hants, butcher 0
5048160 2371077 2371077 defendant Reyner Thomas mercer 604131 604131 Reyner, Thomas, of Winchester, Hants, mercer 0
5129988 2395258 2395258 defendant Worseley George yeoman 604131 604131 Worseley, George, of Winchester, Hants, yeoman 0
5149468 2400977 2400977 defendant Worseley George yeoman 604131 604131 Worseley, George, of Winchester, Hants, yeoman 0
5152515 2401872 2401872 defendant Reson Robert merchant 604131 604131 Reson, Robert, of Winchester, Hants, merchant 1
5158790 2403696 2403696 defendant Coteler John chapman 604131 604131 Coteler, John, of Winchester, Hants, chapman 1
5168394 2406474 2406474 defendant Worseley George yeoman 604131 604131 Worseley, George, of Winchester, Hants, yeoman 0
5168406 2406476 2406476 defendant Robert Raymond vintner 604131 604131 Robert, Raymond, of Winchester, Hants, vintner 0
5174193 2408152 2408152 defendant Coteler John chapman 604131 604131 Coteler, John, of Winchester, Hants, chapman 1
5180250 2409963 2409963 defendant Pece William merchant 604131 604131 Pece, William, of Winchester, Hants, merchant 0
5188045 2412215 2412215 defendant Glaser Stephen glasier 604131 604131 Glaser, Stephen, of Winchester, Hants, glasier 0
5188047 2412216 2412216 defendant Glaser Stephen glasier 604131 604131 Glaser, Stephen, of Winchester, Hants, glasier 0
5188049 2412217 2412217 defendant Glaser Stephen glasier 604131 604131 Glaser, Stephen, of Winchester, Hants, glasier 0
5194721 2414194 2414194 defendant Coteler John chapman 604131 604131 Coteler, John, of Winchester, Hants, chapman 1
5200846 2416009 2416009 defendant Heth Gilbert dyer 604131 604131 Heth, Gilbert, of Winchester, Hants, dyer 0
5200863 2416016 2416016 defendant Heth Gilbert dyer 604131 604131 Heth, Gilbert, of Winchester, Hants, dyer 0
5202316 2416440 2416440 defendant Pece William merchant 604131 604131 Pece, William, of Winchester, Hants, merchant 0
5204499 2417069 2417069 defendant Pece William merchant 604131 604131 Pece, William, of Winchester, Hants, merchant 0
5206012 2417490 2417490 defendant Glaser Stephen glasier 604131 604131 Glaser, Stephen, of Winchester, Hants, glasier 0
5209010 2418368 2418368 defendant Dowene Richard baker 604131 604131 Dowene, Richard, of Winchester, Hants, baker 1
5211517 2419105 2419105 defendant Pece William merchant 604131 604131 Pece, William, of Winchester, Hants, merchant 0
5211665 2419151 2419151 defendant Heth Gilbert dyer 604131 604131 Heth, Gilbert, of Winchester, Hants, dyer 0
5211688 2419160 2419160 defendant Maryies John dyer 604131 604131 Maryies, John, of Winchester, Hants, dyer 0
5211693 2419162 2419162 defendant Wynman John fuller 604131 604131 Wynman, John, of Winchester, Hants, fuller 1
5241133 2427608 2427608 defendant Bole Richard merchant 604131 604131 Bole, Richard, of Winchester, Hants, merchant 2
5275228 2437829 2437829 defendant Salman John clothmaker 604131 604131 Salman, John, of Winchester, Hants, clothmaker 0
5275232 2437830 2437830 defendant Salman John clothmaker 604131 604131 Salman, John, of Winchester, Hants, clothmaker 0
5276785 2438292 2438292 defendant Clerk illegible, junior chapman 604131 604131 Clerk, ---, junior, of Winchester, Hants, chapman 1
5276788 2438293 2438293 defendant Clerk Thomas, junior chapman 604131 604131 Clerk, Thomas, junior, of Winchester, Hants, chapman 1
5297929 2444404 2444404 defendant Quedhampton John gent 604131 604131 Quedhampton, John, of Winchester, Hants, gent 0
5297947 2444411 2444411 defendant Quedhampton John gent 604131 604131 Quedhampton, John, of Winchester, Hants, gent 0
5299688 2444879 2444879 defendant Hamond John gent 604131 604131 Hamond, John, of Winchester, Hants, gent 0
5299692 2444880 2444880 defendant Hamond John gent 604131 604131 Hamond, John, of Winchester, Hants, gent 0
5302263 2445640 2445640 defendant Alysaundyr Henry hosier 604131 604131 Alysaundyr, Henry, of Winchester, Hants, hosier 0
5302401 2445685 2445685 defendant Rougeman Robert yeoman 604131 604131 Rougeman, Robert, of Winchester, Hants, yeoman 0
5305193 2446559 2446559 defendant Grenefeld John gent 604131 604131 Grenefeld, John, of Winchester, Hants, gent 4
5306450 2446917 2446917 defendant Nevyll Thomas fuller 604131 604131 Nevyll, Thomas, of Winchester, Hants, fuller 2
5307334 2447198 2447198 defendant Tylby Joan widow 604131 604131 Tylby, Joan, of Winchester, Hants, widow 0
5307338 2447199 2447199 defendant Tylby Joan widow 604131 604131 Tylby, Joan, of Winchester, Hants, widow 0
5307867 2447370 2447370 defendant Burell Robert gent 604131 604131 Burell, Robert, of Winchester, Hants, gent 0
5308585 2447600 2447600 defendant Wells John gent 604131 604131 Wells, John, of Winchester, Hants, gent 0
5310460 2448165 2448165 defendant Brunley John hosier 604131 604131 Brunley, John, of Winchester, Hants, hosier 1
5310977 2448321 2448321 defendant Crokker Henry chaplain of the New College by Winchester 604131 604131 Crokker, Henry, of Winchester, Hants, chaplain of the New College by Winchester 0
5311380 2448437 2448437 defendant Scherde Oliver chapman 604131 604131 Scherde, Oliver, of Winchester, Hants, chapman 0
5311382 2448438 2448438 defendant Sherde Oliver chapman 604131 604131 Sherde, Oliver, of Winchester, Hants, chapman 0
5369274 2465991 2465991 defendant Hamond John gent 604131 604131 Hamond, John, of Winchester, Hants, gent 0
5369526 2466059 2466059 defendant Barton William gent 604131 604131 Barton, William, of Winchester, Hants, gent 8
5372095 2466867 2466867 defendant Rasshele alias Burton Richard gent 604131 604131 Rasshele alias Burton, Richard, of Winchester, Hants, gent 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);