complaint_snapshots: 11
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 102265688266 | 2026-04-12T19:37:07Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688266 | Footpath Blocked | Al Safa Restaurant, Golden heights | 9700302191 | 2026-01-31T19:07:38Z | Open | Ali | Footpath blocked | ACP,,Masab Tank | 9949994037 | 102265688266.jpg p2102265688266.jpg p3102265688266.jpg | {"comments": [{"id": "102265688266", "mobile_number": "9700302191", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "01-APR-2026 15:03:18"}, {"id": "102265688266", "mobile_number": "9949994037", "posted_by": "P.BALANANDA SWAMY", "remarks": "It is to inform you that the special drive for removal of footpath/road encroachment program will be conducted soon with the help of traffic police", "status": "Attended By Officer", "time_stamp": "30-MAR-2026 08:06:45"}], "grievance": {"assigned_to": "ACP,,Masab Tank", "complaint_type": "Footpath Blocked", "id": "102265688266", "land_mark": "Al Safa Restaurant, Golden heights", "mobile_number": "9700302191", "officer_remarks": "", "phone_to_call": "9949994037", "photo": "102265688266.jpg p2102265688266.jpg p3102265688266.jpg", "raised_by": "Ali", "remarks": "Footpath blocked", "status": "Open", "time_stamp": "01-FEB-2026 00:37:38"}, "photos": [{"name": "102265688266.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688266.jpg"}, {"name": "p2102265688266.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688266.jpg"}, {"name": "p3102265688266.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102265688266.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688266"} | sha256:60a1feafb1fb5d4d1add3a862d4ed5dadf2b0b9d93d2964b06c012fbdb4b74cd |