complaint_snapshots: 35
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 35 | 112255596122 | 2026-04-13T18:45:40Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596122 | Garbage Dump | Ayan darbar hotel vattepally B | 7569097987 | 2025-12-01T01:34:18Z | Attended By Officer | khatija fatima | garbage | AE,,Nagole | 9154172344 | p2112255596122.jpg | {"comments": [{"id": "112255596122", "mobile_number": "9000100058", "posted_by": "Smt Anuradha", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 07:56:28"}, {"id": "112255596122", "mobile_number": "7995009087", "posted_by": "P.Prashanth", "remarks": "garbage", "status": "Open", "time_stamp": "02-DEC-2025 15:16:51"}, {"id": "112255596122", "mobile_number": "9000100058", "posted_by": "Smt Anuradha", "remarks": "need cap for manhole square", "status": "Open", "time_stamp": "01-DEC-2025 09:00:19"}], "grievance": {"assigned_to": "AE,,Nagole", "complaint_type": "Garbage Dump", "id": "112255596122", "land_mark": "Ayan darbar hotel vattepally B", "mobile_number": "7569097987", "officer_remarks": "", "phone_to_call": "9154172344", "photo": "p2112255596122.jpg", "raised_by": "khatija fatima", "remarks": "garbage", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 07:04:18"}, "photos": [{"name": "p2112255596122.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2112255596122.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0112255596122"} | sha256:4dc08df1d57a4c7cd45a78cca4a59f09f561c0cce42f74f77254920b1dfa95d3 |