snapshot_comments

87,399 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 108255392611 9154369424 2025-08-03T01:06:42Z Attended By Officer Dr.B.J. Vanaja Kumari attended 3 to 5 abc dogs {"id": "108255392611", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "attended 3 to 5 abc dogs", "status": "Attended By Officer", "time_stamp": "03-AUG-2025 06:36:42"}
2 2 2 1 108255392612 9848812381 2025-08-08T04:37:08Z Closed Call Centre Satisfied {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-AUG-2025 10:07:08"}
3 2 2 2 108255392612 7993360295 2025-08-06T05:54:21Z Attended By Officer M.Satish Kumar done {"id": "108255392612", "mobile_number": "7993360295", "posted_by": "M.Satish Kumar", "remarks": "done", "status": "Attended By Officer", "time_stamp": "06-AUG-2025 11:24:21"}
4 2 2 3 108255392612 9848812381 2025-08-05T07:02:43Z Open Abedali khan M.Satish Kumar,Assistant Entomologist 7993360295 officer said he resolved as soon as possible {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "M.Satish Kumar,Assistant Entomologist 7993360295 officer said he resolved as soon as possible", "status": "Open", "time_stamp": "05-AUG-2025 12:32:43"}
5 2 2 4 108255392612 9848812381 2025-08-04T06:59:16Z Open Abedali khan Kept conference with M.Satish Kumar,Assistant Entomologist 7993360295 but call is not connecting {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "Kept conference with M.Satish Kumar,Assistant Entomologist 7993360295 but call is not connecting", "status": "Open", "time_stamp": "04-AUG-2025 12:29:16"}
6 2 2 5 108255392612 9848812381 2025-08-02T18:36:04Z Open Abedali khan Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "03-AUG-2025 00:06:04"}
7 2 2 6 108255392612 9848812381 2025-08-01T14:12:18Z Open Abedali khan Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-AUG-2025 19:42:18"}
8 4 4 1 108255392614 9030240314 2025-07-31T18:41:59Z Not Related to My Wing Vivek Citizen enquired regarding Previous Grievance ID 2807255384897 {"id": "108255392614", "mobile_number": "9030240314", "posted_by": "Vivek", "remarks": "Citizen enquired regarding Previous Grievance ID 2807255384897", "status": "Not Related to My Wing", "time_stamp": "01-AUG-2025 00:11:59"}
9 6 6 1 108255392616 9704391756 2025-08-25T04:40:34Z Closed Call Centre Not Satisfied {"id": "108255392616", "mobile_number": "9704391756", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "25-AUG-2025 10:10:34"}
10 6 6 2 108255392616 9154299704 2025-08-02T08:36:41Z Attended By Officer Sri Narsing Rao k {"id": "108255392616", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 14:06:41"}
11 7 7 1 108255392617 9154369424 2025-08-18T05:23:07Z Attended By Officer Dr.B.J. Vanaja Kumari attended 2 to 5 abc dog {"id": "108255392617", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "attended 2 to 5 abc dog", "status": "Attended By Officer", "time_stamp": "18-AUG-2025 10:53:07"}
12 8 8 1 108255392618 8712495967 2025-10-10T12:15:58Z Attended By Officer M.A. ZEESHAN I/c action will be taken as per GHMC rules {"id": "108255392618", "mobile_number": "8712495967", "posted_by": "M.A. ZEESHAN I/c", "remarks": "action will be taken as per GHMC rules", "status": "Attended By Officer", "time_stamp": "10-OCT-2025 17:45:58"}
13 9 9 1 108255392619 9704670163 2025-08-01T03:22:44Z Attended By Officer Sri. Rama rao no stock for new lights {"id": "108255392619", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "no stock for new lights", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 08:52:44"}
14 10 10 1 108255392620 9154032864 2025-08-06T06:54:08Z Attended By Officer Sri A. Maruthi Diwakar resolved {"id": "108255392620", "mobile_number": "9154032864", "posted_by": "Sri A. Maruthi Diwakar", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "06-AUG-2025 12:24:08"}
15 11 11 1 108255392621 7997024599 2025-08-02T09:20:39Z Closed karthikesh Not satisfied {"id": "108255392621", "mobile_number": "7997024599", "posted_by": "karthikesh", "remarks": "Not satisfied", "status": "Closed", "time_stamp": "02-AUG-2025 14:50:39"}
16 11 11 2 108255392621 9154296589 2025-08-01T12:43:58Z Attended By Officer P.Venkateshwar Goud rectifird {"id": "108255392621", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "rectifird", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 18:13:58"}
17 12 12 1 108255392622 9619933063 2025-10-18T07:46:02Z Attended By Officer ShashankBhogi this was attended {"id": "108255392622", "mobile_number": "9619933063", "posted_by": "ShashankBhogi", "remarks": "this was attended", "status": "Attended By Officer", "time_stamp": "18-OCT-2025 13:16:02"}
18 12 12 2 108255392622 9949619958 2025-08-11T02:08:21Z Attended By Officer Jameel Ahmed Clear {"id": "108255392622", "mobile_number": "9949619958", "posted_by": "Jameel Ahmed", "remarks": "Clear", "status": "Attended By Officer", "time_stamp": "11-AUG-2025 07:38:21"}
19 12 12 3 108255392622 9619933063 2025-08-02T04:12:59Z Open ShashankBhogi thanks for attending the issue I am closing this {"id": "108255392622", "mobile_number": "9619933063", "posted_by": "ShashankBhogi", "remarks": "thanks for attending the issue I am closing this", "status": "Open", "time_stamp": "02-AUG-2025 09:42:59"}
20 12 12 4 108255392622 9619933063 2025-08-02T03:58:36Z Open ShashankBhogi ghmc official asked to close n promised to clear the {"id": "108255392622", "mobile_number": "9619933063", "posted_by": "ShashankBhogi", "remarks": "ghmc official asked to close n promised to clear the", "status": "Open", "time_stamp": "02-AUG-2025 09:28:36"}
21 13 13 1 108255392623 9154686556 2025-08-04T01:10:11Z Attended By Officer T.Sowmya . {"id": "108255392623", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "04-AUG-2025 06:40:11"}
22 14 14 1 108255392624 9154909281 2025-08-01T05:36:42Z Attended By Officer Sri.T.R Prasad I/C rectified {"id": "108255392624", "mobile_number": "9154909281", "posted_by": "Sri.T.R Prasad I/C", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 11:06:42"}
23 15 15 1 108255392625 9908027488 2025-08-04T09:09:21Z Closed Call Centre Satisfied {"id": "108255392625", "mobile_number": "9908027488", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "04-AUG-2025 14:39:21"}
24 15 15 2 108255392625 9154909250 2025-08-01T18:28:08Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "108255392625", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 23:58:08"}
25 15 15 3 108255392625 9154909250 2025-08-01T18:27:25Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "108255392625", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 23:57:25"}
26 17 17 1 108255392627 9100025128 2025-08-04T09:06:41Z Attended By Officer B.Ravindra rectified {"id": "108255392627", "mobile_number": "9100025128", "posted_by": "B.Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-AUG-2025 14:36:41"}
27 17 17 2 108255392627 9100025128 2025-08-04T04:55:04Z Open B.Ravindra 4 {"id": "108255392627", "mobile_number": "9100025128", "posted_by": "B.Ravindra", "remarks": "4", "status": "Open", "time_stamp": "04-AUG-2025 10:25:04"}
28 17 17 3 108255392627 9154296589 2025-08-02T03:56:52Z Open P.Venkateshwar Goud farwarded {"id": "108255392627", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "farwarded", "status": "Open", "time_stamp": "02-AUG-2025 09:26:52"}
29 17 17 4 108255392627 9985252272 2025-08-01T17:29:07Z Open sardar Not attended {"id": "108255392627", "mobile_number": "9985252272", "posted_by": "sardar", "remarks": "Not attended", "status": "Open", "time_stamp": "01-AUG-2025 22:59:07"}
30 17 17 5 108255392627 9985252272 2025-08-01T15:24:56Z Attended By Officer sardar not attended just closed the grevinace {"id": "108255392627", "mobile_number": "9985252272", "posted_by": "sardar", "remarks": "not attended just closed the grevinace", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 20:54:56"}
31 17 17 6 108255392627 9985252272 2025-08-01T15:21:41Z Attended By Officer sardar not attended just closed the grevinace {"id": "108255392627", "mobile_number": "9985252272", "posted_by": "sardar", "remarks": "not attended just closed the grevinace", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 20:51:41"}
32 17 17 7 108255392627 9154296589 2025-08-01T15:15:53Z Attended By Officer P.Venkateshwar Goud kapra circle {"id": "108255392627", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "kapra circle", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 20:45:53"}
33 18 18 1 108255392628 9154686556 2025-08-05T00:58:03Z Attended By Officer T.Sowmya . {"id": "108255392628", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "05-AUG-2025 06:28:03"}
34 19 19 1 108255392629 9346014249 2025-08-14T04:33:47Z Attended By Officer Dr.Bheekya attended {"id": "108255392629", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "14-AUG-2025 10:03:47"}
35 19 19 2 108255392629 6304471694 2025-08-07T09:20:58Z Open Call Centre Not Satisfied {"id": "108255392629", "mobile_number": "6304471694", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "07-AUG-2025 14:50:58"}
36 19 19 3 108255392629 9346014249 2025-08-06T05:24:13Z Attended By Officer Dr.Bheekya attended {"id": "108255392629", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "06-AUG-2025 10:54:13"}
37 20 20 1 108255392630 9381459256 2025-08-04T13:05:15Z Attended By Officer P.Venkateshwar Goud. rectified {"id": "108255392630", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-AUG-2025 18:35:15"}
38 21 21 1 108255392631 9398976971 2025-08-02T08:37:58Z Attended By Officer Khairuddin Thank you to the team for their efforts. I humbly request that the dogs are not restored to the same area, as they pose a potential threat. It would be better to relocate them to a safer and more suitable environment. {"id": "108255392631", "mobile_number": "9398976971", "posted_by": "Khairuddin", "remarks": "Thank you to the team for their efforts. I humbly request that the dogs are not restored to the same area, as they pose a potential threat. It would be better to relocate them to a safer and more suitable environment.", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 14:07:58"}
39 21 21 2 108255392631 8919690076 2025-08-01T03:09:01Z Attended By Officer Dr Wasim Complaint attended {"id": "108255392631", "mobile_number": "8919690076", "posted_by": "Dr Wasim", "remarks": "Complaint attended", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 08:39:01"}
40 22 22 1 108255392632 9293604045 2025-08-05T06:42:07Z Closed venkat Immediately attended. Good service. {"id": "108255392632", "mobile_number": "9293604045", "posted_by": "venkat", "remarks": "Immediately attended. Good service.", "status": "Closed", "time_stamp": "05-AUG-2025 12:12:07"}
41 22 22 2 108255392632 9989930592 2025-08-05T06:36:05Z Attended By Officer B.Swapna rectify sir {"id": "108255392632", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "rectify sir", "status": "Attended By Officer", "time_stamp": "05-AUG-2025 12:06:05"}
42 23 23 1 108255392633 9989930592 2025-08-04T16:20:28Z Attended By Officer B.Swapna closed {"id": "108255392633", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "04-AUG-2025 21:50:28"}
43 24 24 1 108255392634 7337557279 2025-08-25T07:38:09Z Attended By Officer Smt.B.Swathi Case filed and penalty to be imposed {"id": "108255392634", "mobile_number": "7337557279", "posted_by": "Smt.B.Swathi", "remarks": "Case filed and penalty to be imposed", "status": "Attended By Officer", "time_stamp": "25-AUG-2025 13:08:09"}
44 24 24 2 108255392634 9701258146 2025-08-22T11:51:25Z Open Call Centre Not Satisfied {"id": "108255392634", "mobile_number": "9701258146", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "22-AUG-2025 17:21:25"}
45 24 24 3 108255392634 7337557279 2025-08-22T07:40:20Z Attended By Officer Smt.B.Swathi conducted inspection and lifted samples for lab analysis {"id": "108255392634", "mobile_number": "7337557279", "posted_by": "Smt.B.Swathi", "remarks": "conducted inspection and lifted samples for lab analysis", "status": "Attended By Officer", "time_stamp": "22-AUG-2025 13:10:20"}
46 25 25 1 108255392635 9441691563 2025-08-05T09:21:11Z Closed Call Centre Not Satisfied {"id": "108255392635", "mobile_number": "9441691563", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "05-AUG-2025 14:51:11"}
47 25 25 2 108255392635 9154369439 2025-08-01T17:59:23Z Attended By Officer Likhitha closed {"id": "108255392635", "mobile_number": "9154369439", "posted_by": "Likhitha", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 23:29:23"}
48 27 27 1 108255392637 9154299704 2025-08-01T10:34:44Z Attended By Officer Musharfuddin rectify {"id": "108255392637", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 16:04:44"}
49 27 27 2 108255392637 9154299704 2025-08-01T05:01:19Z Under Process Musharfuddin under process {"id": "108255392637", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-AUG-2025 10:31:19"}
50 28 28 1 108255392638 9000805945 2025-08-05T09:22:43Z Closed Call Centre Satisfied {"id": "108255392638", "mobile_number": "9000805945", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "05-AUG-2025 14:52:43"}
51 28 28 2 108255392638 8121041420 2025-08-04T03:15:41Z Attended By Officer Dr.Abdul Basith Sir attend a complete 2dogs caught ABC and ARV {"id": "108255392638", "mobile_number": "8121041420", "posted_by": "Dr.Abdul Basith", "remarks": "Sir attend a complete 2dogs caught ABC and ARV", "status": "Attended By Officer", "time_stamp": "04-AUG-2025 08:45:41"}
52 29 29 1 108255392639 9154369423 2025-08-12T16:07:32Z Attended By Officer M.satyanarayana Reddy rectified {"id": "108255392639", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "12-AUG-2025 21:37:32"}
53 30 30 1 108255392640 9154369423 2025-08-12T17:01:47Z Attended By Officer M.satyanarayana Reddy rectified {"id": "108255392640", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "12-AUG-2025 22:31:47"}
54 31 31 1 108255392641 9154299704 2025-08-07T06:07:42Z Attended By Officer Sri Narsing Rao k {"id": "108255392641", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 11:37:42"}
55 32 32 1 108255392642 9154296589 2025-08-03T11:51:56Z Attended By Officer P.Venkateshwar Goud rectifird {"id": "108255392642", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "rectifird", "status": "Attended By Officer", "time_stamp": "03-AUG-2025 17:21:56"}
56 33 33 1 108255392643 9573357296 2025-08-03T09:10:50Z Closed Call Centre Satisfied {"id": "108255392643", "mobile_number": "9573357296", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "03-AUG-2025 14:40:50"}
57 33 33 2 108255392643 9573357296 2025-08-02T13:41:19Z Attended By Officer J Bhavani the street light work is not yet done. but the person complied it verbally {"id": "108255392643", "mobile_number": "9573357296", "posted_by": "J Bhavani", "remarks": "the street light work is not yet done. but the person complied it verbally", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 19:11:19"}
58 33 33 3 108255392643 9000115068 2025-08-02T12:43:08Z Attended By Officer Smt S Sravanthi rectified {"id": "108255392643", "mobile_number": "9000115068", "posted_by": "Smt S Sravanthi", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 18:13:08"}
59 34 34 1 108255392644 9666329788 2025-08-02T09:17:35Z Closed Call Centre Not Satisfied {"id": "108255392644", "mobile_number": "9666329788", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-AUG-2025 14:47:35"}
60 34 34 2 108255392644 9154686556 2025-08-01T17:27:33Z Attended By Officer T.Sowmya rectified {"id": "108255392644", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 22:57:33"}
61 37 37 1 108255392648 9581452143 2025-08-05T11:41:19Z Closed Call Centre Satisfied {"id": "108255392648", "mobile_number": "9581452143", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "05-AUG-2025 17:11:19"}
62 37 37 2 108255392648 9182954615 2025-08-02T03:51:51Z Attended By Officer P.Venkateshwar Goud rectified sir {"id": "108255392648", "mobile_number": "9182954615", "posted_by": "P.Venkateshwar Goud", "remarks": "rectified sir", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 09:21:51"}
63 38 38 1 108255392647 9154299704 2025-08-07T06:07:05Z Attended By Officer Sri Narsing Rao k {"id": "108255392647", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 11:37:05"}
64 40 40 1 108255392650 7893020370 2025-10-13T17:02:31Z Closed Manne Kishore . {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": ".", "status": "Closed", "time_stamp": "13-OCT-2025 22:32:31"}
65 40 40 2 108255392650 8790624601 2025-10-13T15:34:13Z Attended By Officer Sri Jameel Resolved {"id": "108255392650", "mobile_number": "8790624601", "posted_by": "Sri Jameel", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "13-OCT-2025 21:04:13"}
66 40 40 3 108255392650 7893020370 2025-09-02T09:02:36Z Open Manne Kishore After visiting the CM Sri Revanth Reddy Garu and Sri Ranganathan Garu we have blessed with glossy finished road provided by authorities only the problem is walkers are slipping on the road due to over smooth finishing. Kindly Give a Glance. Shubhodayam. {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": "After visiting the CM Sri Revanth Reddy Garu and Sri Ranganathan Garu we have blessed with glossy finished road provided by authorities only the problem is walkers are slipping on the road due to over smooth finishing. Kindly Give a Glance. Shubhodayam.", "status": "Open", "time_stamp": "02-SEP-2025 14:32:36"}
67 40 40 4 108255392650 7893020370 2025-08-08T08:06:34Z Open Manne Kishore Kept Conference with concern officer Sri Jameel ,AE/ENG(8790624601) Officer number is not connected {"id": "108255392650", "mobile_number": "7893020370", "posted_by": "Manne Kishore", "remarks": "Kept Conference with concern officer Sri Jameel ,AE/ENG(8790624601) Officer number is not connected", "status": "Open", "time_stamp": "08-AUG-2025 13:36:34"}
68 40 40 5 108255392650 7995009076 2025-08-01T00:53:55Z Open Sri.M.Bharat Kumar Area pertains to ameerpet ward {"id": "108255392650", "mobile_number": "7995009076", "posted_by": "Sri.M.Bharat Kumar", "remarks": "Area pertains to ameerpet ward", "status": "Open", "time_stamp": "01-AUG-2025 06:23:55"}
69 41 41 1 108255392651 9010403052 2025-08-01T10:07:21Z Open Sri. K.Kiran Kumar forward to ramky {"id": "108255392651", "mobile_number": "9010403052", "posted_by": "Sri. K.Kiran Kumar", "remarks": "forward to ramky", "status": "Open", "time_stamp": "01-AUG-2025 15:37:21"}
70 42 42 1 108255392652 7207923101 2025-08-01T03:14:20Z Attended By Officer Dr.YADAGIRI Dear citizen attended your greivance caught 0 stray dogs at location and noticed 3 sterilized stray dogs and done anti rabies vaccination at location only as per AWBI NORMS we won't catch the sterilized dogs {"id": "108255392652", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "Dear citizen attended your greivance caught 0 stray dogs at location and noticed 3 sterilized stray dogs and done anti rabies vaccination at location only as per AWBI NORMS we won't catch the sterilized dogs", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 08:44:20"}
71 43 43 1 108255392653 9154686556 2025-08-16T08:19:47Z Attended By Officer T.Sowmya . {"id": "108255392653", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "16-AUG-2025 13:49:47"}
72 43 43 2 108255392653 9030033936 2025-08-14T10:52:27Z Open Murali Mohan Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 16:22:27"}
73 43 43 3 108255392653 9030033936 2025-08-14T10:34:46Z Open Murali Mohan Kept Conference with concern officer T.Sowmya,AE/AEE 9154686556 Officer number is not connected {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Kept Conference with concern officer T.Sowmya,AE/AEE 9154686556 Officer number is not connected", "status": "Open", "time_stamp": "14-AUG-2025 16:04:46"}
74 43 43 4 108255392653 9030033936 2025-08-14T10:33:48Z Open Murali Mohan Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 16:03:48"}
75 43 43 5 108255392653 9030033936 2025-08-14T00:07:55Z Open Murali Mohan Citizen informed that the grievance has been pending So please take necessary action Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 05:37:55"}
76 43 43 6 108255392653 9030033936 2025-08-14T00:01:39Z Open Murali Mohan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "14-AUG-2025 05:31:39"}
77 43 43 7 108255392653 9030033936 2025-08-12T13:24:46Z Open Murali Mohan Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "12-AUG-2025 18:54:46"}
78 43 43 8 108255392653 9030033936 2025-08-08T08:56:28Z Open Call Centre Not Satisfied {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "08-AUG-2025 14:26:28"}
79 43 43 9 108255392653 9154686556 2025-08-07T17:13:50Z Attended By Officer T.Sowmya . {"id": "108255392653", "mobile_number": "9154686556", "posted_by": "T.Sowmya", "remarks": ".", "status": "Attended By Officer", "time_stamp": "07-AUG-2025 22:43:50"}
80 43 43 10 108255392653 9030033936 2025-08-05T00:08:08Z Open Murali Mohan Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. {"id": "108255392653", "mobile_number": "9030033936", "posted_by": "Murali Mohan", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "05-AUG-2025 05:38:08"}
81 44 44 1 108255392654 9088872227 2025-08-05T05:58:41Z Attended By Officer Sri K. Chandrasekhar New cc road will be rectified {"id": "108255392654", "mobile_number": "9088872227", "posted_by": "Sri K. Chandrasekhar", "remarks": "New cc road will be rectified", "status": "Attended By Officer", "time_stamp": "05-AUG-2025 11:28:41"}
82 45 45 1 108255392655 9381459256 2025-08-03T03:32:40Z Attended By Officer P.Venkateshwar Goud. rectified {"id": "108255392655", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-AUG-2025 09:02:40"}
83 46 46 1 108255392657 7995009120 2025-08-02T05:33:19Z Attended By Officer Sri. Sai Kiran replace new cover {"id": "108255392657", "mobile_number": "7995009120", "posted_by": "Sri. Sai Kiran", "remarks": "replace new cover", "status": "Attended By Officer", "time_stamp": "02-AUG-2025 11:03:19"}
84 46 46 2 108255392657 7995009120 2025-08-01T02:00:32Z Under Process Sri. Sai Kiran cover will be replaced {"id": "108255392657", "mobile_number": "7995009120", "posted_by": "Sri. Sai Kiran", "remarks": "cover will be replaced", "status": "Under Process", "time_stamp": "01-AUG-2025 07:30:32"}
85 47 47 1 108255392656 7993360321 2025-10-22T16:48:02Z Closed Smt.Preethi Vennila Palagani others {"id": "108255392656", "mobile_number": "7993360321", "posted_by": "Smt.Preethi Vennila Palagani", "remarks": "others", "status": "Closed", "time_stamp": "22-OCT-2025 22:18:02"}
86 47 47 2 108255392656 8686240719 2025-08-14T10:26:09Z Open muzaffer ? {"id": "108255392656", "mobile_number": "8686240719", "posted_by": "muzaffer", "remarks": "?", "status": "Open", "time_stamp": "14-AUG-2025 15:56:09"}
87 47 47 3 108255392656 8686240719 2025-08-09T20:31:02Z Open muzaffer any update {"id": "108255392656", "mobile_number": "8686240719", "posted_by": "muzaffer", "remarks": "any update", "status": "Open", "time_stamp": "10-AUG-2025 02:01:02"}
88 49 49 1 108255392659 7013922017 2025-08-06T08:41:13Z Attended By Officer T Ambica Rani Resolved {"id": "108255392659", "mobile_number": "7013922017", "posted_by": "T Ambica Rani", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "06-AUG-2025 14:11:13"}
89 51 51 1 108255392661 7337364212 2025-08-02T13:18:04Z Open Sri Santosh Reddy Dear citizen sorry for the inconvenience caused. pertains to HMWS and SB. Thank you {"id": "108255392661", "mobile_number": "7337364212", "posted_by": "Sri Santosh Reddy", "remarks": "Dear citizen sorry for the inconvenience caused. pertains to HMWS and SB. Thank you", "status": "Open", "time_stamp": "02-AUG-2025 18:48:04"}
90 51 51 2 108255392661 9000541595 2025-08-02T07:59:33Z Open Orsu Santhosh pertains to chandanagar {"id": "108255392661", "mobile_number": "9000541595", "posted_by": "Orsu Santhosh", "remarks": "pertains to chandanagar", "status": "Open", "time_stamp": "02-AUG-2025 13:29:33"}
91 52 52 1 108255392662 9154369424 2025-08-18T06:05:03Z Attended By Officer Dr.B.J. Vanaja Kumari ABC Dogs 2 to4 {"id": "108255392662", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "ABC Dogs 2 to4", "status": "Attended By Officer", "time_stamp": "18-AUG-2025 11:35:03"}
92 53 53 1 108255392663 9381459256 2025-08-03T03:37:50Z Attended By Officer P.Venkateshwar Goud. rectified {"id": "108255392663", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-AUG-2025 09:07:50"}
93 54 54 1 108255392664 9154909227 2025-08-12T01:56:56Z Attended By Officer Dr.K.Nagarjuna Attended {"id": "108255392664", "mobile_number": "9154909227", "posted_by": "Dr.K.Nagarjuna", "remarks": "Attended", "status": "Attended By Officer", "time_stamp": "12-AUG-2025 07:26:56"}
94 55 55 1 108255392665 8309709808 2025-08-25T04:42:50Z Closed Call Centre Satisfied {"id": "108255392665", "mobile_number": "8309709808", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "25-AUG-2025 10:12:50"}
95 55 55 2 108255392665 9154295249 2025-08-11T10:26:11Z Attended By Officer Sai Chandana rec {"id": "108255392665", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rec", "status": "Attended By Officer", "time_stamp": "11-AUG-2025 15:56:11"}
96 56 56 1 108255392666 9989930451 2025-08-02T10:51:17Z Open B.Uma Rani Garbage {"id": "108255392666", "mobile_number": "9989930451", "posted_by": "B.Uma Rani", "remarks": "Garbage", "status": "Open", "time_stamp": "02-AUG-2025 16:21:17"}
97 57 57 1 108255392667 9949994037 2025-10-11T10:36:06Z Closed P Balananda Swamy This complaint doesn't pertains to my circle {"id": "108255392667", "mobile_number": "9949994037", "posted_by": "P Balananda Swamy", "remarks": "This complaint doesn't pertains to my circle", "status": "Closed", "time_stamp": "11-OCT-2025 16:06:06"}
98 58 58 1 108255392668 9885680883 2025-08-05T09:25:18Z Closed Call Centre Not Satisfied {"id": "108255392668", "mobile_number": "9885680883", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "05-AUG-2025 14:55:18"}
99 58 58 2 108255392668 7997951620 2025-08-01T01:47:17Z Attended By Officer Serilingampally clear {"id": "108255392668", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 07:17:17"}
100 59 59 1 108255392669 9959552464 2025-08-03T18:59:53Z Attended By Officer T. Thirupathi Raju atteded {"id": "108255392669", "mobile_number": "9959552464", "posted_by": "T. Thirupathi Raju", "remarks": "atteded", "status": "Attended By Officer", "time_stamp": "04-AUG-2025 00:29:53"}

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