2017 Actuarial Data Master are in the References/Actuarial_Data_Master/2017 directory. 2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.

Additional notes and details regarding this data release:

2017 & 2018 ADM Insurance Offer for Hybrid Sorghum Seed (0050/55) updated 'Program Type Code' to be 'R' as this commodity/plan is regulatory, 11/30 filing. 2018 ADM Base Rate county yield updated for private product (Section 508(h)) Hybrid Seed Rice (0080/55) as determined by the ADM Female only factor (1.34) established in the Insurance Standards Handbook.

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_171211.zip	A00030_InsuranceOffer_Daily.txt	360
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	959,170
	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,984,890
	A01200_DocumentBuilder_Filing.txt	6,552,308
2017_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	1,117
	A00030_InsuranceOffer_YTD.txt	1,478,981
	A00045_Map_YTD.txt	3,298,356
	A00050_Quality_YTD.txt	510
	A00070_SubsidyPercent_YTD.txt	498
	A00200_Date_YTD.txt	1,485,485
	A00400_AgrCommodity_YTD.txt	431
	A00410_Class_YTD.txt	24
	A00420_Commodity_YTD.txt	127
	A00430_CommodityType_YTD.txt	364
	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	550
	A00550_DocumentStructure_YTD.txt	21
	A00560_EndorsementLength_YTD.txt	1
	A00570_InsuranceOption_YTD.txt	46
	A00580_RateMethod_YTD.txt	4
	A00590_SpoiGroup_YTD.txt	95
	A00615_Draw_YTD.txt	76,700
	A00810_Price_YTD.txt	2,998,996
	A01000_AgrRate_YTD.txt	9,898,224
	A01010_BaseRate_YTD.txt	762,068
	A01020_Beta_YTD.txt	121,500
	A01030_ComboRevenueFactor_YTD.txt	2,857,140
	A01040_CoverageLevelDifferential_YTD.txt	12,650,747
	A01050_SubCountyRate_YTD.txt	195,367
	A01060_OptionRate_YTD.txt	4,607,891
	A01070_Proration_YTD.txt	2,738,688
	A01090_UnitDiscount_YTD.txt	2,899
	A01100_YieldAndTyield_YTD.txt	11,127,004
	A01105_YieldExclusion_YTD.txt	615,027
	A01110_HistoricalRevenueCapping_YTD.txt	156,294
	A01115_HistoricalYieldTrend_YTD.txt	724,426
	A01120_AreaDataSource_YTD.txt	130
	A01125_ProductionArea_YTD.txt	177,728
	A01130_AreaCoverageLevel_YTD.txt	12,269,758
	A01135_AreaRate_YTD.txt	13,886,372
	A01200_DocumentBuilder_YTD.txt	13,723,962
	A01210_Statement_YTD.txt	1,298
2018_ADM_Daily_171211.zip	A00030_InsuranceOffer_Daily.txt	360
	A01010_BaseRate_Daily.txt	21
2018_ADM_Filing_1130.zip	A00030_InsuranceOffer_Filing.txt	887,120
	A00045_Map_Filing.txt	213,653
	A00200_Date_Filing.txt	887,771
	A00810_Price_Filing.txt	675,511
	A01010_BaseRate_Filing.txt	419,549
	A01040_CoverageLevelDifferential_Filing.txt	8,412,792
	A01050_SubCountyRate_Filing.txt	160,795
	A01060_OptionRate_Filing.txt	3,243,686
	A01100_YieldAndTyield_Filing.txt	7,581,422
	A01105_YieldExclusion_Filing.txt	478,074
	A01110_HistoricalRevenueCapping_Filing.txt	138,498
	A01130_AreaCoverageLevel_Filing.txt	3,981,792
	A01200_DocumentBuilder_Filing.txt	5,878,873
	A01220_GuaranteeAdjustment_Filing.txt	813,187
2018_ADM_YTD.zip	A00010_AdmLayout_YTD.txt	1,140
	A00030_InsuranceOffer_YTD.txt	1,350,683
	A00045_Map_YTD.txt	4,522,763
	A00050_Quality_YTD.txt	530
	A00070_SubsidyPercent_YTD.txt	482
	A00200_Date_YTD.txt	1,357,517
	A00400_AgrCommodity_YTD.txt	435
	A00410_Class_YTD.txt	24
	A00420_Commodity_YTD.txt	115
	A00430_CommodityType_YTD.txt	339
	A00440_County_YTD.txt	3,190
	A00450_CroppingPractice_YTD.txt	80
	A00460_InsurancePlan_YTD.txt	25
	A00470_IntendedUse_YTD.txt	12
	A00480_Interval_YTD.txt	41
	A00490_IrrigationPractice_YTD.txt	3
	A00500_OrganicPractice_YTD.txt	3
	A00510_Practice_YTD.txt	1,056
	A00520_State_YTD.txt	50
	A00530_SubClass_YTD.txt	6
	A00540_Type_YTD.txt	506
	A00550_DocumentStructure_YTD.txt	20
	A00560_EndorsementLength_YTD.txt	1
	A00570_InsuranceOption_YTD.txt	45
	A00580_RateMethod_YTD.txt	4
	A00590_SpoiGroup_YTD.txt	103
	A00615_Draw_YTD.txt	23,912,500
	A00810_Price_YTD.txt	3,010,495
	A01000_AgrRate_YTD.txt	10,747,415
	A01010_BaseRate_YTD.txt	536,626
	A01020_Beta_YTD.txt	121,500
	A01030_ComboRevenueFactor_YTD.txt	2,857,140
	A01040_CoverageLevelDifferential_YTD.txt	11,520,416
	A01050_SubCountyRate_YTD.txt	190,309
	A01060_OptionRate_YTD.txt	3,978,913
	A01070_Proration_YTD.txt	384
	A01090_UnitDiscount_YTD.txt	2,849
	A01100_YieldAndTyield_YTD.txt	11,391,425
	A01105_YieldExclusion_YTD.txt	624,090
	A01110_HistoricalRevenueCapping_YTD.txt	156,186
	A01115_HistoricalYieldTrend_YTD.txt	795,825
	A01120_AreaDataSource_YTD.txt	126
	A01125_ProductionArea_YTD.txt	177,586
	A01130_AreaCoverageLevel_YTD.txt	15,254,383
	A01135_AreaRate_YTD.txt	11,502,856
	A01200_DocumentBuilder_YTD.txt	8,234,503
	A01210_Statement_YTD.txt	1,201
	A01220_GuaranteeAdjustment_YTD.txt	997,825