complaint_snapshots: 99
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 99 | 105255241136 | 2026-04-17T05:52:00Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241136 | Improper Disposal of FecalWaste/septage | Beside Bata Showroom | 9963261344 | 2025-05-01T02:40:36Z | Closed | Anirudh Gupta | Our street in front of Chavala Capitol is overflowing with Drainage water for the last three days. Pls fix it asap | AE,,Falaknuma | 7674919906 | 105255241136.jpg | {"comments": [{"id": "105255241136", "mobile_number": "8125966592", "posted_by": "Dr. K. S. Ravi", "remarks": "This grievance pertains to HMWSSB. Please dail 155313", "status": "Closed", "time_stamp": "01-MAY-2025 11:17:46"}], "grievance": {"assigned_to": "AE,,Falaknuma", "complaint_type": "Improper Disposal of FecalWaste/septage", "id": "105255241136", "land_mark": "Beside Bata Showroom", "mobile_number": "9963261344", "officer_remarks": "", "phone_to_call": "7674919906", "photo": "105255241136.jpg", "raised_by": "Anirudh Gupta", "remarks": "Our street in front of Chavala Capitol is overflowing with Drainage water for the last three days. Pls fix it asap", "status": "Closed", "time_stamp": "01-MAY-2025 08:10:36"}, "photos": [{"name": "105255241136.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241136.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241136"} | sha256:28ce7fe144d6c32a1a22ba5c7ce5408504ed8752288484bce600e30e55b3af7a |