| Literature DB >> 31663856 |
Lawrence Fulton1, Clemens Scott Kruse1.
Abstract
BACKGROUND: Hospital-based back surgery in the United States increased by 60% from January 2012 to December 2017, yet the supply of neurosurgeons remained relatively constant. During this time, adult obesity grew by 5%.Entities:
Keywords: back surgery; elastic net; geospatial mapping; health economics; lasso; neurosurgeon; obesity; practice variation; random forest; ridge
Mesh:
Year: 2019 PMID: 31663856 PMCID: PMC6914242 DOI: 10.2196/14609
Source DB: PubMed Journal: J Med Internet Res ISSN: 1438-8871 Impact factor: 5.428
Figure 1Argmin equations for the regression models.
Figure 2An example of a single tree model with 3 branches. The graph was produced by the xgboost package of R. (NumDischarges indicates the number of discharges).
Variables in the study.
| Variable | Type | Definition | Scale of measurement |
| Number of claims | Dependent | Filed third-party claims | {0, 1, 2, ...k} |
| Obesity rate | Obesity | Percentage obese by state | [0%, 40%] |
| CPTa 63 payments | Financial | Total CPT 63 payments | US $ |
| CPT 63 charges | Financial | Total CPT 63 charges | US $ |
| Net patient revenue | Financial | Total revenue from patients | US $ |
| Total revenues | Financial | All revenue, patient-related or otherwise | US $ |
| Net income | Financial | Revenues less expenses | US $ |
| Total expenses | Financial | Total dollars attributed to expenses | US $ |
| Cash on hand | Financial | Funds immediately available | US $ |
| Total assets | Financial | Current and noncurrent assets | US $ |
| Total liabilities | Financial | Current and long-term debt | US $ |
| Percentage Medicare/Medicaid | Financial | Percentage claims from either source | % |
| State | Geospatial | Hospital's state (address) | AK, AL, ... |
| Zip code | Geospatial | 5-digit hospital zip code | 78666, ... |
| Geographic classification | Technical | Rural or urban location | Rural, urban |
| Ownership | Technical | Hospital ownership | Nonprofit, profit, government |
| Medical school affiliation | Technical | Level of affiliation if any | Graduate, major, limited, none |
| Hospital type | Technical | Type of hospital | Short-term acute, children’s, etc |
| Year | Temporal | Year of report | 2012, 2018 |
| Number of staffed beds | Workload | Per Medicare report | {0, 1, ...n} |
| Number of discharges | Workload | Total number of inpatient discharges | {0, 1, ...n} |
| Number of Medicare discharges | Workload | Number of Medicare discharges | {0, 1, ...n} |
| Estimated number of emergency room visits | Workload | Number of emergency room visits | {0, 1, ...n} |
| Total surgeries | Workload | Number of surgeries | {0, 1, ...n} |
| Total acute days | Workload | Number of acute bed days | {0, 1, ...n} |
| Number of affiliated physicians | Workload | Number of affiliated physicians | {0, 1, ...n} |
| Number of employees | Workload | Number of employees | {0, 1, ...n} |
aCPT: Current Procedural Terminology.
Descriptive statistics for all years and all hospitals (N=13,769). The “K” suffix indicates dollars in thousands, while the “M” suffix indicates dollars in millions.
| Variable | Mean (SD) | Median | Minimum | Maximum |
| Claims, n | 182 (244) | 89 | 11 | 3592 |
| Payments/claim, US $ | 4045.99 (2448.96) | 3659.12 | 0 | 34,975.76 |
| Payments, US $ | 767.9K (1097.8K) | 366.2K | 0 | 18,966.3K |
| Charges, US $ | 1517.6K (2467.4K) | 616.4K | 0 | 35,317.2K |
| Charges/claim, US $ | 8032.13 (6993.90) | 6370.08 | 0 | 137,058.80 |
| Net patient revenue, US $ | 343.8M (430.4M) | 217.5M | −98.6M | 5340.9M |
| Net income, US $ | 22.8M (102.8M) | 11.3M | −1648M | 1316.0M |
| Cash, US $ | 30.3M (145.3M) | 2.8M | −1992.7M | 3597.8M |
| Total assets, US $ | 443.0M (820.1M) | 203.5M | −231.7M | 9969.4M |
| Total liabilities, US $ | 178.2M (465.7M) | 69.2M | −2583.8M | 6372.4M |
| Staffed beds, n | 227.45 (201.36) | 177.00 | 1.00 | 2626 |
| Discharges, n | 11,822.61 (11,395.52) | 8899.00 | 1.00 | 127,600 |
| Emergency room visits, n | 47,439.59 (39,580.09) | 39,209.00 | 0 | 543,457 |
| Surgeries, n | 9643.21 (9666.56) | 7019.00 | 0 | 134,638 |
| Affiliated physicians, n | 298.57 (333.43) | 198.00 | 1.00 | 3483 |
| Employees, n | 1629.46 (2044.45) | 1027.00 | 7.00 | 24,673 |
| Percentage of Medicare/Medicaid, % | 0.45 (0.14) | 0.44 | 0 | 1 |
| Obesity rate, n | 29.44 (3.42) | 29.92 | 20.20 | 38 |
Average statistics by year show the growth in both claims and payments.
| Year | Hospitals, n | Total payments, in millions of US $ | Total charges, in millions of US $ | Total claims, n | Payments/claim, in US $ | Charges/claim, in US $ |
| 2012 | 2248 | 1232.61 | 2114.56 | 320,371 | 3847 | 6600 |
| 2013 | 2293 | 1460.80 | 2698.34 | 372,155 | 3925 | 7251 |
| 2014 | 2306 | 1517.88 | 3396.62 | 410,317 | 3699 | 8278 |
| 2015 | 2290 | 1747.68 | 3688.72 | 428,813 | 4076 | 8602 |
| 2016 | 2336 | 2147.48 | 4247.37 | 472,004 | 4550 | 8999 |
| 2017 | 2339 | 2466.92 | 4750.68 | 504,626 | 4889 | 9414 |
Payments, charges, number of claims, payment per claim, charge per claim, and percentage of charges paid by state.
| State | Payments, in millions of US $ | Charges, in millions of US $ | Number of claims, n | Payment/claim, in US $ | Charge/claim, in US $ | Percentage paid, % |
| Alaska | 21.17 | 37.94 | 4387 | 4826.27 | 8649.31 | 55.80 |
| Alabama | 232.76 | 419.16 | 75,486 | 3083.47 | 5552.77 | 55.50 |
| Arkansas | 124.27 | 200.21 | 33,087 | 3755.85 | 6051.07 | 62.10 |
| Arizona | 175.60 | 526.67 | 41,274 | 4254.39 | 12,760.42 | 33.30 |
| California | 563.57 | 1748.02 | 113,410 | 4969.31 | 15,413.29 | 32.20 |
| Colorado | 147.28 | 440.24 | 41,537 | 3545.72 | 10,598.65 | 33.50 |
| Connecticut | 72.96 | 139.43 | 17,179 | 4247.17 | 8116.50 | 52.30 |
| District of Columbia | 26.31 | 53.90 | 5655 | 4651.78 | 9531.16 | 48.80 |
| Delaware | 28.91 | 25.94 | 5569 | 5190.62 | 4657.34 | 111.50 |
| Florida | 546.44 | 1543.23 | 131,442 | 4157.29 | 11,740.79 | 35.40 |
| Georgia | 318.64 | 654.84 | 79,401 | 4013.02 | 8247.29 | 48.70 |
| Hawaii | 12.02 | 22.03 | 2802 | 4291.08 | 7861.44 | 54.60 |
| Iowa | 131.47 | 277.09 | 34,419 | 3819.62 | 8050.58 | 47.40 |
| Idaho | 93.02 | 163.59 | 23,514 | 3956.12 | 6957.22 | 56.90 |
| Illinois | 361.17 | 706.39 | 81,960 | 4406.60 | 8618.73 | 51.10 |
| Indiana | 361.28 | 800.98 | 87,204 | 4142.93 | 9185.09 | 45.10 |
| Kansas | 193.40 | 310.85 | 39,992 | 4836.07 | 7772.78 | 62.20 |
| Kentucky | 215.53 | 306.93 | 50,147 | 4298.00 | 6120.69 | 70.20 |
| Louisiana | 204.21 | 423.83 | 55,726 | 3664.61 | 7605.54 | 48.20 |
| Massachusetts | 210.91 | 267.24 | 42,609 | 4950.01 | 6272.03 | 78.90 |
| Maryland | 83.04 | 96.72 | 34,732 | 2390.89 | 2784.66 | 85.90 |
| Maine | 69.88 | 78.25 | 21,468 | 3255.23 | 3645.18 | 89.30 |
| Michigan | 311.32 | 389.73 | 70,173 | 4436.41 | 5553.81 | 79.90 |
| Minnesota | 191.90 | 279.98 | 47,410 | 4047.73 | 5905.41 | 68.50 |
| Missouri | 362.53 | 487.40 | 83,085 | 4363.33 | 5866.30 | 74.40 |
| Mississippi | 159.04 | 400.04 | 39,059 | 4071.72 | 10,241.97 | 39.80 |
| Montana | 54.19 | 86.78 | 14,106 | 3841.66 | 6151.89 | 62.40 |
| North Carolina | 503.97 | 886.27 | 126,344 | 3988.87 | 7014.74 | 56.90 |
| North Dakota | 36.87 | 43.36 | 9081 | 4060.13 | 4774.58 | 85.00 |
| Nebraska | 94.49 | 184.44 | 24,310 | 3,886.98 | 7586.98 | 51.20 |
| New Hampshire | 74.81 | 120.38 | 19,091 | 3918.49 | 6305.40 | 62.10 |
| New Jersey | 169.55 | 328.00 | 35,479 | 4778.93 | 9244.90 | 51.70 |
| New Mexico | 31.17 | 68.52 | 8583 | 3631.59 | 7983.19 | 45.50 |
| Nevada | 97.33 | 190.03 | 24,617 | 3953.67 | 7719.64 | 51.20 |
| New York | 364.09 | 395.74 | 72,186 | 5043.79 | 5482.21 | 92.00 |
| Ohio | 396.47 | 743.30 | 87,427 | 4534.88 | 8501.92 | 53.30 |
| Oklahoma | 239.62 | 494.62 | 51,639 | 4640.38 | 9578.46 | 48.40 |
| Oregon | 180.39 | 280.10 | 38,328 | 4706.54 | 7307.94 | 64.40 |
| Pennsylvania | 383.17 | 736.78 | 85,334 | 4490.29 | 8634.05 | 52.00 |
| Rhode Island | 15.94 | 16.37 | 3772 | 4225.09 | 4339.10 | 97.40 |
| South Carolina | 293.49 | 492.03 | 60,977 | 4813.14 | 8069.03 | 59.60 |
| South Dakota | 70.42 | 204.78 | 17,870 | 3940.84 | 11,459.54 | 34.40 |
| Tennessee | 289.03 | 619.13 | 79,948 | 3615.26 | 7744.18 | 46.70 |
| Texas | 1,098.91 | 2,450.47 | 260,208 | 4223.22 | 9417.34 | 44.80 |
| Utah | 143.63 | 138.51 | 31,168 | 4608.37 | 4443.86 | 103.70 |
| Virginia | 231.88 | 466.58 | 56,436 | 4108.69 | 8267.36 | 49.70 |
| Vermont | 12.44 | 24.56 | 3578 | 3476.00 | 6864.49 | 50.60 |
| Washington | 264.29 | 669.87 | 66,457 | 3976.84 | 10,079.74 | 39.50 |
| Wisconsin | 161.13 | 283.08 | 39,182 | 4112.30 | 7224.71 | 56.90 |
| West Virginia | 117.51 | 131.28 | 23,852 | 4926.48 | 5504.07 | 89.50 |
| Wyoming | 29.94 | 40.79 | 6149 | 4868.89 | 6633.27 | 73.40 |
State statistics for the proportion of the population identified as obese by the Behavioral Risk Factor Surveillance System by year.
| Statistic | Year | |||||
|
| 2012 | 2013 | 2014 | 2015 | 2016 | 2017 |
| Mean (SD) proportions | 27.95 (3.38) | 28.65 (3.44) | 29.23 (3.42) | 29.28 (3.87) | 29.78 (3.74) | 30.59 (3.86) |
| Median proportions | 27.60 | 29.40 | 29.60 | 29.83 | 29.92 | 31.30 |
| Range | 14.2 | 13.8 | 14.6 | 16.0 | 15.39 | 15.42 |
| Minimum | 20.5 | 21.3 | 21.3 | 20.2 | 22.27 | 22.64 |
| Maximum | 34.7 | 35.1 | 35.9 | 36.2 | 37.66 | 38.06 |
| Count | 51 | 51 | 51 | 51 | 51 | 51 |
Figure 3The correlation matrix depicts the variable relationships. The X’s indicate no statistically significant correlation. Owing to the large sample size, nearly all correlations are statistically significant at the alpha=.05 level. The matrix was produced using ggcorrplot.
Figure 4Correlation between the natural logarithm of obesity rates and the natural logarithm of the number of CPT 63 surgeries performed by hospitals.
Figure 5The untransformed and transformed histograms of the number of claims and the obesity rate variables.
Figure 6Geospatial analysis of all CPT 63 claims from 2012 through 2017.
The performance metrics of the various hierarchical models show that the exponential, trend, seasonality middle-out model performed best on the test set.
| Model | Mean error | Root mean squared error | Mean absolute error | Mean percent error (%) | Mean absolute percent error (%) |
| ETSa-bottom up | 860.42 | 2905.64 | 1371.81 | 3.16 | 10.71 |
| ETS-top down | 688.26 | 2423.58 | 1266.13 | 3.03 | 10.54 |
| ETS-middle out | 611.75 | 2256.70 | 1219.59 | 2.70 | 10.50 |
| ETS-combination | 682.27 | 2404.41 | 1235.04 | 2.25 | 9.56 |
| ARIMAb-bottom up | 5732.63 | 16496.72 | 5762.20 | 24.93 | 26.65 |
| ARIMA-top down | 5214.61 | 14953.59 | 5312.37 | 23.26 | 25.66 |
| ARIMA-middle out | 4606.38 | 13420.78 | 4799.88 | 20.70 | 24.20 |
| ARIMA-combination | 5159.04 | 14782.37 | 5259.67 | 20.65 | 25.92 |
aETS: exponential, trend, seasonality.
bARIMA: autoregressive integrated moving average.
Region-level forecasts demonstrate small error. The average mean absolute percent error (MAPE) for {2016, 2017} was {3.4%, 6.2%}, respectively.
| Region | 2016 forecast | 2016 actual | 2017 forecast | 2017 actual | MAPE 2016 (%) | MAPE 2017 (%) |
| East North Central | 67,019 | 67,672 | 70,630 | 72,720 | 1.0 | 2.9 |
| East South Central | 42,765 | 42,747 | 44,477 | 47,107 | 0.0 | 5.6 |
| Middle Atlantic | 35,044 | 37,532 | 38,309 | 42,860 | 6.6 | 10.6 |
| Mountain | 35,840 | 35,254 | 38,211 | 38,341 | 1.7 | 0.3 |
| New England | 17,763 | 19,476 | 17,763 | 20,733 | 8.8 | 14.3 |
| Pacific | 45,015 | 43,647 | 49,122 | 43,865 | 3.1 | 12.0 |
| South Atlantic | 94,650 | 96,093 | 100,266 | 103,546 | 1.5 | 3.2 |
| West North Central | 45,653 | 46,550 | 48,075 | 48,600 | 1.9 | 1.1 |
| West South Central | 70,972 | 75,352 | 75,197 | 79,553 | 5.8 | 5.5 |
Forecasts produced by the exponential, trend, seasonality middle-out model by state for 2016 and 2017 have an average mean absolute percent error (MAPE) of 10.1% and 13.2%, respectively.
| State | 2016 forecast | 2016 actual | 2017 forecast | 2017 actual | Mean absolute error 2016 (%) | Mean absolute error 2017 (%) |
| Alaska | 773 | 1,132 | 825 | 784 | 31.7 | 5.2 |
| Alabama | 13,709 | 14,029 | 14,658 | 15,697 | 2.3 | 6.6 |
| Arkansas | 6550 | 6193 | 7077 | 6150 | 5.8 | 15.1 |
| Arizona | 8450 | 7585 | 9438 | 9624 | 11.4 | 1.9 |
| California | 22,060 | 21,402 | 24,242 | 21,859 | 3.1 | 10.9 |
| Colorado | 7089 | 6736 | 7081 | 6512 | 5.2 | 8.7 |
| Connecticut | 2539 | 3103 | 2446 | 3289 | 18.2 | 25.6 |
| Dist. of Columbia | 1052 | 1015 | 1070 | 1041 | 3.6 | 2.8 |
| Delaware | 702 | 1129 | 683 | 1286 | 37.8 | 46.9 |
| Florida | 24,991 | 23,611 | 26,870 | 25,417 | 5.8 | 5.7 |
| Georgia | 15,324 | 14,293 | 16,372 | 14,093 | 7.2 | 16.2 |
| Hawaii | 369 | 451 | 370 | 527 | 18.2 | 29.8 |
| Iowa | 5613 | 5698 | 5624 | 6069 | 1.5 | 7.3 |
| Idaho | 3775 | 4755 | 3920 | 4793 | 20.6 | 18.2 |
| Illinois | 15,590 | 15,793 | 16,474 | 15,168 | 1.3 | 8.6 |
| Indiana | 14,839 | 14,839 | 14,850 | 14,648 | 0.0 | 1.4 |
| Kansas | 6943 | 7792 | 7382 | 7969 | 10.9 | 7.4 |
| Kentucky | 8061 | 7805 | 8044 | 9239 | 3.3 | 12.9 |
| Louisiana | 10,682 | 9817 | 11,519 | 11,044 | 8.8 | 4.3 |
| Massachusetts | 7251 | 8424 | 7533 | 9556 | 13.9 | 21.2 |
| Maryland | 6196 | 6458 | 6475 | 6785 | 4.1 | 4.6 |
| Maine | 3532 | 3707 | 3402 | 3345 | 4.7 | 1.7 |
| Michigan | 13,843 | 12,998 | 15,005 | 14,914 | 6.5 | 0.6 |
| Minnesota | 10,768 | 9,499 | 12,317 | 9507 | 13.4 | 29.6 |
| Missouri | 13,157 | 14,155 | 13,181 | 15,378 | 7.1 | 14.3 |
| Mississippi | 6943 | 7562 | 7252 | 7301 | 8.2 | 0.7 |
| Montana | 2954 | 2638 | 3116 | 2108 | 12.0 | 47.8 |
| North Carolina | 21,173 | 22,429 | 21,527 | 24,314 | 5.6 | 11.5 |
| North Dakota | 1839 | 1672 | 2017 | 2013 | 10.0 | 0.2 |
| Nebraska | 4437 | 4036 | 4576 | 4210 | 9.9 | 8.7 |
| New Hampshire | 3000 | 3073 | 2890 | 3382 | 2.4 | 14.5 |
| New Jersey | 6643 | 7067 | 7102 | 6659 | 6.0 | 6.7 |
| New Mexico | 1351 | 1570 | 1350 | 1755 | 13.9 | 23.1 |
| Nevada | 5067 | 4497 | 5606 | 5320 | 12.7 | 5.4 |
| New York | 12,876 | 14,206 | 14,014 | 15,442 | 9.4 | 9.2 |
| Ohio | 15,944 | 16,977 | 17,075 | 19,643 | 6.1 | 13.1 |
| Oklahoma | 9613 | 10,214 | 10,421 | 10,386 | 5.9 | 0.3 |
| Oregon | 7875 | 7,111 | 8454 | 7574 | 10.7 | 11.6 |
| Pennsylvania | 15,524 | 16,259 | 17,193 | 20,759 | 4.5 | 17.2 |
| Rhode Island | 841 | 695 | 914 | 750 | 21.0 | 21.9 |
| South Carolina | 11,050 | 10,921 | 11,858 | 13,494 | 1.2 | 12.1 |
| South Dakota | 2896 | 3698 | 2977 | 3454 | 21.7 | 13.8 |
| Tennessee | 14,052 | 13,351 | 14,523 | 14,870 | 5.3 | 2.3 |
| Texas | 44,127 | 49,128 | 46,181 | 51,973 | 10.2 | 11.1 |
| Utah | 6220 | 6077 | 6765 | 6811 | 2.4 | 0.7 |
| Virginia | 10,543 | 12,143 | 11,731 | 12,020 | 13.2 | 2.4 |
| Vermont | 600 | 474 | 578 | 411 | 26.6 | 40.6 |
| Washington | 13,937 | 13,551 | 15,231 | 13,121 | 2.8 | 16.1 |
| Wisconsin | 6803 | 7065 | 7227 | 8347 | 3.7 | 13. |
| West Virginia | 3619 | 4094 | 3680 | 5096 | 11.6 | 27.8 |
| Wyoming | 935 | 1396 | 934 | 1418 | 33.0 | 34.1 |
Figure 7Regional forecasts generated by the hierarchical time series middle-out model with exponential, trend, seasonality components.
Variables below from the stepwise regression predicted a withhold set with adjusted R2=0.38.
| Variable | Sum of squares | Mean squared error | ||
| Staffed beds | 95.78 | 95.78 | 2423.29 (1) | <.001 |
| Discharges | 21.93 | 21.93 | 554.77 (1) | <.001 |
| ER visits | 17.50 | 17.50 | 442.68 (1) | <.001 |
| Surgeries | 41.15 | 41.15 | 1041.03 (1) | <.001 |
| Net patient revenue | 5.57 | 5.57 | 140.99 (1) | <.001 |
| Net income | 2.53 | 2.53 | 63.97 (1) | <.001 |
| Total liabilities | 4.45 | 4.45 | 112.70 (1) | <.001 |
| Affiliated physicians | 0.24 | 0.24 | 6.08 (1) | <.01 |
| Employees | 6.28 | 6.28 | 158.78 (1) | <.001 |
| Percentage Medicare/Medicaid | 1.16 | 1.16 | 29.34 (1) | <.001 |
| State | 52.35 | 1.05 | 26.49 (50) | <.001 |
| Year | 8.09 | 1.62 | 40.91 (5) | <.001 |
| Urban rural status | 1.99 | 1.99 | 50.43 (1) | <.001 |
| Ownership | 10.76 | 0.90 | 22.68 (12) | <.001 |
| Medical school affiliation | 2.16 | 0.54 | 13.63 (4) | <.001 |
| Hospital type | 0.64 | 0.13 | 3.24 (5) | <.01 |
Variables in the analysis by state and by year.
| Variable | Sum of squares | Mean squared error | ||
| State | 1.16 | 0.02 | 26.40 (50) | <.01 |
| Year | 0.17 | 0.03 | 39.16 (5) | <.01 |
| Discharges | 0.06 | 0.06 | 63.19 (1) | <.01 |
| Net income | 0.004 | 0.004 | 4.45 (1) | .04 |
| Total liabilities | 0.004 | 0.004 | 4.65 (1) | .03 |
Top 10 coefficients by effect size of the elastic net.
| Variable | Coefficient |
| Total assets | −1.539 |
| Net patient revenue | −1.044 |
| Number of staffed beds | 0.212 |
| Number of discharges | 0.186 |
| New Jersey | −0.178 |
| Total surgeries | 0.162 |
| New York | −0.159 |
| California | −0.145 |
| Delaware | −0.143 |
| Employees | −0.136 |
Figure 8Gain plot for the top 5 variables, unaggregated model.
Figure 9Cover plot for the top 5 variables, unaggregated model.
Figure 10Gain plot for the top 5 variables, aggregated model.
Figure 11Cover plot for the top 5 variables, aggregated model.