complaint_snapshots: 65
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 65 | 111255552216 | 2026-04-15T10:59:15Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552216 | Garbage Dump | behind ICICI Bank | 9703203699 | 2025-11-01T01:55:12Z | Closed | Nandeswara Rao | Garbage Dump | AE,,Falaknuma | 7674919906 | 111255552216.jpg p2111255552216.jpg | {"comments": [{"id": "111255552216", "mobile_number": "9703203699", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "16-NOV-2025 14:42:25"}, {"id": "111255552216", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "05-NOV-2025 09:43:44"}, {"id": "111255552216", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "garbage", "status": "Open", "time_stamp": "01-NOV-2025 08:34:39"}], "grievance": {"assigned_to": "AE,,Falaknuma", "complaint_type": "Garbage Dump", "id": "111255552216", "land_mark": "behind ICICI Bank", "mobile_number": "9703203699", "officer_remarks": "", "phone_to_call": "7674919906", "photo": "111255552216.jpg p2111255552216.jpg", "raised_by": "Nandeswara Rao", "remarks": "Garbage Dump", "status": "Closed", "time_stamp": "01-NOV-2025 07:25:12"}, "photos": [{"name": "111255552216.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552216.jpg"}, {"name": "p2111255552216.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552216.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552216"} | sha256:7c5fe44a04f8ca3664455b0d7ee8e4c8d1a47a6ed36fd4d6407e4cbcc8b6118f |