names

2,360 rows where place_id = 586365

✎ 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
3588529 1864056 1864056 defendant Hykkys John husbandman 586365 586365 Hykkys, John, of Wymondham, husbandman 1
3588530 1864056 1864056 defendant Pallyng Robert dyer 586365 586365 Pallyng, Robert, of Wymondham, dyer 2
3589350 1864310 1864310 defendant Lombe Thomas gent 586365 586365 Lombe, Thomas, of Wymondham, gent 2
3589351 1864310 1864310 defendant Luce Thomas husbandman 586365 586365 Luce, Thomas, of Wymondham, husbandman 3
3589352 1864310 1864310 defendant Fydymond Edmund husbandman 586365 586365 Fydymond, Edmund, of Wymondham, husbandman 4
3590777 1864754 1864754 defendant Tylney Peter miller 586365 586365 Tylney, Peter, of Wymondham, miller 0
3591063 1864834 1864834 plaintiff Deken John   586365 586365 Deken, John, of Wymondham 0
3591064 1864834 1864834 defendant Couper Thomas butcher 586365 586365 Couper, Thomas, of Wymondham, butcher 0
3591793 1865054 1865054 plaintiff Feke Alice   586365 586365 Feke, Alice, of Wymondham 0
3591795 1865054 1865054 defendant Whitlawe Oliver husbandman 586365 586365 Whitlawe, Oliver, of Wymondham, husbandman 0
3591797 1865055 1865055 plaintiff Feke Alice   586365 586365 Feke, Alice, of Wymondham 0
3591799 1865055 1865055 defendant Whytlawe Oliver husbandman 586365 586365 Whytlawe, Oliver, of Wymondham, husbandman 0
3591800 1865056 1865056 plaintiff Feke Alice   586365 586365 Feke, Alice, of Wymondham 0
3595098 1866098 1866098 defendant Wyseman William   586365 586365 Wyseman, William, of Wymondham, wheelwright 0
3595099 1866098 1866098 defendant Barbour Robert husbandman 586365 586365 Barbour, Robert, of Wymondham, husbandman 1
3595100 1866098 1866098 defendant Langforth John scrivener 586365 586365 Langforth, John, of Wymondham, scrivener 2
3596037 1866388 1866388 defendant Wederby John gent 586365 586365 Wederby, John, of Wymondham, gent 2
3599170 1867377 1867377 defendant Lambe William husbandman 586365 586365 Lambe, William, of Wymondham, husbandman 0
3601064 1867999 1867999 defendant Lambe William, junior yeoman 586365 586365 Lambe, William, junior, of Wymondham, yeoman 2
3602696 1868507 1868507 defendant Metyngham John yeoman 586365 586365 Metyngham, John, of Wymondham, yeoman 0
3602698 1868507 1868507 defendant Nelyng William husbandman 586365 586365 Nelyng, William, of Wymondham, husbandman 2
3603343 1868719 1868719 defendant Donkys or Doukys Robert husbandman 586365 586365 Donkys or Doukys, Robert, of Wymondham, husbandman 2
3603733 1868838 1868838 defendant Sherer Nicholas husbandman 586365 586365 Sherer, Nicholas, of Wymondham, husbandman 0
3605420 1869362 1869362 defendant Colyour Robert chaplain 586365 586365 Colyour, Robert, of Wymondham, chaplain 0
3606583 1869732 1869732 defendant Nelyng William husbandman 586365 586365 Nelyng, William, of Wymondham, husbandman 0
3606960 1869839 1869839 defendant Wyseman William   586365 586365 Wyseman, William, of Wymondham, wheel wright 2
3611717 1871326 1871326 defendant Walter John butcher 586365 586365 Walter, John, of Wymondham, butcher 0
3612757 1871641 1871641 defendant Broun George husbandman 586365 586365 Broun, George, of Wymondham, husbandman 0
3613289 1871806 1871806 defendant Mortymer Thomas butcher 586365 586365 Mortymer, Thomas, of Wymondham, butcher 1
3613794 1871970 1871970 defendant Lambe Thomas yeoman 586365 586365 Lambe, Thomas, of Wymondham, yeoman 0
3615409 1872460 1872460 defendant Kebyte John chaplain 586365 586365 Kebyte, John, of Wymondham, chaplain 0
3618252 1873332 1873332 defendant Lambe Thomas yeoman 586365 586365 Lambe, Thomas, of Wymondham, yeoman 1
3618253 1873332 1873332 defendant Lambe William, junior yeoman 586365 586365 Lambe, William, junior, of Wymondham, yeoman 2
3621299 1874203 1874203 defendant Wyseman John   586365 586365 Wyseman, John, of Wymondham, wheelwright 0
3622577 1874597 1874597 plaintiff Radclyf James   586365 586365 Radclyf, James, of Wymondham, gent, administrators of 0
3622581 1874598 1874598 plaintiff Radclyff John   586365 586365 Radclyff, John, of Wymondham, gent, administrators of 0
3622707 1874630 1874630 defendant Rochester William yeoman 586365 586365 Rochester, William, of Wymondham, yeoman 0
3624503 1875199 1875199 defendant Chapleyn Robert baker 586365 586365 Chapleyn, Robert, of Wymondham, baker 0
3625491 1875512 1875512 defendant Broun George husbandman 586365 586365 Broun, George, of Wymondham, husbandman 0
3626894 1903263 1903263 plaintiff Ibry or Ivry William chaplain 586365 586365 Ibry or Ivry, William, of Wymondham, chaplain 1
3631571 1904687 1904687 defendant Gaye John raffman 586365 586365 Gaye, John, of Wymondham, raffman 0
3639136 1907059 1907059 defendant Wyseman Robert husbandman 586365 586365 Wyseman, Robert, of Wymondham, husbandman 1
3639235 1907083 1907083 defendant Davy William husbandman 586365 586365 Davy, William, of Wymondham, husbandman 1
3639855 1907279 1907279 plaintiff Wulterton Agnes widow 586365 586365 Wulterton, Agnes, of Wymondham, widow 0
3639856 1907279 1907279 plaintiff Mortymer Thomas   586365 586365 Mortymer, Thomas, of Wymondham 1
3642770 1908188 1908188 defendant Sayer Thomas dyer 586365 586365 Sayer, Thomas, of Wymondham, dyer 1
3642771 1908188 1908188 defendant Borowe William   586365 586365 Borowe, William, of Wymondham, wax chandler 2
3643513 1908401 1908401 defendant Martyn Thomas miller 586365 586365 Martyn, Thomas, of Wymondham, miller 1
3643740 1908469 1908469 defendant Sare Thomas dyer 586365 586365 Sare, Thomas, of Wymondham, dyer 0
3645513 1908995 1908995 defendant Wyseman Robert husbandman 586365 586365 Wyseman, Robert, of Wymondham, husbandman 9
3647527 1909616 1909616 defendant Harold John baker 586365 586365 Harold, John, of Wymondham, baker 1
3648242 1909848 1909848 defendant Palmer Robert husbandman 586365 586365 Palmer, Robert, of Wymondham, husbandman 0
3648245 1909848 1909848 defendant Foster John husbandman 586365 586365 Foster, John, of Wymondham, husbandman 3
3649541 1910246 1910246 defendant Barkley William gent 586365 586365 Barkley, William, of Wymondham, gent 1
3649542 1910246 1910246 defendant Chesylden Richard gent 586365 586365 Chesylden, Richard, of Wymondham, gent 2
3649544 1910246 1910246 defendant Butler Thomas yeoman 586365 586365 Butler, Thomas, of Wymondham, yeoman 4
3649545 1910246 1910246 defendant Sharshall Thomas yeoman 586365 586365 Sharshall, Thomas, of Wymondham, yeoman 5
3649546 1910246 1910246 defendant Lyard Thomas   586365 586365 Lyard, Thomas, of Wymondham, shepherd 6
3649547 1910246 1910246 defendant Chace John laborer 586365 586365 Chace, John, of Wymondham, laborer 7
3649548 1910246 1910246 defendant Legge John laborer 586365 586365 Legge, John, of Wymondham, laborer 8
3649549 1910246 1910246 defendant Foliambe James laborer 586365 586365 Foliambe, James, of Wymondham, laborer 9
3652774 1911188 1911188 defendant Bake Christopher pedder 586365 586365 Bake, Christopher, of Wymondham, pedder 0
3655131 1911865 1911865 defendant Goldespynk John husbandman 586365 586365 Goldespynk, John, of Wymondham, husbandman 4
3655559 1912000 1912000 plaintiff Bransforth John   586365 586365 Bransforth, John, of Wymondham, abbot of St Mary's monastery, successor to Thomas Chamberlain, formerly abbot 0
3655561 1912001 1912001 plaintiff Bransforth John   586365 586365 Bransforth, John, of Wymondham, abbot of the Monastery of the Blessed Mary 0
3655562 1912001 1912001 defendant Luce Thomas husbandman 586365 586365 Luce, Thomas, of Wymondham, husbandman 0
3655563 1912002 1912002 plaintiff Bransforth John   586365 586365 Bransforth, John, of Wymondham, abbot of the Monastery of the Blessed Mary 0
3655566 1912002 1912002 defendant Mokelfeld William baker 586365 586365 Mokelfeld, William, of Wymondham, baker 2
3655567 1912003 1912003 plaintiff Bransforth John   586365 586365 Bransforth, John, of Wymondham, abbot of the Monastery of the Blessed Mary 0
3655568 1912003 1912003 defendant Symondes Robert husbandman 586365 586365 Symondes, Robert, of Wymondham, husbandman 0
3659578 1913255 1913255 defendant Cheseman Thomas smith 586365 586365 Cheseman, Thomas, of Wymondham, smith 1
3659579 1913255 1913255 defendant Bettys William smith 586365 586365 Bettys, William, of Wymondham, smith 2
3660966 1913701 1913701 defendant Cheseman Thomas smith 586365 586365 Cheseman, Thomas, of wymondham, smith 2
3664994 1914996 1914996 defendant Laurens Robert laborer 586365 586365 Laurens, Robert, of Wymondham, laborer 0
3666704 1915533 1915533 defendant Reynbard John butcher 586365 586365 Reynbard, John, of Wymondham, butcher 2
3667483 1915772 1915772 defendant Knyght alias Kett Thomas butcher 586365 586365 Knyght alias Kett, Thomas, of Wymondham, butcher 0
3671887 1917203 1917203 defendant Cheseman Thomas smith 586365 586365 Cheseman, Thomas, of Wymondham, smith 0
3681401 1920270 1920270 defendant Couper William butcher 586365 586365 Couper, William, of Wymondham, butcher 0
3681410 1920272 1920272 defendant Couper William butcher 586365 586365 Couper, William, of Wymondham, butcher 3
3686441 1921913 1921913 defendant Rudde John husbandman 586365 586365 Rudde, John, of Wymondham, husbandman 0
3691603 1923530 1923530 defendant Kent John butcher 586365 586365 Kent, John, of Wymondham, butcher 0
3691789 1923593 1923593 defendant Elyngham William husbandman 586365 586365 Elyngham, William, of Wymondham, husbandman 0
3697518 1925446 1925446 defendant Englys Richard   586365 586365 Englys, Richard, of Wymondham, mason 0
3700753 1926488 1926488 defendant Gospyn John weaver 586365 586365 Gospyn, John, of Wymondham, weaver 0
3701462 1926703 1926703 defendant Knyght John, junior bytcher 586365 586365 Knyght, John, junior, of Wymondham, bytcher 0
3701464 1926704 1926704 defendant Rowchester William mercer 586365 586365 Rowchester, William, of Wymondham, mercer 0
3703264 1927292 1927292 defendant Hendry Thomas turner 586365 586365 Hendry, Thomas, of Wymondham, turner 2
3703265 1927292 1927292 defendant Agas John carrier 586365 586365 Agas, John, of Wymondham, carrier 3
3705868 1928119 1928119 defendant Kette John, junior butcher 586365 586365 Kette, John, junior, of Wymondham, butcher 0
3706826 1928419 1928419 plaintiff Kensey Robert   586365 586365 Kensey, Robert, of Wymondham 0
3706827 1928419 1928419 defendant Stalworth Thomas   586365 586365 Stalworth, Thomas, of Wymondham, cartwright 0
3708076 1928827 1928827 defendant Plomer Robert yeoman 586365 586365 Plomer, Robert, of Wymondham, yeoman 1
3710366 1929561 1929561 plaintiff Sharp William (legal representative) 586365 586365 Sharp, William, of Wymondham, executors of 0
3710373 1929563 1929563 plaintiff Sharpe William (legal representative) 586365 586365 Sharpe, William, of Wymondham, executors of 0
3710522 1929612 1929612 defendant Englyssh Richard   586365 586365 Englyssh, Richard, of Wymondham, mason 4
3712866 1930343 1930343 defendant Lytylprowe Thomas laborer 586365 586365 Lytylprowe, Thomas, of Wymondham, laborer 0
3712869 1930343 1930343 defendant Kytte alias Knyght John husbandman 586365 586365 Kytte alias Knyght, John, of Wymondham, husbandman 3
3714098 1930708 1930708 defendant Foster John husbandman 586365 586365 Foster, John, of Wymondham, husbandman 0
3714099 1930708 1930708 defendant Hough Simon husbandman 586365 586365 Hough, Simon, of Wymondham, cooper, Style, Edmund, of Trows, husbandman 1
3717830 1931881 1931881 defendant Fordham John spooner 586365 586365 Fordham, John, of Wymondham, spooner 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);