names

625 rows where place_id = 587176

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590663 1864723 1864723 defendant Deryng William butcher or shepherd 587176 587176 Deryng, William, of Aylesbury, or of Quarenden, butcher or shepherd 1
3590664 1864723 1864723 defendant Andrewe William husbandman 587176 587176 Andrewe, William, of Aylesbury, husbandman 2
3593000 1865436 1865436 defendant Ravenyng John butcher 587176 587176 Ravenyng, John, of Aylesbury, butcher 0
3594224 1865834 1865834 defendant Glene or Gleve Thomas barber 587176 587176 Glene or Gleve, Thomas, of Aylesbury, barber 0
3598715 1867225 1867225 plaintiff Stone John   587176 587176 Stone, John, of Aylesbury 0
3598718 1867226 1867226 plaintiff Stone John   587176 587176 Stone, John, of Aylesbury 0
3620368 1873954 1873954 defendant Warde Richard draper 587176 587176 Warde, Richard, of Aylesbury, draper 0
3620388 1873961 1873961 defendant Stokes Robert butcher 587176 587176 Stokes, Robert, of Aylesbury, butcher 0
3626303 1903083 1903083 defendant Venour Richard yeoman 587176 587176 Venour, Richard, of Aylesbury, yeoman 0
3626306 1903084 1903084 defendant Venour Richard yeoman 587176 587176 Venour, Richard, of Aylesbury, yeoman 0
3627508 1903461 1903461 defendant Lechyngham Nicholas shoemaker 587176 587176 Lechyngham, Nicholas, of Aylesbury, shoemaker 1
3627509 1903461 1903461 defendant Barbour John (legal representative) 587176 587176 Barbour, John, of Aylesbury, yeoman, executor of 2
3630215 1904299 1904299 defendant Bosy John fisher 587176 587176 Bosy, John, of Aylesbury, fisher 0
3632193 1904885 1904885 defendant Fossebroke John carpenter 587176 587176 Fossebroke, John, of Aylesbury, carpenter 0
3632226 1904896 1904896 defendant Fossebroke John carpenter 587176 587176 Fossebroke, John, of Aylesbury, carpenter 1
3633587 1905317 1905317 defendant Cokkys Roger butcher 587176 587176 Cokkys, Roger, of Aylesbury, butcher 2
3633588 1905317 1905317 defendant Deverell Thomas butcher 587176 587176 Deverell, Thomas, of Aylesbury, butcher 3
3633590 1905318 1905318 defendant Bovyndon Richard shoemaker 587176 587176 Bovyndon, Richard, of Aylesbury, shoemaker 0
3633740 1905364 1905364 defendant Cokkys Roger butcher 587176 587176 Cokkys, Roger, of Aylesbury, butcher 0
3636685 1906265 1906265 defendant Mortymer Thomas butcher 587176 587176 Mortymer, Thomas, of Aylesbury, butcher 0
3638878 1906983 1906983 defendant Taverner Richard yeoman 587176 587176 Taverner, Richard, of Aylesbury, yeoman 0
3638879 1906983 1906983 defendant Devonshyre John yeoman 587176 587176 Devonshyre, John, of Aylesbury, yeoman 1
3638881 1906983 1906983 defendant Bovyngdon Richard yeoman 587176 587176 Bovyngdon, Richard, of Aylesbury, yeoman 3
3644147 1908602 1908602 defendant Bosy alias Bocher John yeoman 587176 587176 Bosy alias Bocher, John, of Aylesbury, yeoman 0
3666152 1915358 1915358 defendant Cokkes Roger butcher 587176 587176 Cokkes, Roger, of Aylesbury, butcher 0
3668179 1915993 1915993 defendant Mortimer Thomas butcher 587176 587176 Mortimer, Thomas, of Aylesbury, butcher 0
3668181 1915994 1915994 defendant Mortymer Thomas butcher 587176 587176 Mortymer, Thomas, of Aylesbury, butcher 0
3672228 1917313 1917313 plaintiff Hall John gent 587176 587176 Hall, John, of Aylesbury, gent 2
3675035 1918222 1918222 defendant Mortymer Thomas yeoman 587176 587176 Mortymer, Thomas, of Aylesbury, yeoman 0
3675433 1918354 1918354 defendant Hoggys Thomas yeoman 587176 587176 Hoggys, Thomas, of Aylesbury, yeoman 0
3688180 1922452 1922452 defendant Hopton Thomas tailor 587176 587176 Hopton, Thomas, of Aylesbury, tailor 0
3688250 1922475 1922475 plaintiff Halle John   587176 587176 Halle, John, of Aylesbury 2
3688259 1922476 1922476 plaintiff Halle John   587176 587176 Halle, John, of Aylesbury 2
3688267 1922477 1922477 plaintiff Halle John   587176 587176 Halle, John, of Aylesbury 2
3692903 1923978 1923978 defendant Mortymer Thomas butcher 587176 587176 Mortymer, Thomas, of Aylesbury, butcher 0
3693260 1924102 1924102 defendant Bovyngton Richard shoemaker 587176 587176 Bovyngton, Richard, of Aylesbury, shoemaker 1
3696370 1925087 1925087 defendant Mortymer Thomas butcher 587176 587176 Mortymer, Thomas, of Aylesbury, butcher 0
3696375 1925089 1925089 defendant Mortymer Thomas butcher 587176 587176 Mortymer, Thomas, of Aylesbury, butcher 0
3703111 1927248 1927248 plaintiff Halle John   587176 587176 Halle, John, of Aylesbury 2
3703118 1927249 1927249 plaintiff Halle John   587176 587176 Halle, John, of Aylesbury 2
3713497 1930533 1930533 defendant Blythe Thomas baker 587176 587176 Blythe, Thomas, of Aylesbury, baker 1
3721320 1932974 1932974 defendant Walton Robert   587176 587176 Walton, Robert, of Aylesbury, "taborer" 0
3729596 1935504 1935504 defendant Frere Richard chapman 587176 587176 Frere, Richard, of Aylesbury, chapman 0
3729606 1935508 1935508 defendant Frere Richard   587176 587176 Frere, Richard, of Aylesbury 0
3729692 1935538 1935538 defendant Corbet Edward   587176 587176 Corbet, Edward, of Aylesbury, wool winder 0
3735539 1937352 1937352 defendant Hayll Richard husbandman 587176 587176 Hayll, Richard, of Aylesbury, husbandman 0
3735540 1937352 1937352 defendant Balard John laborer 587176 587176 Balard, John, of Aylesbury, laborer 1
3735831 1937444 1937444 defendant Aprice John mercer 587176 587176 Aprice, John, of Aylesbury, mercer 0
3736986 1937814 1937814 defendant Coke Edmund laborer 587176 587176 Coke, Edmund, of Aylesbury, laborer 0
3736987 1937814 1937814 defendant Meydwell John laborer 587176 587176 Meydwell, John, of Aylesbury, laborer 1
3737260 1937887 1937887 defendant Walton Robert   587176 587176 Walton, Robert, of Aylesbury, "taberer" 0
3740546 1938901 1938901 defendant Lather Thomas innholder 587176 587176 Lather, Thomas, of Aylesbury, innholder 0
3740548 1938902 1938902 defendant Lather Thomas innholder 587176 587176 Lather, Thomas, of Aylesbury, innholder 0
3743637 1939886 1939886 defendant Apryce John mercer 587176 587176 Apryce, John, of Aylesbury, mercer 0
3743643 1939887 1939887 defendant Aprise John mercer 587176 587176 Aprise, John, of Aylesbury, mercer 2
3749101 1941648 1941648 defendant Hayle Richard husbandman 587176 587176 Hayle, Richard, of Aylesbury, husbandman 0
3753668 1943089 1943089 defendant Fayreclyff Lawrence yeoman 587176 587176 Fayreclyff, Lawrence, of Aylesbury, yeoman 0
3753669 1943089 1943089 defendant Fayreclyff Richard yeoman 587176 587176 Fayreclyff, Richard, of Aylesbury, yeoman 1
3755602 1943709 1943709 defendant ap Rice John mercer 587176 587176 ap Rice, John, of Aylesbury, mercer 2
3756210 1943900 1943900 defendant Hychecok Barnard husbandman 587176 587176 Hychecok, Barnard, of Aylesbury, husbandman 1
3756211 1943900 1943900 defendant Lather Thomas innholder 587176 587176 Lather, Thomas, of Aylesbury, innholder 2
3757219 1944240 1944240 defendant Corbet Edward   587176 587176 Corbet, Edward, of Aylesbury, wool winder 0
3758291 1944588 1944588 defendant Chapman John yeoman 587176 587176 Chapman, John, of Aylesbury, yeoman 0
3764024 1946392 1946392 defendant Plummer John shoemaker 587176 587176 Plummer, John, of Aylesbury, shoemaker 0
3769739 1948189 1948189 defendant Chapman John yeoman 587176 587176 Chapman, John, of Aylesbury, yeoman 0
3770780 1948548 1948548 defendant Fayreclyff Richard gent 587176 587176 Fayreclyff, Richard, of Aylesbury, gent 1
3776344 1950350 1950350 defendant Chapman John yeoman 587176 587176 Chapman, John, of Aylesbury, yeoman 0
3790518 1954857 1954857 defendant Norres Richard yeoman 587176 587176 Norres, Richard, of Aylesbury, yeoman 0
3793400 1955799 1955799 defendant Dane John butcher 587176 587176 Dane, John, of Aylesbury, butcher 0
3794331 1956103 1956103 defendant Godyn or Godwyn John butcher 587176 587176 Godyn or Godwyn, John, of Aylesbury, butcher 0
3804053 1959190 1959190 defendant Goodwyn John butcher 587176 587176 Goodwyn, John, of Aylesbury, butcher 0
3811379 1961453 1961453 defendant Bonyngton or Bovyngton Richard shoemaker 587176 587176 Bonyngton or Bovyngton, Richard, of Aylesbury, shoemaker 1
3823214 1965174 1965174 defendant Pole John dyer 587176 587176 Pole, John, of Aylesbury, dyer 0
3828905 1966921 1966921 plaintiff Colyngborne Richard gent 587176 587176 Colyngborne, Richard, of Aylesbury, gent 0
3830457 1967405 1967405 defendant More John husbandman 587176 587176 More, John, of Aylesbury, husbandman 0
3830465 1967406 1967406 defendant Riley James tailor 587176 587176 Riley, James, of Aylesbury, tailor 1
3833536 1968421 1968421 defendant Rydyng Walter glover 587176 587176 Rydyng, Walter, of Aylesbury, glover 0
3840993 1970752 1970752 defendant Pole John dyer 587176 587176 Pole, John, of Aylesbury, dyer 2
3842088 1971079 1971079 plaintiff Bradbery Edmund yeoman 587176 587176 Bradbery, Edmund, of Aylesbury, yeoman 0
3842090 1971079 1971079 defendant Benny John tailor 587176 587176 Benny, John, of Aylesbury, tailor 1
3842093 1971080 1971080 plaintiff Bradbery Edmund yeoman 587176 587176 Bradbery, Edmund, of Aylesbury, yeoman 0
3842095 1971080 1971080 defendant Benny John tailor 587176 587176 Benny, John, of Aylesbury, tailor 1
3842097 1971081 1971081 plaintiff Bradbery Edmund yeoman 587176 587176 Bradbery, Edmund, of Aylesbury, yeoman 0
3842099 1971081 1971081 defendant Benny John tailor 587176 587176 Benny, John, of Aylesbury, tailor 1
3847109 1972648 1972648 plaintiff Halle John (legal representative) 587176 587176 Halle, John, of Aylesbury, gent, executrix of 0
3847112 1972649 1972649 plaintiff Halle John (legal representative) 587176 587176 Halle, John, of Aylesbury, gent, executrix of 0
3865323 1978611 1978611 defendant Bobyngdon Richard shoemaker 587176 587176 Bobyngdon, Richard, of Aylesbury, shoemaker 0
3872707 1981088 1981088 plaintiff Spede Robert   587176 587176 Spede, Robert, of Aylesbury 2
3872714 1981089 1981089 plaintiff Spede Robert   587176 587176 Spede, Robert, of Aylesbury 2
3874120 1981568 1981568 defendant Bovyndon Richard shoemaker 587176 587176 Bovyndon, Richard, of Aylesbury, shoemaker 0
3874121 1981568 1981568 defendant Chapman Isabel widow 587176 587176 Chapman, Isabel, of Aylesbury, widow 1
3880076 1983596 1983596 plaintiff Passelowe Miles gent 587176 587176 Passelowe, Miles, of Aylesbury, gent 0
3881525 1984082 1984082 defendant Rydyng Margaret spinster 587176 587176 Rydyng, Margaret, of Aylesbury, spinster 0
3885032 1985253 1985253 defendant Plummer John shoemaker 587176 587176 Plummer, John, of Aylesbury, shoemaker 0
3899164 1989925 1989925 defendant Hayll Robert husbandman 587176 587176 Hayll, Robert, of Aylesbury, husbandman 0
3901757 1990811 1990811 defendant Barnat John laborer 587176 587176 Barnat, John, of Aylesbury, laborer 0
3901761 1990811 1990811 defendant Horwode Henry husbandman 587176 587176 Horwode, Henry, of Aylesbury, husbandman 4
3901937 1990875 1990875 defendant Blyth Thomas baker 587176 587176 Blyth, Thomas, of Aylesbury, baker 1
3901938 1990875 1990875 defendant Pole John dyer 587176 587176 Pole, John, of Aylesbury, dyer 2
3901939 1990875 1990875 defendant Cokkys William butcher 587176 587176 Cokkys, William, of Aylesbury, butcher 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);