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

1.93 MB
14637 rows
142 columns


CREATE TABLE table_1 (
  "cpt_display" VARCHAR,
  "national" VARCHAR,
  "n__v01_402_togus_me_hcs" VARCHAR,
  "n__v01_405_white_river_junction_vt_hcs" VARCHAR,
  "n__v01_518_bedford_ma_hcs" VARCHAR,
  "n__v01_523_boston_ma_hcs" VARCHAR,
  "n__v01_608_manchester_nh_hcs" VARCHAR,
  "n__v01_631_central_western_massachusetts_hcs" VARCHAR,
  "n__v01_650_providence_ri_hcs" VARCHAR,
  "n__v01_689_connecticut_hcs" VARCHAR,
  "n__v02_526_bronx_ny_hcs" VARCHAR,
  "n__v02_528_western_new_york_hcs" VARCHAR,
  "n__v02_528a6_finger_lakes_ny_hcs" VARCHAR,
  "n__v02_528a7_syracuse_ny_hcs" VARCHAR,
  "n__v02_528a8_albany_ny_hcs" VARCHAR,
  "n__v02_561_new_jersey_hcs" VARCHAR,
  "n__v02_620_hudson_valley_ny_hcs" VARCHAR,
  "n__v02_630_new_york_harbor_hcs" VARCHAR,
  "n__v02_632_northport_ny_hcs" VARCHAR,
  "n__v04_460_wilmington_de_hcs" VARCHAR,
  "n__v04_503_altoona_pa_hcs" VARCHAR,
  "n__v04_529_butler_pa_hcs" VARCHAR,
  "n__v04_542_coatesville_pa_hcs" VARCHAR,
  "n__v04_562_erie_pa_hcs" VARCHAR,
  "n__v04_595_lebanon_pa_hcs" VARCHAR,
  "n__v04_642_philadelphia_pa_hcs" VARCHAR,
  "n__v04_646_pittsburgh_pa_hcs" VARCHAR,
  "n__v04_693_wilkes_barre_pa_hcs" VARCHAR,
  "n__v05_512_baltimore_md_hcs" VARCHAR,
  "n__v05_517_beckley_wv_hcs" VARCHAR,
  "n__v05_540_clarksburg_wv_hcs" VARCHAR,
  "n__v05_581_huntington_wv_hcs" VARCHAR,
  "n__v05_613_martinsburg_wv_hcs" VARCHAR,
  "n__v05_688_washington_dc_hcs" VARCHAR,
  "n__v06_558_durham_nc_hcs" VARCHAR,
  "n__v06_565_fayetteville_nc_hcs" VARCHAR,
  "n__v06_590_hampton_va_hcs" VARCHAR,
  "n__v06_637_asheville_nc_hcs" VARCHAR,
  "n__v06_652_richmond_va_hcs" VARCHAR,
  "n__v06_658_salem_va_hcs" VARCHAR,
  "n__v06_659_salisbury_nc_hcs" VARCHAR,
  "n__v07_508_atlanta_ga_hcs" VARCHAR,
  "n__v07_509_augusta_ga_hcs" VARCHAR,
  "n__v07_521_birmingham_al_hcs" VARCHAR,
  "n__v07_534_charleston_sc_hcs" VARCHAR,
  "n__v07_544_columbia_sc_hcs" VARCHAR,
  "n__v07_557_dublin_ga_hcs" VARCHAR,
  "n__v07_619_central_alabama_hcs" VARCHAR,
  "n__v07_679_tuscaloosa_al_hcs" VARCHAR,
  "n__v08_516_bay_pines_fl_hcs" VARCHAR,
  "n__v08_546_miami_fl_hcs" VARCHAR,
  "n__v08_548_west_palm_beach_fl_hcs" VARCHAR,
  "n__v08_573_gainesville_fl_hcs" VARCHAR,
  "n__v08_672_san_juan_pr_hcs" VARCHAR,
  "n__v08_673_tampa_fl_hcs" VARCHAR,
  "n__v08_675_orlando_fl_hcs" VARCHAR,
  "n__v09_596_lexington_ky_hcs" VARCHAR,
  "n__v09_603_louisville_ky_hcs" VARCHAR,
  "n__v09_614_memphis_tn_hcs" VARCHAR,
  "n__v09_621_mountain_home_tn_hcs" VARCHAR,
  "n__v09_626_middle_tennessee_hcs" VARCHAR,
  "n__v10_506_ann_arbor_mi_hcs" VARCHAR,
  "n__v10_515_battle_creek_mi_hcs" VARCHAR,
  "n__v10_538_chillicothe_oh_hcs" VARCHAR,
  "n__v10_539_cincinnati_oh_hcs" VARCHAR,
  "n__v10_541_cleveland_oh_hcs" VARCHAR,
  "n__v10_552_dayton_oh_hcs" VARCHAR,
  "n__v10_553_detroit_mi_hcs" VARCHAR,
  "n__v10_583_indianapolis_in_hcs" VARCHAR,
  "n__v10_610_northern_indiana_hcs" VARCHAR,
  "n__v10_655_saginaw_mi_hcs" VARCHAR,
  "n__v10_757_columbus_oh_hcs" VARCHAR,
  "n__v12_537_chicago_il_hcs" VARCHAR,
  "n__v12_550_danville_il_hcs" VARCHAR,
  "n__v12_556_north_chicago_il_hcs" VARCHAR,
  "n__v12_578_hines_il_hcs" VARCHAR,
  "n__v12_585_iron_mountain_mi_hcs" VARCHAR,
  "n__v12_607_madison_wi_hcs" VARCHAR,
  "n__v12_676_tomah_wi_hcs" VARCHAR,
  "n__v12_695_milwaukee_wi_hcs" VARCHAR,
  "n__v15_589_kansas_city_mo_hcs" VARCHAR,
  "n__v15_589a4_columbia_mo_hcs" VARCHAR,
  "n__v15_589a5_eastern_kansas_hcs" VARCHAR,
  "n__v15_589a7_wichita_ks_hcs" VARCHAR,
  "n__v15_657_st_louis_mo_hcs" VARCHAR,
  "n__v15_657a4_poplar_bluff_mo_hcs" VARCHAR,
  "n__v15_657a5_marion_il_hcs" VARCHAR,
  "n__v16_502_alexandria_la_hcs" VARCHAR,
  "n__v16_520_gulf_coast_ms_hcs" VARCHAR,
  "n__v16_564_fayetteville_ar_hcs" VARCHAR,
  "n__v16_580_houston_tx_hcs" VARCHAR,
  "n__v16_586_jackson_ms_hcs" VARCHAR,
  "n__v16_598_little_rock_ar_hcs" VARCHAR,
  "n__v16_629_new_orleans_la_hcs" VARCHAR,
  "n__v16_667_shreveport_la_hcs" VARCHAR,
  "n__v17_504_amarillo_tx_hcs" VARCHAR,
  "n__v17_519_big_spring_tx_hcs" VARCHAR,
  "n__v17_549_dallas_tx_hcs" VARCHAR,
  "n__v17_671_san_antonio_tx_hcs" VARCHAR,
  "n__v17_674_temple_tx_hcs" VARCHAR
);