23  Summary State

State Level Payment Total and Averages for all Years

Metadata

    [ROWS] 2765 
   [PAGES] 6 
  [FIELDS] 28 
[MODIFIED] 2025-01-30 
[DOWNLOAD] https://download.cms.gov/openpayments/SMRY_RPTS_P01302025_01212025/PBLCTN_STATE_SMRY_P01302025_01212025-joined.csv 

Data

# A tibble: 2,765 × 28
   country_code country_name  state_code state_name  payment_type recipient_type
                                                  
 1 US           United States AA         Armed Forc… Research     Covered Recip…
 2 US           United States AE         Armed Forc… Research     Covered Recip…
 3 US           United States AK         Alaska      Research     Covered Recip…
 4 US           United States AL         Alabama     Research     Covered Recip…
 5 US           United States AP         Armed Forc… Research     Covered Recip…
 6 US           United States AR         Arkansas    Research     Covered Recip…
 7 US           United States AS         American S… Research     Covered Recip…
 8 US           United States AZ         Arizona     Research     Covered Recip…
 9 US           United States CA         California  Research     Covered Recip…
10 US           United States CO         Colorado    Research     Covered Recip…
# ℹ 2,755 more rows
# ℹ 22 more variables: program_year , total_number_of_physicians ,
#   total_number_of_non_physician_practitioners ,
#   total_number_of_teaching_hospitals ,
#   total_payment_amount_physician ,
#   total_payment_amount_non_physician_practitioner ,
#   total_payment_amount_teaching_hospital , …

Tidyup

x <- resp |>
  fcompute(
    year           = factor_(program_year),
    country        = country_code,
    state          = state_code,
    pay_type       = factor_(payment_type),
    recip_type     = factor_(recipient_type),
    num_phys       = as.integer(total_number_of_physicians),
    num_npp        = as.integer(total_number_of_non_physician_practitioners),
    num_teach      = as.integer(total_number_of_teaching_hospitals),
    pay_phys       = as.double(total_payment_amount_physician),
    pay_npp        = as.double(total_payment_amount_non_physician_practitioner),
    pay_teach      = as.double(total_payment_amount_teaching_hospital),
    avg_pay_phys   = as.double(mean_total_payment_amount_physician),
    avg_pay_npp    = as.double(mean_total_payment_amount_non_physician_practitioner),
    avg_pay_teach  = as.double(mean_total_payment_amount_teaching_hospital),
    med_pay_phys   = as.double(median_total_payment_amount_physician),
    med_pay_npp    = as.double(median_total_payment_amount_non_physician_practitioner),
    med_pay_teach  = as.double(median_total_payment_amount_teaching_hospital),
    pmts_phys      = as.integer(total_payment_count_physician),
    pmts_npp       = as.integer(total_payment_count_non_physician_practitioner),
    pmts_teach     = as.integer(total_payment_count_teaching_hospital),
    avg_pmts_phys  = as.double(mean_total_payment_count_physician),
    avg_pmts_npp   = as.double(mean_total_payment_count_non_physician_practitioner),
    avg_pmts_teach = as.double(mean_total_payment_count_teaching_hospital),
    med_pmts_phys  = as.double(median_total_payment_count_physician),
    med_pmts_npp   = as.double(median_total_payment_count_non_physician_practitioner),
    med_pmts_teach = as.double(median_total_payment_count_teaching_hospital))

cheapr::overview(x, hist = TRUE)
obs: 2765 
cols: 26 

----- Numeric -----
              col n_missng p_complt n_unique        mean p0 p25 p50    p75
1        num_phys        0        1      640     2121.91  0   0   0     49
2         num_npp        0        1      236       473.1  0   0   0      0
3       num_teach        0        1       98        6.02  0   0   0      4
4        pay_phys        0        1     1105 11703548.71  0   0   0 539620
5         pay_npp        0        1      401   364125.46  0   0   0      0
6       pay_teach        0        1      835 12360902.37  0   0   0 403585
7    avg_pay_phys        0        1     1104     3181.72  0   0   0   2504
8     avg_pay_npp        0        1      398      295.03  0   0   0      0
9   avg_pay_teach        0        1      835   410726.26  0   0   0  59250
10   med_pay_phys        0        1     1019      597.08  0   0   0    141
11    med_pay_npp        0        1      383      203.18  0   0   0      0
12  med_pay_teach        0        1      835    84965.51  0   0   0  12442
13      pmts_phys        0        1      805    47260.71  0   0   0    209
14       pmts_npp        0        1      271     9249.51  0   0   0      0
15     pmts_teach        0        1      693      818.25  0   0   0    147
16  avg_pmts_phys        0        1       55         3.6  0   0   0      4
17   avg_pmts_npp        0        1       37        1.48  0   0   0      0
18 avg_pmts_teach        0        1      293       43.37  0   0   0     21
19  med_pmts_phys        0        1       18        1.13  0   0   0      2
20   med_pmts_npp        0        1       15        0.49  0   0   0      0
21 med_pmts_teach        0        1      160       19.06  0   0   0      8
         p100    iqr          sd  hist
