Emergency Services Billing Rates - NPIs

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 National Provider Identifier Standard (NPI) is a unique ten-digit identification number for covered health care providers. This dataset relates emergency service providers by NPI with the political subdivisions where they operate by year and quarter. There is a row for each emergency service provider operating within a political subdivision. Subdivisions with more than one provider operating in them 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 ZIP codes within political subdivisions, refer to dataset:  <a href="https://data.texas.gov/dataset/Emergency-Services-Billing-Rates-ZIPs/iyci-uypg" target="_blank"><u>Emergency Services Billing Rates - ZIPs</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-npis-w2yx-y2ra\".\"emergency_services_billing_rates_npis\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.