complaint_snapshots: 85
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 85 | 107255337740 | 2026-04-15T21:46:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337740 | Repairs to Road (Pot holes) | Near SBI Bank Gajraularamaram | 9966657488 | 2025-07-01T01:56:45Z | Submitted for Sanction | VISHNU | Since 2 Weeks ,we have raised multiple complaints ,but no one attended for fill the road poles ,please clear this issues ASAP. | AE/ENG,,Gajularamaram | 7995077953 | 107255337740.jpg | {"comments": [{"id": "107255337740", "mobile_number": "9966657488", "posted_by": "VISHNU", "remarks": "clear", "status": "Submitted for Sanction", "time_stamp": "18-JUL-2025 17:29:07"}, {"id": "107255337740", "mobile_number": "9966657488", "posted_by": "VISHNU", "remarks": "still no one attended for clear this issue pot holes , every going accidents in this area", "status": "Submitted for Sanction", "time_stamp": "07-JUL-2025 11:03:51"}, {"id": "107255337740", "mobile_number": "7995077953", "posted_by": "Sri. Kalyan", "remarks": "under sanction", "status": "Submitted for Sanction", "time_stamp": "02-JUL-2025 08:24:45"}], "grievance": {"assigned_to": "AE/ENG,,Gajularamaram", "complaint_type": "Repairs to Road (Pot holes)", "id": "107255337740", "land_mark": "Near SBI Bank Gajraularamaram", "mobile_number": "9966657488", "officer_remarks": "", "phone_to_call": "7995077953", "photo": "107255337740.jpg", "raised_by": "VISHNU", "remarks": "Since 2 Weeks ,we have raised multiple complaints ,but no one attended for fill the road poles ,please clear this issues ASAP.", "status": "Submitted for Sanction", "time_stamp": "01-JUL-2025 07:26:45"}, "photos": [{"name": "107255337740.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337740.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337740"} | sha256:4bd8281001d642ae9198437f57c856c99de0a6765ff8ad64d48ac2d04b2212c9 |