names

149 rows where place_id = 602520

✎ 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
3650498 1910525 1910525 defendant Bruer John weaver 602520 602520 Bruer, John, of Castel Combe, weaver 0
3650505 1910527 1910527 defendant Bruer Robert weaver 602520 602520 Bruer, Robert, of Castel Combe, weaver 2
3650506 1910527 1910527 defendant Lewes John weaver 602520 602520 Lewes, John, of Castel Combe, weaver 3
3650507 1910527 1910527 defendant Bayly Robert weaver 602520 602520 Bayly, Robert, of Castel Combe, weaver 4
3661632 1913915 1913915 defendant Brewer John yeoman 602520 602520 Brewer, John, of Castel Combe, yeoman 0
3669224 1916313 1916313 defendant Berser William yeoman 602520 602520 Berser, William, of Castel Combe, yeoman 0
3669225 1916313 1916313 defendant Bruer Robert yeoman 602520 602520 Bruer, Robert, of Castel Combe, yeoman 1
3804112 1959212 1959212 defendant Osborn Nicholas yeoman 602520 602520 Osborn, Nicholas, of Castel Combe, yeoman 1
3804113 1959212 1959212 defendant Bransley John yeoman 602520 602520 Bransley, John, of Castel Combe, yeoman 2
3807293 1960179 1960179 defendant Appowell William mercer 602520 602520 Appowell, William, of Castel Combe, mercer 0
4099931 2060302 2060302 defendant Wyllys alias Otes Richard butcher 602520 602520 Wyllys alias Otes, Richard, of Castel Combe, butcher 0
4462424 2188939 2188939 defendant Toukere Thomas   602520 602520 Toukere, Thomas, of Castel Combe 0
4486824 2196594 2196594 defendant Symonds Richard   602520 602520 Symonds, Richard, of Castel Combe 0
4540495 2212925 2212925 defendant Bokeler Robert   602520 602520 (Bokeler, Robert, of Castel Combe 3
4604208 2232487 2232487 plaintiff Wynhill Adam   602520 602520 Wynhill, Adam, of Castel Combe 0
4739037 2277301 2277301 defendant Webbe Margaret   602520 602520 Webbe, Margaret, of Castel Combe, widow, formerly wife of Edward Webbe 1
4741282 2277947 2277947 defendant Perys Thomas husbandman 602520 602520 Perys, Thomas, of Castel Combe, husbandman 0
4741283 2277947 2277947 defendant Neweman John husbandman 602520 602520 Neweman, John, of Castel Combe, husbandman 1
4741284 2277947 2277947 defendant Wattys Robert husbandman 602520 602520 Wattys, Robert, of Castel Combe, husbandman 2
4745562 2279213 2279213 defendant Rede John weaver 602520 602520 Rede, John, of Castel Combe, weaver 0
4788117 2292356 2292356 defendant Boukeler William tucker 602520 602520 Boukeler, William, of Castel Combe, tucker 0
4788118 2292356 2292356 defendant Boukeler John tucker 602520 602520 Boukeler, John, of Castel Combe, tucker 1
4788119 2292356 2292356 defendant Lacy John tucker 602520 602520 Lacy, John, of Castel Combe, tucker 2
4794826 2294526 2294526 defendant Hopkyns William   602520 602520 Hopkyns, William, of Castel Combe, shepherd 1
4835122 2306983 2306983 defendant Pyppyng John baker 602520 602520 Pyppyng, John, of Castel Combe, baker 1
4872533 2318368 2318368 defendant Baly William tucker 602520 602520 Baly, William, of Castel Combe, tucker 2
4872534 2318368 2318368 defendant Coston John tucker 602520 602520 Coston, John, of Castel Combe, tucker 3
4872535 2318368 2318368 defendant Fynamour John tucker 602520 602520 Fynamour, John, of Castel Combe, tucker 4
4882155 2321322 2321322 plaintiff Benet William weaver 602520 602520 Benet, William, of Castel Combe, weaver 2
4882156 2321322 2321322 defendant Ferrour or Smith William tucker 602520 602520 Ferrour or Smith, William, of Castel Combe, tucker 0
4882157 2321322 2321322 defendant Ferrour or Smith Roger tucker 602520 602520 Ferrour or Smith, Roger, of Castel Combe, tucker 1
4888788 2323284 2323284 defendant Bogeler John clothier 602520 602520 Bogeler, John, of Castel Combe, clothier 2
4900576 2326821 2326821 defendant Land Thomas tucker 602520 602520 Land, Thomas, of Castel Combe, tucker 0
4917986 2332139 2332139 defendant Cofyn or Cosyn William husbandman 602520 602520 Cofyn or Cosyn, William, of Castel Combe, husbandman 1
4945737 2340656 2340656 defendant More William tucker 602520 602520 More, William, of Castel Combe, tucker 0
4945738 2340656 2340656 defendant Stone John tucker 602520 602520 Stone, John, of Castel Combe, tucker 1
4945739 2340656 2340656 defendant Lonkyn Thomas carpenter 602520 602520 Lonkyn, Thomas, of Castel Combe, carpenter 2
4945741 2340656 2340656 defendant Herfordshire John tucker 602520 602520 Herfordshire, John, of Castel Combe, tucker 4
4945743 2340656 2340656 defendant Wheler Thomas tucker 602520 602520 Wheler, Thomas, of Castel Combe, tucker 6
4945744 2340656 2340656 defendant Benet William weaver 602520 602520 Benet, William, of Castel Combe, weaver 7
4945745 2340656 2340656 defendant Benet Robert weaver 602520 602520 Benet, Robert, of Castel Combe, weaver 8
4946305 2340833 2340833 defendant Charlton John tucker 602520 602520 Charlton, John, of Castel Combe, tucker 0
4946306 2340833 2340833 defendant Sampson William husbandman 602520 602520 Sampson, William, of Castel Combe, husbandman 1
4965864 2346720 2346720 defendant Dony Thomas cordwainer 602520 602520 Dony, Thomas, of Castel Combe, cordwainer 0
4965865 2346720 2346720 defendant Dagge Thomas baker 602520 602520 Dagge, Thomas, of Castel Combe, baker 1
4968182 2347435 2347435 defendant Haynes Thomas clothmaker 602520 602520 Haynes, Thomas, of Castel Combe, clothmaker 0
4971033 2348275 2348275 defendant Deverell Thomas dyer 602520 602520 Deverell, Thomas, of Castel Combe, dyer 2
4971037 2348276 2348276 defendant Deverell Thomas dyer 602520 602520 Deverell, Thomas, of Castel Combe, dyer 2
4971317 2348355 2348355 defendant atte Mille William husbandman 602520 602520 atte Mille, William, of Castel Combe, husbandman 0
4980757 2351183 2351183 defendant Cosyn William cooper 602520 602520 Cosyn, William, of Castel Combe, cooper 0
4980758 2351183 2351183 defendant Briggeman Nicholas weaver 602520 602520 Briggeman, Nicholas, of Castel Combe, weaver 1
4980759 2351183 2351183 defendant Clavele or Clanele Robert weaver 602520 602520 Clavele or Clanele, Robert, of Castel Combe, weaver 2
5013827 2360894 2360894 defendant B- William weaver 602520 602520 B-, William, of Castel Combe, weaver 1
5017182 2361921 2361921 defendant Jones Edward dyer 602520 602520 Jones, Edward, of Castel Combe, dyer 0
5017183 2361921 2361921 defendant Dytton Richard fuller 602520 602520 Dytton, Richard, of Castel Combe, fuller 1
5017184 2361921 2361921 defendant Boys Robert weaver 602520 602520 Boys, Robert, of Castel Combe, weaver 2
5017185 2361921 2361921 defendant Deny Thomas cordwainer 602520 602520 Deny, Thomas, of Castel Combe, cordwainer 3
5017186 2361921 2361921 defendant Haynys Thomas fuller 602520 602520 Haynys, Thomas, of Castel Combe, fuller 4
5017187 2361921 2361921 defendant Benet Robert weaver 602520 602520 Benet, Robert, of Castel Combe, weaver 5
5017188 2361921 2361921 defendant Seman John qweaver 602520 602520 Seman, John, of Castel Combe, qweaver 6
5017189 2361921 2361921 defendant Stevenes John weaver 602520 602520 Stevenes, John, of Castel Combe, weaver 7
5017190 2361921 2361921 defendant Webley John dyer 602520 602520 Webley, John, of Castel Combe, dyer 8
5017191 2361921 2361921 defendant Gederygge John   602520 602520 Gederygge, John, of Castel Combe, servant 9
5017192 2361921 2361921 defendant Burgeys William weaver 602520 602520 Burgeys, William, of Castel Combe, weaver 10
5017193 2361921 2361921 defendant Marchall John baker 602520 602520 Marchall, John, of Castel Combe, baker 11
5017194 2361921 2361921 defendant Glover John glover 602520 602520 Glover, John, of Castel Combe, glover 12
5017195 2361921 2361921 defendant Barbour John barber 602520 602520 Barbour, John, of Castel Combe, barber 13
5017197 2361922 2361922 defendant Jonys Edward dyer 602520 602520 Jonys, Edward, of Castel Combe, dyer 0
5017198 2361922 2361922 defendant Dytton Richard fuller 602520 602520 Dytton, Richard, of Castel Combe, fuller 1
5017199 2361922 2361922 defendant Boys Robert weaver 602520 602520 Boys, Robert, of Castel Combe, weaver 2
5017200 2361922 2361922 defendant Deny Thomas cordwainer 602520 602520 Deny, Thomas, of Castel Combe, cordwainer 3
5017201 2361922 2361922 defendant Haynys Thomas fuller 602520 602520 Haynys, Thomas, of Castel Combe, fuller 4
5017202 2361922 2361922 defendant Benet Robert weaver 602520 602520 Benet, Robert, of Castel Combe, weaver 5
5017203 2361922 2361922 defendant Seman John weaver 602520 602520 Seman, John, of Castel Combe, weaver 6
5017204 2361922 2361922 defendant Stevens John weaver 602520 602520 Stevens, John, of Castel Combe, weaver 7
5017205 2361922 2361922 defendant Webley John dyer 602520 602520 Webley, John, of Castel Combe, dyer 8
5017206 2361922 2361922 defendant Goderygge John   602520 602520 Goderygge, John, of Castel Combe, servant 9
5017207 2361922 2361922 defendant Burgeys William weaver 602520 602520 Burgeys, William, of Castel Combe, weaver 10
5017208 2361922 2361922 defendant Marchall John baker 602520 602520 Marchall, John, of Castel Combe, baker 11
5017209 2361922 2361922 defendant Glover John glover 602520 602520 Glover, John, of Castel Combe, glover 12
5017210 2361922 2361922 defendant Barbour Henry barber 602520 602520 Barbour, Henry, of Castel Combe, barber 13
5017212 2361923 2361923 defendant Lillyngston Thomas weaver 602520 602520 Lillyngston, Thomas, of Castel Combe, weaver 0
5017213 2361923 2361923 defendant Drewe Thomas weaver 602520 602520 Drewe, Thomas, of Castel Combe, weaver 1
5017214 2361923 2361923 defendant Caden John tucker 602520 602520 Caden, John, of Castel Combe, tucker 2
5017215 2361923 2361923 defendant Hille Henry tucker 602520 602520 Hille, Henry, of Castel Combe, tucker 3
5017216 2361923 2361923 defendant Avereys John tucker 602520 602520 Avereys, John, of Castel Combe, tucker 4
5017217 2361923 2361923 defendant Dagge Thomas baker 602520 602520 Dagge, Thomas, of Castel Combe, baker 5
5017218 2361923 2361923 defendant Frensheman William tucker 602520 602520 Frensheman, William, of Castel Combe, tucker 6
5017219 2361923 2361923 defendant Power William dyer 602520 602520 Power, William, of Castel Combe, dyer 7
5017220 2361923 2361923 defendant Deverose or Denerose Thomas laborer 602520 602520 Deverose or Denerose, Thomas, of Castel Combe, laborer 8
5017227 2361924 2361924 defendant Lyllyngston Thomas weaver 602520 602520 Lyllyngston, Thomas, of Castel Combe, weaver 0
5017228 2361924 2361924 defendant Drewe Thomas weaver 602520 602520 Drewe, Thomas, of Castel Combe, weaver 1
5017229 2361924 2361924 defendant Caden John tucker 602520 602520 Caden, John, of Castel Combe, tucker 2
5017230 2361924 2361924 defendant Avereys John tucker 602520 602520 Avereys, John, of Castel Combe, tucker 3
5017231 2361924 2361924 defendant Dagge Thomas tucker 602520 602520 Dagge, Thomas, of Castel Combe, tucker 4
5017232 2361924 2361924 defendant Frensheman William tucker 602520 602520 Frensheman, William, of Castel Combe, tucker 5
5017233 2361924 2361924 defendant Power William dyer 602520 602520 Power, William, of Castel Combe, dyer 6
5017234 2361924 2361924 defendant Denerose Thomas laborer 602520 602520 Denerose, Thomas, of Castel Combe, laborer 7
5019957 2362718 2362718 defendant Symond Thomas tucker 602520 602520 Symond, Thomas, of Castel Combe, tucker 0
5019958 2362718 2362718 defendant Herefordshire John tucker 602520 602520 Herefordshire, John, of Castel Combe, tucker 1

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