snapshot_comments

79,966 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 107255337655 9515660479 2025-07-02T11:52:22Z Attended By Officer V.Arun Kumar fogging done {"id": "107255337655", "mobile_number": "9515660479", "posted_by": "V.Arun Kumar", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 17:22:22"}
2 2 2 1 107255337656 9515165713 2025-07-01T07:05:17Z Closed Dr.G.Rajnikanth HMWS {"id": "107255337656", "mobile_number": "9515165713", "posted_by": "Dr.G.Rajnikanth", "remarks": "HMWS", "status": "Closed", "time_stamp": "01-JUL-2025 12:35:17"}
3 3 3 1 107255337658 9989930669 2025-07-01T06:00:48Z Attended By Officer Ajaj Kumar close {"id": "107255337658", "mobile_number": "9989930669", "posted_by": "Ajaj Kumar", "remarks": "close", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 11:30:48"}
4 3 3 2 107255337658 8309293834 2025-07-01T04:38:59Z Open Murali krishna Payment not updated and still showing to pay . {"id": "107255337658", "mobile_number": "8309293834", "posted_by": "Murali krishna", "remarks": "Payment not updated and still showing to pay .", "status": "Open", "time_stamp": "01-JUL-2025 10:08:59"}
5 3 3 3 107255337658 9989930669 2025-07-01T03:59:04Z Attended By Officer Ajaj Kumar close {"id": "107255337658", "mobile_number": "9989930669", "posted_by": "Ajaj Kumar", "remarks": "close", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 09:29:04"}
6 4 4 1 107255337657 9985236860 2025-07-04T13:09:00Z Closed Mohd Mubeen Qureshi - {"id": "107255337657", "mobile_number": "9985236860", "posted_by": "Mohd Mubeen Qureshi", "remarks": "-", "status": "Closed", "time_stamp": "04-JUL-2025 18:39:00"}
7 4 4 2 107255337657 - 2025-07-04T12:00:29Z - Call Centre Satisfied {"id": "107255337657", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "04-JUL-2025 17:30:29"}
8 4 4 3 107255337657 9154369423 2025-07-03T16:10:22Z Attended By Officer M.satyanarayana Reddy rectified {"id": "107255337657", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-JUL-2025 21:40:22"}
9 6 6 1 107255337660 9701365515 2025-07-04T04:57:20Z Attended By Officer Sri Venkatesh Dy.EE(SWM) cleared {"id": "107255337660", "mobile_number": "9701365515", "posted_by": "Sri Venkatesh Dy.EE(SWM)", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "04-JUL-2025 10:27:20"}
10 6 6 2 107255337660 9848936842 2025-07-04T04:24:35Z Open Pratapsen Another circle {"id": "107255337660", "mobile_number": "9848936842", "posted_by": "Pratapsen", "remarks": "Another circle", "status": "Open", "time_stamp": "04-JUL-2025 09:54:35"}
11 6 6 3 107255337660 9154369422 2025-07-04T00:50:17Z Open Dr. A Praveena pertaining to our circle {"id": "107255337660", "mobile_number": "9154369422", "posted_by": "Dr. A Praveena", "remarks": "pertaining to our circle", "status": "Open", "time_stamp": "04-JUL-2025 06:20:17"}
12 6 6 4 107255337660 9848936842 2025-07-01T01:45:16Z Open Pratapsen Another circle {"id": "107255337660", "mobile_number": "9848936842", "posted_by": "Pratapsen", "remarks": "Another circle", "status": "Open", "time_stamp": "01-JUL-2025 07:15:16"}
13 8 8 1 107255337662 - 2025-07-02T12:11:55Z - Call Centre Satisfied {"id": "107255337662", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "02-JUL-2025 17:41:55"}
14 8 8 2 107255337662 9989930592 2025-07-01T18:24:55Z Attended By Officer B.Swapna closed {"id": "107255337662", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 23:54:55"}
15 9 9 1 107255337663 9154299640 2025-07-05T09:41:56Z Attended By Officer Smt. M. Sushma Rectified {"id": "107255337663", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "05-JUL-2025 15:11:56"}
16 9 9 2 107255337663 9154299640 2025-07-04T10:14:38Z Open Smt. M. Sushma forward {"id": "107255337663", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "forward", "status": "Open", "time_stamp": "04-JUL-2025 15:44:38"}
17 10 10 1 107255337664 - 2025-07-02T12:13:06Z - Call Centre Not Satisfied {"id": "107255337664", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "02-JUL-2025 17:43:06"}
18 10 10 2 107255337664 9989930592 2025-07-01T18:26:28Z Attended By Officer B.Swapna closed {"id": "107255337664", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 23:56:28"}
19 11 11 1 107255337665 9989930592 2025-07-01T18:35:59Z Attended By Officer B.Swapna closed {"id": "107255337665", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 00:05:59"}
20 11 11 2 107255337665 8977703672 2025-06-30T18:57:31Z Open Aravind Lights Street lights are not glowing {"id": "107255337665", "mobile_number": "8977703672", "posted_by": "Aravind", "remarks": "Lights Street lights are not glowing", "status": "Open", "time_stamp": "01-JUL-2025 00:27:31"}
21 12 12 1 107255337666 9989930592 2025-07-01T18:34:54Z Attended By Officer B.Swapna closed {"id": "107255337666", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 00:04:54"}
22 13 13 1 107255337667 9989930592 2025-07-01T18:33:23Z Attended By Officer B.Swapna closed {"id": "107255337667", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 00:03:23"}
23 14 14 1 107255337669 9397392004 2025-07-11T08:47:02Z Closed Call Centre Not Satisfied {"id": "107255337669", "mobile_number": "9397392004", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "11-JUL-2025 14:17:02"}
24 14 14 2 107255337669 9154299704 2025-07-09T10:18:55Z Attended By Officer Musharfuddin rectify {"id": "107255337669", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "09-JUL-2025 15:48:55"}
25 14 14 3 107255337669 9154299704 2025-07-01T05:55:37Z Under Process Musharfuddin under process {"id": "107255337669", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUL-2025 11:25:37"}
26 15 15 1 107255337668 9989930592 2025-07-01T18:32:20Z Attended By Officer B.Swapna closed {"id": "107255337668", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 00:02:20"}
27 16 16 1 107255337670 - 2025-07-02T09:25:13Z - Call Centre Partially Satisfied {"id": "107255337670", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "-", "time_stamp": "02-JUL-2025 14:55:13"}
28 16 16 2 107255337670 9154299704 2025-07-01T09:57:55Z Attended By Officer Musharfuddin rectify {"id": "107255337670", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 15:27:55"}
29 16 16 3 107255337670 9154299704 2025-07-01T05:56:26Z Under Process Musharfuddin under process {"id": "107255337670", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUL-2025 11:26:26"}
30 17 17 1 107255337671 9154299704 2025-07-01T08:38:09Z Attended By Officer Sri Narsing Rao k {"id": "107255337671", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "k", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 14:08:09"}
31 17 17 2 107255337671 9182540493 2025-06-30T19:02:48Z Open SYEDAZMATHULAH NON GLOWING OF STREET LIGHTS. {"id": "107255337671", "mobile_number": "9182540493", "posted_by": "SYEDAZMATHULAH", "remarks": "NON GLOWING OF STREET LIGHTS.", "status": "Open", "time_stamp": "01-JUL-2025 00:32:48"}
32 18 18 1 107255337672 7995007382 2025-07-02T02:54:50Z Attended By Officer Chitti Babu estimation. is submitted for sanction {"id": "107255337672", "mobile_number": "7995007382", "posted_by": "Chitti Babu", "remarks": "estimation. is submitted for sanction", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 08:24:50"}
33 21 21 1 107255337676 7569251193 2025-07-08T09:32:01Z Closed Call Centre Satisfied {"id": "107255337676", "mobile_number": "7569251193", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-JUL-2025 15:02:01"}
34 21 21 2 107255337676 9154909250 2025-07-03T02:21:16Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "107255337676", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "03-JUL-2025 07:51:16"}
35 21 21 3 107255337676 7569251193 2025-07-01T05:40:34Z Open Abdul Gafoor Citizen Called and Informed that the Grievance has been pending.So please take necessary action.Thank you Sir. {"id": "107255337676", "mobile_number": "7569251193", "posted_by": "Abdul Gafoor", "remarks": "Citizen Called and Informed that the Grievance has been pending.So please take necessary action.Thank you Sir.", "status": "Open", "time_stamp": "01-JUL-2025 11:10:34"}
36 23 23 1 107255337678 9704670163 2025-07-07T15:31:10Z Attended By Officer Sri. Rama rao rectified {"id": "107255337678", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "07-JUL-2025 21:01:10"}
37 23 23 2 107255337678 9398976971 2025-07-01T18:21:12Z Open Khairuddin none attended the request. I would urge the dept. folks to not close the tickets without attending it. {"id": "107255337678", "mobile_number": "9398976971", "posted_by": "Khairuddin", "remarks": "none attended the request. I would urge the dept. folks to not close the tickets without attending it.", "status": "Open", "time_stamp": "01-JUL-2025 23:51:12"}
38 23 23 3 107255337678 9704670163 2025-07-01T16:48:48Z Attended By Officer Sri. Rama rao rectified {"id": "107255337678", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 22:18:48"}
39 23 23 4 107255337678 9398976971 2025-07-01T06:49:38Z Open Khairuddin the area is, Khayyam Nagar, Attapur, pillar #177, Rajendra Nagar {"id": "107255337678", "mobile_number": "9398976971", "posted_by": "Khairuddin", "remarks": "the area is, Khayyam Nagar, Attapur, pillar #177, Rajendra Nagar", "status": "Open", "time_stamp": "01-JUL-2025 12:19:38"}
40 24 24 1 107255337679 - 2025-07-02T11:09:41Z - Call Centre Not Satisfied {"id": "107255337679", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "02-JUL-2025 16:39:41"}
41 24 24 2 107255337679 9154369429 2025-07-01T07:17:53Z Attended By Officer Dr.Srikanth caught 3dogs {"id": "107255337679", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "caught 3dogs", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 12:47:53"}
42 25 25 1 107255337680 9959552464 2025-07-03T18:04:03Z Attended By Officer T. Thirupathi Raju atteded {"id": "107255337680", "mobile_number": "9959552464", "posted_by": "T. Thirupathi Raju", "remarks": "atteded", "status": "Attended By Officer", "time_stamp": "03-JUL-2025 23:34:03"}
43 26 26 1 107255337681 9000115068 2025-07-01T12:31:29Z Attended By Officer Smt S Sravanthi rectified {"id": "107255337681", "mobile_number": "9000115068", "posted_by": "Smt S Sravanthi", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 18:01:29"}
44 28 28 1 107255337683 9959552464 2025-07-09T12:38:50Z Attended By Officer T. Thirupathi Raju fogging done {"id": "107255337683", "mobile_number": "9959552464", "posted_by": "T. Thirupathi Raju", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "09-JUL-2025 18:08:50"}
45 28 28 2 107255337683 9963844934 2025-07-03T14:44:39Z Open MD YOUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337683", "mobile_number": "9963844934", "posted_by": "MD YOUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "03-JUL-2025 20:14:39"}
46 28 28 3 107255337683 9963844934 2025-07-02T17:44:57Z Open MD YOUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337683", "mobile_number": "9963844934", "posted_by": "MD YOUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUL-2025 23:14:57"}
47 28 28 4 107255337683 9963844934 2025-07-02T12:36:28Z Open MD YOUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337683", "mobile_number": "9963844934", "posted_by": "MD YOUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUL-2025 18:06:28"}
48 28 28 5 107255337683 9963844934 2025-07-01T18:18:06Z Open MD YOUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337683", "mobile_number": "9963844934", "posted_by": "MD YOUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-JUL-2025 23:48:06"}
49 29 29 1 107255337684 - 2025-07-07T12:26:01Z - Call Centre Satisfied {"id": "107255337684", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "07-JUL-2025 17:56:01"}
50 29 29 2 107255337684 9346014249 2025-07-03T05:32:40Z Attended By Officer Dr.Bheekya Attendant complaint {"id": "107255337684", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "Attendant complaint", "status": "Attended By Officer", "time_stamp": "03-JUL-2025 11:02:40"}
51 29 29 3 107255337684 9963844934 2025-07-02T17:44:49Z Open OUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337684", "mobile_number": "9963844934", "posted_by": "OUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUL-2025 23:14:49"}
52 29 29 4 107255337684 9963844934 2025-07-02T12:35:05Z Open OUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337684", "mobile_number": "9963844934", "posted_by": "OUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUL-2025 18:05:05"}
53 29 29 5 107255337684 9963844934 2025-07-01T18:17:57Z Open OUSUF ZAKRIYA ZUBAIRI Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. {"id": "107255337684", "mobile_number": "9963844934", "posted_by": "OUSUF ZAKRIYA ZUBAIRI", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-JUL-2025 23:47:57"}
54 30 30 1 107255337685 9154299640 2025-07-08T10:41:40Z Attended By Officer Smt. M. Sushma retrieved {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "retrieved", "status": "Attended By Officer", "time_stamp": "08-JUL-2025 16:11:40"}
55 30 30 2 107255337685 9154768771 2025-07-07T05:32:59Z Open S.Kiranmayee other package {"id": "107255337685", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "other package", "status": "Open", "time_stamp": "07-JUL-2025 11:02:59"}
56 30 30 3 107255337685 9154299640 2025-07-05T10:00:38Z Open Smt. M. Sushma Forward {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Forward", "status": "Open", "time_stamp": "05-JUL-2025 15:30:38"}
57 30 30 4 107255337685 9154299640 2025-07-05T09:59:38Z Open Smt. M. Sushma Forward {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Forward", "status": "Open", "time_stamp": "05-JUL-2025 15:29:38"}
58 30 30 5 107255337685 9154299640 2025-07-05T09:57:52Z Open Smt. M. Sushma Forward {"id": "107255337685", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "Forward", "status": "Open", "time_stamp": "05-JUL-2025 15:27:52"}
59 31 31 1 107255337686 9951946143 2025-07-09T08:53:00Z Closed Call Centre Satisfied {"id": "107255337686", "mobile_number": "9951946143", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "09-JUL-2025 14:23:00"}
60 31 31 2 107255337686 7702775284 2025-07-02T10:30:55Z Attended By Officer B Ravindra rectified {"id": "107255337686", "mobile_number": "7702775284", "posted_by": "B Ravindra", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 16:00:55"}
61 32 32 1 107255337688 - 2025-07-02T11:18:10Z - Call Centre Satisfied {"id": "107255337688", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "02-JUL-2025 16:48:10"}
62 32 32 2 107255337688 9154369429 2025-07-01T07:17:04Z Attended By Officer Dr.Srikanth caught 3dogs {"id": "107255337688", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "caught 3dogs", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 12:47:04"}
63 34 34 1 107255337689 9154369423 2025-07-26T02:32:55Z Attended By Officer M.satyanarayana Reddy rectified {"id": "107255337689", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "26-JUL-2025 08:02:55"}
64 34 34 2 107255337689 9704234838 2025-07-01T03:32:08Z Open M Satya Narayana Reddy belongs to falaknama {"id": "107255337689", "mobile_number": "9704234838", "posted_by": "M Satya Narayana Reddy", "remarks": "belongs to falaknama", "status": "Open", "time_stamp": "01-JUL-2025 09:02:08"}
65 35 35 1 107255337690 9398662957 2025-07-25T14:56:04Z Submitted for Sanction Bhanu Teja Dear citizen a new cc road was submitted for sanction {"id": "107255337690", "mobile_number": "9398662957", "posted_by": "Bhanu Teja", "remarks": "Dear citizen a new cc road was submitted for sanction", "status": "Submitted for Sanction", "time_stamp": "25-JUL-2025 20:26:04"}
66 35 35 2 107255337690 7995009087 2025-07-12T19:24:51Z Open P.Prashanth ward 47 {"id": "107255337690", "mobile_number": "7995009087", "posted_by": "P.Prashanth", "remarks": "ward 47", "status": "Open", "time_stamp": "13-JUL-2025 00:54:51"}
67 35 35 3 107255337690 7994322365 2025-07-07T14:53:59Z Open Allisetty Srinesh please take n.a. {"id": "107255337690", "mobile_number": "7994322365", "posted_by": "Allisetty Srinesh", "remarks": "please take n.a.", "status": "Open", "time_stamp": "07-JUL-2025 20:23:59"}
68 37 37 1 107255337693 9154299704 2025-07-03T09:56:43Z Attended By Officer Musharfuddin rectify {"id": "107255337693", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "03-JUL-2025 15:26:43"}
69 37 37 2 107255337693 9154299704 2025-07-02T05:27:58Z Under Process Musharfuddin under process {"id": "107255337693", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "02-JUL-2025 10:57:58"}
70 37 37 3 107255337693 8555982593 2025-07-01T19:34:08Z Open Tauseef The Street Light is not glowing. {"id": "107255337693", "mobile_number": "8555982593", "posted_by": "Tauseef", "remarks": "The Street Light is not glowing.", "status": "Open", "time_stamp": "02-JUL-2025 01:04:08"}
71 37 37 4 107255337693 9154299704 2025-07-01T10:03:58Z Attended By Officer Musharfuddin rectify {"id": "107255337693", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 15:33:58"}
72 37 37 5 107255337693 9154299704 2025-07-01T09:06:02Z Under Process Musharfuddin under process {"id": "107255337693", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUL-2025 14:36:02"}
73 38 38 1 107255337692 8008060477 2025-07-09T12:24:02Z Attended By Officer N.Uday Kiran my team will contact shortly to rectify mosquito means problem {"id": "107255337692", "mobile_number": "8008060477", "posted_by": "N.Uday Kiran", "remarks": "my team will contact shortly to rectify mosquito means problem", "status": "Attended By Officer", "time_stamp": "09-JUL-2025 17:54:02"}
74 38 38 2 107255337692 7993360295 2025-07-01T11:32:25Z Open M.Satish Kumar circle 11 {"id": "107255337692", "mobile_number": "7993360295", "posted_by": "M.Satish Kumar", "remarks": "circle 11", "status": "Open", "time_stamp": "01-JUL-2025 17:02:25"}
75 39 39 1 107255337694 9989930451 2025-07-16T16:11:50Z Attended By Officer B.Uma Rani attended {"id": "107255337694", "mobile_number": "9989930451", "posted_by": "B.Uma Rani", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "16-JUL-2025 21:41:50"}
76 40 40 1 107255337695 - 2025-07-02T11:39:32Z - Call Centre Not Satisfied {"id": "107255337695", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "02-JUL-2025 17:09:32"}
77 40 40 2 107255337695 9154931430 2025-07-01T02:36:02Z Attended By Officer Dr .M Kavitha clear {"id": "107255337695", "mobile_number": "9154931430", "posted_by": "Dr .M Kavitha", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 08:06:02"}
78 41 41 1 107255337696 - 2025-07-02T11:40:19Z - Call Centre Satisfied {"id": "107255337696", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "02-JUL-2025 17:10:19"}
79 41 41 2 107255337696 9989930592 2025-07-02T05:26:23Z Attended By Officer B.Swapna rectify sir {"id": "107255337696", "mobile_number": "9989930592", "posted_by": "B.Swapna", "remarks": "rectify sir", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 10:56:23"}
80 43 43 1 107255337698 8790097163 2025-07-15T09:40:33Z Closed Call Centre Not Satisfied {"id": "107255337698", "mobile_number": "8790097163", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "15-JUL-2025 15:10:33"}
81 43 43 2 107255337698 7989301584 2025-07-02T00:31:00Z Attended By Officer Dr.K.Manjula garbage lifting {"id": "107255337698", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "garbage lifting", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 06:01:00"}
82 46 46 1 107255337701 9908021829 2025-10-12T04:17:47Z Closed Call Centre Satisfied {"id": "107255337701", "mobile_number": "9908021829", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "12-OCT-2025 09:47:47"}
83 46 46 2 107255337701 6309919070 2025-10-11T08:50:52Z Attended By Officer DRF TEAM cleared {"id": "107255337701", "mobile_number": "6309919070", "posted_by": "DRF TEAM", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "11-OCT-2025 14:20:52"}
84 46 46 3 107255337701 9505107172 2025-07-02T12:44:37Z Open Maheshwari DRF {"id": "107255337701", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "DRF", "status": "Open", "time_stamp": "02-JUL-2025 18:14:37"}
85 47 47 1 107255337702 9505107172 2025-07-02T13:15:54Z Closed Maheshwari electric {"id": "107255337702", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "electric", "status": "Closed", "time_stamp": "02-JUL-2025 18:45:54"}
86 49 49 1 107255337704 - 2025-07-02T11:41:13Z - Call Centre Partially Satisfied {"id": "107255337704", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "-", "time_stamp": "02-JUL-2025 17:11:13"}
87 49 49 2 107255337704 9121245035 2025-07-02T05:26:36Z Attended By Officer Sri K. Raghupathi reddy box problem is clear {"id": "107255337704", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "box problem is clear", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 10:56:36"}
88 50 50 1 107255337705 7995077953 2025-07-02T02:53:41Z Closed Sri. Kalyan hmwssb department {"id": "107255337705", "mobile_number": "7995077953", "posted_by": "Sri. Kalyan", "remarks": "hmwssb department", "status": "Closed", "time_stamp": "02-JUL-2025 08:23:41"}
89 51 51 1 107255337706 - 2025-07-02T11:36:13Z - Call Centre Not Satisfied {"id": "107255337706", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "02-JUL-2025 17:06:13"}
90 51 51 2 107255337706 7997951610 2025-07-01T09:51:36Z Attended By Officer Falaknuma clear {"id": "107255337706", "mobile_number": "7997951610", "posted_by": "Falaknuma", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 15:21:36"}
91 53 53 1 107255337708 8074413745 2025-07-02T06:01:30Z Open Smt.G.Joshna Priyadharshini by lifting {"id": "107255337708", "mobile_number": "8074413745", "posted_by": "Smt.G.Joshna Priyadharshini", "remarks": "by lifting", "status": "Open", "time_stamp": "02-JUL-2025 11:31:30"}
92 53 53 2 107255337708 7997951617 2025-07-02T05:23:41Z Open Kharathabad . {"id": "107255337708", "mobile_number": "7997951617", "posted_by": "Kharathabad", "remarks": ".", "status": "Open", "time_stamp": "02-JUL-2025 10:53:41"}
93 54 54 1 107255337709 - 2025-07-02T06:21:24Z - Call Centre Satisfied {"id": "107255337709", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "02-JUL-2025 11:51:24"}
94 54 54 2 107255337709 8019918839 2025-07-01T12:31:42Z Attended By Officer Sri S Lokesh Kumar Good afternoon madam this complent is clear {"id": "107255337709", "mobile_number": "8019918839", "posted_by": "Sri S Lokesh Kumar", "remarks": "Good afternoon madam this complent is clear", "status": "Attended By Officer", "time_stamp": "01-JUL-2025 18:01:42"}
95 55 55 1 107255337710 - 2025-07-04T12:02:51Z - Call Centre Satisfied {"id": "107255337710", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "04-JUL-2025 17:32:51"}
96 55 55 2 107255337710 6309999493 2025-07-02T13:49:18Z Attended By Officer Dr M Jyothi bai clear {"id": "107255337710", "mobile_number": "6309999493", "posted_by": "Dr M Jyothi bai", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "02-JUL-2025 19:19:18"}
97 58 58 1 107255337712 7331151746 2025-07-14T04:15:03Z Closed N.Prashant pertains to HMWSSB.Thank you {"id": "107255337712", "mobile_number": "7331151746", "posted_by": "N.Prashant", "remarks": "pertains to HMWSSB.Thank you", "status": "Closed", "time_stamp": "14-JUL-2025 09:45:03"}
98 58 58 2 107255337712 8008556852 2025-07-13T08:16:58Z Open Sri E. Nagi Reddy Pertains to engineering department {"id": "107255337712", "mobile_number": "8008556852", "posted_by": "Sri E. Nagi Reddy", "remarks": "Pertains to engineering department", "status": "Open", "time_stamp": "13-JUL-2025 13:46:58"}
99 59 59 1 107255337715 8008103629 2025-07-01T11:57:34Z Closed A. Srinivas tgspdcl {"id": "107255337715", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "tgspdcl", "status": "Closed", "time_stamp": "01-JUL-2025 17:27:34"}
100 59 59 2 107255337715 9441437616 2025-07-01T05:40:55Z Open Smt. K.Sameera n {"id": "107255337715", "mobile_number": "9441437616", "posted_by": "Smt. K.Sameera", "remarks": "n", "status": "Open", "time_stamp": "01-JUL-2025 11:10:55"}

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