names

122 rows where place_id = 641532

✎ 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
3862200 1977540 1977540 defendant Fam Ralph laborer 641532 641532 Fam, Ralph, of Potter Heigham, laborer 0
4129262 2070764 2070764 defendant Wodes William laborer 641532 641532 Wodes, William, of Potter Heigham, laborer 0
4139563 2074511 2074511 defendant Wed William husbandman 641532 641532 Wed, William, of potter Heigham, husbandman 1
4158449 2081027 2081027 defendant Fayerwether Clement yeoman 641532 641532 Fayerwether, Clement, of Potter Heigham, yeoman 0
4163025 2082604 2082604 defendant Colman Richard husbandman 641532 641532 Colman, Richard, of Potter Heigham, husbandman 0
4163026 2082604 2082604 defendant Colman Thomas husbandman 641532 641532 Colman, Thomas, of Potter Heigham, husbandman 1
4182283 2089280 2089280 defendant Fayrewether Clement husbandman 641532 641532 Fayrewether, Clement, of Potter Heigham, husbandman 0
4183480 2089702 2089702 defendant Baspole William gent 641532 641532 Baspole, William, of Potter Heigham, gent 0
4183491 2089707 2089707 defendant Catt John husbandman 641532 641532 Catt, John, of Potter Heigham, husbandman 0
4183492 2089707 2089707 defendant Berry John husbandman 641532 641532 Berry, John, of Potter Heigham, husbandman 1
4183493 2089707 2089707 defendant Pytchard Robert husbandman 641532 641532 Pytchard, Robert, of Potter Heigham, husbandman 2
4215041 2100764 2100764 defendant Larwood William husbandman 641532 641532 Larwood, William, of Potter Heigham, husbandman 3
4217557 2101634 2101634 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 0
4217559 2101634 2101634 defendant Heare Thomas husbandman 641532 641532 Heare, Thomas, of Potter Heigham, husbandman 2
4217560 2101634 2101634 defendant Rose John husbandman 641532 641532 Rose, John, of Potter Heigham, husbandman 3
4220045 2102510 2102510 defendant Larwood Henry husbandman 641532 641532 Larwood, Henry, of Potter Heigham, husbandman 0
4221000 2102839 2102839 defendant Hogan Edmund husbandman 641532 641532 Hogan, Edmund, of Potter Heigham, husbandman 0
4227361 2105051 2105051 defendant Pawlynge Christopher yeoman 641532 641532 Pawlynge, Christopher, of Potter Heigham, yeoman 2
4227366 2105052 2105052 defendant Pawlynge Christopher yeoman 641532 641532 Pawlynge, Christopher, of Potter Heigham, yeoman 2
4241468 2110130 2110130 defendant Larwood William husbandman 641532 641532 Larwood, William, of Potter Heigham, husbandman 3
4242670 2110539 2110539 defendant Hogan Edmund husbandman 641532 641532 Hogan, Edmund, of Potter Heigham, husbandman 0
4244542 2111154 2111154 defendant Fayerwether Clement husbandman 641532 641532 Fayerwether, Clement, of Potter Heigham, husbandman 3
4249773 2112906 2112906 defendant Pawlinge Christopher husbandman 641532 641532 Pawlinge, Christopher, of Potter Heigham, husbandman 1
4252310 2113764 2113764 defendant Boult John husbandman 641532 641532 Boult, John, of Potter Heigham, husbandman 1
4274857 2121153 2121153 defendant Ilberd John husbandman 641532 641532 Ilberd, John, of Potter Heigham, husbandman 0
4276613 2121755 2121755 defendant Ilberd John yeoman 641532 641532 Ilberd, John, of Potter Heigham, yeoman 0
4286084 2125078 2125078 defendant Ilberde John yeoman 641532 641532 Ilberde, John, of Potter Heigham, yeoman 0
4286085 2125078 2125078 defendant Bett Edward husbandman 641532 641532 Bett, Edward, of Potter Heigham, husbandman 1
4286091 2125080 2125080 defendant Ilberde John yeoman 641532 641532 Ilberde, John, of Potter Heigham, yeoman 0
4286093 2125081 2125081 defendant Ilberde John yeoman 641532 641532 Ilberde, John, of Potter Heigham, yeoman 0
4286337 2125158 2125158 defendant Suffocke Richard yeoman 641532 641532 Suffocke, Richard, of Potter Heigham, yeoman 2
4287869 2125709 2125709 defendant Larwood William husbandman 641532 641532 Larwood, William, of Potter Heigham, husbandman 1
4288417 2125905 2125905 defendant Heare Joan widow 641532 641532 Heare, Joan, of Potter Heigham, widow 0
4289519 2126314 2126314 defendant Wylson John husbandman 641532 641532 Wylson, John, of Potter Heigham, husbandman 0
4289520 2126314 2126314 defendant Skeyton John carpenter 641532 641532 Skeyton, John, of Potter Heigham, carpenter 1
4309631 2133528 2133528 defendant Ilberde John husbandman 641532 641532 Ilberde, John, of Potter Heigham, husbandman 0
4311455 2134150 2134150 defendant Larwoode William yeoman 641532 641532 Larwoode, William, of Potter Heigham, yeoman 0
4314947 2135339 2135339 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 0
4315669 2135592 2135592 defendant Pewsey Francis clerk 641532 641532 Pewsey, Francis, of Potter Heigham, clerk 1
4315670 2135592 2135592 defendant Larwood William husbandman 641532 641532 Larwood, William, of Potter Heigham, husbandman 2
4315672 2135593 2135593 defendant Pallinge Christopher yeoman 641532 641532 Pallinge, Christopher, of Potter Heigham, yeoman 0
4315673 2135593 2135593 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 1
4318470 2136571 2136571 defendant Larwood William husbandman 641532 641532 Larwood, William, of Potter Heigham, husbandman 1
4318471 2136571 2136571 defendant Appleyard Peter yeoman 641532 641532 Appleyard, Peter, of Potter Heigham, yeoman 2
4320618 2137302 2137302 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 1
4328125 2139721 2139721 defendant Pawling Christopher husbandman 641532 641532 Pawling, Christopher, of Potter Heigham, husbandman 1
4328126 2139721 2139721 defendant Ilbert John husbandman 641532 641532 Ilbert, John, of Potter Heigham, husbandman 2
4328286 2139775 2139775 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 0
4330094 2140363 2140363 defendant Wilson John husbandman 641532 641532 Wilson, John, of Potter Heigham, husbandman 3
4331796 2140928 2140928 defendant Ilberde John yeoman 641532 641532 Ilberde, John, of Potter Heigham, yeoman 0
4331797 2140928 2140928 defendant Lanterne Henry yeoman 641532 641532 Lanterne, Henry, of Potter Heigham, yeoman 1
4332718 2141227 2141227 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 1
4333234 2141401 2141401 defendant Ilberde John yeoman 641532 641532 Ilberde, John, of Potter Heigham, yeoman 1
4333379 2141447 2141447 defendant Ilberde John yeoman 641532 641532 Ilberde John, of Potter Heigham, yeoman 0
4341023 2144135 2144135 defendant Suffolke Richard yeoman 641532 641532 Suffolke, Richard, of Potter Heigham, yeoman 0
4341496 2144303 2144303 defendant Weed William husbandman 641532 641532 Weed, William, of Potter Heigham, husbandman 2
4345893 2145827 2145827 defendant Robbes John husbandman 641532 641532 Robbes, John, of Potter Heigham, husbandman 0
4345895 2145827 2145827 defendant Ilberde John husbandman 641532 641532 Ilberde, John, of Potter Heigham, husbandman 2
4345896 2145827 2145827 defendant Pallynge or Pawlinge Christopher husbandman 641532 641532 Pallynge or Pawlinge, Christopher, of Potter Heigham, husbandman 3
4348026 2146561 2146561 defendant Harrold John husbandman 641532 641532 Harrold, John, of Potter Heigham, husbandman 3
4352612 2148150 2148150 defendant Reede Nicholas husbandman 641532 641532 Reede, Nicholas, of Potter Heigham, husbandman 0
4352613 2148150 2148150 defendant Reede William husbandman 641532 641532 Reede, William, of Potter Heigham, husbandman 1
4355478 2149138 2149138 defendant Reede Thomas husbandman 641532 641532 Reede, Thomas, of Potter Heigham, husbandman 2
4355479 2149138 2149138 defendant Wynn John husbandman 641532 641532 Wynn, John, of Potter Heigham, husbandman 3
4377832 2157141 2157141 defendant Larwood William yeoman 641532 641532 Larwood, William, of Potter Heigham, yeoman 0
4377833 2157141 2157141 defendant Larwood Robert husbandman 641532 641532 Larwood, Robert, of Potter Heigham, husbandman 1
4386281 2160088 2160088 defendant Pallinge Christopher yeoman 641532 641532 Pallinge, Christopher, of Potter Heigham, yeoman 0
4396307 2163340 2163340 defendant Suffelde Richard husbandman 641532 641532 Suffelde, Richard, of Potter Heigham, husbandman 1
4396308 2163340 2163340 defendant Larwood William husbandman 641532 641532 Larwood, William, of Potter Heigham, husbandman 2
4396309 2163340 2163340 defendant Ilberd John husbandman 641532 641532 Ilberd, John, of Potter Heigham, husbandman 3
4403701 2165812 2165812 defendant Heare Joan widow 641532 641532 Heare, Joan, of Potter Heigham, widow 0
4403702 2165812 2165812 defendant Colman Richard husbandman 641532 641532 Colman, Richard, of Potter Heigham, husbandman 1
4404342 2166022 2166022 defendant Pawling Christopher yeoman 641532 641532 Pawling, Christopher, of Potter Heigham, yeoman 0
4407315 2167008 2167008 defendant Larwoode William yeoman 641532 641532 Larwoode, William, of Potter Heigham, yeoman 0
4407316 2167008 2167008 defendant Larwoode Robert husbandman 641532 641532 Larwoode, Robert, of Potter Heigham, husbandman 1
4607543 2233471 2233471 defendant Eche William   641532 641532 Eche, William, of Potter Heigham 2
4607544 2233471 2233471 defendant Reynald Robert   641532 641532 Reynald, Robert, of Potter Heigham 3
4620559 2237416 2237416 plaintiff Jekkes John   641532 641532 Jekkes, John, of Potter Heigham 0
4636977 2242371 2242371 defendant Eche William   641532 641532 Eche, William, of Potter Heigham 1
4636980 2242371 2242371 defendant Cokes William   641532 641532 Cokes, William, of Potter Heigham 4
4668799 2255947 2255947 defendant Tom John   641532 641532 Tom, John, of Potter Heigham, vicar 5
4693939 2263611 2263611 defendant Tom John   641532 641532 Tom, John, of Potter Heigham 0
4697366 2264661 2264661 defendant Cook John yeoman 641532 641532 Cook, John, of Potter Heigham, yeoman 2
4719193 2271353 2271353 defendant Tom John   641532 641532 Tom, John, of Potter Heigham, vicar 0
4724889 2273078 2273078 defendant Stanbowe Thomas yeoman 641532 641532 Stanbowe, Thomas, of Potter Heigham, yeoman 2
4726269 2273501 2273501 defendant Dowe Thomas husbandman 641532 641532 Dowe, Thomas, of Potter Heigham, husbandman 0
4726283 2273505 2273505 defendant Knotte Edmund husbandman 641532 641532 Knotte, Edmund, of Potter Heigham, husbandman 0
4726301 2273509 2273509 defendant atte Seler Thomas yeoman 641532 641532 atte Seler, Thomas, of Potter Heigham, yeoman 0
4726302 2273509 2273509 defendant Sowere Thomas husbandman 641532 641532 Sowere, Thomas, of Potter Heigham, husbandman 1
4726303 2273509 2273509 defendant atte Chirch William husbandman 641532 641532 atte Chirch, William, of Potter Heigham, husbandman 2
4744855 2279013 2279013 defendant Stanlowe Thomas yeoman 641532 641532 Stanlowe, Thomas, of Potter Heigham, yeoman 3
4744869 2279016 2279016 defendant Cook John   641532 641532 Cook, John, of Potter Heigham, bailiff 2
4746130 2279362 2279362 defendant Clerk Edmund yeoman 641532 641532 Clerk, Edmund, of Potter Heigham, yeoman 9
4757348 2282670 2282670 defendant Dawe Thomas husbandman 641532 641532 Dawe, Thomas, of Potter Heigham, husbandman 3
4759986 2283462 2283462 defendant Jankyns Nicholas yeoman 641532 641532 Jankyns, Nicholas, of Potter Heigham, yeoman 1
4759987 2283462 2283462 defendant Cook John   641532 641532 Cook, John, of Potter Heigham, 2
4763999 2284728 2284728 defendant Jankyns Nicholas yeoman 641532 641532 Jankyns, Nicholas, of Potter Heigham, yeoman 6
4789405 2292751 2292751 defendant Reynaldes Robert husbandman 641532 641532 Reynaldes, Robert, of Potter Heigham, husbandman 4
4789407 2292751 2292751 defendant Ecche William yeoman 641532 641532 Ecche, William, of Potter Heigham, yeoman 6
4833432 2306462 2306462 defendant Cook John yeoman 641532 641532 Cook, John, of Potter Heigham, yeoman 2

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