As of December 22, 2016 the following information is now available on the FTP site:
- 2016 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 4/30, 8/31, 11/30 Filing Date, YTD, and Daily Files.
Users can find this information in the following directories:
- 2016 Actuarial Data Master are in the References/Actuarial_Data_Master/2016 directory.
- 2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
Additional notes and details regarding this data release:
2016 ADM Area Risk Rate updated final indices on intervals with an ending month of October for PRF/Apiculture; and 2017 Annual Forage [ADM Price & Area Coverage Level] respectively, reference PM-16-065.
2017 ADM Price records updated to repopulate the Expected Index Values (1.00) at the sub county/grid level as previously done at the county level on Annual Forage, PRF, and Apiculture, 4/30 & 8/31 filings.
2017 ADM updates completed on the 11/30 filing for SCO on Silage Sorghum, Hybrid Corn Seed, Hybrid Seed Rice, Hybrid Sorghum Seed, SCO/ARPI Popcorn and SCO/ARPI Corn for silage conversion factors applied, SCO added to expansion counties for Dry Peas, Potatoes, MI (26-041) SCO Dry Beans populated rate where price volatility is zero and county yield added for Hybrid Corn Seed expansion counties (Plan 55).
2017 ADM Layout (A00010) revised for the Price record to make CrushDistrictNumber part of the business key as well as 2 changes for the upcoming filings (1/31 & 2/28).
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-1337, or via email to ronald.tilly@rma.usda.gov. Archived release bulletins are located online at Actuarial Bulletins.
File Name | Contains | Record Count |
|---|---|---|
2016_ADM_Daily_161222.zip | A01005_AreaRiskRate_Daily.txt | 707,295 |
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,263,808 | |
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 | 85,388 | |
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,072 |
A00030_InsuranceOffer_YTD.txt | 1,474,169 | |
A00045_Map_YTD.txt | 1,954,672 | |
A00050_Quality_YTD.txt | 538 | |
A00070_SubsidyPercent_YTD.txt | 480 | |
A00200_Date_YTD.txt | 1,480,826 | |
A00400_AgrCommodity_YTD.txt | 400 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 131 | |
A00430_CommodityType_YTD.txt | 360 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 77 | |
A00460_InsurancePlan_YTD.txt | 25 | |
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,072 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 547 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 46 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 92 | |
A00615_Draw_YTD.txt | 74,100 | |
A00810_Price_YTD.txt | 1,511,463 | |
A01000_AgrRate_YTD.txt | 9,263,808 | |
A01005_AreaRiskRate_YTD.txt | 87,253,282 | |
A01010_BaseRate_YTD.txt | 755,783 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,827,170 | |
A01040_CoverageLevelDifferential_YTD.txt | 12,312,223 | |
A01050_SubCountyRate_YTD.txt | 177,454 | |
A01060_OptionRate_YTD.txt | 4,543,545 | |
A01070_Proration_YTD.txt | 2,739,624 | |
A01090_UnitDiscount_YTD.txt | 2,801 | |
A01100_YieldAndTyield_YTD.txt | 10,558,009 | |
A01105_YieldExclusion_YTD.txt | 599,718 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,480 | |
A01115_HistoricalYieldTrend_YTD.txt | 23,482 | |
A01200_DocumentBuilder_YTD.txt | 17,395,677 | |
A01210_Statement_YTD.txt | 22,016 | |
2017_ADM_Daily_161222.zip | A00010_AdmLayout_Daily.txt | 11 |
A00030_InsuranceOffer_Daily.txt | 14,995 | |
A00810_Price_Daily.txt | 1,650,090 | |
A01010_BaseRate_Daily.txt | 24 | |
A01040_CoverageLevelDifferential_Daily.txt | 654 | |
A01115_HistoricalYieldTrend_Daily.txt | 58,136 | |
A01120_AreaDataSource_Daily.txt | 10 | |
A01125_ProductionArea_Daily.txt | 1,662 | |
A01130_AreaCoverageLevel_Daily.txt | 106,670 | |
A01135_AreaRate_Daily.txt | 217,962 | |
2017_ADM_Filing_0430.zip | A00030_InsuranceOffer_Filing.txt | 15,286 |
A00045_Map_Filing.txt | 107,955 | |
A00200_Date_Filing.txt | 15,286 | |
A00810_Price_Filing.txt | 120,369 | |
A01010_BaseRate_Filing.txt | 1,911 | |
A01040_CoverageLevelDifferential_Filing.txt | 58,632 | |
A01050_SubCountyRate_Filing.txt | 603 | |
A01060_OptionRate_Filing.txt | 3,539 | |
A01100_YieldAndTyield_Filing.txt | 6,384 | |
A01130_AreaCoverageLevel_Filing.txt | 475,416 | |
A01200_DocumentBuilder_Filing.txt | 102,644 | |
2017_ADM_Filing_0831.zip | A00030_InsuranceOffer_Filing.txt | 165,814 |
A00045_Map_Filing.txt | 1,590,961 | |
A00200_Date_Filing.txt | 165,814 | |
A00810_Price_Filing.txt | 1,547,281 | |
A01000_AgrRate_Filing.txt | 9,898,224 | |
A01010_BaseRate_Filing.txt | 19,322 | |
A01040_CoverageLevelDifferential_Filing.txt | 956,778 | |
A01050_SubCountyRate_Filing.txt | 3,432 | |
A01060_OptionRate_Filing.txt | 85,864 | |
A01070_Proration_Filing.txt | 384 | |
A01100_YieldAndTyield_Filing.txt | 2,380,332 | |
A01105_YieldExclusion_Filing.txt | 11,685 | |
A01130_AreaCoverageLevel_Filing.txt | 7,127,437 | |
A01200_DocumentBuilder_Filing.txt | 648,214 | |
2017_ADM_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 882,721 |
A00045_Map_Filing.txt | 223,049 | |
A00200_Date_Filing.txt | 883,372 | |
A00810_Price_Filing.txt | 755,697 | |
A01010_BaseRate_Filing.txt | 417,171 | |
A01040_CoverageLevelDifferential_Filing.txt | 8,396,664 | |
A01050_SubCountyRate_Filing.txt | 164,404 | |
A01060_OptionRate_Filing.txt | 3,221,238 | |
A01100_YieldAndTyield_Filing.txt | 7,157,968 | |
A01105_YieldExclusion_Filing.txt | 473,925 | |
A01110_HistoricalRevenueCapping_Filing.txt | 138,588 | |
A01130_AreaCoverageLevel_Filing.txt | 3,968,210 | |
A01200_DocumentBuilder_Filing.txt | 6,552,227 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,117 |
A00030_InsuranceOffer_YTD.txt | 1,243,991 | |
A00045_Map_YTD.txt | 1,967,889 | |
A00050_Quality_YTD.txt | 510 | |
A00070_SubsidyPercent_YTD.txt | 479 | |
A00200_Date_YTD.txt | 1,250,495 | |
A00400_AgrCommodity_YTD.txt | 431 | |
A00410_Class_YTD.txt | 24 | |
A00420_Commodity_YTD.txt | 114 | |
A00430_CommodityType_YTD.txt | 339 | |
A00440_County_YTD.txt | 3,190 | |
A00450_CroppingPractice_YTD.txt | 75 | |
A00460_InsurancePlan_YTD.txt | 25 | |
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,014 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 6 | |
A00540_Type_YTD.txt | 504 | |
A00550_DocumentStructure_YTD.txt | 20 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 43 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 95 | |
A00615_Draw_YTD.txt | 29,500 | |
A00810_Price_YTD.txt | 2,598,159 | |
A01000_AgrRate_YTD.txt | 9,898,224 | |
A01010_BaseRate_YTD.txt | 527,087 | |
A01020_Beta_YTD.txt | 121,500 | |
A01030_ComboRevenueFactor_YTD.txt | 2,857,140 | |
A01040_CoverageLevelDifferential_YTD.txt | 10,960,193 | |
A01050_SubCountyRate_YTD.txt | 194,071 | |
A01060_OptionRate_YTD.txt | 3,923,276 | |
A01070_Proration_YTD.txt | 384 | |
A01090_UnitDiscount_YTD.txt | 2,897 | |
A01100_YieldAndTyield_YTD.txt | 11,127,004 | |
A01105_YieldExclusion_YTD.txt | 615,027 | |
A01110_HistoricalRevenueCapping_YTD.txt | 156,294 | |
A01115_HistoricalYieldTrend_YTD.txt | 719,702 | |
A01120_AreaDataSource_YTD.txt | 128 | |
A01125_ProductionArea_YTD.txt | 177,460 | |
A01130_AreaCoverageLevel_YTD.txt | 12,253,024 | |
A01135_AreaRate_YTD.txt | 13,887,417 | |
A01200_DocumentBuilder_YTD.txt | 8,466,300 | |
A01210_Statement_YTD.txt | 1,209 |