complaint_snapshots: 47
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47 | 102255097132 | 2026-04-21T22:43:08Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097132 | Non Glowing of Street Lights | Bison enclave Road 1 | 9849792545 | 2025-02-01T00:28:34Z | Attended By Officer | Vamshikrishna | out of 2 Street lights installed 1Street light is not working for more than 2 months -null | AE/ENG,,Karwan | 7995009103 | 102255097132.jpg | {"comments": [{"id": "102255097132", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "05-MAR-2025 00:15:46"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Non Glowing of Street Lights", "id": "102255097132", "land_mark": "Bison enclave Road 1", "mobile_number": "9849792545", "officer_remarks": "", "phone_to_call": "7995009103", "photo": "102255097132.jpg", "raised_by": "Vamshikrishna", "remarks": "out of 2 Street lights installed 1Street light is not working for more than 2 months -null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 05:58:34"}, "photos": [{"name": "102255097132.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097132.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097132"} | sha256:f02c29887503326e9e085a9c6a62022446cde3f360a06f600765aaf8454e1b7a |