cases
- 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).
371 rows where roll_id = 19
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1999015 | 19 19 | f | 97 | Devon | trespass | Abbott, William | Kyne, Jeremy, of Hertland, husbondman | 1 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999016 | 19 19 | f | 74 | London | debt | Aborowgh, John, of London, mercer | Smyth, Thomas, of Scardeburgh, Yorks, gent; Conyers, Christopher of Scardeburgh, Yorks, gent | 2 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999017 | 19 19 | f | 35 | Staffs | debt | Acton, Edward, esq, of Norton, executor of; (Lyttelton, Edward, esq) | Gilbert Talbott, knight, execs of; (Talbott, John, of Grafton, Worcs, knight; Talbott, Humfrey, of Bromesgrove, Worcs, gent); Wynter, Roger, esq, execs of; (Hungerford, Anthony, Down Ampney, Wilts, knight; Talbott, Lady Margaret, of Grafton, widow); Wheler, John, of Hampton Lovett, Worcs, gent, exec of; (Wheler, Gilbert, of Rollewryght, Oxon, gent) | 3 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999018 | 19 19 | d | 201 | Sussex | concord | Affennell, Thomas; Alice, his wife | Banyster, Edward | 4 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999019 | 19 19 | d | 234 | London | debt | Amcotte, Henry, of London, Alderman | Fawkan alias Fawcaner John, of Lincoln, fishmonger and innholder | 5 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999020 | 19 19 | d | 203 | Devon | trespass | Andrewe, William | Marle, William of Toryton Magna, cordwainer | 6 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999021 | 19 19 | f | 64 | London | debt | Ansten, Robert, of London, grocer | Kyngston, Anthony, of London, knight; Yong, Roger, of Basylden, Berkshire, gent | 7 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999022 | 19 19 | f | 31 | London | debt | ap Benett, Llewellyn ap Meredyth ap Res | Bradford, Robert, of Brymyngham, Warw, shoemaker | 8 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999023 | 19 19 | f | 42 | Staffs | debt | Ardern, Nicholas, of Elford, gent | Huddelston, Richard, of Elford, esq | 9 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999024 | 19 19 | d | 210 | Soms | concord | Arundell, Thomas, knight; Margaret, his wife | Horner, John, senior, esq | 10 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999025 | 19 19 | d | 219 | Shrops | debt | Aspley, Richard | Broke, Henry of Wrynehyll, Staff, gent | 11 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999026 | 19 19 | d | 261 | Cams | debt | Asshe, John, of London, grocer, executor ofs; (Asshe, Elianor alias Ellen, widow, formerly wife of John; Asshe, Thomas, brother of John Asshe) | Marten, John, of Lyckelton, husbandman | 12 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999027 | 19 19 | f | 104 | Kent | partition | Asten, Robert; Asten, Edward | Asten, John; Asten, Henry; Asten, Mathew | 13 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999028 | 19 19 | f | 39 | Shrops | concord | Astyn, William; Anne, his wife | Broke, Robert | 14 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999029 | 19 19 | d | 222 | London | debt | Averell, Bartholomew, of London, haberdasher | Hewetson alias Dent, John, of Richemount, Yorks, merchant; Dente, Richard, of Melmerby, Coverdale, yeoman | 15 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999030 | 19 19 | f | 89 | Yorks | common recovery | Awodd, John; Thorneton, Robert | Thwyng, Marmaduke, gent | 16 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999031 | 19 19 | f | 40 | Suffk | concord | Aylmer, Henry | Knap, Robert | 17 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999032 | 19 19 | f | 106 | Cornw | common recovery | Bagge, Nicholas; Fytte, Nicholas | Enys, Thomas, of Enys, near Ewerthe | 18 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999033 | 19 19 | d | 207 | Yorks | concord | Balam, Robert, gent; Elizabeth, his wife | Thweyng, Marmaduke, gent | 19 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999034 | 19 19 | f | 90 | Sussex | common recovery | Banyster, Edward; Banyster, Katherine, widow | Affennell, Thomas; Alice, his wife | 20 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999035 | 19 19 | f | 49 | Suffk | concord | Barkeley, Robert | Kene, Robert | 21 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999036 | 19 19 | d | 208 | Suffk | concord | Barker, Robert; Margaret, his wife; Hugston, William; Ellen, his wife | Frances, Edmund | 22 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999037 | 19 19 | d | 286 | indenture | Barkervyle, James, esq, son and heir of James Barkervyle, knight, deceased | Sheldon, William of Weston, Warw, esq | 23 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999038 | 19 19 | f | 125 | Soms | account as receiver | Barlow, William, Bishop of Bath and Wells | Ludwell, Edward, of Bath, clothier | 24 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999039 | 19 19 | f | 125 | Soms | account as receiver | Barlow, William, Bishop of Bath and Wells | Yong alias Longe, Thomas, of Bath, baker | 25 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999040 | 19 19 | d | 234 | London | debt | Barnaby, John, of Salisbury | Stacye, Thomas, of London, proctor of the Arches | 26 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999041 | 19 19 | d | 201 | Norfk | concord | Barney, John, esq; Mary, his wife | Sponer, Richard | 27 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999042 | 19 19 | d | 212 | Warw | concord | Bartilmewe, John; Joan, his wife | Cicell, William | 28 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999043 | 19 19 | d | 180 | Cambs | dower | Baylly, Joan, widow | Malyn, Christopher | 29 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999044 | 19 19 | f | 108 | Soms | debt | Baylyff, Ambrose | Lambard, John, of Wedmore, yeoman | 30 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999045 | 19 19 | d | 220 | Yorks | debt | Bealbury, John, of Lyscard, Cornw; Brown, Charles, of Isle of Axholme, Lincs, staple merchant | Oxenfeld, Robert, administrator of; (Oxenfeld, Richard, of Wakefeld, clothier) | 31 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999046 | 19 19 | f | 66 | London | debt | Bekkyngham, Stephen, of London, grocer | Hamond, John, of Bramshott in Hants, weaver; Foster, Andrew, of Havant, Hants, chapman; Gays, John, of Hasylmere, Surrey, yeoman | 32 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999047 | 19 19 | f | 51 | Oxon | concord | Bekyngham, Robert, gent | Cupper, John, gent | 33 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999048 | 19 19 | f | 70 | London | debt | Bell, John, Bishop of Worcester | Grevyll, Fulco, of Beauchamp's Court, Warw, knight | 34 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999049 | 19 19 | f | 49 | Wilts | concord | Besaunt, John; Agnes, his wife; Besaunt, Thomas, their son and heir | Bennat, John | 35 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999050 | 19 19 | f | 4 | Lincs | Blakbourn, Hugh | 36 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||||
| 1999051 | 19 19 | d | 189 | Leics | replevin | Bloxom, John | Wightman, Richard | 37 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999052 | 19 19 | f | 39 | Heref | concord | Blunte, John, esq; Joan, his wife; Blunte, James, son and heir apparent of John | Hoode, Thomas | 38 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999053 | 19 19 | d | 217 | Shrops | common recovery | Boerley, Nicholas, clerk; Sutton, John, clerk; Phelippes, William, clerk | Boerley, John; Juliana, his wife | 39 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999054 | 19 19 | d | 195 | London | debt | Bothe, John, gent, receiver of tolls to the King | Broke, Richard, of Lyllyngston, Nhants; Peryng, John, vicar of Plymouth | 40 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999055 | 19 19 | f | 78 | London | debt | Bothe, John, of Temys Dytton, Surrey, gent | Katherine Foxe, widow, executrix of Henry Foxe, executor of; (Streyt, Peter, of Chester, butcher) | 41 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999056 | 19 19 | d | 201 | Sussex | concord | Bowyer, Richard, senior; Rosa, his wife | Forde, Edward, esq | 42 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999057 | 19 19 | d | 225 | London | debt | Bowyer, William, knight, executors of; (Fysshe, Thomas; Serle, Henry; Eyms, William) | Mall, John, the elder, of Naylande, Suff, clothmaker; Sevill, John, of Tatersayle, Lincolnshire, yeoman; Harwarde, John, of Stretforde, Suffolk, sherman; Mall, John, senior, of Stoke by Nayland, clothman; Mall, John, junior, of Nayland, clothman | 43 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999058 | 19 19 | d | 259 | Crown | letter patent | Bradshawe, Henry, knight | 44 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999059 | 19 19 | f | 45 | Yorks | concord | Bramley, Richard; Agnes, his wife | Key, George | 45 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999060 | 19 19 | d | 211 | Beds | concord | Bray, John, knight | Buteler, Edward, gent | 46 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999061 | 19 19 | f | 52 | Staffs | concord | Brodburn,(?), Thomas; Elizabeth,his wife; Rowlowe, John | Wannton, (?) John, gent | 47 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999062 | 19 19 | f | 83 | Leics | incitement | Brokesbye, Anthony, esq | Hopkyns, John, of Shoulbye, laborer | 48 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999063 | 19 19 | f | 47 | Staffs | debt | Broughton, Richard, of Broughton, gent | Barne, John, of Leighton, Shrops, clerk | 49 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999064 | 19 19 | d | 258 | Crown | letter patent | Broun, Humphrey, knight | 50 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999065 | 19 19 | f | 67 | London | debt | Broun, William, of Swynneshede, Lincs, mercer | Irby, John, of Kyrton, Lincs, gent; Wellockes, Thomas, of Coventry, fishmonger | 51 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999066 | 19 19 | d | 243 | Kent | common recovery | Brown, John; Lake, Robert | Collepeper, John, gent | 52 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999067 | 19 19 | d | 223 | London | debt | Browne, William, of Swynsshed, Lincs, mercer | Robynson, Anthony, of Boston, Lincs, gent; Parkynson, John, of Frisby, Lincs, clerk | 53 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999068 | 19 19 | f | 5 | London | trespass: close | Bryghtman, Thomas | Benson, Thomas, of London, draper | 54 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999069 | 19 19 | d | 211 | Beds | concord | Brykett, Thomas; Margaret, his wife | Ackeworth, George, esq | 55 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999070 | 19 19 | f | 112 | London | debt | Bukland, Richard, of London, merchant tailor | Dyer, John, of Wyncawnton, Somerset, yeoman | 56 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999071 | 19 19 | d | 231 | London | debt | Burton, William, of Todinton, yeoman; Harrys, William, of Syberd Ferys, yeoman | Wright, Alexander, of Candley, Stonley, Warr, gent | 57 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999072 | 19 19 | f | 149 | indenture | Butts, John, gent, son and heir of Butts, William, of Medylton, Norf, gent | Butts, Elizabeth, widow, late wife of Butts, William | 58 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999073 | 19 19 | d | 250 | Soms | common recovery | Carvanell, Lawrence; Farvyn, Peter; Wyllyng, Simon | Bowerman, James | 59 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999074 | 19 19 | d | 221 | Middx | debt | Chaloner, Roger | Knevett, William, of London, gent | 60 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999075 | 19 19 | f | 39 | Kent | concord | Chartham, Thomas; Agnes, his wife | Mason, Stephen | 61 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999076 | 19 19 | f | 50 | Wilts | concord | Chatreton, James; Agnes, his wife | Button, William | 62 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999077 | 19 19 | f | 58 | Leics | debt | Chaundeler, John, draper of London | Howden, Robert, of Loughborough, mercer | 63 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999078 | 19 19 | f | 53 | London | debt | Chestre, William, of London, draper | Mayes alias Nicholls, Richard, of Helmdeon, Nhants, yeoman | 64 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999079 | 19 19 | f | 97 | Devon | debt | Chubbe, John | Frenche, William, of Bryxton, husbandman | 65 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999080 | 19 19 | f | 46 | Essex | concord | Chyshull, William, esq; Elizabeth, his wife | Fytche, Thomas | 66 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999081 | 19 19 | f | 46 | Essex | concord | Chyshull, William, esq; Elizabeth, his wife | Onyon, Thomas | 67 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999082 | 19 19 | d | 256 | Warw | debt | Clopton, William, esq | Hawes, Thomas, gent | 68 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999083 | 19 19 | f | 162 | indenture | Clyfford, George, of Greys Inn, Middx, gent | Cooke, Henry, of London, merchant tailor | 69 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999084 | 19 19 | d | 208 | Herts | concord | Clyfton, Edward | Isake, John | 70 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999085 | 19 19 | f | 49 | Wilts | concord | Cobbe, Thomas; Margaret, his wife | Nycolason, Edward | 71 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999086 | 19 19 | d | 235 | London | debt | Cokayne, Thomas, esq, executor of Cokayn, Barbara, widow, executrix of; (Cokayn, Elizabeth, widow) | Copwod, Sophia, of Tatryge, Herts, widow | 72 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999087 | 19 19 | f | 108 | Suffk | trespass: close | Coke, Thomas | Hasyll, John, of Gosback, senior, yeoman; Hasyll, Thomas, of Gosbeck, yeoman; Hasyll, John, of Gosbeck, junior, yeoman | 73 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999088 | 19 19 | d | 203 | Devon | trespass | Coke, William | Grenslade, William, of Knoston, husbandman | 74 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999089 | 19 19 | f | 172 | indenture | Collys, Humphrey, esq | Slader, Mark; Cottell, Thomas | 75 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999090 | 19 19 | f | 102 | Devon | common recovery | Colwyke, Robert; Lowsmore, George | Prowse, John, of Bollam | 76 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999091 | 19 19 | f | 49 | Devon | concord | Copleston, Christopher, esq; Bodelegh, John; Bedewell, Francis, gent | Gale, Gilbert, gent | 77 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999092 | 19 19 | f | 60 | Cornw | trespass | Coppyng, John, senior; Coppyng, Roger; Coppyng, John, junior | Cocke, Christopher, of Camelford, yeoman | 78 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999093 | 19 19 | d | 201 | Norfk | concord | Corbett, Andrew, esq; Joan his wife | Sowthwell, Robert, knight | 79 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999094 | 19 19 | d | 201 | Sussex | concord | Cornforth, William; Petronella, his wife | Chatfeld, Thomas | 80 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999095 | 19 19 | f | 49 | Devon | concord | Cornysshe, Thomas, husbandman | Mayhow, Richard | 81 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999096 | 19 19 | d | 204 | Staffs | debt | Cortell, John | Cortell, Thomas, of Rolleston, yeoman | 82 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999097 | 19 19 | f | 39 | Kent | concord | Cost, James; Thomasine, his wife | Barbett, Stephen | 83 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999098 | 19 19 | d | 275 | writing | Crown | Bellowe, John, of Grymesby, Lincs, esq; Broxolme, John, of London, esq | 84 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999099 | 19 19 | d | 208 | Devon | concord | Culme, Hugh, gent | Davy alias Richard, Thomas | 85 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999100 | 19 19 | f | 153 | indenture | Culme, Hugh, of Membery, Devon, gent | Davy alias Rycharde, Thomas; Davy alias Rychard, John, of Devon | 86 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999101 | 19 19 | f | 67 | London | debt | Dalston, Thomas, of Carlisle, Cumber, esq | Blenkerne, Hugh, of Assby, Westmor, clerk | 87 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999102 | 19 19 | f | 132 | Lincs | Dalyson, George, esq | Dalyson, Anne, widow | 88 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999103 | 19 19 | d | 261 | Staffs | debt | Damport, John | Hylls, William, of Burton on Trent, innholder | 89 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999104 | 19 19 | f | 51 | Yorks | concord | Darcy, George, knight; Dorothy, his wife | Darcy, Arthur, knight | 90 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999105 | 19 19 | f | 51 | Yorks | concord | Darcy, George, knight; Dorothy, his wife | Darcy, Arthur, knight | 91 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999106 | 19 19 | d | 222 | London | debt | Davyson, William, of Cheshire, Alderman, executrix of; (Davyson, Elizabeth, widow; Dynick, Humphrey, esq; Aldersey, Hugh; Radford, Ralph) | Gerrard, Richard, of Torperley, Cheshire, gent; Lytlover, Robert, of Wallerscote, Weaverham, Cheshire, gent | 92 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999107 | 19 19 | d | 227 | London | debt | Dawes, John, of London, grocer | Marlett, Richard, of Newyngton, Surrey, yeoman; Leweknor, Nicholas, of Chichester, Sussex, gent; Lee, Richard of Fether, Sussex, gent | 93 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999108 | 19 19 | d | 227 | London | debt | Dawes, John, of London, grocer | Mill, Richard, of Havant, Hants, yeoman; Fygge, John, of Hedley, Surrey, clothier; Nauldridge, Elicus(?), of Rydgewyke, Sussex, yeoman; Mores, John, of Petworth, Sussex, yeoman | 94 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999109 | 19 19 | f | 157 | indenture | Dawtrey, Francis, of Porteswod, Hants, knight | Bysshoppe, Thomas, of Henfeld, Sussex, gent | 95 | cp40_1131.txt | CP40/1131 | 2026-01-16 | |||||
| 1999110 | 19 19 | d | 207 | Yorks | concord | Delff, Ellen, widow | Molberley, John | 96 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999111 | 19 19 | f | 78 | London | debt | Dene, John, clerk | Belamy, William, of Harrowe on the hill, Middx, gent | 97 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999112 | 19 19 | f | 15 | Nhants | quare impedit | Denys, Thomas, clerk | Chambers, John, Bishop of Peterborough; Armerer, Thomas; Caworden, John, clerk | 98 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999113 | 19 19 | f | 120 | Yorks | debt | Devenshyre, Arthur, of London, grocer | Evanson, John, of Skypton in Craven, chapman | 99 | cp40_1131.txt | CP40/1131 | 2026-01-16 | ||||
| 1999114 | 19 19 | f | 95 | Staffs | common recovery | Devereux, Walter, knight of the garter, Baron Ferrers | Coton, William, gent, son and heir of Coton, Sigismund | 100 | cp40_1131.txt | CP40/1131 | 2026-01-16 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);