complaint_snapshots: 100
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 100 | 105255241135 | 2026-04-17T05:52:00Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241135 | Improper Disposal of FecalWaste/septage | Beside Bata Showroom | 9963261344 | 2025-05-01T02:40:01Z | 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 | 105255241135.jpg | {"comments": [{"id": "105255241135", "mobile_number": "8125966592", "posted_by": "Dr. K. S. Ravi", "remarks": "This is pertains to HMWSSB. Please dail 155313.", "status": "Closed", "time_stamp": "01-MAY-2025 11:15:23"}], "grievance": {"assigned_to": "AE,,Falaknuma", "complaint_type": "Improper Disposal of FecalWaste/septage", "id": "105255241135", "land_mark": "Beside Bata Showroom", "mobile_number": "9963261344", "officer_remarks": "", "phone_to_call": "7674919906", "photo": "105255241135.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:01"}, "photos": [{"name": "105255241135.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241135.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241135"} | sha256:cc61513629ac0033ee5beec6e688589e4c8955b28d0a181e03687797bb13a57a |