{"disclaimer":"This record shows what TCEQ's public file reported when checked. Confirm delivery decisions against the official record and existing procedures.","facility":{"address":"504 W PINE ST","certificate_expiration_date":"2027-01-31","city":"EDGEWOOD","county":"VAN ZANDT","dated_history_row_count":12,"facility_number":"86765","latest_status_counts":{"OUT OF USE":2},"multi_status_tank_count":2,"owner_name":"BROOKSHIRE GROCERY COMPANY","owner_name_variant_count":1,"owner_names":["BROOKSHIRE GROCERY COMPANY"],"registration_number":"RN107221525","regulated_entity_name":"WALMART EXPRESS 2363","review_required_tank_count":0,"source_row_count":12,"state":"TX","tank_count":2,"tanks":[{"candidate_statuses":["OUT OF USE"],"capacities_gallons":["15000"],"history":[{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-jb6q_w9af.5szk","status":"OUT OF USE","status_date":"2019-06-18"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-w4bx.eb5m_4qq5","status":"IN USE","status_date":"2016-07-21"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-nygj.jt82.9ec6","status":"IN USE","status_date":"2014-08-29"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-u663-6c4v~9krz","status":"IN USE","status_date":"2014-01-01"}],"latest_status":"OUT OF USE","latest_status_date":"2019-06-18","multi_status_history":true,"product_types":["GASOLINE"],"review_required":false,"tank_number":"1"},{"candidate_statuses":["OUT OF USE"],"capacities_gallons":["15000"],"history":[{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"DIESEL","source_row_id":"row-tmuk-mxe5-pjvd","status":"OUT OF USE","status_date":"2019-06-18"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-drsx_c7x5~ic95","status":"OUT OF USE","status_date":"2019-06-18"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"DIESEL","source_row_id":"row-vecs.g5ed_k7tc","status":"IN USE","status_date":"2016-07-21"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-5hj8-8izf.5ac2","status":"IN USE","status_date":"2016-07-21"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"DIESEL","source_row_id":"row-eq2n.8qdy_w7u7","status":"IN USE","status_date":"2014-08-29"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-cxyb.skp9~bqdh","status":"IN USE","status_date":"2014-08-29"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"DIESEL","source_row_id":"row-tgjh~s3rw~wcbf","status":"IN USE","status_date":"2014-01-01"},{"capacity_gallons":"15000","expiration_date":"2027-01-31","product_type":"GASOLINE","source_row_id":"row-962w~88pd~zqt6","status":"IN USE","status_date":"2014-01-01"}],"latest_status":"OUT OF USE","latest_status_date":"2019-06-18","multi_status_history":true,"product_types":["DIESEL","GASOLINE"],"review_required":false,"tank_number":"2"}],"zip_code":"75117","zip_extension":"2944"},"snapshot":{"canonical_sha256":"a1de72c1b28e31e1a68ba631aa47a31451aa979b8cac20aa59e35c737ca993cb","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":16001,"distinct_facility_tank_count":43007,"multi_status_facility_count":1044,"multi_status_pair_count":1431,"resolved_multi_status_pair_count":1430,"retrieved_at_utc":"2026-11-04T21:21:18Z","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-11-04T14:06:44Z","source_url":"https://data.texas.gov/dataset/Texas-Commission-on-Environmental-Quality-Petroleu/jx8f-z4hu","total_facilities_in_snapshot":16001,"total_rows_in_snapshot":69169,"unresolved_latest_tank_status_count":1}}