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