complaint_snapshots: 84
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 84 | 107255337739 | 2026-04-15T21:46:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337739 | Bulk garbage dumps on roads | Anh apartment bazar ghat | 9666915219 | 2025-07-01T01:55:58Z | Attended By Officer | Akheel | garbage dump on road | AE,,Jangammet | 9063843620 | 107255337739.jpg p2107255337739.jpg p3107255337739.jpg | {"comments": [{"id": "107255337739", "mobile_number": "9063843649", "posted_by": "Dr. Ravinder Goud", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 09:17:30"}], "grievance": {"assigned_to": "AE,,Jangammet", "complaint_type": "Bulk garbage dumps on roads", "id": "107255337739", "land_mark": "Anh apartment bazar ghat", "mobile_number": "9666915219", "officer_remarks": "", "phone_to_call": "9063843620", "photo": "107255337739.jpg p2107255337739.jpg p3107255337739.jpg", "raised_by": "Akheel", "remarks": "garbage dump on road", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 07:25:58"}, "photos": [{"name": "107255337739.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337739.jpg"}, {"name": "p2107255337739.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337739.jpg"}, {"name": "p3107255337739.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3107255337739.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337739"} | sha256:b7cb117a5b0f11d41fb9d4192cf063a358be26bbf219bf81d90951f8bc93b46d |