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

1,801 rows where roll_id = 54

✎ 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
2168914 54 54 f   7402   debt _(?) _(?) 2 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168915 54 54 f   7402 Suffk(?) debt(?) _(?), Elizabeth Robert(?) 3 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168916 54 54 f   7559 Herefs   _(?), executors of; (Barre, Isabel de la; Barre, Richard de la; Barre, Thomas de la; Barre, Edmund de la, son of Isabel) Herdeshope, John de 4 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168917 54 54 d   7759 Berks trespass: close, assault & taking Absolon, Alexander Iremonger, Richard le, of Walyngford; Taverner, Thomas le, son of Reginald 5 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168918 54 54 d   7625 Oxon(?) land(?) Abyndon, Julia de, formerly wife of Stephen Abel, Thomas 6 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168919 54 54 f   7433 Hants land Ace, William, son of William Derman, William; Edith, his wife; Pontetyn, John; Joan, his wife 7 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168920 54 54 d   7754 Sussex trespass: assault & taking Adderle, Hugh de Smyth, John le; Erch, Philip, son of William; Erch, William, son of William; Eston, Richard de; Lyghtere, Richard le; Lyghtere, Peter le; Odyk, John; Erch, John, son of William 8 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168921 54 54 d   7756 Berks account as receiver Adyngton, John de Bocher, Francis; atte More, William, butcher; Michel, Richard; White, John le 9 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168922 54 54 f   7520 London account as receiver Adyngton, Simon de, of London Bedeford, John, of Yarmouth 10 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168923 54 54 d   7798 Sussex covenant Alard, James Copper, Walter; Joan, his wife 11 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168924 54 54 d   7681 Gloucs trespass: close & taking Alcestre, Philip de, clerk Walteres, Robert, of Iccomb, clerk 12 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168925 54 54 f   7605 Warws trespass: assault Aldulvestre, Thomas de, son of Thomas Elyot, John; Richard, his son; John & Nicholas, brothers of the same Richard; together with Grene, John, chaplain 13 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168926 54 54 f   7552 Kent account as receiver Aledon, Thomas de, knight Peltebem, Robert 14 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168927 54 54 d   7752 Bucks trespass: taking Allesle, Henry de Chaunceux, Roger, of Asshen, parson; Bray, Emma, of Bechehampton; Horwod, Hugh de, of Bechehampton 15 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168928 54 54 d   7727 Lincs trespass: assault Almot(?), John, of Lesyngham Folkyngham, Ellis, of New Lafford; Folkyngham, William de, junior, of New Lafford; Greyby, John de, junior, of New Lafford; together with Warde, Robert, of New Lafford 16 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168929 54 54 d   7630 Yorks trespass: taking Alta Ripa, John de, son of Godefrey Everly, John de, son of Roger; Walter, brother of John; Turnlay, John de 17 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168930 54 54 f   7481 Berks account as receiver Alveton, John de Mawardyn, William 18 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168931 54 54 d   7761 Lincs trespass: close, taking & assault of men & servants Alvyngham, prior of Dalton, Nicholas de, son of Maud 19 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168932 54 54 f   7461 Devon Statute Merchant Alyam, David, master Lamborne, Richard; atte Forde, Walter; Move, John; Mareschal, Nicholas; Eggecombe, William; atte Pate, Simon 20 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168933 54 54 f   7547 Oxon account Ammory, Richard Crok, Geoffrey, of Brightwell 21 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168934 54 54 f   7563 Derbs Statute Merchant Amore(?), John, of Tuttebury atte Wode, John, of Aston in Rutland(?); Grene, William o' the, of Long Eyton(?) by Tove_(?) or Toton(?) 22 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168935 54 54 f   7536 Derbs account as receiver Amoret, John, of Tuttebury Broun, John, of Lullington 23 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168936 54 54 d   7822 Notts account as receiver Amyas, William de, of Nottingham Walton, Robert de, of Nottingham, son of Hugh 24 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168937 54 54 d   7690 Hants account as receiver Andevere, William de, merchant Farnham, Ellis de, merchant 25 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168938 54 54 f   7440 London account as receiver Andreu, James, of London, draper Squireret(?), Roger; Evenlee, Robert, of Buckingham 26 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168939 54 54 d   7703 Oxon trespass: taking sheep Andreu, William, of Langeford Eliot, Ralph, of Clanefeld; Richeman, John, of Clanefeld 27 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168940 54 54 d   7630 Lancs dower Anynsone, Alice, formerly wife of Adam Coke, Thomas le, son of Richard 28 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168941 54 54 d   7658 Suffk account as receiver Apelthweyt, Stephen de; Arnald, Robert; Cokkes, William le Berard, Edmund; Caproun, Robert 29 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168942 54 54 f   7485 Surrey debt Aperdele, Roger de, son of Adam Reygate, John, prior of Holy Cross church, in 30 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168943 54 54 d   7773 Sussex account as bailiff Apselond, Adam, of New Shorham Dyghere, Stephen le, of Midhurst 31 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168944 54 54 d   7705 Herts quid juris clamat Arnald, Margaret, of Swafeld, formerly wife of Roger; Arnald, Robert; Maud, his wife Mareschal, John le; Margaret, his wife; Margaret, daughter of the same Margaret 32 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168945 54 54 d   7775 Lincs trespass: taking Arnehewe, Thomas de, of Mumby Hoggesthorp, John de, son of William, son of Walter; William, brother of the same John; Smyth, Eudo, of Hoggesthorp; Hoggesthorp, Hugh de, son of Rannulf; Merwyn, Thomas, of Hoggesthorp; Sprotlyng, Robert, of Farlesthorp 33 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168946 54 54 f   7542 Shrops debt Arundell, Richard, earl of Geffrey, Thomas, executors of; (Geffrey, Alice, formerly wife of Walter; Geffrey, John; Ive, Thomas) 34 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168947 54 54 f   7451 Sussex trespass: free chase Arundell, Richard, earl of Waverley, John, abbot of; atte Brugg, Joseph, of Dudelyng; together with Shefyngton, Richard; Godard, Robert, of Bygenesse; atte Krype, Richard, of Cockyng; Stifney, John, of Cockyng; Water, Thomas, brother & co-monk with John, abbot of Waverley; Venur, John le, of Slyndon, park man; Drynkewater, Richard, of Slyndon; Balys, John, of Slyndon; Daubeney, John, of Bygenefre 35 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168948 54 54 d   7757 Notts account as receiver Askeby, John de Cok, John, of Spitelvate 36 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168949 54 54 d   7795 London account as receiver Assheby, John de, clerk Morbourn, John, of London 37 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168950 54 54 f   7546 Warws account as receiver Asteleye, Alice de, formerly wife of Giles Stoke, John de; Stoke, Hugh de, clerk; Hurleye, Thomas de, chaplain 38 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168951 54 54 f   7432 Dorset account as bailiff Asteleye, Thomas de, master Rede, John le, of Whitcherche 39 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168952 54 54 d   7647 Berks account as receiver Aston, prior of Lusteshull, Richard de, merchant 40 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168953 54 54 d   7696 Wilts account as receiver atte Bergh, Walter Meriet, John 41 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168954 54 54 f   7417 Gloucs Statute Merchant atte Borwe, Walter, of Wiltshire Ryvers, Richard de, of Wiltshire, merchant 42 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168955 54 54 f   7455 Surrey dower atte Brok, Christine, formerly wife of John Reygate, prior of 43 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168956 54 54 f   7524 Middx trespass: close, assault, & taking animals atte Brok, John, of Great Stanmere Calverton, John de, chaplain 44 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168957 54 54 d   7774 Sussex ejectment of wardship atte Brugg, Joseph Tortyngton, prior of; atte Wode, Richard; atte Wode, William; Icoumbe, Alice, formerly wife of Thomas 45 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168958 54 54 d   7784 Sussex wardship atte Chambre, Alice, formerly wife of John Russel, Robert; Goldyng, John, chaplain; Perchyng, Joan, formerly wife of John, guardians of John atte Chaumbre, son of John 46 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168959 54 54 f   7439 Wilts account as receiver atte Chaumbre, John, of Salisbury, canon in the cathedral; Hoggesnotton, William de Gerberd, Robert, merchant; Elees(?), John, merchant 47 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168960 54 54 f   7438 Wilts debt atte Chaumbre, John, of Salisbury, canon in the cathedral; Hoggesnotton, William de Gerberd, Robert, merchant; Elees, John, merchant 48 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168961 54 54 f   7455 Kent covenant atte Cherche, Thomas, of Berham Bakele, John le, of Barham, son of Simon 49 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168962 54 54 f   7420 Norfk account atte Chirche, John, of Berneye Beweyn, Henry 50 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168963 54 54 d   7697 Surrey dower atte Churt, Denise, formerly wife of William Taillour, Roger le, of Brokham, draper 51 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168964 54 54 f   7429 Warws trespass: close & taking atte Clyf, Ralph Lauweston, John, of Colleshull 52 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168965 54 54 f   7593 Herts dower atte Conduyt, Christine, formerly wife of Alan Holewell, Michael de, of Bishop's Hatfield, son of Nicholas 53 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168966 54 54 d   7703 Warws trespass: assault atte Corne, Robert, of Stratford upon Avon Frere, John, of Stratford upon Avon 54 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168967 54 54 f   7581 Leics trespass: close, taking atte Cros, John, of Melton Loudham, Roger de, of Ab Kettleby; Margaret, his wife; Loudham, William, son of Roger 55 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168968 54 54 d   7672 Devon account as receiver atte Crucche(?), Stephen(?), of Otterton atte Crucche, Michael, of Otterton 56 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168969 54 54 f   7448 Sussex land atte Dene, John, of Alfricheston Playtere, Mabel, formerly wife of William; Shirrynton, Julia de, formerly wife of Thomas; 57 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168970 54 54 f   7427 Herts land atte Doune, Roger; Julia, his wife Blount, Thomas le 58 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168971 54 54 f   7427 Herts land atte Doune, Roger; Julia, his wife Stowe, William de, of Sabrighesworth, parson; Goldman, Hugh; Bromleye, William; Bromleye, John, junior; atte Hyde, Geoffrey; Frere, William; atte Brok, Robert; atte Brok, Randolf; Joan, his wife; Atton, John de; St Edmunds, John, abbot of; Martyn, John; Matham, Sampson; Margaret, his wife 59 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168972 54 54 f   7551 Sussex trespass: assault atte Estcote(?), John Burgeys, Roger, of East Grenestede; atte Hulle, William; Oselynglegh(?), William; Richard, his son 60 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168973 54 54 d   7731 Soms per que servicia atte Forde, Walter Ralegh, John de, of Nettelscombe; Maud, his wife; Johanna, Elizabeth, Maud, & Christine, daughters of the same John & Maud; Ailideford(?), Henry, parson of the church, in; Ralegh, John, of Hywysh or Huish(?) 61 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168974 54 54 f   7551 Surrey land atte Ga_(?), Thomas Woubourn, Thomas de who vouched Gatstrede, John de, of Waletone, son & heir of Stephen 62 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168975 54 54 d   7782 Cornw account as receiver atte Geler, Richard, of London Aleyn, Thomas, of Fawy 63 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168976 54 54 f   7522 (?) land atte Grene, John Mepershale, John de, knight 64 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168977 54 54 d   7777 Nhants land atte Grene, John, of Uppyngham; Margery, his wife Herberd, Nicholas 65 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168978 54 54 f   7496 Essex account as receiver atte Halle, John, of Maldon Dassh, John, of Branketre, fishmonger 66 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168979 54 54 d   7641 Shrops debt atte Halle, William, son of Roger Vaghan, Thomas; Alesia, his wife 67 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168980 54 54 f   7516 Wilts(?) debt atte Hawe, Nicholas Crok, Reginald 68 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168981 54 54 d   7674 Kent trespass: rescue atte Helle, William atte Helle, Stephen; atte Helle, Ralph; atte Hell, Philip, both brothers of Stephen 69 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168982 54 54 f   7524 Hunts(?) account as receiver atte Hil, Robert, of Great Stokton atte Halle, William, of Little Stokton; Raad, Martin; May, Robert le, of Little Stokton 70 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168983 54 54 f   7451 Sussex trespass: close atte Hull, John, of Nuthurst Spicer, John, of Horsham, scrivenor; L_(?), William; Gosselyn, John 71 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168984 54 54 f   7447 Surrey debt atte Hyde(?), Richard, clerk Wyssh, Katherine, formerly wife of Henry 72 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168985 54 54 d   7637 Warws account as receiver atte Lake, John Mures, Bertram de 73 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168986 54 54 f   7486 Surrey account as receiver atte Leddrede, Gilbert Wyk_(?), Walter de 74 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168987 54 54 d   7811 Suffk account as receiver atte Lee, John Fourbysher, Richard(?) le 75 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168988 54 54 d   7655 Hants land atte Leghe, John Botiller, John le, knight; Gulle(?), Isabel, daughter of John Gulle(?), esq 76 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168989 54 54 f   7443 Cambs account atte March, Nicholas, Rose, his wife Seman, Geoffrey 77 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168990 54 54 d   7644 Hants trespass: close & taking atte Marche, Thomas atte Grome, Richard, of Romesey; Mershton, John, marshall; Scot, John, of Southampton, son of William 78 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168991 54 54 f   7453 Yorks account as receiver atte Milne, William, of Foston, chaplain Ahgby, Walter, of Siglesten; Willardby, John de, of Foston, chaplain 79 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168992 54 54 d   7658 Suffk account as receiver atte Molle, William dil Hoo, John, of Asshfeld, son of Peter 80 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168993 54 54 d   7757 Beds debt atte Mor, John, of Calton, executors of; (atte Mor, John, son of John; Clerk, Gilbert le); Risle, John de, of Chelunton atte Wode, Isabel, of Sharnebrok, formerly wife of Nigel 81 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168994 54 54 d   7827 Beds debt atte Mor, John, of Calton, executors of; (atte Mor, John, son of John; Clerk, Gilbert le); Risle, John de, of Chelunton atte Wode, Isabel, of Sharnebrok, formerly wife of Nigel 82 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168995 54 54 d   7769 Berks account as receiver atte Nasshe, Richard Queynte, John 83 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168996 54 54 d   7739 Essex account as bailiff atte Pirye, Walter Salprest, John, of Southminster 84 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168997 54 54 f   7591 Cornw account as bailiff atte Pitte, John, of St Dominic, parson Olyver, John 85 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168998 54 54 d   7751 Devon acquittance atte Pitten, Thomas Belston, John de 86 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2168999 54 54 d   7769 Berks trespass: close, assault & taking atte Ruyussh, John, of Walyngford Pycot, Robert; May(?), Henry; Joan, his wife; Redyng, Henry; Julia, his wife 87 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169000 54 54 f   7508 London account as receiver atte Rye, Alice Sugworth, John de 88 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169001 54 54 f   7481 Berks account as bailiff atte Rye, John Maynard, John, of Abyndon 89 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169002 54 54 d   7808 Essex trespass: taking horses atte Shire, Thomas Wyththebokeler, John 90 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169003 54 54 d   7729 Cambs account as receiver atte Slowe, John, of Gritton or Girton(?), executors of; (atte Slowe, Roger; atte Slowe, Geoffrey, of Gritton) Bruere, John, of Ely, chaplain 91 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169004 54 54 f   7459 London account as receiver atte Stone, John, of London Broun(?), William 92 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169005 54 54 d   7634 Herts trespass: taking atte Stone, John, of London Caupe, John; Campe, Walter 93 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169006 54 54 f   7533 Herts trespass: close & taking atte Watere, Agnes, of Staundon, formerly wife of John Taney, Thomas, of Erdelegh; Clere, William le, of Walkerne; Smyth, John le, of Walkerne; Webbe, John le, of Walkerne; Slegrave, Thomas, of Walkerne; Slograve, Walter, of Walkerne; Hunte, John le, of Walkerne 94 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169007 54 54 f   7411 Herts account as receiver atte Watre, John Ismongere, Thomas le, of Ware 95 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169008 54 54 f   7524 Middx account as receiver atte Welleheved, John Dykeman, Philip, tailor; Toryngton, John de, of Bassyngbourn, vicar 96 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169009 54 54 f   7584 Gloucs land atte Wode, John, of Wynchecombe, junior Moren(?), Simon, of Swyndon 97 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169010 54 54 f   7419 Staffs dower atte Wode, William; Margery, his wife Wryde, Roger, of Stafford, son of Roger 98 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169011 54 54 f   7475 Gloucs land Aubrey, Richard Kele, John de; Maud, his wife 99 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169012 54 54 d   7666 Middx account as receiver Aubrye, Andrew, of London Pychard, Thomas, of Hereford 100 cp40_357.txt CP40/357 Hilary 1349   2026-01-13
2169013 54 54 f   7440 Cambs trespass: assault & taking Auke or Anke(?), Katherine, of Litleport, formerly wife of Ralph Tapyta, William, of Litleport 101 cp40_357.txt CP40/357 Hilary 1349   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);