1 Reading data

1.1 NFIP

1.2 Election data

1.3 Yale perception data

1.4 Disaster declaration data

1.5 ACS Data

1.6 Merge Data

2 Regression Setup

2.1 Variables

2.2 Non-SFHA Sample

2.3 SFHA Sample

3 Table 1

3.1 Panel A Descriptive Stats Non-SFHA

## 
## ===================================================================================================
## Statistic                       Mean       St. Dev.     Pctl(25)      Median      Pctl(75)     N   
## ---------------------------------------------------------------------------------------------------
## policies_fraction              0.0446       0.0622       0.0162       0.0264       0.0467    16,735
## policies_fraction_pop          0.0203       0.0306       0.0069       0.0116       0.0208    16,735
## climatechangereal              0.6962       0.0581       0.6548       0.6976       0.7417    16,735
## worriedaboutclimatechange      0.5737       0.0677       0.5229       0.5744       0.6250    16,735
## climatechangeimpactpersonal    0.3971       0.0526       0.3552       0.3892       0.4382    16,735
## rep_gain                      -0.0315       0.1257      -0.1213      -0.0273       0.0502    16,709
## median_hh_income            76,102.1500  35,205.3100    51,957.5      67,108       91,174    16,735
## median_age                    40.6639       7.8075      35.3000      40.4000      45.2000    16,735
## white_frac                     0.7746       0.2113       0.6937       0.8431       0.9295    16,735
## college_frac                   0.2022       0.0563       0.1655       0.2042       0.2398    16,735
## total_population             5,212.9160   2,588.4100     3,570        4,801        6,334     16,735
## no_of_homes                  2,242.0080    999.3207     1,597.5       2,097        2,702     16,735
## owner_frac                     0.6768       0.1909       0.5633       0.7169       0.8236    16,735
## lr_cost                       230.7317     189.5796     139.4286     181.9048     232.2500   16,671
## median_house_age              53.1115      165.4379        28           38           50      16,735
## house_price                 270,985.5000 379,706.7000 122,354.0000 176,270.0000 285,151.6000 13,907
## ---------------------------------------------------------------------------------------------------
## 

3.2 Panel B Descriptive Stats SFHA

## 
## ===================================================================================================
## Statistic                       Mean       St. Dev.     Pctl(25)      Median      Pctl(75)     N   
## ---------------------------------------------------------------------------------------------------
## policies_fraction              0.0969       0.1500       0.0174       0.0350       0.0999    18,642
## policies_fraction_pop          0.0525       0.1751       0.0076       0.0155       0.0447    18,642
## climatechangereal              0.6915       0.0597       0.6472       0.6928       0.7357    18,642
## worriedaboutclimatechange      0.5684       0.0686       0.5166       0.5609       0.6213    18,642
## climatechangeimpactpersonal    0.3922       0.0529       0.3497       0.3817       0.4270    18,642
## hr_cost                       867.3781     592.3778     384.3348     885.6000    1,240.0000  18,642
## median_hh_income            69,870.0600  29,901.2100    50,091.5      63,064      82,430.5   18,642
## house_price                 243,952.9000 343,146.2000 116,342.9000 164,115.1000 256,340.6000 15,007
## total_population             4,767.8330   2,386.1510    3,208.2       4,442        5,919     18,642
## no_of_homes                  2,118.1280    983.2881     1,479.2       1,985       2,584.8    18,642
## median_house_age              48.4091      119.1528        30           40           51      18,642
## median_age                    40.9458       8.0128      35.5000      40.7000      45.4000    18,642
## white_frac                     0.7814       0.2215       0.6994       0.8611       0.9424    18,642
## college_frac                   0.2032       0.0547       0.1676       0.2045       0.2393    18,642
## owner_frac                     0.6660       0.1924       0.5515       0.7080       0.8135    18,642
## contentscovered                0.3811       0.2352       0.1860       0.3445       0.5551    18,642
## maxdeductible5000              0.3370       0.2037       0.1749       0.3077       0.4737    18,642
## ---------------------------------------------------------------------------------------------------
## 

4 Table 1 - OLS - Non-SFHA

New: Added hapenning and personal variables, added mean connectedness to a flood event in a distant (another state) county

