names

63 rows where place_id = 592837

✎ 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
3609129 1870513 1870513 defendant Aylton alias Mortyn Robert tailor 592837 592837 Aylton alias Mortyn, Robert, of Hamme, tailor 0
3658333 1912859 1912859 defendant Cartwright Robert husbandman 592837 592837 Cartwright, Robert, of Hamme, husbandman 1
3892815 1987846 1987846 defendant Cloterbucke Thomas weaver 592837 592837 Cloterbucke, Thomas, of Hamme, weaver 0
3912384 1994472 1994472 defendant Turnour John husbandman 592837 592837 Turnour, John, of Hamme, husbandman 0
4440073 2181822 2181822 defendant Shelford John   592837 592837 Shelford, John, of Hamme 0
4441583 2182302 2182302 defendant Shelford John   592837 592837 Shelford, John, of Hamme 0
4453202 2186009 2186009 defendant atte More Richard   592837 592837 atte More, Richard, of Hamme 0
4455294 2186664 2186664 defendant Mogge John   592837 592837 Mogge, John, of Hamme 14
4465060 2189734 2189734 plaintiff Whyte Richard   592837 592837 Whyte, Richard, of Hamme 0
4470583 2191446 2191446 defendant Somersoule Richard   592837 592837 Somersoule, Richard, of Hamme 0
4472178 2191963 2191963 defendant Hegge William   592837 592837 Hegge, William, of Hamme 0
4475668 2193070 2193070 defendant Clerk Nicholas   592837 592837 Clerk, Nicholas, of Hamme 3
4508391 2203110 2203110 defendant Helyot William   592837 592837 Helyot, William, of Hamme 0
4511460 2204029 2204029 defendant Fyneaux Thomas   592837 592837 Fyneaux, Thomas, of Hamme 0
4556224 2217884 2217884 defendant Eldeslegh John   592837 592837 Eldeslegh, John, of Hamme 0
4561965 2219674 2219674 defendant Golowe John   592837 592837 Golowe, John, of Hamme 0
4595046 2229709 2229709 defendant Neel John   592837 592837 Neel, John, of Hamme 1
4598541 2230780 2230780 defendant Webbe John   592837 592837 Webbe, John, of Hamme 0
4598542 2230780 2230780 defendant Colyns John   592837 592837 Colyns, John, of Hamme 1
4629782 2240235 2240235 defendant White John   592837 592837 White, John, of Hamme 0
4666390 2250963 2250963 defendant Neel John carrier 592837 592837 Neel, John, of Hamme, carrier 4
4709144 2268225 2268225 defendant Wenynger John husbandman 592837 592837 Wenynger, John, of Hamme, husbandman 2
4725265 2273193 2273193 defendant Hamme John husbandman 592837 592837 Hamme, John, of Hamme, husbandman 0
4732941 2275481 2275481 plaintiff Polyngton John   592837 592837 Polyngton, John, of Hamme 0
4771606 2287097 2287097 defendant Smyth Richard laborer 592837 592837 Smyth, Richard, of Hamme, laborer 1
4789391 2292747 2292747 defendant Pyn Robert gent 592837 592837 Pyn, Robert, of Hamme, gent 1
4789905 2292912 2292912 defendant Bent William laborer 592837 592837 Bent, William, of Hamme, laborer 0
4824274 2303659 2303659 defendant Cruek Thomas husbandman 592837 592837 Cruek, Thomas, of Hamme, husbandman 2
4831382 2305846 2305846 defendant Webbe John laborer 592837 592837 Webbe, John, of Hamme, laborer 0
4868602 2317154 2317154 defendant Loveyn Robert husbandman 592837 592837 Loveyn, Robert, of Hamme, husbandman 1
4872162 2318254 2318254 defendant Webbe William husbandman 592837 592837 Webbe, William, of Hamme, husbandman 0
4872163 2318254 2318254 defendant Greyell John husbandman 592837 592837 Greyell, John, of Hamme, husbandman 1
4910388 2329766 2329766 defendant Nele John husbandman 592837 592837 Nele, John, of Hamme in Briggewater, husbandman 0
4929887 2335759 2335759 defendant Bruton William yeoman 592837 592837 Bruton, William, of Hamme, yeoman 7
4932572 2336580 2336580 defendant Bruton William yeoman 592837 592837 Bruton, William, of Hamme, yeoman 8
4938800 2338526 2338526 defendant Milward Thomas   592837 592837 Milward, Thomas, of Hamme, millward 0
4954109 2343195 2343195 defendant Nele Robert husbandman 592837 592837 Nele, Robert, of Hamme, Bryggewater, husbandman 0
4960605 2345137 2345137 defendant Polhampton John husbandman 592837 592837 Polhampton, John, of Hamme, husbandman 0
4960606 2345137 2345137 defendant Polhampton Edmund husbandman 592837 592837 Polhampton, Edmund, of Hamme, husbandman 1
4960966 2345246 2345246 defendant le Frende John husbandman 592837 592837 le Frende, John, of Hamme, husbandman 1
4960967 2345246 2345246 defendant Greylle William husbandman 592837 592837 Greylle, William, of Hamme, husbandman 2
4960968 2345246 2345246 defendant Greyll Thomas husbandman 592837 592837 Greyll, Thomas, of Hamme, husbandman 3
4979345 2350783 2350783 defendant Goderych Thomas gent 592837 592837 Goderych, Thomas, of Hamme, gent 0
4979347 2350784 2350784 defendant Goderyche Thomas gent 592837 592837 Goderyche, Thomas, of Hamme, gent 0
4984701 2352352 2352352 defendant Smyth John laborer 592837 592837 Smyth, John, of Hamme, laborer 0
5031295 2366010 2366010 plaintiff Pyn Robert   592837 592837 Pyn, Robert, of Hamme 0
5102349 2387099 2387099 defendant Botiller John, junior husbandman 592837 592837 Botiller, John, junior, of Hamme, husbandman 21
5102351 2387099 2387099 defendant Malette John husbandman 592837 592837 Malette, John, of Hamme, husbandman 23
5102378 2387100 2387100 defendant Botiller John, junior husbandman 592837 592837 Botiller, John, junior, of Hamme, husbandman 21
5102380 2387100 2387100 defendant Malette John husbandman 592837 592837 Malette, John, of Hamme, husbandman 23
5113343 2390294 2390294 defendant Lumbard William husbandman 592837 592837 Lumbard, William, of Hamme juxta Briggewater, husbandman 0
5113344 2390294 2390294 defendant Parys John weaver 592837 592837 Parys, John, of Hamme juxta Briggewater, weaver 1
5194475 2414112 2414112 defendant Aleyn John yeoman 592837 592837 Aleyn, John, of Hamme, yeoman 2
5282709 2440005 2440005 defendant Cryche Robert husbandman 592837 592837 Cryche, Robert, of Hamme juxta Briggewater, husbandman 6
5282710 2440005 2440005 defendant Lambard William husbandman 592837 592837 Lambard, William, of Hamme juxta Briggewater, husbandman 7
5328927 2453727 2453727 defendant Jenyn Thomas husbandman 592837 592837 Jenyn, Thomas, of Hamme, husbandman 2
5388326 2471708 2471708 defendant Rotte John brewer 592837 592837 Rotte, John, of Hamme, brewer 1
5388330 2471709 2471709 defendant Rotte John brewer 592837 592837 Rotte, John, of Hamme, brewer 1
5397894 2474470 2474470 defendant Wynfeld Robert husbandman 592837 592837 Wynfeld, Robert, of Hamme, husbandman 2
5435385 2485523 2485523 defendant Danell Bartholomew husbandman 592837 592837 Danell, Bartholomew, of Hamme, husbandman 3
5444750 2488325 2488325 defendant Codde Thomas husbandman 592837 592837 Codde, Thomas, of Hamme, in Lynmynster, husbandman 1
5450420 2490013 2490013 defendant Banell Bartholomew husbandman 592837 592837 Banell, Bartholomew, of Hamme, husbandman 3
5473582 2497064 2497064 defendant Clerke John husbandman 592837 592837 Clerke, John, of Hamme by Bridgewater, husbandman 3

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