names

96 rows where place_id = 593064

✎ 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
3610294 1870875 1870875 defendant Glasyer William yeoman 593064 593064 Glasyer, William, of Blakemore, yeoman 0
3610300 1870876 1870876 defendant Glasyer William yeoman 593064 593064 Glasyer, William, of Blakemore, yeoman 0
3766118 1947054 1947054 defendant Maunger Robert collier 593064 593064 Maunger, Robert, of Blakemore, collier 2
3836878 1969432 1969432 defendant Woodwynd Robert husbandman 593064 593064 Woodwynd, Robert, of Blakemore, husbandman 4
3842736 1971260 1971260 defendant Hugh George laborer 593064 593064 Hugh, George, of Blakemore, laborer 2
3871838 1980818 1980818 defendant Pawne William gent 593064 593064 Pawne, William, of Blakemore, gent 2
3893272 1987980 1987980 defendant Brown John chaplain 593064 593064 Brown, John, of Blakemore, chaplain 4
3899218 1989946 1989946 defendant Hewes George yeoman 593064 593064 Hewes, George, of Blakemore, yeoman 1
4183062 2089559 2089559 defendant Burle John tailor 593064 593064 Burle, John, of Blakemore, tailor 0
4232116 2106735 2106735 defendant Burle Richard tailor 593064 593064 Burle, Richard, of Blakemore, tailor 0
4473100 2192252 2192252 defendant Roudon John   593064 593064 Roudon, John, of Blakemore 0
4479169 2194140 2194140 plaintiff Houchon John   593064 593064 Houchon, John, of Blakemore 0
4505086 2202123 2202123 defendant Taunere John   593064 593064 Taunere, John, of Blakemore 0
4505091 2202125 2202125 defendant Tannere John   593064 593064 Tannere, John, of Blakemore 0
4543664 2213914 2213914 defendant Hullewey William   593064 593064 Hullewey, William, of Blakemore 1
4561377 2219504 2219504 defendant Clyfford John   593064 593064 Clyfford, John, of Blakemore 3
4562726 2219898 2219898 plaintiff Prior Stephen   593064 593064 Prior, Stephen, of Blakemore 0
4581892 2225783 2225783 defendant Munde John   593064 593064 Munde, John, of Blakemore 4
4601949 2231832 2231832 defendant Clifford John   593064 593064 Clifford, John,of Blakemore 9
4605958 2232978 2232978 defendant Ruddok John   593064 593064 Ruddok, John, of Blakemore 0
4607270 2233386 2233386 defendant Man John   593064 593064 Man, John, of Blakemore 0
4615103 2235734 2235734 defendant Reynold John   593064 593064 Reynold, John, of Blakemore 2
4615136 2235743 2235743 defendant Reynold John   593064 593064 Reynold, John, of Blakemore 1
4619872 2237195 2237195 plaintiff Houchon Richard   593064 593064 Houchon, Richard, of Blakemore 0
4627256 2239473 2239473 plaintiff Reynold John   593064 593064 Reynold, John, of Blakemore 0
4636755 2242314 2242314 defendant Man John   593064 593064 Man, John, of Blakemore 0
4638618 2242831 2242831 defendant Reynold John   593064 593064 Reynold, John, of Blakemore 6
4640742 2243396 2243396 defendant Tyler William   593064 593064 Tyler, William, of Blakemore 1
4646778 2245123 2245123 defendant Reynold John   593064 593064 Reynold, John, of Blakemore 2
4646779 2245123 2245123 defendant Gybbe William   593064 593064 Gybbe, William, of Blakemore 3
4646781 2245123 2245123 defendant White John   593064 593064 White, John, of Blakemore 5
4647781 2245415 2245415 plaintiff Smyth William   593064 593064 Smyth, William, of Blakemore 0
4647785 2245415 2245415 defendant Houthon John   593064 593064 Houthon, John, of Blakemore 3
4647789 2245416 2245416 plaintiff Smyth William   593064 593064 Smyth, William, of Blakemore 0
4647791 2245416 2245416 defendant Reynold John   593064 593064 Reynold, John, of Blakemore 1
4656898 2248052 2248052 defendant Short William   593064 593064 Short, William, of Blakemore 12
4666855 2255361 2255361 plaintiff Alcokes William   593064 593064 Alcokes, William, of Blakemore, stannary or tin bailiff, on his own account 0
4713847 2269655 2269655 defendant Munde John husbandman 593064 593064 Munde, John, of Blakemore, husbandman 0
4734540 2275971 2275971 defendant Fuller John husbandman 593064 593064 Fuller, John, of Blakemore, husbandman 0
4754127 2281669 2281669 plaintiff Sprygge John   593064 593064 Sprygge, John, of Blakemore 2
4754128 2281669 2281669 defendant Wolf Robert husbandman 593064 593064 Wolf, Robert, of Blakemore, husbandman 0
4801464 2296639 2296639 defendant Bette William miller 593064 593064 Bette, William, of Blakemore, miller 0
4801465 2296639 2296639 defendant Bret Alice   593064 593064 Bret, Alice, of Blakemore, widow of Bret, John 1
4804261 2297518 2297518 defendant Tyler William butcher 593064 593064 Tyler, William, of Blakemore, butcher 0
4811725 2299775 2299775 defendant Martyn John laborer 593064 593064 Martyn, John, of Blakemore, laborer 3
4831200 2305790 2305790 defendant Elkyn John husbandman 593064 593064 Elkyn, John, of Blakemore, husbandman 0
4832299 2306134 2306134 defendant Sprygge John draper 593064 593064 Sprygge, John, of Blakemore, draper 0
4832300 2306134 2306134 defendant Gerold John butcher 593064 593064 Gerold, John, of Blakemore, butcher 1
4832301 2306134 2306134 defendant Gerold wm fuller 593064 593064 Gerold, wm, of Blakemore, fuller 2
4899099 2326360 2326360 defendant Wyot Geoffrey husbandman 593064 593064 Wyot, Geoffrey, of Blakemore, husbandman 0
4899100 2326360 2326360 defendant Huchon Richard husbandman 593064 593064 Huchon, Richard, of Blakemore, husbandman 1
4899103 2326360 2326360 defendant Elkyn Thomas husbandman 593064 593064 Elkyn, Thomas, of Blakemore, husbandman 4
4943359 2339892 2339892 defendant Hooke William butcher 593064 593064 Hooke, William, of Blakemore, butcher 0
4943360 2339892 2339892 defendant Houchon John butcher 593064 593064 Houchon, John, of Blakemore, butcher 1
4946797 2341001 2341001 defendant Kyng John maltman 593064 593064 Kyng, John, of Blakemore, maltman 0
4963780 2346079 2346079 defendant Elkyn Thomas drover 593064 593064 Elkyn, Thomas, of Blakemore, drover 0
4963781 2346079 2346079 defendant Huchun John butcher 593064 593064 Huchun, John, of Blakemore, butcher 1
4970588 2348144 2348144 defendant Tyler William butcher 593064 593064 Tyler, William, of Blakemore, butcher 0
4985407 2352557 2352557 defendant Janyn Geoffrey husbandman 593064 593064 Janyn, Geoffrey, of Blakemore, husbandman 1
4987706 2353288 2353288 defendant Palmer John baker 593064 593064 Palmer, John, of Blakemore, baker 0
5016301 2361657 2361657 defendant Palmer Thomas spooner 593064 593064 Palmer, Thomas, of Blakemore, spooner 4
5016303 2361658 2361658 defendant Baldewyn Robert baker 593064 593064 Baldewyn, Robert, of Blakemore, baker 0
5019685 2362638 2362638 defendant Hochon John yeoman 593064 593064 Hochon, John, of Blakemore, yeoman 0
5036143 2367424 2367424 defendant Pulter John pulter 593064 593064 Pulter, John, of Blakemore, pulter 1
5036147 2367425 2367425 defendant Pulter John pulter 593064 593064 Pulter, John, of Blakemore, pulter 1
5045520 2370288 2370288 defendant Kyng John maltman 593064 593064 Kyng, John, of Blakemore, maltman 2
5046152 2370478 2370478 plaintiff (not given) William prior of Manypeny 593064 593064 Manypeny, William, of Blakemore, prior of the priory of St Lawrence the Martyr 0
5046154 2370478 2370478 defendant Gay John dyer 593064 593064 Gay, John, of Blakemore, dyer 1
5047189 2370780 2370780 defendant Elkyn Thomas husbandman 593064 593064 Elkyn, Thomas, of Blakemore, husbandman 2
5047190 2370780 2370780 defendant Elkyn John husbandman 593064 593064 Elkyn, John, of Blakemore, husbandman 3
5047635 2370911 2370911 defendant Elkyn Thomas husbandman 593064 593064 Elkyn, Thomas, of Blakemore, husbandman 0
5061805 2375126 2375126 defendant Elkyn Thomas husbandman 593064 593064 Elkyn, Thomas, of Blakemore, husbandman 1
5073651 2378602 2378602 defendant Spregge thomas hosier 593064 593064 Spregge, thomas, of Blakemore, hosier 1
5086822 2382543 2382543 defendant Rakysworthy John yeoman 593064 593064 Rakysworthy, John, of Blakemore, yeoman 1
5100226 2386506 2386506 defendant Sponere alias Palmer John, senior husbandman 593064 593064 Sponere alias Palmer, John, senior, of Blakemore, husbandman 0
5266460 2435257 2435257 defendant Glasyer William baker 593064 593064 Glasyer, William, of Blakemore, baker 0
5381515 2469771 2469771 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5381521 2469772 2469772 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5381527 2469773 2469773 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5389061 2471921 2471921 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5389067 2471922 2471922 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5411478 2478390 2478390 defendant Standon John yeoman 593064 593064 Standon, John, of Blakemore, yeoman 4
5414717 2479339 2479339 plaintiff Castelyn Robert laborer 593064 593064 Castelyn, Robert, of Blakemore, laborer 2
5414728 2479341 2479341 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5414733 2479342 2479342 defendant Castelyn William   593064 593064 Castelyn, William, of Blakemore 1
5425753 2482672 2482672 defendant Saman John yeoman 593064 593064 Saman, John, of Blakemore, yeoman 4
5430597 2484086 2484086 defendant Castelyn William laborer 593064 593064 Castelyn, William, of Blakemore, laborer 2
5456881 2491963 2491963 defendant Saman John yeoman 593064 593064 Saman, John, of Blakemore, yeoman 2
5463087 2493872 2493872 defendant Broday Thomas husbandman 593064 593064 Broday, Thomas, of Blakemore, husbandman 1
5474630 2497392 2497392 defendant Broday Thomas husbandman 593064 593064 Broday, Thomas, of Blakemore, husbandman 1
5482833 2499811 2499811 defendant Dodde William yeoman 593064 593064 Dodde, William, of Blakemore, yeoman 0
5482878 2499823 2499823 defendant Dodde William yeoman 593064 593064 Dodde, William, of Blakemore, yeoman 1
5547528 2519294 2519294 defendant Rolff John butcher 593064 593064 Rolff, John, of Blakemore, butcher 0
5601265 2535285 2535285 defendant Heygate alias Parsonage John shoemaker 593064 593064 Heygate alias Parsonage, John, of Blakemore, shoemaker 2
5609014 2537721 2537721 defendant Carlyn William yeoman 593064 593064 Carlyn, William, of Blakemore, yeoman 2
5634308 2554718 2554718 defendant Man Robert yeoman 593064 593064 Man, Robert, of Blakemore, yeoman 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);