{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Overview","Earthquake Survey","Earthquake Exposure by County","Validation"],"not_rendered":{"defined_names":26},"read":"whole","date_system":"1900"}

{"sheet":"Overview","index":0,"n_rows":8,"n_cols":3,"rows_kept":8,"merged":[[2,2,2,14],[4,2,4,14],[5,2,5,14],[6,2,6,14],[7,2,7,14],[8,2,8,5]]}
[]
[]
[null,null,"Earthquake Data Submission Template 2025"]
[]
[null,null,"1. Overview and Purpose"]
[null,null,"Who uses this template? and when?\nThis data submission is required only for residential personal lines, not commercial lines of business. Companies not writing personal lines property coverages are not required to submit the report.The submission site at https://rhld.insurance.arkansas.gov/EarthquakeData is available starting December 15th each year. Completed templates must be submitted by April 1st.\n"]
[null,null,"2. Using the Template"]
[null,null,"The correct version of the Excel template should be used. Please check the year in the filename and the title above to make sure you are using the verion for the year on which you are reporting. Data must be submitted as an Excel file. Any other file type, including a PDF, will cause an error. \n\nNOTE: There are 2 data entry tabs in this survey: one called \"Earthquake Data\" for general and premium information, and one called \"Earthquake Exposure by County.\" Please don't forget to fill out the Earthquake Exposure by County tab.\n\nIf your organization provides earthquake coverage in more than one of the four categories below, please provide separate forms (Excel templates) for each category your organization provides earthquake coverage for (do not combine values into one form).\n             o Category 1: Homeowners / Dwelling Fire (Dwelling & Contents)\n             o Category 2: Farmowners (Dwelling & Contents)\n             o Category 3: Renters (Contents only)\n             o Category 4: Mobile or Manufactured Homes (Dwelling & Contents)\n\nQuestions 1 through 8 on the \"Earthquake Survey\" tab are mandatory for all personal lines of business issuers, irrespective of whether the issuer provides earthquake coverage or not. If your company writes any of the personal lines property categories above, but does not write earthquake coverage, please submit only one form (choose any one category) with answers to only the first 8 mandatory fields and “N” for the following two questions. \n                  Currently writing EQ on renewal business? (Y/N) \n                  Currently writing EQ on new business? (Y/N)  \n\nIf your organization provides earthquake coverage in more than one of the four categories, please provide separate Excel files for each category your organization provides earthquake coverage for (do not combine values into one form). It does not matter what you name your file."]

{"sheet":"Earthquake Survey","index":1,"n_rows":40,"n_cols":6,"rows_kept":40,"merged":[[6,5,9,6],[17,0,17,3],[18,0,18,1],[25,0,25,1],[32,0,32,1],[39,0,39,3]]}
["Question #","Question","Response","Explanatory Comments"]
[1,"Five-digit NAIC company code"]
[2,"Company name"]
["2A","Coverage type category"]
[3,"Date Submitted",{"$f":"TODAY()","v":"2025-12-16"}]
[4,"Contact Person"]
[5,"Contact Email",{"$nulls":3},"NOTE: There are 2 tabs in this survey.  Please don't forget to fill out the Earthquake Exposure by County tab."]
[6,"Telephone Number"]
[7,"Currently writing EQ on renewal business? (Y/N)"]
[8,"Currently writing EQ on new business? (Y/N)"]
["9A","Does the company have underwriting restrictions in NE AR (New Madrid Zone) that are more strict than elsewhere in the state? (Y/N)"]
["9B","If answer to 9A is \"yes,\" please describe the underwriting restrictions"]
["10A","What is the minimum required deductible offered in the New Madrid Zone?"]
["10B","What is the minimum required deductible offered anywhere in the state?"]
["10C","What is the maximum deductible offered in AR?"]
["11A","Does the company offer any discounts for EQ mitigation measures? (Y/N)"]
["11B","If answer to 11A is yes, please explain"]
["For the following locations, what is the average annual base premium for Earthquake coverage only (excluding discounts or surcharges) for a $200,000 ranch home, 2,500 square feet, composite shingle roof, with a 10% deductible, unless otherwise noted? Note: Please do not report the entire homeowners premium; we are requesting the premium of Earthquake coverage only."]
["For Frame Dwellings in:",null,"Premium Amount"]
["12A","Wheeler St, Osceola, Mississippi County, AR 72370 15% Deductible"]
["12B","Pecan St., Marked Tree, Poinsett County, AR 72365 15% Deductible"]
["12C","Cherry St., Star City, Lincoln County, AR 71667"]
["12D","Ingram Rd., Enola, Faulkner County, AR 72047"]
["12E","Ann St., Springdale, Washington County, AR 72762"]
["12F","Friendship Dr., Arkadelphia, Clark County AR 71923"]
["For Masonry Veneer Dwellings in:",null,"Premium Amount"]
["13A","Wheeler St, Osceola, Mississippi County, AR 72370 15% Deductible"]
["13B","Pecan St., Marked Tree, Poinsett County, AR 72365 15% Deductible"]
["13C","Cherry St., Star City, Lincoln County, AR 71667"]
["13D","Ingram Rd., Enola, Faulkner County, AR 72047"]
["13E","Ann St., Springdale, Washington County, AR 72762"]
["13F","Friendship Dr., Arkadelphia, Clark County AR 71923"]
["For Masonry Dwellings in: ",null,"Premium Amount"]
["14A","Wheeler St, Osceola, Mississippi County, AR 72370 15% Deductible"]
["14B","Pecan St., Marked Tree, Poinsett County, AR 72365 15% Deductible"]
["14C","Cherry St., Star City, Lincoln County, AR 71667"]
["14D","Ingram Rd., Enola, Faulkner County, AR 72047"]
["14E","Ann St., Springdale, Washington County, AR 72762"]
["14F","Friendship Dr., Arkadelphia, Clark County AR 71923"]
["*PLEASE COMPLETE EARTHQUAKE PREMIUM EXPOSURE BY COUNTY ON NEXT WORKSHEET*"]

{"sheet":"Earthquake Exposure by County","index":2,"n_rows":78,"n_cols":5,"rows_kept":78,"merged":[[0,0,1,0],[0,1,0,4]]}
["County","Residential Earthquake Exposure"]
[null,"Dwelling","Contents","Premium","Policy Count"]
["Arkansas"]
["Ashley"]
["Baxter"]
["Benton"]
["Boone"]
["Bradley"]
["Calhoun"]
["Carroll"]
["Chicot"]
["Clark"]
["Clay "]
["Cleburne"]
["Cleveland"]
["Columbia"]
["Conway"]
["Craighead"]
["Crawford"]
["Crittenden"]
["Cross"]
["Dallas"]
["Desha"]
["Drew"]
["Faulkner"]
["Franklin"]
["Fulton"]
["Garland"]
["Grant"]
["Greene"]
["Hempstead"]
["Hot Spring"]
["Howard"]
["Independence"]
["Izard"]
["Jackson"]
["Jefferson"]
["Johnson"]
["Lafayette"]
["Lawrence"]
["Lee"]
["Lincoln"]
["Little River"]
["Logan"]
["Lonoke"]
["Madison"]
["Marion"]
["Miller"]
["Mississippi"]
["Monroe"]
["Montgomery"]
["Nevada"]
["Newton"]
["Ouachita"]
["Perry"]
["Phillips"]
["Pike"]
["Poinsett"]
["Polk"]
["Pope"]
["Prairie"]
["Pulaski"]
["Randolph"]
["Saline"]
["Scott"]
["Searcy"]
["Sebastian"]
["Sevier"]
["Sharp"]
["St. Francis"]
["Stone"]
["Union"]
["Van Buren"]
["Washington"]
["White"]
["Woodruff"]
["Yell"]
["Total",{"$f":"SUM(B3:B77)","v":{"v":0,"d":"$0"}},{"$f":"SUM(C3:C77)","v":{"v":0,"d":"$0"}},{"$f":"SUM(D3:D77)","v":{"v":0,"d":"$0"}},{"$f":"SUM(E3:E77)","v":0}]

{"sheet":"Validation","index":3,"n_rows":816,"n_cols":3,"rows_kept":816,"hidden":true}
["Y",10003,"Homeowners / Dwelling Fire (Dwelling & Contents)"]
["N",10014,"Renters (Contents only)"]
[null,10019,"Mobile or Manufactured Homes (Dwelling & Contents)"]
[null,10030,"Farmowners (Dwelling & Contents)"]
[null,10051]
[null,10052]
[null,10069]
[null,10071]
[null,10103]
[null,10111]
[null,10117]
[null,10120]
[null,10127]
[null,10166]
[null,10178]
[null,10200]
[null,10204]
[null,10212]
[null,10219]
[null,10220]
[null,10227]
[null,10235]
[null,10239]
[null,10243]
[null,10246]
[null,10251]
[null,10340]
[null,10348]
[null,10349]
[null,10351]
[null,10357]
[null,10358]
[null,10367]
[null,10391]
[null,10472]
[null,10499]
[null,10510]
[null,10641]
[null,10642]
[null,10671]
[null,10677]
[null,10690]
[null,10708]
[null,10723]
[null,10749]
[null,10758]
[null,10783]
[null,10784]
[null,10799]
[null,10804]
[null,10810]
[null,10815]
[null,10817]
[null,10819]
[null,10829]
[null,10847]
[null,10855]
[null,10859]
[null,10872]
[null,10885]
[null,10891]
[null,10915]
[null,10922]
[null,10936]
[null,10945]
[null,10946]
[null,10948]
[null,10952]
[null,10957]
[null,10974]
[null,10984]
[null,10985]
[null,10993]
[null,10997]
[null,11000]
[null,11004]
[null,11027]
[null,11044]
[null,11050]
[null,11054]
[null,11089]
[null,11090]
[null,11110]
[null,11118]
[null,11126]
[null,11127]
[null,11134]
[null,11142]
[null,11150]
[null,11162]
[null,11177]
[null,11185]
[null,11206]
[null,11215]
[null,11223]
[null,11231]
[null,11240]
[null,11255]
[null,11258]
[null,11371]
[null,11398]
[null,11452]
[null,11523]
[null,11551]
[null,11558]
[null,11630]
[null,11770]
[null,11800]
[null,11828]
[null,11835]
[null,11851]
[null,11853]
[null,11932]
[null,11967]
[null,11981]
[null,11991]
[null,12114]
[null,12188]
[null,12254]
[null,12260]
[null,12262]
[null,12297]
[null,12304]
[null,12305]
[null,12319]
[null,12356]
[null,12416]
[null,12484]
[null,12491]
[null,12504]
[null,12508]
[null,12536]
[null,12538]
[null,12548]
[null,12572]
[null,12645]
[null,12696]
[null,12718]
[null,12750]
[null,12777]
[null,12810]
[null,12831]
[null,12866]
[null,12873]
[null,12879]
[null,12944]
[null,12963]
[null,12998]
[null,13021]
[null,13056]
[null,13137]
[null,13269]
[null,13293]
[null,13412]
[null,13528]
[null,13703]
[null,13714]
[null,13722]
[null,13757]
[null,13897]
[null,13927]
[null,13935]
[null,13978]
[null,13986]
[null,14184]
[null,14244]
[null,14245]
[null,14246]
[null,14247]
[null,14250]
[null,14251]
[null,14252]
[null,14254]
[null,14265]
[null,14354]
[null,14508]
[null,14559]
[null,14702]
[null,14788]
[null,14974]
[null,14982]
[null,14990]
[null,15032]
[null,15059]
[null,15105]
[null,15130]
[null,15350]
[null,15474]
[null,15563]
[null,15580]
[null,15679]
[null,15725]
[null,15756]
[null,15885]
[null,15911]
[null,15954]
[null,16023]
[null,16024]
[null,16044]
[null,16045]
[null,16047]
[null,16063]
[null,16070]
[null,16109]
[null,16116]
[null,16125]
[null,16186]
[null,16187]
[null,16203]
[null,16217]
[null,16262]
[null,16273]
[null,16285]
[null,16322]
[null,16356]
[null,16447]
[null,16448]
[null,16449]
[null,16450]
[null,16461]
[null,16510]
[null,16535]
[null,16561]
[null,16578]
[null,16608]
[null,16624]
[null,16632]
[null,16691]
[null,16705]
[null,16810]
[null,16825]
[null,16875]
[null,17043]
[null,17105]
[null,17133]
[null,17136]
[null,17182]
[null,17203]
[null,17221]
[null,17230]
[null,17285]
[null,17558]
[null,17647]
[null,17965]
[null,18023]
[null,18031]
[null,18058]
[null,18139]
[null,18236]
[null,18279]
[null,18295]
[null,18325]
[null,18333]
[null,18430]
[null,18468]
[null,18600]
[null,18619]
[null,18694]
[null,18767]
[null,18961]
[null,18988]
[null,19038]
[null,19046]
[null,19062]
[null,19070]
[null,19100]
[null,19178]
[null,19216]
[null,19224]
[null,19232]
[null,19240]
[null,19348]
[null,19380]
[null,19399]
[null,19402]
[null,19410]
[null,19429]
[null,19445]
[null,19453]
[null,19488]
[null,19496]
[null,19518]
[null,19526]
[null,19530]
[null,19615]
[null,19623]
[null,19631]
[null,19640]
[null,19658]
[null,19682]
[null,19690]
[null,19704]
[null,19712]
[null,19720]
[null,19801]
[null,19828]
[null,19860]
[null,19879]
[null,19887]
[null,19917]
[null,19941]
[null,19976]
[null,19992]
[null,20044]
[null,20052]
[null,20087]
[null,20095]
[null,20109]
[null,20117]
[null,20141]
[null,20222]
[null,20230]
[null,20273]
[null,20281]
[null,20303]
[null,20320]
[null,20338]
[null,20346]
[null,20362]
[null,20370]
[null,20397]
[null,20400]
[null,20427]
[null,20443]
[null,20451]
[null,20478]
[null,20494]
[null,20508]
[null,20532]
[null,20583]
[null,20613]
[null,20699]
[null,20702]
[null,20710]
[null,20796]
[null,20931]
[null,20982]
[null,20990]
[null,21008]
[null,21032]
[null,21075]
[null,21105]
[null,21113]
[null,21164]
[null,21172]
[null,21180]
[null,21253]
[null,21261]
[null,21296]
[null,21326]
[null,21407]
[null,21415]
[null,21423]
[null,21458]
[null,21482]
[null,21628]
[null,21652]
[null,21660]
[null,21687]
[null,21709]
[null,21784]
[null,21830]
[null,21849]
[null,21857]
[null,21865]
[null,21873]
[null,21881]
[null,21903]
[null,21911]
[null,21962]
[null,21970]
[null,21989]
[null,22004]
[null,22012]
[null,22039]
[null,22055]
[null,22063]
[null,22098]
[null,22136]
[null,22179]
[null,22187]
[null,22209]
[null,22225]
[null,22233]
[null,22241]
[null,22250]
[null,22268]
[null,22276]
[null,22292]
[null,22306]
[null,22314]
[null,22322]
[null,22357]
[null,22390]
[null,22454]
[null,22543]
[null,22551]
[null,22578]
[null,22608]
[null,22667]
[null,22683]
[null,22713]
[null,22730]
[null,22748]
[null,22772]
[null,22780]
[null,22810]
[null,22837]
[null,22861]
[null,22888]
[null,22906]
[null,22926]
[null,22950]
[null,22985]
[null,23035]
[null,23043]
[null,23108]
[null,23248]
[null,23280]
[null,23337]
[null,23353]
[null,23361]
[null,23388]
[null,23396]
[null,23418]
[null,23426]
[null,23434]
[null,23450]
[null,23469]
[null,23515]
[null,23574]
[null,23582]
[null,23612]
[null,23647]
[null,23663]
[null,23680]
[null,23728]
[null,23736]
[null,23752]
[null,23760]
[null,23787]
[null,23795]
[null,23809]
[null,23833]
[null,23841]
[null,23876]
[null,23965]
[null,24015]
[null,24031]
[null,24066]
[null,24074]
[null,24082]
[null,24104]
[null,24112]
[null,24120]
[null,24139]
[null,24147]
[null,24171]
[null,24198]
[null,24260]
[null,24279]
[null,24295]
[null,24376]
[null,24414]
[null,24449]
[null,24503]
[null,24538]
[null,24554]
[null,24678]
[null,24724]
[null,24732]
[null,24740]
[null,24759]
[null,24767]
[null,24775]
[null,24791]
[null,24813]
[null,24899]
[null,24961]
[null,24988]
[null,25011]
[null,25054]
[null,25127]
[null,25135]
[null,25143]
[null,25151]
[null,25178]
[null,25180]
[null,25186]
[null,25224]
[null,25232]
[null,25240]
[null,25321]
[null,25364]
[null,25453]
[null,25496]
[null,25534]
[null,25585]
[null,25615]
[null,25623]
[null,25658]
[null,25666]
[null,25674]
[null,25682]
[null,25712]
[null,25747]
[null,25780]
[null,25798]
[null,25844]
[null,25879]
[null,25887]
[null,25895]
[null,25909]
[null,25941]
[null,25968]
[null,25976]
[null,25984]
[null,26042]
[null,26050]
[null,26069]
[null,26077]
[null,26085]
[null,26093]
[null,26182]
[null,26220]
[null,26247]
[null,26298]
[null,26344]
[null,26379]
[null,26395]
[null,26433]
[null,26492]
[null,26581]
[null,26611]
[null,26638]
[null,26662]
[null,26697]
[null,26832]
[null,26905]
[null,26921]
[null,27090]
[null,27120]
[null,27138]
[null,27154]
[null,27235]
[null,27502]
[null,27626]
[null,27740]
[null,27847]
[null,27855]
[null,27871]
[null,27928]
[null,27998]
[null,28188]
[null,28207]
[null,28223]
[null,28258]
[null,28304]
[null,28339]
[null,28401]
[null,28460]
[null,28535]
[null,28649]
[null,28665]
[null,28746]
[null,28860]
[null,28886]
[null,28932]
[null,29017]
[null,29033]
[null,29068]
[null,29157]
[null,29424]
[null,29459]
[null,29530]
[null,29580]
[null,29599]
[null,29688]
[null,29700]
[null,29718]
[null,29742]
[null,29793]
[null,29874]
[null,29890]
[null,29980]
[null,30058]
[null,30104]
[null,30120]
[null,30210]
[null,30325]
[null,30830]
[null,30945]
[null,31003]
[null,31089]
[null,31135]
[null,31194]
[null,31208]
[null,31232]
[null,31325]
[null,31348]
[null,31453]
[null,31470]
[null,31534]
[null,31887]
[null,31895]
[null,31925]
[null,31968]
[null,32077]
[null,32190]
[null,32220]
[null,32280]
[null,32301]
[null,32352]
[null,32387]
[null,32450]
[null,32506]
[null,32522]
[null,32603]
[null,32620]
[null,32700]
[null,32778]
[null,32786]
[null,32859]
[null,32867]
[null,32905]
[null,33014]
[null,33022]
[null,33049]
[null,33162]
[null,33170]
[null,33383]
[null,33480]
[null,33588]
[null,33600]
[null,33650]
[null,33723]
[null,33898]
[null,33987]
[null,34037]
[null,34274]
[null,34312]
[null,34339]
[null,34347]
[null,34495]
[null,34649]
[null,34690]
[null,34711]
[null,34762]
[null,34789]
[null,34924]
[null,35157]
[null,35181]
[null,35246]
[null,35289]
[null,35300]
[null,35319]
[null,35386]
[null,35408]
[null,35416]
[null,35424]
[null,35505]
[null,35602]
[null,35629]
[null,35696]
[null,35769]
[null,35882]
[null,35939]
[null,36064]
[null,36137]
[null,36145]
[null,36161]
[null,36170]
[null,36234]
[null,36404]
[null,36447]
[null,36455]
[null,36463]
[null,36552]
[null,36560]
[null,36587]
[null,36625]
[null,36650]
[null,36684]
[null,36765]
[null,36781]
[null,36897]
[null,36927]
[null,37001]
[null,37060]
[null,37141]
[null,37206]
[null,37214]
[null,37220]
[null,37257]
[null,37273]
[null,37478]
[null,37524]
[null,37540]
[null,37613]
[null,37621]
[null,37648]
[null,37710]
[null,37850]
[null,37877]
[null,37885]
[null,37907]
[null,37915]
[null,37923]
[null,37990]
[null,38067]
[null,38130]
[null,38156]
[null,38245]
[null,38261]
[null,38288]
[null,38300]
[null,38318]
[null,38512]
[null,38601]
[null,38636]
[null,38652]
[null,38660]
[null,38776]
[null,38911]
[null,38962]
[null,38970]
[null,38997]
[null,39012]
[null,39039]
[null,39136]
[null,39152]
[null,39217]
[null,39306]
[null,39322]
[null,39527]
[null,39608]
[null,39845]
[null,39942]
[null,39950]
[null,40029]
[null,40045]
[null,40088]
[null,40134]
[null,40142]
[null,40150]
[null,40169]
[null,40193]
[null,40258]
[null,40282]
[null,40371]
[null,40436]
[null,40460]
[null,40517]
[null,40550]
[null,40649]
[null,40703]
[null,40827]
[null,40843]
[null,40975]
[null,41050]
[null,41106]
[null,41181]
[null,41211]
[null,41238]
[null,41335]
[null,41343]
[null,41394]
[null,41424]
[null,41459]
[null,41483]
[null,41491]
[null,41513]
[null,41629]
[null,41750]
[null,41769]
[null,41840]
[null,41998]
[null,42048]
[null,42234]
[null,42307]
[null,42331]
[null,42376]
[null,42390]
[null,42404]
[null,42447]
[null,42471]
[null,42498]
[null,42552]
[null,42579]
[null,42587]
[null,42617]
[null,42722]
[null,42749]
[null,42757]
[null,42803]
[null,42889]
[null,42897]
[null,42919]
[null,42978]
[null,42986]
[null,42994]
[null,43044]
[null,43273]
[null,43460]
[null,43494]
[null,43575]
[null,43699]
[null,43753]
[null,43974]
[null,44245]
[null,44318]
[null,44369]
[null,44393]
[null,44725]
[null,44768]
[null,81108]