complaint_snapshots: 68
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 68 | 102255097153 | 2026-04-21T22:43:10Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097153 | Street Sweeping Not Done | Street no 3, Venkateshwara Enclave, Chaitanya Vilas Colony, Upperpally | 9701528370 | 2025-02-01T01:45:50Z | Attended By Officer | Ashish | garbage on road-null | AE,,Badangpet | 7995007389 | 102255097153.jpg | {"comments": [{"id": "102255097153", "mobile_number": "9154295265", "posted_by": "Krishna Kishore", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "03-FEB-2025 10:31:09"}, {"id": "102255097153", "mobile_number": "7997951611", "posted_by": "Rajendra Nagar", "remarks": "", "status": "Open", "time_stamp": "01-FEB-2025 07:27:40"}], "grievance": {"assigned_to": "AE,,Badangpet", "complaint_type": "Street Sweeping Not Done", "id": "102255097153", "land_mark": "Street no 3, Venkateshwara Enclave, Chaitanya Vilas Colony, Upperpally", "mobile_number": "9701528370", "officer_remarks": "", "phone_to_call": "7995007389", "photo": "102255097153.jpg", "raised_by": "Ashish", "remarks": "garbage on road-null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 07:15:50"}, "photos": [{"name": "102255097153.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097153.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097153"} | sha256:2e3bb812952c7a6064d30e56d1250a30688f8504cfc57eda55e5637db309a7c0 |