← Back to all datasets
heart Health πŸ›οΈ Houston Public Health stale

Houston Restaurant Inspections

Food establishment inspection scores and violations from Houston Public Health.

πŸ—‚οΈ
300
Records
🚩
20
Red flags
βœ…
80
Quality score
πŸ”„
weekly
Update frequency

Data Detective

Tip

Scan the map for red dots and check the chart for spikes. Big jumps or drops are usually where the interesting questions live.

Source: The numbers above come straight from Houston Open Data.

πŸ“ Data quality breakdown

How healthy is this dataset across five dimensions?

Completeness 94/100
Freshness 15/100
Location 99/100
Consistency 95/100
Usefulness 100/100

πŸ—ΊοΈ Where the data lives

Up to 300 geolocated records. Red markers are flagged values.

πŸ“ˆ Activity over time

Record volume by month, or by status when no dates exist.

🚩 Open red flags

Suspicious values our scanner caught β€” see if you agree.

🚩 High · future date
95% sure

This record is dated in the future.

occurred_at 2026-07-13
A 311 request can't be created next year. A future date usually means someone typed the date wrong or a computer formatted it incorrectly.

Next step: Check for a typo or a time-zone/format bug at the source.

Houston Restaurant Inspections Source β†—
🚩 High · future date
95% sure

This record is dated in the future.

occurred_at 2026-08-18
A 311 request can't be created next year. A future date usually means someone typed the date wrong or a computer formatted it incorrectly.

Next step: Check for a typo or a time-zone/format bug at the source.

Houston Restaurant Inspections Source β†—
🚩 High · future date
95% sure

This record is dated in the future.

occurred_at 2026-07-12
A 311 request can't be created next year. A future date usually means someone typed the date wrong or a computer formatted it incorrectly.

Next step: Check for a typo or a time-zone/format bug at the source.

Houston Restaurant Inspections Source β†—
🚩 High · impossible negative
85% sure

A count or amount is negative where that should be impossible.

numeric_value -70
You can't have negative days to fix a pothole, or negative permits. A negative number here is a sign of a data-entry or calculation mistake.

Next step: Confirm whether negatives represent refunds/corrections or are simply errors.

Houston Restaurant Inspections Source β†—
🚩 High · impossible negative
85% sure

A count or amount is negative where that should be impossible.

numeric_value -92
You can't have negative days to fix a pothole, or negative permits. A negative number here is a sign of a data-entry or calculation mistake.

Next step: Confirm whether negatives represent refunds/corrections or are simply errors.

Houston Restaurant Inspections Source β†—
🚩 High · impossible negative
85% sure

A count or amount is negative where that should be impossible.

numeric_value -60
You can't have negative days to fix a pothole, or negative permits. A negative number here is a sign of a data-entry or calculation mistake.

Next step: Confirm whether negatives represent refunds/corrections or are simply errors.

Houston Restaurant Inspections Source β†—
🚩 High · stale dataset
80% sure

Expected updates every weekly, but it has been 117 days, 12 hours.

last_source_update 2026-02-21
A dataset that's supposed to refresh weekly but hasn't in 117 days, 12 hours is like a bus schedule nobody updated β€” you can't trust it to reflect what's happening now.

Next step: Ask the department whether updates stopped or moved elsewhere.

Houston Restaurant Inspections Source β†—
🚩 Medium · missing value
90% sure

The field "reported_by" is empty in 33% of records.

reported_by 33% empty
Think of a class roster where most students never filled in their phone number. If "reported_by" is blank 33% of the time, we can't trust any total or map that depends on it.

Next step: Ask the owning department why this field is so often blank.

Houston Restaurant Inspections Source β†—

⚠️ Known issues

  • β€’Scores missing for some inspections
  • β€’Addresses not always geocoded

πŸ’‘ Public use cases

  • β€’Check restaurant safety
  • β€’Find repeat violators
  • β€’Compare scores by area

πŸ“ Geo fields

latitude longitude zip

πŸ•’ Time fields

inspection_date

Records: 300

Update frequency: weekly

Last imported: 1 hour ago

Search the Houston Open Data catalog β†—