complaint_snapshots: 95
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 95 | 104255188677 | 2026-04-18T08:22:34Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188677 | HMWSSB | Anjaiah Nagar Jagathgiri Gutta | 9701153700 | 2025-04-01T02:38:19Z | Open | John | During recent new road laying manhole cover got damaged. Need a new one. | - | 104255188677.jpg | {"comments": [{"id": "104255188677", "mobile_number": "9701153700", "posted_by": "John", "remarks": "What happened to this complaint, no one addressed this yet, it's been 15 days that manhole is lying without a cover.", "status": "Open", "time_stamp": "06-APR-2025 20:06:33"}, {"id": "104255188677", "mobile_number": "9701153700", "posted_by": "John", "remarks": "Any update on this, no one responded yet. It's causing frequent clogging of water. Moreover, it's a school zone area, small kids travel by that road.", "status": "Open", "time_stamp": "05-APR-2025 08:18:43"}, {"id": "104255188677", "mobile_number": "7337557254", "posted_by": "M Thirupathi", "remarks": "HMWSSB", "status": "Open", "time_stamp": "01-APR-2025 22:05:10"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "104255188677", "land_mark": "Anjaiah Nagar Jagathgiri Gutta", "mobile_number": "9701153700", "officer_remarks": "", "photo": "104255188677.jpg", "raised_by": "John", "remarks": "During recent new road laying manhole cover got damaged. Need a new one.", "status": "Open", "time_stamp": "01-APR-2025 08:08:19"}, "photos": [{"name": "104255188677.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188677.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188677"} | sha256:7c35d620cf077cb88046102484efb85874882ee958193757257fa12837b5c441 |