complaint_snapshots: 80
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 80 | 102265688335 | 2026-04-12T19:38:18Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688335 | Dustbin Not Cleared | raj nagar colony | 9866274970 | 2026-02-01T02:19:13Z | Attended By Officer | venkata prasad sharma | since 10 days garbage was not lifting | AE,,Uppal | 8712034413 | 102265688335.jpg | {"comments": [{"id": "102265688335", "mobile_number": "8712034413", "posted_by": "J. Pushpalatha", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "11-FEB-2026 09:52:39"}], "grievance": {"assigned_to": "AE,,Uppal", "complaint_type": "Dustbin Not Cleared", "id": "102265688335", "land_mark": "raj nagar colony", "mobile_number": "9866274970", "officer_remarks": "", "phone_to_call": "8712034413", "photo": "102265688335.jpg", "raised_by": "venkata prasad sharma", "remarks": "since 10 days garbage was not lifting", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 07:49:13"}, "photos": [{"name": "102265688335.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688335.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688335"} | sha256:09a6347e827560100cd8193d08a3c348df26dbf161ae1ba0ee06c5e8f33dd6c4 |