names

1,283 rows where place_id = 586471

✎ 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
3588807 1864146 1864146 defendant Wattys Robert husbandman 586471 586471 Wattys, Robert, of Aylesham, husbandman 0
3588950 1864193 1864193 defendant Edmundis William husbandman 586471 586471 Edmundis, William, of Aylesham, husbandman 11
3588951 1864193 1864193 defendant Pynnyng Simon husbandman 586471 586471 Pynnyng, Simon, of Aylesham, husbandman 12
3589288 1864291 1864291 defendant Bettys Robert butcher 586471 586471 Bettys, Robert, of Aylesham, butcher 0
3589621 1864396 1864396 defendant Bettys Robert butcher 586471 586471 Bettys, Robert, of Aylesham, butcher 0
3589622 1864396 1864396 defendant Bettys John husbandman 586471 586471 Bettys, John, of Aylesham, husbandman 1
3589892 1864480 1864480 defendant Colet John husbandman 586471 586471 Colet, John, of Aylesham, husbandman 0
3589894 1864480 1864480 defendant Rafman Alan husbandman 586471 586471 Rafman, Alan, of Aylesham, husbandman 2
3596982 1866682 1866682 defendant Egremond John yeoman 586471 586471 Egremond, John, of Aylesham, yeoman 3
3597159 1866735 1866735 defendant Middelton Reginald husbandman 586471 586471 Middelton, Reginald, of Aylesham, husbandman 1
3598938 1867296 1867296 plaintiff Swewyn Nicholas (legal representative) 586471 586471 Swewyn, Nicholas, of Aylesham, executors of 0
3598940 1867296 1867296 defendant Bettys Robert husbandman 586471 586471 Bettys, Robert, of Aylesham, husbandman 0
3599141 1867367 1867367 defendant Wattys Alan husbandman 586471 586471 Wattys, Alan, of Aylesham, husbandman 1
3600376 1867763 1867763 defendant Bettys Robert butcher 586471 586471 Bettys, Robert, of Aylesham, butcher 1
3601354 1868089 1868089 defendant Tower Thomas yeoman 586471 586471 Tower, Thomas, of Aylesham, yeoman 0
3601369 1868091 1868091 defendant Colet John yeoman 586471 586471 Colet, John, of Aylesham, yeoman 1
3601989 1868281 1868281 defendant Bettys Richard fuller 586471 586471 Bettys, Richard, of Aylesham, fuller 0
3603211 1868672 1868672 defendant Portlond John husbandman 586471 586471 Portlond, John, of Aylesham, husbandman 0
3603425 1868739 1868739 defendant Porlond Margaret widow 586471 586471 Porlond, Margaret, of Aylesham, widow 14
3603661 1868813 1868813 defendant Bettys Edmund butcher 586471 586471 Bettys, Edmund, of Aylesham, butcher 4
3605157 1869277 1869277 defendant Bettys Robert butcher 586471 586471 Bettys, Robert, of Aylesham, butcher 0
3605171 1869282 1869282 plaintiff Howard Richard   586471 586471 Howard, Richard, of Aylesham 0
3605173 1869282 1869282 defendant Blunden John yeoman 586471 586471 Blunden, John, of Aylesham, yeoman 1
3605175 1869283 1869283 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605176 1869283 1869283 defendant Boon Thomas yeoman 586471 586471 Boon, Thomas, of Aylesham, yeoman 0
3605177 1869284 1869284 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605178 1869284 1869284 defendant Colet John husbandman 586471 586471 Colet, John, of Aylesham, husbandman 0
3605179 1869285 1869285 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605180 1869285 1869285 defendant Colet John yeoman 586471 586471 Colet, John, of Aylesham, yeoman 0
3605181 1869286 1869286 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605182 1869286 1869286 defendant Colet John yeoman 586471 586471 Colet, John, of Aylesham, yeoman 0
3605183 1869286 1869286 defendant Emundes John, junior yeoman 586471 586471 Emundes, John, junior, of Aylesham, yeoman 1
3605184 1869286 1869286 defendant Felys Robert (legal representative) 586471 586471 Felys, Robert, of Aylesham, yeoman, executor of 2
3605185 1869286 1869286 defendant Boon Thomas yeoman 586471 586471 Boon, Thomas, of Aylesham, yeoman 3
3605186 1869287 1869287 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605187 1869287 1869287 defendant Emundes John, junior yeoman 586471 586471 Emundes, John, junior, of Aylesham, yeoman 0
3605188 1869288 1869288 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605190 1869288 1869288 defendant Blunden John yeoman 586471 586471 Blunden, John, of Aylesham, yeoman 1
3605192 1869289 1869289 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605194 1869289 1869289 defendant Boon Thomas yeoman 586471 586471 Boon, Thomas, of Aylesham, yeoman 1
3605195 1869290 1869290 plaintiff Howard Richard baker 586471 586471 Howard, Richard, of Aylesham, baker 0
3605198 1869291 1869291 defendant Colet John husbandman 586471 586471 Colet, John, of Aylesham, husbandman 0
3606651 1869754 1869754 defendant Collet John yeoman 586471 586471 Collet, John, of Aylesham, yeoman 1
3608306 1870255 1870255 defendant Portlond Margaret widow 586471 586471 Portlond, Margaret, of Aylesham, widow 0
3613836 1871982 1871982 defendant Croppe Richard raffman 586471 586471 Croppe, Richard, of Aylesham, raffman 1
3616188 1872702 1872702 defendant Peke Ralph tailor 586471 586471 Peke, Ralph, of Aylesham, tailor 0
3616673 1872845 1872845 defendant Bettys Edmund butcher 586471 586471 Bettys, Edmund, of Aylesham, butcher 0
3616759 1872871 1872871 defendant Portlond William mercer 586471 586471 Portlond, William, of Aylesham, mercer 0
3618007 1873252 1873252 defendant Collett John yeoman 586471 586471 Collett, John, of Aylesham, yeoman 0
3618008 1873252 1873252 defendant Bettys William yeoman 586471 586471 Bettys, William, of Aylesham, yeoman 1
3618940 1873533 1873533 defendant Bettys William scrivener 586471 586471 Bettys, William, of Aylesham, scrivener 0
3618953 1873537 1873537 defendant Bettys William scrivener 586471 586471 Bettys, William, of Aylesham, scrivener 0
3620218 1873901 1873901 defendant Bettys William scrivener 586471 586471 Bettys, William, of Aylesham, scrivener 0
3620219 1873901 1873901 defendant Bettes John shoemaker 586471 586471 Bettes, John, of Aylesham, shoemaker 1
3621224 1874180 1874180 plaintiff Mortoft William mercer 586471 586471 Mortoft, William, of Aylesham, mercer 0
3626729 1903205 1903205 defendant Tawener John tailor 586471 586471 Tawener, John, of Aylesham, tailor 3
3628561 1903804 1903804 defendant Colet John yeoman 586471 586471 Colet, John, of Aylesham, yeoman 2
3628953 1903931 1903931 defendant Greneleff Robert chaplain 586471 586471 Greneleff, Robert, of Aylesham, chaplain 0
3628954 1903931 1903931 defendant Athyll Thomas husbandman 586471 586471 Athyll, Thomas, of Aylesham, husbandman 1
3628956 1903931 1903931 defendant Skeveyn William husbandman 586471 586471 Skeveyn, William, of Aylesham, husbandman 3
3631872 1904777 1904777 defendant Rychardson Richard husbandman 586471 586471 Rychardson, Richard, of Aylesham, husbandman 0
3633423 1905268 1905268 defendant Collet John yeoman 586471 586471 Collet, John, of Aylesham, yeoman 0
3634304 1905526 1905526 defendant Shirff John chapman 586471 586471 Shirff, John, of Aylesham, chapman 1
3635466 1905887 1905887 defendant Marsham Thomas   586471 586471 Marsham, Thomas, of Aylesham, worsted weaver 0
3635468 1905888 1905888 defendant Marsham Thomas   586471 586471 Marsham, Thomas, of Aylesham, worsted weaver 0
3636733 1906282 1906282 defendant Johnson John yeoman 586471 586471 Johnson, John, of Aylesham, yeoman 0
3636825 1906309 1906309 defendant Geyton William laborer 586471 586471 Geyton, William, of Aylesham, laborer 5
3638132 1906744 1906744 defendant Colet John yeoman 586471 586471 Colet, John, of Aylesham, yeoman 1
3638340 1906809 1906809 defendant Aleyn Robert   586471 586471 Aleyn, Robert, of Aylesham, worsted weaver 0
3639243 1907084 1907084 defendant Palmer John husbandman 586471 586471 Palmer, John, of Aylesham, husbandman 2
3640132 1907360 1907360 plaintiff Wythe William   586471 586471 Wythe, William, of Aylesham 0
3641483 1907794 1907794 defendant Orwell Thomas raffman 586471 586471 Orwell, Thomas, of Aylesham, raffman 0
3644971 1908836 1908836 defendant Baron Katherine widow 586471 586471 Baron, Katherine, of Aylesham, widow 0
3646134 1909192 1909192 defendant Bonde John husbandman 586471 586471 Bonde, John, of Aylesham, husbandman 0
3646135 1909192 1909192 defendant Rycheman William   586471 586471 Rycheman, William, of Aylesham, worsted weaver 1
3646137 1909193 1909193 defendant Cateson William husbandman 586471 586471 Cateson, William, of Aylesham, husbandman 0
3647700 1909670 1909670 defendant Newman Robert (legal representative) 586471 586471 Newman, Robert, of Aylesham, yeoman, executors of 0
3647701 1909670 1909670 defendant Orwell Thomas clerk 586471 586471 (Orwell, Thomas, of Aylesham, clerk 1
3647702 1909670 1909670 defendant Athyll Thomas yeoman 586471 586471 Athyll, Thomas, of Aylesham, yeoman 2
3647706 1909671 1909671 defendant Newman Robert (legal representative) 586471 586471 Newman, Robert, of Aylesham, yeoman, executors of 0
3647707 1909671 1909671 defendant Orwell Thomas clerk 586471 586471 (Orwell, Thomas, of Aylesham, clerk 1
3647708 1909671 1909671 defendant Athill Thomas yeoman 586471 586471 Athill, Thomas, of Aylesham, yeoman 2
3648595 1909951 1909951 defendant Bokkyng Thomas butcher 586471 586471 Bokkyng, Thomas, of Aylesham, butcher 0
3648602 1909952 1909952 defendant Humfrey John   586471 586471 Humfrey, John, of Aylesham, worsted weaver 1
3648603 1909952 1909952 defendant Wattys John   586471 586471 Wattys, John, of Aylesham, worsted weaver 2
3648609 1909953 1909953 defendant Hill Thomas, junior tanner 586471 586471 Hill, Thomas, junior, of Aylesham, tanner 0
3649206 1910140 1910140 defendant Smyth Robert husbandman 586471 586471 Smyth, Robert, of Aylesham, husbandman 3
3650014 1910372 1910372 defendant Baxter Thomas yeoman 586471 586471 Baxter, Thomas, of Aylesham, yeoman 0
3650250 1910450 1910450 defendant Baxster Thomas yeoman 586471 586471 Baxster, Thomas, of Aylesham, yeoman 0
3650256 1910452 1910452 defendant Eryng or Gryng John husbandman 586471 586471 Eryng or Gryng, John, of Aylesham, husbandman 2
3650278 1910463 1910463 defendant Randolf John husbandman 586471 586471 Randolf, John, of Aylesham, husbandman 0
3650280 1910464 1910464 defendant Wodde John husbandman 586471 586471 Wodde, John, of Aylesham, husbandman 0
3653727 1911428 1911428 plaintiff Wymer Margaret widow 586471 586471 Wymer, Margaret, of Aylesham, widow 0
3653729 1911429 1911429 plaintiff Wymer Margaret widow 586471 586471 Wymer, Margaret, of Aylesham, widow 0
3653732 1911429 1911429 defendant Dokkyng Thomas butcher 586471 586471 Dokkyng, Thomas, of Aylesham, butcher 2
3657986 1912750 1912750 defendant Tylney John   586471 586471 Tylney, John, of Aylesham, worsted weaver 0
3657989 1912750 1912750 defendant Gressenhale John   586471 586471 Gressenhale, John, of Aylesham, shoe maker 3
3657990 1912750 1912750 defendant Bokkyng Thomas butcher 586471 586471 Bokkyng, Thomas, of Aylesham, butcher 4
3660155 1913436 1913436 defendant Tylney John   586471 586471 Tylney, John, of Aylesham, worsted weaver 0
3660964 1913701 1913701 defendant Toly Nicholas mercer 586471 586471 Toly, Nicholas, of Aylesham, mercer 0

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