complaint_snapshots: 46
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46 | 106255287941 | 2026-04-16T18:23:31Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287941 | Dumping waste garbage in Nalas | hno. 2-6, bhavani nagar, malkajgiri | 7075238881 | 2025-06-01T00:47:43Z | Closed | ravi kumar | road side drainage block | AE,,Mehdipatnam | 7331189506 | 106255287941.jpg | {"comments": [{"id": "106255287941", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "penteste to HMWS manager forward", "status": "Closed", "time_stamp": "01-JUN-2025 07:21:56"}], "grievance": {"assigned_to": "AE,,Mehdipatnam", "complaint_type": "Dumping waste garbage in Nalas", "id": "106255287941", "land_mark": "hno. 2-6, bhavani nagar, malkajgiri", "mobile_number": "7075238881", "officer_remarks": "", "phone_to_call": "7331189506", "photo": "106255287941.jpg", "raised_by": "ravi kumar", "remarks": "road side drainage block", "status": "Closed", "time_stamp": "01-JUN-2025 06:17:43"}, "photos": [{"name": "106255287941.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287941.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287941"} | sha256:7e663df122886fab99027d0255335477c7f48b88705e658bd6c0d5be41608ec9 |