complaint_snapshots: 44
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | 108255392654 | 2026-04-15T19:21:07Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392654 | Repairs to Road (Pot holes) | sagar lal hopsital lane towards farah hopital lan | 9703553184 | 2025-08-01T00:06:11Z | Attended By Officer | Gadila Prashad | road needs to repair | AE/ENG,,Goshamahal | 9063836132 | 108255392654.jpg p2108255392654.jpg p3108255392654.jpg | {"comments": [{"id": "108255392654", "mobile_number": "9088872227", "posted_by": "Sri K. Chandrasekhar", "remarks": "New cc road will be rectified", "status": "Attended By Officer", "time_stamp": "05-AUG-2025 11:28:41"}], "grievance": {"assigned_to": "AE/ENG,,Goshamahal", "complaint_type": "Repairs to Road (Pot holes)", "id": "108255392654", "land_mark": "sagar lal hopsital lane towards farah hopital lan", "mobile_number": "9703553184", "officer_remarks": "", "phone_to_call": "9063836132", "photo": "108255392654.jpg p2108255392654.jpg p3108255392654.jpg", "raised_by": "Gadila Prashad", "remarks": "road needs to repair", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 05:36:11"}, "photos": [{"name": "108255392654.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392654.jpg"}, {"name": "p2108255392654.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392654.jpg"}, {"name": "p3108255392654.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3108255392654.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392654"} | sha256:11087e0dad1840ce11cb4f3d9252ecb8c2338ccc83acfb0de9eb893c0ef1ac24 |