names

133 rows where place_id = 593987

✎ 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
3614072 1872065 1872065 defendant Perot Thomas yeoman 593987 593987 Perot, Thomas, of Gunthorp, yeoman 0
3616192 1872704 1872704 defendant Fuller John yeoman 593987 593987 Fuller, John, of Gunthorp, yeoman 0
3618777 1873489 1873489 defendant North Miles yeman 593987 593987 North, Miles, of Gunthorp, yeman 0
3618778 1873489 1873489 defendant Gerves Richard laborer 593987 593987 Gerves, Richard, of Gunthorp, laborer 1
3631034 1904528 1904528 plaintiff Fuller John   593987 593987 Fuller, John, of Gunthorp 0
3674471 1918064 1918064 defendant Koo Henry husbandman 593987 593987 Koo, Henry, of Gunthorp, husbandman 0
3684314 1921229 1921229 defendant Houghton Edmund (legal representative) 593987 593987 Houghton, Edmund, of Gunthorp, yeoman, executor of 1
3684319 1921230 1921230 defendant Houghton Edmund (legal representative) 593987 593987 Houghton, Edmund, of Gunthorp, yeoman, executor of 0
3688557 1922580 1922580 defendant Pekke Thomas clerk 593987 593987 Pekke, Thomas, of Gunthorp, clerk 0
3688558 1922580 1922580 defendant Pekke Edmund chaplain 593987 593987 Pekke, Edmund, of Gunthorp, chaplain 1
3688559 1922580 1922580 defendant Dey Simon husbandman 593987 593987 Dey, Simon, of Gunthorp, husbandman 2
3688560 1922580 1922580 defendant Dey Alice widow 593987 593987 Dey, Alice, of Gunthorp, widow 3
3688563 1922581 1922581 defendant Pekke Thomas clerk 593987 593987 Pekke, Thomas, of Gunthorp, clerk 0
3688564 1922581 1922581 defendant Pekke Edmund chaplain 593987 593987 Pekke, Edmund, of Gunthorp, chaplain 1
3688565 1922581 1922581 defendant Dey Simon husbandman 593987 593987 Dey, Simon, of Gunthorp, husbandman 2
3688566 1922581 1922581 defendant Dey Alice widow 593987 593987 Dey, Alice, of Gunthorp, widow 3
3703384 1927334 1927334 defendant Pecke Thomas clerk 593987 593987 Pecke, Thomas, of Gunthorp, clerk 0
3703385 1927334 1927334 defendant Pecke Edmund husbandman 593987 593987 Pecke, Edmund, of Gunthorp, husbandman 1
3703386 1927334 1927334 defendant Dey Alice widow 593987 593987 Dey, Alice, of Gunthorp, widow 2
3706258 1928244 1928244 defendant Hulberd John carpenter 593987 593987 Hulberd, John, of Gunthorp, carpenter 2
3729331 1935427 1935427 defendant Sheryngham Henry husbandman 593987 593987 Sheryngham, Henry, of Gunthorp, husbandman 0
3730754 1935845 1935845 defendant Shaxston John yeoman 593987 593987 Shaxston, John, of Gunthorp, yeoman 1
3793398 1955798 1955798 defendant Shawe Nicholas yeoman 593987 593987 Shawe, Nicholas, of Gunthorp, yeoman 0
3812932 1961940 1961940 defendant Stemys Robert husbandman 593987 593987 Stemys, Robert, of Gunthorp, husbandman 0
3836041 1969185 1969185 defendant Stemmys Robert husbandman 593987 593987 Stemmys, Robert, of Gunthorp, husbandman 1
3854029 1974895 1974895 defendant Mody Robert yeoman 593987 593987 Mody, Robert, of Gunthorp, yeoman 0
3854030 1974895 1974895 defendant Palmer Richard yeoman 593987 593987 Palmer, Richard, of Gunthorp, yeoman 1
3873357 1981305 1981305 defendant Lynne Thomas thatcher 593987 593987 Lynne, Thomas, of Gunthorp, thatcher 4
3887918 1986208 1986208 defendant Houghton John yeoman 593987 593987 Houghton, John, of Gunthorp, yeoman 1
3952869 2008079 2008079 plaintiff Houghton John (legal representative) 593987 593987 Houghton, John, of Gunthorp, executors of 0
3952872 2008079 2008079 plaintiff Doughtie William   593987 593987 Doughtie, William, of Gunthorp, worsted weaver 3
4005112 2026615 2026615 defendant Bussell Thomas husbandman 593987 593987 Bussell, Thomas, of Gunthorp, husbandman 0
4148116 2077474 2077474 defendant Deynes Gregory yeoman 593987 593987 Deynes, Gregory, of Gunthorp, yeoman 0
4150800 2078414 2078414 defendant Southus John yeoman 593987 593987 Southus, John, of Gunthorp, yeoman 2
4158551 2081062 2081062 defendant Godfrey Robert gent 593987 593987 Godfrey, Robert, of Gunthorp, gent 0
4160304 2081675 2081675 defendant Deynes Gregory husbandman 593987 593987 Deynes, Gregory, of Gunthorp, husbandman 0
4507975 2202960 2202960 defendant Derham William de (legal representative) 593987 593987 Derham, William de, of Gunthorp, administratrix of 1
4508032 2202983 2202983 defendant Barker Thomas   593987 593987 Barker, Thomas, of Gunthorp 0
4556723 2218036 2218036 defendant Wodecroft John   593987 593987 Wodecroft, John, of Gunthorp 2
4634885 2241760 2241760 defendant Smyth Godfrey   593987 593987 Smyth, Godfrey, of Gunthorp 3
4643554 2244217 2244217 defendant Shepherd William   593987 593987 Shepherd, William, of Gunthorp 1
4643913 2244319 2244319 defendant Shepherd William   593987 593987 Shepherd, William, of Gunthorp 0
4643914 2244319 2244319 defendant Baron Henry   593987 593987 Baron, Henry, of Gunthorp 1
4647122 2245211 2245211 defendant Clerk William   593987 593987 Clerk, William, of Gunthorp 0
4660461 2249097 2249097 defendant Baudewyn John husbandman 593987 593987 Baudewyn, John, of Gunthorp, husbandman 1
4703915 2266600 2266600 defendant Wilbey Nicholas clerk 593987 593987 Wilbey, Nicholas, of Gunthorp, clerk 0
4719160 2271340 2271340 defendant Sheperd William husbandman 593987 593987 Sheperd, William, of Gunthorp, husbandman 3
4727867 2273958 2273958 defendant Wilby Joan   593987 593987 Wilby, Joan, of Gunthorp, widow, formerly wife of Robert Wilby 0
4740969 2277869 2277869 defendant Clerk William husbandman 593987 593987 Clerk, William, of Gunthorp, husbandman 2
4742723 2278379 2278379 defendant Pare Roger husbandman 593987 593987 Pare, Roger, of Gunthorp, husbandman 0
4742724 2278379 2278379 defendant Shepherd William husbandman 593987 593987 Shepherd, William, of Gunthorp, husbandman 1
4742725 2278379 2278379 defendant Treweman William husbandman 593987 593987 Treweman, William, of Gunthorp, husbandman 2
4742726 2278379 2278379 defendant Clerk William husbandman 593987 593987 Clerk, William, of Gunthorp, husbandman 3
4777205 2288856 2288856 plaintiff atte Lane John chaplain 593987 593987 atte Lane, John, of Gunthorp, chaplain 0
4783058 2290719 2290719 defendant Gagg- Simon smith 593987 593987 Gagg-, Simon, of Gunthorp, smith 4
4796707 2295123 2295123 defendant Naudewyn John   593987 593987 Naudewyn, John, of Gunthorp, administrators of 2
4802376 2296935 2296935 defendant Davy Robert yeoman 593987 593987 Davy, Robert, of Gunthorp, yeoman 0
4808523 2298834 2298834 defendant Bonde William husbandman 593987 593987 Bonde, William, of Gunthorp, husbandman 2
4808524 2298834 2298834 defendant Ounstrey John husbandman 593987 593987 Ounstrey, John, of Gunthorp, husbandman 3
4818347 2301821 2301821 defendant Wilby Edward   593987 593987 Wilby, Edward, of Gunthorp, franklin 0
4853840 2312613 2312613 defendant Baret John husbandman 593987 593987 Baret, John, of Gunthorp, husbandman 0
4853850 2312615 2312615 defendant Clerke William husbandman 593987 593987 Clerke, William, of Gunthorp, husbandman 2
4868020 2316966 2316966 defendant Barker William husbandman 593987 593987 Barker, William, of Gunthorp, husbandman 0
4869801 2317527 2317527 plaintiff Lessy William   593987 593987 Lessy, William, of Gunthorp 0
4898714 2326249 2326249 defendant Bonde William husbandman 593987 593987 Bonde, William, of Gunthorp, husbandman 0
4898715 2326249 2326249 defendant Barett Geoffrey husbandman 593987 593987 Barett, Geoffrey, of Gunthorp, husbandman 1
4898716 2326249 2326249 defendant Barett William husbandman 593987 593987 Barett, William, of Gunthorp, husbandman 2
4899028 2326338 2326338 plaintiff Pery John clerk 593987 593987 Pery, John, of Gunthorp, clerk 0
4899427 2326462 2326462 defendant Somer John miller 593987 593987 Somer, John, of Gunthorp, miller 0
4900198 2326688 2326688 defendant Bernarde Robert husbandman 593987 593987 Bernarde, Robert, of Gunthorp, husbandman 3
4900199 2326688 2326688 defendant Bernarde William husbandman 593987 593987 Bernarde, William, of Gunthorp, husbandman 4
4950914 2342252 2342252 defendant Grey Robert husbandman 593987 593987 Grey, Robert, of Gunthorp, husbandman 2
4952585 2342732 2342732 defendant Sagge Simon smith 593987 593987 Sagge, Simon, of Gunthorp, smith 1
4962740 2345764 2345764 defendant Tussy Richard husbandman 593987 593987 Tussy, Richard, of Gunthorp, husbandman 0
4985008 2352447 2352447 defendant Somour John husbandman 593987 593987 Somour, John, of Gunthorp, husbandman 2
5032926 2366518 2366518 defendant Howeton John husbandman 593987 593987 Howeton, John, of Gunthorp, husbandman 0
5043813 2369776 2369776 defendant Benet Godfrey butcher 593987 593987 Benet, Godfrey, of Gunthorp, butcher 1
5044960 2370125 2370125 defendant Howeton John husbandman 593987 593987 Howeton, John, of Gunthorp, husbandman 0
5044961 2370125 2370125 defendant Elsyng Thomas husbandman 593987 593987 Elsyng, Thomas, of Gunthorp, husbandman 1
5058558 2374115 2374115 defendant Tussey Richard husbandman 593987 593987 Tussey, Richard, of Gunthorp, husbandman 0
5058559 2374115 2374115 defendant Tussey John husbandman 593987 593987 Tussey, John, of Gunthorp, husbandman 1
5071879 2378083 2378083 defendant Bocher Godfrey butcher 593987 593987 Bocher, Godfrey, of Gunthorp, butcher 4
5076453 2379454 2379454 defendant Clerk William husbandman 593987 593987 Clerk, William, of Gunthorp, husbandman 3
5130904 2395522 2395522 defendant Davy Thomas yeoman 593987 593987 Davy, Thomas, of Gunthorp, yeoman 0
5130905 2395522 2395522 defendant Wakeman Thomas yeoman 593987 593987 Wakeman, Thomas, of Gunthorp, yeoman 1
5134950 2396724 2396724 defendant Carbold Robert clerk 593987 593987 Carbold, Robert, of Gunthorp, clerk 0
5149708 2401045 2401045 defendant Fechet John   593987 593987 Fechet, John, of Gunthorp, mason 0
5150360 2401237 2401237 defendant Davy Thomas husbandman 593987 593987 Davy, Thomas, of Gunthorp, husbandman 0
5150361 2401237 2401237 defendant Wakeman Thomas husbandman 593987 593987 Wakeman, Thomas, of Gunthorp, husbandman 1
5150365 2401239 2401239 defendant Davy Thomas yeoman 593987 593987 Davy, Thomas, of Gunthorp, yeoman 0
5150367 2401240 2401240 defendant Wakeman Thomas yeoman 593987 593987 Wakeman, Thomas, of Gunthorp, yeoman 0
5168922 2406640 2406640 defendant Davy Thomas yeoman 593987 593987 Davy, Thomas, of Gunthorp, yeoman 0
5168924 2406641 2406641 defendant Wake Thomas yeoman 593987 593987 Wake, Thomas, of Gunthorp, yeoman 0
5204352 2417026 2417026 defendant Fechet alias Foket John   593987 593987 Fechet alias Foket, John, of Gunthorp, mason alias husbandman 0
5214660 2420015 2420015 defendant Davy Thomas yeoman 593987 593987 Davy, Thomas, of Gunthorp, yeoman 7
5258021 2432629 2432629 defendant Fuller Andrew carpenter 593987 593987 Fuller, Andrew, of Gunthorp, carpenter 2
5263539 2434346 2434346 defendant Mason John husbandman 593987 593987 Mason, John, of Gunthorp, husbandman 0
5268475 2435900 2435900 defendant Davy Thomas yeoman 593987 593987 Davy, Thomas, of Gunthorp, yeoman 2
5268478 2435900 2435900 defendant Maryner Henry husbandman 593987 593987 Maryner, Henry, of Gunthorp, husbandman 5
5276505 2438201 2438201 defendant Hervy John, junior shoemaker 593987 593987 Hervy, John, junior, of Gunthorp, shoemaker 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);