snapshot_comments
14 rows where snapshot_pk = 58
This data as json, CSV (advanced)
Suggested facets: mobile_number, status_text, posted_by, remarks, comment_timestamp (date)
| comment_pk ▼ | snapshot_pk | ordinal | complaint_id | mobile_number | comment_timestamp | status_text | posted_by | remarks | raw_comment_json |
|---|---|---|---|---|---|---|---|---|---|
| 129 | 58 58 | 1 | 109255451068 | 9154686556 | 2025-10-18T18:35:33Z | Attended By Officer | T.Sowmya | r | {"id": "109255451068", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": "r", "status": "Attended By Officer", "time_stamp": "19-OCT-2025 00:05:33"} |
| 130 | 58 58 | 2 | 109255451068 | 9703401529 | 2025-10-18T15:33:12Z | Open | Akshay Gir | The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility.", "status": "Open", "time_stamp": "18-OCT-2025 21:03:12"} |
| 131 | 58 58 | 3 | 109255451068 | 9703401529 | 2025-10-18T15:32:39Z | Attended By Officer | Akshay Gir | The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility.", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 21:02:39"} |
| 132 | 58 58 | 4 | 109255451068 | 9154686556 | 2025-10-18T09:40:20Z | Attended By Officer | T.Sowmya | rectified | {"id": "109255451068", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 15:10:20"} |
| 133 | 58 58 | 5 | 109255451068 | 9703401529 | 2025-10-17T13:54:54Z | Open | Akshay Gir | The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility.", "status": "Open", "time_stamp": "17-OCT-2025 19:24:54"} |
| 134 | 58 58 | 6 | 109255451068 | 9703401529 | 2025-10-17T13:54:15Z | Attended By Officer | Akshay Gir | The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility.", "status": "Attended By Officer", "time_stamp": "17-OCT-2025 19:24:15"} |
| 135 | 58 58 | 7 | 109255451068 | 9154686556 | 2025-10-17T12:08:24Z | Attended By Officer | T.Sowmya | r | {"id": "109255451068", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": "r", "status": "Attended By Officer", "time_stamp": "17-OCT-2025 17:38:24"} |
| 136 | 58 58 | 8 | 109255451068 | 9703401529 | 2025-10-14T15:10:58Z | Open | Akshay Gir | The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility.", "status": "Open", "time_stamp": "14-OCT-2025 20:40:58"} |
| 137 | 58 58 | 9 | 109255451068 | 9703401529 | 2025-10-14T15:09:59Z | Attended By Officer | Akshay Gir | The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The grievance has once again been falsely marked as “Attended By Officer” by T. Sowmya, with no meaningful inspection or verification (remark contains only “r”). The streetlight outside Rose Villa Apartments (3-6-148/A), lane beside Vasu Medical Shop, opposite HDFC Bank, Himayath Nagar, remains completely non-functional during night hours. Repeated false closures and lack of accountability are unacceptable. The officer’s contact remains unresponsive, and no proper verification has been conducted. Immediate night-time inspection and urgent repair of the streetlight are required, along with a verified night-time photograph confirming it is operational before this grievance ID is closed again. Continued inaction will compel me to escalate this grievance to senior GHMC authorities and local civic representatives to ensure resident safety and proper accountability. The prolonged negligence continues to put residents and pedestrians at serious risk and demonstrates a complete lack of responsibility.", "status": "Attended By Officer", "time_stamp": "14-OCT-2025 20:39:59"} |
| 138 | 58 58 | 10 | 109255451068 | 9154686556 | 2025-10-14T06:23:57Z | Attended By Officer | T.Sowmya | r | {"id": "109255451068", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": "r", "status": "Attended By Officer", "time_stamp": "14-OCT-2025 11:53:57"} |
| 139 | 58 58 | 11 | 109255451068 | 9703401529 | 2025-10-11T00:47:51Z | Open | Akshay Gir | This grievance (ID 109255451068) has been pending since the last week of August 2025. The streetlight outside Rose Villa Apartments (3-6-148/A) remains non-functional, yet T. Sowmya falsely marked it “rectified” and “attended by officer” with misleading images and even tried to close the grievance with just a single letter “r” without consulting the citizen to confirm resolution. The officer’s provided phone number rings with no response, and the GHMC customer helpline 040-21111111 has no provision to escalate this long-pending issue, which is extremely frustrating and unacceptable. I demand immediate resolution, night-time verification, urgent repair, and a verified photo of the functioning streetlight before closure. The prolonged negligence puts residents and pedestrians at serious risk and reflects a complete lack of accountability. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "This grievance (ID 109255451068) has been pending since the last week of August 2025. The streetlight outside Rose Villa Apartments (3-6-148/A) remains non-functional, yet T. Sowmya falsely marked it “rectified” and “attended by officer” with misleading images and even tried to close the grievance with just a single letter “r” without consulting the citizen to confirm resolution. The officer’s provided phone number rings with no response, and the GHMC customer helpline 040-21111111 has no provision to escalate this long-pending issue, which is extremely frustrating and unacceptable. I demand immediate resolution, night-time verification, urgent repair, and a verified photo of the functioning streetlight before closure. The prolonged negligence puts residents and pedestrians at serious risk and reflects a complete lack of accountability.", "status": "Open", "time_stamp": "11-OCT-2025 06:17:51"} |
| 140 | 58 58 | 12 | 109255451068 | 9703401529 | 2025-09-17T14:55:33Z | Attended By Officer | Akshay Gir | The issue reported under this grievance has been only partially resolved as the streetlight directly outside Rose Villa Apartments in the lane beside Vasu Medical Shop opposite HDFC Bank Himayath Nagar is still not working while others in the lane have been fixed so I request that this specific light be rechecked and properly repaired as it continues to pose a safety concern at night. Thank you. | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "The issue reported under this grievance has been only partially resolved as the streetlight directly outside Rose Villa Apartments in the lane beside Vasu Medical Shop opposite HDFC Bank Himayath Nagar is still not working while others in the lane have been fixed so I request that this specific light be rechecked and properly repaired as it continues to pose a safety concern at night. Thank you.", "status": "Attended By Officer", "time_stamp": "17-SEP-2025 20:25:33"} |
| 141 | 58 58 | 13 | 109255451068 | 9154686556 | 2025-09-17T09:14:53Z | Attended By Officer | T.Sowmya | rectified | {"id": "109255451068", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "17-SEP-2025 14:44:53"} |
| 142 | 58 58 | 14 | 109255451068 | 9703401529 | 2025-09-15T15:36:35Z | Open | Akshay Gir | I am writing to formally follow up on a grievance I raised through the GHMC web portal on 1st September 2025, regarding the complete failure of all streetlights in the lane adjacent to Vasu Medical Shop, opposite HDFC Bank, outside Rose Villa Apartments, Himayath Nagar, Hyderabad – 500029. Over two weeks have passed, and the issue remains unresolved. This particular lane connects directly to the Himayath Nagar main road and is frequently used by pedestrians, residents, and vehicles. As of today, the entire stretch of streetlights remains non-functional, resulting in total darkness during the evening and night hours, creating significant safety risks and serious inconvenience to the local community. Request for Immediate Action - I respectfully request that the GHMC Electrical Department: - (1.) Immediately inspect and repair all non-functional streetlights in the specified lane. (2.)Ensure the issue is fully and sustainably resolved, not temporarily patched. (3.)Implement preventive maintenance measures to avoid recurrence of such outages in the future. Exact Location Details:---- Address: Lane beside Vasu Medical Shop, opposite HDFC Bank, outside Rose Villa Apartments. Area: Himayath Nagar, Hyderabad – 500029 Landmark: Vasu Medical Shop / HDFC Bank, Himayath Nagar Main Road Attached: Image of the affected area for your reference This situation warrants urgent attention and resolution. I urge you to assign the matter to the appropriate officer and provide regular updates on the status of the repair. The residents of the area will sincerely appreciate your timely and effective action on this matter. Thank you for your attention. Sincerely, Akshay Gir Mobile: 9703401529 Email: akshaygir2020@gmail.com | {"id": "109255451068", "mobile_number": "9703401529", "posted_by": "Akshay Gir", "remarks": "I am writing to formally follow up on a grievance I raised through the GHMC web portal on 1st September 2025, regarding the complete failure of all streetlights in the lane adjacent to Vasu Medical Shop, opposite HDFC Bank, outside Rose Villa Apartments, Himayath Nagar, Hyderabad – 500029. Over two weeks have passed, and the issue remains unresolved. This particular lane connects directly to the Himayath Nagar main road and is frequently used by pedestrians, residents, and vehicles. As of today, the entire stretch of streetlights remains non-functional, resulting in total darkness during the evening and night hours, creating significant safety risks and serious inconvenience to the local community. Request for Immediate Action - I respectfully request that the GHMC Electrical Department: - (1.) Immediately inspect and repair all non-functional streetlights in the specified lane. (2.)Ensure the issue is fully and sustainably resolved, not temporarily patched. (3.)Implement preventive maintenance measures to avoid recurrence of such outages in the future. Exact Location Details:---- Address: Lane beside Vasu Medical Shop, opposite HDFC Bank, outside Rose Villa Apartments. Area: Himayath Nagar, Hyderabad – 500029 Landmark: Vasu Medical Shop / HDFC Bank, Himayath Nagar Main Road Attached: Image of the affected area for your reference This situation warrants urgent attention and resolution. I urge you to assign the matter to the appropriate officer and provide regular updates on the status of the repair. The residents of the area will sincerely appreciate your timely and effective action on this matter. Thank you for your attention. Sincerely, Akshay Gir Mobile: 9703401529 Email: akshaygir2020@gmail.com", "status": "Open", "time_stamp": "15-SEP-2025 21:06:35"} |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE snapshot_comments (
comment_pk INTEGER PRIMARY KEY,
snapshot_pk INTEGER NOT NULL REFERENCES complaint_snapshots(snapshot_pk) ON DELETE CASCADE,
ordinal INTEGER NOT NULL,
complaint_id TEXT NOT NULL,
mobile_number TEXT NOT NULL,
comment_timestamp TEXT NOT NULL,
status_text TEXT NOT NULL,
posted_by TEXT NOT NULL,
remarks TEXT NOT NULL,
raw_comment_json TEXT NOT NULL,
UNIQUE(snapshot_pk, ordinal)
);