complaint_snapshots: 43
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 43 | 112255596130 | 2026-04-13T18:45:41Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596130 | Garbage Dump | san | 7097056708 | 2025-12-01T01:58:10Z | Closed | naresh | person not tacking garbage they telling this is not my area just one building diffrence | AE,,Charminar | 9063816946 | 112255596130.jpg p2112255596130.jpg p3112255596130.jpg | {"comments": [{"id": "112255596130", "mobile_number": "7097056708", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 14:37:56"}, {"id": "112255596130", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 10:19:59"}], "grievance": {"assigned_to": "AE,,Charminar", "complaint_type": "Garbage Dump", "id": "112255596130", "land_mark": "san", "mobile_number": "7097056708", "officer_remarks": "", "phone_to_call": "9063816946", "photo": "112255596130.jpg p2112255596130.jpg p3112255596130.jpg", "raised_by": "naresh", "remarks": "person not tacking garbage they telling this is not my area just one building diffrence", "status": "Closed", "time_stamp": "01-DEC-2025 07:28:10"}, "photos": [{"name": "112255596130.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/112255596130.jpg"}, {"name": "p2112255596130.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596130.jpg"}, {"name": "p3112255596130.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3112255596130.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596130"} | sha256:433fb8e1995ec2d56f83cdf500432268de51366a4b0688f5029633e98fa5d8b9 |