snapshot_comments

17 rows where snapshot_pk = 25

✎ View and edit SQL

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
36 25 25 1 104255188607 9154768771 2025-05-22T03:24:21Z Attended By Officer S.Kiranmayee rectified {"id": "104255188607", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "22-MAY-2025 08:54:21"}
37 25 25 2 104255188607 9052560193 2025-05-20T18:53:46Z Open Dhawan Dear Officer, I'm going to give complaint against you and your staff for false report and negligence towards the complaint. My location is in S r Nagar, not Banjara hills and you have closed the complaint. It show how disciplined you are towards your work. I'm going to give complaint to CMO & Praja Palana on today. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Dear Officer, I'm going to give complaint against you and your staff for false report and negligence towards the complaint. My location is in S r Nagar, not Banjara hills and you have closed the complaint. It show how disciplined you are towards your work. I'm going to give complaint to CMO & Praja Palana on today.", "status": "Open", "time_stamp": "21-MAY-2025 00:23:46"}
38 25 25 3 104255188607 9154768771 2025-05-20T16:09:08Z Attended By Officer S.Kiranmayee rectified {"id": "104255188607", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "20-MAY-2025 21:39:08"}
39 25 25 4 104255188607 9052560193 2025-05-19T04:21:09Z Open Dhawan not resolved. how many times should I reopen the grievance. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "not resolved. how many times should I reopen the grievance.", "status": "Open", "time_stamp": "19-MAY-2025 09:51:09"}
40 25 25 5 104255188607 9154768771 2025-05-15T14:11:59Z Attended By Officer S.Kiranmayee rectified {"id": "104255188607", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "15-MAY-2025 19:41:59"}
41 25 25 6 104255188607 9052560193 2025-05-15T12:53:42Z Open Dhawan still not resolved.No one has attended the issue {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "still not resolved.No one has attended the issue", "status": "Open", "time_stamp": "15-MAY-2025 18:23:42"}
42 25 25 7 104255188607 9154768771 2025-05-14T18:19:06Z Attended By Officer S.Kiranmayee rectified {"id": "104255188607", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "14-MAY-2025 23:49:06"}
43 25 25 8 104255188607 9052560193 2025-05-14T17:46:49Z Open Dhawan It is not resolved, dear officer please don't giv false reports {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "It is not resolved, dear officer please don't giv false reports", "status": "Open", "time_stamp": "14-MAY-2025 23:16:49"}
44 25 25 9 104255188607 9154299640 2025-05-13T05:29:51Z Attended By Officer Smt. M. Sushma resolved {"id": "104255188607", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "13-MAY-2025 10:59:51"}
45 25 25 10 104255188607 9052560193 2025-05-08T23:31:27Z Open Dhawan Still how many days will it take rectify {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Still how many days will it take rectify", "status": "Open", "time_stamp": "09-MAY-2025 05:01:27"}
46 25 25 11 104255188607 9052560193 2025-04-23T15:31:34Z Open Dhawan Dear officer, how many should should I complain and how many days will it take resolve the issue. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Dear officer, how many should should I complain and how many days will it take resolve the issue.", "status": "Open", "time_stamp": "23-APR-2025 21:01:34"}
47 25 25 12 104255188607 9052560193 2025-04-21T13:55:09Z Open Dhawan Citizen informed that the grievance has been pending. so please take necessary action. Thank you sir. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Citizen informed that the grievance has been pending. so please take necessary action. Thank you sir.", "status": "Open", "time_stamp": "21-APR-2025 19:25:09"}
48 25 25 13 104255188607 9052560193 2025-04-18T14:45:18Z Open Dhawan Dear Officer, it's been almost a month the dust street lights aren't working. I have raised complaint on 1st April 2025 but till today i.e., 18.04.2025 no one has visited the place to check the fault nor they have repaired the street light. I have complained to the GHMC customer care also. I request the kind of reserve to rectify the issue at the earliest. I am unable to understand that how many time should I complain about the same issue to rectify. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Dear Officer, it's been almost a month the dust street lights aren't working. I have raised complaint on 1st April 2025 but till today i.e., 18.04.2025 no one has visited the place to check the fault nor they have repaired the street light. I have complained to the GHMC customer care also. I request the kind of reserve to rectify the issue at the earliest. I am unable to understand that how many time should I complain about the same issue to rectify.", "status": "Open", "time_stamp": "18-APR-2025 20:15:18"}
49 25 25 14 104255188607 9052560193 2025-04-15T09:24:04Z Open Dhawan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "15-APR-2025 14:54:04"}
50 25 25 15 104255188607 9052560193 2025-04-08T10:31:35Z Open Dhawan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "08-APR-2025 16:01:35"}
51 25 25 16 104255188607 9052560193 2025-04-08T10:25:17Z Open Dhawan this is my reminder-2 request for non flowing of street lights. Its been almost 20 days that street lightvis not working. No officer is taking responsibility to repair it. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "this is my reminder-2 request for non flowing of street lights. Its been almost 20 days that street lightvis not working. No officer is taking responsibility to repair it.", "status": "Open", "time_stamp": "08-APR-2025 15:55:17"}
52 25 25 17 104255188607 9052560193 2025-04-04T03:21:00Z Open Dhawan till now no one has visted the place to check the street light. It is requested to repair/install the street light ASAP. {"id": "104255188607", "mobile_number": "9052560193", "posted_by": "Dhawan", "remarks": "till now no one has visted the place to check the street light. It is requested to repair/install the street light ASAP.", "status": "Open", "time_stamp": "04-APR-2025 08:51:00"}

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
);