snapshot_comments

79,041 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 2 2 1 109255451012 8639267510 2025-09-02T05:07:21Z Attended By Officer Sri. S.Vikram Chandra brunch furning {"id": "109255451012", "mobile_number": "8639267510", "posted_by": "Sri. S.Vikram Chandra", "remarks": "brunch furning", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 10:37:21"}
2 3 3 1 109255451013 9154686556 2025-10-07T01:43:53Z Attended By Officer T.Sowmya . {"id": "109255451013", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 07:13:53"}
3 3 3 2 109255451013 9154686556 2025-10-07T01:43:30Z Attended By Officer T.Sowmya . {"id": "109255451013", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "07-OCT-2025 07:13:30"}
4 3 3 3 109255451013 8328333132 2025-09-15T05:03:44Z Open Chaitanya Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "109255451013", "mobile_number": "8328333132", "posted_by": "Chaitanya", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "15-SEP-2025 10:33:44"}
5 4 4 1 109255451014 9030208716 2025-09-30T12:16:26Z Closed charan naidu Problem resolved {"id": "109255451014", "mobile_number": "9030208716", "posted_by": "charan naidu", "remarks": "Problem resolved", "status": "Closed", "time_stamp": "30-SEP-2025 17:46:26"}
6 4 4 2 109255451014 7995007396 2025-09-30T12:15:33Z Attended By Officer Smt K Satya Laxmi attend {"id": "109255451014", "mobile_number": "7995007396", "posted_by": "Smt K Satya Laxmi", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "30-SEP-2025 17:45:33"}
7 5 5 1 109255451015 9059345525 2025-09-03T06:26:20Z Attended By Officer G Kavitha rectify {"id": "109255451015", "mobile_number": "9059345525", "posted_by": "G Kavitha", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 11:56:20"}
8 6 6 1 109255451016 9701363239 2025-09-01T11:22:54Z Closed Smt Chandana, DYEE pertains 6police department {"id": "109255451016", "mobile_number": "9701363239", "posted_by": "Smt Chandana, DYEE", "remarks": "pertains 6police department", "status": "Closed", "time_stamp": "01-SEP-2025 16:52:54"}
9 6 6 2 109255451016 9912478361 2025-09-01T07:04:50Z Open Sri. S. Goverdhan The matter pertains to Deputy Commissioner Circle -5, GHMC {"id": "109255451016", "mobile_number": "9912478361", "posted_by": "Sri. S. Goverdhan", "remarks": "The matter pertains to Deputy Commissioner Circle -5, GHMC", "status": "Open", "time_stamp": "01-SEP-2025 12:34:50"}
10 6 6 3 109255451016 8019349909 2025-08-31T18:41:12Z Open Preetham As per Telangana High court direction, No loud band or music allowed after 10 PM as part of Ganesh festival. However, In P and T colony road, there is a huge violation of the aforesaid rule. A lot many bands with high decibels of volumes for Ganesh procession have been keep on coming in P and T colony road in Dilshuknagar till late night. We have persons having health issues at home. Kindly ask the police personnel to do the patrolling frequently and prevent this noise pollution please after 10 PM. This is a request as we have health relates issues {"id": "109255451016", "mobile_number": "8019349909", "posted_by": "Preetham", "remarks": "As per Telangana High court direction, No loud band or music allowed after 10 PM as part of Ganesh festival. However, In P and T colony road, there is a huge violation of the aforesaid rule. A lot many bands with high decibels of volumes for Ganesh procession have been keep on coming in P and T colony road in Dilshuknagar till late night. We have persons having health issues at home. Kindly ask the police personnel to do the patrolling frequently and prevent this noise pollution please after 10 PM. This is a request as we have health relates issues", "status": "Open", "time_stamp": "01-SEP-2025 00:11:12"}
11 7 7 1 109255451017 9885510510 2025-09-04T05:20:25Z Closed Sri.Vinay please look into the matter {"id": "109255451017", "mobile_number": "9885510510", "posted_by": "Sri.Vinay", "remarks": "please look into the matter", "status": "Closed", "time_stamp": "04-SEP-2025 10:50:25"}
12 7 7 2 109255451017 9701363239 2025-09-01T11:22:26Z Open Smt Chandana, DYEE pertains to police department {"id": "109255451017", "mobile_number": "9701363239", "posted_by": "Smt Chandana, DYEE", "remarks": "pertains to police department", "status": "Open", "time_stamp": "01-SEP-2025 16:52:26"}
13 7 7 3 109255451017 9912478361 2025-09-01T07:04:05Z Open Sri. S. Goverdhan The matter pertains to Deputy Commissioner, Circle - 5, GHMC. {"id": "109255451017", "mobile_number": "9912478361", "posted_by": "Sri. S. Goverdhan", "remarks": "The matter pertains to Deputy Commissioner, Circle - 5, GHMC.", "status": "Open", "time_stamp": "01-SEP-2025 12:34:05"}
14 7 7 4 109255451017 8019349909 2025-08-31T18:41:12Z Open Preetham As per Telangana High court direction, No loud band or music allowed after 10 PM as part of Ganesh festival. However, In P and T colony road, there is a huge violation of the aforesaid rule. A lot many bands with high decibels of volumes for Ganesh procession have been keep on coming in P and T colony road in Dilshuknagar till late night. We have persons having health issues at home. Kindly ask the police personnel to do the patrolling frequently and prevent this noise pollution please after 10 PM. This is a request as we have health relates issues {"id": "109255451017", "mobile_number": "8019349909", "posted_by": "Preetham", "remarks": "As per Telangana High court direction, No loud band or music allowed after 10 PM as part of Ganesh festival. However, In P and T colony road, there is a huge violation of the aforesaid rule. A lot many bands with high decibels of volumes for Ganesh procession have been keep on coming in P and T colony road in Dilshuknagar till late night. We have persons having health issues at home. Kindly ask the police personnel to do the patrolling frequently and prevent this noise pollution please after 10 PM. This is a request as we have health relates issues", "status": "Open", "time_stamp": "01-SEP-2025 00:11:12"}
15 8 8 1 109255451018 7337557230 2025-09-09T13:01:16Z Submitted for Sanction P.Ravali nil {"id": "109255451018", "mobile_number": "7337557230", "posted_by": "P.Ravali", "remarks": "nil", "status": "Submitted for Sanction", "time_stamp": "09-SEP-2025 18:31:16"}
16 9 9 1 109255451020 9121245035 2025-09-04T06:27:39Z Attended By Officer Sri K. Raghupathi reddy Street light complaint rectified sir {"id": "109255451020", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "Street light complaint rectified sir", "status": "Attended By Officer", "time_stamp": "04-SEP-2025 11:57:39"}
17 10 10 1 109255451019 9290544519 2025-09-05T09:50:41Z Closed Call Centre Satisfied {"id": "109255451019", "mobile_number": "9290544519", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "05-SEP-2025 15:20:41"}
18 10 10 2 109255451019 9849324700 2025-09-02T08:41:01Z Attended By Officer Kiranmayee I/C rectified Sir {"id": "109255451019", "mobile_number": "9849324700", "posted_by": "Kiranmayee I/C", "remarks": "rectified Sir", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 14:11:01"}
19 11 11 1 109255451022 9866043024 2026-03-29T19:27:00Z Open Dr Mohammed Khaleel Ahmed No action yet {"id": "109255451022", "mobile_number": "9866043024", "posted_by": "Dr Mohammed Khaleel Ahmed", "remarks": "No action yet", "status": "Open", "time_stamp": "30-MAR-2026 00:57:00"}
20 11 11 2 109255451022 7995007379 2025-09-10T05:23:54Z Open Sri D. Mahesh opp ak maternity hospital it is hmws mh. {"id": "109255451022", "mobile_number": "7995007379", "posted_by": "Sri D. Mahesh", "remarks": "opp ak maternity hospital it is hmws mh.", "status": "Open", "time_stamp": "10-SEP-2025 10:53:54"}
21 11 11 3 109255451022 8712013113 2025-09-06T09:04:09Z Open V Konda Rama Reddy pertains to another ward {"id": "109255451022", "mobile_number": "8712013113", "posted_by": "V Konda Rama Reddy", "remarks": "pertains to another ward", "status": "Open", "time_stamp": "06-SEP-2025 14:34:09"}
22 11 11 4 109255451022 9063843649 2025-09-01T15:45:59Z Open Dr. Ravinder Goud please contact {"id": "109255451022", "mobile_number": "9063843649", "posted_by": "Dr. Ravinder Goud", "remarks": "please contact", "status": "Open", "time_stamp": "01-SEP-2025 21:15:59"}
23 12 12 1 109255451021 9515660479 2025-09-11T06:47:12Z Attended By Officer V.Arun Kumar fogging done {"id": "109255451021", "mobile_number": "9515660479", "posted_by": "V.Arun Kumar", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "11-SEP-2025 12:17:12"}
24 13 13 1 109255451023 9154296589 2025-09-07T20:24:06Z Attended By Officer P.Venkateshwar Goud rectifird {"id": "109255451023", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "rectifird", "status": "Attended By Officer", "time_stamp": "08-SEP-2025 01:54:06"}
25 13 13 2 109255451023 7416104707 2025-09-02T07:16:03Z Open Ward139 grievance pertains to Gowtham Nagar {"id": "109255451023", "mobile_number": "7416104707", "posted_by": "Ward139", "remarks": "grievance pertains to Gowtham Nagar", "status": "Open", "time_stamp": "02-SEP-2025 12:46:03"}
26 14 14 1 109255451024 7799588861 2025-10-23T06:47:47Z Attended By Officer Ch. SUDHAKAR informed to remove encroachment {"id": "109255451024", "mobile_number": "7799588861", "posted_by": "Ch. SUDHAKAR", "remarks": "informed to remove encroachment", "status": "Attended By Officer", "time_stamp": "23-OCT-2025 12:17:47"}
27 14 14 2 109255451024 8328104508 2025-10-10T04:45:24Z Open Call Centre Not Satisfied {"id": "109255451024", "mobile_number": "8328104508", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "10-OCT-2025 10:15:24"}
28 14 14 3 109255451024 7799588861 2025-10-09T06:03:47Z Attended By Officer Ch. SUDHAKAR informed to remove encroachment {"id": "109255451024", "mobile_number": "7799588861", "posted_by": "Ch. SUDHAKAR", "remarks": "informed to remove encroachment", "status": "Attended By Officer", "time_stamp": "09-OCT-2025 11:33:47"}
29 14 14 4 109255451024 8328104508 2025-09-11T08:51:46Z Open Ward039 Pertains to 43-Chandrayangutta ward {"id": "109255451024", "mobile_number": "8328104508", "posted_by": "Ward039", "remarks": "Pertains to 43-Chandrayangutta ward", "status": "Open", "time_stamp": "11-SEP-2025 14:21:46"}
30 14 14 5 109255451024 7799588861 2025-09-11T04:55:12Z Open Ch. SUDHAKAR pertains to santoshnagar {"id": "109255451024", "mobile_number": "7799588861", "posted_by": "Ch. SUDHAKAR", "remarks": "pertains to santoshnagar", "status": "Open", "time_stamp": "11-SEP-2025 10:25:12"}
31 15 15 1 109255451025 9154299704 2025-09-20T06:22:25Z Attended By Officer Sri Narsing Rao k {"id": "109255451025", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "20-SEP-2025 11:52:25"}
32 15 15 2 109255451025 9154299704 2025-09-01T10:58:13Z Open Musharfuddin p {"id": "109255451025", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "p", "status": "Open", "time_stamp": "01-SEP-2025 16:28:13"}
33 15 15 3 109255451025 8712499192 2025-08-31T20:45:56Z Under Process Smt K. Lavanya under process {"id": "109255451025", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "under process", "status": "Under Process", "time_stamp": "01-SEP-2025 02:15:56"}
34 16 16 1 109255451026 9154909250 2025-09-02T05:25:36Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "109255451026", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 10:55:36"}
35 16 16 2 109255451026 9063843649 2025-09-01T04:37:20Z Open Dr. Ravinder Goud please contact {"id": "109255451026", "mobile_number": "9063843649", "posted_by": "Dr. Ravinder Goud", "remarks": "please contact", "status": "Open", "time_stamp": "01-SEP-2025 10:07:20"}
36 17 17 1 109255451027 9154369423 2025-09-11T03:36:44Z Attended By Officer M.satyanarayana Reddy rectified {"id": "109255451027", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "11-SEP-2025 09:06:44"}
37 17 17 2 109255451027 9394797796 2025-09-05T05:11:48Z Open SYED ABDUL MALIK SIR I HUMBLY REQUEST YOU TO RESOLVED OUR PROBLEM PLS {"id": "109255451027", "mobile_number": "9394797796", "posted_by": "SYED ABDUL MALIK", "remarks": "SIR I HUMBLY REQUEST YOU TO RESOLVED OUR PROBLEM PLS", "status": "Open", "time_stamp": "05-SEP-2025 10:41:48"}
38 17 17 3 109255451027 9394797796 2025-09-03T07:44:24Z Open SYED ABDUL MALIK not working work given complaint sir please action sow many accident illigal activity {"id": "109255451027", "mobile_number": "9394797796", "posted_by": "SYED ABDUL MALIK", "remarks": "not working work given complaint sir please action sow many accident illigal activity", "status": "Open", "time_stamp": "03-SEP-2025 13:14:24"}
39 18 18 1 109255451028 9989930592 2025-09-08T05:56:51Z Attended By Officer B.Swapna closed {"id": "109255451028", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "08-SEP-2025 11:26:51"}
40 18 18 2 109255451028 8247761125 2025-09-04T10:33:36Z Open Call Centre Not Satisfied {"id": "109255451028", "mobile_number": "8247761125", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "04-SEP-2025 16:03:36"}
41 18 18 3 109255451028 9989930592 2025-09-02T13:14:25Z Attended By Officer B.Swapna closed {"id": "109255451028", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 18:44:25"}
42 19 19 1 109255451029 9154909321 2025-09-04T08:00:10Z Attended By Officer K.Raju nutral problem rectified {"id": "109255451029", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "nutral problem rectified", "status": "Attended By Officer", "time_stamp": "04-SEP-2025 13:30:10"}
43 20 20 1 109255451031 9154299704 2025-09-16T09:35:33Z Attended By Officer Sri Narsing Rao k {"id": "109255451031", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "16-SEP-2025 15:05:33"}
44 21 21 1 109255451030 7386611173 2025-09-13T09:57:54Z Closed Call Centre Satisfied {"id": "109255451030", "mobile_number": "7386611173", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "13-SEP-2025 15:27:54"}
45 21 21 2 109255451030 9866505931 2025-09-03T02:55:44Z Attended By Officer M. Vijay Kumar grabage {"id": "109255451030", "mobile_number": "9866505931", "posted_by": "M. Vijay Kumar", "remarks": "grabage", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 08:25:44"}
46 22 22 1 109255451032 7997951618 2025-09-01T04:29:09Z Attended By Officer Jubilee Hills clear {"id": "109255451032", "mobile_number": "7997951618", "posted_by": "Jubilee Hills", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 09:59:09"}
47 22 22 2 109255451032 9154909250 2025-09-01T01:46:53Z Open Dr.Md Irshad Iqbal It pertains to Shaikpet please contact {"id": "109255451032", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "It pertains to Shaikpet please contact", "status": "Open", "time_stamp": "01-SEP-2025 07:16:53"}
48 23 23 1 109255451033 7842547676 2025-09-13T10:47:37Z Closed Call Centre Satisfied {"id": "109255451033", "mobile_number": "7842547676", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "13-SEP-2025 16:17:37"}
49 23 23 2 109255451033 7997951620 2025-09-01T04:48:44Z Attended By Officer Serilingampally clear {"id": "109255451033", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 10:18:44"}
50 24 24 1 109255451034 8977712309 2025-09-07T15:55:31Z Closed sai Nice work {"id": "109255451034", "mobile_number": "8977712309", "posted_by": "sai", "remarks": "Nice work", "status": "Closed", "time_stamp": "07-SEP-2025 21:25:31"}
51 24 24 2 109255451034 8977712309 2025-09-07T15:55:01Z Attended By Officer sai thank you resolved {"id": "109255451034", "mobile_number": "8977712309", "posted_by": "sai", "remarks": "thank you resolved", "status": "Attended By Officer", "time_stamp": "07-SEP-2025 21:25:01"}
52 24 24 3 109255451034 8977712309 2025-09-05T18:46:26Z Attended By Officer sai please resolve asap {"id": "109255451034", "mobile_number": "8977712309", "posted_by": "sai", "remarks": "please resolve asap", "status": "Attended By Officer", "time_stamp": "06-SEP-2025 00:16:26"}
53 24 24 4 109255451034 8977712309 2025-09-05T18:45:56Z Attended By Officer sai not resolved {"id": "109255451034", "mobile_number": "8977712309", "posted_by": "sai", "remarks": "not resolved", "status": "Attended By Officer", "time_stamp": "06-SEP-2025 00:15:56"}
54 24 24 5 109255451034 9182954615 2025-09-05T09:13:34Z Attended By Officer P.Venkateshwar Goud rectified sir {"id": "109255451034", "mobile_number": "9182954615", "posted_by": "P.Venkateshwar Goud", "remarks": "rectified sir", "status": "Attended By Officer", "time_stamp": "05-SEP-2025 14:43:34"}
55 25 25 1 109255451035 9966165048 2025-09-07T09:34:38Z Closed Call Centre Satisfied {"id": "109255451035", "mobile_number": "9966165048", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "07-SEP-2025 15:04:38"}
56 25 25 2 109255451035 9154296619 2025-09-03T11:49:07Z Attended By Officer B.Ravindra rectified {"id": "109255451035", "mobile_number": "9154296619", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 17:19:07"}
57 25 25 3 109255451035 9966165048 2025-09-02T07:09:53Z Open Ward139 grievance pertains to 4- Meerpet HB Colony {"id": "109255451035", "mobile_number": "9966165048", "posted_by": "Ward139", "remarks": "grievance pertains to 4- Meerpet HB Colony", "status": "Open", "time_stamp": "02-SEP-2025 12:39:53"}
58 26 26 1 109255451036 9246163445 2025-09-09T16:21:47Z Attended By Officer Kishore still not working {"id": "109255451036", "mobile_number": "9246163445", "posted_by": "Kishore", "remarks": "still not working", "status": "Attended By Officer", "time_stamp": "09-SEP-2025 21:51:47"}
59 26 26 2 109255451036 9154296589 2025-09-07T20:23:30Z Attended By Officer P.Venkateshwar Goud rectifird {"id": "109255451036", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "rectifird", "status": "Attended By Officer", "time_stamp": "08-SEP-2025 01:53:30"}
60 26 26 3 109255451036 9246163445 2025-09-03T13:35:18Z Open Kishore please let me know the status {"id": "109255451036", "mobile_number": "9246163445", "posted_by": "Kishore", "remarks": "please let me know the status", "status": "Open", "time_stamp": "03-SEP-2025 19:05:18"}
61 27 27 1 109255451037 9912370899 2025-09-02T09:00:06Z Attended By Officer Kiranmayee I/c CCMS box time setting problem rectified {"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"}
62 28 28 1 109255451038 9154909250 2025-09-02T05:23:15Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "109255451038", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 10:53:15"}
63 28 28 2 109255451038 9515165713 2025-09-01T14:57:20Z Open Dr.G.Rajnikanth not in my limits {"id": "109255451038", "mobile_number": "9515165713", "posted_by": "Dr.G.Rajnikanth", "remarks": "not in my limits", "status": "Open", "time_stamp": "01-SEP-2025 20:27:20"}
64 29 29 1 109255451039 8328385936 2025-09-17T06:46:06Z Attended By Officer Sri A Karunakar encroachment drives will be conducted with the coordination of traffic police department {"id": "109255451039", "mobile_number": "8328385936", "posted_by": "Sri A Karunakar", "remarks": "encroachment drives will be conducted with the coordination of traffic police department", "status": "Attended By Officer", "time_stamp": "17-SEP-2025 12:16:06"}
65 31 31 1 109255451041 9948554619 2025-09-24T09:54:16Z Closed Call Centre Not Satisfied {"id": "109255451041", "mobile_number": "9948554619", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "24-SEP-2025 15:24:16"}
66 31 31 2 109255451041 9515165713 2025-09-02T11:01:40Z Attended By Officer Dr .G .Rajnikanth cleared {"id": "109255451041", "mobile_number": "9515165713", "posted_by": "Dr .G .Rajnikanth", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "02-SEP-2025 16:31:40"}
67 31 31 3 109255451041 9100955064 2025-09-02T01:27:03Z Open PRAVEEN complaint belongs to 61 Attapur ward {"id": "109255451041", "mobile_number": "9100955064", "posted_by": "PRAVEEN", "remarks": "complaint belongs to 61 Attapur ward", "status": "Open", "time_stamp": "02-SEP-2025 06:57:03"}
68 32 32 1 109255451042 9663887878 2025-09-13T09:58:39Z Closed Call Centre Not Satisfied {"id": "109255451042", "mobile_number": "9663887878", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "13-SEP-2025 15:28:39"}
69 32 32 2 109255451042 8008103629 2025-09-01T13:21:34Z Attended By Officer A. Srinivas attend {"id": "109255451042", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 18:51:34"}
70 33 33 1 109255451043 9989320858 2025-09-02T11:03:53Z Closed Call Centre Not Satisfied {"id": "109255451043", "mobile_number": "9989320858", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-SEP-2025 16:33:53"}
71 33 33 2 109255451043 9154299704 2025-09-01T10:53:51Z Attended By Officer Musharfuddin rectify {"id": "109255451043", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 16:23:51"}
72 33 33 3 109255451043 9154299704 2025-09-01T10:53:04Z Under Process Musharfuddin rectifying {"id": "109255451043", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectifying", "status": "Under Process", "time_stamp": "01-SEP-2025 16:23:04"}
73 34 34 1 109255451044 8008103629 2025-09-01T13:22:13Z Attended By Officer A. Srinivas attend {"id": "109255451044", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 18:52:13"}
74 35 35 1 109255451045 9393345451 2025-09-11T04:32:01Z Closed Call Centre Not Satisfied {"id": "109255451045", "mobile_number": "9393345451", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "11-SEP-2025 10:02:01"}
75 35 35 2 109255451045 9154369429 2025-09-10T06:45:51Z Attended By Officer Dr.Srikanth caught 2dogs {"id": "109255451045", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "caught 2dogs", "status": "Attended By Officer", "time_stamp": "10-SEP-2025 12:15:51"}
76 35 35 3 109255451045 9393345451 2025-09-03T12:16:01Z Open Vasudev rao Citizen informed complaint has not yet rectified so kept conference with concern officerDr Wasim,Veternery Officer(8919690076)Officer Said complaint will Racatifi as soon as Possible. {"id": "109255451045", "mobile_number": "9393345451", "posted_by": "Vasudev rao", "remarks": "Citizen informed complaint has not yet rectified so kept conference with concern officerDr Wasim,Veternery Officer(8919690076)Officer Said complaint will Racatifi as soon as Possible.", "status": "Open", "time_stamp": "03-SEP-2025 17:46:01"}
77 35 35 4 109255451045 9393345451 2025-09-01T16:59:13Z Open Vasudev rao Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "109255451045", "mobile_number": "9393345451", "posted_by": "Vasudev rao", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-SEP-2025 22:29:13"}
78 36 36 1 109255451046 9398508101 2025-09-08T07:47:18Z Attended By Officer Smt. N. Shireesha resolved {"id": "109255451046", "mobile_number": "9398508101", "posted_by": "Smt. N. Shireesha", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "08-SEP-2025 13:17:18"}
79 36 36 2 109255451046 7995009122 2025-09-01T01:35:53Z Open VIJAY pertaining to IS sadan ward {"id": "109255451046", "mobile_number": "7995009122", "posted_by": "VIJAY", "remarks": "pertaining to IS sadan ward", "status": "Open", "time_stamp": "01-SEP-2025 07:05:53"}
80 38 38 1 109255451048 9849929325 2025-09-13T09:59:32Z Closed Call Centre Satisfied {"id": "109255451048", "mobile_number": "9849929325", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "13-SEP-2025 15:29:32"}
81 38 38 2 109255451048 9885198396 2025-09-09T04:09:00Z Attended By Officer Dr. Vijay Mohan Rao cleared {"id": "109255451048", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "09-SEP-2025 09:39:00"}
82 39 39 1 109255451049 7981692049 2025-09-07T04:34:28Z Closed Call Centre Satisfied {"id": "109255451049", "mobile_number": "7981692049", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "07-SEP-2025 10:04:28"}
83 39 39 2 109255451049 9154909250 2025-09-03T02:24:46Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "109255451049", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 07:54:46"}
84 39 39 3 109255451049 7981692049 2025-09-01T14:31:34Z Open Sandeep Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "109255451049", "mobile_number": "7981692049", "posted_by": "Sandeep", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-SEP-2025 20:01:34"}
85 40 40 1 109255451050 9948050373 2025-09-02T04:49:13Z Closed Call Centre Satisfied {"id": "109255451050", "mobile_number": "9948050373", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-SEP-2025 10:19:13"}
86 40 40 2 109255451050 7989301584 2025-09-01T08:31:50Z Attended By Officer Dr.K.Manjula sweeping clear {"id": "109255451050", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 14:01:50"}
87 41 41 1 109255451051 7337557230 2025-09-30T07:57:17Z Submitted for Sanction P.Ravali sor,badly damaged stretches sanctioned and work will be taken up to avoid inconvenience {"id": "109255451051", "mobile_number": "7337557230", "posted_by": "P.Ravali", "remarks": "sor,badly damaged stretches sanctioned and work will be taken up to avoid inconvenience", "status": "Submitted for Sanction", "time_stamp": "30-SEP-2025 13:27:17"}
88 41 41 2 109255451051 9665779206 2025-09-05T01:37:00Z Open Chandan Singh its been a week with no update on this issue. Kindly look into this issue as soon as possible {"id": "109255451051", "mobile_number": "9665779206", "posted_by": "Chandan Singh", "remarks": "its been a week with no update on this issue. Kindly look into this issue as soon as possible", "status": "Open", "time_stamp": "05-SEP-2025 07:07:00"}
89 42 42 1 109255451052 9989624364 2025-09-24T09:56:56Z Closed Call Centre Satisfied {"id": "109255451052", "mobile_number": "9989624364", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "24-SEP-2025 15:26:56"}
90 42 42 2 109255451052 8008060371 2025-09-03T02:50:34Z Attended By Officer Sri. M.Srinivas Circle 7 Complaint {"id": "109255451052", "mobile_number": "8008060371", "posted_by": "Sri. M.Srinivas", "remarks": "Circle 7 Complaint", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 08:20:34"}
91 42 42 3 109255451052 9989930527 2025-09-02T12:31:19Z Open D.Meneamma santhosh Nagar {"id": "109255451052", "mobile_number": "9989930527", "posted_by": "D.Meneamma", "remarks": "santhosh Nagar", "status": "Open", "time_stamp": "02-SEP-2025 18:01:19"}
92 43 43 1 109255451053 9177904941 2025-11-25T04:26:18Z Attended By Officer Dr.Y . Sudguna Devi complaint disposed properly {"id": "109255451053", "mobile_number": "9177904941", "posted_by": "Dr.Y . Sudguna Devi", "remarks": "complaint disposed properly", "status": "Attended By Officer", "time_stamp": "25-NOV-2025 09:56:18"}
93 43 43 2 109255451053 9154369424 2025-09-05T02:33:56Z Attended By Officer Dr.B.J. Vanaja Kumari attended 1 dogs catched 2 to 5 abc dogs {"id": "109255451053", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "attended 1 dogs catched 2 to 5 abc dogs", "status": "Attended By Officer", "time_stamp": "05-SEP-2025 08:03:56"}
94 43 43 3 109255451053 9652576687 2025-09-03T04:25:14Z Open Call Centre Not Satisfied {"id": "109255451053", "mobile_number": "9652576687", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "03-SEP-2025 09:55:14"}
95 43 43 4 109255451053 9154369424 2025-09-03T02:22:14Z Attended By Officer Dr.B.J. Vanaja Kumari attended 1 dog catched 2 to 5 abc dogs {"id": "109255451053", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "attended 1 dog catched 2 to 5 abc dogs", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 07:52:14"}
96 44 44 1 109255451055 7331170681 2025-10-13T08:27:49Z Closed Sri. B. Laxmi Deepak Hmwssb {"id": "109255451055", "mobile_number": "7331170681", "posted_by": "Sri. B. Laxmi Deepak", "remarks": "Hmwssb", "status": "Closed", "time_stamp": "13-OCT-2025 13:57:49"}
97 44 44 2 109255451055 7331170681 2025-10-10T10:01:32Z Under Process Sri. B. Laxmi Deepak sanction {"id": "109255451055", "mobile_number": "7331170681", "posted_by": "Sri. B. Laxmi Deepak", "remarks": "sanction", "status": "Under Process", "time_stamp": "10-OCT-2025 15:31:32"}
98 44 44 3 109255451055 7331189510 2025-09-01T09:53:32Z Open Sri. D. Raj Kumar ward no 11 {"id": "109255451055", "mobile_number": "7331189510", "posted_by": "Sri. D. Raj Kumar", "remarks": "ward no 11", "status": "Open", "time_stamp": "01-SEP-2025 15:23:32"}
99 45 45 1 109255451056 9000979737 2025-09-01T11:17:29Z Attended By Officer phani Kumar not cleared. {"id": "109255451056", "mobile_number": "9000979737", "posted_by": "phani Kumar", "remarks": "not cleared.", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 16:47:29"}
100 45 45 2 109255451056 7989301584 2025-09-01T06:57:49Z Attended By Officer Dr.K.Manjula garbage Lifting {"id": "109255451056", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "garbage Lifting", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 12:27:49"}

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