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 | 102265688267 | 2026-04-12T19:37:08Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688267 | Repairs to Road (Pot holes) | beside Amaravathi towers | 9553367914 | 2026-01-31T19:08:13Z | Attended By Officer | prasad | Road became narrow and getting cars struck | AE/ENG,,Miyapur | 7331189194 | 102265688267.jpg p2102265688267.jpg | {"comments": [{"id": "102265688267", "mobile_number": "7331189194", "posted_by": "Sri.S.Prathap", "remarks": "Dear citizen sorry for the inconvenience caused. Issue will be resolved as early as possible by laying cc road.Thank you", "status": "Attended By Officer", "time_stamp": "17-MAR-2026 16:27:21"}, {"id": "102265688267", "mobile_number": "9063843651", "posted_by": "I.RANI", "remarks": "pertains to engineering department", "status": "Open", "time_stamp": "10-FEB-2026 08:36:33"}], "grievance": {"assigned_to": "AE/ENG,,Miyapur", "complaint_type": "Repairs to Road (Pot holes)", "id": "102265688267", "land_mark": "beside Amaravathi towers", "mobile_number": "9553367914", "officer_remarks": "", "phone_to_call": "7331189194", "photo": "102265688267.jpg p2102265688267.jpg", "raised_by": "prasad", "remarks": "Road became narrow and getting cars struck", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 00:38:13"}, "photos": [{"name": "102265688267.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688267.jpg"}, {"name": "p2102265688267.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688267.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688267"} | sha256:cc757e11e6c377f1101a6cc4c453109a67229593325de895709814d3f0ac41e9 |