home / cp40x

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

✎ 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
1935234 7 7 d   720 Herts debt (crease) Broke, William, of Braughyng, innholder; Quarteyn, Edward, of Braughyng, husbandman; Perle, John, of Braughyng, chapman 3 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935235 7 7 d   891 Norwich debt (crease) Reynham, William, of Stowbarfold, yeoman 4 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935236 7 7 d   28 Vacated debt (vacated) Fyssher, John, of Overton, Hants, clothmaker 5 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935237 7 7 d   939 Vacated dower (vacated) Sacheverell, Henry, knight; Vyllers, John, knight; Hasilrigge, Thomas, esq; Harvy, Thomas, esq; Palmer, Thomas, esq; Fowler, John; Armestrong, Alexander; Blounte, Christopher 6 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935238 7 7 f   1192 Notts debt (vacated), escheator of Notts FitzWilliam, John, of Sprodebarowe, Yorks, gent; Blode, John, of Plumtre, yeoman; Schepard, Elias, of Baseford, husbandman 7 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935239 7 7 f   1033 Vacated trespass (vacated), John Canynges, William, of Ircote, Ammesbury, husbandman 8 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935240 7 7 f   600 Vacated debt (vacated), John Wryght, Walter, of Teryngton, husbandman 9 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935241 7 7 d   1008 London debt (vacated), John, of Newcastle on Tyne, fuller Townesende, John, of Bery, Norf, esq 10 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935242 7 7 f   1163 Suff trespass: close (vacated), Radclyff, Robert, knight, Lord FitzWauter Gawgeer, Robert, of Long Melford, clothmaker 11 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935243 7 7 f   429 Vacated trespass: taking (vacated), Thomas Blakkaller, John, of Exeter, merchant 12 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935244 7 7 d   373 Vacated trespass: close (vacated), William; (vacated), Joan Burneford, John, of Lamerton, husbandman 13 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935245 7 7 f   586 Vacated debt (vacated); Nicholas, of Norwich, merchant Tante, William, of Langley, canon; Lowe, John, of Barnehambrome, husbandman; Debney, Gregory, of Barnehambrome, husbandman; Godsave, Hugh, of Carbroke, husbandman 14 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935246 7 7 f   1245 Wilts debt execution A Borowe, Thomas Bonde, John, of London, gent 15 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935247 7 7 f   473 Sussex covenant A Broke, John, of Lytlyngton Warnett, John, of Framfeld, gent 16 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935248 7 7 d   566 Kent debt A Burgh, Edward, knight; Anne his wife Saunder, Thomas, of Newhede, Est Mallyng, husbandman 17 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935249 7 7 d   122 London debt A Chamber, Richard, merchant of the staple Clopton, Henry, of London, merchant of the staple 18 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935250 7 7 f   559 Suff concord A More, William; Christine his wife Jermyn, Thomas, senior 19 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935251 7 7 f   113 Beds debt A Welde, William Tyler, John, of Luton, butcher 20 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935252 7 7 d   1023 Suff trespass: close A Woode, William Sparowe, Robert, senior, of Cheddbar, yeoman 21 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935253 7 7 d   301 Suff debt Abbott, Simon Pollyng, John, of Chellysworth, weaver 22 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935254 7 7 d   1038 Suff debt Abell, Anne, of Stoke Naylond, widow Deane, John, of West Barfold, Essex, husbandman; George, John, of Lexden, Essex, husbandman; Malle, John, of Naylond, clothier 23 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935255 7 7 f   375 Essex trespass: close Abell, Anne, widow Sparyn, Thomas, of Berfold, husbandman; Snowdon, John, of Barfold, husbandman 24 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935256 7 7 f   160 London debt Abell, John, of Neylond, Suff, clothman, executor of; (Bonham, Thomas, esq) Seyntpere, William, of London, merchant tailor; Boyvyle, Richard, of London, merchant tailor; Power, Thomas, of London, grocer, gent 25 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935257 7 7 f   1078 Vacated debt Abell, John, senior, executor of Davy, Joan, of Naylond, widow, executor of; (Bonham, Thomas) Abell, John, junior, of Naylond, merchant, administrators of; (Bacon, Thomas, of Hesset, Suff, gent; Anne his wife) 26 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935258 7 7 f   939 Lincs debt Acres, Thomas Gyldon, Thomas, of Aswarby, husbandman 27 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935259 7 7 d   697 London debt Acton, Hugh, of London, merchant tailor Empson, Thomas, of Abthorp, Nhants, gent 28 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935260 7 7 f   289 Yorks debt execution Acton, Hugh, of London, merchant tailor Gascoynge, William, of Harwoode, knight 29 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935261 7 7 d   695 London debt Acton, Hugh, of London, merchant tailor Nevell, Thomas, of Rolston, Notts, esq; Lacy, Henry, of Grauncester, Cams, gent; Kebyll, Thomas, of Colchester, clothman 30 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935262 7 7 f   125 London debt Acton, Hugh, of London, merchant tailor Nevell, Thomas, of Rolston, Notts, esq; Lacy, Henry, of Grauncester, Cams, gent; Kebyll, Thomas, of Colchester, clothman; Empson, Thomas, of Abthorpe, Nhants, gent 31 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935263 7 7 d   868 Kent debt Acton, John, of Chart juxta Sutton Valence Grangeman, William, of Borden, husbandman 32 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935264 7 7 d   103 Berks debt Acton, Thomas, clerk Mason, Thomas, of Hungerford, mercer 33 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935265 7 7 d   545 Norf trespass: close Adam, Richard Goolde, Edmund, of Tylney, husbandman 34 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935266 7 7 d   904 Herts debt Adam, Thomas; Adam, John, of Sabrychesworth, husbandman Hochyn, Thomas, of Stondon, husbandman; Waren, John, of Stondon, smith 35 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935267 7 7 d   510 Herts concord Adams, Agnes, daughter of Couper, William, kinsman of Couper, John, of Wygynton; Carter, Thomas; Margaret his wife, daughter of Couper, William Lamburn, Edward 36 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935268 7 7 f   363 Staffs trespass: close Adams, Humphrey Turner, Thomas, of Brynton, husbandman; Bradhurste, William, of Brynton, husbandman; Turner, John, senior, of Brynton, husbandman 37 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935269 7 7 d   1170 London debt Adams, John Creas, John, of Weston, Soms, clerk 38 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935270 7 7 d   1031 Suff trespass: close Adanys or Adamys, William Roket, Nicholas, of Gorleston, plough wright 39 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935271 7 7 f   594 Norf debt Adcok, John, clerk Greye, Robert, of Wikelwode, miller; Gisborn, Florence, of Hengham, mercer; Wright, Richard, of Depeham, husbandman 40 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935272 7 7 f   154 London debt Adyngton, Thomas, of London, skinner Fayrefax, William, of Steton, Yorks, esq; Nores, Henry, of Est Grenewyche, Kent, esq; Draper, William, of Est Grenewyche, gent 41 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935273 7 7 f   198 London debt Adyngton, Thomas, of London, skinner Gylford, Henry, of Ledys, Jent, knight 42 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935274 7 7 d   114 London debt Adyngton, Thomas, of London, skinner Gylford, Henry, of Ledys, Kent, knight 43 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935275 7 7 d   1105 Herefs trespass: close Adys, John Leche, John, of Luy de Priour, husbandman; Leche, John, of Sheylwyke, husbandman 44 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935276 7 7 d   1046 Lincs trespass: close Aiermyn, William Ovyn or Obyn, John, of Repynhall, husbandman 45 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935277 7 7 f   1227 Norf trespass: close Akers, John Elger, John, of Seggeford, yeoman 46 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935278 7 7 f   1227 Norf trespass: close Akers, John Ryckys, William, of Hecheham, yeoman; Blaksmyth, Thomas, of Hecheham, yeoman; Manser, William, of Hecheham, yeoman 47 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935279 7 7 d   587 Kent debt Alatson, William Woldregge, Robert, of Eynesford, husbandman 48 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935280 7 7 f   1298 Soms trespass: close Alatt, Randolph; Eleanor his wife Laughwell, Michael, of Selleworthy, butcher; Rowe, John, of Luckum, butcher 49 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935281 7 7 f   332 Suff trespass: close Albright, Peter Wellys, John, of Stradbroke, carpenter; Pulham, John, of Stradbroke, carpenter 50 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935282 7 7 f   1199 Warks debt Aldesworth, Robert, rector of Bysshoppis Hampton Baker, John, of Solyshole, chaplain 51 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935283 7 7 f   376 Essex debt Aldowse, William, of Colchester, yeoman Breton, William, of Wykes, or of Colchester, gent 52 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935284 7 7 d   674 Cornw trespass: close Alee, Thomas Rovell or Ronell, Richard, of Pennemell, husbandman; Rovell or Ronell, James, of Pennemell, husbandman; Rede, Roger, of Pennemell, husbandman 53 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935285 7 7 d   889 Yorks trespass: close Alen, John Flemyng, Reginald, of Selby, butcher; Browne, Thomas, of Selby, husbandman; Marshall, John, of Braton, husbandman; Ryall, Richard, of Braton, husbandman; Burdousse, John, of Burton, husbandman 54 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935286 7 7 f   181 London debt Alen, Roger, of London, haberdasher Shawe, Humphrey, of Bulvan, Essex, yeoman; Yong, John, of Wallyngton, Soms, chapman; Yong, John, of Wallyngton, dyer; Inold, William, of London, chaplain, master of Harte 55 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935287 7 7 d   37 Devon concord Alenger, Richard; Alice his wife Bagge, John 56 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935288 7 7 d   229 Lincs common recovery Alenson, John Percy, Henry 57 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935289 7 7 d   538 Norf trespass: close Alenson, Thomas Marten, William, senior, of Walpole, husbandman; Rawlyn, William, of Walpole, husbandman; Neale, Simon, of Walpole, husbandman; Marten, William, junior, of Walpole, husbandman; Stephynson, John, senior, of Walpole, husbandman 58 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935290 7 7 f   1220 Norf debt Aleyn, Edmund, clerk Hall, Thomas, of Erpyngham, husbandman; Fyssher, John, of Itryngham, husbandman 59 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935291 7 7 d   764 London debt Aleyn, John, of London, alderman Hogeson, Robert, of Wassand, Yorks, gent 60 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935292 7 7 d   1122 London debt Aleyn, John, of London, alderman White, John, of Esternewike, Holdernes, Yorks, yeoman 61 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935293 7 7 f   685 Derbs common recovery Aleyn, John, of London, alderman; Baker, John, gent; Rice, Simon; Plymley, Alexander, of London, mercer; Harryson, John, clerk Styrley, James, of London, vintner 62 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935294 7 7 f   684 Suff common recovery Aleyn, John, of London, alderman; Baker, John; Rice, Simon; Plymley, Alexander; Harryson, John, clerk Blyant, Richard 63 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935295 7 7 d   144 London debt Aleyn, Thomas, of London, skinner, executors of; (Hall, John; Mary his wife) Huse, William, of North Duffeld, Yorks, knight; Broun, Mathew, of Croydon, Surrey, knight; Darknall, Robert, of Canterbury, gent; Bele, Henry, of London, gent; Hillersdon, John of London, gent 64 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935296 7 7 f   210 Norf debt Aleyn, William, executors of; (Hardyngham, John; Mary his wife) Fenne, Robert, of Hadleigh, Dsuff, yeoman 65 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935297 7 7 d   833 Lincs trespass: taking Alger, Richard Tomson, John, of Wygtoft, husbandman; Grice, Thomas, of Algerkyrk, husbandman 66 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935298 7 7 d   605 Kent debt Alletson, William Woldregge, Robert, of Eynesford, husbandman 67 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935299 7 7 f   91 Wilts trespass: close Alryge, William Wheteacre, Richard, of Bratton, clothier 68 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935300 7 7 d   411 Nottingham account as receiver Alynson, John Inglysh, William, of Nottingham, merchant 69 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935301 7 7 d   359 Nottingham debt Alynson, John Watson, William, of Nottingham, butcher; Bery, John, of Tyknall, Derbs, husbandman 70 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935302 7 7 f   1227 Norf debt Alysaunder, of Bishops Lenn, yeoman Barnesdale, John, of Darsyngham, yeoman; Mabbys, Geoffrey, of Waterden, husbandman 71 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935303 7 7 d   875 Kent debt Alysson, George Bedford, Quintin, of Chartham, husbandman; Burgeis, Thomas, of Molysshem husbandman; Hardeman, Moise, of Chilham, yeoman 72 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935304 7 7 d   123 London debt Amadas, John, yeoman of the guard Poynys, Anthony, of London, knight; Raynysforthe, John, of London, knight 73 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935305 7 7 d   137 London debt Amcott, Henry, of London, stockfishmonger Bradford, Ralph, of Barwyke on Twede, Northumb, merchant 74 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935306 7 7 d   875 Kent debt Amyas, Richard Chapman, William, of Cheryngton, tailor; Childe, Simon, of Molasshe, husbandman; Taylour, Robert, of Lynsted, husbandman; Feverer, Robert, of Mynster, Isle of Sheppey, weaver 75 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935307 7 7 d   876 Kent forcible entry Amyas, William Brentt, William, of Wyllesbourgh, gent 76 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935308 7 7 d   828 Lincs debt Anderson, John, executors of; (Anderson, Alice, widow; Anderson, Peter; Anderson, William) Rawlynson, William, of Est Rasyn, glover 77 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935309 7 7 f   491 Lincs trespass: close Anderson, Thomas Baynton, George, of Theleby, husbandman 78 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935310 7 7 f   1244 Kent concord Andrewe, George; Margaret his wife Ongley, Richard 79 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935311 7 7 f   37 Hants trespass: close Andrewe, John Walyson, Christopher, of Alton Westbroke, yeoman; Smyth, William, of Est Wardlam, yeoman; Gore, Richard, of Alton Estbroke, tailor; Bygnale, John, of Alton Estbroke, tailor 80 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935312 7 7 d   538 Norf trespass: close Andrewe, Richard Ketyll, Robert, of Tyrryngton, husbandman; Nycolson, Robert, of Walpole, husbandman; Gyrdeyn, Thomas, of Walpole, husbandman 81 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935313 7 7 d   28 London debt Andrewe, Richard, administrator of; (Warcop, Thomas) Flynt, John, of Abyndon, Berks, draper 82 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935314 7 7 d   697 London debt Andrewe, Richard, administrator of; (Warcop, Thomas) Flynt, John, of Abyngdon, Berks, draper 83 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935315 7 7 d   1027 Suff debt Andrewe, Thomas Sekker, John, of Bury St Edmunds, husbandman; Gryffyn, William, of Bury St Edmunds, husbandman; Smyth, William, of Exnyng, husbandman; Danbrye or Daubrye, John, of Exnyng, husbandman 84 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935316 7 7 d   440 Kent replevin Andrewe, William Comer, Richard 85 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935317 7 7 f   1239 Hants debt Andrewes, Richard Bacheler, John, of Charlecote, husbandman 86 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935318 7 7 f   131 London debt Andrews, Richard, gent Aprece, Robert, of Wassyngley, Hunts, gent 87 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935319 7 7 f   1254   trespass: close Androwis, Thomas Hochyns, Alice, of Meane, widow 88 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935320 7 7 d   266 Wilts trespass: assault Anewyk, William Rose, Thomas, of Pewsey, tailor 89 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935321 7 7 d   482 Cornw debt Angay or Augay, Thomas, executor of; (Pawley, Stephen) Polglace, Robert, of Nanssavallan, Kynwyn, husbandman 90 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935322 7 7 d   1084 Norf debt Anger or Auger, John Revett, John, of Hengham, barker; Baxter, Stephen, of Hengham, butcher 91 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935323 7 7 d   1091 Norf debt Annott, Thomas Pylgryme, Thomas, of Sheryngham, mariner 92 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935324 7 7 d   489 Worcs debt Anslet or Auslet, Thomas Hyll, Nicholas, of Bromesgrove, laborer; Chamber, Richard, of Astewod, or of Dudderhyll, husbandman; Wylde, John, of Astewod, husbandman 93 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935325 7 7 f   83 Wilts trespass: close ap Gwyllams, John Sargeaunt, John, of Sevyngton, Lygh, husbandman; Sargeaunt, Robert, of Ryles, Lygh, husbandman 94 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935326 7 7 d   1009 London debt ap Howell, John, of London, mercer Knyvet, William, of King's household, Est Grenewyche, Kent, gent; Cottesmore, John, of Bryttwell, Oxon, gent; Michelson, Patrick, of London, draper; Everton, Humphrey, of Wethersett, Suff, gent; Poeley, Robert, of Donyngton, Suff, gent 95 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935327 7 7 f   520 Herefs debt ap Jenn, Morgan Dyer, William, of Oxford, bachelor of arts 96 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935328 7 7 d   1098 Shrops trespass: close ap Owen, David, clerk Grace, Adam, of Oswester, March of Wales, yeoman 97 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935329 7 7 d   479 Shrops trespass: close ap Owen, David, clerk Grace, Adam, of Oswester, March of Wales, yeoman 98 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935330 7 7 d   33 Shrops trespass: close ap Owen, David, clerk Grace, Adam, of Oswester, March of Wales, yeoman 99 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935331 7 7 f   1296 Soms debt ap Res, John, of Newensey, mercer Yong, John, of Est Brent, yeoman 100 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935332 7 7 d   85 Wilts trespass: taking ap Rise, Maurice Knave, John, of Bratton, butcher 101 cp40_1049.txt CP40no1046   1526 Henry VIII 2026-01-15
1935333 7 7 d   1089 Norf debt Aple, Thomas Taylour, John, of Tybenham, husbandman 102 cp40_1049.txt CP40no1046   1526 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);
Powered by Datasette · Queries took 40.872ms