Name: ProcedureCounts FY24
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-zero
About this Dataset

ProcedureCounts FY24

CPT frequency counts for encounters in outpatient and inpatient settings in the VA healthcare system. Does NOT include services provided in the community.
Organization: Department of Veterans Affairs
Last updated: 2025-04-02T04:34:33.977973
Tags: medical, medical-care, treatment
Tables

Table 1

@usgov.va_gov_procedurecounts_fy24.table_1
2.03 MB
14,637 rows
142 columns
CREATE TABLE table_1 (
  "cpt_display" VARCHAR,
  "national" VARCHAR,
  "n__v01_402_togus_me_hcs" VARCHAR  -- (V01) (402) Togus, ME HCS,
  "n__v01_405_white_river_junction_vt_hcs" VARCHAR  -- (V01) (405) White River Junction, VT HCS,
  "n__v01_518_bedford_ma_hcs" VARCHAR  -- (V01) (518) Bedford, MA HCS,
  "n__v01_523_boston_ma_hcs" VARCHAR  -- (V01) (523) Boston, MA HCS,
  "n__v01_608_manchester_nh_hcs" VARCHAR  -- (V01) (608) Manchester, NH HCS,
  "n__v01_631_central_western_massachusetts_hcs" VARCHAR  -- (V01) (631) Central Western Massachusetts HCS,
  "n__v01_650_providence_ri_hcs" VARCHAR  -- (V01) (650) Providence, RI HCS,
  "n__v01_689_connecticut_hcs" VARCHAR  -- (V01) (689) Connecticut HCS,
  "n__v02_526_bronx_ny_hcs" VARCHAR  -- (V02) (526) Bronx, NY HCS,
  "n__v02_528_western_new_york_hcs" VARCHAR  -- (V02) (528) Western New York HCS,
  "n__v02_528a6_finger_lakes_ny_hcs" VARCHAR  -- (V02) (528A6) Finger Lakes, NY HCS,
  "n__v02_528a7_syracuse_ny_hcs" VARCHAR  -- (V02) (528A7) Syracuse, NY HCS,
  "n__v02_528a8_albany_ny_hcs" VARCHAR  -- (V02) (528A8) Albany, NY HCS,
  "n__v02_561_new_jersey_hcs" VARCHAR  -- (V02) (561) New Jersey HCS,
  "n__v02_620_hudson_valley_ny_hcs" VARCHAR  -- (V02) (620) Hudson Valley, NY HCS,
  "n__v02_630_new_york_harbor_hcs" VARCHAR  -- (V02) (630) New York Harbor HCS,
  "n__v02_632_northport_ny_hcs" VARCHAR  -- (V02) (632) Northport, NY HCS,
  "n__v04_460_wilmington_de_hcs" VARCHAR  -- (V04) (460) Wilmington, DE HCS,
  "n__v04_503_altoona_pa_hcs" VARCHAR  -- (V04) (503) Altoona, PA HCS,
  "n__v04_529_butler_pa_hcs" VARCHAR  -- (V04) (529) Butler, PA HCS,
  "n__v04_542_coatesville_pa_hcs" VARCHAR  -- (V04) (542) Coatesville, PA HCS,
  "n__v04_562_erie_pa_hcs" VARCHAR  -- (V04) (562) Erie, PA HCS,
  "n__v04_595_lebanon_pa_hcs" VARCHAR  -- (V04) (595) Lebanon, PA HCS,
  "n__v04_642_philadelphia_pa_hcs" VARCHAR  -- (V04) (642) Philadelphia, PA HCS,
  "n__v04_646_pittsburgh_pa_hcs" VARCHAR  -- (V04) (646) Pittsburgh, PA HCS,
  "n__v04_693_wilkes_barre_pa_hcs" VARCHAR  -- (V04) (693) Wilkes-Barre, PA HCS,
  "n__v05_512_baltimore_md_hcs" VARCHAR  -- (V05) (512) Baltimore, MD HCS,
  "n__v05_517_beckley_wv_hcs" VARCHAR  -- (V05) (517) Beckley, WV HCS,
  "n__v05_540_clarksburg_wv_hcs" VARCHAR  -- (V05) (540) Clarksburg, WV HCS,
  "n__v05_581_huntington_wv_hcs" VARCHAR  -- (V05) (581) Huntington, WV HCS,
  "n__v05_613_martinsburg_wv_hcs" VARCHAR  -- (V05) (613) Martinsburg, WV HCS,
  "n__v05_688_washington_dc_hcs" VARCHAR  -- (V05) (688) Washington, DC HCS,
  "n__v06_558_durham_nc_hcs" VARCHAR  -- (V06) (558) Durham, NC HCS,
  "n__v06_565_fayetteville_nc_hcs" VARCHAR  -- (V06) (565) Fayetteville, NC HCS,
  "n__v06_590_hampton_va_hcs" VARCHAR  -- (V06) (590) Hampton, VA HCS,
  "n__v06_637_asheville_nc_hcs" VARCHAR  -- (V06) (637) Asheville, NC HCS,
  "n__v06_652_richmond_va_hcs" VARCHAR  -- (V06) (652) Richmond, VA HCS,
  "n__v06_658_salem_va_hcs" VARCHAR  -- (V06) (658) Salem, VA HCS,
  "n__v06_659_salisbury_nc_hcs" VARCHAR  -- (V06) (659) Salisbury, NC HCS,
  "n__v07_508_atlanta_ga_hcs" VARCHAR  -- (V07) (508) Atlanta, GA HCS,
  "n__v07_509_augusta_ga_hcs" VARCHAR  -- (V07) (509) Augusta, GA HCS,
  "n__v07_521_birmingham_al_hcs" VARCHAR  -- (V07) (521) Birmingham, AL HCS,
  "n__v07_534_charleston_sc_hcs" VARCHAR  -- (V07) (534) Charleston, SC HCS,
  "n__v07_544_columbia_sc_hcs" VARCHAR  -- (V07) (544) Columbia, SC HCS,
  "n__v07_557_dublin_ga_hcs" VARCHAR  -- (V07) (557) Dublin, GA HCS,
  "n__v07_619_central_alabama_hcs" VARCHAR  -- (V07) (619) Central Alabama HCS,
  "n__v07_679_tuscaloosa_al_hcs" VARCHAR  -- (V07) (679) Tuscaloosa, AL HCS,
  "n__v08_516_bay_pines_fl_hcs" VARCHAR  -- (V08) (516) Bay Pines, FL HCS,
  "n__v08_546_miami_fl_hcs" VARCHAR  -- (V08) (546) Miami, FL HCS,
  "n__v08_548_west_palm_beach_fl_hcs" VARCHAR  -- (V08) (548) West Palm Beach, FL HCS,
  "n__v08_573_gainesville_fl_hcs" VARCHAR  -- (V08) (573) Gainesville, FL HCS,
  "n__v08_672_san_juan_pr_hcs" VARCHAR  -- (V08) (672) San Juan, PR HCS,
  "n__v08_673_tampa_fl_hcs" VARCHAR  -- (V08) (673) Tampa, FL HCS,
  "n__v08_675_orlando_fl_hcs" VARCHAR  -- (V08) (675) Orlando, FL HCS,
  "n__v09_596_lexington_ky_hcs" VARCHAR  -- (V09) (596) Lexington, KY HCS,
  "n__v09_603_louisville_ky_hcs" VARCHAR  -- (V09) (603) Louisville, KY HCS,
  "n__v09_614_memphis_tn_hcs" VARCHAR  -- (V09) (614) Memphis, TN HCS,
  "n__v09_621_mountain_home_tn_hcs" VARCHAR  -- (V09) (621) Mountain Home, TN HCS,
  "n__v09_626_middle_tennessee_hcs" VARCHAR  -- (V09) (626) Middle Tennessee HCS,
  "n__v10_506_ann_arbor_mi_hcs" VARCHAR  -- (V10) (506) Ann Arbor, MI HCS,
  "n__v10_515_battle_creek_mi_hcs" VARCHAR  -- (V10) (515) Battle Creek, MI HCS,
  "n__v10_538_chillicothe_oh_hcs" VARCHAR  -- (V10) (538) Chillicothe, OH HCS,
  "n__v10_539_cincinnati_oh_hcs" VARCHAR  -- (V10) (539) Cincinnati, OH HCS,
  "n__v10_541_cleveland_oh_hcs" VARCHAR  -- (V10) (541) Cleveland, OH HCS,
  "n__v10_552_dayton_oh_hcs" VARCHAR  -- (V10) (552) Dayton, OH HCS,
  "n__v10_553_detroit_mi_hcs" VARCHAR  -- (V10) (553) Detroit, MI HCS,
  "n__v10_583_indianapolis_in_hcs" VARCHAR  -- (V10) (583) Indianapolis, IN HCS,
  "n__v10_610_northern_indiana_hcs" VARCHAR  -- (V10) (610) Northern Indiana HCS,
  "n__v10_655_saginaw_mi_hcs" VARCHAR  -- (V10) (655) Saginaw, MI HCS,
  "n__v10_757_columbus_oh_hcs" VARCHAR  -- (V10) (757) Columbus, OH HCS,
  "n__v12_537_chicago_il_hcs" VARCHAR  -- (V12) (537) Chicago, IL HCS,
  "n__v12_550_danville_il_hcs" VARCHAR  -- (V12) (550) Danville, IL HCS,
  "n__v12_556_north_chicago_il_hcs" VARCHAR  -- (V12) (556) North Chicago, IL HCS,
  "n__v12_578_hines_il_hcs" VARCHAR  -- (V12) (578) Hines, IL HCS,
  "n__v12_585_iron_mountain_mi_hcs" VARCHAR  -- (V12) (585) Iron Mountain, MI HCS,
  "n__v12_607_madison_wi_hcs" VARCHAR  -- (V12) (607) Madison, WI HCS,
  "n__v12_676_tomah_wi_hcs" VARCHAR  -- (V12) (676) Tomah, WI HCS,
  "n__v12_695_milwaukee_wi_hcs" VARCHAR  -- (V12) (695) Milwaukee, WI HCS,
  "n__v15_589_kansas_city_mo_hcs" VARCHAR  -- (V15) (589) Kansas City, MO HCS,
  "n__v15_589a4_columbia_mo_hcs" VARCHAR  -- (V15) (589A4) Columbia, MO HCS,
  "n__v15_589a5_eastern_kansas_hcs" VARCHAR  -- (V15) (589A5) Eastern Kansas HCS,
  "n__v15_589a7_wichita_ks_hcs" VARCHAR  -- (V15) (589A7) Wichita, KS HCS,
  "n__v15_657_st_louis_mo_hcs" VARCHAR  -- (V15) (657) St. Louis, MO HCS,
  "n__v15_657a4_poplar_bluff_mo_hcs" VARCHAR  -- (V15) (657A4) Poplar Bluff, MO HCS,
  "n__v15_657a5_marion_il_hcs" VARCHAR  -- (V15) (657A5) Marion, IL HCS,
  "n__v16_502_alexandria_la_hcs" VARCHAR  -- (V16) (502) Alexandria, LA HCS,
  "n__v16_520_gulf_coast_ms_hcs" VARCHAR  -- (V16) (520) Gulf Coast, MS HCS,
  "n__v16_564_fayetteville_ar_hcs" VARCHAR  -- (V16) (564) Fayetteville, AR HCS,
  "n__v16_580_houston_tx_hcs" VARCHAR  -- (V16) (580) Houston, TX HCS,
  "n__v16_586_jackson_ms_hcs" VARCHAR  -- (V16) (586) Jackson, MS HCS,
  "n__v16_598_little_rock_ar_hcs" VARCHAR  -- (V16) (598) Little Rock, AR HCS,
  "n__v16_629_new_orleans_la_hcs" VARCHAR  -- (V16) (629) New Orleans, LA HCS,
  "n__v16_667_shreveport_la_hcs" VARCHAR  -- (V16) (667) Shreveport, LA HCS,
  "n__v17_504_amarillo_tx_hcs" VARCHAR  -- (V17) (504) Amarillo, TX HCS,
  "n__v17_519_big_spring_tx_hcs" VARCHAR  -- (V17) (519) Big Spring, TX HCS,
  "n__v17_549_dallas_tx_hcs" VARCHAR  -- (V17) (549) Dallas, TX HCS,
  "n__v17_671_san_antonio_tx_hcs" VARCHAR  -- (V17) (671) San Antonio, TX HCS,
  "n__v17_674_temple_tx_hcs" VARCHAR  -- (V17) (674) Temple, TX HCS
);