complaint_snapshots: 101
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 202265689527 | 2026-04-12T19:56:35Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0202265689527 | Repairs to Road (Pot holes) | black ground park | 8885220000 | 2026-02-01T18:40:19Z | Closed | Syed Abdul Rehman | Respected Sir/MadamAfter recent road repair work in our area construction waste has been left on the road. People are dumping garbage on it leading to stagnant water and mosquito breeding. Kindly arrange immediate clearance of debris and sanitation measures. | AE/ENG,,Tarnaka | 7331151747 | 202265689527.jpg | {"comments": [{"id": "202265689527", "mobile_number": "8885220000", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "18-FEB-2026 15:49:19"}, {"id": "202265689527", "mobile_number": "7331151747", "posted_by": "Sri Ch Venu", "remarks": "online grievance attended", "status": "Attended By Officer", "time_stamp": "17-FEB-2026 16:31:26"}], "grievance": {"assigned_to": "AE/ENG,,Tarnaka", "complaint_type": "Repairs to Road (Pot holes)", "id": "202265689527", "land_mark": "black ground park", "mobile_number": "8885220000", "officer_remarks": "", "phone_to_call": "7331151747", "photo": "202265689527.jpg", "raised_by": "Syed Abdul Rehman", "remarks": "Respected Sir/MadamAfter recent road repair work in our area construction waste has been left on the road. People are dumping garbage on it leading to stagnant water and mosquito breeding. Kindly arrange immediate clearance of debris and sanitation measures.", "status": "Closed", "time_stamp": "02-FEB-2026 00:10:19"}, "photos": [{"name": "202265689527.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/202265689527.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0202265689527"} | sha256:4c12549dc9910cf70dc76bd018619e44f9cacb3159dd635636c23b3a226d62b4 |