As of September 17, 2015 the following information is now available on the FTP site:
- 2015 Actuarial Data Master for the 11/30 Filing Date, YTD, and Daily Files.
- 2016 Actuarial Data Master for the 6/30, 8/31 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory.
- 2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
Additional notes and details regarding this data release:
2015 ADM Price updated for corn (AR & MS) harvest price announcement, PM-15-046, 11/30 filing.
2016 ADM Price updated for barley, canola, and wheat COMBO (01/02/03), barley & wheat SCO (31/32/33), and ARPI wheat (04/05/06), reference PM-15-046, 6/30 filing.
2016 ADM Area Risk Rate on ARPI & SCO wheat and SCO barley is updated to provide expected county revenue amounts, 6/30 filing.
2016 ADM Price updated to 1) populate missing irrigated CBVs (county base values) on a few selected PRF grids which bordered states which didn't price by grid; and 2) remove base county offers where CBV is null and populate minimum & maximum acre percent for all the subcounty price records for CE/PASS processing, 8/31 filing.
2016 Margin Protection ADM information (Insurance Offer, Area Risk Rate, Draw, Historical Yield Trend, and Price) for sales will be forthcoming on the next update later today via email notification.
Please notify your data processing representative that this information is available for downloading. For questions regarding the actuarial information, please contact Ron Tilly by phone at (816) 926-1137, or via email to ronald.tilly@rma.usda.gov.
Archived release bulletins are located online at Actuarial Bulletins.
File Name | Contains | Record Count |
|---|---|---|
2015_ADM_Daily_150916.zip | A00810_Price_Daily.txt | 2,600 |
2015_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 745,769 |
A00045_Map_Filing.txt | 232,040 | |
A00200_Date_Filing.txt | 746,420 | |
A00810_Price_Filing.txt | 808,088 | |
A01005_AreaRiskRate_Filing.txt | 50,758,986 | |
A01010_BaseRate_Filing.txt | 415,784 | |
A01040_CoverageLevelDifferential_Filing.txt | 7,110,613 | |
A01050_SubCountyRate_Filing.txt | 144,166 | |
A01060_OptionRate_Filing.txt | 2,972,066 | |
A01100_YieldAndTyield_Filing.txt | 6,593,468 | |
A01105_YieldExclusion_Filing.txt | 420,588 | |
A01110_HistoricalRevenueCapping_Filing.txt | 139,614 | |
A01200_DocumentBuilder_Filing.txt | 6,892,284 | |
2015_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,049 |
A00030_InsuranceOffer_YTD.txt | 1,191,404 | |
A00045_Map_YTD.txt | 1,684,344 | |
A00050_Quality_YTD.txt | 518 | |
A00070_SubsidyPercent_YTD.txt | 464 | |
A00200_Date_YTD.txt | 1,198,043 | |
A00400_AgrCommodity_YTD.txt | 405 | |
A00410_Class_YTD.txt | 27 | |
A00420_Commodity_YTD.txt | 126 | |
A00430_CommodityType_YTD.txt | 359 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 76 | |
A00460_InsurancePlan_YTD.txt | 24 | |
A00470_IntendedUse_YTD.txt | 12 | |
A00480_Interval_YTD.txt | 47 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 1,043 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 4 | |
A00540_Type_YTD.txt | 542 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 47 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 83 | |
A00810_Price_YTD.txt | 1,034,566 | |
A01000_AgrRate_YTD.txt | 6,241,608 | |
A01005_AreaRiskRate_YTD.txt | 61,701,500 | |
A01010_BaseRate_YTD.txt | 749,203 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,312,176 | |
A01050_SubCountyRate_YTD.txt | 177,763 | |
A01060_OptionRate_YTD.txt | 4,040,002 | |
A01070_Proration_YTD.txt | 2,739,732 | |
A01090_UnitDiscount_YTD.txt | 2,669 | |
A01100_YieldAndTyield_YTD.txt | 10,293,875 | |
A01105_YieldExclusion_YTD.txt | 420,588 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,804 | |
A01200_DocumentBuilder_YTD.txt | 13,962,997 | |
A01210_Statement_YTD.txt | 2,916 | |
2016_ADM_Daily_150916.zip | A00810_Price_Daily.txt | 302,980 |
A01005_AreaRiskRate_Daily.txt | 279,402 | |
2016_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 166,919 |
A00045_Map_Filing.txt | 38,007 | |
A00200_Date_Filing.txt | 172,925 | |
A00810_Price_Filing.txt | 140,001 | |
A01005_AreaRiskRate_Filing.txt | 11,215,380 | |
A01010_BaseRate_Filing.txt | 81,159 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,469,809 | |
A01050_SubCountyRate_Filing.txt | 23,625 | |
A01060_OptionRate_Filing.txt | 569,387 | |
A01100_YieldAndTyield_Filing.txt | 1,371,420 | |
A01105_YieldExclusion_Filing.txt | 120,786 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,742 | |
A01200_DocumentBuilder_Filing.txt | 1,586,600 | |
2016_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 168,244 |
A00045_Map_Filing.txt | 1,590,039 | |
A00200_Date_Filing.txt | 168,244 | |
A00810_Price_Filing.txt | 341,100 | |
A01000_AgrRate_Filing.txt | 9,240,768 | |
A01005_AreaRiskRate_Filing.txt | 7,142,467 | |
A01010_BaseRate_Filing.txt | 19,247 | |
A01040_CoverageLevelDifferential_Filing.txt | 971,310 | |
A01050_SubCountyRate_Filing.txt | 3,432 | |
A01060_OptionRate_Filing.txt | 81,160 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,252,082 | |
A01105_YieldExclusion_Filing.txt | 11,238 | |
A01200_DocumentBuilder_Filing.txt | 918,792 | |
2016_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,065 |
A00030_InsuranceOffer_YTD.txt | 358,471 | |
A00045_Map_YTD.txt | 1,737,777 | |
A00050_Quality_YTD.txt | 252 | |
A00070_SubsidyPercent_YTD.txt | 356 | |
A00200_Date_YTD.txt | 364,477 | |
A00400_AgrCommodity_YTD.txt | 400 | |
A00410_Class_YTD.txt | 14 | |
A00420_Commodity_YTD.txt | 84 | |
A00430_CommodityType_YTD.txt | 249 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 51 | |
A00460_InsurancePlan_YTD.txt | 21 | |
A00470_IntendedUse_YTD.txt | 10 | |
A00480_Interval_YTD.txt | 47 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 593 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 5 | |
A00540_Type_YTD.txt | 349 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 29 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 18 | |
A00810_Price_YTD.txt | 493,776 | |
A01000_AgrRate_YTD.txt | 9,240,768 | |
A01005_AreaRiskRate_YTD.txt | 18,828,583 | |
A01010_BaseRate_YTD.txt | 107,936 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 859,140 | |
A01040_CoverageLevelDifferential_YTD.txt | 2,576,320 | |
A01050_SubCountyRate_YTD.txt | 29,367 | |
A01060_OptionRate_YTD.txt | 670,938 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 817 | |
A01100_YieldAndTyield_YTD.txt | 3,710,448 | |
A01105_YieldExclusion_YTD.txt | 132,855 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,742 | |
A01200_DocumentBuilder_YTD.txt | 2,681,544 | |
A01210_Statement_YTD.txt | 6,253 |