The Data:

## 'data.frame':    89392 obs. of  88 variables:
##  $ YEAR                            : int  2020 2020 2020 2020 2020 2020 2020 2020 2020 2020 ...
##  $ YEAR_TYPE                       : chr  "CY" "FY" "FY" "FY" ...
##  $ SMRY_CTGRY                      : chr  "NATION" "NATION" "NATION" "NATION" ...
##  $ SRVC_CTGRY                      : chr  "HH" "HOS" "IRF" "LTC" ...
##  $ PRVDR_ID                        : chr  "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" ...
##  $ PRVDR_NAME                      : chr  "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" ...
##  $ PRVDR_CITY                      : chr  "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" ...
##  $ STATE                           : chr  "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" ...
##  $ PRVDR_ZIP                       : chr  "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" "NATIONAL TOTAL" ...
##  $ BENE_DSTNCT_CNT                 : int  2849234 1681571 331414 73480 1423340 2590 56731 32756 43443 306144 ...
##  $ TOT_EPSD_STAY_CNT               : int  8416675 1767370 374033 81204 1935189 7150 193119 101892 109069 987909 ...
##  $ TOT_SRVC_DAYS                   : int  62728424 126857339 4794703 2095772 52224660 54179 1305359 718962 783475 7353902 ...
##  $ TOT_CHRG_AMT                    : num  1.58e+10 3.53e+10 1.92e+10 1.82e+10 3.59e+10 ...
##  $ TOT_ALOWD_AMT                   : num  1.50e+10 2.20e+10 8.45e+09 3.66e+09 3.10e+10 ...
##  $ TOT_MDCR_PYMT_AMT               : num  1.50e+10 2.20e+10 8.31e+09 3.39e+09 2.60e+10 ...
##  $ TOT_MDCR_STDZD_PYMT_AMT         : num  1.51e+10 2.23e+10 8.14e+09 3.43e+09 2.64e+10 ...
##  $ TOT_OUTLIER_PYMT_AMT            : int  319271906 NA 255887674 396894915 NA 445389 2626218 1429452 2500405 71759017 ...
##  $ BENE_DUAL_PCT                   : chr  "26" "29" "21" "46" ...
##  $ BENE_RRL_PCT                    : int  8 7 7 9 8 18 14 24 2 1 ...
##  $ BENE_AVG_AGE                    : int  77 82 76 71 79 76 77 77 79 77 ...
##  $ BENE_MALE_PCT                   : int  41 42 47 54 41 39 39 39 42 42 ...
##  $ BENE_FEML_PCT                   : int  59 58 53 46 59 61 61 61 58 58 ...
##  $ BENE_RACE_WHT_PCT               : int  78 81 80 65 79 78 80 87 85 61 ...
##  $ BENE_RACE_BLACK_PCT             : int  11 9 10 20 11 3 18 10 3 7 ...
##  $ BENE_RACE_API_PCT               : int  2 2 2 2 2 4 0 0 1 11 ...
##  $ BENE_RACE_HSPNC_PCT             : int  7 7 6 10 5 3 1 1 7 17 ...
##  $ BENE_RACE_NATIND_PCT            : int  0 0 1 1 1 10 0 0 2 0 ...
##  $ BENE_RACE_UNK_PCT               : int  1 0 1 1 1 1 0 0 1 2 ...
##  $ BENE_RACE_OTHR_PCT              : int  1 1 1 1 1 1 0 0 1 1 ...
##  $ BENE_AVG_RISK_SCRE              : num  2.24 2.58 2.69 4.42 2.83 2.25 2.15 2.18 2.18 2.27 ...
##  $ BENE_CC_BH_ADHD_OTHCD_V1_PCT    : int  1 NA 2 4 3 1 1 1 1 2 ...
##  $ BENE_CC_BH_ALCOHOL_DRUG_V1_PCT  : int  11 NA 16 23 15 18 11 11 13 12 ...
##  $ BENE_CC_BH_ALZ_NONALZDEM_V2_PCT : int  27 NA 28 37 49 31 27 25 26 27 ...
##  $ BENE_CC_BH_ANXIETY_V1_PCT       : int  37 NA 45 52 48 31 38 37 34 32 ...
##  $ BENE_CC_BH_BIPOLAR_V1_PCT       : int  6 NA 8 13 13 7 5 8 6 6 ...
##  $ BENE_CC_BH_DEPRESS_V1_PCT       : int  40 NA 48 53 55 37 37 40 39 38 ...
##  $ BENE_CC_BH_MOOD_V2_PCT          : int  43 NA 53 58 60 41 41 43 42 42 ...
##  $ BENE_CC_BH_PD_V1_PCT            : int  2 NA 3 4 4 3 3 2 2 2 ...
##  $ BENE_CC_BH_PTSD_V1_PCT          : int  2 NA 3 3 2 4 2 2 2 2 ...
##  $ BENE_CC_BH_SCHIZO_OTHPSY_V1_PCT : int  5 NA 5 13 14 4 5 4 4 7 ...
##  $ BENE_CC_BH_TOBACCO_V1_PCT       : int  15 NA 20 29 18 19 19 21 14 13 ...
##  $ BENE_CC_PH_AFIB_V2_PCT          : int  33 NA 41 50 41 35 33 36 36 29 ...
##  $ BENE_CC_PH_ARTHRITIS_V2_PCT     : int  66 NA 71 60 68 62 69 66 65 66 ...
##  $ BENE_CC_PH_ASTHMA_V2_PCT        : int  14 NA 15 16 14 13 13 11 15 16 ...
##  $ BENE_CC_PH_CANCER6_V2_PCT       : int  19 NA 20 19 20 17 18 18 20 17 ...
##  $ BENE_CC_PH_CKD_V2_PCT           : int  42 NA 49 62 51 38 43 39 45 39 ...
##  $ BENE_CC_PH_COPD_V2_PCT          : int  33 NA 38 58 41 34 36 38 32 30 ...
##  $ BENE_CC_PH_DIABETES_V2_PCT      : int  45 NA 51 66 50 43 47 43 40 48 ...
##  $ BENE_CC_PH_HF_NONIHD_V2_PCT     : int  39 NA 46 67 50 38 40 42 35 38 ...
##  $ BENE_CC_PH_HYPERLIPIDEMIA_V2_PCT: int  79 NA 86 81 81 63 80 74 78 79 ...
##  $ BENE_CC_PH_HYPERTENSION_V2_PCT  : int  91 NA 95 96 95 86 94 93 90 91 ...
##  $ BENE_CC_PH_ISCHEMICHEART_V2_PCT : int  45 NA 54 60 52 38 47 51 44 45 ...
##  $ BENE_CC_PH_OSTEOPOROSIS_V2_PCT  : int  20 NA 24 15 24 22 18 20 23 24 ...
##  $ BENE_CC_PH_PARKINSON_V2_PCT     : int  5 NA 7 5 8 5 5 5 6 6 ...
##  $ BENE_CC_PH_STROKE_TIA_V2_PCT    : int  18 NA 44 36 32 19 19 20 20 17 ...
##  $ PRMRY_DX_INFCTN_PCT             : int  1 1 0 8 5 1 1 1 2 1 ...
##  $ PRMRY_DX_NEOBLD_PCT             : int  4 24 1 2 3 4 4 4 3 3 ...
##  $ PRMRY_DX_ENDONUTRMET_PCT        : int  10 3 1 4 3 6 10 9 6 13 ...
##  $ PRMRY_DX_MNTBEHNEUDIS_PCT       : int  2 0 0 1 2 2 3 1 2 2 ...
##  $ PRMRY_DX_NERVSYSTM_PCT          : int  7 25 17 2 9 7 6 6 8 7 ...
##  $ PRMRY_DX_ENTSYS_PCT             : int  0 0 0 0 0 0 0 0 0 0 ...
##  $ PRMRY_DX_CIRCSYSTM_PCT          : int  25 29 22 6 17 18 28 28 20 26 ...
##  $ PRMRY_DX_RSPSYSTM_PCT           : int  7 11 2 45 12 6 8 9 7 5 ...
##  $ PRMRY_DX_DIGSYSTM_PCT           : int  2 2 1 3 2 2 2 2 2 2 ...
##  $ PRMRY_DX_SKNMUSSYSTM_PCT        : int  15 0 5 9 9 21 12 12 14 19 ...
##  $ PRMRY_DX_GUSYSTM_PCT            : int  3 2 0 4 7 2 3 4 3 3 ...
##  $ PRMRY_DX_PRGPERICONG_PCT        : int  0 0 0 0 0 NA 0 0 0 0 ...
##  $ PRMRY_DX_SXILLDEF_PCT           : int  0 1 13 1 2 0 0 0 0 0 ...
##  $ PRMRY_DX_INJPOIS_PCT            : int  11 1 22 9 16 13 10 11 16 8 ...
##  $ PRMRY_DX_HLTHSRV_PCT            : int  14 1 17 5 15 17 12 13 18 11 ...
##  $ NRSNG_VISITS_CNT                : int  36702228 32154608 NA NA NA 28562 711623 401105 394905 5121724 ...
##  $ MSW_VISITS_CNT                  : int  503090 5887764 NA NA NA 482 10892 3996 7957 70357 ...
##  $ AIDE_VISITS_CNT                 : int  4560397 33015143 NA NA NA 3755 86974 62192 43777 465883 ...
##  $ TOT_NRSNG_MNTS                  : int  1633137120 1966008525 NA NA NA 1515630 30694875 17141865 18599910 249162585 ...
##  $ TOT_PT_MNTS                     : chr  "1077157725" NA "229793763" NA ...
##  $ INDVDL_PT_MNTS                  : chr  NA NA "197276463" NA ...
##  $ CNCRNT_GRP_PT_MNTS              : chr  NA NA "30884295" NA ...
##  $ COTRT_PT_MNTS                   : chr  NA NA "1633005" NA ...
##  $ TOT_OT_MNTS                     : chr  "314391915" NA "225937208" NA ...
##  $ INDVDL_OT_MNTS                  : chr  NA NA "197023352" NA ...
##  $ CNCRNT_GRP_OT_MNTS              : chr  NA NA "27431930" NA ...
##  $ COTRT_OT_MNTS                   : chr  NA NA "1481926" NA ...
##  $ TOT_SLP_MNTS                    : chr  "64137405" NA "56496538" NA ...
##  $ INDVDL_SLP_MNTS                 : chr  NA NA "53003355" NA ...
##  $ CNCRNT_GRP_SLP_MNTS             : chr  NA NA "3271282" NA ...
##  $ COTRT_SLP_MNTS                  : chr  NA NA "221901" NA ...
##  $ HOSPC_RHC_DAYS_PCT              : int  NA 99 NA NA NA NA NA NA NA NA ...
##  $ TOT_HH_LUPA_EPSDS_CNT           : int  729282 NA NA NA NA 810 16245 8766 11013 66259 ...

Table: Data Summary

Graphs -USA map

map -leaflet

Data analysis

first 5 most prevalent diseases in the zipcode