complaint_snapshots: 105
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 105 | 105255241141 | 2026-04-17T05:52:02Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241141 | Non Glowing of Street Lights | opposite to sai shah sadan | 9550129099 | 2025-05-01T02:47:13Z | Attended By Officer | Suresh Babu Anjuru | Street lights not glowing in while colony | AEE/ENG,,Bahadurpura | 9989211406 | 105255241141.jpg | {"comments": [{"id": "105255241141", "mobile_number": "9154960548", "posted_by": "Smt.N.Lakshmi Priya I/C", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "17-MAY-2025 16:09:36"}, {"id": "105255241141", "mobile_number": "9154369439", "posted_by": "G Likhitha", "remarks": "Chanda nagar", "status": "Open", "time_stamp": "17-MAY-2025 08:01:06"}, {"id": "105255241141", "mobile_number": "9154960548", "posted_by": "Smt.N.Lakshmi Priya I/C", "remarks": "Transfar", "status": "Open", "time_stamp": "06-MAY-2025 22:59:30"}], "grievance": {"assigned_to": "AEE/ENG,,Bahadurpura", "complaint_type": "Non Glowing of Street Lights", "id": "105255241141", "land_mark": "opposite to sai shah sadan", "mobile_number": "9550129099", "officer_remarks": "", "phone_to_call": "9989211406", "photo": "105255241141.jpg", "raised_by": "Suresh Babu Anjuru", "remarks": "Street lights not glowing in while colony", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 08:17:13"}, "photos": [{"name": "105255241141.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241141.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241141"} | sha256:bd90292ef4e1d75424b07cf900a1a0d17a9ec68e5e99f3fb84ff0d8d841e5ac4 |