1      140463     49      8272.6 ▇▁▁▁▁
2       38149      0     2508.31 ▇▁▁▁▁
3         152      4       15.38 ▇▁▁▁▁
4  2201851466 539620 72073442.54 ▇▁▁▁▁
5    50646264      0  2313622.45 ▇▁▁▁▁
6  1795233296 403585 86712070.35 ▇▁▁▁▁
7      203854   2504     8856.26 ▇▁▁▁▁
8      154596      0     3304.57 ▇▁▁▁▁
9    44339831  59250  1856702.05 ▇▁▁▁▁
10     203854    141      4540.9 ▇▁▁▁▁
11     154596      0     3207.69 ▇▁▁▁▁
12   22715690  12442   646263.41 ▇▁▁▁▁
13    6660991    209   283373.88 ▇▁▁▁▁
14    1167580      0    57413.52 ▇▁▁▁▁
15     110980    147     4018.01 ▇▁▁▁▁
16         75      4        7.64 ▇▁▁▁▁
17         41      0        4.81 ▇▁▁▁▁
18       5293     21      182.87 ▇▁▁▁▁
19         47      2        2.14 ▇▁▁▁▁
20         14      0        1.43 ▇▁▁▁▁
21       5293      8      144.41 ▇▁▁▁▁

----- Categorical -----
         col n_missng p_complt n_unique n_levels
1       year        0        1        8        8
2    country        0        1       62       NA
3      state      285      0.9       62       NA
4   pay_type        0        1        2        2
5 recip_type        0        1        3        3
                                           min
1                                         2017
2                                           AE
3                                           AA
4                                      General
5 Covered Recipient Non-Physician Practitioner
                                  max
1                                 ALL
2                                  ZW
3                                  WY
4                            Research
5 Covered Recipient Teaching Hospital

Distribution

Variable       |     Mean |       SD |      IQR |            Range | Skewness
-----------------------------------------------------------------------------
num_phys       |  2121.91 |  8272.60 |    49.00 | [0.00, 1.40e+05] |     6.91
num_npp        |   473.10 |  2508.31 |     0.00 | [0.00, 38149.00] |     8.04
num_teach      |     6.02 |    15.38 |     4.00 |   [0.00, 152.00] |     4.09
pay_phys       | 1.17e+07 | 7.21e+07 | 5.44e+05 | [0.00, 2.20e+09] |    16.92
pay_npp        | 3.64e+05 | 2.31e+06 |     0.00 | [0.00, 5.06e+07] |    11.86
pay_teach      | 1.24e+07 | 8.67e+07 | 4.05e+05 | [0.00, 1.80e+09] |    15.15
avg_pay_phys   |  3181.72 |  8856.26 |  2506.08 | [0.00, 2.04e+05] |     9.23
avg_pay_npp    |   295.03 |  3304.57 |     0.00 | [0.00, 1.55e+05] |    38.56
avg_pay_teach  | 4.11e+05 | 1.86e+06 | 59799.40 | [0.00, 4.43e+07] |    11.10
med_pay_phys   |   597.08 |  4540.90 |   141.30 | [0.00, 2.04e+05] |    35.18
med_pay_npp    |   203.18 |  3207.69 |     0.00 | [0.00, 1.55e+05] |    41.95
med_pay_teach  | 84965.51 | 6.46e+05 | 12458.18 | [0.00, 2.27e+07] |    22.40
pmts_phys      | 47260.71 | 2.83e+05 |   209.50 | [0.00, 6.66e+06] |    14.22
pmts_npp       |  9249.51 | 57413.52 |     0.00 | [0.00, 1.17e+06] |    11.06
pmts_teach     |   818.25 |  4018.01 |   148.00 | [0.00, 1.11e+05] |    13.72
avg_pmts_phys  |     3.60 |     7.64 |     4.00 |    [0.00, 75.00] |     4.18
avg_pmts_npp   |     1.48 |     4.81 |     0.00 |    [0.00, 41.00] |     4.20
avg_pmts_teach |    43.37 |   182.87 |    21.00 |  [0.00, 5293.00] |    14.12
med_pmts_phys  |     1.13 |     2.14 |     2.00 |    [0.00, 47.00] |     6.81
med_pmts_npp   |     0.49 |     1.43 |     0.00 |    [0.00, 14.00] |     3.89
med_pmts_teach |    19.06 |   144.41 |     8.00 |  [0.00, 5293.00] |    24.59

