As of June 24, 2016 the following information is now available on the FTP site:
- 2017 Actuarial Data Master for the 6/30 Filing Date, YTD, and Daily Files.
- 2017 Special Provisions for the 6/30 Filing Date.
Users can find this information in the following directories:
- 2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory.
- 2017 Special Provisions are in the Special_Provisions/2017 directory.
Additional notes and details regarding this data release:
2017 Special Provisions and ADM files are now released for the 6/30 filing except Margin Protection (plan 16) and sugarcane.
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 |
---|---|---|
2017_ADM_Daily_160624.zip | A00030_InsuranceOffer_Daily.txt | 170,046 |
A00045_Map_Daily.txt | 38,154 | |
A00050_Quality_Daily.txt | 232 | |
A00070_SubsidyPercent_Daily.txt | 170 | |
A00200_Date_Daily.txt | 175,899 | |
A00410_Class_Daily.txt | 7 | |
A00420_Commodity_Daily.txt | 17 | |
A00430_CommodityType_Daily.txt | 45 | |
A00440_County_Daily.txt | 5 | |
A00450_CroppingPractice_Daily.txt | 8 | |
A00460_InsurancePlan_Daily.txt | 10 | |
A00470_IntendedUse_Daily.txt | 2 | |
A00510_Practice_Daily.txt | 132 | |
A00520_State_Daily.txt | 1 | |
A00530_SubClass_Daily.txt | 2 | |
A00540_Type_Daily.txt | 70 | |
A00550_DocumentStructure_Daily.txt | 7 | |
A00570_InsuranceOption_Daily.txt | 16 | |
A00580_RateMethod_Daily.txt | 3 | |
A00590_SpoiGroup_Daily.txt | 21 | |
A00810_Price_Daily.txt | 103,283 | |
A01010_BaseRate_Daily.txt | 82,377 | |
A01020_Beta_Daily.txt | 37,500 | |
A01030_ComboRevenueFactor_Daily.txt | 849,150 | |
A01040_CoverageLevelDifferential_Daily.txt | 1,458,550 | |
A01050_SubCountyRate_Daily.txt | 23,754 | |
A01060_OptionRate_Daily.txt | 578,373 | |
A01090_UnitDiscount_Daily.txt | 635 | |
A01100_YieldAndTyield_Daily.txt | 1,482,048 | |
A01105_YieldExclusion_Daily.txt | 127,068 | |
A01110_HistoricalRevenueCapping_Daily.txt | 17,706 | |
A01115_HistoricalYieldTrend_Daily.txt | 147,558 | |
A01120_AreaDataSource_Daily.txt | 30 | |
A01125_ProductionArea_Daily.txt | 51,653 | |
A01130_AreaCoverageLevel_Daily.txt | 633,462 | |
A01135_AreaRate_Daily.txt | 2,151,890 | |
A01200_DocumentBuilder_Daily.txt | 1,099,104 | |
A01210_Statement_Daily.txt | 246 | |
2017_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 170,046 |
A00045_Map_Filing.txt | 38,154 | |
A00200_Date_Filing.txt | 175,899 | |
A00810_Price_Filing.txt | 103,283 | |
A01010_BaseRate_Filing.txt | 82,377 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,458,550 | |
A01050_SubCountyRate_Filing.txt | 23,754 | |
A01060_OptionRate_Filing.txt | 578,373 | |
A01100_YieldAndTyield_Filing.txt | 1,482,048 | |
A01105_YieldExclusion_Filing.txt | 127,068 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,706 | |
A01130_AreaCoverageLevel_Filing.txt | 633,462 | |
A01200_DocumentBuilder_Filing.txt | 1,099,104 | |
2017_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,112 |
A00030_InsuranceOffer_YTD.txt | 185,101 | |
A00045_Map_YTD.txt | 140,481 | |
A00050_Quality_YTD.txt | 232 | |
A00070_SubsidyPercent_YTD.txt | 268 | |
A00200_Date_YTD.txt | 190,954 | |
A00410_Class_YTD.txt | 11 | |
A00420_Commodity_YTD.txt | 34 | |
A00430_CommodityType_YTD.txt | 65 | |
A00440_County_YTD.txt | 3,166 | |
A00450_CroppingPractice_YTD.txt | 31 | |
A00460_InsurancePlan_YTD.txt | 16 | |
A00470_IntendedUse_YTD.txt | 4 | |
A00480_Interval_YTD.txt | 39 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 297 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 3 | |
A00540_Type_YTD.txt | 103 | |
A00550_DocumentStructure_YTD.txt | 18 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 25 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 21 | |
A00810_Price_YTD.txt | 116,069 | |
A01010_BaseRate_YTD.txt | 84,288 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 849,150 | |
A01040_CoverageLevelDifferential_YTD.txt | 1,516,159 | |
A01050_SubCountyRate_YTD.txt | 24,357 | |
A01060_OptionRate_YTD.txt | 581,912 | |
A01090_UnitDiscount_YTD.txt | 672 | |
A01100_YieldAndTyield_YTD.txt | 1,488,432 | |
A01105_YieldExclusion_YTD.txt | 127,068 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,706 | |
A01115_HistoricalYieldTrend_YTD.txt | 147,558 | |
A01120_AreaDataSource_YTD.txt | 30 | |
A01125_ProductionArea_YTD.txt | 51,653 | |
A01130_AreaCoverageLevel_YTD.txt | 1,083,954 | |
A01135_AreaRate_YTD.txt | 2,360,458 | |
A01200_DocumentBuilder_YTD.txt | 1,200,329 | |
A01210_Statement_YTD.txt | 377 | |
2017_SPOI_0630.zip | 2017 Special Provisions 06/30 Filing Date | 4,561 |