complaint_snapshots: 27
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27 | 109255451037 | 2026-04-15T15:19:01Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451037 | Timer Settings of Street Lights | - | 9490783483 | 2025-09-01T00:15:01Z | Attended By Officer | Venkatesh | Citizen Complained regarding Timer setting of street Lights at , H no 9-5-101,near sivalayam,sbi colony,champapet | AEE/ENG,,Kapra | 7995009082 | {"comments": [{"id": "109255451037", "mobile_number": "9912370899", "posted_by": "Kiranmayee I/c", "remarks": "CCMS box time setting problem rectified", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 14:30:06"}], "grievance": {"assigned_to": "AEE/ENG,,Kapra", "complaint_type": "Timer Settings of Street Lights", "id": "109255451037", "land_mark": "-", "mobile_number": "9490783483", "officer_remarks": "", "phone_to_call": "7995009082", "photo": "", "raised_by": "Venkatesh", "remarks": "Citizen Complained regarding Timer setting of street Lights at , H no 9-5-101,near sivalayam,sbi colony,champapet", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 05:45:01"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451037"} | sha256:e03c2108a97fefd58a4ccc651b6aae65e8544164e2edea13b272cc45f849bd67 |