{"disclaimer":"This record shows what TCEQ's public file reported when checked. Confirm delivery decisions against the official record and existing procedures.","facility":{"address":"100 JAPHET ST","certificate_expiration_date":"2026-09-30","city":"HOUSTON","county":"HARRIS","dated_history_row_count":13,"facility_number":"33524","latest_status_counts":{"IN USE":9},"multi_status_tank_count":2,"owner_name":"CITY OF HOUSTON","owner_name_variant_count":1,"owner_names":["CITY OF HOUSTON"],"registration_number":"RN101948875","regulated_entity_name":"CITY OF HOUSTON PUBLIC UTILITIES & WASTEWATER T P","review_required_tank_count":0,"source_row_count":13,"state":"TX","tank_count":9,"tanks":[{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"","source_row_id":"row-ew6r.4xyx.xu8q","status":"IN USE","status_date":"1980-01-01"}],"latest_status":"IN USE","latest_status_date":"1980-01-01","multi_status_history":false,"product_types":[],"review_required":false,"tank_number":"1"},{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"","source_row_id":"row-7cdq~utwu-3pct","status":"IN USE","status_date":"1980-01-01"}],"latest_status":"IN USE","latest_status_date":"1980-01-01","multi_status_history":false,"product_types":[],"review_required":false,"tank_number":"2"},{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"","source_row_id":"row-5bfu.yce9~ebm3","status":"IN USE","status_date":"1980-01-01"}],"latest_status":"IN USE","latest_status_date":"1980-01-01","multi_status_history":false,"product_types":[],"review_required":false,"tank_number":"3"},{"candidate_statuses":["IN USE"],"capacities_gallons":["10000"],"history":[{"capacity_gallons":"10000","expiration_date":"2026-09-30","product_type":"EMPTY","source_row_id":"row-6mi4_m7ue_27s2","status":"IN USE","status_date":"2010-04-28"}],"latest_status":"IN USE","latest_status_date":"2010-04-28","multi_status_history":false,"product_types":["EMPTY"],"review_required":false,"tank_number":"5"},{"candidate_statuses":["IN USE"],"capacities_gallons":["10000"],"history":[{"capacity_gallons":"10000","expiration_date":"2026-09-30","product_type":"EMPTY","source_row_id":"row-und4_eigv_kibw","status":"IN USE","status_date":"2010-04-28"}],"latest_status":"IN USE","latest_status_date":"2010-04-28","multi_status_history":false,"product_types":["EMPTY"],"review_required":false,"tank_number":"6"},{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"GASOLINE","source_row_id":"row-du6x-femx~p2qz","status":"IN USE","status_date":"2017-04-16"},{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"GASOLINE","source_row_id":"row-be7p-nbv6.jgj8","status":"OUT OF USE","status_date":"2008-12-30"}],"latest_status":"IN USE","latest_status_date":"2017-04-16","multi_status_history":true,"product_types":["GASOLINE"],"review_required":false,"tank_number":"7"},{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"GASOLINE","source_row_id":"row-eyph~zb8h.phzk","status":"IN USE","status_date":"2017-04-16"},{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"GASOLINE","source_row_id":"row-2cm6~m9uj-zcew","status":"OUT OF USE","status_date":"2012-06-18"}],"latest_status":"IN USE","latest_status_date":"2017-04-16","multi_status_history":true,"product_types":["GASOLINE"],"review_required":false,"tank_number":"8"},{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"DIESEL","source_row_id":"row-jqa9.m4vz.a6jx","status":"IN USE","status_date":"2017-04-16"},{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"DIESEL","source_row_id":"row-pv2b_ctpa.2e8d","status":"IN USE","status_date":"2002-09-01"}],"latest_status":"IN USE","latest_status_date":"2017-04-16","multi_status_history":false,"product_types":["DIESEL"],"review_required":false,"tank_number":"9"},{"candidate_statuses":["IN USE"],"capacities_gallons":["25000"],"history":[{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"DIESEL","source_row_id":"row-c46y.ttnj.6udt","status":"IN USE","status_date":"2017-04-16"},{"capacity_gallons":"25000","expiration_date":"2026-09-30","product_type":"DIESEL","source_row_id":"row-bkah~s4u9~wccd","status":"IN USE","status_date":"2002-09-01"}],"latest_status":"IN USE","latest_status_date":"2017-04-16","multi_status_history":false,"product_types":["DIESEL"],"review_required":false,"tank_number":"10"}],"zip_code":"77020","zip_extension":"7823"},"snapshot":{"canonical_sha256":"b106cddba0cb8568b117bdb92a27ba9d297c2ba4b7954f0b818998c6abda4d44","canonicalization_version":"1","cohort_size":250,"directory_selection_rule":"Every facility in the accepted snapshot. Latest tank status is resolved by dated source history; tied or undated latest records remain marked review required.","directory_size":16110,"distinct_facility_tank_count":43217,"multi_status_facility_count":1028,"multi_status_pair_count":1406,"resolved_multi_status_pair_count":1405,"retrieved_at_utc":"2026-09-15T19:02:34Z","selection_rule":"Facilities with at least one tank represented by more than one recorded status and no unresolved latest-date conflict; ordered by multi-status tank count, dated history row count, then numeric facility number.","source_last_updated_utc":"2026-09-15T13:03:39Z","source_url":"https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Petroleu/jx8f-z4hu","total_facilities_in_snapshot":16110,"total_rows_in_snapshot":69240,"unresolved_latest_tank_status_count":1}}