Variable       | Kurtosis |    n | n_Missing
--------------------------------------------
num_phys       |    65.94 | 2765 |         0
num_npp        |    79.99 | 2765 |         0
num_teach      |    20.46 | 2765 |         0
pay_phys       |   400.85 | 2765 |         0
pay_npp        |   187.43 | 2765 |         0
pay_teach      |   273.87 | 2765 |         0
avg_pay_phys   |   149.31 | 2765 |         0
avg_pay_npp    |  1739.07 | 2765 |         0
avg_pay_teach  |   178.75 | 2765 |         0
med_pay_phys   |  1490.22 | 2765 |         0
med_pay_npp    |  1962.32 | 2765 |         0
med_pay_teach  |   655.26 | 2765 |         0
pmts_phys      |   263.43 | 2765 |         0
pmts_npp       |   164.07 | 2765 |         0
pmts_teach     |   273.95 | 2765 |         0
avg_pmts_phys  |    23.97 | 2765 |         0
avg_pmts_npp   |    20.05 | 2765 |         0
avg_pmts_teach |   309.76 | 2765 |         0
med_pmts_phys  |    99.60 | 2765 |         0
med_pmts_npp   |    18.82 | 2765 |         0
med_pmts_teach |   769.93 | 2765 |         0
year |       Variable |     Mean |       SD |      IQR |            Range
-------------------------------------------------------------------------
2017 |       num_phys |  2550.80 |  8257.42 |   160.50 | [0.00, 71679.00]
2017 |        num_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 |      num_teach |     7.24 |    15.88 |     7.50 |   [0.00, 116.00]
2017 |       pay_phys | 8.57e+06 | 2.83e+07 | 1.74e+06 | [0.00, 2.66e+08]
2017 |        pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 |      pay_teach | 7.64e+06 | 3.53e+07 | 1.55e+06 | [0.00, 4.55e+08]
2017 |   avg_pay_phys |  3388.73 |  6884.52 |  3498.24 | [0.00, 58319.74]
2017 |    avg_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 |  avg_pay_teach | 3.18e+05 | 9.36e+05 | 1.65e+05 | [0.00, 7.94e+06]
2017 |   med_pay_phys |   443.74 |   900.39 |   152.96 |  [0.00, 5067.41]
2017 |    med_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 |  med_pay_teach | 95379.64 | 5.10e+05 | 23903.65 | [0.00, 7.30e+06]
2017 |      pmts_phys | 42428.78 | 1.42e+05 |   620.50 | [0.00, 1.15e+06]
2017 |       pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 |     pmts_teach |   645.29 |  1694.11 |   436.00 | [0.00, 15099.00]
2017 |  avg_pmts_phys |     4.22 |     6.62 |     5.00 |    [0.00, 47.00]
2017 |   avg_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 | avg_pmts_teach |    42.74 |   110.94 |    39.50 |   [0.00, 967.00]
2017 |  med_pmts_phys |     1.48 |     3.21 |     2.00 |    [0.00, 47.00]
2017 |   med_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2017 | med_pmts_teach |    20.71 |    87.06 |    15.00 |   [0.00, 967.00]
2018 |       num_phys |  2451.92 |  8120.27 |   132.75 | [0.00, 72302.00]
2018 |        num_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 |      num_teach |     7.16 |    15.93 |     7.00 |   [0.00, 118.00]
2018 |       pay_phys | 8.55e+06 | 3.02e+07 | 1.65e+06 | [0.00, 3.14e+08]
2018 |        pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 |      pay_teach | 8.26e+06 | 3.98e+07 | 1.59e+06 | [0.00, 5.22e+08]
2018 |   avg_pay_phys |  3611.56 |  8003.39 |  3344.71 | [0.00, 86613.82]
2018 |    avg_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 |  avg_pay_teach | 3.24e+05 | 9.84e+05 | 1.29e+05 | [0.00, 9.81e+06]
2018 |   med_pay_phys |   627.29 |  2476.04 |   166.16 | [0.00, 37500.00]
2018 |    med_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 |  med_pay_teach | 88121.41 | 4.67e+05 | 20641.36 | [0.00, 6.48e+06]
2018 |      pmts_phys | 39295.91 | 1.35e+05 |   583.75 | [0.00, 1.11e+06]
2018 |       pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 |     pmts_teach |   644.10 |  1709.48 |   369.50 | [0.00, 14273.00]
2018 |  avg_pmts_phys |     4.06 |     5.93 |     6.00 |    [0.00, 22.00]
2018 |   avg_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 | avg_pmts_teach |    39.55 |    98.72 |    35.00 |   [0.00, 880.00]
2018 |  med_pmts_phys |     1.35 |     2.00 |     2.00 |    [0.00, 19.00]
2018 |   med_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2018 | med_pmts_teach |    17.71 |    71.82 |    15.00 |   [0.00, 880.00]
2019 |       num_phys |  2436.90 |  8044.52 |   136.00 | [0.00, 70778.00]
2019 |        num_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 |      num_teach |     7.29 |    16.09 |     8.00 |   [0.00, 111.00]
2019 |       pay_phys | 9.07e+06 | 3.24e+07 | 1.58e+06 | [0.00, 3.09e+08]
2019 |        pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 |      pay_teach | 1.06e+07 | 4.66e+07 | 1.59e+06 | [0.00, 4.35e+08]
2019 |   avg_pay_phys |  3850.84 | 13377.09 |  3960.09 | [0.00, 2.04e+05]
2019 |    avg_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 |  avg_pay_teach | 3.62e+05 | 1.10e+06 | 1.41e+05 | [0.00, 8.78e+06]
2019 |   med_pay_phys |  1313.57 | 12261.35 |   164.01 | [0.00, 2.04e+05]
2019 |    med_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 |  med_pay_teach | 73056.53 | 2.90e+05 | 19021.73 | [0.00, 2.85e+06]
2019 |      pmts_phys | 37817.70 | 1.31e+05 |   652.00 | [0.00, 1.09e+06]
2019 |       pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 |     pmts_teach |   653.71 |  1828.13 |   427.00 | [0.00, 17454.00]
2019 |  avg_pmts_phys |     3.99 |     5.70 |     6.00 |    [0.00, 24.00]
2019 |   avg_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 | avg_pmts_teach |    37.48 |    99.79 |    37.00 |  [0.00, 1195.00]
2019 |  med_pmts_phys |     1.38 |     2.12 |     2.00 |    [0.00, 24.00]
2019 |   med_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2019 | med_pmts_teach |    17.68 |    80.92 |    15.00 |  [0.00, 1195.00]
2020 |       num_phys |  1967.46 |  6401.35 |   140.75 | [0.00, 55017.00]
2020 |        num_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 |      num_teach |     7.44 |    16.30 |     7.75 |   [0.00, 108.00]
2020 |       pay_phys | 6.59e+06 | 2.37e+07 | 1.19e+06 | [0.00, 2.57e+08]
2020 |        pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 |      pay_teach | 7.88e+06 | 3.06e+07 | 1.92e+06 | [0.00, 2.56e+08]
2020 |   avg_pay_phys |  2884.77 |  5941.00 |  3510.49 | [0.00, 42409.33]
2020 |    avg_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 |  avg_pay_teach | 3.26e+05 | 9.35e+05 | 1.25e+05 | [0.00, 8.86e+06]
2020 |   med_pay_phys |   483.91 |  1783.87 |   119.57 | [0.00, 25913.42]
2020 |    med_pay_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 |  med_pay_teach | 68844.58 | 2.69e+05 | 20861.84 | [0.00, 2.96e+06]
2020 |      pmts_phys | 21780.09 | 74950.38 |   528.75 | [0.00, 6.11e+05]
2020 |       pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 |     pmts_teach |   570.84 |  1657.28 |   297.50 | [0.00, 16887.00]
2020 |  avg_pmts_phys |     2.89 |     4.15 |     5.00 |    [0.00, 17.00]
2020 |   avg_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 | avg_pmts_teach |    32.88 |    78.71 |    25.75 |   [0.00, 668.00]
2020 |  med_pmts_phys |     1.10 |     1.64 |     2.00 |    [0.00, 13.00]
2020 |   med_pmts_npp |     0.00 |     0.00 |     0.00 |     [0.00, 0.00]
2020 | med_pmts_teach |    14.22 |    54.78 |    10.00 |   [0.00, 668.00]
2021 |       num_phys |  1423.69 |  5789.12 |     9.00 | [0.00, 59549.00]
2021 |        num_npp |   604.68 |  2377.39 |     0.00 | [0.00, 21525.00]
2021 |      num_teach |     4.98 |    14.13 |     1.00 |   [0.00, 121.00]
2021 |       pay_phys | 5.48e+06 | 2.41e+07 | 71463.91 | [0.00, 2.95e+08]
2021 |        pay_npp | 3.01e+05 | 1.24e+06 |     0.00 | [0.00, 1.24e+07]
2021 |      pay_teach | 6.48e+06 | 3.69e+07 | 18181.84 | [0.00, 5.36e+08]
2021 |   avg_pay_phys |  2809.96 |  8826.49 |  1574.71 | [0.00, 1.14e+05]
2021 |    avg_pay_npp |   750.95 |  7942.83 |     0.00 | [0.00, 1.55e+05]
2021 |  avg_pay_teach | 2.37e+05 | 9.01e+05 | 10112.19 | [0.00, 1.02e+07]
2021 |   med_pay_phys |   608.81 |  4029.37 |   122.11 | [0.00, 78000.00]
2021 |    med_pay_npp |   673.38 |  7935.80 |     0.00 | [0.00, 1.55e+05]
2021 |  med_pay_teach | 40247.49 | 1.78e+05 |  2901.72 | [0.00, 2.54e+06]
2021 |      pmts_phys | 19491.88 | 83758.01 |    28.75 | [0.00, 8.25e+05]
2021 |       pmts_npp |  8760.04 | 35699.37 |     0.00 | [0.00, 3.34e+05]
2021 |     pmts_teach |   365.57 |  1313.08 |    16.75 | [0.00, 15826.00]
2021 |  avg_pmts_phys |     2.34 |     4.53 |     3.00 |    [0.00, 24.00]
2021 |   avg_pmts_npp |     1.85 |     4.46 |     0.00 |    [0.00, 19.00]
2021 | avg_pmts_teach |    20.39 |    60.35 |     5.50 |   [0.00, 484.00]
2021 |  med_pmts_phys |     0.82 |     1.75 |     1.00 |    [0.00, 24.00]
2021 |   med_pmts_npp |     0.61 |     1.33 |     0.00 |    [0.00, 10.00]
2021 | med_pmts_teach |     8.05 |    37.03 |     2.00 |   [0.00, 484.00]
2022 |       num_phys |  1588.72 |  6452.36 |    12.50 | [0.00, 66238.00]
2022 |        num_npp |   708.61 |  2773.90 |     0.00 | [0.00, 24982.00]
2022 |      num_teach |     4.86 |    13.70 |     1.00 |   [0.00, 120.00]
2022 |       pay_phys | 6.46e+06 | 3.12e+07 | 51974.64 | [0.00, 4.55e+08]
2022 |        pay_npp | 4.22e+05 | 1.75e+06 |     0.00 | [0.00, 1.73e+07]
2022 |      pay_teach | 6.76e+06 | 4.40e+07 | 34309.06 | [0.00, 7.31e+08]
2022 |   avg_pay_phys |  2330.20 |  5850.01 |  1850.26 | [0.00, 64890.86]
2022 |    avg_pay_npp |   393.05 |  2506.92 |     0.00 | [0.00, 43750.00]
2022 |  avg_pay_teach | 2.54e+05 | 1.02e+06 | 12240.69 | [0.00, 1.12e+07]
2022 |   med_pay_phys |   498.80 |  1708.22 |   116.80 | [0.00, 24000.00]
2022 |    med_pay_npp |   268.28 |  2277.09 |     0.00 | [0.00, 43750.00]
2022 |  med_pay_teach | 43045.56 | 2.15e+05 |  3015.06 | [0.00, 3.52e+06]
2022 |      pmts_phys | 22303.56 | 95173.60 |    42.00 | [0.00, 9.16e+05]
2022 |       pmts_npp | 10461.30 | 42191.60 |     0.00 | [0.00, 3.87e+05]
2022 |     pmts_teach |   371.45 |  1314.58 |    11.00 | [0.00, 16446.00]
2022 |  avg_pmts_phys |     2.33 |     4.48 |     3.00 |    [0.00, 20.00]
2022 |   avg_pmts_npp |     2.00 |     4.66 |     0.00 |    [0.00, 20.00]
2022 | avg_pmts_teach |    22.57 |    70.02 |     4.00 |   [0.00, 780.00]
2022 |  med_pmts_phys |     0.81 |     1.38 |     2.00 |     [0.00, 9.00]
2022 |   med_pmts_npp |     0.67 |     1.51 |     0.00 |    [0.00, 14.00]
2022 | med_pmts_teach |     9.08 |    49.77 |     3.00 |   [0.00, 780.00]
2023 |       num_phys |  1679.16 |  6860.81 |    11.00 | [0.00, 70351.00]
2023 |        num_npp |   793.14 |  3130.87 |     1.00 | [0.00, 28727.00]
2023 |      num_teach |     4.70 |    13.37 |     1.00 |   [0.00, 122.00]
2023 |       pay_phys | 5.72e+06 | 2.51e+07 | 32647.47 | [0.00, 3.06e+08]
2023 |        pay_npp | 5.11e+05 | 2.12e+06 |   125.56 | [0.00, 2.10e+07]
2023 |      pay_teach | 5.61e+06 | 3.00e+07 |  8655.63 | [0.00, 3.83e+08]
2023 |   avg_pay_phys |  2184.93 |  7250.59 |  1306.00 | [0.00, 1.03e+05]
2023 |    avg_pay_npp |   322.50 |  1059.58 |    53.12 | [0.00, 10804.57]
2023 |  avg_pay_teach | 2.31e+05 | 8.77e+05 |  5288.56 | [0.00, 9.41e+06]
2023 |   med_pay_phys |   303.67 |   760.84 |   124.61 |  [0.00, 5609.69]
2023 |    med_pay_npp |   197.03 |   801.48 |    29.18 |  [0.00, 9630.00]
2023 |  med_pay_teach | 39072.25 | 2.30e+05 |  1161.03 | [0.00, 4.21e+06]
2023 |      pmts_phys | 23479.27 | 1.01e+05 |    41.00 | [0.00, 9.57e+05]
2023 |       pmts_npp | 12137.85 | 49307.25 |     1.00 | [0.00, 4.55e+05]
2023 |     pmts_teach |   350.32 |  1273.84 |     8.50 | [0.00, 14995.00]
2023 |  avg_pmts_phys |     2.40 |     4.44 |     3.25 |    [0.00, 19.00]
2023 |   avg_pmts_npp |     2.36 |     4.91 |     1.00 |    [0.00, 20.00]
2023 | avg_pmts_teach |    22.70 |    79.86 |     4.25 |   [0.00, 971.00]
2023 |  med_pmts_phys |     0.86 |     1.52 |     2.00 |    [0.00, 13.00]
2023 |   med_pmts_npp |     0.98 |     2.09 |     1.00 |    [0.00, 13.00]
2023 | med_pmts_teach |     9.73 |    63.25 |     1.75 |   [0.00, 971.00]
ALL  |       num_phys |  3078.91 | 12784.24 |    16.00 | [0.00, 1.40e+05]
ALL  |        num_npp |  1002.79 |  4104.29 |     1.00 | [0.00, 38149.00]
ALL  |      num_teach |     6.13 |    17.68 |     0.00 |   [0.00, 152.00]
ALL  |       pay_phys | 3.61e+07 | 1.65e+08 | 46817.37 | [0.00, 2.20e+09]
ALL  |        pay_npp | 1.12e+06 | 4.89e+06 |    23.60 | [0.00, 5.06e+07]
ALL  |      pay_teach | 3.81e+07 | 1.96e+08 |     0.00 | [0.00, 1.80e+09]
ALL  |   avg_pay_phys |  4572.20 | 11420.67 |  3766.69 | [0.00, 1.53e+05]
ALL  |    avg_pay_npp |   486.54 |  1710.31 |    23.60 | [0.00, 22761.11]
ALL  |  avg_pay_teach | 1.07e+06 | 4.00e+06 |     0.00 | [0.00, 4.43e+07]
ALL  |   med_pay_phys |   638.59 |  3071.25 |   207.44 | [0.00, 44135.14]
ALL  |    med_pay_npp |   217.86 |   837.14 |    23.60 |  [0.00, 9630.00]
ALL  |  med_pay_teach | 2.14e+05 | 1.43e+06 |     0.00 | [0.00, 2.27e+07]
ALL  |      pmts_phys | 1.46e+05 | 6.51e+05 |    96.75 | [0.00, 6.66e+06]
ALL  |       pmts_npp | 28543.40 | 1.22e+05 |     1.00 | [0.00, 1.17e+06]
ALL  |     pmts_teach |  2525.08 |  9185.96 |     0.00 | [0.00, 1.11e+05]
ALL  |  avg_pmts_phys |     6.55 |    14.62 |     5.00 |    [0.00, 75.00]
ALL  |   avg_pmts_npp |     3.46 |     8.54 |     1.00 |    [0.00, 41.00]
ALL  | avg_pmts_teach |   114.69 |   404.27 |     0.00 |  [0.00, 5293.00]
ALL  |  med_pmts_phys |     1.47 |     2.87 |     2.00 |    [0.00, 24.00]
ALL  |   med_pmts_npp |     0.95 |     2.00 |     1.00 |    [0.00, 13.00]
ALL  | med_pmts_teach |    50.24 |   327.00 |     0.00 |  [0.00, 5293.00]

