texas-gov/institutional-medical-billing-services-sv2-detail-tuuc-49gz
Icon for Socrata external plugin
Open repository in Console
 
Readme
Updated 3 months ago
Indexed 1 month ago

Institutional Medical Billing Services (SV2) Detail Information

The Texas Department of Insurance, Division of Workers’ Compensation (DWC) maintains a database of institutional medical billing services (SV2). It contains charges, payments, and treatments billed on a CMS-1450 form (UB-92, UB-04) by hospitals and medical facilities that treat injured employees, excluding ambulatory surgical centers, with dates of service for the last five years. For datasets going back to 2010, see <a href="https://data.texas.gov/dataset/Institutional-Medical-Billing-Services-SV2-Detail-/trqb-ssnn" target="_blank"><u>institutional medical billing services (SV2) detail information – historical</u></a>.

The detail contains information to identify insurance carriers, injured employees, employers, place of service, and diagnostic information. The bill details are individual line items that are grouped in the header section of a single bill. The bill selection date and bill ID must be used to group individual line items into a single bill. Find more information in our <a href="https://www.tdi.texas.gov/wc/information/documents/pudfdictionary2.xlsx" target="_blank"><u>institutional medical billing services (SV2) detail data dictionary</u></a>.

See <a href="https://data.texas.gov/dataset/Institutional-Medical-Billing-Services-SV2-Header-/cmu9-4z9n" target="_blank"><u>institutional medical billing services (SV2) header information</u></a> for the corresponding header records related to this dataset.

Go to our page on <a href="https://www.tdi.texas.gov/wc/information/pudfpricelist.html" target="_blank"><u>DWC medical state reporting public use data file (PUDF)</u></a> to learn more about using this information.

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 \"texas-gov/institutional-medical-billing-services-sv2-detail-tuuc-49gz\".\"institutional_medical_billing_services_sv2_detail\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.

 
Preview
  • institutional_medical_billing_services_sv2_detail
     
     
     
     
     
Upstream Metadata