Emergency Services Billing Rates - ZIPs

The Texas Department of Insurance (TDI) collects and reports information about billing rates for emergency service providers within political subdivisions as reported by those political subdivisions. The Zone Improvement Plan (ZIP) code is a unique seven-digit identification number for postal delivery in the United States. This dataset relates political subdivisions and ZIP codes they contain by year and quarter. There is a row for each ZIP code within a political subdivision. Subdivisions containing more than one ZIP code or providers operating in more than one subdivision will be listed in multiple rows. The data includes the year and quarter the information applies to as well as the date the political subdivision submitted their report.

The Texas Legislature amended <a href="https://statutes.capitol.texas.gov/Docs/IN/htm/IN.38.htm" target="_blank"><u>Texas Insurance Code Chapter 38</u></a> via <a href="https://capitol.texas.gov/tlodocs/88R/billtext/html/SB02476F.htm" target="_blank"><u>Senate Bill 2476</u></a> during the 88th session to add reporting “relating to consumer protections against certain medical and health care billing by emergency medical services providers. A political subdivision may submit to the department a rate set, controlled, or regulated by the political subdivision for emergency services.”

► For contact information, refer to dataset:  <a href="https://data.texas.gov/dataset/Emergency-Services-Billing-Rates-Contact-List/xgca-u3qh" target="_blank"><u>Emergency Services Billing Rates - Contact List</u></a>.

► For procedure codes rates, refer to dataset:  <a href="https://data.texas.gov/dataset/Emergency-Services-Billing-Rates-Code-Rates/ipyh-z9mx" target="_blank"><u>Emergency Services Billing Rates - Code Rates</u></a>.

► For National Provider Identifier Standard (NPI) information reported in each political subdivision, refer to dataset: <a href="https://data.texas.gov/dataset/Emergency-Services-Billing-Rates-NPIs/w2yx-y2ra" target="_blank"><u>Emergency Services Billing Rates - NPI</u></a>.

Users are responsible for reviewing and updating data before the submission deadlines. Information entered or found in this dataset is subject to change. Visit <a href="https://www.tdi.texas.gov/general/disclaim.html" target="_blank"><u>TDI’s web site disclaimer</u></a> for more information.

For more information related to this data, visit <a href="https://www.tdi.texas.gov/health/esbindex.html" target="_blank"><u>TDI’s FAQ page</u></a>.

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/emergency-services-billing-rates-zips-iyci-uypg\".\"emergency_services_billing_rates_zips\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.