names

194 rows where place_id = 588742

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590923 1864787 1864787 defendant John Henry   588742 588742 John, Henry, of Lamberherst, "ripeer" 4
3595428 1866203 1866203 defendant Hotspore John husbandman 588742 588742 Hotspore, John, of Lamberherst, husbandman 0
3596024 1866383 1866383 defendant Selcok Thomas collier 588742 588742 Selcok, Thomas, of Lamberherst, collier 0
3601819 1868225 1868225 defendant Taunton John laborer 588742 588742 Taunton, John, of Lamberherst, laborer 3
3602742 1868523 1868523 defendant Godfrey Robert   588742 588742 Godfrey, Robert, of Lamberherst, cloth maker 0
3603305 1868707 1868707 defendant Hotspore John husbandman 588742 588742 Hotspore, John, of Lamberherst, husbandman 1
3611621 1871304 1871304 defendant Alen William husbandman 588742 588742 Alen, William, of Lamberherst, husbandman 0
3611622 1871304 1871304 defendant Alen Stephen laborer 588742 588742 Alen, Stephen, of Lamberherst, laborer 1
3622049 1874437 1874437 defendant Chawry John yeoman 588742 588742 Chawry, John, of Lamberherst, yeoman 1
3632640 1905027 1905027 defendant Ricard Henry laborer 588742 588742 Ricard, Henry, of Lamberherst, laborer 0
3632646 1905027 1905027 defendant Barke Jelnet laborer 588742 588742 Barke, Jelnet, of Lamberherst, laborer 6
3641743 1907868 1907868 defendant Brodde Richard repyer 588742 588742 Brodde, Richard, of Lamberherst, repyer 0
3644826 1908789 1908789 defendant Colyn John miner 588742 588742 Colyn, John, of Lamberherst, miner 0
3644827 1908789 1908789 defendant Riccard Henry yeoman 588742 588742 Riccard, Henry, of Lamberherst, yeoman 1
3644828 1908789 1908789 defendant Welford William clothman 588742 588742 Welford, William, of Lamberherst, clothman 2
3644830 1908789 1908789 defendant Loby John collier 588742 588742 Loby, John, of Lamberherst, collier 4
3656357 1912234 1912234 defendant Fonle Christopher repyer 588742 588742 Fonle, Christopher, of Lamberherst, repyer 0
3680369 1919940 1919940 defendant Sandell Thomas carpenter 588742 588742 Sandell, Thomas, of Lamberherst, carpenter 1
3689880 1922994 1922994 defendant Harrys Robert clerk of the forge at Begham 588742 588742 Harrys, Robert, of Lamberherst, yeoman, clerk of the forge at Begham 0
3699964 1926221 1926221 defendant Groute John collier 588742 588742 Groute, John, of Lamberherst, collier 2
3699965 1926221 1926221 defendant Reynold Guntun smith 588742 588742 Reynold, Guntun, of Lamberherst, smith 3
3703235 1927283 1927283 plaintiff Darell Henry   588742 588742 Darell, Henry, of Lamberherst 1
3704738 1927771 1927771 defendant Jakson Thomas yeoman 588742 588742 Jakson, Thomas, of Lamberherst, yeoman 0
3704739 1927771 1927771 defendant Est Joan widow 588742 588742 Est, Joan, of Lamberherst, widow 1
3722311 1933239 1933239 defendant Lamkyn William tailor 588742 588742 Lamkyn, William, of Lamberherst, tailor 1
3723487 1933612 1933612 plaintiff Patynden Walter   588742 588742 Patynden, Walter, of Lamberherst 0
3723488 1933612 1933612 defendant Jakeson Thomas husbandman 588742 588742 Jakeson, Thomas, of Lamberherst, husbandman 0
3732924 1936521 1936521 defendant Thomas William gent 588742 588742 Thomas, William, of Lamberherst, gent 0
3732925 1936521 1936521 defendant Grome Richard laborer 588742 588742 Grome, Richard, of Lamberherst, laborer 1
3732926 1936521 1936521 defendant Busse Henry laborer 588742 588742 Busse, Henry, of Lamberherst, laborer 2
3732931 1936523 1936523 defendant Grome Richard laborer 588742 588742 Grome, Richard, of Lamberherst, laborer 0
3753013 1942876 1942876 defendant Rammesden Vincent tailor 588742 588742 Rammesden, Vincent, of Lamberherst, tailor 0
3759213 1944870 1944870 defendant Busse William yeoman 588742 588742 Busse, William, of Lamberherst, yeoman 0
3760231 1945204 1945204 defendant Sampson Henry gent 588742 588742 Sampson, Henry, of Lamberherst, gent 0
3769988 1948270 1948270 defendant Luk Michael yeoman 588742 588742 Luk, Michael, of Lamberherst, yeoman 1
3785256 1953173 1953173 defendant Wyllard Nicholas   588742 588742 Wyllard, Nicholas, of Lamberherst, tile maker 0
3835125 1968926 1968926 defendant Mongge William yeoman 588742 588742 Mongge, William, of Lamberherst, yeoman 0
3835126 1968926 1968926 defendant Rarons James laborer 588742 588742 Rarons, James, of Lamberherst, laborer 1
3837801 1969736 1969736 defendant Burre John beer brewer 588742 588742 Burre, John, of Lamberherst, beer brewer 1
3837807 1969737 1969737 defendant Burre John beer brewer 588742 588742 Burre, John, of Lamberherst, beer brewer 1
3866050 1978877 1978877 defendant Mugge William yeoman 588742 588742 Mugge, William, of Lamberherst, yeoman 0
3866085 1978889 1978889 defendant Mugge William yeoman 588742 588742 Mugge, William, of Lamberherst, yeoman 0
3866087 1978890 1978890 defendant Mugge William yeoman 588742 588742 Mugge, William, of Lamberherst, yeoman 0
3871217 1980627 1980627 defendant Turke Gilbert yeoman 588742 588742 Turke, Gilbert, of Lamberherst, yeoman 1
3880905 1983885 1983885 defendant Mugge William yeoman 588742 588742 Mugge, William, of Lamberherst, yeoman 1
3882937 1984558 1984558 defendant Mugge William yeoman 588742 588742 Mugge, William, of Lamberherst, yeoman 1
3919189 1996744 1996744 defendant Cardnall John husbandman 588742 588742 Cardnall, John, of Lamberherst, husbandman 3
3922340 1997786 1997786 defendant Patynden Walter yeoman 588742 588742 Patynden, Walter, of Lamberherst, yeoman 0
3939976 2003668 2003668 defendant Thatcher Robert yeoman 588742 588742 Thatcher, Robert, of Lamberherst, yeoman 0
4010261 2028438 2028438 defendant Grey John   588742 588742 Grey, John, of Lamberherst, mason 0
4055808 2044458 2044458 defendant Stephen John tanner 588742 588742 Stephen, John, of Lamberherst, tanner 1
4055809 2044458 2044458 defendant Banes Simon shoemaker 588742 588742 Banes, Simon, of Lamberherst, shoemaker 2
4063806 2047340 2047340 defendant Bysshoppe Richard   588742 588742 Bysshoppe, Richard, of Lamberherst, "clovebordehewer" 0
4104378 2061848 2061848 defendant Edborowe Thomas hammer man 588742 588742 Edborowe, Thomas, of Lamberherst, hammer man 2
4104383 2061849 2061849 defendant Edborowe Thomas hammer man 588742 588742 Edborowe, Thomas, of Lamberherst, hammer man 2
4106992 2062796 2062796 defendant Dyne William yeoman 588742 588742 Dyne, William, of Lamberherst, yeoman 2
4195092 2093847 2093847 defendant Bassocke William smith 588742 588742 Bassocke, William, of Lamberherst, smith 0
4226779 2104840 2104840 defendant Weston Barbara widow 588742 588742 Weston, Barbara, of Lamberherst, widow 1
4233378 2107188 2107188 defendant Harrys Thomas clerk 588742 588742 Harrys, Thomas, of Lamberherst, clerk 0
4314380 2135141 2135141 defendant Pomye James collier 588742 588742 Pomye, James, of Lamberherst, collier 0
4314977 2135350 2135350 defendant Prymmer James husbandman 588742 588742 Prymmer, James, of Lamberherst, husbandman 0
4365481 2152721 2152721 defendant Baker William husbandman 588742 588742 Baker, William, of Lamberherst, husbandman 2
4381918 2158638 2158638 defendant Hamper John yeoman 588742 588742 Hamper, John, of Lamberherst, yeoman 1
4381922 2158639 2158639 defendant Hamper John yeoman 588742 588742 Hamper, John, of Lamberherst, yeoman 1
4381986 2158662 2158662 defendant Pomy or Poiny James collier 588742 588742 Pomy or Poiny, James, of Lamberherst, collier 0
4383554 2159209 2159209 defendant Bentkyn George ryppyer or fishmonger 588742 588742 Bentkyn, George, of Lamberherst, ryppyer or fishmonger 1
4401667 2165154 2165154 defendant Leddall Henry husbandman 588742 588742 Leddall, Henry, of Lamberherst, husbandman 2
4516996 2205723 2205723 defendant Couper Roger   588742 588742 Couper, Roger, of Lamberherst 0
4551621 2216450 2216450 defendant Clement John   588742 588742 Clement, John, of Lamberherst 0
4563237 2220073 2220073 plaintiff Remys Thomas   588742 588742 Remys, Thomas, of Lamberherst 0
4632978 2241186 2241186 defendant Wigselle John   588742 588742 Wigselle, John, of Lamberherst 0
4638394 2242774 2242774 defendant Wever William   588742 588742 Wever, William, of Lamberherst 0
4658309 2248482 2248482 defendant Michell Thomas husbandman 588742 588742 Michell, Thomas, of Lamberherst, husbandman 0
4666766 2255335 2255335 defendant Leche Simon ripier 588742 588742 Leche, Simon, of Lamberherst, ripier 2
4681398 2259803 2259803 defendant Wevere William   588742 588742 Wevere, William, of Lamberherst, rypyere or inland fish seller 0
4719944 2271583 2271583 defendant Cloute Richard tailor 588742 588742 Cloute, Richard, of Lamberherst, tailor 0
4753035 2281338 2281338 defendant Clyve Ralph husbandman 588742 588742 Clyve, Ralph, of Lamberherst, husbandman 0
4777352 2288907 2288907 defendant Tylere Robert laborer 588742 588742 Tylere, Robert, of Lamberherst, laborer 0
4779430 2289548 2289548 defendant Pleyr William carpenter 588742 588742 Pleyr, William, of Lamberherst, carpenter 2
4782719 2290610 2290610 defendant Courthope John husbandman 588742 588742 Courthope, John, of Lamberherst, husbandman 0
4795566 2294764 2294764 defendant Osbarn William laborer 588742 588742 Osbarn, William, of Lamberherst, laborer 2
4874804 2319063 2319063 defendant Benet John carpenter 588742 588742 Benet, John, of Lamberherst, carpenter 0
4874805 2319063 2319063 defendant Newenden Thomas ripier or fishmonger 588742 588742 Newenden, Thomas, of Lamberherst, ripier or fishmonger 1
4874911 2319096 2319096 defendant atte Hale William laborer 588742 588742 atte Hale, William, of Lamberherst, laborer 0
4879936 2320640 2320640 defendant Matte William draper 588742 588742 Matte, William, of Lamberherst, draper 0
4881037 2320981 2320981 plaintiff Whytmelk Henry   588742 588742 Whytmelk, Henry, of Lamberherst 0
4891729 2324156 2324156 defendant Faukes Richard husbandman 588742 588742 Faukes, Richard, of Lamberherst, husbandman 1
4893802 2324757 2324757 defendant Roper Edward laborer 588742 588742 Roper, Edward, of Lamberherst, laborer 0
4893803 2324757 2324757 defendant Mat William laborer 588742 588742 Mat, William, of Lamberherst, laborer 1
4893804 2324757 2324757 defendant Couper Henry laborer 588742 588742 Couper, Henry, of Lamberherst, laborer 2
4907205 2328817 2328817 defendant Grigge Richard laborer 588742 588742 Grigge, Richard, of Lamberherst, laborer 1
4952048 2342582 2342582 defendant Burgon Thomas gent 588742 588742 Burgon, Thomas, of Lamberherst, gent 0
4956890 2344020 2344020 defendant Polle John weaver 588742 588742 Polle, John, of Lamberherst, weaver 2
4960755 2345178 2345178 defendant Wyldebore Thomas husbandman 588742 588742 Wyldebore, Thomas, of Lamberherst, husbandman 0
4960756 2345178 2345178 defendant Patenden William husbandman 588742 588742 Patenden, William, of Lamberherst, husbandman 1
4965672 2346657 2346657 defendant Tylemaker Thomas   588742 588742 Tylemaker, Thomas, of Lamberherst, tile maker 0
5018503 2362293 2362293 defendant Pykeryng Robert repier or fishmonger 588742 588742 Pykeryng, Robert, of Lamberherst, repier or fishmonger 0
5018505 2362293 2362293 defendant Burden William ripier or fishmonger 588742 588742 Burden, William, of Lamberherst, ripier or fishmonger 2
5018510 2362294 2362294 defendant Pykeryng Robert ripier or fishmonger 588742 588742 Pykeryng, Robert, of Lamberherst, ripier or fishmonger 0
5018512 2362294 2362294 defendant Burdon William ripier or fishmonger 588742 588742 Burdon, William, of Lamberherst, ripier or fishmonger 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);