## 
## =========================================================
##                                (1)       (2)       (3)   
## ---------------------------------------------------------
## worriedaboutclimatechange    0.086*                      
##                              (0.047)                     
## climatechangereal                       0.059            
##                                        (0.052)           
## climatechangeimpactpersonal                     0.200*** 
##                                                  (0.076) 
## log(median_hh_income)         0.013     0.012     0.013  
##                              (0.009)   (0.009)   (0.009) 
## log(median_age)              -0.001    -0.001    -0.001  
##                              (0.018)   (0.018)   (0.018) 
## log(white_frac)               0.018     0.018     0.018  
##                              (0.012)   (0.012)   (0.012) 
## log(college_frac)           -0.020*** -0.020*** -0.019***
##                              (0.007)   (0.007)   (0.007) 
## log(total_population)       0.066***  0.066***  0.066*** 
##                              (0.019)   (0.019)   (0.019) 
## log(no_of_homes)            -0.353*** -0.353*** -0.352***
##                              (0.027)   (0.027)   (0.027) 
## log(owner_frac)              0.038**   0.038**   0.039** 
##                              (0.016)   (0.016)   (0.016) 
## log(lr_cost)                0.013***  0.013***  0.013*** 
##                              (0.005)   (0.005)   (0.005) 
## log(median_house_age)         0.001     0.001     0.001  
##                              (0.002)   (0.002)   (0.002) 
## log(house_price)            -0.037*** -0.037*** -0.037***
##                              (0.013)   (0.013)   (0.013) 
## disaster_1                  0.019***  0.019***  0.019*** 
##                              (0.002)   (0.002)   (0.002) 
## disaster_2                  0.023***  0.023***  0.022*** 
##                              (0.002)   (0.002)   (0.002) 
## disaster_3                  0.018***  0.018***  0.018*** 
##                              (0.002)   (0.002)   (0.002) 
## log(flood_connectedness)    0.006***  0.006***  0.006*** 
##                              (0.002)   (0.002)   (0.002) 
## Tract                           Y         Y         Y    
## State*Year                      Y         Y         Y    
## N                            100,422   100,422   100,422 
## Adjusted R2                   0.967     0.967     0.967  
## =========================================================

4.1 Table 1: Disaster interaction

Referee comment: I am mostly about understanding their role as an “interaction term”. So for a given level of an individual’s climate risk perceptions, do natural disasters in the area (or in the US) increase the take up rates? So think of it as an interaction term in Table 2 for example. Some data is available to test this

## 
## ====================================================================
##                                           (1)       (2)       (3)   
## --------------------------------------------------------------------
## worriedaboutclimatechange               0.078*                      
##                                         (0.047)                     
## climatechangereal                                  0.048            
##                                                   (0.052)           
## climatechangeimpactpersonal                                 0.186** 
##                                                             (0.075) 
## disaster_1                              -0.003    -0.018    -0.0005 
##                                         (0.009)   (0.012)   (0.008) 
## log(median_hh_income)                    0.013     0.013     0.013  
##                                         (0.009)   (0.009)   (0.009) 
## log(median_age)                         -0.001    -0.001    -0.001  
##                                         (0.018)   (0.018)   (0.018) 
## log(white_frac)                          0.018     0.018     0.018  
##                                         (0.012)   (0.012)   (0.012) 
## log(college_frac)                      -0.020*** -0.020*** -0.019***
##                                         (0.007)   (0.007)   (0.007) 
## log(total_population)                  0.066***  0.066***  0.066*** 
##                                         (0.019)   (0.019)   (0.019) 
## log(no_of_homes)                       -0.353*** -0.353*** -0.352***
##                                         (0.027)   (0.027)   (0.027) 
## log(owner_frac)                         0.039**   0.038**   0.039** 
##                                         (0.016)   (0.016)   (0.016) 
## log(lr_cost)                           0.013***  0.013***  0.013*** 
##                                         (0.005)   (0.005)   (0.005) 
## log(median_house_age)                    0.001     0.001     0.001  
##                                         (0.002)   (0.002)   (0.002) 
## log(house_price)                       -0.037*** -0.037*** -0.037***
##                                         (0.013)   (0.013)   (0.013) 
## disaster_2                             0.023***  0.023***  0.022*** 
##                                         (0.002)   (0.002)   (0.002) 
## disaster_3                             0.018***  0.018***  0.018*** 
##                                         (0.002)   (0.002)   (0.002) 
## log(flood_connectedness)               0.007***  0.007***  0.007*** 
##                                         (0.002)   (0.002)   (0.002) 
## worriedaboutclimatechange:disaster_1    0.040**                     
##                                         (0.016)                     
## climatechangereal:disaster_1                     0.056***           
##                                                   (0.018)           
## climatechangeimpactpersonal:disaster_1                      0.052** 
##                                                             (0.021) 
## Tract                                      Y         Y         Y    
## State*Year                                 Y         Y         Y    
## N                                       100,422   100,422   100,422 
## Adjusted R2                              0.967     0.967     0.967  
## ====================================================================

