complaint_snapshots: 114
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 114 | 105255241150 | 2026-04-17T05:52:07Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241150 | Public Toilet(s) Cleaning | opp Diamond bakery | 7032224866 | 2025-05-01T02:54:48Z | Closed | suresh | drainage leackage | AE,,Narsingi | 8712034424 | 105255241150.jpg | {"comments": [{"id": "105255241150", "mobile_number": "6305471334", "posted_by": "Dr.Mamatha", "remarks": "HMWSSB wing toll free number 155313", "status": "Closed", "time_stamp": "01-MAY-2025 10:56:47"}], "grievance": {"assigned_to": "AE,,Narsingi", "complaint_type": "Public Toilet(s) Cleaning", "id": "105255241150", "land_mark": "opp Diamond bakery", "mobile_number": "7032224866", "officer_remarks": "", "phone_to_call": "8712034424", "photo": "105255241150.jpg", "raised_by": "suresh", "remarks": "drainage leackage", "status": "Closed", "time_stamp": "01-MAY-2025 08:24:48"}, "photos": [{"name": "105255241150.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241150.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241150"} | sha256:f27a9f47b1968459f80b9acc9107a5f790293aeff795c736213fcf633560b50b |