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,059 rows where roll_id = 2

✎ 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
1907408 2 2 d   872 Kent trespass: close (Crease) Rayne, John, of Merworth, husbandman 1 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907409 2 2 f   867 Beds common recovery A Brigges, John, knight; Baynam, Christopher, knight; Rudhale, William; Russell, John; Wye, Richard; Clyfford, James, gent Throkmarton, Robert, knight 2 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907410 2 2 f   871 Bucks common recovery A Brigges, John, knight; Baynam, Christopher, knight; Rudhale, William; Russell, John; Wye, Richard; Clyfford, James, gent Throkmarton, Robert, knight 3 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907411 2 2 f   987 Sussex trespass: abduction A Broke, Ingeleram; Alice his wife Patynden, Walter, of Lambherst, yeoman 4 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907412 2 2 d   460 Glos debt A Dene, Thomas, of Barton Dobyns, Robert, of Dumbulton, husbandman 5 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907413 2 2 f   1004 Dorset debt A London, John, of Sherborn, clothier Tyson, Thomas, of Bristol, merchant 6 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907414 2 2 f   1179 Herts trespass: close and assault Abbot, John Sowet, Thomas, of Hoddesdon, maltman 7 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907415 2 2 d   804 London debt Abbott, Thomas, executors of; (Hanby, William; Margaret his wife) Talmache, Robert, of Ottley, Suff 8 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907416 2 2 f   538 Derbs debt Abbotte, William; Hunter, Edmund; Wycam, Richard; Shyrwode, William Selyok, Richard, of Nottingham, bellfounder 9 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907417 2 2 f   706 Norf   Abbys, James, rector of Brancastre, son of Abbys, Robert Smyth, William, knight 10 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907418 2 2 f   57 York trespass: close Abney, Thomas Fonneby, John, of York, merchant 11 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907419 2 2 d   50 Yorks debt Abney, Thomas Griswett, William, of Hemmesley, mercer 12 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907420 2 2 d   357 Cams debt Abraham, Robert Soylard, William, of Litlington, husbandman 13 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907421 2 2 f   483 Lincs trespass: taking Abraham, Roland, executor of; (Warbarton, William) Feld, Henry, of Morton juxta Burne, husbandman 14 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907422 2 2 f   88 Devon debt Abrey, Richard Fooke alias Faux, Robert, of Colampton, chapman 15 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907423 2 2 f   402 London debt Achylley, Roger, of London, draper Mynell, William, of London, draper; Buers, Robert, of Shefford, Beds, esq; Hilbill, Richard, of London, tailor 16 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907424 2 2 d   955 London debt Acton, Hugh, of London, merchant tailor Rush, Thomas, of Ipswich, gent 17 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907425 2 2 d   342 London debt Acton, Hugh, of London, merchant tailor Tryste, Thomas, of Cambulton, Beds, gent; Wyntersall, William, of London, yeoman; Orwell, John, of Newport, Isle of Wight, yeoman; Willoughby, Edward, of London, gent; Willebe, Richard, of London, gent 18 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907426 2 2 f   401 Cams debt Adam, Nicholas, of Walden, Essex, grocer, administrators of; (Dowson, John; Joan his wife) Flakke, John, of Balsham, husbandman; Nayller, John, of Balsham, husbandman; Barton, John, of Balsham, gent; Hosteler, Robert, of Babraham, husbandman 19 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907427 2 2 d   152 Essex debt Adam, Nicholas, of Walden, grocer, administrators of; (Dowson, John; Joan his wife) Wandyr alias Saunder, John, of Cambridge, haberdasher; Coke, John, of Radwynter, husbandman 20 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907428 2 2 d   37 Yorks trespass: close Adam, Richard Pygard, Thomas, of Bramham, yeoman 21 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907429 2 2 d   388 Oxon debt Adams, Maurice, clerk Bedford, Thomas, of Tettesworth, yeoman 22 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907430 2 2 f   476 Nhants debt Adams, Thomas Goodall, Robert, abbot of Sulby Abbey 23 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907431 2 2 f   66 Yorks trespass: assault Adcok, Thomas, chaplain Dale, William, of Norton, sherman; Grymbald, Robert, of New Malton, tanner 24 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907432 2 2 f   663 Middx debt Adyson, Reginald, of Tempyll Dynsley, Herts, yeoman Lorkyn, John, of St Clement Danes, butcher 25 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907433 2 2 d   742 Yorks entry sur disseisin Alanson, Christopher Warde, William 26 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907434 2 2 f   483 Lincoln debt Alanson, Robert, of Lincoln, jeweler Sawne, William, of Tewittefeld, Warton, Lancs, yeoman 27 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907435 2 2 d   920 Essex trespass Alburgh, Robert Naylyngherst, James, of Magna Badowe, gent; Theyer, Nicholas, of Magna Badowe, husbandman; Cok, Thomas, of Magna Badowe, whitawer; Bankys, Thomas, of Magna Badowe, tailor; Onghon, James, of Magna Badowe, pulter; Sturgeon, William, of Magna Badowe, tanner; Sturgeon, John, of Magna Badowe, laborer; Sturgeon, Ralph, of Magna Badowe, pulter; Sturgeon, Robert, of Magna Badowe, whitawer 28 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907436 2 2 d   344 London debt Alcock, Thomas, of Hartefeld, Sussex, yeoman Thomlyn, Richard, prior of Tunbrigge Priory 29 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907437 2 2 d   891 Sussex debt Alcoke, Thomas Porter, William, of Hertlepe, Kent, yeoman 30 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907438 2 2 f   1062 Suff replevin Alderton, Edmund Ketyll, Richard 31 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907439 2 2 d   856 Suff debt Aldyreche, William, of Great Yarmouth Calthorp, Robert, senior, of Becclys, butcher 32 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907440 2 2 f   994 Kent debt Alen, Alice, of Sutton at Hone, widow, executors of; (Levendale, Stephen; Joan his wife) Whyte, Richard, of St Mary Crey, barber; Maynard, John, of North Cray, carpenter, executrix of; (Maynard, Joan, of North Cray, widow) 33 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907441 2 2 f   58 Yorks trespass: close Alen, William Mascall, Robert, of Bracton, husbandman; Marshall, John, of Bracton, husbandman 34 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907442 2 2 d   786 London debt Aleyn, John, of London, armorer, owner of ship, Le Mary Aleyson of Suthwerk Saunderson, Stephen, of London, fishmonger 35 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907443 2 2 f   1109 Gloucester debt Aleyn, Ralph, of London, grocer Gloucetur, Thomas, of Gloucester, merchant 36 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907444 2 2 f   398 London debt Aleyn, Roger, of London, haberdasher Heret, Peter, of Southwerk, dyer 37 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907445 2 2 f   935 Norf debt Aleyn, Thomas Vyncent, Godfrey, of North Tudenham, husbandman; Foster, William, of Est Derham, husbandman 38 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907446 2 2 f   1178 Herts trespass: close Aleyn, Thomas, of Betlowe Duncombe, William, of Tyscote, husbandman 39 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907447 2 2 f   692 Suff common recovery Alferey, William; Maynard, John, junior; Saxpays, Robert Gyldrygge, Robert 40 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907448 2 2 d   41 Devon trespass Allerton, Thomas; Prater, Nicholas Houghton, John, of Paynton, husbandman; Isabel his wife; Adam John, of Paynton, husbandman 41 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907449 2 2 d   414 Oxon debt Alseys, Richard, administrators of; (Ansty or Austy, John; Okbanke, Thomas) Archer, Elizabeth, of Henley on Thames, widow 42 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907450 2 2 f   742 Norf debt Amfles, Richard, of Bishops Lenn, merchant, executor of; (Amfles, Robert) Tasseborowe, Robert, of Yarmouth, yeoman 43 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907451 2 2 f   743 Norf debt Amfles, Robert, of Lenne Sutton, Thomas, of Sowold, Suff, merchant 44 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907452 2 2 f   1165 Kent concord Amys, Thomas; Joan his wife Meyne, John, gent 45 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907453 2 2 f   994 Kent debt Andrewe, William Nicholas, Roger, of Syddyngborn, husbandman; Chaplyn, Simon, of Syddyngborn, butcher; Alen, Geoffrey, of Bredgare, husbandman; Ryccard, Robert, of Middylton, butcher; Waden, William, of Tong, husbandman 46 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907454 2 2 f   973 Kent debt Andrewe, William Nicholas, Roger, of Syddyngborn, husbandman; Chaplyn, Simon, of Syddyngborn, butcher; Aleyn, Geoffrey, of Bredgare, husbandman; Ryccard, Robert, of Myddylton, butcher; Waden, William, of Tong, husbandman 47 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907455 2 2 f   144 Herts debt Andrewe, William, senior Hamond, Roger, of Westmyll, husbandman 48 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907456 2 2 d   395 Berks debt Andrewes, Thomas Alen, Thomas, of Redyng, butcher 49 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907457 2 2 f   432 Oxon debt Andrewes, Thomas, of Islep Chaundeler, John, of Dunstewe, yeoman 50 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907458 2 2 d   1037 Cams debt Anger or Auger, Robert Ayshton, Nicholas, of Knapwell, yeoman 51 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907459 2 2 f   517 Herefs trespass: close ap Harry, Thomas Sylly, John, of Dernedale, husbandman 52 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907460 2 2 d   467 Herefs debt ap Howell, Lewis Tayllour, Thomas, of Noke, husbandman; Philippys, John, of Pembrugge, butcher; Garwey, Geoffrey, of Noke, husbandman 53 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907461 2 2 f   174 Oxon trespass: taking ap Ryce, Richard Lygon, Richard, of Arle, Glos, gent; Kynner, John, of Arle, yeoman 54 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907462 2 2 f   762 Norf debt Applyard, Nicholas, knight Andrewes, Walter, of Hengham, hardwareman 55 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907463 2 2 f   634 Norwich formadon descender Applyerd, Nicholas Curson, Richard 56 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907464 2 2 d   85 Bucks debt Apprice, Walter, of London, draper Grey, Richard, Earl of Kent 57 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907465 2 2 f   1156 London debt Apprice, Walter, of London, draper Grey, Richard, Earl of Kent, knight 58 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907466 2 2 d   532 Lincs debt Aquara, John, clerk Nelson, William, of Belcheforth, husbandman; Nelson, Miles, of Belcheforth, husbandman; Whryght, Robert, of Hornecastell, yeoman 59 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907467 2 2 d   510 Herts trespass: assault Archer, Robert Felle, William, of Evelden, Beds, clerk 60 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907468 2 2 d   453 Worcs debt Archer, William Walker, John, of Erston, husbandman 61 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907469 2 2 f   1056 London covenant Archer, William, of London, brewer Wryght, William, of Barkewey, Herts, husbandman 62 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907470 2 2 d   390 Bucks debt Ardern, John Cooper, John, of Hamelden, husbandman; Kene, John, of Turvyle, husbandman 63 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907471 2 2 d   476 Worcs debt Ardern, John Tayllour, John, of Littull Inkebarowe, husbandman 64 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907472 2 2 d   394 Oxon debt Ardern, John Wytney, William, of Henton, Chinnor, husbandman; Wytney, Richard, of Henton, Chinnor, husbandman 65 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907473 2 2 f   60 Yorks trespass: close Arksey, Robert Wyse, William, of Neswyk, shepherd 66 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907474 2 2 d   879 Kent debt Arkynbold, John Bachellar, John, of Smarden, husbandman; Peynter, Alexander, of Horsmonden, clothmaker 67 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907475 2 2 f   973 Kent debt Arkynbold, John Venor, John, of Est Mallyng, husbandman 68 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907476 2 2 f   836 Essex debt Armerer, Richard Heyward, John, of Fernam, husbandman 69 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907477 2 2 f   138 Bucks trespass Armesby, William Daffey, John, of Newport Paynell, yeoman 70 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907478 2 2 f   37 Wilts trespass: assault Arnesham, John Swanneborough, John, of Salisbury, cordwainer; Smyth, William, of Fyssherton Anger, yeoman; verton, John, of Fyssherton Anger, yeoman 71 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907479 2 2 d   125 Kent debt Arnett, Richard Munde, John, of Strode, pardoner 72 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907480 2 2 d   662 Hants replevin Arnewode, John Curle, William; Perys, Thomas, junior; Curle, John, senior 73 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907481 2 2 f   611 Suff concord Arnold, Andrew; Christine his wife Smyth, John 74 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907482 2 2 d   848 Suff debt Arnold, John Arnold, William, of Blundeston, husbandman 75 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907483 2 2 f   1111 Norf trespass: close Arnold, William Parret, Thomas, of Crowmer, mariner 76 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907484 2 2 f   1176 London debt Arnwey, Robert, merchant of the staple Garyngton, John, of Munden, Essex; Garyngton, John, of London, draper 77 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907485 2 2 d   835 Worcs   Arthern, John, esq Taylour, John, of Lytyl Inteberogh, husbandman 78 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907486 2 2 f   192 Suff debt Arundell, Joan, widow Water, Digory, of Talent, Cornw, clerk 79 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907487 2 2 d   614 Wilts debt Arundell, John, knight Bettys, Lewis, of Westbury, miller 80 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907488 2 2 d   468 Cornw incitement Arundell, John, of Talvern, esq Trolaston, Ralph, of Grogcyth, husbandman 81 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907489 2 2 d   1013 London debt Ascue, Christopher, of London, draper Merydale, Humphrey, of Magna Brykhyll, Bucks, yeoman; Gryffyn, John, of Parva Brykhyll, Bucks, yeoman; Button, Ralph, of Ampthyll, Beds, yeoman 82 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907490 2 2 f   146 Herts debt Ascue, Roger Ansell, Andrew, of Harpden, husbandman 83 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907491 2 2 d   532 Lincs debt Ascue, William, knight Richardson, Thomas, of Kelby, husbandman 84 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907492 2 2 f   568 Derbs trespass: park Ashby, John, abbot of Derley Abbey Zouche, David, of Codnore, gent 85 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907493 2 2 d   519 Derbs trespass: close Ashby, John, abbot of Derley Abbey Zouche, David, of Codnore, gent 86 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907494 2 2 d   634 Sussex debt Ashdowne, John, prior of Lewes Priory Baggecroft, Simon, executor of; (Baggecroft, William, of Bexwell, Norf, yeoman) 87 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907495 2 2 f   792 London debt Ashdowne, John, prior of Lewes Priory Guldeford, Edward, of Rolvynden, Kent, knight; Guldeford, George, of Rolvynden, esq; Gage, John, of Rolvynden, esq 88 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907496 2 2 d   706 Sussex debt Ashdowne, John, prior of Lewes Priory Haver, Richard, prior of Hatfeld Regis Priory 89 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907497 2 2 f   785 Sussex debt Ashdowne, John, prior of Lewes Priory Walhede, Thomas, of Parva Canfeld, Essex, clerk 90 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907498 2 2 f   1016 Soms debt Ashe, Richard, of Tykenham, esq Styver, Humphrey, of Weston juxta Briggewater, gent, executrix of; (Styver, Agnes, of Weston juxta Briggewater, widow) 91 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907499 2 2 d   741 Yorks trespass: close Aske, Robert Assheton, Robert, of Lathome, husbandman; Carlill, Robert, of Lathome, husbandman; Beilby, Robert, of Ellerton, husbandman; Broune, John, of Ellerton, husbandman 92 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907500 2 2 d   65 Yorks trespass: close Askwith, Richard Rede, Christopher, of Sigston, yeoman; Rede, Margaret, of Carlton, widow 93 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907501 2 2 d   65 Yorks trespass: close Askwith, William Bayn, John, of Masham, yeoman 94 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907502 2 2 d   846 Suff debt Aslak, William Monkey, John, of Lowestoft, tailor 95 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907503 2 2 f   306 Kent common recovery Asshe, Edward Willard, Richard 96 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907504 2 2 f   390 London debt Asshe, Humphrey, of London, haberdasher, administrator of; (Asshe, John, gent) Longmede, Nicholas, of London, merchant; Prowde, John, of London, haberdasher; Pote, Robert, of London, parish clerk; Northbroke, John, of Exeter, merchant; Broke, John, of Oxford, merchant 97 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907505 2 2 f   665 Middx debt Asshebroke, Robert, of Chepyng Wycombe, Bucks Lorkyn, John, of St Clement Danes, butcher 98 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907506 2 2 d   489 Leics trespass: taking Assheby, William Salysbury, Henry, of Byttysby, husbandman 99 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15
1907507 2 2 f   1201 Suff debt Asshefeld, George, esq Wyngfeld, Thomas, of London, gent; Yole, John, of Bury St Edmunds, carrier 100 cp40_1013.txt CP40no1013   1516 Henry VIII 2026-01-15

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