names

85 rows where place_id = 588252

✎ 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
3593848 1865716 1865716 defendant Auncell John husbandman 588252 588252 Auncell, John, of Hatfeld Peverell, husbandman 0
3593849 1865716 1865716 defendant Brook Richard husbandman 588252 588252 Brook, Richard, of Hatfeld Peverell, husbandman 1
3610607 1870983 1870983 defendant Grey Thomas yeoman 588252 588252 Grey, Thomas, of Hatfeld Peverell, yeoman 0
3612638 1871590 1871590 defendant Grey Thomas yeoman 588252 588252 Grey, Thomas, of Hatfeld Peverell, yeoman 0
3617646 1873142 1873142 defendant Grey Thmas yeoman 588252 588252 Grey, Thmas, of Hatfeld Peverell, yeoman 0
3633094 1905162 1905162 defendant Calner Robert tailor 588252 588252 Calner, Robert, of Hatfeld Peverell, tailor 0
3698406 1925722 1925722 defendant Broke James husbandman 588252 588252 Broke, James, of Hatfeld Peverell, husbandman 0
3711471 1929894 1929894 defendant Tendryng Christian yeoman 588252 588252 Tendryng, Christian, of Hatfeld Peverell, yeoman 0
3861124 1977199 1977199 defendant Waterhowse Robert yeoman 588252 588252 Waterhowse, Robert, of Hatfeld Peverell, yeoman 0
3868435 1979681 1979681 defendant Chyld Thomas husbandman 588252 588252 Chyld, Thomas, of Hatfeld Peverell, husbandman 1
4467879 2190635 2190635 defendant Brokeman John tailor 588252 588252 Brokeman, John, of Hatfeld Peverell, tailor 1
4516959 2205711 2205711 defendant Filiol John   588252 588252 Filiol, John, of Hatfeld Peverell 0
4516961 2205712 2205712 defendant Filioll John   588252 588252 Filioll, John, of Hatfeld Peverell 0
4526411 2208537 2208537 plaintiff Kyng John   588252 588252 Kyng, John, of Hatfeld Peverell 0
4534632 2211102 2211102 defendant Filiol John   588252 588252 Filiol, John, of Hatfeld Peverell 0
4537691 2212062 2212062 defendant Hierde Henry   588252 588252 Hierde, Henry, of Hatfeld Peverell 0
4555759 2217736 2217736 defendant Botere John   588252 588252 Botere, John, of Hatfeld Peverell 0
4559479 2218914 2218914 defendant Geffrey Thomas   588252 588252 Geffrey, Thomas, of Hatfeld Peverell 1
4559481 2218914 2218914 defendant Derby John   588252 588252 Derby, John, of Hatfeld Peverell 3
4586215 2227112 2227112 defendant Mareshall Robert   588252 588252 Mareshall, Robert, of Hatfeld Peverell 1
4586278 2227127 2227127 defendant Derby John   588252 588252 Derby, John, of Hatfeld Peverell 0
4586281 2227127 2227127 defendant Breggeman Thomas   588252 588252 Breggeman, Thomas, of Hatfeld Peverell 3
4596827 2230242 2230242 defendant Welton Thomas   588252 588252 Welton, Thomas, of Hatfeld Peverell 0
4646455 2245027 2245027 plaintiff Prior John   588252 588252 Prior, John, of Hatfeld Peverell 0
4660138 2249016 2249016 defendant Mustarder Roger butcher 588252 588252 Mustarder, Roger, of Hatfeld Peverell, butcher 0
4662756 2249809 2249809 plaintiff Fuller Thomas   588252 588252 Fuller, Thomas, of Hatfeld Peverell 0
4734952 2276085 2276085 defendant Hoberd Thomas tanner 588252 588252 together with Hoberd, Thomas, of Hatfeld Peverell, tanner 7
4734964 2276086 2276086 defendant Hoberd Thomas tanner 588252 588252 Hoberd, Thomas, of Hatfeld Peverell, tanner 0
4734976 2276087 2276087 defendant Hoberd Thomas tanner 588252 588252 Hoberd, Thomas, of Hatfeld Peverell, tanner 0
4770509 2286753 2286753 defendant Pypere Thomas laborer 588252 588252 Pypere, Thomas, of Hatfeld Peverell, laborer 0
4770510 2286753 2286753 defendant Mason Roger   588252 588252 Mason, Roger, of Hatfeld Peverell, mason 1
4779168 2289459 2289459 defendant Motte John husbandman 588252 588252 Motte, John, of Hatfeld Peverell, husbandman 0
4782508 2290537 2290537 defendant Musterder Roger husbandman 588252 588252 Musterder, Roger, of Hatfeld Peverell, husbandman 0
4806551 2298263 2298263 defendant Hyerd John husbandman 588252 588252 Hyerd, John, of Hatfeld Peverell, husbandman 1
4810272 2299357 2299357 defendant Auncell John husbandman 588252 588252 Auncell, John, of Hatfeld Peverell, husbandman 3
4876765 2319706 2319706 defendant Trenerdon or Treverdon Roger yeoman 588252 588252 Trenerdon or Treverdon, Roger, of Hatfeld Peverell, yeoman 0
4918631 2332343 2332343 defendant Purfote William husbandman 588252 588252 Purfote, William, of Hatfeld Peverell, husbandman 0
4918632 2332343 2332343 defendant Purfote John husbandman 588252 588252 Purfote, John, of Hatfeld Peverell, husbandman 1
4929921 2335771 2335771 defendant Profoot Robert husbandman 588252 588252 Profoot, Robert, of Hatfeld Peverell, husbandman 0
4929922 2335771 2335771 defendant Profoot Richard husbandman 588252 588252 Profoot, Richard, of Hatfeld Peverell, husbandman 1
4945239 2340486 2340486 defendant Motte John husbandman 588252 588252 Motte, John, of Hatfeld Peverell, husbandman 0
4959874 2344914 2344914 defendant Egefeld Robert fishmonger 588252 588252 Egefeld, Robert, of Hatfeld Peverell, fishmonger 0
4965347 2346558 2346558 defendant Frenssheman John laborer 588252 588252 Frenssheman, John, of Hatfeld Peverell, laborer 0
4965351 2346559 2346559 defendant Frenssheman John laborer 588252 588252 Frenssheman, John, of Hatfeld Peverell, laborer 0
4978532 2350530 2350530 defendant Heggefeld Robert husbandman 588252 588252 Heggefeld, Robert, of Hatfeld Peverell, husbandman 0
5005673 2358556 2358556 defendant Hoberd Roger husbandman 588252 588252 Hoberd, Roger, of Hatfeld Peverell, husbandman 0
5005674 2358556 2358556 defendant Fuller Henry husbandman 588252 588252 Fuller, Henry, of Hatfeld Peverell, husbandman 1
5016617 2361753 2361753 defendant Fuller Henry drover 588252 588252 Fuller, Henry, of Hatfeld Peverell, drover 3
5016623 2361754 2361754 defendant Fuller Henry drover 588252 588252 Fuller, Henry, of Hatfeld Peverell, drover 3
5060639 2374762 2374762 defendant Purfote Robert husbandman 588252 588252 Purfote, Robert, of Hatfeld Peverell, husbandman 0
5060640 2374762 2374762 defendant Purfote Richard husbandman 588252 588252 Purfote, Richard, of Hatfeld Peverell, husbandman 1
5060643 2374762 2374762 defendant Tyler Thomas husbandman 588252 588252 Tyler, Thomas, of Hatfeld Peverell, husbandman 4
5060644 2374762 2374762 defendant Milner Richard husbandman 588252 588252 Milner, Richard, of Hatfeld Peverell, husbandman 5
5062130 2375229 2375229 defendant Raulyn William husbandman 588252 588252 Raulyn, William, of Hatfeld Peverell, husbandman 1
5063621 2375652 2375652 defendant Fuller Henry husbandman 588252 588252 Fuller, Henry, of Hatfeld Peverell, husbandman 3
5072779 2378343 2378343 defendant Mynton John laborer 588252 588252 Mynton, John, of Hatfeld Peverell, laborer 3
5087793 2382812 2382812 defendant Fuller John husbandman 588252 588252 Fuller, John, of Hatfeld Peverell, husbandman 1
5098529 2386000 2386000 defendant Rawelyn William husbandman 588252 588252 Rawelyn, William, of Hatfeld Peverell, husbandman 1
5205566 2417374 2417374 defendant Osberne Isabel   588252 588252 Osberne, Isabel, of Hatfeld Peverell, widow, formerly wife of Richard 2
5216357 2420525 2420525 defendant Maynard John husbandman 588252 588252 Maynard, John, of Hatfeld Peverell, husbandman 0
5225571 2423152 2423152 defendant Lane William maltman 588252 588252 Lane, William, of Hatfeld Peverell, maltman 2
5230535 2424545 2424545 defendant Chapman John laborer 588252 588252 Chapman, John, of Hatfeld Peverell, laborer 1
5238958 2426984 2426984 defendant Sawekyn John husbandman 588252 588252 Sawekyn, John, of Hatfeld Peverell, husbandman 0
5254878 2431642 2431642 defendant Lacy Henry tanner 588252 588252 Lacy, Henry, of Hatfeld Peverell, tanner 0
5284388 2440453 2440453 defendant Rolle Thomas husbandman 588252 588252 Rolle, Thomas, of Hatfeld Peverell, husbandman 0
5284390 2440453 2440453 defendant Lovell George husbandman 588252 588252 Lovell, George, of Hatfeld Peverell, husbandman 2
5292956 2442932 2442932 defendant Lane William husbandman 588252 588252 Lane, William, of Hatfeld Peverell, husbandman 0
5292957 2442932 2442932 defendant Laweles Philip husbandman 588252 588252 Laweles, Philip, of Hatfeld Peverell, husbandman 1
5308233 2447495 2447495 defendant Purfote Richard husbandman 588252 588252 Purfote, Richard, of Hatfeld Peverell, husbandman 0
5322191 2451708 2451708 defendant Broke Richard husbandman 588252 588252 Broke, Richard, of Hatfeld Peverell, husbandman 2
5322192 2451708 2451708 defendant Mytton John husbandman 588252 588252 Mytton, John, of Hatfeld Peverell, husbandman 3
5421625 2481403 2481403 defendant Rochestir Thomas   588252 588252 Rochestir, Thomas, of Hatfeld Peverell, wax chandler 1
5441491 2487378 2487378 defendant Rochestir Thomas Waxchandler 588252 588252 Rochestir, Thomas, of Hatfeld Peverell, Waxchandler 1
5441499 2487380 2487380 defendant Rochestir Thomas waxchandler 588252 588252 Rochestir, Thomas, of Hatfeld Peverell, waxchandler 1
5476354 2497932 2497932 defendant Bardevyle William laborer 588252 588252 Bardevyle, William, of Hatfeld Peverell, laborer 3
5548232 2519511 2519511 plaintiff Isaak alias Foster John   588252 588252 Isaak alias Foster, John, of Hatfeld Peverell 1
5561996 2523490 2523490 defendant Isaak John   588252 588252 Isaak, John, of Hatfeld Peverell 1
5573027 2526664 2526664 defendant Raulyn Colette widow 588252 588252 Raulyn, Colette, of Hatfeld Peverell, widow 0
5573028 2526664 2526664 defendant Raulyn William husbandman 588252 588252 Raulyn, William, of Hatfeld Peverell, husbandman 1
5599130 2534612 2534612 defendant Purfote Robert yeoman 588252 588252 Purfote, Robert, of Hatfeld Peverell, yeoman 0
5617007 2549131 2549131 defendant Fillow John   588252 588252 Fillow, John, of Hatfeld Peverell 0
5630248 2553466 2553466 defendant Fuller Thomas chapman 588252 588252 Fuller, Thomas, of Hatfeld Peverell, chapman 0
5630250 2553467 2553467 defendant Fuller Thomas chapman 588252 588252 Fuller, Thomas, of Hatfeld Peverell, chapman 0
5633704 2554540 2554540 defendant Prowdfot Roger farmer 588252 588252 Prowdfot, Roger, of Hatfeld Peverell, farmer 0
5633706 2554541 2554541 defendant Prowdfot Roger farmer 588252 588252 Prowdfot, Roger, of Hatfeld Peverell, farmer 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);