complaint_snapshots: 79
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 79 | 102265688334 | 2026-04-12T19:38:17Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688334 | Urination in Public/Open Defecation | Ratnadeep supermarket | 9440025486 | 2026-02-01T02:17:22Z | Attended By Officer | Mohammed Burhanuddin | Foul urine smell since last 4 months causing serious inconvenience in breathing especially since the construction of the building is being finished | AE,,Malakpet | 9247540131 | 102265688334.jpg p2102265688334.jpg p3102265688334.jpg | {"comments": [{"id": "102265688334", "mobile_number": "9247540131", "posted_by": "S.Sharath", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "21-FEB-2026 08:39:50"}, {"id": "102265688334", "mobile_number": "9440025486", "posted_by": "Mohammed Burhanuddin", "remarks": "Stink issue still not resolved", "status": "Open", "time_stamp": "18-FEB-2026 17:04:01"}, {"id": "102265688334", "mobile_number": "9440025486", "posted_by": "Mohammed Burhanuddin", "remarks": "Stink issue still not resolved", "status": "Open", "time_stamp": "18-FEB-2026 17:03:17"}, {"id": "102265688334", "mobile_number": "9247540131", "posted_by": "S.Sharath", "remarks": "Spoke with citizen, Complaint is regarding water works please open complaint against to hmwssb", "status": "Attended By Officer", "time_stamp": "12-FEB-2026 08:40:15"}, {"id": "102265688334", "mobile_number": "9440025486", "posted_by": "Mohammed Burhanuddin", "remarks": "The stink is still being felt. Not sure what is wrong but it is causing serious inconvenience in breathing!!!", "status": "Open", "time_stamp": "06-FEB-2026 18:06:19"}, {"id": "102265688334", "mobile_number": "9440025486", "posted_by": "Mohammed Burhanuddin", "remarks": "The stink is still being felt. Not sure what is wrong but it is causing serious inconvenience in breathing!!!", "status": "Open", "time_stamp": "06-FEB-2026 18:05:48"}, {"id": "102265688334", "mobile_number": "9247540131", "posted_by": "S.Sharath", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "06-FEB-2026 14:24:18"}], "grievance": {"assigned_to": "AE,,Malakpet", "complaint_type": "Urination in Public/Open Defecation", "id": "102265688334", "land_mark": "Ratnadeep supermarket", "mobile_number": "9440025486", "officer_remarks": "", "phone_to_call": "9247540131", "photo": "102265688334.jpg p2102265688334.jpg p3102265688334.jpg", "raised_by": "Mohammed Burhanuddin", "remarks": "Foul urine smell since last 4 months causing serious inconvenience in breathing especially since the construction of the building is being finished", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 07:47:22"}, "photos": [{"name": "102265688334.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688334.jpg"}, {"name": "p2102265688334.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688334.jpg"}, {"name": "p3102265688334.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102265688334.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688334"} | sha256:26d2817fd00f5b3088922ec2452214431a8587ad4d81f3ab41cd7be703724584 |