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,844 rows where roll_id = 67

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: roll_number, 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
2232627 67 67   f 852   replevin [ membrane torn ] Brook, Henry 1 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232628 67 67   d 1375 vacat trespass: close, taking animals [ plaintiff erased ], Richard Toche, Adam, tanner; Gace, William 2 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232629 67 67   f 377 Devon(?) detinue (charter) [ plaintiff name obscured ] Clerk, Robert, of Bradeworthy 3 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232630 67 67   f 377   debt [ plaintiff name obscured ] fitz Waryn, Almaric 4 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232631 67 67   d 1228 Yorks debt [ plaintiff obscured by crease ], knight(?) Malton, Robert; Henryson, Thomas; _(?), Thomas, of Wakefeld 5 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232632 67 67   d 1248   debt [ plaintiff obscured by tear ] Belman, Richard, of Swyneshevede 6 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232633 67 67   d 1248   debt [ plaintiff obscured by tear ] Sergeaunt, William, of Wykenby; Thornton, Edmund de 7 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232634 67 67   f 102 Leics debt [ unnamed person ] , executor of; (Horneby, Thomas, of Leicester) Langham, John, of Kilby 8 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232635 67 67   f 563 vacat trespass: rescue [ vacated ] Maydewell, Peter, clerk; Wrydlyngton, Nicholas, the parish priest, of 9 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232636 67 67   f 838   debt _(?) Page, John, of Hadlegh; atte More, William, clerk; _(?), Nicholas; Draper, Richard, of Ipswich; Colman, John 10 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232637 67 67   d 1013 vacat dower _(?), Augustine; Maud, formerly wife of Simon Manser Grey, John, of Bakton; Bouse, Robert, of Bakton; Spark, Robert, of Bakton; Merable, John, of Bakton 11 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232638 67 67   d 895   debt _(?), collegiate of Astele, Warwickshire Che_(?), Henry 12 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232639 67 67   d 1747 Kent(?) covenant _(?), John Tannere, William, of Canterbury; Joan, his wife 13 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232640 67 67   f 833   trespass: close, felling & taking trees, assault of men _(?), knight Talbot, Henry 14 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232641 67 67   d 1248   debt _(?), of Fillyngham Parynot, William, of Fillyngham 15 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232642 67 67   f 837   debt _(?), of London, tailor Darundell, Richard, knight 16 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232643 67 67   f 842   debt _(?), of London, tailor or Weston, John(?) Rodyngton, Robert, living with Henry, prince(?); Bracy, Guy, of Buckinghamshire, esq 17 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232644 67 67   f 426 Norfk(?) Statute of Laborers _(?), Richard(?) Nicoll, Robert 18 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232645 67 67   d 870   [ plea type obscured ] _(?), sen, of the parish of Newenden(?) Duk, Henry, of _enynden or Benenden(?) 19 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232646 67 67   f 6   [ torn ] _(?), Thomas   20 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232647 67 67   f 850   debt _aney(?), of London, grocer; Middelton, William, of London, grocer Pecok, Thomas, of Canterbury, bow maker; Messanger, _(?), of Newbery, Berks 21 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232648 67 67   d 1752   debt _erne(?) Amfry, Michael 22 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232649 67 67   d 1248   debt _keworth, of Benyngworth Gybson, John, of Stepyng 23 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232650 67 67   d 869   trespass _onge(?), of Sybbedon Longeford, John 24 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232651 67 67   f 850   debt _sley(?) Wollaston, William, fishmonger; del Chaumbre, Christopher; Bukley, Nicholas, clerk; Stretton, Robert; Vance, Robert; Bodesham, Henry 25 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232652 67 67   d 1001 Oxon trespass: free warren, hunting & taking Abberbury, John, clerk Cook, Henry; togther with Fermore, John, of Nethercote; John, his son 26 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232653 67 67   f 352 Oxon debt Abberbury, John, of Doclynton, parson Colde Norton, William, prior of 27 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232654 67 67   f 483 Oxon debt Abberbury, John, of Walton Sclatter, John, of Dadyngton 28 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232655 67 67   f 198 Devon debt Abbeston, John Boterworth, Thomas; Damarll, Roger, clerk; Manerey, John 29 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232656 67 67   f 499 Lincs debt Abbot, John, of Hatteclyf Oudeby, Thomas, of Staynwath. Hewet, Richard, of Saxby; Smyth, Richard, of Fresthorp, parson; Jamesson, John, of Rasen 30 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232657 67 67   f 780 London debt Abbot, John, of London, mercer Bernewell, Thomas, of Warwick, chapman; atte Hall, Roger, of Lancaashire; Walter, John; Sauston, John 31 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232658 67 67   f 780 London debt Abbot, John, of London, mercer Fresyngfeld, Roger, of Yarmouth; Draper, Henry; Lechemere, Reginald 32 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232659 67 67   f 780 London debt Abbot, John, of London, mercer Warde, John, of Alcetur, Warws; Dyson, John; Dyson, William, of Ynckebarowe, Worcs; Doune alias Dounyng, John, of Catewade, Suff 33 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232660 67 67   f 780 London debt Abbot, John, of London, mercer; Trumpyngton, William, of London, mercer Boteler, Geoffrey, of Chesthunt, esq; Warde, Thomas, esq 34 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232661 67 67   f 658 Soms trespass: close, felling & taking trees & brushwood Abbotesbury, abbot of Yonge, Nicholas, of Ludelynch, son of Richard 35 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232662 67 67   d 1300 Dorset trespass: close & taking Abbotesbury, Gilbert Bole, Walter, clerk 36 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232663 67 67   d 997 York debt Abell, Maud Gournolde, William; Joan, his wife; Tyler, Joan; Keswyk, Alice 37 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232664 67 67   f 96 Norfk debt Abnale, Thomas, of Bishop's Lenn Robyn, John 38 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232665 67 67   f 96 Norfk detinue (charter) Abnale, Thomas, of Bishop's Lenn Wryghte, Thomas, chaplain; Hanyngton, John, chaplain 39 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232666 67 67   d 1679 Norfk debt Abnale, Thomas, of Lenn, burgess Lathe, Robert, of Wysbeche; Halle, Peter, of Bishop's Lenn, mariner; Paxman, Geoffrey 40 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232667 67 67   d 1495 Bucks debt Abraham, John Hyll, Thomas, tailor 41 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232668 67 67   d 1482 Lincs trespass: assault, taking & imparking a horse, without reasonable cause Abraham, Roger, of Sutton atte Asshe, John, of Speldyng, shoemaker 42 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232669 67 67   f 52 Beds trespass: close & taking Abraham, Thomas, of Bromeham Pertenale, John, of Bromeham; John, his son 43 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232670 67 67   d 1378 Herefs trespass: close, felling & taking trees & brushwood Aburhale, John ap David ap Yorwarth, John 44 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232671 67 67   f 5 Berks trespass Abyndon, abbot of Chambre, Henry 45 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232672 67 67   d 1151 Berks debt Abyndon, abbot of Henley, John, of Langeworthe, parson 46 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232673 67 67   d 1073 Middx debt Abyndon, Giles Monk, John, of Rokehey, Kent, tanner; Barker, Robert, of Sundrysshe 47 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232674 67 67   f 114 Derbs Statute of Laborers Achard, William, sen, of Steyns_(?) Taillour, John, of Querndon; _(?), John 48 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232675 67 67   f 211 Middx debt Acres, Thomas, of London, draper Fleccher, Walter, of Buckinghamshire 49 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232676 67 67   d 1694 Nthumb trespass: close, felling & taking trees & brushwood Acton, Lawrence Jonesson, Adam, of Atton 50 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232677 67 67   d 1260 Dorset trespass: taking horse Adam, John Tilfot, Richard, of Canne 51 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232678 67 67   d 883 Herts debt Adam, John, esq Burton, Edward, of Wynge, Bucks 52 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232679 67 67   f 452 Kent debt Adam, Thomas Colpepir, Thomas, of Canterbury; Grete, Thomas; Eleanor, his wife 53 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232680 67 67   f 846 Kent debt Adam, Thomas, son of Stephen Yonggh, John, of Eldyngg 54 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232681 67 67   d 1242 Herts Statute of Laborers Adam, Walter, of Royston, prior Ely, Walter, formerly servant of the prior 55 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232682 67 67   f 191 Herts Statute of Laborers Adam, Walter, prior of Royston Ely, Walter, formerly servant to the prior of Royston 56 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232683 67 67   d 1358 Yorks debt Addewyk, John de, of Fryston, vicar Squyer, Robert, of Lunde(?) 57 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232684 67 67   d 988 Cambs trespass: taking horses Adekyn, William Joseph, Henry 58 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232685 67 67   f 657 Soms debt Adekyns, William, of Cherde Langbrokes, William, clerk 59 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232686 67 67   d 1215 London debt Adkyn, John; Langeman, John Balyngon, John 60 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232687 67 67   d 1487 London debt Adkyn, John; Langeman, John Balyngon, John 61 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232688 67 67   d 1518 London debt Adkyn, John; Langeman, John Balyngon, John 62 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232689 67 67   d 1619 Derbs debt Admet, Robert, of Assheby de la Zouche Page, William, of Assheburn; Nicolas, John, of Stanley 63 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232690 67 67   f 797 Warws debt Adumston, William, clerk Smert, Joan, formerly wife of Roger; Baker, Richard, of Kylyngworth 64 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232691 67 67   f 536 Devon trespass: close, assault & taking Agelond, John Everard, John, of Sanford Peverell; Metton, William; atte Combe, John, of Lomone; Everard, Thomas, of Holcombe 65 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232692 67 67   f 539 Soms debt Ailcrych, John, of Taunton Cory, John, of Taunton, smith 66 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232693 67 67   d 960 Hants debt Aileward, Richard, of Boston, merchant; Aileward, Thomas, clerk Raketon, Roger, of Chichester, burgess, executors of; (Sherter, Richard; Raketon, Julia, formerly wife of Roger) 67 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232694 67 67   f 446 Essex debt Aillewy, William Walton, John, of Berghholte; Rikelage, John, of Berghholte; Skynnere, John, of Manytre; Benortham, William, shipman; Sherewent, John, of Berghholte; Sherewent, William 68 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232695 67 67   d 1346 London debt Ailmer, Richard, of London, mercer Jelyan, John, tailor; Rys, Philip, of Wantynge; Bailly, John, of Andover 69 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232696 67 67   f 585 Suffk debt Aisshfeld, Robert de, esq, executors of; (Ixworth, Walter, master; Berton, John, of Dounham, parson; Blyaunt, Simon) Mascal, William, of Hyntelysham; Fystenene, Reginald, of Flocketon; atte Hel, John, of Hentolysham; Giffard, Thomas, of Brustall; Bocher, Nicholas, of Haldham 70 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232697 67 67   f 650 Derbs debt Alastre, John Kylyngton, Robert; Sutbery, Thomas 71 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232698 67 67   d 1062 Notts debt Alastre, John Kytson, John, sen, of Nottingham; Kytson, John, jun; Shipley, Robert; Betheway, John; Dykun, John 72 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232699 67 67   d 1718 London debt Albertis, Philip de, of the Society of Alberti of Florence, merchant; Maruns(?), Franciscus, of the same society Charleton, Edward, lord of Powys, knight 73 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232700 67 67   f 717 Worcs debt Alcestre, John, of Wircestre or Worcester Bailly, John, of Alvechirche; Dyer, Nicholas, of Evesham; Dyer, Robert, of Pershore; Marsshall, Thomas, of Haddesover; Gonell, Thomas, of Wyche; Clent, William, of Wyche; Kyd, William, of Tendebury; Hayley, William, of Brommesgrove; Malton, William; Botrell, William; Stacy, Robert, dyer; Careles, Nicholas of Worcester; Parcheford, John; Mason, Benedict, of Worcester; Merston, John; Paytfen, Lawrence; Latynhorn, John; Walcotes, Richard; Ruggeley, Hugh; Crokebarowe, John 74 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232701 67 67   d 1672 Beds debt Alcok, John, clerk Daye, Robert; Joan, his daughter; Smyth, John, of Bolnhurst; Clerk, John, butcher 75 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232702 67 67   d 1054 London debt Alcok, John, of London, grocer Mere, John 76 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232703 67 67   d 1700 Bucks account as receiver Alcok, Thomas Belasise, John, of Newport Pagnell, mercer 77 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232704 67 67   f 131 Oxon trespass: close & taking Alcrynton, Robert Wrench, Walter, of Shorthampton; Carter, Thomas, of Shepton 78 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232705 67 67   f 334 Norwich debt Alderford, Edmund, clerk; Martyn, Thomas, of Norwich dorkyn, William, of Westwyk, parson; Cok, Richard, of Westwyke 79 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232706 67 67   f 35 Norwich debt Alderford, John, of Norwich; Workeby, Henry, of Lincoln, bow maker Ancastre, Thomas, of Worcester, bow maker; Osaunt, John, of Norwich 80 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232707 67 67   d 1645 Norwich debt Alderford, John; Donne, John, of London Wetherby, Walter, of Norwich, dyer 81 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232708 67 67   d 1314 Yorks debt Aldewyk, John, of Kyngeston upon Hull Litster, John, of Malton 82 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232709 67 67   d 1312 Yorks debt Aldewyk, John, of Kyngeston upon Hull Wadman, William, of Witlingate, in the city of York 83 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232710 67 67   d 1057 Suffk debt Aldewyk, Robert; Gedeford, John; Hotty, Thomas, clerk Bondener, John; Arnold, John; Godwene, William, of Kersey 84 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232711 67 67   f 289 Yorks debt Aldewyk, Thomas, of Kyngeston upon Hull, executor of; (Aldewyk, John, of Kyngeston upon Hull) Beset, John, of Malton 85 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232712 67 67   d 1188 Suffk   Aldewykele, Robert, of Ratlesden Bakere, William, of Hadeleye Selers; Canon, Richard, of Buxhale, wright; together with Edward, Robert, of Wolpet; Makel, Adam, of Preston; Cranele, William, of Hadeleye 86 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232713 67 67   f 387 Norfk debt Aldous, William, of Walyngton, executors of; ( _(?); Joan, his wife) Soutere, _(?), executrix of; (Soutere, Margaret) 87 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232714 67 67   f 404 Kent debt Aldulf, John Bouryng, Robert, of Hadlo; Brodet, Richard, of Hadlo 88 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232715 67 67   f 26 Kent trespass Aldulf, John Tebaud, Thomas, of Sele 89 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232716 67 67   f 415 Essex debt Alewyn, Thomas Altheworld, Walter, of Wodeyestre; Lakford, Geoffrey, of Felstede; Fodryngey, William, chaplain 90 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232717 67 67   f 17 Leics detinue (box of muniments) Alexton, William, of Shepeshed, vicar Clerk, William, of Hathersegge, clerk 91 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232718 67 67   f 746 Norfk debt Aleyn, Charles, of Colkirke, parson Fraunceys, William, of Bishop's Lenn; Lexham, Thomas, of Hempton 92 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232719 67 67   f 622 London detinue (documents) Aleyn, Geoffrey Tannere, John, of London, scrivenor 93 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232720 67 67   f 656 Dorset debt Aleyn, John Fouler, Robert, executors of; (Webbere, Edmund; Alice, his wife) 94 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232721 67 67   d 1128 Leics wardship in socage Aleyn, John; Joan, his wife Malory, John 95 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232722 67 67   d 1252 Kent trespass: threats, taking goods Aleyn, Katherine Hereford, Robert; together with Herewerthyng, John 96 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232723 67 67   d 1502 Devon trespass: taking animals Aleyn, Robert Gambon, John, sen, of Badecoway; Thomas, his son; Webber, Thomas; Ponste, John; Coham, Simon; Kitehele, William; Cruwys, John; Gorkele, Henry; Toly, John 97 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232724 67 67   d 1546 Warws wardship in socage Aleyn, Robert; Joan, his wife Malory, John, of Welton 98 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232725 67 67   f 366 Sussex debt Aleyn, Stephen Nowell, John, of Hampshire; Hamond, Walter, of Southampton 99 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13
2232726 67 67   d 1212 Cambs debt Aleyn, William, of Bokesworth Langham, John; Braban, Ralph; Moigne, John, of Dokesworthe; Bayforth, Richard; Mayner, Richard, of Over 100 cp40_605_AJ.txt CP40/605 Easter 1412   2026-01-13

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