{
  "$type": "site.standard.document",
  "bskyPostRef": {
    "cid": "bafyreicabzi3ylhkvayzerwqcizx2p2hcopqerx7pqzvnvmyr7vjc2nc44",
    "uri": "at://did:plc:glftha7ciqcqj36aguryfmoz/app.bsky.feed.post/3mlrdc2kk3ju2"
  },
  "coverImage": {
    "$type": "blob",
    "ref": {
      "$link": "bafkreigq2k7xuo66w52nd6yqx5cq4lzhs6tcblhaqarh2k4kr65jo6wtvu"
    },
    "mimeType": "image/png",
    "size": 232012
  },
  "path": "/832847/oc-texas-public-water-systems-water-quality-over-time/",
  "publishedAt": "2026-05-13T20:20:34.000Z",
  "site": "https://www.usluck.com",
  "tags": [
    "Data Is Beautiful"
  ],
  "textContent": "Texas requires nearly 15,000 water systems to send out water quality reports to customers. I grabbed the last ~15 years of them (~225,000 individual Word documents). I extracted and cleaned the data to create this interactive dashboard. Visualization details: 14,903 water systems mapped 2,375 systems with violations 11.6 million people affected Color coding: Green = [...]",
  "title": "[OC] Texas Public Water Systems Water Quality Over Time"
}