names

127 rows where place_id = 586233

✎ 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
3588225 1863971 1863971 defendant Burton Thomas yeoman 586233 586233 Burton, Thomas, of Attylburgh, yeoman 1
3609090 1870500 1870500 defendant Knyght Robert yeoman 586233 586233 Knyght, Robert, of Attylburgh, yeoman 0
3616266 1872729 1872729 defendant Brampton Robert gent 586233 586233 Brampton, Robert, of Attylburgh, gent 0
3616267 1872729 1872729 defendant Poly John husbandman 586233 586233 Poly, John, of Attylburgh, husbandman 1
3616268 1872729 1872729 defendant Spylman Robert husbandman 586233 586233 Spylman, Robert, of Attylburgh, husbandman 2
3616270 1872729 1872729 defendant Dowe John husbandman 586233 586233 Dowe, John, of Attylburgh, husbandman 4
3618884 1873517 1873517 defendant Bole John innholder 586233 586233 Bole, John, of Attylburgh, innholder 0
3622584 1874598 1874598 defendant Kelyng Agnes widow 586233 586233 Kelyng, Agnes, of Attylburgh, widow 1
3635180 1905799 1905799 defendant Browne John clerk 586233 586233 Browne, John, of Attylburgh, clerk 1
3636383 1906168 1906168 defendant Broune John clerk 586233 586233 Broune, John, of Attylburgh, clerk 0
3639137 1907059 1907059 defendant Canne Thomas husbandman 586233 586233 Canne, Thomas, of Attylburgh, husbandman 2
3680711 1920048 1920048 defendant Gurney Anthony esq 586233 586233 Gurney, Anthony, of Attylburgh, esq 0
3691808 1923599 1923599 defendant Drury William   586233 586233 Drury, William, of Attylburgh, gent, son of Drury, William 0
3710300 1929538 1929538 defendant Howes Bartholomew husbandman 586233 586233 Howes, Bartholomew, of Attylburgh, husbandman 0
3710828 1929704 1929704 defendant Wellys John husbandman 586233 586233 Wellys, John, of Attylburgh, husbandman 1
3710830 1929704 1929704 defendant Cowper Thomas   586233 586233 Cowper, Thomas, of Attylburgh, ploughwright 3
3710831 1929704 1929704 defendant Burton Thomas husbandman 586233 586233 Burton, Thomas, of Attylburgh, husbandman 4
3740810 1938983 1938983 defendant Alysaunder John (legal representative) 586233 586233 Alysaunder, John, of Attylburgh, husbandman, executor of 0
3742392 1939491 1939491 defendant Goose Walter husbandman 586233 586233 Goose, Walter, of Attylburgh, husbandman 4
3755829 1943774 1943774 defendant Eloy John husbandman 586233 586233 Eloy, John, of Attylburgh, husbandman 4
3761423 1945585 1945585 defendant Gyllyng John   586233 586233 Gyllyng, John, of Attylburgh, worsted weaver 4
3773827 1949525 1949525 defendant Elcy John husbandman 586233 586233 Elcy, John, of Attylburgh, husbandman 4
3777362 1950665 1950665 defendant Knyght Thomas shoemaker 586233 586233 Knyght, Thomas, of Attylburgh, shoemaker 0
3777363 1950665 1950665 defendant Knyght Robert laborer 586233 586233 Knyght, Robert, of Attylburgh, laborer 1
3783281 1952523 1952523 defendant Shergate John cordwainer 586233 586233 Shergate, John, of Attylburgh, cordwainer 0
3794704 1956219 1956219 defendant Knyght Robert laborer 586233 586233 Knyght, Robert, of Attylburgh, laborer 1
3805972 1959804 1959804 defendant Howes Bartholomew (legal representative) 586233 586233 Howes, Bartholomew, of Attylburgh, yeoman, executors of 0
3805973 1959804 1959804 defendant Howes John tanner 586233 586233 (Howes, John, of Attylburgh, tanner 1
3805974 1959804 1959804 defendant Howes Matilda widow 586233 586233 Howes, Matilda, of Attylburgh, widow 2
3812135 1961708 1961708 defendant Dowyr Henry chaplain 586233 586233 Dowyr, Henry, of Attylburgh, chaplain 0
3834870 1968847 1968847 defendant Polly Thomas yeoman 586233 586233 Polly, Thomas, of Attylburgh, yeoman 0
3834876 1968848 1968848 defendant Pelly Thomas yeoman 586233 586233 Pelly, Thomas, of Attylburgh, yeoman 0
3846519 1972469 1972469 defendant Goos John cooper 586233 586233 Goos, John, of Attylburgh, cooper 0
3848658 1973164 1973164 defendant Purkyn John   586233 586233 Purkyn, John, of Attylburgh, wheel wright 2
3863394 1977953 1977953 defendant Kent John husbandman 586233 586233 Kent, John, of Attylburgh, husbandman 1
3869424 1980015 1980015 defendant Fenne John baker 586233 586233 Fenne, John, of Attylburgh, baker 0
3886663 1985793 1985793 defendant Payn Robert yeoman 586233 586233 Payn, Robert, of Attylburgh, yeoman 0
3886665 1985793 1985793 defendant Payn Anthony singleman 586233 586233 Payn, Anthony, of Attylburgh, singleman 2
3893876 1988174 1988174 defendant Brett William husbandman 586233 586233 Brett, William, of Attylburgh, husbandman 1
3903442 1991377 1991377 defendant Godfrey John yeoman 586233 586233 Godfrey, John, of Attylburgh, yeoman 3
3907456 1992787 1992787 defendant Brampton William gent 586233 586233 Brampton, William, of Attylburgh, gent 0
3907459 1992788 1992788 defendant Brampton William gent 586233 586233 Brampton, William, of Attylburgh, gent 0
3914830 1995306 1995306 defendant Kent John husbandman 586233 586233 Kent, John, of Attylburgh, husbandman 4
3993843 2022548 2022548 plaintiff Churche William   586233 586233 Churche, William, of Attylburgh, wheelwright 0
3995410 2023101 2023101 plaintiff Cowper John (legal representative) 586233 586233 Cowper, John, of Attylburgh, yeoman, executors of 0
4749263 2280266 2280266 defendant Latilyver John husbandman 586233 586233 Latilyver, John, of Attylburgh, husbandman 0
4816710 2301323 2301323 defendant Bret Richard yeoman 586233 586233 Bret, Richard, of Attylburgh, yeoman 3
4817810 2301655 2301655 defendant Padgrys Richard yeoman 586233 586233 Padgrys, Richard, of Attylburgh, yeoman 0
4823342 2303387 2303387 defendant Reginald William gent 586233 586233 Reginald, William, of Attylburgh, gent 0
4845233 2310021 2310021 defendant Attylburgh Reginald gent 586233 586233 Attylburgh, Reginald, of Attylburgh, gent 0
4850323 2311556 2311556 defendant Patgrys John yeoman 586233 586233 Patgrys, John, of Attylburgh, yeoman 0
4856253 2313327 2313327 defendant Bret Richard yeoman 586233 586233 Bret, Richard, of Attylburgh, yeoman 0
4874382 2318929 2318929 defendant Redgrave Thomas husbandman 586233 586233 Redgrave, Thomas, of Attylburgh, husbandman 1
4874383 2318929 2318929 defendant Clerk John laborer 586233 586233 Clerk, John, of Attylburgh, laborer 2
4890963 2323911 2323911 defendant Radclyf John   586233 586233 Radclyf, John, of Attylburgh, knight 1
4900099 2326660 2326660 defendant Litilprowde John barker 586233 586233 Litilprowde, John, of Attylburgh, barker 7
4901235 2326994 2326994 defendant Draper Thomas husbandman 586233 586233 Draper, Thomas, of Attylburgh, husbandman 2
4908749 2329284 2329284 defendant Lyttylproud John tanner 586233 586233 Lyttylproud, John, of Attylburgh, tanner 3
4921056 2333097 2333097 defendant Gall Thomas husbandman 586233 586233 Gall, Thomas, of Attylburgh, husbandman 1
4930285 2335872 2335872 defendant Colet Nicholas yeoman 586233 586233 Colet, Nicholas, of Attylburgh, yeoman 0
4940757 2339136 2339136 defendant Spilman Robert husbandman 586233 586233 Spilman, Robert, of Attylburgh, husbandman 0
4959794 2344892 2344892 defendant Lytilproud John barker 586233 586233 Lytilproud, John, of Attylburgh, barker 3
4965271 2346538 2346538 defendant Baxster Bartholomew yeoman 586233 586233 Baxster, Bartholomew, of Attylburgh, yeoman 0
4965272 2346538 2346538 defendant Baxster Richard laborer 586233 586233 Baxster, Richard, of Attylburgh, laborer 1
4965652 2346650 2346650 defendant Eleskyn William yeoman 586233 586233 Eleskyn, William, of Attylburgh, yeoman 1
4982322 2351628 2351628 defendant Lytelproud John barker 586233 586233 Lytelproud, John, of Attylburgh, barker 0
4999900 2356848 2356848 defendant Grey Robert carver 586233 586233 Grey, Robert, of Attylburgh, carver 1
4999901 2356848 2356848 defendant Grey John merchant 586233 586233 Grey, John, of Attylburgh, merchant 2
5007216 2359003 2359003 defendant Page Roger husbandman 586233 586233 Page, Roger, of Attylburgh, husbandman 0
5048262 2371115 2371115 defendant Chapman William laborer 586233 586233 Chapman, William, of Attylburgh, laborer 2
5082055 2381128 2381128 plaintiff de Radclyf John (legal representative) 586233 586233 de Radclyf, John, of Attylburgh, knight, executors of 0
5123596 2393358 2393358 defendant Maygood Robert weaver 586233 586233 Maygood, Robert, of Attylburgh, weaver 2
5123597 2393358 2393358 defendant Spylman John laborer 586233 586233 Spylman, John, of Attylburgh, laborer 3
5158670 2403658 2403658 plaintiff Radclyff John esq 586233 586233 Radclyff, John, of Attylburgh, esq 0
5221872 2422095 2422095 defendant Popy Robert clerk 586233 586233 Popy, Robert, of Attylburgh, clerk 0
5221873 2422095 2422095 defendant Anabyll William ostler 586233 586233 Anabyll, William, of Attylburgh, ostler 1
5229757 2424324 2424324 defendant Leche Richard pedder 586233 586233 Leche, Richard, of Attylburgh, pedder 0
5240860 2427532 2427532 defendant Pepy Robert clerk 586233 586233 Pepy, Robert, of Attylburgh, clerk 0
5256554 2432169 2432169 plaintiff Draper Thomas   586233 586233 Draper, Thomas, of Attylburgh 0
5256565 2432174 2432174 plaintiff Drapere Thomas   586233 586233 Drapere, Thomas, of Attylburgh 0
5263499 2434331 2434331 defendant Haye Margaret widow 586233 586233 Haye, Margaret, of Attylburgh, widow 3
5265042 2434827 2434827 defendant Bolytout Robert husbandman 586233 586233 Bolytout, Robert, of Attylburgh, husbandman 0
5277846 2438605 2438605 defendant Kelyng John carpenter 586233 586233 Kelyng, John, of Attylburgh, carpenter 0
5278216 2438725 2438725 defendant Forthe Richard yeoman 586233 586233 Forthe, Richard, of Attylburgh, yeoman 2
5279347 2439050 2439050 plaintiff Brampton John gent 586233 586233 Brampton, John, of Attylburgh, gent 0
5281451 2439645 2439645 defendant Brampton Thomas, senior esq 586233 586233 Brampton, Thomas, senior, of Attylburgh, esq 0
5283575 2440248 2440248 defendant Radclyf John, senior gent 586233 586233 Radclyf, John, senior, of Attylburgh, gent 2
5291857 2442624 2442624 plaintiff Radclyff John esq 586233 586233 Radclyff, John, of Attylburgh, esq 0
5292045 2442678 2442678 defendant Hay Margaret widow 586233 586233 Hay, Margaret, of Attylburgh, widow 1
5295339 2443630 2443630 defendant Forthe Richard chapman 586233 586233 Forthe, Richard, of Attylburgh, chapman 4
5301028 2445263 2445263 defendant Swetman John husbandman 586233 586233 Swetman, John, of Attylburgh, husbandman 0
5302381 2445680 2445680 defendant Spylman Robert husbandman 586233 586233 Spylman, Robert, of Attylburgh, husbandman 1
5307170 2447145 2447145 defendant Podde William   586233 586233 Podde, William, of Attylburgh, mason 0
5316105 2449890 2449890 defendant Crawe John clerk 586233 586233 (Crawe, John, of Attylburgh, clerk 1
5320444 2451196 2451196 defendant Doo Elias laborer 586233 586233 Doo, Elias, of Attylburgh, laborer 0
5333051 2454954 2454954 defendant Robyns or Roberdys William husbandman 586233 586233 Robyns or Roberdys, William, of Attylburgh, husbandman 1
5340753 2457307 2457307 defendant Reynold Thomas singleman 586233 586233 Reynold, Thomas, of Attylburgh, mercer, singleman 1
5345059 2458616 2458616 defendant Bolytont or Bolytout Robert husbandman 586233 586233 Bolytont or Bolytout, Robert, of Attylburgh, husbandman 0
5350233 2460194 2460194 defendant Canne Bartholomew husbandman 586233 586233 Canne, Bartholomew, of Attylburgh, husbandman 1
5350238 2460195 2460195 defendant Canne Bartholomew husbandman 586233 586233 Canne, Bartholomew, of Attylburgh, husbandman 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);