complaint_snapshots: 5
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 103255140302 | 2026-04-21T14:15:24Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140302 | Non Glowing of Street Lights | North kamalanag 4 th cross road | 8639129345 | 2025-02-28T18:44:32Z | Attended By Officer | Sushma | Light is not working and can't walk on that road | AE/ENG,,Keesara | 8712013141 | {"comments": [{"id": "103255140302", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 13:39:13"}, {"id": "103255140302", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "under Process", "status": "Under Process", "time_stamp": "03-MAR-2025 12:10:25"}, {"id": "103255140302", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "2", "status": "Open", "time_stamp": "01-MAR-2025 07:10:37"}], "grievance": {"assigned_to": "AE/ENG,,Keesara", "complaint_type": "Non Glowing of Street Lights", "id": "103255140302", "land_mark": "North kamalanag 4 th cross road", "mobile_number": "8639129345", "officer_remarks": "", "phone_to_call": "8712013141", "photo": "", "raised_by": "Sushma", "remarks": "Light is not working and can't walk on that road", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 00:14:32"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140302"} | sha256:356718cb478bf3b430a5e98856e65e3b1d85a2e17fae64068c341abe38928e4a |