complaint_snapshots: 54
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 54 | 102265688309 | 2026-04-12T19:37:51Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688309 | Non Glowing of Street Lights | Dubai gate lane | 7842459814 | 2026-02-01T01:14:07Z | Attended By Officer | sirish | street light blinking | AE/ENG,,Bowenpally | 9700407166 | 102265688309.jpg | {"comments": [{"id": "102265688309", "mobile_number": "9700407166", "posted_by": "Soundarya", "remarks": "carbon problem", "status": "Attended By Officer", "time_stamp": "03-FEB-2026 16:01:00"}], "grievance": {"assigned_to": "AE/ENG,,Bowenpally", "complaint_type": "Non Glowing of Street Lights", "id": "102265688309", "land_mark": "Dubai gate lane", "mobile_number": "7842459814", "officer_remarks": "", "phone_to_call": "9700407166", "photo": "102265688309.jpg", "raised_by": "sirish", "remarks": "street light blinking", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 06:44:07"}, "photos": [{"name": "102265688309.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688309.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688309"} | sha256:1989f40776b9266eba2fa5237b498006731b44994239fd1606130fb1798687fa |