2017 Actuarial Data Master for the 8/31 Filing Date, YTD, and Daily Files. 2017 Special Provisions for the 8/31 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 are released for Whole Farm Revenue Protection (WFRP), 8/31 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-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_160830.zip	A00030_InsuranceOffer_Daily.txt	9,420
	A00070_SubsidyPercent_Daily.txt	20
	A00200_Date_Daily.txt	9,420
	A00400_AgrCommodity_Daily.txt	431
	A00420_Commodity_Daily.txt	1
	A00430_CommodityType_Daily.txt	3
	A00440_County_Daily.txt	24
	A00460_InsurancePlan_Daily.txt	1
	A00510_Practice_Daily.txt	1
	A00540_Type_Daily.txt	3
	A01000_AgrRate_Daily.txt	9,898,224
	A01040_CoverageLevelDifferential_Daily.txt	75,312
	A01200_DocumentBuilder_Daily.txt	129,001
	A01210_Statement_Daily.txt	13
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	325,462
	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_YTD.zip	A00010_AdmLayout_YTD.txt	1,112
	A00030_InsuranceOffer_YTD.txt	360,145
	A00045_Map_YTD.txt	1,738,819
	A00050_Quality_YTD.txt	253
	A00070_SubsidyPercent_YTD.txt	355
	A00200_Date_YTD.txt	365,998
	A00400_AgrCommodity_YTD.txt	431
	A00410_Class_YTD.txt	14
	A00420_Commodity_YTD.txt	79
	A00430_CommodityType_YTD.txt	248
	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	21
	A00810_Price_YTD.txt	444,274
	A01000_AgrRate_YTD.txt	9,898,224
	A01010_BaseRate_YTD.txt	109,424
	A01020_Beta_YTD.txt	37,500
	A01030_ComboRevenueFactor_YTD.txt	889,110
	A01040_CoverageLevelDifferential_YTD.txt	2,556,314
	A01050_SubCountyRate_YTD.txt	29,523
	A01060_OptionRate_YTD.txt	693,016
	A01070_Proration_YTD.txt	384
	A01090_UnitDiscount_YTD.txt	818
	A01100_YieldAndTyield_YTD.txt	3,958,668
	A01105_YieldExclusion_YTD.txt	140,619
	A01110_HistoricalRevenueCapping_YTD.txt	17,706
	A01115_HistoricalYieldTrend_YTD.txt	167,835
	A01120_AreaDataSource_YTD.txt	51
	A01125_ProductionArea_YTD.txt	58,548
	A01130_AreaCoverageLevel_YTD.txt	8,253,523
	A01135_AreaRate_YTD.txt	6,251,164
	A01200_DocumentBuilder_YTD.txt	1,906,819
	A01210_Statement_YTD.txt	738
2017_SPOI_0831.zip	2017 Special Provisions 08/31 Filing Date	9,294