complaint_snapshots: 66
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66 | 105255241101 | 2026-04-17T05:51:46Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241101 | Non Glowing of Street Lights | SPR hills Rajiv Gandhi Nagar | 9032345411 | 2025-05-01T01:55:17Z | Attended By Officer | ketavath Ramesh | street light not working | AE/ENG,,Charminar | 9063816948 | 105255241101.jpg p2105255241101.jpg p3105255241101.jpg | {"comments": [{"id": "105255241101", "mobile_number": "7207923077", "posted_by": "G.Kavitha I/C", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "07-MAY-2025 19:35:38"}], "grievance": {"assigned_to": "AE/ENG,,Charminar", "complaint_type": "Non Glowing of Street Lights", "id": "105255241101", "land_mark": "SPR hills Rajiv Gandhi Nagar", "mobile_number": "9032345411", "officer_remarks": "", "phone_to_call": "9063816948", "photo": "105255241101.jpg p2105255241101.jpg p3105255241101.jpg", "raised_by": "ketavath Ramesh", "remarks": "street light not working", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 07:25:17"}, "photos": [{"name": "105255241101.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241101.jpg"}, {"name": "p2105255241101.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241101.jpg"}, {"name": "p3105255241101.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3105255241101.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241101"} | sha256:cb6ac3b9f8aaf55b9e66cef9480f8455bd8a0944b9111e19de26fa08d072c4a0 |