opendata-utah-gov/2014-utah-statelevel-ambulatory-surgery-procedures-xdgg-9vk2
Icon for Socrata external plugin
  •  
    Overview
  •  
    Tables
  •  
    REST API
  •  
    SQL Query
Open repository in Console
 
Readme
Updated 5 years ago
‧
Indexed 6 hours ago

2014 Utah State-Level Ambulatory Surgery Procedures

The 2014 Ambulatory Surgery Database contains data on reportable procedures from all submitting ambulatory surgery facilities in Utah. Facility level information is available on the Office of Health Care Statistics in a downloadable format, http://health.utah.gov/hda/reports/Ambsurg14.xlsx

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"opendata-utah-gov/2014-utah-statelevel-ambulatory-surgery-procedures-xdgg-9vk2\".\"2014_utah_statelevel_ambulatory_surgery_procedures\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • 2014_utah_statelevel_ambulatory_surgery_procedures
     
    Left sidebar is currently unimplemented
     
     
     
     
    Right sidebar is currently unimplemented
Upstream Metadata
NotesNotes2014 CHANGES: Previously, the Ambulatory Surgery Report contained the top 20 CPT-4 and ICD-9 procedures performed statewide. The 2014 Ambulatory Surgery Report contains all reportable procedures as defined within the attached document. Reported Enhanced Ambulatory Patient Groups (EAPGs) were also expanded in the 2014 report; previous reports included the first 13 EAPG categories while the 2014 report contains all EAPG categories. The EAPG categories were generated using 3M Core Grouping Software for Windows (Version 2015.2.3). Wallingford, CT, 3M Health Information Systems, July 2015.
MicrositesMicrositesDepartment of Health
DisclaimersDisclaimerSlight changes to data processing were made; for primary payer, there is no longer a separate “Unknown” category. Payer category 09 now represents Charity, Unclassified, and Unknown payers. The “Managed Care” category (category 06) contains only payers with “Managed Care” in the payer field; managed care may be commercial. However, all plans with commercial carrier names were grouped in “Other Commercial” if they are not Blue Cross/Blue Shield. Mastectomy procedural codes changed in 2007, and the appropriate CPT-4 codes (19300-19307) were used to create the mastectomy procedure category beginning in 2014. However, the data requested in the submission manual only included 19120-19220 so the procedure category variable should be used with caution and in conjunction with procedure codes to ensure accuracy.
Dataset SummaryCoverageUtahGranularityStateTime Period2014OrganizationUtah Department of Health, Office of Health Care StatisiticsDataset OwnerOffice of Health Care StatisticsData FrequencyAnnualPosting FrequencyAnnualContact Informationhealthcarestat@utah.gov
Dataset InformationAgencyHealth

About

2014 Utah State-Level Ambulatory Surgery Procedures
5 years ago (updated)
6 hours ago (indexed)
Loading...

Topics

  • ambsurg
  • ambulatory surgery
  • cpt-4
  • icd9
  • reportable procedures

Sources

  • lsavoie - 2014 Utah State-Level Ambulatory Surgery Procedures
  • Utah Department of Health, Office of Health Care Statistics (creator)

License

No license available.