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,550 rows where roll_id = 63

✎ 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
2213526 63 63   d 1842 London   [ entry incomplete ] Coggeshale, William, of Essex, knight 1 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213527 63 63   d 1639 Kent   [ incomlete entry ] Hallum, Robert, of Northflete, master & parson 2 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213528 63 63   d 1837 Lincs(?) trespass: taking [ membrane torn ] Walssh(?), John; his son; Clay, David, of Holbech; Kyng, Thomas; Wenne, Geoffrey, of Holbech; _(?), John; Elys, William, of Flete; Grene, William, of Flete; Thakker, Richard, of Flete; De_(?), John; Kyng, Lawrence, of Flete; Dygill, Richard, of Flete; Williamson, Fulco, chapman; _(?), NIcholas, servant of Drayby(?) 3 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213529 63 63   d 1839   debt [ obscured ] Bluet, John 4 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213530 63 63   d 941   debt [ obscured ] Fitz Ive(?), John, of Boxford, church clerk; Jekel, _(?), shoemaker; atte Slade, Simon, of Illoye; _oole, John, of Lavenham(?); _(?); Alice, his wife; shepherd, R_(?); Alhot, Thomas, of Waldynfeld 5 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213531 63 63   f 7     [ parchment torn ] Reynold, Isabel 6 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213532 63 63   d 1860   debt [ text obscured ] Boteller, Hugh, of Brakkele 7 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213533 63 63   d 1284 vacat debt [ vacated ] _(?); Talbot, Thomas, of Bylliston; Wry_the(?), John 8 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213534 63 63   f 353 vacat trespass: assault _(?), Alice Forster, Lawrence; Yenge, James; Idelet, Robert; together with Fyssher, John, of Plymouth 9 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213535 63 63   d 1859   debt _(?), clerk Boynton, John de, of Boynton 10 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213536 63 63   f 314 [ erased ] debt _(?), clerk; Everdon, John, clerk Richefort, John de, knight; Symond, John, of Boston 11 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213537 63 63   f 903   debt execution _(?), executors of; (Warener, John; Osgaston, John; Tem_(?), Richard) Assheman, William, of Gorleston 12 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213538 63 63   f 906 Middx trespass: taking _(?), Henry Peres, Alice, of Westminster, formerly wife of John 13 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213539 63 63   d 1837 Lincs(?) trespass: close & taking _(?), John Mays, William, of Donyngton; Calche, John, of Donyngton 14 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213540 63 63   f 893   [ plea type obscured ] _(?), John(?) Great H_(?), Richard, parson of; Holand, _(?) 15 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213541 63 63   d 1836   trespass: close & taking _(?), knight Waleson, William, of Stalynburgh; Shepherd, John; William, his son; Megson, William, of Stalynburgh; Bam, Robert de, of Stalyngburgh 16 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213542 63 63   f 895 Lincs(?) trespass: close & taking _(?), knight; W_(?), Richard Redy, John, of Sybbesey 17 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213543 63 63   d 1854 Bucks(?) trespass: close & taing _(?), of Helpesthorp Grene, Henry, of Helpesthorp 18 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213544 63 63   d 1835   debt _(?), of London, citizen Made_(?), of W_(?); _(?), Robert 19 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213545 63 63   f 894   debt _(?), of Rogge Deen(?) Leveryk, William, of Irreby 20 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213546 63 63   d 1837   trespass on the case: poor maintenance of drainage channel, causing flooding _(?), of Rydford, knight Rupe, Robert, abbot of 21 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213547 63 63   d 1837   debt _(?), of Soterton Massyngberd, Hugh, of Sutterton 22 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213548 63 63   f 895   trespass: taking _(?), of Spaldyng Daunt, William, of Spaldyng; Bathe, Robert; _(?), of Depyng 23 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213549 63 63   d 1833   debt _(?), of Swanyngton Clerk, Robert, of Thregeston 24 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213550 63 63   f 895   debt _(?), or Wrangle Belle, Richard, of Hek_(?) 25 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213551 63 63   d 1852   trespass: assault & taking _(?), Ralph Scurell, Thomas; Bosworneth, Roger, _(?), John; Vyan, Richard; Jojan, Richard; Richard, Robert; Dro_(?), John; Texter, Alice; David, John; Maryn, Richard; Ivon, John; Kenell, Walter, of Loo; Ldeon(?), Henry, of _rthenes; John; Raulyn, Benedict 26 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213552 63 63   d 1735   account as receiver _(?), Ralph Thornbury, Philip 27 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213553 63 63   f 3 Essex trespass _(?), Robert Abraham, John(?); Abraham, William, servant of John 28 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213554 63 63   d 1843     _(?), Thomas Spicer, John, of Wooton, Beds; Norton, John 29 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213555 63 63   d 1841   account as receiver _(?); Agnes, his wife Martham, Richard 30 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213556 63 63   d 1207 vacat land _(?); and his wife; Derneford, Stephen, jun Denyngton, John; Hoper, Thomas; Symon, Ralph; Yveuell, John, chaplain; Gawell, William, chaplain; Elys, John, clerk 31 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213557 63 63   f 273 vacat, Devon(?) dower _(?); Edith, his wife _(?), John; Celia, his wife 32 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213558 63 63   d 935   land _(?); Elizabeth, his wife Venye(?), James, le, vicar 33 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213559 63 63   d 1839   trespass _ecford(?), knight _(?), Thomas, of Mauby 34 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213560 63 63   d 1778 Suffk debt _emkyl(?), Nicholas, of Hadlegh Bayn, John, of Hadlegh 35 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213561 63 63   d 1119   debt _hithelegh(?), Richard, jun Pomeray, Thomas de la, knight 36 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213562 63 63   f 916   debt _irgh(?) Haukyn, John, of London 37 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213563 63 63   f 895 Lincs(?) debt _liffe(?) G_(?), John, of Grantham, clerk 38 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213564 63 63   d 1494   trespass: assault _ogges(?), Walter, chaplain Rog_ss_a(?), John, baker 39 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213565 63 63   d 1833   debt _powe(?), of Melton Twyford, Margaret, prioress 40 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213566 63 63   d 1854   trespass: separate fishing, gutter & taking _syles(?), knight Colles, John, Peyto, John; Beef, William; together with Forster, John; Lowe, Richard de; Collesden, Robert; Bonde, William; Hugges, John 41 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213567 63 63   d 1839   account as receiver _vyth(?), William, esq Call, Robert, of Rycall 42 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213568 63 63   f 754 Devon(?) trespass: close A_e(?), Giles Taillour, William, of Bradeford; atte _(?), Henry; Ram, Robert 43 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213569 63 63   d 1259 Norfk debt Abbenale, Thomas Howgate, Robert, of Leicester, mercer 44 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213570 63 63   f 500 Berks land & advowson Abberbury, Richard, knight; Cleet, Alice, daughter of John, & wife of Richard Stane, Randolf de la, son of William(?) 45 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213571 63 63   d 1611 Hunts Statute of Laborers Abbot, Margaret Oundell, William 46 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213572 63 63   d 1242 London debt Abbot, Roger, of London, draper, executor of; (Weyland, Thomas; Calan(?), Robert; Agnes, his wife) Northlond, Richard, knight 47 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213573 63 63   d 1213 London debt Abbot, Roger, of London, draper, executors of; (Weyland, Thomas; Coton, Robert; Agnes, his wife) Northelond, Richard, knight 48 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213574 63 63   f 630 Wilts debt Abbot, Thomas Foket, Margaret, formerly wife of Thomas Foket, of Salisbury; Webbe, Vincent, of Salisbury; Portesham, Hugh, of Salisbury; Busshop, John, of Salisbury, weaver; Walton, John, jun, of Salisbury, fuller; Hyndon, Robert, of Salisbury; Shapwyk, Richard, of Portsmouth; Whitfeld, John, of Bruton, weaver; Broun, Edith, of Salisbury, formerly wife of Robert, weaver 49 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213575 63 63   f 309 Dorset trespass: felling & taking trees & brushwood Abbotesbury, abbot of Houper, Thomas, of Portesham; Smyth, William, of Portesham 50 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213576 63 63   d 1399 Dorset trespass: close & taking animals Abbotesbury, Robert, abbot of Perot, Thomas, chaplain 51 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213577 63 63   d 1488 Oxon detinue (box of charters) Abraham, John Pacy, William, of Grafton 52 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213578 63 63   d 1276 Lincs debt Abraham, William, of Boston, draper Bargayne, William, of Boston, dyer 53 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213579 63 63   d 1853 Lincs(?) debt Abruby, John, of Denant in Alman, merchant Stekenay, Stephen, of Newerk; Martyn, Robert, of Spaldyng 54 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213580 63 63   f 648 Kent debt Absolon, Agnes, of Leuesham Skyll, Richard, of London 55 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213581 63 63   d 1508 London debt Aby, Robert, marshall of the King's Marshalsea Hospice Levyngton, Richard 56 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213582 63 63   d 1116 Devon account as receiver Ackelane, John atte Forde, Walter 57 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213583 63 63   f 173 Herefs trespass: taking money Acton, John Bromyerd, John, of Hereford, prior; Belmare, Richard, another brother in the same priory 58 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213584 63 63   f 634 Bucks formedon descender Adam, Richard, of Swanburn; Julia, his wife Dens, Robert, of Hoggeston; Alice, his wife 59 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213585 63 63   f 345 Kent debt Adam, Stephen Loudare, Richard, of Aldyngton 60 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213586 63 63   f 72 Kent debt Adam, Stephen, of Romene Stonstrete, John, of Kyngessnoth 61 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213587 63 63   d 1593 Soms trespass: close Adams, William Shawe, Thomas, of Pennesford 62 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213588 63 63   f 226 (Cambs) supplicavit: mistaken outlawry Adekyn, John, of Berton, Cambs Caldecote, Thomas, of Cambridge 63 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213589 63 63   d 1113   debt Adekyns, William Colyford, John, of North Pederton 64 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213590 63 63   d 1573 Beds trespass: taking Adesson, John Plot, John, of Chalsterne 65 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213591 63 63   f 449 Warws debt Adkynson, John Godfrey, Henry; Chaselyn, Thomas 66 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213592 63 63   d 1070 London debt Aghton, Gilbert, of London, stock fishmonger B_rd_(?), John, of Sandwich 67 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213593 63 63   d 1575 Suffk trespass: close, assault & taking Aketon, John Mory, John, of Stratford; Rande, Thomas, of Stratford; Sadelere, Roger, of Stratford 68 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213594 63 63   f 640 Notts debt Akryng, John Flesshewer, John, of Stoketh 69 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213595 63 63   f 339 Essex debt Alayn, Richard, chaplain; atte Hoo, John, chaplain Nunde, John, of Lambourn, parson; Shelley, John, parson of the church, in; atte Ree, Wiliam, of Wodford; Brayneshache, John, of Shyngelfeld; Loryng, Robert, of Hodesdon 70 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213596 63 63   d 1684 Norfk debt Alberd, Giles Plomer, Philip, of Norfolk; Stoun(?), John, scrivenor; Pawele, John, of Surlyngham 71 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213597 63 63   d 1805 Norfk trespass: close & taking Alby, Margaret de, formerly wife of Roger Walpoll, Peter de 72 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213598 63 63   f 475 Yorks debt Aldeburgh, Robert, of Masham Hakenay, William, of Feriby, miller 73 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213599 63 63   d 1719 Bucks detinue (charter) Aldebury, William Warde, Robert, of Aylesbury 74 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213600 63 63   f 19 Essex trespass: assault Aldeham, John, of Kelewedon, vicar Perpont, Edward 75 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213601 63 63   d 1076 Bristol debt Alderley, Nicholas Pembroke, William, of Bristol, burgess 76 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213602 63 63   f 34 London debt Aldesworth, Thomas Plattes, Richard, of Nottingham; Maundvile, Robert, of Nottingham; Sergeant, James, of Coventry; Pynchebek, Thomas; Salway, Richard 77 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213603 63 63   d 979 Suffk debt Aldewyk, Peter, of Ratelsden Freton, Richard de; Freton, John, of Herleston; Davy, William, of Edwardeston; Davy, Walter, of Edwardeston; Porter, William, of Chelesworth, fuller; Merffrey, William, of Little Waldyngfeld, fuller 78 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213604 63 63   f 836 Suffk debt Aldewyk, Peter, of Ratlesden Freton, Richard de; Freton, John, of Herleston; Davy, William, of Edwardeston; Davy, Walter, of Edwardeston; Porter, William, of Chelesworth, fuller; Merffrey, William, of Little Waldyngfeld, fuller 79 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213605 63 63   f 882 Norfk trespass: close & taking Aldry, John, of Norwich Mouton, John, the parish priest, in 80 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213606 63 63   f 155 Norfk trespass: close & taking Aldry, John, of Norwich Mouton, John, the parish priest, of 81 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213607 63 63   f 800 Norfk debt Aldry, John, of Norwich Straunge, Robert, of Topcroft 82 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213608 63 63   d 1667 Norfk debt Aldry, John, of Norwich Straunge, Robert, of Topcroft 83 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213609 63 63   d 1275 Lincs debt Aldyngham, John, of Ingoldmeles, clerk Skynner, Robert, of Louth 84 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213610 63 63   f 848 Sussex debt Aleyn, Alan Swan, Roger, of Hertfeld; atte Crouche, William, bekere; Chylly, John 85 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213611 63 63   d 1431 Herts land Aleyn, Gilbert; Margery, his wife Brodeye, Robert; Alice, his wife; Smyth, John 86 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213612 63 63   d 1709 Wilts trespass: close, felling & taking trees & brushwood Aleyn, John Burton, William, of Burton 87 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213613 63 63   f 442 Cornw trespass: close, taking house timbers, incitement Aleyn, John Judde, Richard; Alice, his wife 88 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213614 63 63   d 1381 Worcs debt Aleyn, John Styward, William, of Salford Abbot; Clayn, William, of Aburton; Whelere, John, of Wyche, butcher 89 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213615 63 63   d 1742 Norfk(?) debt Aleyn, John, of Fretyngham, parson Randolf, Henry, of Horstede, parson 90 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213616 63 63   d 1758 Sussex trespass: assault Aleyn, Joseph; Alice, his wife Sage, Robert 91 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213617 63 63   d 1451 Norfk debt Aleyn, Nicholas Cotte, William, of Redham; Isabel, his wife 92 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213618 63 63   f 698 Sussex trespass: assault of wife Aleyn, Philip; Julia, his wife Aleyn, Nicholas 93 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213619 63 63   f 18 Essex debt Aleyn, Richard, chaplain Bateman, Nicholas, clerk 94 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213620 63 63   d 1460 Essex debt Aleyn, Richard, chaplain Bateman, Nicholas, clerk 95 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213621 63 63   d 997   [ plea type obscured by tear ] Aleyn, Richard, of Broklonde, son of William Stokepeny, John; Denne, William; atte Smethe, Thomas 96 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213622 63 63   d 1802   trespass on the case: warranty on sale of goods Aleyn, Richard, of Longestowe, Hunts Tippere, John, of Everdene, Beds 97 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213623 63 63   d 945 Notts trespass: close & taking Aleyn, Robert Serle, Henry, of Bestam(?), vicar; Tillyng, Nicholas, of Lenton; Taillour, Robert, of Lenton; Shakesper, John, of Lenton 98 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213624 63 63   d 1365 Nhants debt Aleyn, Robert Wolf, Roger, of Beauchampton; Derlyngton, Thomas, of Wenlyngburgh; Taylard, John, of Multon; Herdwyn, Robert, of Northampton; Gillyng, John, of Bradden; Bukyngham, John, of Northampton; Gardiner, William, of Keylmerssh 99 cp40_570_AJ.txt CP40/570 Trinity 1403   2026-01-13
2213625 63 63   f 469 London debt Aleyn, Roger, of London, goldsmith Riche, John, of Petrisfeld, Hants 100 cp40_570_AJ.txt CP40/570 Trinity 1403   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);