5 Table 2 - OLS - SFHA

## 
## =======================================================================================
##                                  Frac. with content              Max deductible        
##                                (1)       (2)       (3)       (4)       (5)       (6)   
## ---------------------------------------------------------------------------------------
## worriedaboutclimatechange   0.256***                       -0.191*                     
##                              (0.097)                       (0.114)                     
## climatechangereal                      0.223**                       -0.057            
##                                        (0.101)                       (0.124)           
## climatechangeimpactpersonal                      0.309**                       -0.095  
##                                                  (0.147)                       (0.176) 
## log(median_hh_income)        -0.017    -0.017    -0.017    0.036**   0.036**   0.036** 
##                              (0.014)   (0.014)   (0.014)   (0.016)   (0.016)   (0.016) 
## log(median_age)              -0.008    -0.008    -0.013     0.035     0.034     0.035  
##                              (0.031)   (0.031)   (0.032)   (0.039)   (0.039)   (0.039) 
## log(white_frac)               0.006     0.005     0.002     0.016     0.017     0.017  
##                              (0.017)   (0.017)   (0.017)   (0.020)   (0.020)   (0.020) 
## log(college_frac)             0.003     0.002     0.001     0.014     0.015     0.015  
##                              (0.013)   (0.013)   (0.013)   (0.015)   (0.015)   (0.015) 
## log(total_population)        -0.033    -0.034    -0.039    -0.038    -0.038    -0.038  
##                              (0.030)   (0.030)   (0.030)   (0.037)   (0.037)   (0.037) 
## log(no_of_homes)              0.069     0.070    0.074*     0.031     0.031     0.030  
##                              (0.044)   (0.044)   (0.044)   (0.053)   (0.053)   (0.053) 
## log(owner_frac)              -0.001    -0.002    -0.001    -0.019    -0.018    -0.018  
##                              (0.025)   (0.025)   (0.025)   (0.026)   (0.026)   (0.026) 
## log(hr_cost)                -0.134*** -0.134*** -0.134*** 0.076***  0.076***  0.076*** 
##                              (0.011)   (0.011)   (0.011)   (0.015)   (0.015)   (0.015) 
## log(median_house_age)        -0.004    -0.004    -0.004    0.009**   0.009**   0.009** 
##                              (0.004)   (0.004)   (0.004)   (0.005)   (0.005)   (0.005) 
## log(house_price)             -0.026    -0.023    -0.021   0.082***  0.080***  0.080*** 
##                              (0.018)   (0.018)   (0.018)   (0.024)   (0.024)   (0.024) 
## disaster_1                    0.003     0.003     0.004    -0.005    -0.005    -0.005  
##                              (0.004)   (0.004)   (0.004)   (0.004)   (0.004)   (0.004) 
## disaster_2                   0.008**   0.008*    0.010**   -0.004    -0.004    -0.004  
##                              (0.004)   (0.004)   (0.004)   (0.004)   (0.004)   (0.004) 
## disaster_3                  0.011***  0.010***  0.011***  -0.014*** -0.014*** -0.014***
##                              (0.004)   (0.004)   (0.004)   (0.004)   (0.004)   (0.004) 
## log(flood_connectedness)      0.006     0.006     0.004    -0.007    -0.007    -0.007  
##                              (0.005)   (0.005)   (0.005)   (0.005)   (0.005)   (0.005) 
## Tract                           Y         Y         Y         Y         Y         Y    
## State*Year                      Y         Y         Y         Y         Y         Y    
## N                            107,139   107,139   107,139   107,139   107,139   107,139 
## Adjusted R2                   0.881     0.881     0.881     0.856     0.856     0.856  
## =======================================================================================

5.1 Table 2: Disaster interaction

