As of February 24, 2015 the following information is now available on the FTP site:
- 2014 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
- 2015 Actuarial Data Master for the 4/30, 11/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2014 Actuarial Data Master are in the References/Actuarial_Data_Master/2014 directory.
- 2015 Actuarial Data Master are in the References/Actuarial_Data_Master/2015 directory
Additional notes and details regarding this data release:
2014 and 2015 ADM Area Risk Rate updated final indices on intervals with an ending month of December for PRF/Apiculture and Annual Forage respectively, reference PM-15-011.
2015 Kay County, Oklahoma COMBO Soybean map association added for FAC (following another crop) practice via updated ADM records for sub county rate, map, and coverage level differential, 11/30 filing.
2015 ADM Option Rate updated on COMBO Barley to remove YE/MA/MB excluded 2 insurance option code combination, 11/30 filing.
2015 ADM Price update on COMBO/SCO Rice to add contract pricing information, 11/30 filing.
2015 ADM Price updated to show corn silage price on YP (01/04/31) to be in the projected price field vs the established price, 11/30 filing.
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 |
|---|---|---|
2014_ADM_Daily_150224.zip | A01005_AreaRiskRate_Daily.txt | 257,730 |
2014_ADM_Filing_0831.zip | A00030_InsuranceOffer_FIling.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01000_AgrRate_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01070_Proration_Filing.txt A01100_YieldAndTyield_Filing.txt A01200_DocumentBuilder_Filing.txt | 86,403 1,317,650 86,403 84,611 1,135,674 6,564,892 17,702 523,892 6,282 47,068 600 2,002,947 361,563 |
| 2014_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01005_AreaRiskRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt | 987 855,984 1,681,194 517 368 862,596 399 26 127 357 3,188 76 20 12 47 3 3 1,050 50 4 541 20 1 45 4 51 684,313 1,135,674 11,892,864 725,809 121,500 2,667,330 7,386,876 175,003 3,033,881 2,739,948 1,517 9,062,626 156,804 12,662,839 1,160 |
| 2015 ADM Daily 150224.zip | A00045 Map Daily.txt A00810_Price_Daily.txt A01005_AreaRiskRate_Daily.txt A01040_CoverageLevelDifferential_Daily.txt A01050_SubCountyRate_Daily.txt A01060_OptionRate_Daily.txt | 9 13,584 31,670 75 9 8,334 |
| 2015_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01200_DocumentBuilder_Filing.txt | 14,025 89,279 14,025 11,784 785,416 1,791 52,734 603 3,153 3,738 82,918 |
| 2015_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt A00045_Map_Filing.txt A00200_Date_Filing.txt A00810_Price_Filing.txt A01005_AreaRiskRate_Filing.txt A01010_BaseRate_Filing.txt A01040_CoverageLevelDifferential_Filing.txt A01050_SubCountyRate_Filing.txt A01060_OptionRate_Filing.txt A01100_YieldAndTyield_Filing.txt A01105_YieldExclusion_Filing.txt A01110_HistoricalRevenueCapping_Filing.txt A01200_DocumentBuilder_Filing.txt | 745,769 232,031 746,420 173,123 50,743,056 415,784 7,110,538 144,157 2,972,066 6,593,468 420,588 139,614 6,892,284 |
| 2015_ADM_YTD.zip | A00010_AdmLayout_YTD.txt A00030_InsuranceOffer_YTD.txt A00045_Map_YTD.txt A00050_Quality_YTD.txt A00070_SubsidyPercent_YTD.txt A00200_Date_YTD.txt A00400_AgrCommodity_YTD.txt A00410_Class_YTD.txt A00420_Commodity_YTD.txt A00430_CommodityType_YTD.txt A00440_County_YTD.txt A00450_CroppingPractice_YTD.txt A00460_InsurancePlan_YTD.txt A00470_IntendedUse_YTD.txt A00480_Interval_YTD.txt A00490_IrrigationPractice_YTD.txt A00500_OrganicPractice_YTD.txt A00510_Practice_YTD.txt A00520_State_YTD.txt A00530_SubClass_YTD.txt A00540_Type_YTD.txt A00550_DocumentStructure_YTD.txt A00560_EndorsementLength_YTD.txt A00570_InsuranceOption_YTD.txt A00580_RateMethod_YTD.txt A00590_SpoiGroup_YTD.txt A00810_Price_YTD.txt A01000_AgrRate_YTD.txt A01005_AreaRiskRate_YTD.txt A01010_BaseRate_YTD.txt A01020_Beta_YTD.txt A01030_ComboRevenueFactor_YTD.txt A01040_CoverageLevelDifferential_YTD.txt A01050_SubCountyRate_YTD.txt A01060_OptionRate_YTD.txt A01070_Proration_YTD.txt A01090_UnitDiscount_YTD.txt A01100_YieldAndTyield_YTD.txt A01105_YieldExclusion_YTD.txt A01110_HistoricalRevenueCapping_YTD.txt A01200_DocumentBuilder_YTD.txt A01210_Statement_YTD.txt | 1,034 1,191,376 1,684,335 517 460 1,198,015 405 27 125 359 3,190 76 24 12 47 3 3 1,042 50 4 541 20 1 47 4 83 386,858 6,241,608 61,685,570 749,203 121,500 2,827,170 10,312,101 177,754 4,040,002 2,739,732 2,669 10,293,875 420,588 156,804 13,962,829 2,912 |