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,894 rows where roll_id = 18

✎ 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
1989559 18 18 f   5445 Herefs trespass: close A Glin, John, esq Lane, David, of Magna Marcle, chaplain; Aphoell, Hugh, of Yatton, husbandman 1 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989560 18 18 f   6354 Heref trespass: close A Glin, John, esq Lane, Roger, of Budwynhyll, husbandman; Cole, Richard, of Fownehope, husbandman; ap Hooll, John, of Yatton, husbandman 2 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989561 18 18 d   6831 Devon dower Abbott, Emma, widow of John Abbott Abbott, William 3 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989562 18 18 d   6700 Lincs defamation Abbott, Robert Kyrke, Thomas, of Morton, yeoman 4 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989563 18 18 d   7855 Lincs defamation Abbott, Robert Kyrke, Thomas, of Morton, yeoman 5 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989564 18 18 f   5191 Lincs debt Abbott, Robert Newcom, Richard, of Hawthrop, husbandman 6 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989565 18 18 d   6654 London debt Abbott, Robert Tharret, Robert, of Stalyngburgh, Lincs, husbandman 7 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989566 18 18 d   7072 Herts debt Abbott, William Cowper, Robert, of Watton, butcher; Bylls, James, of Stondon, horse courser 8 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989567 18 18 f   6322 Essex debt Abbott, William, executors of; (Hagger, John; Thurgood, John) Hoye, William, of Latton, yeoman 9 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989568 18 18 d   6912 Essex debt Abbott, William, executors of; (Hagger, John; Thurgood, John) Langham, William, of Stortford, Herts, butcher 10 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989569 18 18 f   5529 Essex trespass: park Abell, John Parke, Edward, of Horkesly Magna, husbandman; Parke, John, of Horkesly Magna, husbandman 11 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989570 18 18 f   6370 Essex trespass: close Abell, John Roos, Edward, of Naylond, gent 12 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989571 18 18 d   6916 Essex trespass: close Abell, John, gent Barnard, Henry, of Stoke juxta Neylond, Suff, husbandman; Barnard, William, of Stoke juxta Neylond, Suff, husbandman; Waryng, Thomas, of Wyston, Suff, husbandman; Lorkyng, Hugh, of Wyston, husbandman; Lorken, James, of Wyston, husbandman 13 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989572 18 18 d   6916 Essex trespass: close Abell, John, gent Hyntylson, John, of Stoke juxta Neylond, Suff, husbandman; Reddys, William, of Neylond, sherman; Swallowe, Thomas, of Neylond, sherman; Crowe, Robert, of Neylond, sherman 14 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989573 18 18 f   5530 Essex trespass: close Abell, John, gent Parke, John, of Horkesly Magna, husbandman; Parke, Edward, of Horkesly Magna, husbandman; Blakemore, John, of Horkesly Magna, husbandman; Jurden, Bartholomew, of Horkesly Magna, husbandman 15 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989574 18 18 f   5530 Essex trespass: close Abell, John, gent Planpen, John, junior, of Neylond, Suff, husbandman; Rychemond, Edward, of Neylond, husbandman; Mylles, John, of Stoke juxta Neylond, husbandman; Mylles, Richard, of Stoke juxta Neylond, husbandman 16 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989575 18 18 f   5212 Kent concord Abell, John, junior Stepkyn, Thomas 17 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989576 18 18 f   5497 London debt Abraham, Thomas, of London, leatherseller Coke, John, of Perott, Soms, yeoman 18 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989577 18 18 d   7201 London debt Abraham, Thomas, of London, leatherseller Hastynge, Francis, of London, knight, Lord Hastynge 19 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989578 18 18 d   7626 London debt execution Abraham, Thomas, of London, leatherseller Hastynge, Francis, of London, knight, Lord Hastynge 20 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989579 18 18 d   7200 London debt Abraham, Thomas, senior, of London, leatherseller Hastynge, Francis, of London, knight, Lord Hastynge 21 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989580 18 18 f   6322 Essex debt Aburfurthe, William Raymond, John, of Chyppyng Walden, shoemaker; Raymond, Anothy, of Chyppyng Walden, haberdasher; Warden, Leonard, of Matchyng, clerk; Palmer, William, of Ryckelyng, husbandman 22 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989581 18 18 d   7512 Worcs debt Acton, John, of Westewoodde, gent Combes, John, of Straford on Avon, gebnt 23 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989582 18 18 f   5765 Worcs debt Acton, Thomas, esq Carpenter, Richard, of Leomster, Heref, butcher; Carpenter, Thomas, of Myttylton, Heref, yeoman; Bagyer, Thomas,of Yarpole, Heref, tanner 24 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989583 18 18 f   5766 Worcs debt Acton, Thomas, esq Carpenter, Richard, of Leomster, Heref, butcher; Carpenter, Thomas, of Myttylton, Heref, yeoman; Bagyer, Thomas,of Yarpole, Heref, tanner 25 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989584 18 18 d   7513 Shrops waste Acton, William Oldherye, John; Joan his wife 26 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989585 18 18 d   7759 Beds debt Acworth, George, esq Tuckey, William, of Harlyngdon, husbandman; Pecokke, Thomas, of Westonyng, yeoman; Russell, Edward, of Ampthill, butcher 27 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989586 18 18 d   7298 London debt Acworth, Thomas, of London, merchant tailor Bulmer, William, of Pockelyngton, Yorks, gent 28 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989587 18 18 f   6432 Beds debt Acworthe, George, esq Hardyng, William, of Woodend, Harlyngdon, yeoman 29 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989588 18 18 f   5184 Essex debt Adams, Simon Fuller, Roger, of Harlowe, brewer 30 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989589 18 18 f   5429 Kent common recovery Ady, William Borne, Henry, esq 31 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989590 18 18 d   7533 Midd recognisance, writ of entry Adye, William Borne, Henry, of Dodyngton, Kent, esq 32 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989591 18 18 f   5369 Suff debt Age, Thomas Girlyng, William, of Burgh St Margaret, Norf, husbandman 33 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989592 18 18 d   6819 Cumber trespass: close Aglyonby, Edward Richardson, William, of Lynstoke, husbandman; Isabel his wife; Grame, Thomas, of Lynstoke, husbandman; Alice his wife; Nycolson, John, of Lynstoke, husbandman; Elizabeth his wife; Nycolson, Alice, of Lynstoke, spinster; Grame, John, of Lynstoke, husbandman; Janet his wife; Blakloke, Thomas, of Lynstoke, husbandman; Cecilia his wife; Nicolson, Robert, of Lynstoke, husbandman; Ellen his wife; Richardson, Christopher, of Lynstoke, husbandman; Mariotta his wife; Clerke, Edward, of Lynstoke, husbandman; Katherine his wife; Thomson, James, of Lynstoke, husbandman; Isabel his wife; Nycolson, Robert, of Lynstoke, husbandman; Janet his wife; Dowersten, Roland, of Lynstoke, husbandman; Ellen his wife; Nicolson, Christopher, of Lynstoke, husbandman; Isabel his wife: Richardson, Edward, of Lynstoke, husbandman; Elizabeth his wife; Blakeloke, Richard, of Lynstoke, husbandman; Marion his wife 34 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989593 18 18 f   5714 Norf debt Agthorp, Richard Adcok, William, of New Bokenham, beer brewer 35 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989594 18 18 d   7096 Norf   Akers, John, of Trowner Michelson, Andrew, of Cley juxta Mare, mariner; Webster, John, of Cley 36 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989595 18 18 f   5716 Norf debt Akers, Thomas Mychelson, Andrew, of Cley juxta Mare, mariner 37 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989596 18 18 d   7135 Worcs replevin Alam, George Harrys, John 38 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989597 18 18 d   7135 Worcs replevin Alam, George Stonall, Robert 39 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989598 18 18 f   5251 Surrey debt Albroke, John, executor of; (Hynkeley, Richard) Brokehall, James, of Eschear, husbandman; Braydelley, John, of Walton on Thames, laborer; Bysseck, John, of Walton on Thames, laborer 40 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989599 18 18 d   7030 Norf debt Aldam, Richard, of Pyrlstone alias Byllyngforth, executors of; (Goldyng, Christiane, of Eye, widow; Aldam, John, of Shymplyng) Lacy, Richard, of Hoxne, Suff, yeoman 41 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989600 18 18 d   7029 Norf debt Alden, Thomas Sherwyn, Nicholas, of Carleton, collarmaker; Launcetour, Robert, or Roydon, husbandman 42 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989601 18 18 d   7593 Wilts debt Aldeworth, Robert, junior Pen, John, of Wutton Bassett, husbandman 43 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989602 18 18 d   7655 Kent concord Aldey, James; Elizabeth his wife Peeke, Nicholas 44 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989603 18 18 f   6316 Suff concord Aldhowse, Thomas; Elizabeth his wife Aldhowse, Robert 45 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989604 18 18 f   6316 Suff concord Aldhowse, Thomas; Elizabeth his wife Bugge, Robert 46 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989605 18 18 f   5656 Norwich debt Aldryche, John, of Norwich, grocer Barker, John, of Aylesham, mercer 47 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989606 18 18 f   5655 Norwich debt Aldryche, John, of Norwich, grocer Gold, James, of Lytcham, mercer; Uityng(?), William, of Dekylburgh, mercer 48 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989607 18 18 f   5655 Norwich debt Aldryche, John, of Norwich, grocer Hyll, William, of Bongey, Suff, mercer 49 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989608 18 18 f   5861 London debt Aldwyn, Nicholas, of London, goldsmith Clyfford, Nicholas, of Sutton Valence, Kent, esq 50 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989609 18 18 f   6126 Kent debt Alee, John, of Sandwich, yeoman Mone, John, of Horton, yeoman, executors of; (Den, John, of Kyngyston, yeoman; Mone, Sampson, of Braborne, yeoman) 51 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989610 18 18 f   6126 Kent debt Alee, John, of Sandwich, yeoman Mone, John, of Horton, yeoman, executors of; (Den, John, of Kyngyston, yeoman; Mone, Sampson, of Braborne, yeoman) 52 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989611 18 18 f   5347 Shrops trespass: close Alen, Thomas Bebbe, William, senior, of St Margaret Clee, husbandman 53 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989612 18 18 d   7312 Norf   Alen, Thomas Comfort, John, of Cromer, mariner 54 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989613 18 18 d   6816 Lincs debt Alenson, John Chapman, Thomas, of Boston, butcher; Corby, Thomas, of Boston, butcher 55 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989614 18 18 d   7304 Norf debt Alexander, Thomas Wryght, Thomas, of Aslakton, yeoman; Ponyour, William, of Bury St Edmunds, freemason; Hambeleyn, William, of Pulham, thatcher; Ponyour, John, of Wacketon, husbandman 56 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989615 18 18 d   7184 Berks trespass: close Aley, Christine, widow Smythe, Richard, of Wyndesore, innholder 57 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989616 18 18 f   5561 Hunts debt Aleyn, Geoffrey, gent Dyxon, James, of Stylton, husbandman; Gryme, Robert, of Eryth, butcher; Stevyns, John, of Stylton, husbandman; Metcalfe, Henry, of Stylton, innholder 58 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989617 18 18 f   5666 Norf debt Aleyn, Geoffrey, gent Waller, Edward, of Lyrlyng, husbandman 59 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989618 18 18 f   6326 Herts debt Aleyn, John, executors of; (Corbett, John; Agnes his wife) Vinwell, William, of Barkewaye, baker 60 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989619 18 18 f   6257 Essex debt Aleyn, John, gent Hopton, John, of Feryng, husbandman 61 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989620 18 18 f   6160 Devon trespass Aller, Valentine Tokfeld, Richard, of Belston, husbandman 62 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989621 18 18 f   6521 Essex defamation Alleston, William, junior Calle, Roger, of Castle Hedyngham, butcher; Jegyn, John, of Castle Hedyngham, husbandman 63 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989622 18 18 f   5520 Essex defamation Alleston, William, junior Calle, Roger, of Castle Hedyngham, butcher; Jenyn, John, of Castle Hedyngham, husbandman 64 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989623 18 18 d   6630 Essex concord Alleyn, Robert; Joan his wife Harres, Ambrose 65 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989624 18 18 d   6756 Staffs debt Alleyne, Robert, of London, butcher, executors of; (Dalyson, William; Elizabeth his wife) Startyn, John, of Uttetur, jusbandman 66 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989625 18 18 d   7630 London debt Allott, Robert Tharrett, Robert, of Stalyngburgh, Lincs, husbandman 67 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989626 18 18 f   5625 Gloucester debt Allyn, Edward Evenysshe, Robert, of Barnewood, Gloucester, milner 68 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989627 18 18 f   5945 Norf debt Alpe, Thomas, of Dunham Parva, yeoman Mundye, John, of Magna Dunham, husbandman; Fyckes, Thomas, of Parva Dunham, husbandman 69 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989628 18 18 d   7705 Heref debt Alye, Richard, executrix of; (Alye, Joan, widow) Goodman, Richard, of Canon Pewen, yeoman; Lewes, John, of Webley, husbandman; Nycollys, Richard, of Morcott, husbandman 70 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989629 18 18 f   6312 Herts concord Alygh, Robert, senior Shurley, Thomas 71 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989630 18 18 f   6312 Kent concord Alygh, Robert, senior Shurley, Thomas 72 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989631 18 18 f   6312 Middlesex concord Alygh, Robert, senior Shurley, Thomas 73 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989632 18 18 f   6312 Surrey concord Alygh, Robert, senior Shurley, Thomas 74 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989633 18 18 f   6251 Surrey replevin Alygh, Thomas Shergold, Gavin; Awood, John, senior 75 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989634 18 18 d   7131 Worcs debt Alys, Richard Harryson, William, of Cadycrofte, yeoman 76 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989635 18 18 d   7303 Norf debt Alysander, Thomas, of Forncett, yeoman Sherwyn, James, of Aslacton, wheelwright; Sherwyn, Robert, of Carleton Rode, husbandman; Sherwyn, Robert, of Multon, wheelwright 77 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989636 18 18 f   5945 Norf debt Alysander, Thomas, of Fornecett, yeoman Seman, Robert, of Stratton Longa, husbandman; Seman, John, of Wymondham, husbandman; Woodereve, William, of Mornyngthorp, tailor; Saye, John, of Mornyngthorp, husbandman 78 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989637 18 18 f   5257 Surrey debt Ambros, Richard, of Cranley, clerk Bradshawe, William, of Litherland, Lancs, gent; Starkey, John, of Aghton, Lancs, gent; Morecroft, Brian, of Aghton, Lancs, clerk; Kyrkeby, Thomas, of Aghton, chaplain 79 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989638 18 18 d   6699 Lincs debt Amcotte, Alexander, of Anstroppe, esq Cobbyns, John, of Wynthorpe in the Marsh, laborer, executor of; (Thory, Robert, of Ingolmyles in the Marsh, yeoman) 80 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989639 18 18 f   5245 London debt Amcottys, Henry, of London, alderman Fynche, Nicholas, of Norton, Kent, gent 81 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989640 18 18 f   5245 London debt Amcottys, Henry, of London, alderman Grene, John, of Maldon, Essex, yeoman 82 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989641 18 18 d   7525 Midd recognisance, writ of entry Ameredith, Griffin, of Exeter, gent Hody, Richard, gent 83 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989642 18 18 d   7180 Soms common recovery Ameredyth, Griffin Hody, Richard, gent 84 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989643 18 18 f   5190 Kent debt Amoottys alias Hancott, Henry, of London, alderman Whytlok, Patrick, of Asperych, yeoman 85 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989644 18 18 d   7705 Heref debt Amore, John Golaber, John, of Elsdon, husbandman; Golaber, William, of Nesthend, Lynhales, husbandman; Bengore, Walter, of Spone, Erdysley, husbandman 86 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989645 18 18 d   7626 Devon debt Amore, John Helyer, John, of Exeter, yeoman 87 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989646 18 18 f   5680 Soms debt Amorey, Anthony Hoker, John, of Norton, clerk; Cape, Thomas, of Wellyngton, husbandman 88 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989647 18 18 d   7672 Herts debt Amps, George Archer, Thomas, of Barram Wod, Ilstrey, maltman; Est, John, of Pegsden, Shytlyngton, Beds, maltman 89 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989648 18 18 f   6423 Beds debt Amps, John Sylley, John, of Flytwyke, husbandman; Aleyn, Thomas, of Dunstable, shoemaker; Turnour, William, of Dunstable Houghton, "carier" 90 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989649 18 18 d   6876 Beds debt Amps, John Thorpe, William, of Dunstable, husbandman 91 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989650 18 18 d   6988 Staffs debt Amynton alias Mynton, John, executors of; (Gryme, Thomas; Mynton, Elizabeth) Chetwyn, John, of Kele, gent 92 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989651 18 18 f   6342 Kent partition Ancher, Anthony Hert, William 93 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989652 18 18 f   6191 Kent partition Ancher, Anthony Symondys, Thomasine, widow; Coppynger, Ralph 94 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989653 18 18 d   6645 London covenant Anderton, James, of Ewkeston, Lancs Porte, John, of Etwall, Derbs, esq 95 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989654 18 18 f   5698 Herts debt Andrew, Thomas Gyll, Peter, of Standon, horse courser 96 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989655 18 18 d   7736 Cams debt Andrewe, Agnes, of Hynton, widow, executor of; (Lambard, Robert) Rydley, William, of Hynton, husbandman; Redman, John, of Hynton, yeoman 97 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989656 18 18 d   7511 Devon debt Andrewe, John Southcote, John, of Were Gyfford, gent 98 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989657 18 18 d   6778 Kent common recovery Andrewe, John; Lome, William Colley, Thomas, of Dovorr, beer brewer 99 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16
1989658 18 18 f   5635 Hants trespass: close Andrewe, Maragret, widow Ketyswell, Christopher, of Sutton Bishop, husbandman; Rooke, Robert, of Sutton Bishop, husbandman; Parker, John, of Sutton Bishop, husbandman 100 cp40_1120.txt CP40/1120     Henry VIII 2026-01-16

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