complaint_snapshots: 66
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 66 | 111255552218 | 2026-04-15T10:59:15Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552218 | Non Glowing of Street Lights | dr reddy colony has godown lane | 9390483085 | 2025-11-01T01:56:28Z | Closed | Praveena | streetlight not working | AEE/ENG,,Bahadurpura | 9989211406 | 111255552218.jpg p2111255552218.jpg p3111255552218.jpg | {"comments": [{"id": "111255552218", "mobile_number": "9390483085", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "11-NOV-2025 15:17:45"}, {"id": "111255552218", "mobile_number": "9666411132", "posted_by": "Smt Lakshmi Priya", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "03-NOV-2025 18:30:25"}], "grievance": {"assigned_to": "AEE/ENG,,Bahadurpura", "complaint_type": "Non Glowing of Street Lights", "id": "111255552218", "land_mark": "dr reddy colony has godown lane", "mobile_number": "9390483085", "officer_remarks": "", "phone_to_call": "9989211406", "photo": "111255552218.jpg p2111255552218.jpg p3111255552218.jpg", "raised_by": "Praveena", "remarks": "streetlight not working", "status": "Closed", "time_stamp": "01-NOV-2025 07:26:28"}, "photos": [{"name": "111255552218.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552218.jpg"}, {"name": "p2111255552218.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552218.jpg"}, {"name": "p3111255552218.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3111255552218.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552218"} | sha256:03b4f27810029f60301b18d4614d97389287d77e9e763a759ebb1dda328379ff |