names

125 rows where place_id = 590420

✎ 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
3601153 1868024 1868024 defendant Smyth William yeoman 590420 590420 Smyth, William, of Rougham, yeoman 2
3629724 1904148 1904148 defendant Wryght John miller 590420 590420 Wryght, John, of Rougham, miller 1
3629725 1904148 1904148 defendant Nunne Robert husbandman 590420 590420 Nunne, Robert, of Rougham, husbandman 2
3670855 1916849 1916849 defendant Yelverton William esq 590420 590420 Yelverton, William, of Rougham, esq 0
3670856 1916849 1916849 defendant Hyde John clerk 590420 590420 Hyde, John, of Rougham, clerk 1
3686966 1922089 1922089 defendant Yelverton William esq 590420 590420 Yelverton, William, of Rougham, esq 0
3702336 1926988 1926988 defendant White Robert (legal representative) 590420 590420 White, Robert, of Rougham, shepherd, executor of 0
3719856 1932478 1932478 defendant Yelverton William esq 590420 590420 Yelverton, William, of Rougham, esq 0
3768357 1947746 1947746 defendant Wynspere William hardwareman 590420 590420 Wynspere, William, of Rougham, hardwareman 0
3776297 1950332 1950332 defendant Bruet Robert laborer 590420 590420 Bruet, Robert, of Rougham, laborer 1
3791624 1955221 1955221 defendant Yemmys Thomas husbandman 590420 590420 Yemmys, Thomas, of Rougham, husbandman 0
3802492 1958676 1958676 defendant Skotte Robert   590420 590420 Skotte, Robert, of Rougham, shepherd 8
3840038 1970451 1970451 defendant Poynter Robert   590420 590420 Poynter, Robert, of Rougham, shepherd 0
3840039 1970452 1970452 plaintiff Yelverton William, junior gent 590420 590420 Yelverton, William, junior, of Rougham, gent 0
4002715 2025736 2025736 plaintiff Higham Thomas gent 590420 590420 Higham, Thomas, of Rougham, gent 0
4002716 2025736 2025736 defendant Goodwyn Edmund gent 590420 590420 Goodwyn, Edmund, of Rougham, gent 0
4041265 2039365 2039365 plaintiff Mynne Robert yeoman 590420 590420 Mynne, Robert, of Rougham, yeoman 0
4203660 2096838 2096838 defendant Drury Robert esq 590420 590420 Drury, Robert, of Rougham, esq 0
4210535 2099240 2099240 defendant Hempston Roger yeoman 590420 590420 Hempston, Roger, of Rougham, yeoman 1
4211420 2099548 2099548 defendant Drury Robert esq 590420 590420 Drury, Robert, of Rougham, esq 0
4232162 2106751 2106751 defendant Marcant Edmund gent 590420 590420 Marcant, Edmund, of Rougham, gent 0
4232165 2106752 2106752 defendant Markant Edmund gent 590420 590420 Markant, Edmund, of Rougham, gent 0
4276113 2121592 2121592 defendant Yelverton William (legal representative) 590420 590420 Yelverton, William, of Rougham, esq, executors of 0
4406864 2166864 2166864 defendant Potter Robert maltster 590420 590420 Potter, Robert, of Rougham, maltster 0
4485598 2196204 2196204 plaintiff Reed John   590420 590420 Reed, John, of Rougham 0
4566686 2221155 2221155 defendant Smyth Walter   590420 590420 Smyth, Walter, of Rougham 1
4576356 2224115 2224115 plaintiff Brook William   590420 590420 Brook, William, of Rougham 0
4599667 2231110 2231110 defendant Baker (illegible)   590420 590420 Baker, _, of Rougham 2
4636711 2242302 2242302 defendant Grene John   590420 590420 Grene, John, of Rougham 0
4636712 2242302 2242302 defendant atte Howe John   590420 590420 atte Howe, John, of Rougham 1
4645414 2244727 2244727 defendant Hogge Thomas   590420 590420 Hogge, Thomas, of Rougham 0
4687918 2261787 2261787 defendant Elys George yeoman 590420 590420 Elys, George, of Rougham, yeoman 0
4722829 2272453 2272453 plaintiff Coupe Robert merchant 590420 590420 Coupe, Robert, of Rougham, merchant 0
4748476 2280058 2280058 defendant atte Howe Ralph yeoman 590420 590420 atte Howe, Ralph, of Rougham, yeoman 0
4748477 2280058 2280058 defendant atte Howe John yeoman 590420 590420 atte Howe, John, of Rougham, yeoman 1
4769498 2286439 2286439 defendant Wubmere Nicholas chaplain 590420 590420 Wubmere, Nicholas, of Rougham, chaplain 3
4828629 2304994 2304994 defendant Pattyng Adam yeoman 590420 590420 Pattyng, Adam, of Rougham, yeoman 0
4828630 2304994 2304994 defendant Ropere John yeoman 590420 590420 Ropere, John, of Rougham, yeoman 1
4828631 2304994 2304994 defendant Gray John yeoman 590420 590420 Gray, John, of Rougham, yeoman 2
4828632 2304994 2304994 defendant Warde Robert yeoman 590420 590420 Warde, Robert, of Rougham, yeoman 3
4828634 2304995 2304995 defendant Pattyng Adam yeoman 590420 590420 Pattyng, Adam, of Rougham, yeoman 0
4828635 2304995 2304995 defendant Roper John yeoman 590420 590420 Roper, John, of Rougham, yeoman 1
4828636 2304995 2304995 defendant Gray John yeoman 590420 590420 Gray, John, of Rougham, yeoman 2
4828637 2304995 2304995 defendant Warde Robert yeoman 590420 590420 Warde, Robert, of Rougham, yeoman 3
4831125 2305766 2305766 defendant Hopeston Nicholas yeoman 590420 590420 Hopeston, Nicholas, of Rougham, yeoman 1
4838201 2307869 2307869 defendant Warde Robert husbandman 590420 590420 Warde, Robert, of Rougham, husbandman 0
4858069 2313893 2313893 defendant Nunne John yeoman 590420 590420 Nunne, John, of Rougham, yeoman 0
4858070 2313893 2313893 defendant Hepeston Nicholas yeoman 590420 590420 Hepeston, Nicholas, of Rougham, yeoman 1
4859030 2314205 2314205 defendant Bache Robert yeoman 590420 590420 Bache, Robert, of Rougham, yeoman 0
4859031 2314205 2314205 defendant Cartere Richard laborer 590420 590420 Cartere, Richard, of Rougham, laborer 1
4872514 2318363 2318363 plaintiff Nunne John yeoman 590420 590420 Nunne, John, of Rougham, yeoman 0
4872515 2318363 2318363 plaintiff Hempeston Nicholas yeoman 590420 590420 Hempeston, Nicholas, of Rougham, yeoman 1
4889543 2323526 2323526 defendant Drury William   590420 590420 Drury, William, of Rougham, knight 0
4971476 2348396 2348396 defendant Tillor Roger yeoman 590420 590420 Tillor, Roger, of Rougham, yeoman 2
5014059 2360966 2360966 defendant Bowyere John husbandman 590420 590420 Bowyere, John, of Rougham, husbandman 1
5016441 2361700 2361700 defendant Wynde Peter husbandman 590420 590420 Wynde, Peter, of Rougham, husbandman 3
5016763 2361793 2361793 defendant atte Hoo Ralph husbandman 590420 590420 atte Hoo, Ralph, of Rougham, husbandman 3
5018067 2362168 2362168 plaintiff Coket Walter   590420 590420 Coket, Walter, of Rougham 3
5030446 2365777 2365777 defendant Drury William   590420 590420 Drury, William, of Rougham, knight 0
5059189 2374313 2374313 defendant Boyton Richard, junior husbandman 590420 590420 Boyton, Richard, junior, of Rougham, husbandman 0
5059190 2374313 2374313 defendant Boyton John laborer 590420 590420 Boyton, John, of Rougham, laborer 1
5062311 2375288 2375288 defendant atte Howe John yeoman 590420 590420 atte Howe, John, of Rougham, yeoman 4
5100221 2386504 2386504 defendant Smyth John   590420 590420 Smyth, John, of Rougham, gent, formerly dwelling with Lord Le Scrop 0
5107664 2388673 2388673 plaintiff Drury Thomas esq 590420 590420 Drury, Thomas, of Rougham, esq 0
5124065 2393493 2393493 defendant Smyth John gent 590420 590420 Smyth, John, of Rougham, gent 0
5143957 2399377 2399377 defendant Hog Robert husbandman 590420 590420 Hog, Robert, of Rougham, husbandman 1
5164978 2405495 2405495 defendant Hog Robert husbandman 590420 590420 Hog, Robert, of Rougham, husbandman 1
5178650 2409469 2409469 defendant Hog Robert husbandman 590420 590420 Hog, Robert, of Rougham, husbandman 1
5190174 2412869 2412869 defendant Nunne Robert husbandman 590420 590420 Nunne, Robert, of Rougham, husbandman 0
5190175 2412869 2412869 defendant Nunne Thomas carpenter 590420 590420 Nunne, Thomas, of Rougham, carpenter 1
5190176 2412869 2412869 defendant Nunne John husbandman 590420 590420 Nunne, John, of Rougham, husbandman 2
5190198 2412872 2412872 defendant Nunne Robert husbandman 590420 590420 Nunne, Robert, of Rougham, husbandman 0
5190199 2412872 2412872 defendant Nunne Thomas carpenter 590420 590420 Nunne, Thomas, of Rougham, carpenter 1
5190200 2412872 2412872 defendant Nunne John husbandman 590420 590420 Nunne, John, of Rougham, husbandman 2
5201548 2416210 2416210 defendant Hog Robert husbandman 590420 590420 Hog, Robert, of Rougham, husbandman 1
5206813 2417727 2417727 defendant Nunne Robert husbandman 590420 590420 Nunne, Robert, of Rougham, husbandman 0
5206814 2417727 2417727 defendant Nunne Thomas carpenter 590420 590420 Nunne, Thomas, of Rougham, carpenter 1
5206815 2417727 2417727 defendant Nunne John husbandman 590420 590420 Nunne, John, of Rougham, husbandman 2
5210965 2418938 2418938 defendant Whitefote Thomas yeoman 590420 590420 Whitefote, Thomas, of Rougham, yeoman 2
5227121 2423582 2423582 defendant Baldyr or Baldyro Christine widow 590420 590420 Baldyr or Baldyro, Christine, of Rougham, widow 0
5281481 2439651 2439651 defendant Nunne Thomas carpenter 590420 590420 Nunne, Thomas, of Rougham, carpenter 2
5284459 2440469 2440469 plaintiff Fyncham Edmund (legal representative) 590420 590420 Fyncham, Edmund, of Rougham, gent, executors of 0
5284465 2440470 2440470 plaintiff Fyncham Edmund (legal representative) 590420 590420 Fyncham, Edmund, of Rougham, gent, executors of 0
5284473 2440471 2440471 plaintiff Fyncham Edmund (legal representative) 590420 590420 Fyncham, Edmund, of Rougham, gent, executors of 0
5287548 2441382 2441382 defendant Andrew Robert miller 590420 590420 Andrew, Robert, of Rougham, miller 0
5290469 2442217 2442217 plaintiff Tyllotte Thomas   590420 590420 Tyllotte, Thomas, of Rougham 1
5294286 2443301 2443301 defendant Hog John yeoman 590420 590420 Hog, John, of Rougham, yeoman 0
5309344 2447835 2447835 defendant Hog Alice widow 590420 590420 Hog, Alice, of Rougham, widow 1
5311900 2448586 2448586 defendant Milley Edmund husbandman 590420 590420 Milley, Edmund, of Rougham, husbandman 0
5314421 2449340 2449340 defendant Hog John yeoman 590420 590420 Hog, John, of Rougham, yeoman 0
5319878 2451032 2451032 plaintiff Horn Edward   590420 590420 Horn, Edward, of Rougham 0
5336821 2456077 2456077 defendant Swanton James yeoman 590420 590420 Swanton, James, of Rougham, yeoman 0
5339885 2457041 2457041 defendant Hogge John husbandman 590420 590420 Hogge, John, of Rougham, husbandman 0
5350793 2460358 2460358 defendant Mulley Edmund husbandman 590420 590420 Mulley, Edmund, of Rougham, husbandman 0
5364100 2464429 2464429 plaintiff Yelverton William Esq 590420 590420 Yelverton, William, of Rougham, Esq 0
5364102 2464430 2464430 plaintiff Yelverton William esq 590420 590420 Yelverton, William, of Rougham, esq 0
5364535 2464565 2464565 defendant Mulley Edmund husbandman 590420 590420 Mulley, Edmund, of Rougham, husbandman 0
5364537 2464565 2464565 defendant Mulley Robert husbandman & son of Edmund 590420 590420 Mulley, Robert, of Rougham, husbandman & son of Edmund 2
5385690 2470977 2470977 defendant Yelverton Nicholas gent 590420 590420 Yelverton, Nicholas, of Rougham, gent 0
5391593 2472665 2472665 defendant Whytfote Thomas yeoman 590420 590420 Whytfote, Thomas, of Rougham, yeoman 5

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