complaint_snapshots: 53
This data as json
| snapshot_pk | complaint_id | scraped_at | source_url | complaint_type | landmark | mobile_number | grievance_timestamp | status_text | raised_by | remarks | assigned_to | officer_remarks | phone_to_call | grievance_photo_text | raw_payload_json | content_hash |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 104255188635 | 2026-04-18T08:22:29Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188635 | HMWSSB | HMT NAGAR NACHARAM STREET NO 4/A NEAR VENKATESHWAR SAMAY TEMPLE | 8978906006 | 2025-04-01T01:36:38Z | Closed | SIDDIRAMULU | Drain overflow jam | - | p2104255188635.jpg | {"comments": [{"id": "104255188635", "mobile_number": "9948885032", "posted_by": "Sadanand", "remarks": "Call 155313", "status": "Closed", "time_stamp": "13-JUN-2025 14:01:10"}, {"id": "104255188635", "mobile_number": "7331189511", "posted_by": "Kum.M.Keerthi Sri", "remarks": "pertians to hmwssb", "status": "Open", "time_stamp": "04-APR-2025 10:57:18"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "104255188635", "land_mark": "HMT NAGAR NACHARAM STREET NO 4/A NEAR VENKATESHWAR SAMAY TEMPLE", "mobile_number": "8978906006", "officer_remarks": "", "photo": "p2104255188635.jpg", "raised_by": "SIDDIRAMULU", "remarks": "Drain overflow jam", "status": "Closed", "time_stamp": "01-APR-2025 07:06:38"}, "photos": [{"name": "p2104255188635.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2104255188635.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188635"} | sha256:46d66a98bac5281b187b29621ae11e71c48db1e6851a626c9807beff8662da83 |