complaint_snapshots: 40
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40 | 103255140336 | 2026-04-21T14:15:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140336 | Non Glowing of Street Lights | kistama enclave mes colony, near Reddy chicken shop | 7386999029 | 2025-03-01T00:35:13Z | Closed | vinaysingh | street lights of our area are not working from 3-4 days. nobody are here to retifiy this problem.Please get this problem solved as soon as possible. | AE/ENG,,Karwan | 7995009103 | 103255140336.jpg p2103255140336.jpg p3103255140336.jpg | {"comments": [{"id": "103255140336", "mobile_number": "7386999029", "posted_by": "vinaysingh", "remarks": "-", "status": "Closed", "time_stamp": "04-MAR-2025 09:25:03"}, {"id": "103255140336", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir Rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 07:57:08"}, {"id": "103255140336", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir Rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 07:56:12"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Non Glowing of Street Lights", "id": "103255140336", "land_mark": "kistama enclave mes colony, near Reddy chicken shop", "mobile_number": "7386999029", "officer_remarks": "", "phone_to_call": "7995009103", "photo": "103255140336.jpg p2103255140336.jpg p3103255140336.jpg", "raised_by": "vinaysingh", "remarks": "street lights of our area are not working from 3-4 days. nobody are here to retifiy this problem.Please get this problem solved as soon as possible.", "status": "Closed", "time_stamp": "01-MAR-2025 06:05:13"}, "photos": [{"name": "103255140336.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/103255140336.jpg"}, {"name": "p2103255140336.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2103255140336.jpg"}, {"name": "p3103255140336.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3103255140336.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140336"} | sha256:8d13068d388ba07d2a3d483ed9577ef591aadaad7c4d006cb33153d83088e39b |