complaint_snapshots: 42
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 42 | 104255188624 | 2026-04-18T08:22:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188624 | Non Glowing of Street Lights | Saikrishna Enclave Phase-2 Yapral Park | 9177003935 | 2025-04-01T00:53:20Z | Attended By Officer | Sundarababu | Street light not glowing - this light is frequently not working several times rectified | AE/ENG,,Karwan | 7995009103 | 104255188624.jpg | {"comments": [{"id": "104255188624", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "10-APR-2025 17:56:52"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Non Glowing of Street Lights", "id": "104255188624", "land_mark": "Saikrishna Enclave Phase-2 Yapral Park", "mobile_number": "9177003935", "officer_remarks": "", "phone_to_call": "7995009103", "photo": "104255188624.jpg", "raised_by": "Sundarababu", "remarks": "Street light not glowing - this light is frequently not working several times rectified", "status": "Attended By Officer", "time_stamp": "01-APR-2025 06:23:20"}, "photos": [{"name": "104255188624.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188624.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188624"} | sha256:bfc3a2b28b1d4f325f731048755b1eccc2809495ae1b2087d6cdb57132ac2f96 |