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,512 rows where roll_id = 64

✎ 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
2218076 64 64   d 1574 Suffk land Kantele, Thomas Fyn, John; Fyn, William 1 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218077 64 64   f 570 Norfk dower Karman, John, of Shipden; Agnes, his wife Colby, John, of North Reppes 2 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218078 64 64   f 879 Suffk debt Karwent, John Godyng, Ellis, of Debenham; Sewale, John, of Welesham 3 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218079 64 64   f 836 Suffk debt Karwent, John Leman, William, of Weybrede 4 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218080 64 64   d 979 Suffk(?) debt Karwent, John Leman, William, of Weybrede; Godyng, Ellis, of Debenham; Plomer, John, of Framelyngham; Sewale, John, of Welesham 5 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218081 64 64   d 1177 Nthumb trespass: close & taking Kawardby, John, of Alnewyk, draper Payn, John, of Brendewode; Payn, Thomas, Mok(?), Stephen, of Orseth 6 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218082 64 64   f 684 Cumb trespass: close & taking Kay, William Harras, Nicholas, of Lamplogh; Broun, Thomas, of Aierist(?); Syngleton, William de, of Coupland 7 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218083 64 64   f 25 Kent replevin Kayme, William Kayme, Roger 8 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218084 64 64   d 1611 Hunts trespass Kayno, Robert Lucas, John, clerk; Ferrour, Richard, of Ravele; Collysson, John 9 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218085 64 64   d 1611 Hunts trespass: assault Kayno, Robert Olney, Richard; Baker, John; Cook, John; Stable, William of the; together with Whithoune, William; Lucas, John, clerk; Ferrour, Richard, of Ravele; Collysson, John 10 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218086 64 64   d 1457 London trespass Kays, Richard Bovauntre, William; Bovauntre, John 11 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218087 64 64   f 569 London detinue (box of charters) & debt Kays, Richard Russell, John; Margery, his wife; Bonaunt(?), John; Joan, his wife 12 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218088 64 64   d 1247 London detinue (box of charters) & debt Kays, Richard Russell, John; Margery, his wife; Bonauntre, John; Joan, his wife 13 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218089 64 64   d 1210 Middx debt Kaysho, Henry, of Northampton, draper Botesham, John, of Northampton, draper 14 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218090 64 64   d 1230 Sussex debt Kechenege, William Holstokke, John, sen, of Northiham; Holstokke, John, jun, of Northihamme 15 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218091 64 64   d 1772 Soms debt Kedewelly, John London, William, of Crukern; Lytel, Benedict, of Mere; Bocher, William, of Yevelchestre; Reynesbury, John; Page, Peter 16 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218092 64 64   f 276 Soms debt Kedewelly, John Stapelton, William, of Briggewater; Poule, John, of Briggewater; Castell, John, of Laurence Lydeyard; Skynner(?), Robert, of Briggewater 17 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218093 64 64   d 1144 Soms debt Kedwelly, John Boteler, Henry 18 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218094 64 64   d 1739   debt Kedwelly, John, of Briggewater, clerk; Mayn, Richard Botelere, Henry, of Bristol 19 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218095 64 64   d 1495   debt Keep, William, of Wysebeche, executors of; (atte Lathe, Robert; Margaret, his wife) _(?), of Wysebeche; Lowyne, John 20 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218096 64 64   f 641 Cambs debt Keep, William, of Wysebeche, executors of; (atte Lathe, Robert; Margaret, his wife) Pokedyche, John; Pappe, Thomas; Taillour, Thomas, of Wysebeche 21 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218097 64 64   d 1836 Lincs debt Kele, Robert Mannyng, William, chaplain; Bramle, John, of Conyngesby 22 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218098 64 64   d 1532 Lincs debt Kele, Robert de Leggesby, Peter de, clerk 23 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218099 64 64   f 68 Lincs debt Kele, Robert de Mannyng, William, chaplain; Bramle, John, of Conyngesby 24 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218100 64 64   d 1517 York trespass: close & taking Kelfeld, Thomas de, of York Leverton, Thomas de, of York 25 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218101 64 64   d 1820   debt Kelk, John de Scruby, Thomas; Penreth, John de; Brounflete, Thomas, of Beverley; Ingram, John, of Burton; Coltman, John; Smyth, William, of Pokelyngton 26 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218102 64 64   d 1528 Yorks debt Kelk, John de Shephird, Thomas, of Lund; Lecolf, Thomas; Santon, Robert de of Lund 27 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218103 64 64   f 469 London debt Kellum, Robert Grenne, Robert, of Becheley; Southewell, Robert, of Becheley; Milles, William, of Becheley 28 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218104 64 64   d 1681 Notts debt Kellum, Thomas Baxter, John, of Newerk; Russell, John 29 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218105 64 64   d 1427 Notts trespass: taking Kelome, John de, son of Richard Mandesley, Thomas de; Osmanthorp, Hugh 30 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218106 64 64   f 787 Notts [ plea type obscured ] Kelome, John de, son of Richard Mandesley, Thomas; Osmanthorp, Hugh 31 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218107 64 64   f 408 Lincs trespass: close & taking Kelon, William Belle(?), Robert, of Spaldyng; together with Shouldam, John, of Spaldyng 32 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218108 64 64   d 1780 Suffk debt Kelsey, Philip, of Great Qwelwetham, parson of the church Copto, William, of Great Qwelwetham 33 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218109 64 64   d 1497 Essex debt Kelsey, Robert, of London, vintner; Alice, his wife West, John, of Lodon, fishmonger; West, William, of Elmedon 34 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218110 64 64   f 27 Kent debt Kempe, Thomas, of Wye atte Sole, John, of Deal, parson 35 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218111 64 64   d 1592 Soms trespass: close & taking Ken, John, of Ken Jakeron, Thomas, of Ken 36 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218112 64 64   f 654 Soms account as bailiff Ken, John, of Ken Russheworth, John, of ken 37 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218113 64 64   d 1765 Cornw trespass; assault Kendale, John Cotewata, Richard 38 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218114 64 64   f 467 Staffs trespass: assault Kendale, John, of Atherston Ludford, Henry, of Anstley; Boteler, John, of Austley; Scot, Henry, of Anstley 39 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218115 64 64   d 1103 Derbs debt Kendall, William Strete, John, of Cryche 40 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218116 64 64   d 1602 Hants trespass: felling & taking trees & brushwood Kenne, John Pynays, Richard, of Bynteworthe 41 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218117 64 64   f 525 Devon trespass: close, taking horses, cows, bull & other animals Kenrigg, Richard; Gille, John Halewill, John; Rowe, William, clerk; Rowe, Hugh; together with Wakham, Walter; Wakham, Richard; Bekebury, John; Yoman, William; Short, Walter; Martyn, Nicholas, haulier; Wethilond, John, clerk 42 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218118 64 64   f 525 Devon trespass: close, taking horses, cows, bull & other animals Kenrigg, Richard; Gille, John Wakham, Walter; Wakham, Richard; Bekebury, John; Yoman, William; Short, Walter; Martyn, Nicholas, haulier; Wethilond, John, clerk; together with Halewill, John; Rowe, William, clerk; Rowe, Hugh 43 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218119 64 64   f 307 Devon debt Kenrigge, Richard Rysshe, Thomas; Maud, his wife 44 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218120 64 64   d 1668 Norfk reasonable dower Kenstan, Agnes, formerly wife of Walter Prentes, Henry, of Wygenhale; Maud, his wife 45 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218121 64 64   d 1194 Herts debt Kent, Alice, countess of Bernevylle, Thomas 46 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218122 64 64   d 1087 Yorks debt Kent, Alice, countess of, & Lady of Wake Forestere, John, of Cotyngham; Mafaa, John, of Screyngham 47 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218123 64 64   d 1087 Yorks debt Kent, Alice, countess of, & Lady of Wake Taillour, Roger, of Keldholm; Milner, William, of Keldholm; Smyth, John, of Kirkeby Moresheved; Barker, Robert, of Kirkeby Moresheved 48 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218124 64 64   d 1194 Herts debt Kent, Alice, countess of, and Lady of Wake Nichell, John, of Buschey; Scheperd, John, of Aldenham; Smyth, John, of Watford 49 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218125 64 64   d 1112 Surrey trespass: taking animals Kent, Alice, formerly wife of Thomas, lately the earl, of Weyvyle, Richard 50 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218126 64 64   f 191 Soms waste Kent, Joan Beaumond, Robert; Joan, his wife 51 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218127 64 64   f 216 Derbs debt Kent, Joan, countess of, & lady of Wake Nettilworth, Roger, of Chestrefeld 52 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218128 64 64   f 216 Derbs account Kent, Joan, countess of, & lady of Wake Nettilworth, Roger, of Chestrefeld 53 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218129 64 64   f 557 Essex debt Kent, John Stistede, Stephen; Chapman, Thomas, of Pateswyk 54 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218130 64 64   f 156 Norfk debt Kent, John, of Filby Robert, Oliver of Ingham 55 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218131 64 64   f 250 Berks debt Kent, John, of Redyng, mercer Smyth, Nicholas, of Henton 56 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218132 64 64   f 330 Suffk debt Kent, John, of Thaxstede Stedeman, Thomas, of Stoke Neyland 57 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218133 64 64   f 836 Suffk debt Kent, Nicholas, of Combes Goldsmyth, Frederick, of Ipswich; Calk, John, of Boxsted, shoemaker; Creppyng, John, of Combes, butcher; Cook, John, of Stowe Deen 58 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218134 64 64   d 978 Suffk debt Kent, Nicholas, of Combes Goldsmyth, Frederick, of Ipswich; Calk, John, of Boxsted, shoemaker; Creppyng, John, of Combes, butcher; Cook, John, of Stowe Deen 59 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218135 64 64   d 1100 Cornw trespass Kent, Thomas Prata, John, clerk; others 60 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218136 64 64   f 569 London debt Kent, Thomas, of London, painter Preston, John, of Caweston, Norfolk; Lorde, John, of Bedfordshire 61 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218137 64 64   d 1214 London(?) debt Kent, Thomas, of London, painter Preston, John, of Caweston; Lorde, John, of Bedeford 62 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218138 64 64   f 403 Norfk debt Kep, William, of Wysbech, executors of; (atte Lathe, Robert; Margaret, his wife) Mylys, Agnes; Bollyngbork, Eve; Redberd, Edmund 63 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218139 64 64   f 318 Hants debt Kerby, Nicholas, of the Soke of Winchester Saundres, John, of Slyndon 64 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218140 64 64   f 19 Herts debt Kerdyngton, John, chaplain Yepegrave, Thomas 65 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218141 64 64   f 44 York debt Kereby, Robert, of York Getour, John, bed maker 66 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218142 64 64   f 449 Warws debt Keresley, William de, of Coventry Marssal, John, of Corley, son of Henry; Mars_(?), Henry, of Corley 67 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218143 64 64   f 172 Suffk debt Kerseye, John, prior of Ku, John, of Kerseye 68 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218144 64 64   f 607 Lincs account as receiver Kerver, Gilbert, of Grymesby Godelyng, Henry, of Grymesby 69 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218145 64 64   d 1713 Kent debt Kestane, Roger, parson of the church, in Holm, John, of Craye 70 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218146 64 64   f 440 Berks trespass: close, taking chest of charters & other goods Kete, Agnes Goryng, Thomas, of West Hakeburn 71 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218147 64 64   d 1361 Norfk debt Ketell, Roger Lekynghithe, John, of Hekyngham; Bateman, John, of Hekyngham; Plegh, Stephen, of Hekyngham; Kyng, William, of Hekyngham 72 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218148 64 64   f 726 Norfk trespass: close, taking animals & goods Ketill, Roger Randes, John, clerk 73 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218149 64 64   d 1020 Hants debt Keton, John, clerk Frank, John, of the New Forest; Tauk, Margaret, of Burle, formerly wife of John; Malmeshull, Amice, of Southampton 74 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218150 64 64   f 31 Devon debt Keynes, John Whitelegh, Peter 75 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218151 64 64   f 723 Soms trespass: close & taking Keynesham, Thomas, abbot of Husee, Henry, of Keynesham; Margery, his daughter 76 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218152 64 64   d 1592 Soms debt Keynesham, Thomas, abbot of the monastery, in Beston, John, of Shyrmhampton; Blakhod, Henry 77 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218153 64 64   d 1192 Lincs debt Kidall, John Richecok, Richard, of Burgh, Yorkshire; Wodehous, Roger, of Barton; Peek, William, of Barton; Baudewyn, Richard, of Yatilthorp; Harpour, John, jun, of Boudeby; Stokes, William, of Wotton 78 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218154 64 64   f 194 Middx debt Kilborne, Emma, prioress of Glastynbury, John 79 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218155 64 64   f 422 Middx debt Kilborne, Emma, prioress of Glastyngbury, John 80 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218156 64 64   d 1337 Essex debt Killer, William Aubre, John, of Borham 81 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218157 64 64   d 1013 London debt Killesby, John, chaplain Everdon, John, of London, tailor 82 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218158 64 64   d 1214 London debt Killyk, John, of London, vintner; Wymbissh, Thomas, of Thakstede Page, John, of Walden, Essex 83 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218159 64 64   d 1505 London debt Killyk, John, of London, vintner; Wymbissh, Thomas, of Thakstede Page, John, of Walden, Essex 84 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218160 64 64   d 1459 Surrey trespass Killyk, Richard Portere, Richard 85 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218161 64 64   d 1176 York Statute of Laborers Killynghale, Robert de, of York, cutler Brune, Henry, of Beverley; Brune, William 86 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218162 64 64   d 1700 York Statute of Laborers Killynghale, Robert de, of York, cutler Brune, Henry, of Beverley; Brune, William 87 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218163 64 64   d 1591 Westmd debt Killynghall, John de, of Kirkeby Stephen Alanby, Robert 88 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218164 64 64   f 242 York debt Killynghall, Robert, of York, cutler Barde, William, of London; Barde, Robert 89 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218165 64 64   f 761 York debt Killynghall, Robert, of York, cutler Barde, William, of London; Barde, Robert 90 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218166 64 64   f 696 Yorks trespass: close, taking box of charters & other goods Kilpyn, John Bedlyngton, Robert; Oustwyk, Alice de, daughter of Alan 91 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218167 64 64   f 361 Hants covenant King's Beaulieu, abbot of Tauk, Thomas, esq 92 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218168 64 64   f 283 Wilts debt Kiplych, Walter Wynter, Robert, of Brykmyston 93 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218169 64 64   f 59 Leics debt Kirkeby on Wrethek, prior of the priory, in Ochweleman(?), John, of Wely_(?), Derbyshire 94 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218170 64 64   f 901   trespass: assault Kirkeby(??) Cokkys, John; _(?), Nicholas 95 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218171 64 64   d 1042 Yorks detinue (chest of charters) Kirkeby, Alice de Biland, Geoffrey, abbot of 96 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218172 64 64   f 644 Essex debt Kirkeby, John, of London Sewale, Roger, of London, brewer 97 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218173 64 64   f 502 Middx debt Kirkeby, John; Oudeby, William Burton, Richard, of Tuttebury; Caus, Robert 98 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218174 64 64   f 320 Yorks debt Kirkeby, Roger de, of York Reynardson, Simon, of Tykell 99 cp40_570_KZ.txt CP40/570 Trinity 1403   2026-01-13
2218175 64 64   d 1416 Yorks trespass: assault & imprisonment Kirkeby, Thomas, chaplain Slengesby, John, of Scardeburgh 100 cp40_570_KZ.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);