names

333 rows where place_id = 593113

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610506 1870949 1870949 defendant See Henry yeoman 593113 593113 See, Henry, of Grymesby, yeoman 0
3610507 1870949 1870949 defendant Whettelay Richard yeoman 593113 593113 Whettelay, Richard, of Grymesby, yeoman 1
3669344 1916350 1916350 plaintiff Lorde Robert   593113 593113 Lorde, Robert, of Grymesby 1
3706945 1928456 1928456 defendant West Robert draper 593113 593113 West, Robert, of Grymesby, draper 0
3742604 1939555 1939555 defendant Rowedon Stephen yeoman 593113 593113 Rowedon, Stephen, of Grymesby, yeoman 1
4060234 2046062 2046062 defendant Huytt William yeoman 593113 593113 Huytt, William, of Grymesby, yeoman 0
4415266 2169667 2169667 defendant atte Wode William   593113 593113 atte Wode, William, of Grymesby, son of Thomas 0
4417912 2170479 2170479 defendant Goldsmyth Richard   593113 593113 Goldsmyth, Richard, of Grymesby 1
4418273 2170597 2170597 defendant Sewan William   593113 593113 Sewan, William, of Grymesby, son of Peter 0
4418274 2170597 2170597 defendant Dyck William of the   593113 593113 Dyck, William of the, of Grymesby, son of Robert 1
4418275 2170597 2170597 defendant Barne Peter   593113 593113 Barne, Peter, of Grymesby, son of Hugh 2
4420232 2171229 2171229 plaintiff Briggesle _ de merchant 593113 593113 Briggesle, _ de, of Grymesby, merchant 0
4420256 2171236 2171236 defendant Northfok Robert de   593113 593113 Northfok, Robert de, of Grymesby 2
4421869 2171717 2171717 plaintiff Davy Joan   593113 593113 Davy, Joan, of Grymesby, formerly wife of Robert 0
4422804 2171989 2171989 plaintiff Finttenay Agnes   593113 593113 Finttenay, Agnes, of Grymesby, formerly wife of Simon 0
4424019 2172365 2172365 plaintiff Hilbrand Robert   593113 593113 Hilbrand, Robert, of Grymesby 0
4424020 2172365 2172365 defendant atte Grene Ralph   593113 593113 atte Grene, Ralph, of Grymesby 0
4424022 2172366 2172366 plaintiff Hilbrand Robert   593113 593113 Hilbrand, Robert, of Grymesby 0
4424025 2172366 2172366 defendant who vouched Toller Emma   593113 593113 who vouched Toller, Emma, of Grymesby, formerly wife of William 2
4424026 2172367 2172367 plaintiff Hilbrand Robert   593113 593113 Hilbrand, Robert, of Grymesby 0
4424028 2172368 2172368 plaintiff Hilbrand Robert   593113 593113 Hilbrand, Robert, of Grymesby 0
4424029 2172368 2172368 defendant Riby John de   593113 593113 Riby, John de, of Grymesby 0
4424030 2172369 2172369 plaintiff Hilbrand Robert   593113 593113 Hilbrand, Robert, of Grymesby 0
4445174 2183461 2183461 defendant Burton Robert de   593113 593113 Burton, Robert de, of Grymesby 0
4446426 2183799 2183799 plaintiff del See Joan   593113 593113 del See, Joan, of Grymesby 0
4447524 2184139 2184139 plaintiff Elynson Simon   593113 593113 Elynson, Simon, of Grymesby 0
4447525 2184139 2184139 defendant Gotson Peter   593113 593113 Gotson, Peter, of Grymesby 0
4447612 2184173 2184173 defendant Wele Walter de   593113 593113 Wele, Walter de, of Grymesby 0
4447613 2184173 2184173 defendant Aby Richard de   593113 593113 Aby, Richard de, of Grymesby 1
4447614 2184173 2184173 defendant Balcok William   593113 593113 Balcok, William, of Grymesby 2
4447999 2184296 2184296 defendant Redbourn Robert   593113 593113 Redbourn, Robert, of Grymesby 0
4448378 2184421 2184421 defendant Pernant John   593113 593113 Pernant, John, of Grymesby 0
4450704 2185179 2185179 defendant Backester John   593113 593113 Backester, John, of Grymesby 0
4450742 2185195 2185195 defendant Clare Stephen   593113 593113 Clare, Stephen, of Grymesby 0
4452473 2185770 2185770 defendant Patryngton William de   593113 593113 Patryngton, William de, of Grymesby 0
4461579 2188698 2188698 defendant Aleliy Nicholas   593113 593113 Aleliy, Nicholas, of Grymesby 0
4461905 2188783 2188783 defendant Hardy John pardoner 593113 593113 Hardy, John, of Grymesby, pardoner 1
4462258 2188894 2188894 defendant Patryngton William de   593113 593113 Patryngton, William de, of Grymesby 0
4464786 2189650 2189650 defendant Hardy John   593113 593113 Hardy, John, of Grymesby 2
4464794 2189651 2189651 defendant Hardy John   593113 593113 Hardy, John, of Grymesby 2
4472880 2192194 2192194 plaintiff Cotes John de   593113 593113 Cotes, John de, of Grymesby 0
4475008 2192854 2192854 plaintiff Elmeshale William   593113 593113 Elmeshale, William, of Grymesby 0
4475478 2193007 2193007 defendant Slotheby Walter   593113 593113 Slotheby, Walter, of Grymesby 2
4475479 2193007 2193007 defendant Askeby Geoffrey   593113 593113 Askeby, Geoffrey, of Grymesby 3
4475480 2193007 2193007 defendant Aby Richard   593113 593113 Aby, Richard, of Grymesby 4
4476774 2193399 2193399 defendant Braban John   593113 593113 Braban, John, of Grymesby 0
4487438 2196784 2196784 plaintiff Smyth Gilbert   593113 593113 Smyth, Gilbert, of Grymesby 0
4488176 2197017 2197017 defendant White John   593113 593113 White, John, of Grymesby, son of Simon 3
4488226 2197033 2197033 plaintiff Starchiwe Robert de   593113 593113 Starchiwe, Robert de, of Grymesby 0
4492116 2198222 2198222 defendant Burton Robert de   593113 593113 Burton, Robert de, of Grymesby 0
4493489 2198668 2198668 defendant Bryggeslay Thomas de draper 593113 593113 Bryggeslay, Thomas de, of Grymesby, draper 1
4497605 2199898 2199898 plaintiff Duffeld William de   593113 593113 Duffeld, William de, of Grymesby 0
4497753 2199943 2199943 plaintiff Elmsale William   593113 593113 Elmsale, William, of Grymesby 0
4498345 2200141 2200141 defendant Broklesby Robert de   593113 593113 Broklesby, Robert de, of Grymesby 1
4498350 2200142 2200142 defendant Brokkesby Robert de   593113 593113 Brokkesby, Robert de, of Grymesby 1
4502645 2201411 2201411 plaintiff (not given) Simon vicar of Mustall 593113 593113 Mustall, Simon, of Grymesby, vicar of St James' church 0
4505695 2202291 2202291 defendant Glover Thomas   593113 593113 Glover, Thomas, of Grymesby 3
4506825 2202604 2202604 defendant Cokson John   593113 593113 Cokson, John, of Grymesby 0
4507370 2202767 2202767 defendant Mylner William   593113 593113 Mylner, William, of Grymesby 0
4507638 2202851 2202851 plaintiff White Simon   593113 593113 White, Simon, of Grymesby 0
4507642 2202852 2202852 plaintiff White Simon   593113 593113 White, Simon, of Grymesby 0
4509176 2203346 2203346 defendant Burton Thomas   593113 593113 Burton, Thomas, of Grymesby 0
4513177 2204544 2204544 plaintiff Brigeslay Thomas de   593113 593113 Brigeslay, Thomas de, of Grymesby 0
4513178 2204544 2204544 defendant Slotheby Walter de   593113 593113 Slotheby, Walter de, of Grymesby 0
4513193 2204550 2204550 defendant Payntour Thomas   593113 593113 Payntour, Thomas, of Grymesby 1
4514650 2205001 2205001 plaintiff Carleton Robert   593113 593113 Carleton, Robert, of Grymesby 0
4514886 2205069 2205069 defendant Waltham Geoffrey pasterer 593113 593113 Waltham, Geoffrey, of Grymesby, pasterer 0
4519039 2206307 2206307 plaintiff Duffeld William   593113 593113 Duffeld, William, of Grymesby 0
4519415 2206431 2206431 plaintiff Elmesale William   593113 593113 Elmesale, William, of Grymesby 0
4519417 2206432 2206432 plaintiff Elmesale William   593113 593113 Elmesale, William, of Grymesby 0
4519428 2206437 2206437 plaintiff Elmsale William   593113 593113 Elmsale, William, of Grymesby 0
4520801 2206846 2206846 plaintiff Wele William de   593113 593113 Wele, William de, of Grymesby 1
4520802 2206846 2206846 defendant Covenham John   593113 593113 Covenham, John, of Grymesby 0
4524450 2207987 2207987 plaintiff Holme John   593113 593113 Holme, John, of Grymesby 0
4524451 2207987 2207987 plaintiff Gonerby John   593113 593113 Gonerby, John, of Grymesby 1
4524452 2207987 2207987 defendant Takell John   593113 593113 Takell, John, of Grymesby 0
4524453 2207987 2207987 defendant Ferour John   593113 593113 Ferour, John, of Grymesby 1
4527270 2208808 2208808 defendant Helyng Annice   593113 593113 Helyng, Annice, of Grymesby 0
4527294 2208817 2208817 defendant Helyng Annice   593113 593113 Helyng, Annice, of Grymesby 0
4528240 2209107 2209107 defendant Brokelesby Robert de   593113 593113 Brokelesby, Robert de, of Grymesby 0
4531670 2210168 2210168 plaintiff Person Philippa   593113 593113 Person, Philippa, of Grymesby 0
4535319 2211316 2211316 defendant Tyler Nicholas   593113 593113 Tyler, Nicholas, of Grymesby 0
4535543 2211390 2211390 defendant Smeton William   593113 593113 Smeton, William, of Grymesby 0
4536107 2211570 2211570 defendant Wathe Gilbert   593113 593113 Wathe, Gilbert, of Grymesby 0
4540344 2212878 2212878 plaintiff Wele William   593113 593113 Wele, William, of Grymesby 0
4540345 2212878 2212878 defendant Covenham John   593113 593113 Covenham, John, of Grymesby 0
4540829 2213037 2213037 defendant Covenham John   593113 593113 Covenham, John, of Grymesby 0
4540838 2213039 2213039 plaintiff White Richard   593113 593113 White, Richard, of Grymesby 0
4541103 2213123 2213123 plaintiff Wode Isabel   593113 593113 Wode, Isabel, of Grymesby 0
4545190 2214417 2214417 defendant Martyn Maud   593113 593113 Martyn, Maud, of Grymesby 0
4546284 2214770 2214770 plaintiff Brayne Thomas   593113 593113 Brayne, Thomas, of Grymesby 0
4547433 2215126 2215126 plaintiff Bynbrok John   593113 593113 Bynbrok, John, of Grymesby 0
4547436 2215127 2215127 plaintiff Bynbrok John   593113 593113 Bynbrok, John, of Grymesby 0
4547442 2215129 2215129 plaintiff Bynbroke John   593113 593113 Bynbroke, John, of Grymesby 0
4547443 2215129 2215129 plaintiff White Richard   593113 593113 White, Richard, of Grymesby 1
4549679 2215833 2215833 defendant Perche Robert   593113 593113 Perche, Robert, of Grymesby 0
4549873 2215894 2215894 plaintiff Cowper Richard (legal representative) 593113 593113 Cowper, Richard, of Grymesby, executors of 0
4549876 2215894 2215894 plaintiff Coweper Henry   593113 593113 Coweper, Henry, of Grymesby 3
4551386 2216372 2216372 defendant Spencer Robert   593113 593113 Spencer, Robert, of Grymesby 0
4551742 2216488 2216488 plaintiff Elikyngton John   593113 593113 Elikyngton, John, of Grymesby 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);