names

2,227 rows where place_id = 585907

✎ 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
3587467 1863727 1863727 defendant Johnson alias Wysbyche John waterman 585907 585907 Johnson alias Wysbyche, John, of Bishops Lenn, waterman 4
3587469 1863728 1863728 defendant Whyte Edmund roper 585907 585907 Whyte, Edmund, of Bishops Lenn, roper 0
3587777 1863825 1863825 defendant Fysshe John gent 585907 585907 Fysshe, John, of Bishops Lenn, gent 0
3587883 1863860 1863860 defendant Beelys John merchant 585907 585907 Beelys, John, of Bishops Lenn, merchant 3
3588211 1863968 1863968 plaintiff Bastard Isabel (legal representative) 585907 585907 Bastard, Isabel, of Bishops Lenn, widow, , executors of 0
3588219 1863969 1863969 defendant Hall William baker 585907 585907 Hall, William, of Bishops Lenn, baker 2
3588220 1863969 1863969 defendant Gest alias Placke Richard glover 585907 585907 Gest alias Placke, Richard, of Bishops Lenn, glover 3
3588221 1863970 1863970 plaintiff Bastard Richard   585907 585907 Bastard, Richard, of Bishops Lenn 0
3588591 1864076 1864076 defendant Thurwald Richard husbandman 585907 585907 Thurwald, Richard, of Bishops Lenn, husbandman 2
3588694 1864108 1864108 plaintiff Bolman John (legal representative) 585907 585907 Bolman, John, of Bishops Lenn, chaplain, executor of 0
3588695 1864108 1864108 plaintiff Taylour John   585907 585907 Taylour, John, of Bishops Lenn 1
3588856 1864165 1864165 defendant Fysshmer John brewer 585907 585907 Fysshmer, John, of Bishops Lenn, brewer 0
3588860 1864166 1864166 defendant Fysshmer John brewer 585907 585907 Fysshmer, John, of Bishops Lenn, brewer 2
3590171 1864564 1864564 defendant Carter Thomas merchant 585907 585907 Carter, Thomas, of Bishops Lenn, merchant 0
3590172 1864564 1864564 defendant Braybroke Robert merchant 585907 585907 Braybroke, Robert, of Bishops Lenn, merchant 1
3590785 1864756 1864756 defendant Walker Robert chaplain 585907 585907 Walker, Robert, of Bishops Lenn, chaplain 3
3591101 1864841 1864841 plaintiff Denne John tanner 585907 585907 Denne, John, of Bishops Lenn, tanner 0
3591857 1865074 1865074 defendant Gyggys John yeoman 585907 585907 Gyggys, John, of Bishops Lenn, innholder, or of Burnham Westgate, yeoman 1
3591863 1865075 1865075 defendant Mannyng William butcher 585907 585907 Mannyng, William, of Bishops Lenn, butcher 1
3592170 1865171 1865171 plaintiff Freynd John   585907 585907 Freynd, John, of Bishops Lenn 0
3593939 1865742 1865742 defendant Hoste Stephen merchant 585907 585907 Hoste, Stephen, of Bishops Lenn, merchant 1
3593945 1865743 1865743 defendant Hoste Stephen merchant 585907 585907 Hoste, Stephen, of Bishops Lenn, merchant 1
3594205 1865829 1865829 defendant Beelys John merchant 585907 585907 Beelys, John, of Bishops Lenn, merchant 0
3594994 1866064 1866064 plaintiff Lovet Thomas fishmonger 585907 585907 Lovet, Thomas, of Bishops Lenn, fishmonger 0
3595784 1866315 1866315 defendant Blaunch John dyer 585907 585907 Blaunch, John, of Bishops Lenn, dyer 0
3597003 1866689 1866689 defendant Clare John fishmonger 585907 585907 Clare, John, of Bishops Lenn, fishmonger 2
3597068 1866705 1866705 defendant Antony William butcher 585907 585907 Antony, William, of Bishops Lenn, butcher 0
3597069 1866705 1866705 defendant Waterman John vintner 585907 585907 Waterman, John, of Bishops Lenn, vintner 1
3597107 1866719 1866719 defendant Salter Ralph yeoman 585907 585907 Salter, Ralph, of Bishops Lenn, yeoman 0
3599523 1867490 1867490 plaintiff Tygo John draper 585907 585907 Tygo, John, of Bishops Lenn, draper 0
3599526 1867490 1867490 defendant Cuttys John yeoman 585907 585907 Cuttys, John, of Bishops Lenn, yeoman 2
3599724 1867558 1867558 defendant Beeston John merchant 585907 585907 Beeston, John, of Bishops Lenn, merchant 0
3599726 1867559 1867559 defendant Beeston John merchant 585907 585907 Beeston, John, of Bishops Lenn, merchant 0
3600504 1867805 1867805 defendant Sygon Thomas barker 585907 585907 Sygon, Thomas, of Bishops Lenn, barker 0
3600665 1867854 1867854 defendant Saten John yeoman 585907 585907 Saten, John, of Bishops Lenn, yeoman 0
3601035 1867990 1867990 defendant Rede John (legal representative) 585907 585907 Rede, John, of Bishops Lenn, administrator of 0
3601190 1868037 1868037 plaintiff Alysaunder John butcher 585907 585907 Alysaunder, John, of Bishops Lenn, butcher 0
3601193 1868037 1868037 defendant Skotte John dyer 585907 585907 Skotte, John, of Bishops Lenn, dyer 2
3602495 1868440 1868440 defendant Soham John (legal representative) 585907 585907 Soham, John, of Bishops Lenn, executor of Codyngton, John, of Bishops Lenn, yeoman, executors of 0
3602496 1868440 1868440 defendant Soham Edmund mercer 585907 585907 (Soham, Edmund, of Bishops Lenn, mercer 1
3602497 1868440 1868440 defendant Tayllour John yeoman 585907 585907 Tayllour, John, of Bishops Lenn, yeoman 2
3602684 1868502 1868502 defendant Blaunche John merchant 585907 585907 Blaunche, John, of Bishops Lenn, merchant 1
3602957 1868589 1868589 plaintiff Coldeweddir Thomas baker 585907 585907 Coldeweddir, Thomas, of Bishops Lenn, baker 0
3603103 1868636 1868636 defendant Abell John raffman 585907 585907 Abell, John, of Bishops Lenn, raffman 0
3603104 1868636 1868636 defendant Riseburgh Thomas   585907 585907 Riseburgh, Thomas, of Bishops Lenn, wax chandler 1
3603405 1868738 1868738 plaintiff Denne alias Deane John tanner 585907 585907 Denne alias Deane, John, of Bishops Lenn, tanner 0
3603406 1868738 1868738 defendant Alwyn Thomas brasier 585907 585907 Alwyn, Thomas, of Bishops Lenn, brasier 0
3603407 1868738 1868738 defendant Jekillis Luke smith 585907 585907 Jekillis, Luke, of Bishops Lenn, smith 1
3604539 1869084 1869084 defendant Perpoynt Henry   585907 585907 Perpoynt, Henry, of Bishops Lenn, knight 0
3604707 1869136 1869136 plaintiff Hareby or Harvy Isabel (legal representative) 585907 585907 Hareby or Harvy, Isabel, of Bishops Lenn, widow, executors of 0
3605821 1869487 1869487 defendant Gelaway Everard merchant 585907 585907 Gelaway, Everard, of Bishops Lenn, merchant 0
3607111 1869890 1869890 plaintiff Pylly Robert   585907 585907 Pylly, Robert, of Bishops Lenn 0
3607234 1869928 1869928 plaintiff Rede Joan widow 585907 585907 Rede, Joan, of Bishops Lenn, widow 0
3607236 1869928 1869928 defendant Trewe William tailor 585907 585907 Trewe, William, of Bishops Lenn, tailor 0
3607247 1869931 1869931 defendant Symkynson Thomas merchant 585907 585907 Symkynson, Thomas, of Bishops Lenn, merchant 0
3608543 1870330 1870330 defendant Warde Thomas merchant 585907 585907 Warde, Thomas, of Bishops Lenn, merchant 0
3608547 1870331 1870331 defendant Constantyn Robert husbandman 585907 585907 Constantyn, Robert, of Bishops Lenn, husbandman 0
3608550 1870332 1870332 defendant Cuttys John yeoman 585907 585907 Cuttys, John, of Bishops Lenn, yeoman 0
3608565 1870335 1870335 defendant Constantyn Robert husbandman 585907 585907 Constantyn, Robert, of Bishops Lenn, husbandman 0
3609342 1870582 1870582 defendant Blasenby Robert brewer 585907 585907 Blasenby, Robert, of Bishops Lenn, brewer 0
3609584 1870664 1870664 defendant Soweme Edmund mercer 585907 585907 Soweme, Edmund, of Bishops Lenn, mercer 0
3609585 1870664 1870664 defendant Soweme John mercer 585907 585907 Soweme, John, of Bishops Lenn, mercer 1
3609587 1870665 1870665 defendant Soweme Edmund mercer 585907 585907 Soweme, Edmund, of Bishops Lenn, mercer 0
3609589 1870666 1870666 defendant Soweme John mercer 585907 585907 Soweme, John, of Bishops Lenn, mercer 0
3610359 1870898 1870898 defendant Narforth Thomas yeoman 585907 585907 Narforth, Thomas, of Bishops Lenn, yeoman 0
3610363 1870900 1870900 defendant Narforth Thomas yeoman 585907 585907 Narforth, Thomas, of Bishops Lenn, yeoman 0
3612979 1871708 1871708 plaintiff Alysaunder John   585907 585907 Alysaunder, John, of Bishops Lenn 0
3612980 1871708 1871708 defendant Sygon Thomas tanner 585907 585907 Sygon, Thomas, of Bishops Lenn, tanner 0
3612981 1871708 1871708 defendant Trotte John butcher 585907 585907 Trotte, John, of Bishops Lenn, butcher 1
3613596 1871899 1871899 plaintiff Bastard Richard   585907 585907 Bastard, Richard, of Bishops Lenn 0
3613602 1871900 1871900 plaintiff Bastard Richard   585907 585907 Bastard, Richard, of Bishops Lenn 0
3613604 1871901 1871901 plaintiff Bastard Richard   585907 585907 Bastard, Richard, of Bishops Lenn 0
3613610 1871902 1871902 plaintiff Bastard Richard   585907 585907 Bastard, Richard, of Bishops Lenn 0
3613616 1871903 1871903 plaintiff Bastard Richard   585907 585907 Bastard, Richard, of Bishops Lenn 0
3613692 1871930 1871930 plaintiff Bees Robert merchant 585907 585907 Bees, Robert, of Bishops Lenn, merchant 0
3613693 1871930 1871930 defendant Braybroke Robert merchant 585907 585907 Braybroke, Robert, of Bishops Lenn, merchant 0
3613694 1871931 1871931 plaintiff Bees Robert merchant 585907 585907 Bees, Robert, of Bishops Lenn, merchant 0
3613695 1871931 1871931 defendant Brayebroke Robert merchant 585907 585907 Brayebroke, Robert, of Bishops Lenn, merchant 0
3613696 1871932 1871932 plaintiff Bees Robert merchant 585907 585907 Bees, Robert, of Bishops Lenn, merchant 0
3613697 1871932 1871932 defendant Clare alias Chaunterell John (legal representative) 585907 585907 Clare alias Chaunterell, John, of Bishops Lenn, raffman, executrix of 0
3613698 1871932 1871932 defendant Clare Isabel widow 585907 585907 Clare, Isabel, of Bishops Lenn, widow 1
3613973 1872028 1872028 defendant Wayte John beer brewer 585907 585907 Wayte, John, of Bishops Lenn, beer brewer 0
3613975 1872029 1872029 defendant Wayte John beer brewer 585907 585907 Wayte, John, of Bishops Lenn, beer brewer 0
3614969 1872326 1872326 defendant Thorysby Robert gent 585907 585907 Thorysby, Robert, of Bishops Lenn, gent 0
3615616 1872526 1872526 defendant Goldsmyth Arnold goldsmith 585907 585907 Goldsmyth, Arnold, of Bishops Lenn, goldsmith 0
3615618 1872527 1872527 defendant Goldsmyth Arnold goldsmith 585907 585907 Goldsmyth, Arnold, of Bishops Lenn, goldsmith 0
3615726 1872560 1872560 plaintiff Tayllour John merchant 585907 585907 Tayllour, John, of Bishops Lenn, merchant 1
3616331 1872747 1872747 defendant Sygon Thomas tanner 585907 585907 Sygon, Thomas, of Bishops Lenn, tanner 0
3616332 1872747 1872747 defendant Trotte John butcher 585907 585907 Trotte, John, of Bishops Lenn, butcher 1
3616334 1872748 1872748 defendant Sygon Thomas tanner 585907 585907 Sygon, Thomas, of Bishops Lenn, tanner 0
3616336 1872749 1872749 defendant Trotte John butcher 585907 585907 Trotte, John, of Bishops Lenn, butcher 0
3616337 1872750 1872750 plaintiff Dene John tanner 585907 585907 Dene, John, of Bishops Lenn, tanner 0
3616357 1872755 1872755 plaintiff Denne John   585907 585907 Denne, John, of Bishops Lenn 0
3616374 1872759 1872759 defendant Blaunche John dyer 585907 585907 Blaunche, John, of Bishops Lenn, dyer 4
3616379 1872759 1872759 defendant Harde Richard merchant 585907 585907 Harde, Richard, of Bishops Lenn, merchant 9
3616870 1872908 1872908 defendant Beelys John merchant 585907 585907 Beelys, John, of Bishops Lenn, merchant 0
3617013 1872941 1872941 defendant Gygges John merchant 585907 585907 Gygges, John, of Bishops Lenn, merchant 0
3618194 1873315 1873315 defendant Bladesmyth Peter chapman 585907 585907 Bladesmyth, Peter, of Bishops Lenn, chapman 0
3618200 1873317 1873317 defendant Westyrfeld Edmund chapman 585907 585907 Westyrfeld, Edmund, of Bishops Lenn, chapman 0
3618613 1873446 1873446 defendant Mannyng William butcher 585907 585907 Mannyng, William, of Bishops Lenn, butcher 2

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