names

69 rows where place_id = 588431

✎ 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
3594501 1865911 1865911 defendant Ferrour Eleanor widow 588431 588431 Ferrour, Eleanor, of Tettebury, widow 1
4445070 2183432 2183432 defendant Baker Henry   588431 588431 Baker, Henry, of Tettebury 3
4462040 2188825 2188825 defendant Walters Walter   588431 588431 Walters, Walter, of Tettebury 0
4464808 2189656 2189656 defendant Ramesey John   588431 588431 Ramesey, John, of Tettebury 0
4464810 2189657 2189657 defendant Ramesey John   588431 588431 Ramesey, John, of Tettebury 0
4472663 2192114 2192114 defendant Welyfed John   588431 588431 Welyfed, John, of Tettebury 2
4487167 2196712 2196712 defendant Draper Edmund   588431 588431 Draper, Edmund, of Tettebury 2
4493114 2198548 2198548 defendant Baker Henry   588431 588431 Baker, Henry, of Tettebury 0
4531945 2210257 2210257 defendant Haille Ralph   588431 588431 Haille, Ralph, of Tettebury 0
4541285 2213171 2213171 plaintiff Wolmonger Denis   588431 588431 Wolmonger, Denis, of Tettebury 0
4543486 2213851 2213851 defendant Baker Henry   588431 588431 Baker, Henry, of Tettebury 0
4565949 2220905 2220905 defendant Hayle Richard   588431 588431 Hayle, Richard, of Tettebury 0
4565951 2220905 2220905 defendant Jones John   588431 588431 Jones, John, of Tettebury 2
4565953 2220905 2220905 defendant Sevare John   588431 588431 Sevare, John, of Tettebury 4
4565955 2220905 2220905 defendant Agas Robert   588431 588431 Agas, Robert, of Tettebury 6
4591794 2228788 2228788 defendant Corriour William   588431 588431 Corriour, William, of Tettebury 0
4596640 2230186 2230186 plaintiff Sadeler John   588431 588431 Sadeler, John, of Tettebury 0
4600146 2231271 2231271 defendant Dekene John   588431 588431 Dekene, John, of Tettebury 0
4606316 2233090 2233090 plaintiff Badcok John   588431 588431 Badcok, John, of Tettebury 0
4607524 2233466 2233466 plaintiff Bernard Nicholas   588431 588431 Bernard, Nicholas, of Tettebury 0
4621586 2237738 2237738 defendant Motfont John   588431 588431 Motfont, John, of Tettebury 0
4645494 2244751 2244751 defendant Gilmyn Thomas   588431 588431 Gilmyn, Thomas, of Tettebury 0
4647255 2245251 2245251 defendant Holwey Nicholas   588431 588431 Holwey, Nicholas, of Tettebury 4
4650250 2246094 2246094 defendant Hayle Richard   588431 588431 Hayle, Richard, of Tettebury 2
4653862 2247116 2247116 plaintiff Bernard Nicholas   588431 588431 Bernard, Nicholas, of Tettebury 0
4664048 2250244 2250244 plaintiff Gylmyn Thomas   588431 588431 Gylmyn, Thomas, of Tettebury 0
4664049 2250244 2250244 defendant Bernard Nicholas   588431 588431 Bernard, Nicholas, of Tettebury, Glos husbandman 0
4664050 2250245 2250245 plaintiff Gylmyn Thomas   588431 588431 Gylmyn, Thomas, of Tettebury 0
4680140 2259397 2259397 defendant Whyte John laborer 588431 588431 with Whyte, John, of Tettebury, laborer 2
4680141 2259397 2259397 defendant Swannyng Roger laborer 588431 588431 Swannyng, Roger, of Tettebury, laborer 3
4680145 2259399 2259399 defendant Clerk William   588431 588431 Clerk, William, of Tettebury, holy water clerk 0
4680146 2259399 2259399 defendant Bykeley William cordwainer 588431 588431 Bykeley, William, of Tettebury, cordwainer 1
4680148 2259400 2259400 defendant Toundesende Thomas yeoman 588431 588431 Toundesende, Thomas, of Tettebury, yeoman 0
4680151 2259400 2259400 defendant Clerk William   588431 588431 Clerk, William, of Tettebury, holy water clerk 3
4680152 2259400 2259400 defendant Bykeley William shoemaker 588431 588431 Bykeley, William, of Tettebury, shoemaker 4
4680154 2259401 2259401 defendant White John laborer 588431 588431 White, John, of Tettebury, laborer 0
4680155 2259401 2259401 defendant Swaunynges Roger laborer 588431 588431 Swaunynges, Roger, of Tettebury, laborer 1
4701604 2265895 2265895 defendant Touneshende Thomas yeoman 588431 588431 Touneshende, Thomas, of Tettebury, yeoman 0
4726416 2273545 2273545 defendant Touneshende Thomas yeoman 588431 588431 Touneshende, Thomas, of Tettebury, yeoman 0
4726417 2273546 2273546 plaintiff Gylmyn Thomas   588431 588431 Gylmyn, Thomas, of Tettebury 0
4745966 2279323 2279323 plaintiff Gylmyn Thomas   588431 588431 Gylmyn, Thomas, of Tettebury, on his own account 0
4745967 2279323 2279323 defendant Mygo Richard shoemaker 588431 588431 Mygo, Richard, of Tettebury, shoemaker 0
4745969 2279323 2279323 defendant Haily Richard (legal representative) 588431 588431 Haily, Richard, of Tettebury, executor of William, Gawlok, of Tettebury, executors of 2
4745970 2279323 2279323 defendant Hanly John tanner 588431 588431 (Hanly, John, of Tettebury, tanner 3
4761878 2284058 2284058 plaintiff Estynton John   588431 588431 Estynton, John, of Tettebury 0
4778543 2289272 2289272 plaintiff Bernard Nicholas   588431 588431 Bernard, Nicholas, of Tettebury 0
4812386 2299986 2299986 defendant Baye Thomas yeoman 588431 588431 Baye, Thomas, of Tettebury, yeoman 0
4848296 2310938 2310938 defendant Hathemere William axbrenner or charcoal burner 588431 588431 Hathemere, William, of Tettebury, axbrenner or charcoal burner 1
4903734 2327788 2327788 plaintiff Estynton John butcher 588431 588431 Estynton, John, of Tettebury, butcher 0
4958736 2344580 2344580 defendant Netherton Nicholas chapman 588431 588431 Netherton, Nicholas, of Tettebury, chapman 0
5071801 2378060 2378060 defendant Unwyn William husbandman 588431 588431 Unwyn, William, of Tettebury, husbandman 0
5113498 2390334 2390334 defendant Warner Thomas warrener 588431 588431 Warner, Thomas, of Tettebury, warrener 3
5123322 2393262 2393262 defendant Vale John husbandman 588431 588431 Vale, John, of Tettebury, husbandman 0
5123323 2393262 2393262 defendant Vale Thomas weaver 588431 588431 Vale, Thomas, of Tettebury, weaver 1
5134375 2396551 2396551 defendant Carter John hostiler 588431 588431 Carter, John, of Tettebury, hostiler 1
5154270 2402406 2402406 defendant Carter John hosteller 588431 588431 Carter, John, of Tettebury, hosteller 1
5187707 2412123 2412123 plaintiff Herne Walter   588431 588431 Herne, Walter, of Tettebury 0
5205679 2417405 2417405 plaintiff Herne Walter   588431 588431 Herne, Walter, of Tettebury 0
5283516 2440231 2440231 defendant Brydde Richard husbandman 588431 588431 Brydde, Richard, of Tettebury, husbandman 1
5347862 2459477 2459477 defendant Combe John weaver 588431 588431 Combe, John, of tettebury, weaver 4
5358892 2462832 2462832 defendant Sheriffe William clerk 588431 588431 Sheriffe, William, of Tettebury, clerk 0
5377944 2468680 2468680 defendant Sadeler Richard yeoman 588431 588431 Sadeler, Richard, of Tettebury, yeoman 0
5389811 2472149 2472149 defendant Ireland John John fuller 588431 588431 Ireland, John John, of Tettebury, fuller 0
5471313 2496358 2496358 plaintiff Herne Walter   588431 588431 Herne, Walter, of Tettebury 0
5471314 2496358 2496358 plaintiff Herne Thomas   588431 588431 Herne, Thomas, of Tettebury 1
5471315 2496358 2496358 defendant Stevenys John husbandman 588431 588431 Stevenys, John, of Tettebury, husbandman 0
5493137 2502857 2502857 defendant Tanner Thomas tanner 588431 588431 Tanner, Thomas, of Tettebury, tanner 0
5615105 2548515 2548515 defendant Waltere Walter   588431 588431 Waltere, Walter, of Tettebury 0
5620859 2550393 2550393 plaintiff Skynnere Henry   588431 588431 Skynnere, Henry, of Tettebury 0

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);