complaint_snapshots: 5
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5 | 105255241041 | 2026-04-17T05:51:20Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241041 | Selling of Expired food articles | Near by SR colony, | 7075501390 | 2025-04-30T18:55:22Z | Closed | Shashi samha shiva rao | Citizen Complained regarding selling expired food articles and cotamined food at reaturent, Laxmi narasimhas villa, Sr colony, Near by SR colony,Erragadda. | Food Safety Officer,,Charminar | 9032330788 | {"comments": [{"id": "105255241041", "mobile_number": "7993360321", "posted_by": "Smt.Preethi Vennila Palagani", "remarks": "resolved by the respondents", "status": "Closed", "time_stamp": "27-MAY-2025 11:09:21"}, {"id": "105255241041", "mobile_number": "7075501390", "posted_by": "Shashi samha shiva rao", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "01-MAY-2025 07:48:40"}, {"id": "105255241041", "mobile_number": "7075501390", "posted_by": "Shashi samha shiva rao", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-MAY-2025 00:47:18"}], "grievance": {"assigned_to": "Food Safety Officer,,Charminar", "complaint_type": "Selling of Expired food articles", "id": "105255241041", "land_mark": "Near by SR colony,", "mobile_number": "7075501390", "officer_remarks": "", "phone_to_call": "9032330788", "photo": "", "raised_by": "Shashi samha shiva rao", "remarks": "Citizen Complained regarding selling expired food articles and cotamined food at reaturent, Laxmi narasimhas villa, Sr colony, Near by SR colony,Erragadda.", "status": "Closed", "time_stamp": "01-MAY-2025 00:25:22"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241041"} | sha256:c06c6919d76c463266ac5d970f16981c059d80c542945cec06261d6f4bf23a64 |