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

5,328 rows where roll_id = 61

✎ 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
2203037 61 61 d   1970 Cambs debt [ obscured ] _(?), of Fudham(?) 1 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203038 61 61 d   1032   debt [ obscured ] Lullew_(?), John 2 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203039 61 61 d   1051   debt (Zouche, Hugh la, knight, executors of; (Pelham, John, knight; Joan, his wife; Crouchere, William, of Fen Drayton, parson; Aleyn, William; Leverer, Richard) Wyndesore, John; Fulburn, William 3 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203040 61 61 d   1185 Yorks(?) debt [ first line obscured ] Henry(?) [ text obscured ] 4 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203041 61 61 d   1444 Warws debt [ is the plaintiff Roger Gardyner? ] Elyve, William, of Coventry, skinner 5 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203042 61 61 d   1926   trespass: taking horses & goods [ membrane torn ] Hakker, Nicholas 6 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203043 61 61 d   1058   trespass [ membrane torn ] Whetacre, Thomas 7 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203044 61 61 f   176 Gloucs covenant [ obscured ] Markeley, John; Isabel, his wife 8 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203045 61 61 f   3   [ obscured ] [ obscured ] Shokber_(?), Christopher; Huchyn(?) 9 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203046 61 61 d   1601   trespass [ obscured ] Tryvet, Thomas, of Cambridge 10 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203047 61 61 d   1998 Lincs trespass [ obscured ] Weleft_(?), Robert 11 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203048 61 61 f   3     [ obscured ]   12 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203049 61 61 f   43     [ obscured ]   13 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203050 61 61 d   1159 Lincs(?) assumpsit [ text obscured ] Haweberk, William 14 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203051 61 61 f   5   trespass _(?), chaplain(?) Pentyl(?), John 15 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203052 61 61 d   1968 Yorks dower _(?), James; Cecily, his wife del More, John, of Thornes 16 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203053 61 61 d   1273   trespass: killing pigs _(?), John Lotcote(?), William, of Mepeham 17 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203054 61 61 f   44 Yorks(?) debt _(?), of Howden(?) Keyton, Richard, of Askysby 18 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203055 61 61 f   318 vacat Statute of Laborers _(?), of Ipswich Charneux, Edmund; Bullyng, John 19 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203056 61 61 f   39   debt _(?), of Thaxstede Wynselowe, John 20 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203057 61 61 f   44 Yorks(?) debt _(?), of Tounelay Kent, Alice, countess of 21 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203058 61 61 d   1554 Bucks(?) trespass: assault of servant _(?), or St Davids(?), Guy, bishop of Bret, Thomas, knight; Cook, Richard 22 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203059 61 61 d   1554 Oxon(?) debt _(?), Richard, formerly servant to the late King Richard _(?), of Dorchester 23 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203060 61 61 d   2002   trespass: taking _(?), Robert [ obscured ] 24 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203061 61 61 f   28 Kent debt _(?), Stephen Lecchyngen, Richard de, of Smerden 25 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203062 61 61 f   172 Soms Statute of Laborers _(?), Thomas _(?), John 26 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203063 61 61 f   6   debt _(?), Thomas, lord of Weston Inge & of Byllington(?) _fige(?) 27 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203064 61 61 d   1555 Suffk Statute of Laborers _(?), William(?) Bullyng, John 28 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203065 61 61 d   1554 Oxon(?) trespass: close & taking _(?); Celia, his wife Bernard, John 29 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203066 61 61 f   3   debt _(?); Thomas; _(?), John, of Boston; Wy_(?), John, of Cambridge, master Haylok(?), Robert; Grenyng(?), Robert; others 30 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203067 61 61 d   1575   debt _ege(?), Hugh Sawer, John 31 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203068 61 61 f   44 Yorks(?) trespass: taking _esgodby, on his own account _(?), William 32 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203069 61 61 d   1552 London(?) debt _s(?), Richard, of London, mercer Copuldyk, John, knight; Camell, Robert; Wodecok, John, clerk; Lardyner, John; Walden, John, clerk; Plashe, John; Hereford, John, clerk 33 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203070 61 61 d   1552 London(?) debt _s(?), Richard, of London, mercer Honyngham, William de, of York, goldsmith(?); Bowet, Thomas, esq; Raventhorp, Thomas, esq; Wrenche, Thomas; Danyel, Thomas; Hintte, William 34 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203071 61 61 f   41   debt _wardyn(?), of London, grocer, on his own account Preterton, Hugh 35 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203072 61 61 d   1052   account _well(?); Anne, his wife Forster, Simon 36 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203073 61 61 f   414 Oxon ravishment of ward Abberbury, Richard de, knight, executors of; (Wilcotes, John; Makkeney, William; Orwell, John) Basyng, John; Agnes, his wife; John, brother of Agnes 37 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203074 61 61 d   1958 Berks land Abberbury, Richard, knight; Cleet, Alice, daughter of John Cleet & wife of Richard Stane, _(?), son of William de la Stane 38 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203075 61 61 f   355 Heref trespass: assault Abbot, Joan, of Leston Coutrey, Thomas le, of Lodelowe 39 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203076 61 61 d   1283 Norfk debt Abbot, Richard Prendere, John, of Shipden 40 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203077 61 61 f   515 Wilts debt Abbot, Thomas Davy, Ralph, of Salisbury, weaver; Wroxle, Robert, of Salisbury, weaver; Gylowe, William, of Salisbury, weaver; Mone, William, tailor; Busshop, John, weaver; Smyth, Henry 41 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203078 61 61 f   131 Wilts debt Abbot, Thomas, of Salisbury, dyer Baret, John, of Tarente Moneketon 42 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203079 61 61 d   1486 Nhants account as receiver Abbot, William Hogekyns, John, of Farvyngho 43 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203080 61 61 d   1486 Nhants debt Abbot, William Hogekyns, John, of Farvyngho; Zele, Thomas, executrix of; (Zele, Margaret, formerly wife of Thomas) 44 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203081 61 61 d   1364 Nhants account as receiver Abbot, William; Walton, John; Wantynge, John, of Farvyngho Smyth, Richard, clerk 45 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203082 61 61 f   124 Soms trespass: close Abbotesbury, Abbot of Joyberd, Richard 46 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203083 61 61 d   1902 Oxon debt Abburbury, John, clerk Fulbekke, Roger 47 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203084 61 61 d   1991 Oxon debt Abburbury, John, of Dokelyngton, parson Stowe, John, of Boreford 48 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203085 61 61 f   846 Norfk debt Abnale, Thomas Strystem, William, of Echam; Deye, Joan, of Helyngton; Osteler, John, of Lyccham; Welle, William, of Fosdyk; Lystere, John, staying in Walden 49 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203086 61 61 d   1706 Norfk(?) debt Abnale, Thomas Sutton, Thomas, of Northampton 50 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203087 61 61 f   96 Leics trespass: close & taking Above the Kirke, John, chaplain Durward, Thomas; Joan, his wife 51 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203088 61 61 d   1295 Oxon(?) detinue or debt Abraham, John Carter, Robert, of Comenore 52 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203089 61 61 d   1130 Lincs account as bailiff Abraham, Nicholas Littyster, William, of Quappelade 53 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203090 61 61 d   1911 Lincs trespass: killing foal & hen Abraham, Nicholas Saunderson, William, of Algerkirk 54 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203091 61 61 f   897 Lincs debt Abraham, Nicholas, of Algerkirk Hylyard, Roger, executrix of; (Hylyard, Joan, of Gedney) 55 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203092 61 61 d   1901 Berks trespass: felling trees & taking Abyndon, Richard, abbot of Bagge, Peter, of Abyndon, servant of John Bagge; Warwyk, John, of Abyndon, shoemaker; Lavynton, Walter, of Abyndon; together with Beaumond, Robert, of Abyndon; Webbe, William, of Abyndon; Wyght, John; Bate, Simon, of Abyndon, servant of John Bate; Battesour, Thomas; Colnham, John, of Abyndon, jun; Worthe, John; Whitton, John, clerk 56 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203093 61 61 d   1901 Berks trespass: free warren, hunting & taking Abyndon, Richard, abbot of Bye, John, of Shynele 57 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203094 61 61 d   1902 Berks trespass Abyndon, Richard, abbot of Whitton, John, clerk 58 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203095 61 61 d   1676 Soms debt Abyne, Roger, of Gotehurst, parson Bochere, John, of Enemere 59 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203096 61 61 d   1912   debt Abyngton, John Masse, Thomas, of Westburgh; parker, John, of Segbroke 60 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203097 61 61 d   1728 Lincs trespass: assault of servant Acastre. John Coke, Alan, of Lincoln 61 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203098 61 61 d   1168 Middx debt Acclom, John, of Scardeburgh Taverner, John, of Lynne 62 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203099 61 61 d   1890 Yorks debt Acclum, Mary, formerly wife of William de Acclum, knight, executors of; (Acclum, Henry; Fosseton, Richard; Henreman, William) More, John de la, of Pothow; Henryson, Robert; Rogerson, William, of Pothowe 63 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203100 61 61 d   1194 Nthumb trespass: close Accon, Lawrence Keswyk, John de; Richardson, William, of Newcastle upon Tyne; Smythson, John; Dey, William; Cledde, John; Monke, Nicholas; del Man, John; Cosour, William; Ferrour, John, of Newcastle; Wetewang, William; del Welles, Thomas; Carter, Adam, of Elstwyk; Grenelef, Richard; Breuster, John, of Newcastle upon Tyne 64 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203101 61 61 d   1542 Sussex trespass Acton, William, clerk Mopys, John 65 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203102 61 61 d   1392 London debt Adam, John Flete, John 66 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203103 61 61 f   312 Hants trespass Adam, John Launcevey(?), Richard 67 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203104 61 61 f   312 Hants trespass Adam, John; Totteford, John Launcevey(?), Richard 68 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203105 61 61 d   1772 Herts debt Adam, Nicholas, of Therfelde Skynnere, Philip, of Asschwelle 69 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203106 61 61 f   855 Yorks trespass: killing 3 boars Adamson, Richard, of Erkenden atte Keld, Thomas, of Minskip 70 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203107 61 61 d   1366 Yorks trespass: close & rick Adamson, Richard, of Erkenden Daweson, Robert, of Erkenden, son of Thomas 71 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203108 61 61 d   1680 Middx debt Adekyns, William, of Cherde Lambrok, William 72 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203109 61 61 f   944 Sussex trespass: taking & imparking animals, without reasonable cause Adlard, Walter Compere, Robert 73 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203110 61 61 d   1902 Bucks debt Adynggrave, William Helyot, William, of Hamme 74 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203111 61 61 f   405 Nhants cessavit Adyngton, Katherine Wawe, John 75 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203112 61 61 d   1919 Devon debt Affeton, Thomas de, executor of Thomas de Hacche, executor of; (Affeton, Thomas) Souper, William, son & heir of Joan, formerly wife of John 76 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203113 61 61 d   1919 Devon debt Affeton, Thomas de, executor of; (Affeton, Thomas de) Donne, Hugh; Glasier, Robert, of Exeter, son & heir of Thomas; Dodyngton, Thomas 77 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203114 61 61 d   1190 Devon debt Affeton, Thomas de, executor of; (Affeton, Thomas de) Donne, Hugh; Glasyer, Robert, of Exeter, son & heir of Thomas; Dodyngton, Thomas 78 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203115 61 61 f   917 Devon debt Affeton, Thomas, executor of Thomas de Hacche, executor of Robert de Hacche, executor of; (Affeton, Thomas) Speek, William, of Branford 79 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203116 61 61 d   1138 Devon debt Affeton, Thomas, executor of Thomas de Hacche, executor of Robert de Hacche, executor of; (Affeton, Thomas) Speek, William, of Branford; Tyverton, John de, executor of; (Trebrewe, John, clerk) 80 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203117 61 61 d   1804 Devon debt Affeton, Thomas, executor of Thomas de Hacche, executor of Robert de Hacche, executor of; (Affeton, Thomas) Speek, William, of Branford; Tyverton, John de, executor of; (Trebrewe, John, clerk) 81 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203118 61 61 d   1964 Devon debt Affeton, Thomas, executor of Thomas de Hacche, executor of Robert de Hacche, executor of; (Affeton, Thomas) Tunerton, John de, executor of; (Trebrewe, John, clerk) 82 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203119 61 61 f   904 Devon(?) debt Affeton, Thomas, executor of; (_(?), Affeton) Bykelegh(?), Thomas, son & heir of (?) 83 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203120 61 61 d   1191 Devon debt Affeton, Thomas, executor of; (Affeton, Thomas) Bykelegh, Thomas, son & heir of John 84 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203121 61 61 f   79 Devon debt Affeton, Thomas, executor of; (Affeton, Thomas) Marchaunt, Robert, executors of; (Bykelegh, Thomas, son & heir of John; Shephurde, John) 85 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203122 61 61 d   1447 Devon debt Affeton, Thomas, sen Trommer, Walter, of Polysford; Trommer, Thomas; Horton, Robert, of Mollond; Dook, John, of Bradeford Tracy; Horyg, William, of Romundeslegh or Romansleigh; Janyn, John, of South Molton; atte Hille, Thomas, of Wollecombe 86 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203123 61 61 f   860 Essex debt Agar, Ralph, of Colchester, executors of; (Denton, Robert, clerk; Wyght, Robert) Lambe, William, executor of; (Fullere, Robert, of Halsted, clerk) 87 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203124 61 61 d   1349 Kent replevin Aghemond, Hamond German, Simon, jun 88 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203125 61 61 f   587 London debt Aghton, Gilbert de, of London, stockfish monger del Wollesall, Richard; Kelyng, Robert, of Kirkeby Walay, parson of half the church; Seacome, Robert, of Liverpool; Lydiate, Robert, son of William; Collay(?), Adam de 89 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203126 61 61 f   469 Yorks debt Aghton, John Parkynson, Robert, of Coteneys; Sliche, Thomas, of Whitgyft; Dodley, Robert de, shipman; Prikofeld, William; Fox, John, butcher; Howesonman, John; Milner, John 90 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203127 61 61 d   1535 Yorks debt Aglion, Richard, of Beverley Randolf, Simon, dyer 91 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203128 61 61 d   1060 Yorks debt Aglion, Richard, of Beverley, merchant Redmer, William, of Out Newton(?) 92 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203129 61 61 d   1593 Cumb debt Aglionnby, William de, of Agliounby Bristowe, John de, baker; Philipson, Robert; Levenweode, William; Warthewyk, William de 93 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203130 61 61 d   1817 Cumb trespass: close, taking house timbers Agliounby, William de Ledall, William de, of Burgh; Atkynson del Garthe, John; Wessy, Adam; Banton, William de; Wilkynson, John, of Langbargh; Robynson, John, herde; Barne, John, of Banton; del Mure, Thomas; Levyngton, Robert de; Taillour, John, of Banton; Soust, John 94 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203131 61 61 f   277 Nthumb trespass: close Aiton(?), Lawrence Hydwyn, John; de Hall, John; Hunter, Stephen; Haweson, John; Mandelans, Peter de; Barker, Richard, of Newcastle upon Tyne; Byrchefeld, Robert; Beverley, Robert de; Hull, John de; Grey, Robert; Cook, William; Watson, John; Styrnyng, John; Hogge, John 95 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203132 61 61 d   1473 Soms debt Alampton, John, clerk Richard, John, of Welles 96 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203133 61 61 d   1411 Soms debt Alampton, John; Arthur, John, jun; Kyngesbury, Thomas Torney, Robert, of Combe, Wilts 97 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203134 61 61 d   1599 Lincs debt Alanson, John, of Cumberworth, son of William Cumberworth, Robert de, son of Celia 98 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203135 61 61 d   1987 London debt Albertis, Philip de, of Florence, of the society of Albertines Peverell, Thomas, bishop of Llandaff 99 cp40_561_AJ.txt CP40/561 Easter 1401   2026-01-12
2203136 61 61 f   305 London debt Albon, John, of London, mercer Oyne, John, of Northampton, glasier; Merston, John, of Chesthunt, esq; Gervays, Thomas, of Shaftesbury, draper; Doune, John, of Chelmesford 100 cp40_561_AJ.txt CP40/561 Easter 1401   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);