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

✎ 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
1902937 1 1 d   527 Lincs trespass: taking (vacated) Cort, William, of Gaynesburgh, yeoman 1 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902938 1 1 d   446 Vacated debt (vacated) Rankyn, Lawrence, of Cambridge, merchant 2 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902939 1 1 f   444 Vacated debt (Vacated), John Mydwynter, (vacated), of Norleche, husbandman 3 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902940 1 1 f   528 Vacated debt (vacated), of Norwich, chaplain Walters, Thomas, of Norwich, barker 4 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902941 1 1 d   1049 Dorset debt A Borow, Thomas Longmede, Nicholas, of Dertmouth, Devon, merchant; Harys, Hugh, of Fyppyng Okford, yeoman; A Man, Richard, of Wynborn, glover; Pope, Mathew, of Mylton, yeoman; Wykes, Thomas, of Oveshote, mercer 5 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902942 1 1 d   950 Oxon debt A Dene, James, of Stoke Talmage, yeoman Cottisford, Thomas, of Launton, yeoman; Cale, Thomas, of Henley on Thames, smith; Skydmore, Thomas, of Watlyngton, gent; White, Humphrey, of Henley on Thames, miller; Wylly, Thomas, of Rytherfeld Gray, weaver 6 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902943 1 1 d   823 Herts debt A Dene, William, smith Grigge, Thomas, of Gaddesden, wheeler 7 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902944 1 1 f   1008 Sussex replevin A Neston, William Ponte, James 8 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902945 1 1 d   609   replevin A Neston, William   9 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902946 1 1 f   49 Kent debt A Wode, Robert Horton, William, of Wye, carpenter 10 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902947 1 1 d   145 Vacated trespass: close Abbot, (vacated) Obleys, Agnes, of Chelborowe, widow 11 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902948 1 1 f   1031 Dorset trespass: close Abbot, John Obleys, Agnes, of Chelborowe, widow 12 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902949 1 1 f   264 Essex common recovery Abell, John; Bonham, Thomas Smyth, John; Rose his wife, daughter of Busshe, William 13 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902950 1 1 d   351 Suff debt Abell, Richard, of Nayland, clithier Sclye, Robert, of Lyddyngton, Rutland, yeoman 14 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902951 1 1 d   1009 London debt Abraham, Richard, of London, mercer Hamond, John, rector of Swepston, Leics; Burgulon, Edmund, of Neuton, Swepston, husbandman 15 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902952 1 1 d   709 Herefs debt Abryge, Thomas; Morys, John Chapman, Philip, of Leomynster, mercer; Haloward, Hugh, of Leomynster, husbandman; Sadeler, Robert, of Leomynster, saddler; Bradwell, John, of Leomynster, hosier 16 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902953 1 1 d   380 Yorks debt Acrod, William Staneley or Staveley, Henry, of Masham, gent; Laycok, John, of Dancaster, yeoman 17 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902954 1 1 f   422 Yorks trespass: assault Acrod, William, clerk Staneley or Staveley, Henry, of Masham, gent 18 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902955 1 1 d   74 London debt execution Acton, Hugh, of London, merchant tailor Adhams, Christopher, of Suthwark, yeoman 19 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902956 1 1 d   114 London debt Acton, Hugh, of London, merchant tailor Reed, William, of Borstall, Bucks, knight; Morgan, Hugh, of Borstall, yeoman 20 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902957 1 1 d   973 London debt Acton, Hugh, of London, merchant tailor Walshe, John, of Cheshunt, Herts, esq 21 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902958 1 1 d   65 London debt Acton, Hugh, of London, merchant tailor Wyngfeld, Anthony, of London, gent 22 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902959 1 1 f   601 London debt Acton, Hugh, of St Johns Strete, Middx, courser Berners, John, of Stortford, Herts, gent 23 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902960 1 1 f   904 London debt Acton, Hugh, of St Johns Strete, Middx, courser Berners, John, of Stortford, Herts, gent 24 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902961 1 1 d   1046 Devon trespass: close Adam, John, senior Cause, Hugh, of Fen, husbandman; Pers, William, of Fen, husbandman 25 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902962 1 1 d   1046 Devon trespass: close Adam, John, senior Harvy, William, of Loddyswell, husbandman; Angelice his wife; Harvy, Thomas, of Loddyswell, husbandman 26 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902963 1 1 d   1046 Devon trespass: close Adam, John, senior Lee, John, of South Newton, Churstowe, husbandman 27 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902964 1 1 f   141 London debt Adam, Nicholas, of London, goldsmith, executors of; (Nele, John, of London, goldsmith; Joan his wife) Lever, William, of Maunsfeld in Shirwood, Notts, draper 28 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902965 1 1 f   1128 Cams debt Adam, William, executrix of; (Adam, Isabel, widow) Holand, George, prior of St Mary Priory, Anglesey 29 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902966 1 1 d   864 Devon trespass: close Adams, John Cawnter, John, of Mylton Abbots, yeoman; Maynerd, Thomas, of Mylton, yeoman; Palmer, Richard, of Brodewode Wygger, yeoman 30 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902967 1 1 d   329 Notts debt Adamson, Robert Thomson Thomas, of Blithe, laborer 31 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902968 1 1 f   38 Staffs replevin Adderley, Thomas Wryght, Alice, widow 32 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902969 1 1 d   439 Warks trespass: close Addersyche, Henry Felowes, Richard, of Alcetur, shoemaker; Style, John, of Alcetur, laborer; Hall, Roger, of Alcetur, laborer 33 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902970 1 1 f   573 Lincs debt Adderton, John Lokecok, John, of Brampton, husbandman 34 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902971 1 1 f   7 Glos debt Addys, John, of Pauntley, executors of; (Morton, Thomas; Margaret his wife) Sybblys, Richard, of Dymmok, husbandman 35 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902972 1 1 f   500 Herts debt Adene, William, smith Grigge, Thomas, of Magna Gaddesden, wheeler 36 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902973 1 1 f   17 Herts debt Adene, William, smith Grygge, Thomas, of Magna Gaddesden, wheeler 37 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902974 1 1 d   1014 London debt Adys, William, of London, goldsmith Vaughan, William, of London, gent; Adys, John, of Weston, Herefs, husbandman; Forstall, George, of London, gent; Draper, John, of Syscetor, Glos, yeoman; Vyncent, John, of Walcote, Nhants, gent 38 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902975 1 1 f   1008 Sussex trespass: close Agmondesham, Henry Jotton, Edmund, of Kyrdford, husbandman 39 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902976 1 1 f   1008 Surrey trespass: close Agmondesham, John Grosham, John, of London, grocer 40 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902977 1 1 f   1031 Dorset trespass: close Aier, John Bregan, John, of Craforde, husbandman; Nowell, John, of Craforde, husbandman; Williams, John, of Craforde, husbandman 41 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902978 1 1 f   1000 Essex trespass: close Akent, John Brokhell, John, of Beauchamp Otys, husbandman 42 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902979 1 1 f   402 Suff debt Akent, John Smyth, William, of Melford, butcher; Ravelet or Rabelet, Thomas, of Burys, yeoman; Dawys or Dallys, John, of Sudbury, husbandman 43 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902980 1 1 d   337 Herts debt Alborn, William Chambre, William, of Hycchyn, tanner 44 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902981 1 1 d   504 Suff debt Alby, Thomas, administrator of; (Whyte, John) Barker, William, of Clare, yeoman; Germyn, Agnes, of Melford, widow; Alby, Margaret, of Melford, spinster 45 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902982 1 1 d   294 Beds trespass: close Alde, John, chaplain Scott, Thomas, of Eton, yeoman; Bolno, Thomas, of Eton, shoemaker 46 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902983 1 1 f   547 Coventry debt Aldernes, Robert of London, merchant Hill, John, of Coventry, dyer 47 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902984 1 1 f   547 Coventry debt Aldernes, Robert of London, merchant Rychardson, William, of Coventry, dyer 48 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902985 1 1 f   547 Coventry debt Aldernes, Robert of London, merchant Stanwardyne, William, of Coventry, dyer 49 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902986 1 1 d   248 Yorks replevin Alderston, Thomas, clerk Melsey Abbey, John, abbot of 50 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902987 1 1 f   1191 London debt Alderton, Joan, widow Audelet, John, of Abyngdon, Berks, yeoman 51 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902988 1 1 d   870 London debt Aldryche, of London, grocer, executors of; (Sandell, John; Durdant, William) Blaunchard, William, of Salisbury, apothecary; Fryer, William, of Oxford, grocer; Awode, John, of Coventry, grocer; Beyngly, John, of Salisbury, grocer 52 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902989 1 1 f   988 London debt Aldryche, William, of London, grocer, executors of; (Sandell, John; Durdaunt, William) Spycer, John, of Bristol, grocer; Blont, Thomas, of Oxford, grocer; Hacke, John, of Cambridge, grocer; Walker, John, of Blansford, Dorset, grocer 53 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902990 1 1 d   902 Kent debt Aldy, Nicholas, of London, grocer Broke, John, of Canterbury, mercer; Broke, William, rector of Fordych 54 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902991 1 1 d   488 Norf debt Aleleyns, Waren Bryghtwell, John, senior, of Crowmer, carpenter; Perman, Roger, of Crowmer, mariner; Bene, William, of Crowmer, baker 55 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902992 1 1 d   565 Essex common recovery Alen, Richard; Heron, John; Ketyll, Richard; Bover, Richard Hevenyngham, John, esq 56 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902993 1 1 f   5 Berks debt Alen, Thomas Laurence, Hugh, of Redyng, butcher; Monke, William, of Redyng, chandler; Polluker or Pollnker, of Arreley , husbandman 57 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902994 1 1 d   424 Shrops debt Alen, William Squyer, John, of Welyngton, yeoman; Alen, Edward, of Prece, tailor 58 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902995 1 1 d   496 Warks debt Alestre, John, clerk, dean of St Mary College, Warwick Sporyer, John, of Byfeld, Nhants, merchant 59 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902996 1 1 f   55 Surrey account as socage guardian Aleyn, John Slater, Richard, of Oxstede, husbandman 60 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902997 1 1 d   1035 Surrey account as socage guardian Aleyn, John Slater, Richard, of Oxstede, husbandman 61 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902998 1 1 d   876 London debt Aleyn, John, of London, mercer Brownsmyth, Thomas, of Trowbrigge, Wilts, clothier 62 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1902999 1 1 f   159 London debt Aleyn, John, of London, mercer Mugge, William, of Godeherst, Kent, clothier; Coushman or Conshman, Simon, of Cranebroke, Kent, weaver; Brownsmyth, Thomas, of Trowbrigge, Wilts, clothier 63 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903000 1 1 f   567 London debt Aleyn, John, of London, mercer Sherborn, Richard, of Stanehurst, Lancs, knight; Kyghley, Henry, of Inskyp, Lancs, knight; Soworth, John, of Samlesbury, Lancs, knight 64 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903001 1 1 f   143 London debt Aleyn, John, of London, mercer Sherborn, Richard, of Stanehurst, Lancs, knight; Kyghtley, Henry, of Inskyp, Lancs, knight; Soworth, John, of Samlesbury, Lancs, knight 65 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903002 1 1 d   895 London debt Aleyn, John, of London, mercer Warde, Roger, of Elton, Notts, yeoman; Byron, John, of Colwyke, Notts, esq 66 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903003 1 1 f   931 London debt Aleyn, John, of London, mercer Whichecot, Thomas, of Dunston, Lincs, gent 67 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903004 1 1 f   143 London debt Aleyn, John, of London, mercer Whychecott, Thomas, of Dunston, Lincs, gent; Warde, Roger, of Elton, Notts, yeoman; Byron, John, of Colwyke, esq 68 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903005 1 1 f   159 London debt Aleyn, John, of London, mercer Wychcote, Thomas, of Donston, Lincs, gent; Brownsop, William, rector of Holwale, Dorset 69 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903006 1 1 f   283 London debt Aleyn, Ralph, of London, grocer Agard, Ralph, of Kings Bromley, Staffs, esq 70 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903007 1 1 f   283 London debt Aleyn, Ralph, of London, grocer Agard, Ralph, of Kings Bromley, Staffs, esq 71 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903008 1 1 d   85 London debt Aleyn, Ralph, of London, grocer Gloucetur, Thomas, of Gloucester, merchant 72 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903009 1 1 d   800 London debt Aleyn, Ralph, of London, grocer Gloucetur, Thomas, of Gloucester, merchant 73 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903010 1 1 f   469 Staffs debt Alkyn, Thomas Mathewe, Robert, of Ronton, yeoman 74 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903011 1 1 f   53 Kent trespass: close Allard, Henry Ambros, Thomas, of Kenyngton, husbandman; Atwode, Robert, Kenyngton, husbandman 75 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903012 1 1 d   967 Devon trespass: close Allerton, Thomas; Prater, Nicholas Houghton, John, of Paynton, husbandman; Isabel his wife; Adam, John, of Paynton, husbandman 76 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903013 1 1 f   50 Sussex debt Allock, Thomas Constabyll, William, executrix of; (Constabyll, Joan, of Pykcombe, widow) 77 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903014 1 1 d   855 Suff debt Alman, John Prest, Robert, of Hopton, husbandman 78 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903015 1 1 d   611 Nottingham debt Altofte, John Johnson, William, of Nottingham, butcher 79 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903016 1 1 f   22 Lincs debt Alvyngham Priory, John, prior of Ennerby or Gunerby, William, of Walde Newton, husbandman 80 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903017 1 1 d   305 Kent concord Alyn, William; Alice his wife Raynold, William 81 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903018 1 1 d   871 Cams debt Alyngton, Giles, knight, sheriff of Cams Talleworth, John, of Brynkeley, yeoman; Harvy, Thomas, of Melreth, yeoman; Byrd, Thomas, of Chesterton, yeoman; Blak, William, of Gamlyngey, yeoman; Hardyng, John, of Papworth Agnes, Hunts, yeoman 82 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903019 1 1 f   1105 Lincs debt Alynson, Robert Cortyn alias Vesse, John, of Botheby juxta Naynby, husbandman 83 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903020 1 1 f   527 Norf debt Alysaunder, John, of Bishops Lenn, butcher Roo, Thomas, of Bishops Lenn, glover; Whetley, John, of Rysyng, husbandman; Taverner, Richard, of Shuldham, husbandman 84 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903021 1 1 d   776 London debt Amadas, Robert, of London, goldsmith Burton, Robert, of London, gent 85 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903022 1 1 f   903 London debt Amadas, Robert, of London, goldsmith Gascoigne, William, of Caryngton, Beds, esq 86 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903023 1 1 f   907 London debt Amadas, Robert, of London, goldsmith Hall, Robert, of Ore, Sussex, gent 87 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903024 1 1 d   29 London debt Amadas, Robert, of London, goldsmith Hall, Robert, of Ore, Sussex, gent; Burton, Robert, of London, gent; Mychell, John, of London, gent 88 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903025 1 1 f   885 London debt Amadas, Robert, of London, goldsmith Mychell, John, of London, gent 89 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903026 1 1 d   592 London debt Amadas, Robert, of London, goldsmith Willoughby, Christopher, of London, esq 90 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903027 1 1 d   120 London debt Amadas, Robert, of London, goldsmith Willoughby, Richard, of Grynden, Nhants, husbandman; Gascoigne, William, of Caryngton, Beds, esq 91 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903028 1 1 f   902 London debt Amadas, Robert, of London, goldsmith Willoughby, Richard, of Gryndon, Nhants, gent 92 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903029 1 1 d   525 Lincs trespass: close Amby, Philip Benton, William, of Ryby, husbandman; Frankelysshe, Richard, of Rybe, husbandman; Benyngworth, Henry, of Ryby, husbandman; Parker, William, of Ryby, husbandman 93 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903030 1 1 d   1063 Essex debt Ame, William Bone, John, junior, of Rammesdon Bellowes, laborer 94 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903031 1 1 d   482 Norf debt Amfles, William, of Bishops Lenn, merchant, executors of; (Amfles, Joan, widow; Amfles, Robert) Colvyle, William, of St Neots, Hunts, fishmonger 95 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903032 1 1 f   558 Suff debt Amore, John Alden, William, of Bokenham, Norf, tailor; Mosse, Robert, of Lopham, Norf, tailor 96 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903033 1 1 d   387 Suff debt Amore, John Alden, William, of Bokenham, Norf, tailor; Mosse, Robert, of Lopham, Norf, tailor 97 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903034 1 1 d   873 Cams trespass: close Andrewe, Joan Waren, Eleanor, of London, widow; Game, John, of Kneseworth, husbandman 98 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903035 1 1 d   444 Coventry debt Andrewe, William Alet, Ralph, of Coventry, dyer 99 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18
1903036 1 1 d   15 Herts debt Andrewe, William, senior Adane, John, of Burne, Cams, yeoman; Chapman, John, of Pokerych, mercer 100 cp40_1005.txt CP40no1005B Hilary 1514   2026-01-18

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