The first table need to show the period of event_type over 2010–2020 with at least one firm in the county of location being affected. (The period needs to include mean, median and max).
The second table need to show the distribution of the event_type by year across states.
The data is in the following:
Code:
* Example generated by -dataex-. For more info, type help dataex clear input str6 gvkey double year str25 cusip str8 state long episode_id str26 event_type str109 cz_name float(period ESG_Disclosure_Score Market_to_Book Firm_Size Leverage ROA Cash_Holding) "001004" 2010 "000361105" "IL" 44746 "Thunderstorm Wind" "KANE" 0 . 1.8933235 7.440574 .26053295 . .03371021 "001004" 2011 "000361105" "IL" 53962 "Hail" "GREENE" 0 . 1.8758063 7.694235 .360874 .13070932 .03084276 "001004" 2012 "000361105" "IL" 67728 "Thunderstorm Wind" "PIKE" 0 . 1.688374 7.667111 .3316019 .1116752 .03523796 "001004" 2013 "000361105" "IL" 76174 "Hail" "DU PAGE" 0 . 1.5657777 7.695985 .28824732 .1197997 .04055467 "001004" 2014 "000361105" "IL" 87952 "Tornado" "LA SALLE" 0 . 1.4847804 7.323171 .10165016 .0380541 .03610561 "001004" 2015 "000361105" "IL" 97957 "Thunderstorm Wind" "JERSEY" 0 . 1.3759383 7.273856 .10269745 .09036303 .021635115 "001004" 2016 "000361105" "IL" 111583 "Thunderstorm Wind" "RANDOLPH" 0 . 1.2909602 7.31595 .10458081 .1027668 .006847949 "001004" 2017 "000361105" "IL" 119484 "Thunderstorm Wind" "MCHENRY" 0 . 1.2871937 7.329553 .11621959 .08410345 .027284056 "001004" 2018 "000361105" "IL" 130465 "Thunderstorm Wind" "GREENE" 0 . 1.335914 7.324622 .09339573 .10067555 .027089376 "001004" 2019 "000361105" "IL" 137733 "Hail" "ST. CLAIR" 0 . 1.3647233 7.639642 .3292929 .09893224 .2042809 "001004" 2020 "000361105" "IL" 148784 "Hail" "MCLEAN" 0 . 1.284267 7.339343 .13320777 .04896585 .03909853 "001045" 2010 "02376R102" "TX" 45922 "Thunderstorm Wind" "LAMB" 0 40.4959 -1126.1398 10.130145 .2465088 . .05707908 "001045" 2011 "02376R102" "TX" 58446 "Thunderstorm Wind" "MEDINA" 0 41.7355 -1132.2797 10.079455 .25932628 .02770249 .06004696 "001045" 2012 "02376R102" "TX" 61392 "Thunderstorm Wind" "AUSTIN" 0 41.3223 -1132.3607 10.06518 .26305458 .06013083 .06091025 "001045" 2013 "02376R102" "TX" 75862 "Drought" "SWISHER" 30 29.7521 -881.692 10.365582 .19479766 .1105487 .04510538 "001045" 2014 "02376R102" "TX" 83653 "Dust Storm" "CARSON" 0 43.3884 117.1221 10.365582 .19479766 .08186373 .04510538 "001045" 2015 "02376R102" "TX" 95515 "Flash Flood" "SAN PATRICIO" 0 45.8678 37.618244 10.365582 .19479766 .08186373 .04510538 "001045" 2016 "02376R102" "TX" 109925 "Hail" "DAWSON" 0 47.5207 45.48504 10.365582 .19479766 .08186373 .04510538 "001045" 2017 "02376R102" "TX" 118913 "Tornado" "POLK" 0 50.8264 41.10423 10.365582 .19479766 .08186373 .04510538 "001045" 2018 "02376R102" "TX" 132364 "Hail" "ROBERTSON" 0 . -1146.1432 10.365582 .19479766 .08186373 .04510538 "001045" 2019 "02376R102" "TX" 138625 "Hail" "HOWARD" 0 56.6116 -1231.397 10.365582 .19479766 .08186373 .04510538 "001045" 2020 "02376R102" "TX" 146623 "High Wind" "OLDHAM" 0 56.6116 -1146.1432 10.365582 .19479766 -.0008828464 .04510538 "001050" 2010 "125141101" "TX" 40312 "Hail" "CROCKETT" 0 11.157 5.829025 4.3146977 .1444024 . .07744247 "001050" 2011 "125141101" "TX" 57647 "Drought" "FAYETTE" 29 11.157 4.901405 4.3738055 .12099061 .18407296 .16036297 "001050" 2012 "125141101" "TX" 63434 "Thunderstorm Wind" "WILLACY" 0 11.157 4.639311 4.5444007 0 .22601297 .2443467 "001050" 2013 "125141101" "TX" 74803 "Thunderstorm Wind" "JONES" 0 11.157 3.8419495 5.853742 .2555891 .27249637 .06501767 "001050" 2014 "125141101" "TX" 86211 "Thunderstorm Wind" "BASTROP" 0 11.157 3.807198 6.026747 .271326 .10214153 .04672692 "001050" 2015 "125141101" "TX" 99456 "Thunderstorm Wind" "POTTER" 0 11.157 4.81045 6.394959 .29612955 .1090126 .06598488 "001050" 2016 "125141101" "TX" 104869 "Hail" "GLASSCOCK" 0 11.157 6.139717 6.211873 .2746784 .09388313 .09490328 "001050" 2017 "125141101" "TX" 114533 "Hail" "FRANKLIN" 0 16.1157 6.405648 6.083472 .29217488 .05628377 .06953157 "001050" 2018 "125141101" "TX" 124211 "Hail" "LUBBOCK" 0 . 6.788465 5.972745 .21521874 .06232827 .11319418 "001050" 2019 "125141101" "TX" 143994 "Drought" "LLANO" 29 16.1157 6.396338 6.012827 .213106 .07700557 .09044213 "001050" 2020 "125141101" "TX" 146604 "Thunderstorm Wind" "RUSK" 0 16.1157 6.172143 6.03862 .21830896 .07467263 .09017348 "001062" 2010 "G3156P103" "CA" 45511 "Flood" "SAN BERNARDINO" 0 . . 6.509633 0 . . "001062" 2011 "G3156P103" "CA" 50111 "Flood" "MERCED" 0 . . 6.45002 0 . . "001062" 2012 "G3156P103" "CA" 66293 "Flash Flood" "INYO" 0 . . 6.148496 0 . . "001062" 2013 "G3156P103" "CA" 79725 "Flash Flood" "SAN DIEGO" 0 . . 5.529993 0 . . "001062" 2014 "G3156P103" "CA" 87683 "Wildfire" "KERN CTY MTNS" 8 . 1.677654 5.408664 0 -.005782456 .02209257 "001062" 2015 "G3156P103" "CA" 102621 "Frost/Freeze" "W CENTRAL S.J. VALLEY" 1 . . 5.089755 0 . . "001062" 2016 "G3156P103" "CA" 104678 "Heavy Snow" "WEST SLOPE NORTHERN SIERRA NEVADA" 1 . 1.5298475 5.50134 0 -.012319064 .01746388 "001062" 2017 "G3156P103" "CA" 113302 "Heavy Snow" "TULARE CTY MTNS" 1 . . 5.50355 0 . . "001062" 2018 "G3156P103" "CA" 121898 "Dense Fog" "SW S.J. VALLEY" 1 . . 5.278482 0 . . "001062" 2019 "G3156P103" "CA" 143916 "Flood" "SAN BERNARDINO" 0 . 1.3016107 5.658129 0 -.005982496 .01599026 "001062" 2020 "G3156P103" "CA" 155660 "Winter Weather" "MONO" 1 . . 6.141478 0 . . "001072" 2010 "002444107" "SC" 42600 "Thunderstorm Wind" "COLLETON" 0 . 14.19435 7.749099 0 . .3367178 "001072" 2011 "002444107" "SC" 47848 "Thunderstorm Wind" "LEXINGTON" 0 . 13.563306 7.811168 0 .13901423 .3295839 "001072" 2012 "002444107" "SC" 60190 "Thunderstorm Wind" "NEWBERRY" 0 . 14.413692 7.864034 0 .07831243 .4024174 "001072" 2013 "002444107" "SC" 72654 "Thunderstorm Wind" "COLLETON" 0 . 13.819644 7.776949 0 .08046634 .36658 "001072" 2014 "002444107" "SC" 81357 "Winter Storm" "FAIRFIELD" 1 . 13.268486 7.807516 0 .10690326 .343026 "001072" 2015 "002444107" "SC" 96190 "Thunderstorm Wind" "RICHLAND" 0 . 12.885685 7.787307 0 .0846896 .3937233 "001072" 2016 "002444107" "SC" 103852 "Hail" "YORK" 0 . 12.723126 7.81497 0 .101557 .4469913 "001072" 2017 "002444107" "SC" 116170 "Thunderstorm Wind" "RICHLAND" 0 . 12.645764 7.890869 0 .09782503 .3094929 "001072" 2018 "002444107" "SC" 130540 "Thunderstorm Wind" "CHESTER" 0 . 11.954738 7.942106 0 .1511954 .28906137 "001094" 2010 "004446100" "NY" 39500 "Frost/Freeze" "NORTHERN SARATOGA" 1 . 4.6254506 5.446095 .002372213 . .13450448 "001094" 2011 "004446100" "NY" 51482 "Thunderstorm Wind" "BROOME" 0 . 4.4062634 5.741929 .1764619 .0996847 .09499623 "001094" 2012 "004446100" "NY" 69172 "Thunderstorm Wind" "WAYNE" 0 . 4.3189726 5.70138 .152917 .1089407 .08814488 "001094" 2013 "004446100" "NY" 76262 "Thunderstorm Wind" "COLUMBIA" 0 . 3.9794955 5.778983 .09915283 .1490377 .10937452 "001094" 2014 "004446100" "NY" 87848 "Thunderstorm Wind" "HERKIMER" 0 . 3.544048 6.148434 .2254372 .1719321 .09325746 "001094" 2015 "004446100" "NY" 100250 "Thunderstorm Wind" "SUFFOLK" 0 . 3.3418944 6.193944 .22491394 .14033814 .07643525 "001094" 2016 "004446100" "NY" 112448 "Lake-Effect Snow" "SOUTHERN ERIE" 2 . 2.87696 6.293009 .21966316 .14221253 .12520665 "001094" 2017 "004446100" "NY" 117013 "Thunderstorm Wind" "CHENANGO" 0 . 2.235793 6.945229 .340658 .1260776 .05560281 "001094" 2018 "004446100" "NY" 122685 "Winter Weather" "SOUTHEASTERN ST. LAWRENCE" 2 . 9.947334 6.642518 .4138045 .015050304 .13546382 "001119" 2010 "006212104" "MD" 37402 "Winter Storm" "SOMERSET" 1 . . . . . . "001119" 2011 "006212104" "MD" 57509 "Tropical Storm" "SOMERSET" 1 . . . . . . "001119" 2012 "006212104" "MD" 65789 "Thunderstorm Wind" "PRINCE GEORGE'S" 0 . . . . . . "001119" 2013 "006212104" "MD" 74253 "Thunderstorm Wind" "ANNE ARUNDEL" 0 . . . . . . "001119" 2014 "006212104" "MD" 84693 "Flood" "CARROLL" 0 . . . . . . "001119" 2015 "006212104" "MD" 94401 "Winter Storm" "SOUTHERN BALTIMORE" 0 . . . . . . "001119" 2016 "006212104" "MD" 107759 "Thunderstorm Wind" "CHARLES" 0 . . . . . . "001119" 2017 "006212104" "MD" 119372 "Thunderstorm Wind" "HOWARD" 0 . . . . . . "001119" 2018 "006212104" "MD" 127372 "Flood" "BALTIMORE" 0 . . . . . . "001119" 2019 "006212104" "MD" 136094 "Thunderstorm Wind" "ALLEGANY" 0 . . . . . . "001119" 2020 "006212104" "MD" 152945 "Thunderstorm Wind" "HARFORD" 0 . . . . . . "001121" 2010 "006351308" "TX" 39609 "Hail" "HOOD" 0 . .1973435 5.708123 0 . .0963542 "001121" 2011 "006351308" "TX" 51395 "Hail" "HAMILTON" 0 . .1607445 5.937114 0 .16219446 .09784078 "001121" 2012 "006351308" "TX" 70496 "Winter Weather" "MOORE" 0 . .13095678 6.039066 0 .1651357 .1126076 "001121" 2013 "006351308" "TX" 72781 "Flash Flood" "TRAVIS" 0 . .11501775 6.104976 0 .13504378 .13553992 "001121" 2014 "006351308" "TX" 87141 "Thunderstorm Wind" "OCHILTREE" 0 . .11296409 5.831337 0 .07045139 .235272 "001121" 2015 "006351308" "TX" 93164 "Heavy Snow" "DENTON" 0 . .11665823 5.493946 0 .062667616 .3777604 "001121" 2016 "006351308" "TX" 103734 "Flash Flood" "NAVARRO" 0 . .1175818 5.50887 0 .10215653 .3537947 "001121" 2017 "006351308" "TX" 115299 "Hail" "ECTOR" 0 . .12093271 5.644401 .005974447 .06116935 .3869524 "001121" 2018 "006351308" "TX" 126084 "Hail" "WHEELER" 0 . .12136278 5.630746 .014673504 .0405088 .419787 "001121" 2019 "006351308" "TX" 138066 "Thunderstorm Wind" "MILAM" 0 . .11832997 5.801641 .04871812 .087643 .3695268 "001121" 2020 "006351308" "TX" 149218 "Drought" "COASTAL CAMERON" 0 . .12080808 5.690991 .07991235 .04007049 .1757842 "001161" 2010 "007903107" "CA" 44715 "Wildfire" "TULARE CTY MTNS" 30 . 228.81136 8.509967 .4877115 . .28847703 "001161" 2011 "007903107" "CA" 54327 "Flood" "KINGS" 0 . 148.98503 8.507951 .4069439 .1492748 .28905934 "001161" 2012 "007903107" "CA" 70017 "Heavy Rain" "MARIPOSA" 0 . 449.7389 8.294049 .5105 .04521599 .2505 "001161" 2013 "007903107" "CA" 71841 "Dense Fog" "W CENTRAL S.J. VALLEY" 0 . 452.3164 8.374938 .47452155 .0605 .25293982 "001161" 2014 "007903107" "CA" 82222 "High Surf" "SAN DIEGO COUNTY COASTAL AREAS" 2 . 1408.1868 8.234035 .5872047 .06409961 .27608177 "001161" 2015 "007903107" "CA" 96585 "Flash Flood" "SISKIYOU" 0 . -1146.1432 8.042056 .7275651 -.007440536 .25249276 "001161" 2016 "007903107" "CA" 112491 "Frost/Freeze" "W CENTRAL S.J. VALLEY" 0 . 762.8074 8.108021 .4320988 -.009015278 .3806083 "001161" 2017 "007903107" "CA" 120922 "Dense Fog" "SW S.J. VALLEY" 0 . 537.06757 8.171882 .3940678 .06895513 .3353107 "001161" 2018 "007903107" "CA" 129910 "Debris Flow" "MONO" 0 . 269.4078 8.4242 .2743635 .16666667 .2548288 "001161" 2019 "007903107" "CA" 133275 "Heavy Rain" "SANTA CRUZ" 0 . 140.45734 8.70417 .12076974 .1591308 .23755807 "001161" 2020 "007903107" "CA" 147198 "Heavy Rain" "HUMBOLDT" 0 . 70.40934 9.100749 .06382504 .265428 .15978576 "001173" 2010 "008015307" "FL" 35206 "Sleet" "PUTNAM" 0 . 1.5908512 3.164546 .3612214 . .006841794 "001173" 2011 "008015307" "FL" 57754 "Thunderstorm Wind" "PINELLAS" 0 . 1.5096304 3.137015 .3535055 .07948306 .006815715 "001173" 2012 "008015307" "FL" 65497 "Funnel Cloud" "BREVARD" 0 . 1.3064102 3.149483 .2219602 .10084654 .0006859887 "001210" 2010 "009207101" "NC" 38620 "Thunderstorm Wind" "SURRY" 0 . .22521146 3.5328395 .0002337746 . .1918705 "001210" 2011 "009207101" "NC" 50850 "Hail" "SURRY" 0 . .22115533 3.5577166 0 .06808685 .1657213 end
Best wishes
0 Response to Query about table generation
Post a Comment