Date
To
All Insurance Providers
From
Zachary White Chief, Actuarial Branch /s/ Zachary White
Subject
Actuarial Release 17-024 - Actuarial Information Available
As of August 01, 2017 the following information is now available on the FTP site:
- 2016 Actuarial Data Master for the 8/31, 11/30, 12/31 Filing Date, YTD, and Daily Files.
- 2017 Actuarial Data Master for the 6/30, 11/30 Filing Date, YTD, and Daily Files.
- 2018 Actuarial Data Master for the 6/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.
- 2018 Actuarial Data Master are in the References/Actuarial_Data_Master/2018 directory.
Additional notes and details regarding this data release:
2016 SCO (plan 31) final county yields on safflower and tomatoes are issued via ADM Area Risk Rate, reference PM-17-046.
2017 ADM Price updated for the harvest price announcement, PM-17-045, 6/30 and 11/30 filings.
2018 Margin Protection (plans 16/17) on 24 specific expansion counties on corn are being removed in addition to the 20 counties announced on July 17, (7 counties in Kansas, 2 for Michigan, 9 in North Dakota, 4 in South Dakota, and 2 in Wisconsin). These will be marked with a deleted date in the ADM files previously released and the appropriate SPOI PDF files are now removed from the 6/30 SPOI zip for corn plan 16 folder. End users are requested to purge previously downloaded PDFs. Total number of 2018 MP corn counties to be offered is 793.
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_170801.zip | A01005_AreaRiskRate_Daily.txt | 4,302 |
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_Filing_1130.zip | A00030_InsuranceOffer_Filing.txt | 886,327 |
A00045_Map_Filing.txt | 214,856 | |
A00200_Date_Filing.txt | 886,978 | |
A00810_Price_Filing.txt | 962,662 | |
A01005_AreaRiskRate_Filing.txt | 68,341,538 | |
A01010_BaseRate_Filing.txt | 418,887 | |
A01040_CoverageLevelDifferential_Filing.txt | 8,123,808 | |
A01050_SubCountyRate_Filing.txt | 146,647 | |
A01060_OptionRate_Filing.txt | 3,205,652 | |
A01100_YieldAndTyield_Filing.txt | 6,836,241 | |
A01105_YieldExclusion_Filing.txt | 466,461 | |
A01110_HistoricalRevenueCapping_Filing.txt | 138,738 | |
A01200_DocumentBuilder_Filing.txt | 8,887,029 | |
2016_ADM_Filing_1231.zip | A00030_InsuranceOffer_Filing.txt | 894 |
A00045_Map_Filing.txt | 453 | |
A00200_Date_Filing.txt | 894 | |
A00810_Price_Filing.txt | 894 | |
A01005_AreaRiskRate_Filing.txt | 2,412 | |
A01010_BaseRate_Filing.txt | 492 | |
A01040_CoverageLevelDifferential_Filing.txt | 6,192 | |
A01050_SubCountyRate_Filing.txt | 144 | |
A01060_OptionRate_Filing.txt | 3,214 | |
A01100_YieldAndTyield_Filing.txt | 10,260 | |
A01105_YieldExclusion_Filing.txt | 402 | |
A01200_DocumentBuilder_Filing.txt | 8,065 | |
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,267,262 | |
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_170801.zip | A00810_Price_Daily.txt | 27,570 |
2017_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 170,930 |
A00045_Map_Filing.txt | 38,187 | |
A00200_Date_Filing.txt | 176,783 | |
A00810_Price_Filing.txt | 172,748 | |
A01010_BaseRate_Filing.txt | 82,470 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,463,639 | |
A01050_SubCountyRate_Filing.txt | 23,787 | |
A01060_OptionRate_Filing.txt | 591,628 | |
A01100_YieldAndTyield_Filing.txt | 1,483,536 | |
A01105_YieldExclusion_Filing.txt | 127,068 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,706 | |
A01130_AreaCoverageLevel_Filing.txt | 659,377 | |
A01200_DocumentBuilder_Filing.txt | 1,107,631 | |
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,888,350 | |
A01200_DocumentBuilder_YTD.txt | 13,723,962 | |
A01210_Statement_YTD.txt | 1,298 | |
2018_ADM_Daily_170801.zip | A00030_InsuranceOffer_Daily.txt | 164 |
A00200_Date_Daily.txt | 164 | |
A01040_CoverageLevelDifferential_Daily.txt | 984 | |
A01060_OptionRate_Daily.txt | 164 | |
A01200_DocumentBuilder_Daily.txt | 1,312 | |
2018_ADM_Filing_0630.zip | A00030_InsuranceOffer_Filing.txt | 182,975 |
A00045_Map_Filing.txt | 40,221 | |
A00200_Date_Filing.txt | 189,158 | |
A00810_Price_Filing.txt | 104,611 | |
A01010_BaseRate_Filing.txt | 85,407 | |
A01040_CoverageLevelDifferential_Filing.txt | 1,558,642 | |
A01050_SubCountyRate_Filing.txt | 25,389 | |
A01060_OptionRate_Filing.txt | 615,971 | |
A01100_YieldAndTyield_Filing.txt | 1,628,226 | |
A01105_YieldExclusion_Filing.txt | 131,439 | |
A01110_HistoricalRevenueCapping_Filing.txt | 17,688 | |
A01130_AreaCoverageLevel_Filing.txt | 657,246 | |
A01200_DocumentBuilder_Filing.txt | 1,234,230 | |
A01220_GuaranteeAdjustment_Filing.txt | 181,947 | |
2018_ADM_YTD.zip | A00010_AdmLayout_YTD.txt | 1,140 |
A00030_InsuranceOffer_YTD.txt | 206,914 | |
A00045_Map_YTD.txt | 481,644 | |
A00050_Quality_YTD.txt | 237 | |
A00070_SubsidyPercent_YTD.txt | 281 | |
A00200_Date_YTD.txt | 213,097 | |
A00410_Class_YTD.txt | 11 | |
A00420_Commodity_YTD.txt | 37 | |
A00430_CommodityType_YTD.txt | 66 | |
A00440_County_YTD.txt | 3,166 | |
A00450_CroppingPractice_YTD.txt | 38 | |
A00460_InsurancePlan_YTD.txt | 18 | |
A00470_IntendedUse_YTD.txt | 6 | |
A00480_Interval_YTD.txt | 41 | |
A00490_IrrigationPractice_YTD.txt | 3 | |
A00500_OrganicPractice_YTD.txt | 3 | |
A00510_Practice_YTD.txt | 335 | |
A00520_State_YTD.txt | 50 | |
A00530_SubClass_YTD.txt | 3 | |
A00540_Type_YTD.txt | 110 | |
A00550_DocumentStructure_YTD.txt | 19 | |
A00560_EndorsementLength_YTD.txt | 1 | |
A00570_InsuranceOption_YTD.txt | 26 | |
A00580_RateMethod_YTD.txt | 4 | |
A00590_SpoiGroup_YTD.txt | 27 | |
A00810_Price_YTD.txt | 312,189 | |
A01010_BaseRate_YTD.txt | 87,318 | |
A01020_Beta_YTD.txt | 37,500 | |
A01030_ComboRevenueFactor_YTD.txt | 1,108,890 | |
A01040_CoverageLevelDifferential_YTD.txt | 1,654,455 | |
A01050_SubCountyRate_YTD.txt | 25,992 | |
A01060_OptionRate_YTD.txt | 619,510 | |
A01090_UnitDiscount_YTD.txt | 816 | |
A01100_YieldAndTyield_YTD.txt | 1,635,009 | |
A01105_YieldExclusion_YTD.txt | 131,439 | |
A01110_HistoricalRevenueCapping_YTD.txt | 17,688 | |
A01115_HistoricalYieldTrend_YTD.txt | 153,345 | |
A01120_AreaDataSource_YTD.txt | 31 | |
A01125_ProductionArea_YTD.txt | 51,790 | |
A01130_AreaCoverageLevel_YTD.txt | 1,551,856 | |
A01135_AreaRate_YTD.txt | 2,627,804 | |
A01200_DocumentBuilder_YTD.txt | 1,388,985 | |
A01210_Statement_YTD.txt | 416 | |
A01220_GuaranteeAdjustment_YTD.txt | 182,130 |