complaint_snapshots: 108
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 108 | 105255241145 | 2026-04-17T05:52:04Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241145 | Public Toilet(s) Blockage | anjani residency, hal colony phase 2, Near Cmr school | 8686041777 | 2025-05-01T02:51:36Z | Closed | AkulaChennaKesava | road drainage got blocked water over flow foul smell | AE,,Narsingi | 8712034424 | 105255241145.jpg p2105255241145.jpg p3105255241145.jpg | {"comments": [{"id": "105255241145", "mobile_number": "6305471334", "posted_by": "Dr.Mamatha", "remarks": "HMWSSB wing toll free number 155313", "status": "Closed", "time_stamp": "01-MAY-2025 10:57:17"}], "grievance": {"assigned_to": "AE,,Narsingi", "complaint_type": "Public Toilet(s) Blockage", "id": "105255241145", "land_mark": "anjani residency, hal colony phase 2, Near Cmr school", "mobile_number": "8686041777", "officer_remarks": "", "phone_to_call": "8712034424", "photo": "105255241145.jpg p2105255241145.jpg p3105255241145.jpg", "raised_by": "AkulaChennaKesava", "remarks": "road drainage got blocked water over flow foul smell", "status": "Closed", "time_stamp": "01-MAY-2025 08:21:36"}, "photos": [{"name": "105255241145.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241145.jpg"}, {"name": "p2105255241145.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241145.jpg"}, {"name": "p3105255241145.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3105255241145.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241145"} | sha256:43ad48967ba0144b74a0fbd194021ffd838b8ab00f577950ba1a039ec7062a74 |