complaint_snapshots: 14
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14 | 102265688269 | 2026-04-12T19:37:10Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688269 | Non Glowing of Street Lights | Opposite Vijetha Theatre Lane Beside Jaya Parvathi Nilayam | 9700444958 | 2026-01-31T19:20:55Z | Closed | Syed Ali | Street light Glowing very low and dim and sometimes total black | AE/ENG,,Borabanda | 8919851903 | 102265688269.jpg p2102265688269.jpg p3102265688269.jpg | {"comments": [{"id": "102265688269", "mobile_number": "9700444958", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "07-FEB-2026 14:19:49"}, {"id": "102265688269", "mobile_number": "9121106496", "posted_by": "V Raj Kumar", "remarks": "rectify by officer", "status": "Attended By Officer", "time_stamp": "06-FEB-2026 21:54:02"}], "grievance": {"assigned_to": "AE/ENG,,Borabanda", "complaint_type": "Non Glowing of Street Lights", "id": "102265688269", "land_mark": "Opposite Vijetha Theatre Lane Beside Jaya Parvathi Nilayam", "mobile_number": "9700444958", "officer_remarks": "", "phone_to_call": "8919851903", "photo": "102265688269.jpg p2102265688269.jpg p3102265688269.jpg", "raised_by": "Syed Ali", "remarks": "Street light Glowing very low and dim and sometimes total black", "status": "Closed", "time_stamp": "01-FEB-2026 00:50:55"}, "photos": [{"name": "102265688269.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688269.jpg"}, {"name": "p2102265688269.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688269.jpg"}, {"name": "p3102265688269.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102265688269.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688269"} | sha256:6e600d8e2764f9f0e1999b662cba321b11b4986d40e3eb9a75340eac9f3ecf9f |