complaint_snapshots: 25
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25 | 108255392635 | 2026-04-15T19:21:05Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392635 | Timer Settings of Street Lights | Radhe Shyam Nilayam | 9441691563 | 2025-07-31T19:28:55Z | Closed | Seshu | Timer is not working. Street lights are not working | AE/ENG,,Falaknuma | 7995009087 | 108255392635.jpg | {"comments": [{"id": "108255392635", "mobile_number": "9441691563", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "05-AUG-2025 14:51:11"}, {"id": "108255392635", "mobile_number": "9154369439", "posted_by": "Likhitha", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 23:29:23"}], "grievance": {"assigned_to": "AE/ENG,,Falaknuma", "complaint_type": "Timer Settings of Street Lights", "id": "108255392635", "land_mark": "Radhe Shyam Nilayam", "mobile_number": "9441691563", "officer_remarks": "", "phone_to_call": "7995009087", "photo": "108255392635.jpg", "raised_by": "Seshu", "remarks": "Timer is not working. Street lights are not working", "status": "Closed", "time_stamp": "01-AUG-2025 00:58:55"}, "photos": [{"name": "108255392635.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392635.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392635"} | sha256:e1bc7cbaedcda703cd8c952b20b81bd65a4b85ca5f64c26faadf4e514231df08 |