Debugging public data - county codes in Texas

If you sort a list of Texas counties by county name, the counties will not be in order by county number. Texas Center for Healthcare Statistics Every county in the United States has a FIPS code. These standards codes are usful for mapping and joining additional datasets. Texas state agencies do not bother with these FIPS codes. Instead, each state agency publishes data using their own county codes. The county codes of one state agency may not match other agencies’ county codes. I recently spent a few hours extremely confused by this, because I used the formula published by the Texas Department of State Health Services on data published by the Texas Health and Human Services, resulting in incorrect data. ...

May 16, 2025

SNAP State Performance Indicators Datasets

I started to post SNAP performance indicators from the USDA in machine-readable format, aggregating and cleaning the data from the many PDF tables. This repository includes quick-access to cleaned, FIPS-linked CSV long-format tables of yearly state reported indicators for Application Processing Timeliness, Program Error Rates, and Case and Procedural Error Rates (coming soon). USDA Descriptions as follows: Application Processing Timeliness “measures the timeliness of states’ processing of initial SNAP applications. The Food and Nutrition Act of 2008 entitles all eligible households to SNAP benefits within 30 days of application, or within 7 days, if they are eligible for expedited service.” ...

February 21, 2024