names

127,000 rows where place_id = 585869

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587389 1863699 1863699 defendant Toft Henry gent 585869 585869 Toft, Henry, of London, gent 0
3587410 1863708 1863708 plaintiff Parker Thomas ironmonger 585869 585869 Parker, Thomas, of London, ironmonger 1
3587414 1863708 1863708 defendant Lane John   585869 585869 Lane, John, of London, gent, registrar for Bishop of Lincoln 3
3587417 1863710 1863710 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587421 1863711 1863711 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587425 1863712 1863712 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587429 1863713 1863713 plaintiff Abraham Thomas grocer 585869 585869 Abraham, Thomas, of London, grocer 0
3587478 1863730 1863730 plaintiff Adyffe or Adysse Richard tailor 585869 585869 Adyffe or Adysse, Richard, of London, tailor 0
3587491 1863734 1863734 defendant Agmondesham Margaret widow 585869 585869 Agmondesham, Margaret, of London, widow 0
3587492 1863735 1863735 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587493 1863735 1863735 defendant a Cornwell Thomas   585869 585869 a Cornwell, Thomas, of London, knight 0
3587495 1863736 1863736 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587497 1863737 1863737 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587498 1863737 1863737 defendant Cobcote Richard gent 585869 585869 Cobcote, Richard, of London, gent 0
3587499 1863737 1863737 defendant Ferman Richard   585869 585869 Ferman, Richard, of London, gent, servant to Bourgchyer, John 1
3587500 1863737 1863737 defendant Coke Thomas   585869 585869 Coke, Thomas, of London, yeoman, servant to Bourgchyer, John 2
3587501 1863738 1863738 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587502 1863738 1863738 defendant Coryton or Conrton John gent 585869 585869 Coryton or Conrton, John, of London, gent 0
3587503 1863739 1863739 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587506 1863740 1863740 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587507 1863740 1863740 defendant Shirwode Thomas gent 585869 585869 Shirwode, Thomas, of London, gent 0
3587509 1863740 1863740 defendant Louther John gent 585869 585869 Louther, John, of London, gent 2
3587510 1863741 1863741 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587512 1863741 1863741 defendant Tresaldoun John   585869 585869 Tresaldoun, John, of London, cook 1
3587513 1863742 1863742 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587517 1863743 1863743 plaintiff Akstell Henry draper 585869 585869 Akstell, Henry, of London, draper 0
3587521 1863745 1863745 plaintiff Alathiam Ralph goldsmith 585869 585869 Alathiam, Ralph, of London, goldsmith 0
3587548 1863754 1863754 defendant Long John brewer 585869 585869 Long, John, of London, brewer 0
3587583 1863764 1863764 defendant Lyonell or Lyonhill Hugh goldsmith 585869 585869 Lyonell or Lyonhill, Hugh, of London, goldsmith 0
3587584 1863765 1863765 plaintiff Alwyn Nicholas mercer 585869 585869 Alwyn, Nicholas, of London, mercer 0
3587587 1863766 1863766 plaintiff Alwyn Nicholas mercer 585869 585869 Alwyn, Nicholas, of London, mercer 0
3587591 1863767 1863767 plaintiff Alwyn Nicholas mercer 585869 585869 Alwyn, Nicholas, of London, mercer 0
3587594 1863767 1863767 defendant Markeham John gent or esq 585869 585869 Markeham, John, of London, gent or esq 2
3587595 1863767 1863767 defendant Boson Henry gent 585869 585869 Boson, Henry, of London, gent 3
3587596 1863768 1863768 plaintiff Alwyn Nicholas mercer 585869 585869 Alwyn, Nicholas, of London, mercer 0
3587695 1863796 1863796 defendant Mody Edmund gent 585869 585869 Mody, Edmund, of London, gent 0
3587697 1863797 1863797 defendant Smyth William gent 585869 585869 Smyth, William, of London, gent 0
3587714 1863805 1863805 plaintiff Assheborn Henry gent 585869 585869 Assheborn, Henry, of London, gent 0
3587716 1863805 1863805 defendant Morton Thomas clerk 585869 585869 Morton, Thomas, of London, clerk 1
3587737 1863811 1863811 plaintiff Astre alias Austreth Ralph fishmonger 585869 585869 Astre alias Austreth, Ralph, of London, fishmonger 0
3587750 1863814 1863814 defendant Mody Edmund gent 585869 585869 Mody, Edmund, of London, gent 0
3587751 1863814 1863814 defendant Smyth William gent 585869 585869 Smyth, William, of London, gent 1
3587841 1863844 1863844 plaintiff Awebrey Richard haberdasher 585869 585869 Awebrey, Richard, of London, haberdasher 0
3587843 1863845 1863845 plaintiff Awebrey Richard haberdasher 585869 585869 Awebrey, Richard, of London, haberdasher 0
3587867 1863854 1863854 plaintiff Aylmer Lawrence draper 585869 585869 Aylmer, Lawrence, of London, draper 0
3587868 1863854 1863854 defendant Arderne Thomas gent 585869 585869 Arderne, Thomas, of London, gent 0
3587869 1863855 1863855 plaintiff Aylmer Lawrence draper 585869 585869 Aylmer, Lawrence, of London, draper 0
3587874 1863857 1863857 defendant Hole Alice widow 585869 585869 Hole, Alice, of London, widow 0
3587876 1863858 1863858 defendant Hoole Alice widow 585869 585869 Hoole, Alice, of London, widow 0
3587953 1863884 1863884 plaintiff Baily David skinner 585869 585869 Baily, David, of London, skinner 0
3587955 1863885 1863885 plaintiff Baily David skinner 585869 585869 Baily, David, of London, skinner 0
3587972 1863891 1863891 defendant Partryche Andrew merchant and ironmonger 585869 585869 Partryche, Andrew, of London, merchant and ironmonger 1
3588022 1863906 1863906 defendant Smyth John armorer 585869 585869 Smyth, John, of London, armorer 0
3588032 1863911 1863911 plaintiff Banaster Thomas (legal representative) 585869 585869 Banaster, Thomas, of London, innholder and vintner, executors of 0
3588035 1863911 1863911 defendant Delves Ellen   585869 585869 Delves, Ellen, of London, widow of Delves, John, knight 0
3588036 1863911 1863911 defendant Delves Ralph gent 585869 585869 Delves, Ralph, of London, gent 1
3588109 1863930 1863930 plaintiff Barker John goldsmith 585869 585869 Barker, John, of London, goldsmith 0
3588110 1863930 1863930 defendant ap Roger Thomas, junior   585869 585869 ap Roger, Thomas, junior, of London, knight, son of Vaghan, Roger, knight 0
3588111 1863931 1863931 plaintiff Barker John goldsmith 585869 585869 Barker, John, of London, goldsmith 0
3588112 1863931 1863931 defendant ap Roger Thomas, junior   585869 585869 ap Roger, Thomas, junior, of London, knight, son of Vaghan, Roger, knight 0
3588113 1863932 1863932 plaintiff Barker John goldsmith 585869 585869 Barker, John, of London, goldsmith 0
3588116 1863932 1863932 defendant Palmer Thomas   585869 585869 Palmer, Thomas, of London, "chapemaker" 2
3588117 1863933 1863933 plaintiff Barker John goldsmith 585869 585869 Barker, John, of London, goldsmith 0
3588120 1863933 1863933 defendant Palmer Thomas   585869 585869 Palmer, Thomas, of London, "chapemaker" 2
3588121 1863934 1863934 plaintiff Barker John goldsmith 585869 585869 Barker, John, of London, goldsmith 0
3588128 1863937 1863937 plaintiff Barlowe Roger tailor 585869 585869 Barlowe, Roger, of London, tailor 0
3588130 1863938 1863938 plaintiff Barlowe Roger tailor 585869 585869 Barlowe, Roger, of London, tailor 0
3588140 1863941 1863941 defendant Burbage William gent 585869 585869 Burbage, William, of London, gent 0
3588141 1863941 1863941 defendant Russell Henry gent 585869 585869 Russell, Henry, of London, gent 1
3588144 1863943 1863943 plaintiff Barnewell John (legal representative) 585869 585869 Barnewell, John, of London, stockfishmonger, executors of 0
3588154 1863946 1863946 defendant Fetplace Anthony gent 585869 585869 Fetplace, Anthony, of London, gent 0
3588168 1863953 1863953 plaintiff Bartlat Roger ironmonger 585869 585869 Bartlat, Roger, of London, ironmonger 0
3588178 1863956 1863956 plaintiff Barton John mercer 585869 585869 Barton, John, of London, mercer 0
3588180 1863957 1863957 plaintiff Barton John mercer 585869 585869 Barton, John, of London, mercer 0
3588269 1863987 1863987 plaintiff Beauchamp John draper 585869 585869 Beauchamp, John, of London, draper 0
3588277 1863988 1863988 plaintiff Beauchamp John draper 585869 585869 Beauchamp, John, of London, draper 0
3588291 1863991 1863991 defendant Foster John clerk 585869 585869 Foster, John, of London, clerk 0
3588418 1864027 1864027 plaintiff Benyngton John grocer 585869 585869 Benyngton, John, of London, grocer 0
3588423 1864028 1864028 plaintiff Benyngton John grocer 585869 585869 Benyngton, John, of London, grocer 0
3588429 1864029 1864029 defendant Symons Thomas clerk 585869 585869 Symons, Thomas, of London, clerk 0
3588432 1864031 1864031 plaintiff Bere Margaret   585869 585869 Bere, Margaret, of London widow 0
3588434 1864032 1864032 plaintiff Bere Margaret widow 585869 585869 Bere, Margaret, of London, widow 0
3588438 1864034 1864034 plaintiff Berell John, senior (legal representative) 585869 585869 Berell, John, senior, of London, grocer, executors of 0
3588440 1864034 1864034 plaintiff Berell William grocer 585869 585869 Berell, William, of London, grocer 2
3588445 1864035 1864035 plaintiff Berell John, senior (legal representative) 585869 585869 Berell, John, senior, of London, grocer, executors of 0
3588447 1864035 1864035 plaintiff Berell William grocer 585869 585869 Berell, William, of London, grocer 2
3588451 1864036 1864036 plaintiff Berell William grocer 585869 585869 Berell, William, of London, grocer 0
3588518 1864054 1864054 plaintiff Best John mercer 585869 585869 Best, John, of London, mercer 0
3588553 1864062 1864062 defendant Nasshe Thomas pewterer 585869 585869 Nasshe, Thomas, of London, pewterer 0
3588651 1864092 1864092 defendant Cary William gent 585869 585869 Cary, William, of London, gent 0
3588652 1864092 1864092 defendant Cumberford Edward gent 585869 585869 Cumberford, Edward, of London, gent 1
3588698 1864109 1864109 defendant Vernon William, junior gent 585869 585869 Vernon, William, junior, of London, gent 0
3588700 1864110 1864110 defendant Vernon William, junior gent 585869 585869 Vernon, William, junior, of London, gent 0
3588725 1864116 1864116 defendant Vernon William merchant 585869 585869 Vernon, William, of London, merchant 0
3588798 1864142 1864142 plaintiff Boterey William mercer 585869 585869 Boterey, William, of London, mercer 0
3588806 1864146 1864146 plaintiff Botry William mercer 585869 585869 Botry, William, of London, mercer 0
3588811 1864148 1864148 defendant Fowler Thomas gent 585869 585869 Fowler, Thomas, of London, or of Buckingham, gent 0
3588812 1864149 1864149 plaintiff Boulsdon Thomas skinner 585869 585869 Boulsdon, Thomas, of London, skinner 0
3588813 1864149 1864149 defendant Dalowe Miles gent 585869 585869 Dalowe, Miles, of London, gent 0
3588814 1864149 1864149 defendant Popley Thomas   585869 585869 Popley, Thomas, of London, parson of Buklond 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);