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

3,617 rows where roll_id = 55

✎ 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
2170715 55 55 d   8625   [ Black Death adjournment ] [ Edward III ]   1 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170716 55 55 d   8327 Westmd waste abbot of St Mary's Burton, Roger de, of Kendale, knight; Maneser, John de, of Wode Walton, parson; Brysthwayt, Henry de, chaplain 2 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170717 55 55 d   8409 Leics debt Abburbury, prior of Donynton, Richard de, executors of; (Donynton, Alice de; William, her son; Houby, John de; Leicester, abbot of St Mary de Pratis, in; Jeryn, William, another monk in the same abbey) 3 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170718 55 55 f   8077 Oxon maintenance(?) Abel, Thomas Abyndon, Julia de, formerly wife of Stephen; Hoton, Adam de, master; Castel, Henry, master 4 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170719 55 55 d   8328 Oxon attaint Abel, Thomas Abyndon, Julia, formerly wife of Stephen; Pirye, Michael, de, spicer; Levertone, William de, master, of Oxon, priest in the house of the BM; Hamme, Thomas; Malmerbury, Henry de; Deyghere, Walter le; Maud, his wife; Russel, John; Lucy, his wife 5 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170720 55 55 f   8187 Berks land Abyndon, Abbot of Hakebourn, Richard de, of Abyndon 6 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170721 55 55 f   7955 Middx trespass: taking Abyngdon, Abbot de Borle, Geoffrey de, of Kensyngton, vicar; Geffrey, William, of Borley, priest; Jaket, John; Cartare, John; Bussheye, Thomas, of London, tapestry maker; Vykerestok(?), Gilbert le; Godynch, Thomas le; William servant of Geffrey 7 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170722 55 55 f   8220 Yorks land Acastre, John de; Isolda, his wife Studeleye, John de; Margaret, his wife; Fisshere, Simon le; Eleanor, his wife 8 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170723 55 55 d   8619 Yorks trespass: close & taking Acastre, William de, of York Angron, Clement de; John, son of Clement; Peter, son of Clement; Spynk, Adam; Trovet, Walter; Carter, William; Coke, John 9 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170724 55 55 f   8223 Lincs Statute Merchant Acastre, William de, of York Neville, Robert, of Horneby, Lancs, knight 10 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170725 55 55 d   8485 Leics land Ace, John Somenour, John le, of Barewe, son of John 11 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170726 55 55 d   8525 Nthumb waste Acton, Maud de, of Newcastle upon Tyne, formerly wife of Richard Conners, Isolda, of Newcastle upon Tyne 12 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170727 55 55 f   8154 Nthumb account as bailiff Acton, Maud de, of Newcastle upon Tyne, formerly wife of Richard Frankeleyn, John 13 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170728 55 55 f   7898 Gloucs land Acton, William de, son of William, son of Stephen Acton, Roger de, son of Ralph 14 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170729 55 55 f   8012 Norfk trespass: close & assault of servant Adam, son of William Richard, son of Bartholomew 15 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170730 55 55 f   7989 Sussex trespass: assault & taking Addele, Hugh de Smyth, John le; Erth(?), Philip, son of William; Erth(?), William, son of William; Eston, Richard de; Lyghtere, Richard le; Odyk(?), John; Erch, John, son of William 16 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170731 55 55 d   8247   (?) Afferton(?), Thomas de Cela(?), William, of Huntcote(?); another(?) 17 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170732 55 55 d   8367 Devon account as receiver Affeton, Richard de Affeton, Thomas de 18 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170733 55 55 d   8538 Derbs account as receiver Ainret(?), John, of Suttebury Broun, John, of Lollyngton 19 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170734 55 55 d   8497 Cumb debt Akehevede, William de, of Wrikyngton or Workington(?), parson Waleys del Laches, William 20 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170735 55 55 d   8589 Bucks acquittance of service Akeny, Roger de, knight Grusset, Richard, of Lavendene 21 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170736 55 55 d   8296 Herefs replevin Albon, John, son of Luke Gibbes, William 22 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170737 55 55 d   8585 Norfk account as receiver Alby, Adam, parson of atte Parke, Robert, of Metton 23 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170738 55 55 d   8418 Yorks ael Alde Ravenser, John de, son of John, son of John Hoton, William de, son of Hugh 24 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170739 55 55 d   8273 Cambs debt Aldeburgh, Clement de, of Norwich, merchant; Bacheler, William, of Norwich, merchant Bassyngburn, John de 25 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170740 55 55 f   7905 Warws trespass: assault Aldulvestre, William de, son of Thomas Elyot, John; Richard, his own; John, brother of Richard; Nicholas, brother of Richard; together with Grene(?), John, chaplain 26 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170741 55 55 d   8321 Kent account as receiver Aledon, Thomas de, knight Beltelem, Robert 27 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170742 55 55 f   8192 Suffk land Algod, Richard atte Bregge, Robert, of Codenham, son of John 28 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170743 55 55 f   8198 Norfk land Algor, John, chaplain Brampton, Nicholas de; Margaret, his wife 29 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170744 55 55 f   8199 Norfk land Algor, John, chaplain Brampton, Nicholas de; Margaret, his wife 30 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170745 55 55 f   8135 Leics dower Alice, wife of John de Sadyngton Whitewell, John de, who vouched Whitewell, Richard de 31 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170746 55 55 d   8546 Norfk covenant Alisaundre, William senior; Margaret, his wife Howard, Thomas, of Wygenhale, son of William; Margaret, his wife; Howard, John, of Wygenhale, son of William; Isabel, his wife 32 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170747 55 55 d   8457 Yorks account as receiver Allerstane alias Alvestane, William de Hall, William de le, of Great Driffeld, son of Robert 33 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170748 55 55 d   8456 Yorks account as receiver Allerton, Denise de, of York, formerly wife of Thomas Eseby, Ellis de, of Rypon, physician 34 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170749 55 55 f   7966 Bucks trespass: taking Allesle, Henry de Chaunceux, Roger, of Asshen, parson; Bray, Emma, of Bechehampton; Horwod, Hugh, of Bechehampton 35 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170750 55 55 d   8419 Herefs land Alleton, William, de Baskervill, Walter de, kinsman & heir of Roger, whom Richard Holles, chaplain, warrants 36 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170751 55 55 f   8086 Lincs trespass: assault Almot, John, of Lesyngham Folkyngham, Ellis de, of New Lafford; Folkyngham, William de, of New Lafford; Warde, Robert, of New Lafford 37 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170752 55 55 f   7930 Staffs wardship Alrewas, John de Marnham, Thomas de; Fremon, John le, of Barre; Isabel, his wife; Etton(?), John de; Cursoun, Thomas le, knight; Thorleye, Simon de 38 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170753 55 55 f   7922 Sussex debt Alta Ripa, Celia de Chaumbleyn, William le, of Hethshete, executors of; (Baillyff, Thomas le, of Midhurst, son of Richard; Chaumbleyn, Joan le, of Hethshete, formerly wife of William) 39 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170754 55 55 d   8372 Kent trespass: close & taking Altremer, William Shymmyng, Nicholas; Strode, John de, senior, of Hierne; Chelde, Thomas; Fauconer, Peter 40 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170755 55 55 d   8585 Norfk account as receiver Alvard, John Cobbe, Thomas; Bretoun, John; Beek, Robert de la; Cosplawe, Robert de 41 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170756 55 55 f   7952 Yorks debt Alverthorp, Hamo de, of Sutton in Galtres, vicar Gra, Thomas, of York, merchant, son of John; Ruston, John de, York, merchant 42 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170757 55 55 f   8175 Lincs account as receiver Alwaldby, John de, son of William Scragan, Geoffrey 43 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170758 55 55 d   8308 Yorks debt Alwarthorp, Hamo de, of Sutton in Galtres, vicar Lyndessay, Thomas de, son of Robert; Lyndessay, Robert de 44 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170759 55 55 f   7987 Lincs account as bailiff Amcotes, Richard de, of Stalby, parson Kirkeby, Richard de 45 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170760 55 55 d   8516 Lincs account as bailiff Amcotes, Thomas de, executors of; (Amcotes, Maud de, formerly wife of Thomas; John, son of Maud) Mumby, Robert de 46 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170761 55 55 f   7979 Yorks account as bailiff Ampelford, John de, clerk Fluyreld, William, of Thormondby 47 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170762 55 55 d   8476 Staffs wardship Andeleye, James de Ardene, John de 48 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170763 55 55 f   8134 Norfk trespass: assault & taking Andreu, Celia, of Beston Abbis, James, of Beston; Alice, his wife; John, son of the same James; Clement, John, of Runton 49 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170764 55 55 d   8320 Sussex account as receiver Andreu, Stephen, of Wynchelse, son of Edmund Bernette, John, of Iwehurst or Ewhurst(?) 50 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170765 55 55 d   8383 Shrops account as receiver Andrewe, Robert, of Nottingham, merchant Symleye, Thomas, of Shrewsbury, merchant 51 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170766 55 55 d   8590 Surrey account as receiver Apdele, Roger de, of Ledrede or Leatherhead atte Legh, John, of Hodlegh or Headley(?) 52 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170767 55 55 d   8590 Surrey debt Apdele, Roger de, of Ledrede or Leatherhead Kene, Richard, of Ledrede, baker, son & heir of William; Longe, Henry le, of Ledrede; Norreys, Peter, of Fetcham 53 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170768 55 55 d   8389 Surrey debt Aperdele, Robert de Hore, Walter le, of Leatherhead 54 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170769 55 55 f   8107 Soms debt Aperdele, Roger de Leddrede, John de 55 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170770 55 55 f   7989 Surrey debt Aperdele, Roger de, son of Adam Reigate, John, prior of Holy Cross church, in 56 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170771 55 55 d   8537 Notts trespapss: taking cows Appelby, Hugh de, clerk Brunham, John de, chaplain; Broun, Thomas, of Alkeley; Hyve, Roger, of Fynyngley 57 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170772 55 55 d   8555 Yorks debt Appelby, John de, of York, executors of ; (Appelby, William de, clerk; Skail, John, chaplain) Aton, Gilbert de, knight, kinsman & heir of John de Vescy 58 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170773 55 55 f   8127 London debt recognisance Appelby, Nicholas de, of York Mountegu, John; Margaret, his wife, daughter & heiress of Thomas de Mounte Hermery, knight 59 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170774 55 55 d   8524 Kent(?) account as bailiff Apuldrefeld, William de Smart, William, of Mereworthe 60 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170775 55 55 d   8592 Suffk detinue (charter) Archer, John le, of Kettelbere, parson Child, Gilbert le, of Debenham 61 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170776 55 55 f   8128 Berks account as receiver Arnyat, William, of Wallingford Carpenter, Richard le, of Wallingford; Gant, Robert, of Whitechurche; Gant, Thomas, of Whitechurche 62 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170777 55 55 f   8015 Shrops debt Arundell, Richard, earl of Geffrey, Thomas, executors of; (Geffrey, Alice, formerly wife of Walter; Geffrey, John; Ive, Thomas) 63 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170778 55 55 d   8401 Norfk land Arundell, Richard, earl of Lancaster, Herny, Earl of 64 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170779 55 55 d   8570 Sussex covenant Arundell, Richard, earl of Viem_(?), John de, son of Lucy 65 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170780 55 55 d   8507 Sussex covenant Arundell, Richard, earl of Vyenna, John, son of Lucy(?) 66 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170781 55 55 d   8516 Yorks account as receiver Askeham, Thomas de, of York Lincoln, Ralph de, of Brymesby 67 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170782 55 55 f   7924 Notts account as receiver Askham, John de Selston, John de, son of William 68 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170783 55 55 d   8318 Yorks debt Askham, Thomas de, of York, merchant, executors of; (Askham, Richard de, of York, son of Thomas; Berlot, Adam) Babthorp, Ralph de, son & heir of Robert 69 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170784 55 55 d   8578 Lincs land Aslacby, William de, son of Robert; Albreda, his wife Alice, daughter of Raulyn, the son of the priest(?) 70 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170785 55 55 d   8464 Notts land Aslacton, Hugh de, son of Richard, son of Agnes Smyth, Felicity le, of Aslacton, daughter of William 71 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170786 55 55 f   7888 Notts acquittance of service Aslacton, John de, son of Reginald de Aslacton, knight, senior Aslacton, Simon de, son of Reginald de Aslacton, knight 72 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170787 55 55 f   7860 Notts trespass Aslacton, Roger de Carleton, Robert de, son of Geoffrey; Walye, John, of Carleton; Clombre, Robert de, of Carleton, son of William; Hope, Robert de, of Carleton 73 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170788 55 55 d   8501 Suffk wardship Aspale, John de, knight Canston, Henry de; Margaret, his wife 74 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170789 55 55 f   8103 Derbs account as receiver Asshburn, Robert de; Emyngton, Roger de Spayne, Thomas de; Milton, Ralph de; Parfeye, Richard; Rosel, Thomas; Butteley, Henry de; Drayton; Bacon, John; Rauf-servant, Ralph; Henry-servant, Gilbert; Parfey, Thomas; Granger, Nicholas le, of Doffeld(?) 75 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170790 55 55 d   8346 Lincs account Assheballok, John, of Newerk Hawys, John, of Newerk 76 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170791 55 55 d   8367 Derbs trespass: close Assheburne, Robert Pache, John, of Aldewerk; Reve, Henry le; Brassyngton, John de, of Aldewerk; Mydelton, Margery de, formerly wife of John; Maydon, John le; Maydon, William the, of Aldewerk; Emma, servant of William of Bircheovere 77 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170792 55 55 f   8062 Yorks formedon descender Asshebury, Thomas de; Margery, his wife Clarell, Robert 78 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170793 55 55 f   7983 Nhants debt Assheby, John de, of Cotyngham, parson, executor of; (Haronden, John de, of Cotyngham, parson) Sord, Richard le, of Wylbeston 79 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170794 55 55 d   8351 Lancs trespass Asshehurst, Adam de, knight Barowe, Richard de, of Lathum, parker; Swane, Ellis; Cappe, Elia; Gardmere, Robert le; Scot, Donald; Pety, Adam; Mereiugh(?), John de; Latham, Adam de, son of Stephen 80 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170795 55 55 d   8616 Norfk account as receiver Asshele, Robert de, clerk Catton, William de, of Norwich, skinner; Fayrman, William, of Beston 81 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170796 55 55 d   8257 Staffs account as bailiff Assheleye, John, parson of the church, in Tyleman, John, chaplain 82 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170797 55 55 f   8163 Norfk dower Asteley, Margery de, of Hulle Morton, formerly wife of Thomas Asteley, Robert de, knight; Agnes, his wife 83 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170798 55 55 d   8391 Warws account as receiver Asteleye, Alice de, formerly wife of Giles Stoke, John de 84 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170799 55 55 d   8386 Yorks Statute Merchant Asthull, Richard de, of York Cram, John of Aldewerk 85 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170800 55 55 f   8004 Derbs covenant Aston, John de; Maud, his wife Bele, John, chaplain 86 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170801 55 55 f   7863 Berks account as receiver Aston, prior of Lusteshull, Richard de, merchant 87 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170802 55 55 f   8082 Shrops covenant Aston, Richard de, of Langeton, parson Lutteleye, Philip de; Katherine, his wife 88 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170803 55 55 d   8370 Staffs account as receiver Aston, Richard de, of Lichfeld, clerk Blount, John le, son of John 89 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170804 55 55 f   8035 Gloucs formedon descender Aston, Robert de Aston, Margery, formerly wife of Richard de Aston 90 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170805 55 55 d   8546 Cambs covenant Aston, Thomas, of East Hattele, parson; Cundy, Robert, of Long Stanton, chaplain Martyn, John, of Pampesworth; Alice, his wife 91 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170806 55 55 f   8159 Leics acquttance Aston, William de Houby, Walter de, knight 92 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170807 55 55 f   8058 Yorks replevin Astyn, William, of Penyesthorp; Penyesthorp, William de, son of Elizabeth; Thorp, John de, son of Walter Thorp, Stephen de, son of _(?) 93 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170808 55 55 f   8034 Worcs trespass: taking cows Athelard, Agnes, of Bentleye Pauncefot Worcester, John, prior of the church of the BM, in; Clifton, Robert de, another monk, in the same priory; Aboveton, Walter; Gibben, William 94 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170809 55 55 f   8081 Norfk covenant Athelwald, James, of Suthcreyk, son of Edmund Athelwald, Thomas, of Suthcreyk, son of James; Weston, Robert, son of Thomas; Astel, John, of Suthcreyk; James, son of Hugh, chaplain 95 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170810 55 55 d   8597 Norfk Statute Merchant Athelwale, John, of South Creyk Monk, Michael, of Crowemere 96 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170811 55 55 f   7954 Lincs debt Atherby, John de, of Lincoln, draper Kyme, Philip de, of All Saints, Waynflet, parson 97 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170812 55 55 d   8491 Norfk trespass: assault atte Batherne, Thomas, of Ludham Wyot, Roger, son of Robert 98 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170813 55 55 f   7872 Wilts account as receiver atte Borgh, Walter Gerberd, Robert, of Oddestok 99 cp40_358.txt CP40/358 Easter 1349   2026-01-12
2170814 55 55 f   7872 Wilts account as receiver atte Borgh, Walter Terstwode, John; Gilbert, his brother 100 cp40_358.txt CP40/358 Easter 1349   2026-01-12

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