cases

Plea-roll index rows (one case entry per source row).
side
Membrane face — f (front) or d (dorse), when known.
image
Membrane / frame number from the index (not a URL). Use with rolls.aalt_roll_url to find the scan on AALT.
roll_label
Roll identifier copied from the source index.
roll_number
Numeric roll id when present on the row.
county
Court venue for the case (not necessarily the person’s place county).
source_downloaded_at
ISO date (YYYY-MM-DD) from the filesystem mtime of the saved index file — proxy for when that WAALT/AALT page was downloaded (not the SQLite import time).

4,681 rows where roll_id = 15

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: side, source_downloaded_at (date)

id ▼ roll_id side roll_number image county case_type plaintiff defendant source_row source_file roll_label term year monarch source_downloaded_at
1975775 15 15 d   3558 Sussex common recovery A Broke, Richard Halle, William, esq 1 cp40_1092.txt CP40/1092       2026-01-16
1975776 15 15 d   4093   writing A Broke, Richard, senior, of Lytlyngton Sage, Robert, of Lytlyngton, Essex, son of Sage, Simon 2 cp40_1092.txt CP40/1092       2026-01-16
1975777 15 15 d   3401 Bucks trespass: assault A Grene, William; Alice his wife Raunce, John, of Chepyng Wycombe, husbandman 3 cp40_1092.txt CP40/1092       2026-01-16
1975778 15 15 f   2600 Herefs debt A Gwilliam(?), John Lewis, Christopher, of Leomynster, saddler; Lyde, Thomas, of Leomynster, tailor; Hewis, Thomas, of Bodenham, chaplain; Carpynter; Richard, of Leomynster, butcher 4 cp40_1092.txt CP40/1092       2026-01-16
1975779 15 15 d   3024 Lincs trespass: close Abbot, Robert Jesop, Robert, of Carleby, husbandman 5 cp40_1092.txt CP40/1092       2026-01-16
1975780 15 15 f   1736 Lincs debt Abbott, Robert Lyones, John, of Donyngton, glover 6 cp40_1092.txt CP40/1092       2026-01-16
1975781 15 15 f   1761 Essex debt Abbys, James Dyglott, John, of Pedmarsshe, smith; Lorde, John, of Moche Horsley, husbandman; Mendam, Robert, of Boxford, Suff, smith; Brewer, Thomas, of Moche Horsley, husbandman; Brewer, William, of Boxted, carpenter 7 cp40_1092.txt CP40/1092       2026-01-16
1975782 15 15 f   2401 Suff debt Abbys, James, of Naylande, clothmaker Lulley, Stephen, of Naylande, "macer" 8 cp40_1092.txt CP40/1092       2026-01-16
1975783 15 15 f   2755 London debt Abram alias Abraham, Thomas, of London, mercer or leather seller Boyton, Matthew, of London, esq; Haydon, John, of London, gent 9 cp40_1092.txt CP40/1092       2026-01-16
1975784 15 15 f   2896 London debt Abram, Thomas Grene, Ralph, of Partney, chapman 10 cp40_1092.txt CP40/1092       2026-01-16
1975785 15 15 d   3539 London debt Abram, Thomas Grene, Ralph, of Partney, Lincs, chapman 11 cp40_1092.txt CP40/1092       2026-01-16
1975786 15 15 d   3783 London debt Abram, Thomas Grene, Ralph, of Partney, Lincs, chapman 12 cp40_1092.txt CP40/1092       2026-01-16
1975787 15 15 d   3213 Devon debt Abram, Thomas, of London, leather seller Wyse, John, of Sydenham, gent 13 cp40_1092.txt CP40/1092       2026-01-16
1975788 15 15 d   3214 Warks debt Abram, Thomas, senior, of London, leather seller Slye alias Edmondes, Miles, of Baddisley, smith 14 cp40_1092.txt CP40/1092       2026-01-16
1975789 15 15 f   1986 London debt Abram, Thomas, senior, of London, leather seller Smethewyle, William, of London, gent; Mydylwoode, Roger, of Whitby, Yorks, gent 15 cp40_1092.txt CP40/1092       2026-01-16
1975790 15 15 f   2595 Herefs trespass: close Acryge, Thomas Powlle, Thomas, of Leomster, butcher 16 cp40_1092.txt CP40/1092       2026-01-16
1975791 15 15 d   3767 Worcs trespass: assault Acton, Hugh Payton, William, of Reddyche, sawyer; Yede, Humphrey, of Fekenham, miller; Gerard, Daniel, of Reddyche, laborer 17 cp40_1092.txt CP40/1092       2026-01-16
1975792 15 15 f   2349 Cornw detinue Acton, Hugh, of London, merchant tailor, executors of; (Withepoll, Paul; Wilford, William; Botery, William) Arundell, John, of Lanheron, esq 18 cp40_1092.txt CP40/1092       2026-01-16
1975793 15 15 d   4050 London debt Acton, Hugh, of London, merchant tailor, executors of; (Withepoule, Paul, of London, merchant tailor; Wylford, William, senior, of London, merchant tailor) Cauvuncle(?), John, of London, gent 19 cp40_1092.txt CP40/1092       2026-01-16
1975794 15 15 f   2875 Sussex trespass: close Acton, James Durkyn, John, of Petworth, husbandman; Toplyng, John, of Petworth, laborer; Palmer, Richard, of Petworth, laborer 20 cp40_1092.txt CP40/1092       2026-01-16
1975795 15 15 d   3458 Worcs debt Acton, John, of Westowe, gent Wheler, John, of Droytwich, gent, executors of; (Wheler, Elizabeth, of Droytwich, widow; Wheler, Gilbert, of Droytwich, gent) 21 cp40_1092.txt CP40/1092       2026-01-16
1975796 15 15 f   2245 Worcs trespass: assault Acton, Robert Southall, Roger, of Bewdeley, yeoman; Bysshop, John, of Bewdeley, laborer; Nycols, Thomas, of Bewdeley, laborer 22 cp40_1092.txt CP40/1092       2026-01-16
1975797 15 15 f   2244 Worcs trespass: close Acton, Robert, esq Southall, Roger, of Bewdeley, yeoman 23 cp40_1092.txt CP40/1092       2026-01-16
1975798 15 15 d   3768 Worcs debt Acton, Thomas, gent Yowle, Robert, of Worcester, fuller; Kyry, David, of Worcester, weaver 24 cp40_1092.txt CP40/1092       2026-01-16
1975799 15 15 f   1704 Herts debt Adam, Thomas Waller, John, of Sabbysforth, butcher; Archer, Thomas, of Sabbysford, butcher; Amber, John, of Sabbysford, mercer; Pery, John, of Manuden, husbandman; Branche, Gilbert, of Magna Haddam, husbandman; Amber, John, of Sabbysford, miller 25 cp40_1092.txt CP40/1092       2026-01-16
1975800 15 15 d   3110 London debt Adam, William, of Lenn Myller, Thomas, of Bishops Lenn, merchant 26 cp40_1092.txt CP40/1092       2026-01-16
1975801 15 15 d   2990 Staffs debt Adams, Richard, of Stretton on Donnesmore Rane, John, of Newcastle under Lyme, sherman 27 cp40_1092.txt CP40/1092       2026-01-16
1975802 15 15 d   3360 London debt execution Adams, Robert, of London, salter Sakevyle, William, of Blachyngly, Surrey, gent 28 cp40_1092.txt CP40/1092       2026-01-16
1975803 15 15 d   3388 Kent defamation Adamson, John; Joan his wife Stevynson, Thomas, of Sithyngborn, yeoman; Joan his wife; Archer, William, of Middelton juxta Sithyngborn, waterman 29 cp40_1092.txt CP40/1092       2026-01-16
1975804 15 15 f   1821 Hants trespass: assault Adamson, Robert Smyth, Thomas, of Mapuldorwell, weaver 30 cp40_1092.txt CP40/1092       2026-01-16
1975805 15 15 f   2221 Hants trespass: assault Adamson, Robert Smyth, Thomas, of Mapuldorwell, weaver 31 cp40_1092.txt CP40/1092       2026-01-16
1975806 15 15 f   2728 Norf   Adcok, John, clerk Pye, John, of Hacford juxta Hengham, husbandman; Joan his wife 32 cp40_1092.txt CP40/1092       2026-01-16
1975807 15 15 d   3860 London debt Adyngton, Thomas, of London, skinner Burgh, Thomas, knight, Lord Burgh 33 cp40_1092.txt CP40/1092       2026-01-16
1975808 15 15 f   2611 Herefs trespass: close Adys, Richard Robartys, Thomas, of Nether Shelwyke, miller; Phyllyppys, Thomas, of Nether Shelwyke, husbandman 34 cp40_1092.txt CP40/1092       2026-01-16
1975809 15 15 d   3030 Essex debt Affrith, John, senior Myles, William, of Markyate, yeoman 35 cp40_1092.txt CP40/1092       2026-01-16
1975810 15 15 d   3032 Essex debt Affrith, Thomas Affrith, John, of Kennesworth, Herts, executors of; (Newbolt, William, of Kennesworth, yeoman; Alice his wife) 36 cp40_1092.txt CP40/1092       2026-01-16
1975811 15 15 d   3040 Essex debt, vacated Affrith, Thomas Affrith, John, of Kennesworth, Herts, executors of; (Newbolt, William, of Kennesworth, yeoman; Alice his wife) 37 cp40_1092.txt CP40/1092       2026-01-16
1975812 15 15 f   2148 Middx recognisance, writ of entry Agard, Thomas Dagge, Oswold 38 cp40_1092.txt CP40/1092       2026-01-16
1975813 15 15 d   3065 Staffs debt Agarde, Nicholas Russell, Thomas, of Barton under Nedewode, husbandman 39 cp40_1092.txt CP40/1092       2026-01-16
1975814 15 15 d   3201 Lincs common recovery Agarde, Thomas Daggys, Oswald 40 cp40_1092.txt CP40/1092       2026-01-16
1975815 15 15 f   2580 Herefs debt Aglam, William Stevyns, John, of Leomynster, butcher; Inke, John, of Leomynster, dyer; Kyrlwood, John, of Erdeyslonde, husbandman 41 cp40_1092.txt CP40/1092       2026-01-16
1975816 15 15 f   2172 Surrey debt Agland, John, executor of; (Murrall, James) Thorne, George, of Mascham, husbandman 42 cp40_1092.txt CP40/1092       2026-01-16
1975817 15 15 d   3265 Norwich debt Albon, Richard Jettour, John, of Leyestoft, Suff, yeoman 43 cp40_1092.txt CP40/1092       2026-01-16
1975818 15 15 d   3637 Norwich debt Albon, Richard Jettour, John, of Leyestoft, Suff, yeoman 44 cp40_1092.txt CP40/1092       2026-01-16
1975819 15 15 d   4018 Sussex debt Alchorn, Thomas Michelborne, John, of Dychenyng, yeoman 45 cp40_1092.txt CP40/1092       2026-01-16
1975820 15 15 f   1769 Staffs trespass: close Alcok, Roger Forste, Edward, of Seyghtford, husbandman; Swancote, William, of Seightford, husbandman; Davenporte, Richard, of Seyghtford, husbandman; Forste, William, of Seyghtford, husbandman 46 cp40_1092.txt CP40/1092       2026-01-16
1975821 15 15 f   2641 Norf debt Alden, John, of Wynfarthyng Goodwyn, Edward, of London, gent; Plate, Gregory, of Tybenham, clerk; Hawkyns, William, of Suydenham(?), husbandman; Roberdys, John, of Martham, husbandman 47 cp40_1092.txt CP40/1092       2026-01-16
1975822 15 15 d   4068 Norf debt Alden, Robert, of Wynfarthyng, cooper Canne, Nicholas, of Melton, husbandman; Bryggis, William, of Mulberton, husbandman; Broun, John, of Wynfarthyng, wheelwright; Walter, Stephen, of Hokham, husbandman; Launcetour, Richard, of Dysse, husbandman 48 cp40_1092.txt CP40/1092       2026-01-16
1975823 15 15 d   4067 Norf debt Alden, Robert; Clerke, Robert, of Wynferthyng Fedymont, Robert, of Watton, carpenter 49 cp40_1092.txt CP40/1092       2026-01-16
1975824 15 15 f   2058 Norf debt Alden, Thomas Bolton, William, of Garboldesham, gent 50 cp40_1092.txt CP40/1092       2026-01-16
1975825 15 15 d   4068 Norf debt Alden, Thomas, of Wynfarthyng Isake, William, of Sporle, yeoman; More, Thomas, of Carleton Rode, thatcher; Jowell, Christopher, of Carleton Rode, husbandman 51 cp40_1092.txt CP40/1092       2026-01-16
1975826 15 15 f   2528 Berks debt Aldeworthe, Marion Kete(?), Marion, of Chepyngsley, widow 52 cp40_1092.txt CP40/1092       2026-01-16
1975827 15 15 d   3267 Norwich debt Aldryche, Gregory, of Norwich Lane, Roger, of Bungey, Suff, merchant; Breke, William, of Bungey, mercer, Coode, John, of Nungey, wax chandler 53 cp40_1092.txt CP40/1092       2026-01-16
1975828 15 15 f   2734 Norwich debt Aldryche, Gregory, of Norwich Lane, Roger, of Bungey, Suff, merchant; Broke, William, of Bungey, mercer; Code, John, of Bungey, wax chandler 54 cp40_1092.txt CP40/1092       2026-01-16
1975829 15 15 f   2797 Norwich debt Aldryche, Gregory, of Norwich, mercer Rysburgh, William, of Norwich, grocer; Wynfeld, John, of Stalem, husbandman 55 cp40_1092.txt CP40/1092       2026-01-16
1975830 15 15 d   3588 Hants trespass: close Alee, Richard, administrators of; (Alee, Thomas; Alee, John) Bromall, Richard, of Beaulewe, tailor 56 cp40_1092.txt CP40/1092       2026-01-16
1975831 15 15 d   4015 Cams debt Alee, Richard, gent Ely Cathedral, Robert, prior of 57 cp40_1092.txt CP40/1092       2026-01-16
1975832 15 15 f   1752 Herts debt Alen alias Warren, John Bedell, George, of Stondon, yeoman 58 cp40_1092.txt CP40/1092       2026-01-16
1975833 15 15 d   3424 Berks debt Alen, Edward, gent Mayhewe, John, of Burghfeld, gent; Clerke, John, of Bastelden, yeoman; George, John, of Wolston, yeoman 59 cp40_1092.txt CP40/1092       2026-01-16
1975834 15 15 d   3384 Sussex trespass: close Alen, John Rose, John, of Horsham, baker; Cowper, John, of Horsham, baker 60 cp40_1092.txt CP40/1092       2026-01-16
1975835 15 15 f   1755 Essex account as receiver Alen, John, archbishop of Dublin, administrator of; (Alen, Thomas) Alen, John, of London, knight 61 cp40_1092.txt CP40/1092       2026-01-16
1975836 15 15 f   2416 London debt Alen, Ralph Conway, Thomas, of Denbigh, North Wales, chapman; Wryght, Thomas, of Worcester, dyer; Draper, Richard, of Oswester, Salop, chapman 62 cp40_1092.txt CP40/1092       2026-01-16
1975837 15 15 f   1882 London debt Alen, Ralph Conwaye, Thomas, of Denbigh, North Wales, chapman; Conwaye, Henry, of Denbigh, chapman; Wryght, Thomas, of Worcester, dyer; Draper, Richard, of Oswester, Salop, chapman 63 cp40_1092.txt CP40/1092       2026-01-16
1975838 15 15 f   2349 Yorks debt Alen, Ralph Medley, John, of Wakefeld, clothier; Medley, Robert, of Wakefeld, clothier; Spynke, Richard, of Wakefeld, yeoman 64 cp40_1092.txt CP40/1092       2026-01-16
1975839 15 15 f   2720 Shrops debt Alen, Richard, of London, haberdasher Hood, Richard, of Bysshops Castell, mercer 65 cp40_1092.txt CP40/1092       2026-01-16
1975840 15 15 f   2718 Staffs debt Alen, Roger Turner, James, of Burselen, yeoman; Aleyn, William, of Leke, husbandman; Wassynton, Edward, of Foulechers, husbandman; Bayle, Stephen, of Newcastle under Lyme, butcher 66 cp40_1092.txt CP40/1092       2026-01-16
1975841 15 15 d   3039 Essex debt Alen, Thomas, of Raylegh, yeoman Artur, Robert, of Sudmynster, gent 67 cp40_1092.txt CP40/1092       2026-01-16
1975842 15 15 f   1729 Staffs trespass Alett, Christopher Mason, John, of Horseley, Ecclessall, laborer; Weston, Richard, of Horseley, Ecclessall, laborer 68 cp40_1092.txt CP40/1092       2026-01-16
1975843 15 15 f   2701 Nottingham debt Aleyn, Edward, of Wheston; Joan his wife Richardson alias James, Thomas, of Tyddyswall, Derbs, yeoman; Shakarley, Thomas, of Mornsall, Derbs, gent 69 cp40_1092.txt CP40/1092       2026-01-16
1975844 15 15 f   2044 Norf debt Aleyn, Gregory Rycheman, Edward, of Swafeld, worsted weaver 70 cp40_1092.txt CP40/1092       2026-01-16
1975845 15 15 f   2729 Norf debt Aleyn, Henry Crowde, Richard, of Cromwe, merchant; Chosyll, Edward, of Aylsham, butcher 71 cp40_1092.txt CP40/1092       2026-01-16
1975846 15 15 f   2922 Norf debt Aleyn, Henry, clerk; Hare, William, gent Wattys, Richard, of Norwich, patton maker; Funtyng, John, of Norwich, merchant 72 cp40_1092.txt CP40/1092       2026-01-16
1975847 15 15 f   2735 Norwich debt Aleyn, John, of Norwich, hosier or bellfounder Johnson, Peter, of Rysyng Castell, yeoman; Newton, Nicholas, of Rysyng Castell, husbandman; Bexendell, Christopher, of Pykenham Wade, innkeeper 73 cp40_1092.txt CP40/1092       2026-01-16
1975848 15 15 f   2042 Norwich debt Aleyn, John, of Norwich, hosier or bellfounder Johnson, Peter, of Rysyng Castell, yeoman; Salter, Thomas, of Rysyng Castell, yeoman; Newton, Nicholas, of Rysyng Castell, husbandman; Bexendell, Christopher, of Pykenham Wade, innkeeper; Kent, John, of Rysyng Castell, yeoman 74 cp40_1092.txt CP40/1092       2026-01-16
1975849 15 15 f   2062 Norwich debt Aleyn, John, of Norwich, hosier or bellfounder Kent, John, of Rysyng Castell, yeoman 75 cp40_1092.txt CP40/1092       2026-01-16
1975850 15 15 f   2061 Norwich debt Aleyn, John, of Norwich, hosier or bellfounder Salter, Thomas, of Rysyng Castell, yeoman 76 cp40_1092.txt CP40/1092       2026-01-16
1975851 15 15 f   2373 Cornw quare impedit Aleyn, John; Gosnold, Edward, yeoman Vesey, John, Bishop of Exeter; Vyan, Nicholas John; Taylour, John, clerk 77 cp40_1092.txt CP40/1092       2026-01-16
1975852 15 15 f   2342 London debt Aleyn, Ralph Conway, Thomas, of Denbigh, North Wales, chapman; Wryght, Thomas, of Worcester, dyer; Draper, Richard, of Oswester, Salop, chapman 78 cp40_1092.txt CP40/1092       2026-01-16
1975853 15 15 f   1848 London debt Aleyn, Ralph Henkley, William, of Lichfeld, Staffs, dyer; Harvye, Thomas, of Worsettur, dyer; Mylward, Richard, of Aynowe, Oxon, chapman; Crosse, Robert, of Chester, glover; Heydon, John, of Tetbury, Glos, chapman 79 cp40_1092.txt CP40/1092       2026-01-16
1975854 15 15 f   2287 Suff debt Aleyn, Richard Trykker, William, of Stanton, husbandman 80 cp40_1092.txt CP40/1092       2026-01-16
1975855 15 15 f   2800 Norf debt Aleyn, Robert, of Lowistofte, Suff, draper Bokenham, William, of Hallysworth, Suff, coverlet weaver; Humfrey, John, of Dekylburgh, husbandman; Buckenham, Thomas, of Pullam Mary, coverlet weaver 81 cp40_1092.txt CP40/1092       2026-01-16
1975856 15 15 d   3757 Worcs debt Alflete, John Hardyng alias Williams, John, of Droitwiche, butcher; Hunt, John, of Salwarpe, husbandman; Hocrell, William, of Droitwiche, butcher 82 cp40_1092.txt CP40/1092       2026-01-16
1975857 15 15 f   2591 Worcs trespass: close Alflete, John Walter, Robert, of Marten Hussintre, laborer 83 cp40_1092.txt CP40/1092       2026-01-16
1975858 15 15 d   3458 Worcs debt Alford, Robert Alford, James, of Claymes, husbandman; Shreve, Thomas, of Worcester, butcher; Stocke, John, of Pyrton, caryer; Tomkyns alias Wever, William, of Worcerter, butcher 84 cp40_1092.txt CP40/1092       2026-01-16
1975859 15 15 f   1851 London debt Alford, Robert, of London, draper Hastynge, George, of London, knight, Earl of Huntyngdon; Brokesby, Francis, of Assheby de la Zouche, Leics, gent 85 cp40_1092.txt CP40/1092       2026-01-16
1975860 15 15 d   3800 London debt Algar, James Dune, Thomas, of Cotnes, Yorks, husbandman; Padley, Roger, of Rotheram, Yorks, chapman; Wylde, Robert, of Toynton, Lincs, yeoman; Holtby, Christopher, of Lincoln, yeoman; Barnaby, William, of Melton Mowbrey, Leics, mercer 86 cp40_1092.txt CP40/1092       2026-01-16
1975861 15 15 f   2906 London debt Algar, James Dune, Thomas, of Cotnes, Yorks, husbandman; Padley, Roger, of Rotheram, Yorks, chapman; Wylde, Robert, of Toynton, Lincs, yeoman; Holtby, Christopher, of Lincoln, yeoman; Barnaby, William, of Melton Mowbrey, Leics, mercer 87 cp40_1092.txt CP40/1092       2026-01-16
1975862 15 15 f   2760 Lincs trespass: close Alger, Richard Prykfeld, Edward, of Algerkyrke, gent; Wyborn, Henry, of Sutterton, weaver 88 cp40_1092.txt CP40/1092       2026-01-16
1975863 15 15 d   3820 Norf debt Alisander, Thomas Knyght alias Kett, Thomas, of Wyndham, butcher 89 cp40_1092.txt CP40/1092       2026-01-16
1975864 15 15 d   3353 Devon debt execution Allerton, Christopher Gylbert, Geoffrey, of Bovy Tracy, gent; Joan his wife 90 cp40_1092.txt CP40/1092       2026-01-16
1975865 15 15 f   1737 Lincs debt Allynson, William Kyme, Robert, of Wygtoft, yeoman 91 cp40_1092.txt CP40/1092       2026-01-16
1975866 15 15 f   2048 Norf debt Alpe, Thomas Mundy, John, of Duneham, husbandman; Towley, Henry, of Fraunseham Magna, yeoman; Fytlyng, Edward, of Hyngham Market, butcher; Hyanson, Thomas, of Pykenham, Wade, clerk 92 cp40_1092.txt CP40/1092       2026-01-16
1975867 15 15 f   2742 Wilts trespass: close Alrigge, William Tanner, Thomas, of Westbury, yeoman 93 cp40_1092.txt CP40/1092       2026-01-16
1975868 15 15 d   3069 Staffs debt Alton, Thomas, prior of Ronton Monastery Jones, Roger, of Cowley, yeoman 94 cp40_1092.txt CP40/1092       2026-01-16
1975869 15 15 f   1988 London debt Alye, John Coventre, Denis, of Claymaldon, Surrey, clerk 95 cp40_1092.txt CP40/1092       2026-01-16
1975870 15 15 f   1962 London debt Alye, John Goodman, Roger, of Tunbrygge, Kent, yeoman 96 cp40_1092.txt CP40/1092       2026-01-16
1975871 15 15 f   2908 London debt Amadas, Robert, of London, goldsmith, administrator of; (Nevile, Thomas, knight) Strelley, James, of London, vintner; Manwood, Richard, of Ipswich, mercer; Saxye, Robert, of London, merchant tailor 97 cp40_1092.txt CP40/1092       2026-01-16
1975872 15 15 f   2780 London debt Amadas, Robert, of London, goldsmith, administrator of; (Nevile, Thomas, knight) Talbot, Francis, of Wyngfeld, Derbs, knight; Cotton, Roger, of London, gent 98 cp40_1092.txt CP40/1092       2026-01-16
1975873 15 15 f   2146 London debt Amadas, Robert, of London, goldsmith, administrator of; (Nevile, Thomas, knight) Talbott, Francis, of Wyngfeld, Derbs, knight, Lord Talbott; Cotton, Roger, of London, gent 99 cp40_1092.txt CP40/1092       2026-01-16
1975874 15 15 f   1704 Herts debt Amber, John Noddys, John, of Sabbysford, miller 100 cp40_1092.txt CP40/1092       2026-01-16

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE cases (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    roll_id INTEGER NOT NULL REFERENCES rolls(id) ON DELETE CASCADE,
    side TEXT,
    roll_number TEXT,
    image TEXT,
    county TEXT,
    case_type TEXT,
    plaintiff TEXT,
    defendant TEXT,
    source_row INTEGER, source_file TEXT, roll_label TEXT, term TEXT, year INTEGER, monarch TEXT, source_downloaded_at TEXT,
    UNIQUE(roll_id, source_row)
);
CREATE INDEX idx_cases_roll_id ON cases(roll_id);
CREATE INDEX idx_cases_plaintiff ON cases(plaintiff);
CREATE INDEX idx_cases_defendant ON cases(defendant);
CREATE INDEX idx_cases_county ON cases(county);
CREATE INDEX idx_cases_year ON cases(year);
CREATE INDEX idx_cases_source_file ON cases(source_file);