complaint_snapshots: 12
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12 | 105255241049 | 2026-04-17T05:51:23Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241049 | Non Glowing of Street Lights | Mithilanagar | 9923785833 | 2025-04-30T20:03:07Z | Closed | Ramu | street lights not working | AE/ENG,,Narsingi | 7994322365 | 105255241049.jpg | {"comments": [{"id": "105255241049", "mobile_number": "9923785833", "posted_by": "Ramu", "remarks": "-", "status": "Closed", "time_stamp": "22-MAY-2025 02:52:10"}, {"id": "105255241049", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "compalaint is clear", "status": "Attended By Officer", "time_stamp": "14-MAY-2025 15:27:42"}], "grievance": {"assigned_to": "AE/ENG,,Narsingi", "complaint_type": "Non Glowing of Street Lights", "id": "105255241049", "land_mark": "Mithilanagar", "mobile_number": "9923785833", "officer_remarks": "", "phone_to_call": "7994322365", "photo": "105255241049.jpg", "raised_by": "Ramu", "remarks": "street lights not working", "status": "Closed", "time_stamp": "01-MAY-2025 01:33:07"}, "photos": [{"name": "105255241049.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241049.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241049"} | sha256:a2607e62b20fee5a248cf84f3019d233d5402270010976b8c957976886ad7706 |