names

148 rows where place_id = 595741

✎ 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
3621716 1874332 1874332 defendant Gate John butcher 595741 595741 Gate, John, of Nuneton, butcher 0
3621717 1874332 1874332 defendant Tomson Thomas barker 595741 595741 Tomson, Thomas, of Nuneton, barker 1
3621718 1874332 1874332 defendant Smyth William smith 595741 595741 Smyth, William, of Nuneton, smith 2
3621719 1874332 1874332 defendant Gardener John yeoman 595741 595741 Gardener, John, of Nuneton, yeoman 3
3621720 1874332 1874332 defendant Camp or Camper Lawrence yeoman 595741 595741 Camp or Camper, Lawrence, of Nuneton, yeoman 4
3621721 1874332 1874332 defendant Peres John laborer 595741 595741 Peres, John, of Nuneton, laborer 5
3636789 1906296 1906296 plaintiff Rowlot Robert   595741 595741 Rowlot, Robert, of Nuneton 0
3649775 1910292 1910292 plaintiff Rawlott Robert   595741 595741 Rawlott, Robert, of Nuneton 0
3660169 1913440 1913440 plaintiff (not given) Elizabeth prioress of Hasilrigg 595741 595741 Hasilrigg, Elizabeth, of Nuneton, prioress of the monastery of St Mary 0
3677638 1919048 1919048 defendant Bayly George bellfounder 595741 595741 Bayly, George, of Nuneton, bellfounder 0
3700478 1926387 1926387 defendant Logan Roger chaplain 595741 595741 Logan, Roger, of Nuneton, chaplain 1
3701188 1926618 1926618 defendant Smyth Robert yeoman 595741 595741 Smyth, Robert, of Nuneton, yeoman 5
3701195 1926619 1926619 defendant Smyth Robert yeoman 595741 595741 Smyth, Robert, of Nuneton, yeoman 5
3703725 1927446 1927446 defendant Cosby Christopher weaver 595741 595741 Cosby, Christopher, of Nuneton, weaver 1
3713770 1930604 1930604 defendant Hall Richard husbandman 595741 595741 Hall, Richard, of Nuneton, husbandman 5
3714119 1930716 1930716 plaintiff Astell William   595741 595741 Astell, William, of Nuneton 1
3715544 1931146 1931146 defendant Smyth Richard butcher 595741 595741 Smyth, Richard, of Nuneton, butcher 7
3741104 1939080 1939080 defendant Jeynkynson William laborer 595741 595741 Jeynkynson, William, of Nuneton, laborer 1
3741246 1939120 1939120 defendant Wurship Richard tanner 595741 595741 Wurship, Richard, of Nuneton, tanner 0
3741247 1939120 1939120 defendant Turnour John tailor 595741 595741 Turnour, John, of Nuneton, tailor 1
3741248 1939120 1939120 defendant Assheborne William brasier 595741 595741 Assheborne, William, of Nuneton, brasier 2
3743091 1939692 1939692 defendant Nyghtyngale John tailor 595741 595741 Nyghtyngale, John, of Nuneton, tailor 0
3756477 1944000 1944000 defendant Rampyon John yeoman 595741 595741 Rampyon, John, of Nuneton, yeoman 1
3756478 1944000 1944000 defendant Halle Richard yeoman 595741 595741 Halle, Richard, of Nuneton, yeoman 2
3785569 1953276 1953276 defendant Shardeley Robert yeoman 595741 595741 Shardeley, Robert, of Nuneton, yeoman 1
3798604 1957469 1957469 defendant Hall Joan widow 595741 595741 Hall, Joan, of Nuneton, widow 2
3798852 1957555 1957555 defendant Hall Robert (legal representative) 595741 595741 Hall, Robert, of Nuneton, husbandman, executrix of 4
3798853 1957555 1957555 defendant Hall Joan widow 595741 595741 Hall, Joan, of Nuneton, widow 5
3866668 1979085 1979085 defendant Slade Henry plumber or pewterer 595741 595741 Slade, Henry, of Nuneton, plumber or pewterer 0
3875059 1981888 1981888 defendant Fyndern William gent 595741 595741 Fyndern, William, of Nuneton, gent 0
3882756 1984497 1984497 plaintiff Tomson Thomas (legal representative) 595741 595741 Tomson, Thomas, of Nuneton, executors of 0
3909572 1993505 1993505 defendant Chaplyn William yeoman 595741 595741 Chaplyn, William, of Nuneton, yeoman 0
3968917 2013752 2013752 defendant Stonyng Thomas clerk 595741 595741 Stonyng, Thomas, of Nuneton, clerk 10
3968955 2013758 2013758 defendant Stonyng Thomas clerk 595741 595741 Stonyng, Thomas, of Nuneton, clerk 15
4076981 2052051 2052051 defendant Webbe Randolph blacksmith 595741 595741 Webbe, Randolph, of Nuneton, blacksmith 0
4083251 2054299 2054299 defendant Musson John laborer 595741 595741 Musson John, of Nuneton, laborer 0
4083252 2054299 2054299 defendant Ethell alias Laurence John laborer 595741 595741 Ethell alias Laurence, John, of Nuneton, laborer 1
4083253 2054299 2054299 defendant None John laborer 595741 595741 None, John, of Nuneton, laborer 2
4083254 2054299 2054299 defendant Pate Ralph laborer 595741 595741 Pate, Ralph, of Nuneton, laborer 3
4083255 2054299 2054299 defendant Evans Thomas laborer 595741 595741 Evans, Thomas, of Nuneton, laborer 4
4083256 2054299 2054299 defendant Agar Alexander laborer 595741 595741 Agar, Alexander, of Nuneton, laborer 5
4083257 2054299 2054299 defendant Sherman Henry laborer 595741 595741 Sherman, Henry, of Nuneton, laborer 6
4083258 2054299 2054299 defendant Hore William laborer 595741 595741 Hore, William, of Nuneton, laborer 7
4115601 2065863 2065863 defendant Mussen John yeoman 595741 595741 Mussen, John, of Nuneton, yeoman 2
4115602 2065863 2065863 defendant Ethell alias Laurence John laborer 595741 595741 Ethell alias Laurence, John, of Nuneton, laborer 3
4281345 2123380 2123380 defendant Parker John cutler 595741 595741 Parker, John, of Nuneton, ,cutler 2
4521408 2207039 2207039 defendant Huby Nicholas   595741 595741 Huby, Nicholas, of Nuneton, vicar 1
4569015 2221894 2221894 plaintiff Wareyn Thomas   595741 595741 Wareyn, Thomas, of Nuneton 0
4569016 2221894 2221894 defendant Derby Nicholas   595741 595741 Derby, Nicholas, of Nuneton, vicar 0
4613139 2235167 2235167 defendant Shepherd John   595741 595741 Shepherd, John, of Nuneton 3
4621118 2237587 2237587 defendant Walker William   595741 595741 Walker, William, of Nuneton 0
4628662 2239888 2239888 defendant Bosvyll William   595741 595741 Bosvyll, William, of Nuneton 0
4629390 2240121 2240121 defendant Lutulworth Thomas   595741 595741 Lutulworth, Thomas, of Nuneton 1
4632725 2241120 2241120 plaintiff Walcote Elizabeth   595741 595741 Walcote, Elizabeth, of Nuneton, prioress 0
4651385 2246437 2246437 defendant Knyght Alexander yeoman 595741 595741 Knyght, Alexander, of Nuneton, yeoman 0
4674906 2257761 2257761 defendant barker William tanner 595741 595741 barker, William, of Nuneton, tanner 0
4693282 2263400 2263400 defendant Aleyn John chaplain 595741 595741 Aleyn, John, of Nuneton, chaplain 0
4712575 2269251 2269251 defendant Bosevyle John husbandman 595741 595741 Bosevyle, John, of Nuneton, husbandman 1
4719869 2271559 2271559 defendant Milner John weaver 595741 595741 Milner, John, of Nuneton, weaver 0
4744360 2278874 2278874 plaintiff Egle William   595741 595741 Egle, William, of Nuneton 0
4744364 2278875 2278875 plaintiff Egle William   595741 595741 Egle, William, of Nuneton, on his own account 0
4779912 2289717 2289717 defendant Wayte Roger husbandman 595741 595741 Wayte, Roger, of Nuneton, husbandman 2
4785905 2291628 2291628 defendant Stamford Robert barker 595741 595741 Stamford, Robert, of Nuneton, barker 0
4808979 2298983 2298983 defendant Reynold William husbandman 595741 595741 Reynold, William, of Nuneton, husbandman 0
4827846 2304759 2304759 defendant Smyth William smith 595741 595741 Smyth, William, of Nuneton, smith 2
4851808 2312003 2312003 plaintiff Walcote Elizabeth   595741 595741 Walcote, Elizabeth, of Nuneton, prioress 0
4853352 2312459 2312459 defendant Umfrey John   595741 595741 Umfrey, John, of Nuneton 0
4878126 2320110 2320110 defendant Grene Thomas yeoman 595741 595741 Grene, Thomas, of Nuneton, yeoman 3
4905577 2328345 2328345 defendant Assheby John weaver 595741 595741 Assheby, John, of Nuneton, weaver 0
4905578 2328345 2328345 defendant Clerk William weaver 595741 595741 Clerk, William, of Nuneton, weaver 1
4905579 2328345 2328345 defendant Frencheman Robert weaver 595741 595741 Frencheman, Robert, of Nuneton, weaver 2
4909046 2329371 2329371 defendant Smyth William tanner 595741 595741 Smyth, William, of Nuneton, tanner 0
4928283 2335272 2335272 defendant Chaloner Roger husbandman 595741 595741 Chaloner, Roger, of Nuneton, husbandman 4
4928284 2335272 2335272 defendant Bocher John husbandman 595741 595741 Bocher, John, of Nuneton, husbandman 5
4936701 2337861 2337861 defendant Crosse William   595741 595741 Crosse, William, of Nuneton, mason 1
4949987 2341966 2341966 defendant Couper Robert cordwainer 595741 595741 Couper, Robert, of Nuneton, cordwainer 0
4969505 2347826 2347826 defendant Benet John chaplain 595741 595741 Benet, John, of Nuneton, chaplain 0
4980040 2350983 2350983 defendant Rowetly Roger husbandman 595741 595741 Rowetly, Roger, of Nuneton, husbandman 1
4980041 2350983 2350983 defendant Broke William husbandman 595741 595741 Broke, William, of Nuneton, husbandman 2
4980042 2350983 2350983 defendant Milner Richard yeoman 595741 595741 Milner, Richard, of Nuneton, yeoman 3
4980045 2350984 2350984 defendant Borwey Robert carpenter 595741 595741 Borwey, Robert, of Nuneton, carpenter 0
4980046 2350984 2350984 defendant Slade Robert tailor 595741 595741 Slade, Robert, of Nuneton, tailor 1
4980047 2350984 2350984 defendant Walker William fuller 595741 595741 Walker, William, of Nuneton, fuller 2
4980048 2350984 2350984 defendant Wykay John   595741 595741 Wykay, John, of Nuneton, malt maker 3
4980049 2350984 2350984 defendant Assheby John yeoman 595741 595741 Assheby, John, of Nuneton, yeoman 4
4980052 2350985 2350985 defendant Sponer William tanner 595741 595741 Sponer, William, of Nuneton, tanner 0
4980053 2350985 2350985 defendant Hudde John husbandman 595741 595741 Hudde, John, of Nuneton, husbandman 1
4980054 2350985 2350985 defendant Thorp John weaver 595741 595741 Thorp, John, of Nuneton, weaver 2
4980055 2350985 2350985 defendant Wryght John carpenter 595741 595741 Wryght, John, of Nuneton, carpenter 3
4980056 2350985 2350985 defendant Deyster John baker 595741 595741 Deyster, John, of Nuneton, baker 4
5007177 2358989 2358989 defendant Reynold John weaver 595741 595741 Reynold, John, of Nuneton, weaver 0
5010281 2359871 2359871 plaintiff (not given) Elizabeth prioress of Walcots 595741 595741 Walcots, Elizabeth, of Nuneton, prioress of the House & church of the BM 0
5010282 2359871 2359871 defendant (illegible) John husbandman 595741 595741 _, John, of Nuneton, husbandman 0
5011867 2360322 2360322 defendant Boswell Richard chandler 595741 595741 Boswell, Richard, of Nuneton, chandler 1
5015434 2361395 2361395 defendant Umfrey John yeoman 595741 595741 Umfrey, John, of Nuneton, yeoman 0
5033517 2366684 2366684 defendant Milward Emma widow 595741 595741 Milward, Emma, of Nuneton, widow 1
5053424 2372629 2372629 defendant Busvyle Richard chandler 595741 595741 Busvyle, Richard, of Nuneton, chandler 0
5073775 2378644 2378644 defendant Symson Thomas carpenter 595741 595741 Symson, Thomas, of Nuneton, carpenter 0
5085676 2382210 2382210 defendant Catton John laborer 595741 595741 Catton, John, of Nuneton, laborer 2
5085677 2382210 2382210 defendant Busshop John yeoman 595741 595741 Busshop, John,of Nuneton, yeoman 3

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