complaint_snapshots: 18
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18 | 110255503088 | 2026-04-15T13:17:22Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503088 | Non Glowing of Street Lights | devendar mansion | 8919013946 | 2025-09-30T20:05:08Z | Closed | p uday kiran | not glowing of street lights | AE/ENG,,Charminar | 9063816948 | 110255503088.jpg p2110255503088.jpg | {"comments": [{"id": "110255503088", "mobile_number": "8919013946", "posted_by": "p uday kiran", "remarks": "Satisfied", "status": "Closed", "time_stamp": "25-OCT-2025 11:48:13"}, {"id": "110255503088", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "09-OCT-2025 19:53:14"}], "grievance": {"assigned_to": "AE/ENG,,Charminar", "complaint_type": "Non Glowing of Street Lights", "id": "110255503088", "land_mark": "devendar mansion", "mobile_number": "8919013946", "officer_remarks": "", "phone_to_call": "9063816948", "photo": "110255503088.jpg p2110255503088.jpg", "raised_by": "p uday kiran", "remarks": "not glowing of street lights", "status": "Closed", "time_stamp": "01-OCT-2025 01:35:08"}, "photos": [{"name": "110255503088.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503088.jpg"}, {"name": "p2110255503088.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503088.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503088"} | sha256:87f939915511a18f1130a220967fbe3486ea4013232220c917555da10e0f817a |