Referee comment: I am mostly about understanding their role as an “interaction term”. So for a given level of an individual’s climate risk perceptions, do natural disasters in the area (or in the US) increase the take up rates? So think of it as an interaction term in Table 2 for example. Some data is available to test this

## 
## ==================================================================================================
##                                             Frac. with content              Max deductible        
##                                           (1)       (2)       (3)       (4)       (5)       (6)   
## --------------------------------------------------------------------------------------------------
## worriedaboutclimatechange              0.256***                       -0.199*                     
##                                         (0.097)                       (0.114)                     
## climatechangereal                                 0.213**                       -0.051            
##                                                   (0.101)                       (0.124)           
## climatechangeimpactpersonal                                 0.305**                       -0.101  
##                                                             (0.147)                       (0.175) 
## disaster_1                               0.002    -0.037    -0.005    -0.030     0.017    -0.021  
##                                         (0.023)   (0.030)   (0.021)   (0.026)   (0.033)   (0.023) 
## log(median_hh_income)                   -0.017    -0.017    -0.017    0.036**   0.036**   0.036** 
##                                         (0.014)   (0.014)   (0.014)   (0.016)   (0.016)   (0.016) 
## log(median_age)                         -0.008    -0.008    -0.013     0.035     0.034     0.035  
##                                         (0.031)   (0.031)   (0.032)   (0.039)   (0.039)   (0.039) 
## log(white_frac)                          0.006     0.005     0.002     0.016     0.017     0.017  
##                                         (0.017)   (0.017)   (0.017)   (0.020)   (0.020)   (0.020) 
## log(college_frac)                        0.003     0.002     0.001     0.014     0.015     0.015  
##                                         (0.013)   (0.013)   (0.013)   (0.015)   (0.015)   (0.015) 
## log(total_population)                   -0.033    -0.034    -0.039    -0.038    -0.038    -0.038  
##                                         (0.030)   (0.030)   (0.030)   (0.037)   (0.037)   (0.037) 
## log(no_of_homes)                         0.069     0.070    0.074*     0.031     0.031     0.030  
##                                         (0.044)   (0.044)   (0.044)   (0.053)   (0.053)   (0.053) 
## log(owner_frac)                         -0.001    -0.002    -0.001    -0.019    -0.018    -0.018  
##                                         (0.025)   (0.025)   (0.025)   (0.026)   (0.026)   (0.026) 
## log(hr_cost)                           -0.134*** -0.134*** -0.134*** 0.076***  0.076***  0.076*** 
##                                         (0.011)   (0.011)   (0.011)   (0.015)   (0.015)   (0.015) 
## log(median_house_age)                   -0.004    -0.004    -0.004    0.009**   0.009**   0.009** 
##                                         (0.004)   (0.004)   (0.004)   (0.005)   (0.005)   (0.005) 
## log(house_price)                        -0.026    -0.023    -0.021   0.082***  0.080***  0.080*** 
##                                         (0.018)   (0.018)   (0.018)   (0.024)   (0.024)   (0.024) 
## disaster_2                              0.008**   0.008*    0.010**   -0.004    -0.004    -0.005  
##                                         (0.004)   (0.004)   (0.004)   (0.004)   (0.004)   (0.004) 
## disaster_3                             0.011***   0.010**  0.011***  -0.015*** -0.014*** -0.014***
##                                         (0.004)   (0.004)   (0.004)   (0.004)   (0.004)   (0.004) 
## log(flood_connectedness)                 0.006     0.006     0.004    -0.007    -0.007    -0.007  
##                                         (0.005)   (0.005)   (0.005)   (0.005)   (0.005)   (0.005) 
## worriedaboutclimatechange:disaster_1     0.002                         0.045                      
##                                         (0.041)                       (0.046)                     
## climatechangereal:disaster_1                       0.061                        -0.033            
##                                                   (0.044)                       (0.049)           
## climatechangeimpactpersonal:disaster_1                       0.024                         0.041  
##                                                             (0.053)                       (0.062) 
## Tract                                      Y         Y         Y         Y         Y         Y    
## State*Year                                 Y         Y         Y         Y         Y         Y    
## N                                       107,139   107,139   107,139   107,139   107,139   107,139 
## Adjusted R2                              0.881     0.881     0.881     0.856     0.856     0.856  
## ==================================================================================================