names

50 rows where place_id = 591555

✎ 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
3604789 1869162 1869162 defendant Thomson Robert yeoman 591555 591555 Thomson, Robert, of Hemyngburgh, yeoman 2
3620262 1873917 1873917 defendant Stersecre John shoemaker 591555 591555 Stersecre, John, of Hemyngburgh, shoemaker 0
3647852 1909724 1909724 defendant Banes Robert husbandman 591555 591555 Banes, Robert, of Hemyngburgh, husbandman 0
3718250 1931992 1931992 defendant Goldesburgh Robert yeoman 591555 591555 Goldesburgh, Robert, of Hemyngburgh, yeoman 0
3718251 1931992 1931992 defendant Goldesburgh William yeoman 591555 591555 Goldesburgh, William, of Hemyngburgh, yeoman 1
3766437 1947160 1947160 plaintiff Marshall Richard clerk 591555 591555 Marshall, Richard, of Hemyngburgh, clerk 0
3868131 1979578 1979578 defendant Tomson William husbandman 591555 591555 Tomson, William, of Hemyngburgh, husbandman 0
4441265 2182201 2182201 plaintiff Bolthorp Robert   591555 591555 Bolthorp, Robert, of Hemyngburgh, on his own account 0
4469201 2191035 2191035 defendant Wate Thomas chaplain 591555 591555 Wate, Thomas, of Hemyngburgh, chaplain 2
4479869 2194369 2194369 defendant Clerk Margery   591555 591555 Clerk, Margery, of Hemyngburgh 0
4480261 2194488 2194488 defendant Clerk Margery   591555 591555 Clerk, Margery, of Hemyngburgh 0
4515714 2205340 2205340 plaintiff Clerk Margery   591555 591555 Clerk, Margery, of Hemyngburgh 0
4534712 2211132 2211132 defendant Barbour William   591555 591555 Barbour, William, of Hemyngburgh 0
4556370 2217931 2217931 defendant Everard William   591555 591555 with Everard, William, of Hemyngburgh 6
4557671 2218333 2218333 defendant Thomesson Robert shoemaker 591555 591555 Thomesson, Robert, of Hemyngburgh, shoemaker 0
4668975 2256001 2256001 defendant Heppes John chaplain 591555 591555 Heppes, John, of Hemyngburgh, chaplain 0
4682704 2260205 2260205 defendant Gorwardby William chaplain 591555 591555 Gorwardby, William, of Hemyngburgh, chaplain 0
4682706 2260206 2260206 defendant Gorwardby William chaplain 591555 591555 Gorwardby, William, of Hemyngburgh, chaplain 0
4717087 2270673 2270673 defendant Tynde Robert husbandman 591555 591555 Tynde, Robert, of Hemyngburgh, husbandman 0
4744411 2278888 2278888 defendant Rogse Thomas smith 591555 591555 Rogse, Thomas, of Hemyngburgh, smith 0
4750808 2280717 2280717 defendant Polayn Richard husbandman 591555 591555 Polayn, Richard, of Hemyngburgh, husbandman 1
4750912 2280749 2280749 plaintiff Rykynghale John   591555 591555 Rykynghale, John, of Hemyngburgh, parson, on his own account 0
4777427 2288935 2288935 defendant Clerk Thomas   591555 591555 Clerk, Thomas, of Hemyngburgh, parish clerk 0
4847988 2310848 2310848 defendant Lassey John husbandman 591555 591555 Lassey, John, of Hemyngburgh, husbandman 1
4854481 2312793 2312793 defendant Retsee Thomas smith 591555 591555 Retsee, Thomas, of Hemyngburgh, smith 1
4877235 2319835 2319835 defendant Hadilsay Richard weaver 591555 591555 Hadilsay, Richard, of Hemyngburgh, weaver 3
4879402 2320488 2320488 defendant Hacilsay Richard weaver 591555 591555 Hacilsay, Richard, of Hemyngburgh, weaver 0
4895826 2325369 2325369 defendant Hadilsey Richard weaver 591555 591555 Hadilsey, Richard, of Hemyngburgh, weaver 1
4912720 2330483 2330483 defendant Dlyson Richard chaplain 591555 591555 Dlyson, Richard, of Hemyngburgh, chaplain 0
4964062 2346161 2346161 defendant Lacy John yeoman 591555 591555 Lacy, John, of Hemyngburgh, yeoman 0
5047884 2370983 2370983 defendant Serfe John yeoman 591555 591555 Serfe, John, of Hemyngburgh, yeoman 0
5055427 2373208 2373208 defendant Kelfeld William yeoman 591555 591555 Kelfeld, William, of Hemyngburgh, yeoman 4
5080810 2380752 2380752 defendant Goldesburgh William yeoman 591555 591555 Goldesburgh, William, of Hemyngburgh, yeoman 0
5167364 2406191 2406191 defendant Ramsey William yeoman 591555 591555 Ramsey, William, of Hemyngburgh, yeoman 0
5170448 2407085 2407085 defendant Thomasson William husbandman 591555 591555 Thomasson, William, of Hemyngburgh, husbandman 2
5212833 2419497 2419497 defendant Fyssher Robert chapman 591555 591555 Fyssher, Robert, of Hemyngburgh, chapman 2
5212834 2419497 2419497 defendant Jakson Agnes widow 591555 591555 Jakson, Agnes, of Hemyngburgh, widow 3
5212835 2419497 2419497 defendant Graunge John walker 591555 591555 Graunge, John, of Hemyngburgh, walker 4
5278344 2438772 2438772 defendant Mergeryson John husbandman 591555 591555 Mergeryson, John, of Hemyngburgh, husbandman 0
5283643 2440265 2440265 defendant Ryffan William yeoman 591555 591555 Ryffan, William, of Hemyngburgh, yeoman 1
5288016 2441508 2441508 defendant Portyngton Thomas clerk 591555 591555 Portyngton, Thomas, of Hemyngburgh, clerk 0
5300245 2445037 2445037 defendant Goldisburgh William yeoman 591555 591555 Goldisburgh, William, of Hemyngburgh, yeoman 3
5300246 2445037 2445037 defendant Ryffan Thomas yeoman 591555 591555 Ryffan, Thomas, of Hemyngburgh, yeoman 4
5327746 2453366 2453366 defendant Proudefote Robert weaver 591555 591555 Proudefote, Robert, of Hemyngburgh, weaver 2
5340101 2457112 2457112 defendant Goldesburgh William yeoman 591555 591555 Goldesburgh, William, of Hemyngburgh, yeoman 0
5382884 2470171 2470171 defendant Merten Richard esq 591555 591555 Merten, Richard, of Hemyngburgh, esq 0
5427309 2483112 2483112 defendant Goldesburgh William yeoman 591555 591555 Goldesburgh, William, of Hemyngburgh, yeoman 0
5430833 2484161 2484161 defendant Goldisburgh William yeoman 591555 591555 Goldisburgh, William, of Hemyngburgh, yeoman 0
5484723 2500356 2500356 defendant Goldesburgh William gent 591555 591555 Goldesburgh, William, of Hemyngburgh, gent 3
5541544 2517468 2517468 defendant Peirson Roger butcher 591555 591555 Peirson, Roger, of Hemyngburgh, butcher 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);