year | Skewness | Kurtosis |   n | n_Missing
--------------------------------------------
2017 |     5.03 |    30.15 | 269 |         0
2017 |          |          | 269 |         0
2017 |     3.49 |    14.68 | 269 |         0
2017 |     5.51 |    37.15 | 269 |         0
2017 |          |          | 269 |         0
2017 |     9.19 |   102.88 | 269 |         0
2017 |     3.60 |    18.69 | 269 |         0
2017 |          |          | 269 |         0
2017 |     5.03 |    30.93 | 269 |         0
2017 |     2.43 |     6.05 | 269 |         0
2017 |          |          | 269 |         0
2017 |    11.64 |   154.92 | 269 |         0
2017 |     4.95 |    28.40 | 269 |         0
2017 |          |          | 269 |         0
2017 |     4.60 |    27.41 | 269 |         0
2017 |     2.18 |     6.62 | 269 |         0
2017 |          |          | 269 |         0
2017 |     5.27 |    35.37 | 269 |         0
2017 |    10.77 |   150.97 | 269 |         0
2017 |          |          | 269 |         0
2017 |     9.41 |    97.33 | 269 |         0
2018 |     5.20 |    32.28 | 278 |         0
2018 |          |          | 278 |         0
2018 |     3.59 |    15.67 | 278 |         0
2018 |     6.21 |    48.39 | 278 |         0
2018 |          |          | 278 |         0
2018 |     9.43 |   107.38 | 278 |         0
2018 |     5.23 |    43.56 | 278 |         0
2018 |          |          | 278 |         0
2018 |     5.54 |    39.77 | 278 |         0
2018 |    12.32 |   179.32 | 278 |         0
2018 |          |          | 278 |         0
2018 |    10.92 |   136.91 | 278 |         0
2018 |     5.15 |    30.79 | 278 |         0
2018 |          |          | 278 |         0
2018 |     4.28 |    22.63 | 278 |         0
2018 |     1.49 |     1.01 | 278 |         0
2018 |          |          | 278 |         0
2018 |     4.63 |    27.70 | 278 |         0
2018 |     3.61 |    24.44 | 278 |         0
2018 |          |          | 278 |         0
2018 |     9.38 |   100.17 | 278 |         0
2019 |     5.15 |    31.58 | 279 |         0
2019 |          |          | 279 |         0
2019 |     3.45 |    14.15 | 279 |         0
2019 |     5.93 |    41.94 | 279 |         0
2019 |          |          | 279 |         0
2019 |     6.45 |    44.66 | 279 |         0
2019 |    12.34 |   181.18 | 279 |         0
2019 |          |          | 279 |         0
2019 |     4.84 |    27.77 | 279 |         0
2019 |    16.34 |   270.64 | 279 |         0
2019 |          |          | 279 |         0
2019 |     6.99 |    55.48 | 279 |         0
2019 |     5.21 |    31.53 | 279 |         0
2019 |          |          | 279 |         0
2019 |     5.00 |    32.60 | 279 |         0
2019 |     1.46 |     1.08 | 279 |         0
2019 |          |          | 279 |         0
2019 |     6.77 |    67.16 | 279 |         0
2019 |     4.86 |    45.70 | 279 |         0
2019 |          |          | 279 |         0
2019 |    11.98 |   165.79 | 279 |         0
2020 |     5.10 |    30.77 | 268 |         0
2020 |          |          | 268 |         0
2020 |     3.42 |    13.55 | 268 |         0
2020 |     6.59 |    55.38 | 268 |         0
2020 |          |          | 268 |         0
2020 |     5.98 |    39.11 | 268 |         0
2020 |     3.55 |    15.91 | 268 |         0
2020 |          |          | 268 |         0
2020 |     4.93 |    32.28 | 268 |         0
2020 |    11.22 |   155.77 | 268 |         0
2020 |          |          | 268 |         0
2020 |     7.07 |    60.69 | 268 |         0
2020 |     5.24 |    31.79 | 268 |         0
2020 |          |          | 268 |         0
2020 |     5.44 |    40.21 | 268 |         0
2020 |     1.41 |     0.84 | 268 |         0
2020 |          |          | 268 |         0
2020 |     3.95 |    20.43 | 268 |         0
2020 |     3.02 |    15.00 | 268 |         0
2020 |          |          | 268 |         0
2020 |     8.49 |    86.50 | 268 |         0
2021 |     6.29 |    46.96 | 408 |         0
2021 |     5.64 |    37.34 | 408 |         0
2021 |     4.51 |    24.56 | 408 |         0
2021 |     7.31 |    66.61 | 408 |         0
2021 |     6.08 |    43.92 | 408 |         0
2021 |    10.04 |   121.12 | 408 |         0
2021 |     7.50 |    77.26 | 408 |         0
2021 |    18.21 |   349.11 | 408 |         0
2021 |     6.51 |    53.11 | 408 |         0
2021 |    17.63 |   336.69 | 408 |         0
2021 |    18.28 |   351.08 | 408 |         0
2021 |     9.07 |   106.50 | 408 |         0
2021 |     6.51 |    49.60 | 408 |         0
2021 |     5.75 |    39.09 | 408 |         0
2021 |     6.47 |    56.42 | 408 |         0
2021 |     2.21 |     4.21 | 408 |         0
2021 |     2.47 |     4.75 | 408 |         0
2021 |     4.31 |    21.06 | 408 |         0
2021 |     6.70 |    77.34 | 408 |         0
2021 |     2.73 |     9.61 | 408 |         0
2021 |     9.35 |   100.23 | 408 |         0
2022 |     6.29 |    47.02 | 405 |         0
2022 |     5.64 |    37.29 | 405 |         0
2022 |     4.54 |    25.29 | 405 |         0
2022 |     9.36 |   114.24 | 405 |         0
2022 |     6.23 |    45.59 | 405 |         0
2022 |    12.67 |   190.29 | 405 |         0
2022 |     4.80 |    36.54 | 405 |         0
2022 |    14.34 |   232.87 | 405 |         0
2022 |     6.96 |    58.88 | 405 |         0
2022 |     8.17 |    96.11 | 405 |         0
2022 |    17.52 |   331.59 | 405 |         0
2022 |    11.65 |   173.01 | 405 |         0
2022 |     6.45 |    48.69 | 405 |         0
2022 |     5.69 |    38.13 | 405 |         0
2022 |     6.77 |    63.35 | 405 |         0
2022 |     2.14 |     3.66 | 405 |         0
2022 |     2.39 |     4.39 | 405 |         0
2022 |     5.68 |    44.08 | 405 |         0
2022 |     2.00 |     4.86 | 405 |         0
2022 |     3.38 |    18.04 | 405 |         0
2022 |    12.27 |   171.01 | 405 |         0
2023 |     6.30 |    47.12 | 410 |         0
2023 |     5.73 |    38.58 | 410 |         0
2023 |     4.65 |    26.83 | 410 |         0
2023 |     7.41 |    67.90 | 410 |         0
2023 |     6.24 |    45.93 | 410 |         0
2023 |     8.95 |    91.51 | 410 |         0
2023 |     9.01 |   108.51 | 410 |         0
2023 |     6.61 |    53.45 | 410 |         0
2023 |     6.35 |    49.58 | 410 |         0
2023 |     2.99 |     9.83 | 410 |         0
2023 |     8.54 |    92.02 | 410 |         0
2023 |    15.14 |   267.69 | 410 |         0
2023 |     6.49 |    49.19 | 410 |         0
2023 |     5.76 |    39.15 | 410 |         0
2023 |     6.43 |    54.02 | 410 |         0
2023 |     2.03 |     3.23 | 410 |         0
2023 |     2.10 |     3.21 | 410 |         0
2023 |     7.29 |    70.22 | 410 |         0
2023 |     2.90 |    14.51 | 410 |         0
2023 |     2.69 |     8.14 | 410 |         0
2023 |    13.19 |   184.86 | 410 |         0
ALL  |     6.47 |    50.47 | 448 |         0
ALL  |     5.88 |    40.37 | 448 |         0
ALL  |     4.42 |    23.43 | 448 |         0
ALL  |     8.06 |    82.68 | 448 |         0
ALL  |     6.51 |    50.03 | 448 |         0
ALL  |     7.44 |    58.98 | 448 |         0
ALL  |     6.36 |    68.01 | 448 |         0
ALL  |     7.86 |    81.62 | 448 |         0
ALL  |     5.99 |    44.79 | 448 |         0
ALL  |    11.11 |   140.24 | 448 |         0
ALL  |     6.93 |    61.27 | 448 |         0
ALL  |    11.75 |   159.86 | 448 |         0
ALL  |     6.70 |    52.54 | 448 |         0
ALL  |     6.03 |    42.91 | 448 |         0
ALL  |     6.45 |    55.18 | 448 |         0
ALL  |     2.71 |     6.58 | 448 |         0
ALL  |     2.75 |     6.51 | 448 |         0
ALL  |     7.32 |    72.97 | 448 |         0
ALL  |     3.79 |    21.44 | 448 |         0
ALL  |     2.42 |     6.07 | 448 |         0
ALL  |    12.42 |   174.80 | 448 |         0