snapshot_comments

80,328 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
1 1 1 1 110255503071 9346685136 2025-10-27T08:53:12Z Closed Call Centre Satisfied {"id": "110255503071", "mobile_number": "9346685136", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "27-OCT-2025 14:23:12"}
2 1 1 2 110255503071 9346685136 2025-10-14T00:57:03Z Attended By Officer Gogulla venkatesh thanks to GHMC Team for a solve the problem {"id": "110255503071", "mobile_number": "9346685136", "posted_by": "Gogulla venkatesh", "remarks": "thanks to GHMC Team for a solve the problem", "status": "Attended By Officer", "time_stamp": "14-OCT-2025 06:27:03"}
3 1 1 3 110255503071 9059345525 2025-10-06T05:18:06Z Attended By Officer G Kavitha rectify {"id": "110255503071", "mobile_number": "9059345525", "posted_by": "G Kavitha", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "06-OCT-2025 10:48:06"}
4 2 2 1 110255503072 9989930592 2025-10-07T10:25:14Z Attended By Officer B.Swapna closed {"id": "110255503072", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 15:55:14"}
5 4 4 1 110255503074 9121245035 2025-10-08T10:16:22Z Attended By Officer Sri K. Raghupathi reddy sir rectified {"id": "110255503074", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir rectified", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 15:46:22"}
6 5 5 1 110255503075 8341712808 2025-11-02T08:32:23Z Closed Call Centre Not Satisfied {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-NOV-2025 14:02:23"}
7 5 5 2 110255503075 7331189190 2025-10-10T06:11:18Z Attended By Officer P Vigneshwari Sir, patch work is pending due to water supply line leakage. However, our team has temporarily addressed the issue with WMM to make the road motorable. {"id": "110255503075", "mobile_number": "7331189190", "posted_by": "P Vigneshwari", "remarks": "Sir, patch work is pending due to water supply line leakage. However, our team has temporarily addressed the issue with WMM to make the road motorable.", "status": "Attended By Officer", "time_stamp": "10-OCT-2025 11:41:18"}
8 5 5 3 110255503075 8341712808 2025-10-07T09:43:07Z Open ShivaChandan Why are you claiming that you have resolved when it is not. Not even an inch of work has started there. {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "ShivaChandan", "remarks": "Why are you claiming that you have resolved when it is not. Not even an inch of work has started there.", "status": "Open", "time_stamp": "07-OCT-2025 15:13:07"}
9 5 5 4 110255503075 8247250922 2025-10-07T08:28:39Z Attended By Officer Smt. Sakina fatima this issue resolved h {"id": "110255503075", "mobile_number": "8247250922", "posted_by": "Smt. Sakina fatima", "remarks": "this issue resolved h", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 13:58:39"}
10 5 5 5 110255503075 7331186857 2025-10-06T07:47:22Z Open Kedareshwari pertains to ward15 {"id": "110255503075", "mobile_number": "7331186857", "posted_by": "Kedareshwari", "remarks": "pertains to ward15", "status": "Open", "time_stamp": "06-OCT-2025 13:17:22"}
11 5 5 6 110255503075 8341712808 2025-10-01T05:46:42Z Open Ward019 HASTINAPURAM WARD 16 {"id": "110255503075", "mobile_number": "8341712808", "posted_by": "Ward019", "remarks": "HASTINAPURAM WARD 16", "status": "Open", "time_stamp": "01-OCT-2025 11:16:42"}
12 6 6 1 110255503076 9704670163 2025-10-07T19:27:40Z Attended By Officer Sri. Rama rao rectified {"id": "110255503076", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 00:57:40"}
13 6 6 2 110255503076 8712499192 2025-10-01T04:59:13Z Open Smt K. Lavanya pertain to Attapur {"id": "110255503076", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "pertain to Attapur", "status": "Open", "time_stamp": "01-OCT-2025 10:29:13"}
14 6 6 3 110255503076 9966540552 2025-09-30T18:42:44Z Open Deepak streets lights not working {"id": "110255503076", "mobile_number": "9966540552", "posted_by": "Deepak", "remarks": "streets lights not working", "status": "Open", "time_stamp": "01-OCT-2025 00:12:44"}
15 7 7 1 110255503077 9154299704 2025-10-22T13:32:34Z Attended By Officer Sri Narsing Rao k {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "22-OCT-2025 19:02:34"}
16 7 7 2 110255503077 8978434143 2025-10-18T04:16:44Z Open Ali Street lights he said within 4 days its will be completed still now it’s pending {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Street lights he said within 4 days its will be completed still now it’s pending", "status": "Open", "time_stamp": "18-OCT-2025 09:46:44"}
17 7 7 3 110255503077 8978434143 2025-10-18T04:15:27Z Attended By Officer Ali Not Attend {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not Attend", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 09:45:27"}
18 7 7 4 110255503077 9154299704 2025-10-15T07:17:19Z Attended By Officer Sri Narsing Rao k {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "15-OCT-2025 12:47:19"}
19 7 7 5 110255503077 8978434143 2025-10-08T15:38:00Z Open Ali Still its Pending from 27 July … No work is done simply without any resolution closing Ticket. If citizens have given complaint you have to rectified.. not to give Fake comments {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Still its Pending from 27 July … No work is done simply without any resolution closing Ticket. If citizens have given complaint you have to rectified.. not to give Fake comments", "status": "Open", "time_stamp": "08-OCT-2025 21:08:00"}
20 7 7 6 110255503077 8978434143 2025-10-08T15:35:41Z Attended By Officer Ali not Attending {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "not Attending", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 21:05:41"}
21 7 7 7 110255503077 9154299704 2025-10-08T08:28:58Z Attended By Officer Sri Narsing Rao k {"id": "110255503077", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 13:58:58"}
22 7 7 8 110255503077 9154295249 2025-10-04T08:14:24Z Open Sai Chandana forward to Red hills {"id": "110255503077", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "forward to Red hills", "status": "Open", "time_stamp": "04-OCT-2025 13:44:24"}
23 7 7 9 110255503077 8978434143 2025-10-01T11:04:37Z Open Ali Not Attending {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not Attending", "status": "Open", "time_stamp": "01-OCT-2025 16:34:37"}
24 7 7 10 110255503077 8978434143 2025-10-01T11:04:06Z Attended By Officer Ali Not attend {"id": "110255503077", "mobile_number": "8978434143", "posted_by": "Ali", "remarks": "Not attend", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 16:34:06"}
25 7 7 11 110255503077 9154295249 2025-10-01T10:25:47Z Attended By Officer Sai Chandana rectified {"id": "110255503077", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 15:55:47"}
26 8 8 1 110255503079 8008060371 2025-10-04T07:33:06Z Attended By Officer Sri. M.Srinivas Circle 9 Complaint {"id": "110255503079", "mobile_number": "8008060371", "posted_by": "Sri. M.Srinivas", "remarks": "Circle 9 Complaint", "status": "Attended By Officer", "time_stamp": "04-OCT-2025 13:03:06"}
27 8 8 2 110255503079 7995600490 2025-10-02T09:00:58Z Open Call Centre Not Satisfied {"id": "110255503079", "mobile_number": "7995600490", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "02-OCT-2025 14:30:58"}
28 8 8 3 110255503079 8008060371 2025-10-01T04:26:35Z Attended By Officer Sri. M.Srinivas Circle 9 Complaint {"id": "110255503079", "mobile_number": "8008060371", "posted_by": "Sri. M.Srinivas", "remarks": "Circle 9 Complaint", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 09:56:35"}
29 9 9 1 110255503078 9704670163 2025-10-07T19:26:39Z Attended By Officer Sri. Rama rao Rectified {"id": "110255503078", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 00:56:39"}
30 9 9 2 110255503078 9154369423 2025-10-01T03:18:01Z Open M.satyanarayana Reddy k {"id": "110255503078", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "k", "status": "Open", "time_stamp": "01-OCT-2025 08:48:01"}
31 10 10 1 110255503080 9347032091 2025-10-08T10:15:34Z Closed Call Centre Satisfied {"id": "110255503080", "mobile_number": "9347032091", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-OCT-2025 15:45:34"}
32 10 10 2 110255503080 8712499192 2025-10-01T08:56:00Z Attended By Officer Smt K. Lavanya rectified {"id": "110255503080", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 14:26:00"}
33 10 10 3 110255503080 8712499192 2025-10-01T04:57:11Z Under Process Smt K. Lavanya under process {"id": "110255503080", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "under process", "status": "Under Process", "time_stamp": "01-OCT-2025 10:27:11"}
34 11 11 1 110255503081 7981836439 2025-10-20T10:04:17Z Closed Call Centre Satisfied {"id": "110255503081", "mobile_number": "7981836439", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "20-OCT-2025 15:34:17"}
35 11 11 2 110255503081 8500496801 2025-10-07T10:54:34Z Attended By Officer Smt R Shirisha rectified {"id": "110255503081", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 16:24:34"}
36 11 11 3 110255503081 9059345525 2025-10-06T05:18:57Z Open G Kavitha out of package {"id": "110255503081", "mobile_number": "9059345525", "posted_by": "G Kavitha", "remarks": "out of package", "status": "Open", "time_stamp": "06-OCT-2025 10:48:57"}
37 11 11 4 110255503081 9989930592 2025-10-01T04:31:22Z Open B.Swapna balkampet {"id": "110255503081", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "balkampet", "status": "Open", "time_stamp": "01-OCT-2025 10:01:22"}
38 12 12 1 110255503083 9121245035 2025-10-06T14:30:07Z Attended By Officer Sri K. Raghupathi reddy clear {"id": "110255503083", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "06-OCT-2025 20:00:07"}
39 12 12 2 110255503083 9121245035 2025-10-06T14:24:47Z Open Sri K. Raghupathi reddy fwd {"id": "110255503083", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "fwd", "status": "Open", "time_stamp": "06-OCT-2025 19:54:47"}
40 12 12 3 110255503083 9121245035 2025-10-06T03:58:39Z Open Sri K. Raghupathi reddy fwd {"id": "110255503083", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "fwd", "status": "Open", "time_stamp": "06-OCT-2025 09:28:39"}
41 12 12 4 110255503083 8500496801 2025-10-01T16:41:06Z Open Smt R Shirisha other package {"id": "110255503083", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "other package", "status": "Open", "time_stamp": "01-OCT-2025 22:11:06"}
42 13 13 1 110255503082 9154296619 2025-10-06T12:34:52Z Attended By Officer B.Ravindra re {"id": "110255503082", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "re", "status": "Attended By Officer", "time_stamp": "06-OCT-2025 18:04:52"}
43 13 13 2 110255503082 9398175780 2025-10-06T05:18:02Z Open Call Centre Not Satisfied {"id": "110255503082", "mobile_number": "9398175780", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "06-OCT-2025 10:48:02"}
44 13 13 3 110255503082 9154296619 2025-10-05T04:36:47Z Attended By Officer B.Ravindra rectified {"id": "110255503082", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 10:06:47"}
45 13 13 4 110255503082 9154296619 2025-10-04T03:19:06Z Open B.Ravindra 2 {"id": "110255503082", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "2", "status": "Open", "time_stamp": "04-OCT-2025 08:49:06"}
46 14 14 1 110255503084 9100667105 2025-10-14T13:46:24Z Attended By Officer Syed akbar no street light kindly request to provide the lights on the pule {"id": "110255503084", "mobile_number": "9100667105", "posted_by": "Syed akbar", "remarks": "no street light kindly request to provide the lights on the pule", "status": "Attended By Officer", "time_stamp": "14-OCT-2025 19:16:24"}
47 14 14 2 110255503084 9100667105 2025-10-14T13:44:03Z Attended By Officer Syed akbar no street lights {"id": "110255503084", "mobile_number": "9100667105", "posted_by": "Syed akbar", "remarks": "no street lights", "status": "Attended By Officer", "time_stamp": "14-OCT-2025 19:14:03"}
48 14 14 3 110255503084 8074004250 2025-10-07T16:14:32Z Attended By Officer Satya narayana rectified {"id": "110255503084", "mobile_number": "8074004250", "posted_by": "Satya narayana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 21:44:32"}
49 15 15 1 110255503085 7331170020 2025-10-04T03:49:32Z Submitted for Sanction S Mahadev Anurag need proposal {"id": "110255503085", "mobile_number": "7331170020", "posted_by": "S Mahadev Anurag", "remarks": "need proposal", "status": "Submitted for Sanction", "time_stamp": "04-OCT-2025 09:19:32"}
50 15 15 2 110255503085 8712034414 2025-10-04T03:21:26Z Open Sri S Sai Yugandhar Reddy 132 {"id": "110255503085", "mobile_number": "8712034414", "posted_by": "Sri S Sai Yugandhar Reddy", "remarks": "132", "status": "Open", "time_stamp": "04-OCT-2025 08:51:26"}
51 16 16 1 110255503086 7013681851 2025-10-07T14:00:39Z Attended By Officer Ibrahim non glowing of street lights. jubilee medical hall lane Panjagutta venkateswara colony division. please rectify . thank you {"id": "110255503086", "mobile_number": "7013681851", "posted_by": "Ibrahim", "remarks": "non glowing of street lights. jubilee medical hall lane Panjagutta venkateswara colony division. please rectify . thank you", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 19:30:39"}
52 16 16 2 110255503086 9154299640 2025-10-05T13:56:25Z Attended By Officer Smt. M. Sushma rectified {"id": "110255503086", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 19:26:25"}
53 16 16 3 110255503086 8500496801 2025-10-01T03:38:54Z Open Smt R Shirisha other {"id": "110255503086", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "other", "status": "Open", "time_stamp": "01-OCT-2025 09:08:54"}
54 17 17 1 110255503087 9154369429 2025-10-04T07:21:12Z Attended By Officer Dr.Srikanth Attended {"id": "110255503087", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "Attended", "status": "Attended By Officer", "time_stamp": "04-OCT-2025 12:51:12"}
55 18 18 1 110255503088 8919013946 2025-10-25T06:18:13Z Closed p uday kiran Satisfied {"id": "110255503088", "mobile_number": "8919013946", "posted_by": "p uday kiran", "remarks": "Satisfied", "status": "Closed", "time_stamp": "25-OCT-2025 11:48:13"}
56 18 18 2 110255503088 8500496801 2025-10-09T14:23:14Z Attended By Officer Smt R Shirisha rectified {"id": "110255503088", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "09-OCT-2025 19:53:14"}
57 19 19 1 110255503089 8074642401 2025-10-05T05:09:27Z Attended By Officer MOHD MAJEED KHAN not resolved send team asap {"id": "110255503089", "mobile_number": "8074642401", "posted_by": "MOHD MAJEED KHAN", "remarks": "not resolved send team asap", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 10:39:27"}
58 19 19 2 110255503089 8008060477 2025-10-05T04:09:01Z Attended By Officer N.Uday Kiran done {"id": "110255503089", "mobile_number": "8008060477", "posted_by": "N.Uday Kiran", "remarks": "done", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 09:39:01"}
59 19 19 3 110255503089 8074642401 2025-10-02T09:02:01Z Open Call Centre Not Satisfied {"id": "110255503089", "mobile_number": "8074642401", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "02-OCT-2025 14:32:01"}
60 19 19 4 110255503089 8008060477 2025-10-01T12:15:42Z Attended By Officer N.Uday Kiran we contact you to verify mosquito meance {"id": "110255503089", "mobile_number": "8008060477", "posted_by": "N.Uday Kiran", "remarks": "we contact you to verify mosquito meance", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 17:45:42"}
61 20 20 1 110255503090 9705869992 2025-10-03T04:38:17Z Attended By Officer Sri. L. Swamy Naik It is to inform you that please approach the traffice police for redressal of your grievance {"id": "110255503090", "mobile_number": "9705869992", "posted_by": "Sri. L. Swamy Naik", "remarks": "It is to inform you that please approach the traffice police for redressal of your grievance", "status": "Attended By Officer", "time_stamp": "03-OCT-2025 10:08:17"}
62 21 21 1 110255503091 9440449486 2025-10-06T07:04:06Z Closed Sri S Sairam Reddy it pertains to HMWSSB {"id": "110255503091", "mobile_number": "9440449486", "posted_by": "Sri S Sairam Reddy", "remarks": "it pertains to HMWSSB", "status": "Closed", "time_stamp": "06-OCT-2025 12:34:06"}
63 22 22 1 110255503092 7981829691 2025-10-10T09:27:12Z Closed Call Centre Partially Satisfied {"id": "110255503092", "mobile_number": "7981829691", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "Closed", "time_stamp": "10-OCT-2025 14:57:12"}
64 22 22 2 110255503092 9154686556 2025-10-09T12:51:35Z Attended By Officer T.Sowmya . {"id": "110255503092", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "09-OCT-2025 18:21:35"}
65 22 22 3 110255503092 7981829691 2025-10-07T13:05:41Z Open Md Ayub khan Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "110255503092", "mobile_number": "7981829691", "posted_by": "Md Ayub khan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "07-OCT-2025 18:35:41"}
66 22 22 4 110255503092 7981829691 2025-10-06T08:04:53Z Open Md Ayub khan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "110255503092", "mobile_number": "7981829691", "posted_by": "Md Ayub khan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "06-OCT-2025 13:34:53"}
67 23 23 1 110255503093 9676300250 2025-10-20T10:09:04Z Closed Call Centre Satisfied {"id": "110255503093", "mobile_number": "9676300250", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "20-OCT-2025 15:39:04"}
68 23 23 2 110255503093 9959226586 2025-10-01T06:45:36Z Attended By Officer P Harishanker kindly apply through Meeseva online with relevant Documents. {"id": "110255503093", "mobile_number": "9959226586", "posted_by": "P Harishanker", "remarks": "kindly apply through Meeseva online with relevant Documents.", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 12:15:36"}
69 23 23 3 110255503093 9959226586 2025-10-01T06:34:43Z Open P Harishanker it pertains to 95-ward jubilee Hills {"id": "110255503093", "mobile_number": "9959226586", "posted_by": "P Harishanker", "remarks": "it pertains to 95-ward jubilee Hills", "status": "Open", "time_stamp": "01-OCT-2025 12:04:43"}
70 23 23 4 110255503093 7702522448 2025-10-01T02:14:54Z Open U. Venkataramulu our officials vl attend forwarded to Jubili hills circle {"id": "110255503093", "mobile_number": "7702522448", "posted_by": "U. Venkataramulu", "remarks": "our officials vl attend forwarded to Jubili hills circle", "status": "Open", "time_stamp": "01-OCT-2025 07:44:54"}
71 24 24 1 110255503094 7989823354 2025-12-05T08:54:07Z Attended By Officer Syed Yahiya Kamal Submit your registered documents through mee seva for mutation of property for further process {"id": "110255503094", "mobile_number": "7989823354", "posted_by": "Syed Yahiya Kamal", "remarks": "Submit your registered documents through mee seva for mutation of property for further process", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 14:24:07"}
72 24 24 2 110255503094 8125668932 2025-12-02T14:21:44Z Open Krishna Anusuri GHMC records are not getting updated even after mutation fee is paid. I have attached mutation certificate also but no action is taken. I am chasing many times with no proper help. {"id": "110255503094", "mobile_number": "8125668932", "posted_by": "Krishna Anusuri", "remarks": "GHMC records are not getting updated even after mutation fee is paid. I have attached mutation certificate also but no action is taken. I am chasing many times with no proper help.", "status": "Open", "time_stamp": "02-DEC-2025 19:51:44"}
73 24 24 3 110255503094 8125668932 2025-12-01T20:42:40Z Open Krishna Anusuri I am attaching mutation certificate once again for you here that i have received in Feb 2025. I am not sure you are understanding my issue. I have already got mutation certificate. Do I still need to go to meeseva. Meeseva dept are saying to contact GHMC. Please assist. {"id": "110255503094", "mobile_number": "8125668932", "posted_by": "Krishna Anusuri", "remarks": "I am attaching mutation certificate once again for you here that i have received in Feb 2025. I am not sure you are understanding my issue. I have already got mutation certificate. Do I still need to go to meeseva. Meeseva dept are saying to contact GHMC. Please assist.", "status": "Open", "time_stamp": "02-DEC-2025 02:12:40"}
74 24 24 4 110255503094 7989823354 2025-12-01T06:36:51Z Attended By Officer Syed Yahiya Kamal For mutation of property, submit your registered documents and link also should be registered through mee seva for further process. {"id": "110255503094", "mobile_number": "7989823354", "posted_by": "Syed Yahiya Kamal", "remarks": "For mutation of property, submit your registered documents and link also should be registered through mee seva for further process.", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 12:06:51"}
75 24 24 5 110255503094 8125668932 2025-11-29T23:08:11Z Open Krishna Anusuri I have already got mutation certificate / Transfer certificate. When getting mutation certificate only the link documents etc all got registered. GHMC records didnt get updated. Is it mee seva dept to update on GHMC staff to update. I have also requested online and I got acknowledgement number CTAO20251124231916. But no action taken till now. {"id": "110255503094", "mobile_number": "8125668932", "posted_by": "Krishna Anusuri", "remarks": "I have already got mutation certificate / Transfer certificate. When getting mutation certificate only the link documents etc all got registered. GHMC records didnt get updated. Is it mee seva dept to update on GHMC staff to update. I have also requested online and I got acknowledgement number CTAO20251124231916. But no action taken till now.", "status": "Open", "time_stamp": "30-NOV-2025 04:38:11"}
76 24 24 6 110255503094 7989823354 2025-10-02T10:05:03Z Attended By Officer Syed Yahiya Kamal submit your registered documents and link documents also should be registered and apply through meeseva for further process of mutation {"id": "110255503094", "mobile_number": "7989823354", "posted_by": "Syed Yahiya Kamal", "remarks": "submit your registered documents and link documents also should be registered and apply through meeseva for further process of mutation", "status": "Attended By Officer", "time_stamp": "02-OCT-2025 15:35:03"}
77 25 25 1 110255503095 7093000100 2026-03-15T17:25:08Z Open Abdul Nala work belongs to hmws ? {"id": "110255503095", "mobile_number": "7093000100", "posted_by": "Abdul", "remarks": "Nala work belongs to hmws ?", "status": "Open", "time_stamp": "15-MAR-2026 22:55:08"}
78 25 25 2 110255503095 7995009079 2025-10-14T06:51:17Z Open Sri.G. Bharath Kumar pertaining to HMWSSB {"id": "110255503095", "mobile_number": "7995009079", "posted_by": "Sri.G. Bharath Kumar", "remarks": "pertaining to HMWSSB", "status": "Open", "time_stamp": "14-OCT-2025 12:21:17"}
79 27 27 1 110255503097 7842547676 2025-10-27T08:55:34Z Closed Call Centre Satisfied {"id": "110255503097", "mobile_number": "7842547676", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "27-OCT-2025 14:25:34"}
80 27 27 2 110255503097 7997951620 2025-10-01T02:01:19Z Attended By Officer Serilingampally clear {"id": "110255503097", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 07:31:19"}
81 28 28 1 110255503098 9154369429 2025-10-10T06:51:32Z Attended By Officer Dr.Srikanth caught 2dogs {"id": "110255503098", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "caught 2dogs", "status": "Attended By Officer", "time_stamp": "10-OCT-2025 12:21:32"}
82 29 29 1 110255503099 9154909321 2025-10-11T10:57:16Z Attended By Officer K.Raju rectify {"id": "110255503099", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "11-OCT-2025 16:27:16"}
83 29 29 2 110255503099 6301726265 2025-10-06T09:29:57Z Open Call Centre Not Satisfied {"id": "110255503099", "mobile_number": "6301726265", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "06-OCT-2025 14:59:57"}
84 29 29 3 110255503099 9154909321 2025-10-05T17:46:45Z Attended By Officer K.Raju rectify {"id": "110255503099", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 23:16:45"}
85 29 29 4 110255503099 6301726265 2025-10-05T17:45:17Z Open Anil Kumar Not resolved It been more then 1 month ,this is 4time I am giving complaint {"id": "110255503099", "mobile_number": "6301726265", "posted_by": "Anil Kumar", "remarks": "Not resolved It been more then 1 month ,this is 4time I am giving complaint", "status": "Open", "time_stamp": "05-OCT-2025 23:15:17"}
86 29 29 5 110255503099 9154909321 2025-10-05T17:38:43Z Attended By Officer K.Raju rectify {"id": "110255503099", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 23:08:43"}
87 30 30 1 110255503100 9121245035 2025-10-08T09:30:15Z Attended By Officer Sri K. Raghupathi reddy sir rectified {"id": "110255503100", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir rectified", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 15:00:15"}
88 31 31 1 110255503101 9000114676 2025-10-01T01:45:15Z Closed Dr .Neelima forward {"id": "110255503101", "mobile_number": "9000114676", "posted_by": "Dr .Neelima", "remarks": "forward", "status": "Closed", "time_stamp": "01-OCT-2025 07:15:15"}
89 33 33 1 110255503103 8143616865 2025-10-06T21:26:29Z Attended By Officer Md Vikash Still Pending.. {"id": "110255503103", "mobile_number": "8143616865", "posted_by": "Md Vikash", "remarks": "Still Pending..", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 02:56:29"}
90 33 33 2 110255503103 9154931422 2025-10-06T11:54:22Z Attended By Officer Dr.Chandra Shekar clear {"id": "110255503103", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "06-OCT-2025 17:24:22"}
91 33 33 3 110255503103 8143616865 2025-10-06T11:46:19Z Open Call Centre Not Satisfied {"id": "110255503103", "mobile_number": "8143616865", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "06-OCT-2025 17:16:19"}
92 33 33 4 110255503103 9154931422 2025-10-05T11:27:12Z Attended By Officer Dr.Chandra Shekar clear {"id": "110255503103", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "05-OCT-2025 16:57:12"}
93 34 34 1 110255503104 8328509062 2025-10-14T08:50:23Z Closed Call Centre Satisfied {"id": "110255503104", "mobile_number": "8328509062", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "14-OCT-2025 14:20:23"}
94 34 34 2 110255503104 7995009122 2025-10-08T19:32:36Z Attended By Officer VIJAY complaint attended {"id": "110255503104", "mobile_number": "7995009122", "posted_by": "VIJAY", "remarks": "complaint attended", "status": "Attended By Officer", "time_stamp": "09-OCT-2025 01:02:36"}
95 34 34 3 110255503104 7995009122 2025-10-01T05:15:15Z Under Process VIJAY under process {"id": "110255503104", "mobile_number": "7995009122", "posted_by": "VIJAY", "remarks": "under process", "status": "Under Process", "time_stamp": "01-OCT-2025 10:45:15"}
96 36 36 1 110255503106 9704670163 2025-10-08T14:51:19Z Attended By Officer Sri. Rama rao Rectified {"id": "110255503106", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 20:21:19"}
97 37 37 1 110255503107 8686705994 2025-11-15T10:18:57Z Closed Call Centre Satisfied {"id": "110255503107", "mobile_number": "8686705994", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "15-NOV-2025 15:48:57"}
98 37 37 2 110255503107 8121041509 2025-11-01T09:10:38Z Attended By Officer DRF TEAM solved the problem {"id": "110255503107", "mobile_number": "8121041509", "posted_by": "DRF TEAM", "remarks": "solved the problem", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 14:40:38"}
99 37 37 3 110255503107 7337557266 2025-10-31T13:31:51Z Open Sri. R. Hemu Naik Pertaining to B N reddy nagar ward {"id": "110255503107", "mobile_number": "7337557266", "posted_by": "Sri. R. Hemu Naik", "remarks": "Pertaining to B N reddy nagar ward", "status": "Open", "time_stamp": "31-OCT-2025 19:01:51"}
100 38 38 1 110255503108 7331189492 2025-10-01T03:54:59Z Closed O.Divya Teja pertains to HMWS SB they will impose penalty for that {"id": "110255503108", "mobile_number": "7331189492", "posted_by": "O.Divya Teja", "remarks": "pertains to HMWS SB they will impose penalty for that", "status": "Closed", "time_stamp": "01-OCT-2025 09:24:59"}

Next page

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