snapshot_comments

73,968 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: ordinal, status_text, 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 112255596088 9247389884 2025-12-03T04:27:13Z Closed Call Centre Satisfied {"id": "112255596088", "mobile_number": "9247389884", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "03-DEC-2025 09:57:13"}
2 1 1 2 112255596088 8332045454 2025-12-02T10:24:41Z Attended By Officer Sri. Rama rao rectified {"id": "112255596088", "mobile_number": "8332045454", "posted_by": "Sri. Rama rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 15:54:41"}
3 2 2 1 112255596089 9701365515 2025-12-01T01:33:46Z Attended By Officer Sri Venkatesh Dy.EE(SWM) vlear {"id": "112255596089", "mobile_number": "9701365515", "posted_by": "Sri Venkatesh Dy.EE(SWM)", "remarks": "vlear", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 07:03:46"}
4 3 3 1 112255596090 6300987583 2025-12-05T08:54:35Z Attended By Officer Dr Agnivesh Dear citizen your grevience Attended caught 1dog and noticed 2sterilized dog's as per awbi norms we will not catch them please {"id": "112255596090", "mobile_number": "6300987583", "posted_by": "Dr Agnivesh", "remarks": "Dear citizen your grevience Attended caught 1dog and noticed 2sterilized dog's as per awbi norms we will not catch them please", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 14:24:35"}
5 4 4 1 112255596091 9000541595 2025-12-02T06:22:28Z Closed Orsu Santhosh this is bilongs to Hmwssb {"id": "112255596091", "mobile_number": "9000541595", "posted_by": "Orsu Santhosh", "remarks": "this is bilongs to Hmwssb", "status": "Closed", "time_stamp": "02-DEC-2025 11:52:28"}
6 5 5 1 112255596092 9640809791 2025-12-04T09:06:20Z Closed Call Centre Not Satisfied {"id": "112255596092", "mobile_number": "9640809791", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 14:36:20"}
7 5 5 2 112255596092 9154295249 2025-12-03T06:33:37Z Attended By Officer Sai Chandana rectified {"id": "112255596092", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 12:03:37"}
8 6 6 1 112255596093 7995007396 2026-03-10T13:25:57Z Attended By Officer K.satyalakshmi work will takenup administrative sanction {"id": "112255596093", "mobile_number": "7995007396", "posted_by": "K.satyalakshmi", "remarks": "work will takenup administrative sanction", "status": "Attended By Officer", "time_stamp": "10-MAR-2026 18:55:57"}
9 6 6 2 112255596093 9908003111 2026-02-13T10:44:39Z Open Call Centre Not Satisfied {"id": "112255596093", "mobile_number": "9908003111", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "13-FEB-2026 16:14:39"}
10 6 6 3 112255596093 7995007396 2026-02-10T13:35:02Z Attended By Officer K.satyalakshmi work will be taken up by administrative sanction {"id": "112255596093", "mobile_number": "7995007396", "posted_by": "K.satyalakshmi", "remarks": "work will be taken up by administrative sanction", "status": "Attended By Officer", "time_stamp": "10-FEB-2026 19:05:02"}
11 7 7 1 112255596094 9908003111 2026-02-25T06:16:46Z Closed Call Centre Not Satisfied {"id": "112255596094", "mobile_number": "9908003111", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "25-FEB-2026 11:46:46"}
12 7 7 2 112255596094 7995007396 2026-02-10T07:48:20Z Attended By Officer K.satyalakshmi sir shortly repair {"id": "112255596094", "mobile_number": "7995007396", "posted_by": "K.satyalakshmi", "remarks": "sir shortly repair", "status": "Attended By Officer", "time_stamp": "10-FEB-2026 13:18:20"}
13 7 7 3 112255596094 7995007396 2026-02-10T07:47:17Z Open K.satyalakshmi sir partains to yapral {"id": "112255596094", "mobile_number": "7995007396", "posted_by": "K.satyalakshmi", "remarks": "sir partains to yapral", "status": "Open", "time_stamp": "10-FEB-2026 13:17:17"}
14 7 7 4 112255596094 7995007396 2026-02-10T07:46:18Z Open K.satyalakshmi sir partains to ward no.189 {"id": "112255596094", "mobile_number": "7995007396", "posted_by": "K.satyalakshmi", "remarks": "sir partains to ward no.189", "status": "Open", "time_stamp": "10-FEB-2026 13:16:18"}
15 8 8 1 112255596095 9908003111 2026-01-14T09:41:01Z Closed Call Centre Satisfied {"id": "112255596095", "mobile_number": "9908003111", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "14-JAN-2026 15:11:01"}
16 8 8 2 112255596095 9505107172 2025-12-06T10:58:23Z Attended By Officer Smt. P.Maheshwari sir, we are now given only plants, last already given to your colony...GHMC are planting in rainy season {"id": "112255596095", "mobile_number": "9505107172", "posted_by": "Smt. P.Maheshwari", "remarks": "sir, we are now given only plants, last already given to your colony...GHMC are planting in rainy season", "status": "Attended By Officer", "time_stamp": "06-DEC-2025 16:28:23"}
17 9 9 1 112255596096 8978627860 2025-12-02T04:08:25Z Closed Call Centre Not Satisfied {"id": "112255596096", "mobile_number": "8978627860", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-DEC-2025 09:38:25"}
18 9 9 2 112255596096 9346014249 2025-12-01T05:42:22Z Attended By Officer Dr.Bheekya Attend complaint {"id": "112255596096", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "Attend complaint", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 11:12:22"}
19 10 10 1 112255596097 8919603356 2025-12-10T06:00:00Z Closed Call Centre Satisfied {"id": "112255596097", "mobile_number": "8919603356", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "10-DEC-2025 11:30:00"}
20 10 10 2 112255596097 9963895117 2025-12-03T22:27:12Z Attended By Officer Sri K.Mallikarjun Rao Closed as not mentioned any location details {"id": "112255596097", "mobile_number": "9963895117", "posted_by": "Sri K.Mallikarjun Rao", "remarks": "Closed as not mentioned any location details", "status": "Attended By Officer", "time_stamp": "04-DEC-2025 03:57:12"}
21 11 11 1 112255596098 9515660479 2025-12-04T03:07:35Z Attended By Officer V.Arun Kumar Fogging Done {"id": "112255596098", "mobile_number": "9515660479", "posted_by": "V.Arun Kumar", "remarks": "Fogging Done", "status": "Attended By Officer", "time_stamp": "04-DEC-2025 08:37:35"}
22 11 11 2 112255596098 8179984142 2025-12-03T05:22:55Z Open Call Centre Not Satisfied {"id": "112255596098", "mobile_number": "8179984142", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "03-DEC-2025 10:52:55"}
23 11 11 3 112255596098 9515660479 2025-12-01T16:57:01Z Attended By Officer V.Arun Kumar fogging done {"id": "112255596098", "mobile_number": "9515660479", "posted_by": "V.Arun Kumar", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 22:27:01"}
24 12 12 1 112255596099 7893507177 2025-12-05T09:25:59Z Closed Call Centre Partially Satisfied {"id": "112255596099", "mobile_number": "7893507177", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "Closed", "time_stamp": "05-DEC-2025 14:55:59"}
25 12 12 2 112255596099 9154369429 2025-12-03T06:02:31Z Attended By Officer Dr.Srikanth Operat d dogs cannot be catched as per High court order {"id": "112255596099", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "Operat d dogs cannot be catched as per High court order", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 11:32:31"}
26 13 13 1 112255596100 9381007096 2025-12-02T10:57:36Z Closed ali Good work {"id": "112255596100", "mobile_number": "9381007096", "posted_by": "ali", "remarks": "Good work", "status": "Closed", "time_stamp": "02-DEC-2025 16:27:36"}
27 13 13 2 112255596100 8712499192 2025-12-02T08:38:02Z Attended By Officer Smt K. Lavanya rectified {"id": "112255596100", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 14:08:02"}
28 13 13 3 112255596100 8712499192 2025-12-01T01:34:51Z Under Process Smt K. Lavanya under process {"id": "112255596100", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "under process", "status": "Under Process", "time_stamp": "01-DEC-2025 07:04:51"}
29 14 14 1 112255596102 9154369429 2025-12-04T04:54:06Z Attended By Officer Dr.Srikanth The caught dogs will be done ABC ARV and will be released at the same place where we caught {"id": "112255596102", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "The caught dogs will be done ABC ARV and will be released at the same place where we caught", "status": "Attended By Officer", "time_stamp": "04-DEC-2025 10:24:06"}
30 14 14 2 112255596102 9550164264 2025-12-03T11:16:57Z Open Call Centre Not Satisfied {"id": "112255596102", "mobile_number": "9550164264", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "03-DEC-2025 16:46:57"}
31 14 14 3 112255596102 9154369429 2025-12-01T05:42:05Z Attended By Officer Dr.Srikanth caught 3dogs {"id": "112255596102", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "caught 3dogs", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 11:12:05"}
32 15 15 1 112255596101 9014761027 2025-12-06T08:36:45Z Closed Call Centre Satisfied {"id": "112255596101", "mobile_number": "9014761027", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "06-DEC-2025 14:06:45"}
33 15 15 2 112255596101 9063816967 2025-12-01T09:24:54Z Attended By Officer Dr Dipankar Pal attended {"id": "112255596101", "mobile_number": "9063816967", "posted_by": "Dr Dipankar Pal", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 14:54:54"}
34 15 15 3 112255596101 9063816967 2025-12-01T01:11:59Z Under Process Dr Dipankar Pal under process {"id": "112255596101", "mobile_number": "9063816967", "posted_by": "Dr Dipankar Pal", "remarks": "under process", "status": "Under Process", "time_stamp": "01-DEC-2025 06:41:59"}
35 16 16 1 112255596103 7330656945 2025-12-01T10:41:51Z Closed Sri. G. Dheeraj k {"id": "112255596103", "mobile_number": "7330656945", "posted_by": "Sri. G. Dheeraj", "remarks": "k", "status": "Closed", "time_stamp": "01-DEC-2025 16:11:51"}
36 17 17 1 112255596104 8121041420 2025-12-02T05:30:03Z Attended By Officer Dr.Abdul Basith sir atteand a complent cot by Abc {"id": "112255596104", "mobile_number": "8121041420", "posted_by": "Dr.Abdul Basith", "remarks": "sir atteand a complent cot by Abc", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 11:00:03"}
37 17 17 2 112255596104 9014524746 2025-12-02T04:09:36Z Open Call Centre Not Satisfied {"id": "112255596104", "mobile_number": "9014524746", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "02-DEC-2025 09:39:36"}
38 17 17 3 112255596104 8121041420 2025-12-01T03:53:39Z Attended By Officer Dr.Abdul Basith Sir attended a complaint and caught dogs for arv {"id": "112255596104", "mobile_number": "8121041420", "posted_by": "Dr.Abdul Basith", "remarks": "Sir attended a complaint and caught dogs for arv", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 09:23:39"}
39 18 18 1 112255596105 8008880102 2025-12-04T09:23:50Z Closed Call Centre Not Satisfied {"id": "112255596105", "mobile_number": "8008880102", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 14:53:50"}
40 18 18 2 112255596105 9000744055 2025-12-02T07:52:07Z Attended By Officer K. Mohan Rao sorry for the inconvenience {"id": "112255596105", "mobile_number": "9000744055", "posted_by": "K. Mohan Rao", "remarks": "sorry for the inconvenience", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 13:22:07"}
41 19 19 1 112255596106 8074004250 2025-12-03T09:28:42Z Attended By Officer Satya narayana rectified {"id": "112255596106", "mobile_number": "8074004250", "posted_by": "Satya narayana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 14:58:42"}
42 19 19 2 112255596106 7731927044 2025-12-03T04:28:03Z Open Call Centre Not Satisfied {"id": "112255596106", "mobile_number": "7731927044", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "03-DEC-2025 09:58:03"}
43 19 19 3 112255596106 8074004250 2025-12-02T09:44:21Z Attended By Officer Satya narayana rectified {"id": "112255596106", "mobile_number": "8074004250", "posted_by": "Satya narayana", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 15:14:21"}
44 20 20 1 112255596107 9849029881 2025-12-02T08:11:13Z Closed Call Centre Satisfied {"id": "112255596107", "mobile_number": "9849029881", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-DEC-2025 13:41:13"}
45 20 20 2 112255596107 8712499192 2025-12-01T10:05:09Z Attended By Officer Smt K. Lavanya rectify {"id": "112255596107", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "rectify", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 15:35:09"}
46 20 20 3 112255596107 8712499192 2025-12-01T01:36:18Z Under Process Smt K. Lavanya under process {"id": "112255596107", "mobile_number": "8712499192", "posted_by": "Smt K. Lavanya", "remarks": "under process", "status": "Under Process", "time_stamp": "01-DEC-2025 07:06:18"}
47 21 21 1 112255596108 9949994049 2025-12-27T06:58:22Z Attended By Officer E. SURENDER REDDY This office has issued show cause notice and further action will be taken {"id": "112255596108", "mobile_number": "9949994049", "posted_by": "E. SURENDER REDDY", "remarks": "This office has issued show cause notice and further action will be taken", "status": "Attended By Officer", "time_stamp": "27-DEC-2025 12:28:22"}
48 21 21 2 112255596108 9866589490 2025-12-12T11:59:32Z Open Call Centre Not Satisfied {"id": "112255596108", "mobile_number": "9866589490", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Open", "time_stamp": "12-DEC-2025 17:29:32"}
49 21 21 3 112255596108 9949994049 2025-12-05T06:29:03Z Attended By Officer E. SURENDER REDDY This office has inspected the site and further necessary action will be taken {"id": "112255596108", "mobile_number": "9949994049", "posted_by": "E. SURENDER REDDY", "remarks": "This office has inspected the site and further necessary action will be taken", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 11:59:03"}
50 21 21 4 112255596108 9866589490 2025-12-02T11:14:30Z Open pavan Height of the building is too much and damaging My house and encouragement to road {"id": "112255596108", "mobile_number": "9866589490", "posted_by": "pavan", "remarks": "Height of the building is too much and damaging My house and encouragement to road", "status": "Open", "time_stamp": "02-DEC-2025 16:44:30"}
51 21 21 5 112255596108 9949994049 2025-12-02T11:03:46Z Attended By Officer E. SURENDER REDDY This office will inspect the site and take further necessary action {"id": "112255596108", "mobile_number": "9949994049", "posted_by": "E. SURENDER REDDY", "remarks": "This office will inspect the site and take further necessary action", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 16:33:46"}
52 21 21 6 112255596108 9866589490 2025-12-01T00:30:25Z Open pavan over height of the building than the cc road is effecting neighbours. 4 to 5 feet height than neighbour so their water or seepage will damage our premises. please try to understand street dogs are jumping or the wall and damage My belongings and disturb the sleep in the mid night. {"id": "112255596108", "mobile_number": "9866589490", "posted_by": "pavan", "remarks": "over height of the building than the cc road is effecting neighbours. 4 to 5 feet height than neighbour so their water or seepage will damage our premises. please try to understand street dogs are jumping or the wall and damage My belongings and disturb the sleep in the mid night.", "status": "Open", "time_stamp": "01-DEC-2025 06:00:25"}
53 22 22 1 112255596109 9494566137 2025-12-03T23:41:43Z Closed A. Srikanth goud This is the issue of 2016 did not resolved {"id": "112255596109", "mobile_number": "9494566137", "posted_by": "A. Srikanth goud", "remarks": "This is the issue of 2016 did not resolved", "status": "Closed", "time_stamp": "04-DEC-2025 05:11:43"}
54 22 22 2 112255596109 9154931422 2025-12-03T08:02:08Z Attended By Officer Dr.Chandra Shekar clear {"id": "112255596109", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 13:32:08"}
55 22 22 3 112255596109 9704456422 2025-12-01T02:46:04Z Open Sri. S . Srinivas SAT EMI complaint {"id": "112255596109", "mobile_number": "9704456422", "posted_by": "Sri. S . Srinivas", "remarks": "SAT EMI complaint", "status": "Open", "time_stamp": "01-DEC-2025 08:16:04"}
56 23 23 1 112255596110 9505085112 2025-12-01T03:45:50Z Closed Sri Dr.Nagesh Naik forward {"id": "112255596110", "mobile_number": "9505085112", "posted_by": "Sri Dr.Nagesh Naik", "remarks": "forward", "status": "Closed", "time_stamp": "01-DEC-2025 09:15:50"}
57 24 24 1 112255596111 9505107172 2025-12-01T08:54:22Z Closed Smt. P.Maheshwari TGSPDCL electrical {"id": "112255596111", "mobile_number": "9505107172", "posted_by": "Smt. P.Maheshwari", "remarks": "TGSPDCL electrical", "status": "Closed", "time_stamp": "01-DEC-2025 14:24:22"}
58 27 27 1 112255596114 9949015699 2025-12-01T08:43:42Z Closed Call Centre Satisfied {"id": "112255596114", "mobile_number": "9949015699", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "01-DEC-2025 14:13:42"}
59 27 27 2 112255596114 8008103629 2025-12-01T05:21:32Z Attended By Officer A. Srinivas attend {"id": "112255596114", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 10:51:32"}
60 27 27 3 112255596114 8125218065 2025-12-01T04:47:38Z Open Dr. Srikanth Reddy chanda nagar -21 {"id": "112255596114", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "chanda nagar -21", "status": "Open", "time_stamp": "01-DEC-2025 10:17:38"}
61 28 28 1 112255596115 9000119969 2025-12-03T04:24:20Z Closed Call Centre Satisfied {"id": "112255596115", "mobile_number": "9000119969", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "03-DEC-2025 09:54:20"}
62 28 28 2 112255596115 9154909250 2025-12-01T02:27:48Z Attended By Officer Dr.Md Irshad Iqbal Resolved {"id": "112255596115", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Resolved", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 07:57:48"}
63 29 29 1 112255596116 9000100556 2025-12-02T04:11:09Z Closed Call Centre Partially Satisfied {"id": "112255596116", "mobile_number": "9000100556", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "Closed", "time_stamp": "02-DEC-2025 09:41:09"}
64 29 29 2 112255596116 8500496801 2025-12-01T07:20:00Z Attended By Officer Smt R Shirisha rectified {"id": "112255596116", "mobile_number": "8500496801", "posted_by": "Smt R Shirisha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 12:50:00"}
65 32 32 1 112255596119 7842136224 2025-12-08T10:10:30Z Closed Call Centre Satisfied {"id": "112255596119", "mobile_number": "7842136224", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-DEC-2025 15:40:30"}
66 32 32 2 112255596119 7337364206 2025-12-01T03:32:10Z Attended By Officer Sai Tharun DYEE(SWM) Complete Attend {"id": "112255596119", "mobile_number": "7337364206", "posted_by": "Sai Tharun DYEE(SWM)", "remarks": "Complete Attend", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 09:02:10"}
67 34 34 1 112255596121 9849490333 2025-12-04T08:56:14Z Closed Call Centre Satisfied {"id": "112255596121", "mobile_number": "9849490333", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 14:26:14"}
68 34 34 2 112255596121 7997951601 2025-12-01T02:40:05Z Attended By Officer Kapra clear {"id": "112255596121", "mobile_number": "7997951601", "posted_by": "Kapra", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 08:10:05"}
69 35 35 1 112255596122 9000100058 2025-12-03T02:26:28Z Attended By Officer Smt Anuradha clear {"id": "112255596122", "mobile_number": "9000100058", "posted_by": "Smt Anuradha", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 07:56:28"}
70 35 35 2 112255596122 7995009087 2025-12-02T09:46:51Z Open P.Prashanth garbage {"id": "112255596122", "mobile_number": "7995009087", "posted_by": "P.Prashanth", "remarks": "garbage", "status": "Open", "time_stamp": "02-DEC-2025 15:16:51"}
71 35 35 3 112255596122 9000100058 2025-12-01T03:30:19Z Open Smt Anuradha need cap for manhole square {"id": "112255596122", "mobile_number": "9000100058", "posted_by": "Smt Anuradha", "remarks": "need cap for manhole square", "status": "Open", "time_stamp": "01-DEC-2025 09:00:19"}
72 36 36 1 112255596123 8885264284 2025-12-07T05:11:46Z Closed Call Centre Not Satisfied {"id": "112255596123", "mobile_number": "8885264284", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "07-DEC-2025 10:41:46"}
73 36 36 2 112255596123 9247540129 2025-12-03T06:51:01Z Attended By Officer Dr Sanjay sir Attended a complaint {"id": "112255596123", "mobile_number": "9247540129", "posted_by": "Dr Sanjay", "remarks": "sir Attended a complaint", "status": "Attended By Officer", "time_stamp": "03-DEC-2025 12:21:01"}
74 37 37 1 112255596124 9440946919 2025-12-10T09:07:53Z Closed Call Centre Not Satisfied {"id": "112255596124", "mobile_number": "9440946919", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "10-DEC-2025 14:37:53"}
75 37 37 2 112255596124 9154369439 2025-12-05T14:34:33Z Attended By Officer Likhitha closed this moosapet circle not lingampally circle please current location submit in moosapet circle {"id": "112255596124", "mobile_number": "9154369439", "posted_by": "Likhitha", "remarks": "closed this moosapet circle not lingampally circle please current location submit in moosapet circle", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 20:04:33"}
76 37 37 3 112255596124 9154299640 2025-12-03T05:56:00Z Open Smt. M. Sushma forward {"id": "112255596124", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "forward", "status": "Open", "time_stamp": "03-DEC-2025 11:26:00"}
77 38 38 1 112255596125 8019918839 2025-12-17T01:51:19Z Closed Sri S Lokesh Kumar tgspdcl electrical wing {"id": "112255596125", "mobile_number": "8019918839", "posted_by": "Sri S Lokesh Kumar", "remarks": "tgspdcl electrical wing", "status": "Closed", "time_stamp": "17-DEC-2025 07:21:19"}
78 40 40 1 112255596127 9533438350 2025-12-04T09:44:30Z Closed Call Centre Satisfied {"id": "112255596127", "mobile_number": "9533438350", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 15:14:30"}
79 40 40 2 112255596127 9701365515 2025-12-01T04:41:18Z Attended By Officer Sri Venkatesh Dy.EE(SWM) clear {"id": "112255596127", "mobile_number": "9701365515", "posted_by": "Sri Venkatesh Dy.EE(SWM)", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 10:11:18"}
80 41 41 1 112255596128 9059996963 2025-12-02T07:20:20Z Closed Call Centre Satisfied {"id": "112255596128", "mobile_number": "9059996963", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-DEC-2025 12:50:20"}
81 41 41 2 112255596128 8500452291 2025-12-01T10:43:09Z Attended By Officer Smt.V.Praveena tree branches cutting by TGSPDCL department not ghmc {"id": "112255596128", "mobile_number": "8500452291", "posted_by": "Smt.V.Praveena", "remarks": "tree branches cutting by TGSPDCL department not ghmc", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 16:13:09"}
82 41 41 3 112255596128 9703336064 2025-12-01T06:24:48Z Open Smt. Dr. Rajini forward {"id": "112255596128", "mobile_number": "9703336064", "posted_by": "Smt. Dr. Rajini", "remarks": "forward", "status": "Open", "time_stamp": "01-DEC-2025 11:54:48"}
83 41 41 4 112255596128 8500452291 2025-12-01T05:12:19Z Open Smt.V.Praveena electrical department has cutting this branches, please cleare {"id": "112255596128", "mobile_number": "8500452291", "posted_by": "Smt.V.Praveena", "remarks": "electrical department has cutting this branches, please cleare", "status": "Open", "time_stamp": "01-DEC-2025 10:42:19"}
84 42 42 1 112255596129 8328202608 2025-12-03T05:24:57Z Closed Call Centre Satisfied {"id": "112255596129", "mobile_number": "8328202608", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "03-DEC-2025 10:54:57"}
85 42 42 2 112255596129 9703336064 2025-12-02T07:19:36Z Attended By Officer Smt. Dr. Rajini resolved {"id": "112255596129", "mobile_number": "9703336064", "posted_by": "Smt. Dr. Rajini", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 12:49:36"}
86 42 42 3 112255596129 8328202608 2025-12-01T13:54:01Z Open bhaskar Reddy Not lifted {"id": "112255596129", "mobile_number": "8328202608", "posted_by": "bhaskar Reddy", "remarks": "Not lifted", "status": "Open", "time_stamp": "01-DEC-2025 19:24:01"}
87 42 42 4 112255596129 9703336064 2025-12-01T06:23:40Z Attended By Officer Smt. Dr. Rajini resolved {"id": "112255596129", "mobile_number": "9703336064", "posted_by": "Smt. Dr. Rajini", "remarks": "resolved", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 11:53:40"}
88 43 43 1 112255596130 7097056708 2025-12-04T09:07:56Z Closed Call Centre Satisfied {"id": "112255596130", "mobile_number": "7097056708", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "04-DEC-2025 14:37:56"}
89 43 43 2 112255596130 9154931422 2025-12-02T04:49:59Z Attended By Officer Dr.Chandra Shekar clear {"id": "112255596130", "mobile_number": "9154931422", "posted_by": "Dr.Chandra Shekar", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 10:19:59"}
90 44 44 1 112255596131 9008440173 2025-12-03T06:01:33Z Closed Call Centre Satisfied {"id": "112255596131", "mobile_number": "9008440173", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "03-DEC-2025 11:31:33"}
91 44 44 2 112255596131 9885198396 2025-12-02T07:14:52Z Attended By Officer Dr. Vijay Mohan Rao cleared {"id": "112255596131", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "cleared", "status": "Attended By Officer", "time_stamp": "02-DEC-2025 12:44:52"}
92 45 45 1 112255596132 9008440173 2025-12-02T04:10:47Z Closed Call Centre Satisfied {"id": "112255596132", "mobile_number": "9008440173", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-DEC-2025 09:40:47"}
93 45 45 2 112255596132 9154909245 2025-12-01T13:23:01Z Attended By Officer K Tirupathaiah Complaint attended sir {"id": "112255596132", "mobile_number": "9154909245", "posted_by": "K Tirupathaiah", "remarks": "Complaint attended sir", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 18:53:01"}
94 46 46 1 112255596133 9849276865 2025-12-01T04:10:43Z Attended By Officer Dr Gopal Mahajan attended {"id": "112255596133", "mobile_number": "9849276865", "posted_by": "Dr Gopal Mahajan", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 09:40:43"}
95 47 47 1 112255596135 7995009083 2025-12-01T07:53:15Z Closed Sri S Rajiv hmws and sb {"id": "112255596135", "mobile_number": "7995009083", "posted_by": "Sri S Rajiv", "remarks": "hmws and sb", "status": "Closed", "time_stamp": "01-DEC-2025 13:23:15"}
96 48 48 1 112255596134 7995009108 2025-12-05T10:21:26Z Closed Sri. Kaushik it's pertains to electricity {"id": "112255596134", "mobile_number": "7995009108", "posted_by": "Sri. Kaushik", "remarks": "it's pertains to electricity", "status": "Closed", "time_stamp": "05-DEC-2025 15:51:26"}
97 49 49 1 112255596136 9573666426 2025-12-06T08:34:41Z Closed Call Centre Not Satisfied {"id": "112255596136", "mobile_number": "9573666426", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "06-DEC-2025 14:04:41"}
98 49 49 2 112255596136 9866511388 2025-12-01T09:46:10Z Attended By Officer Sri B Ravindra re {"id": "112255596136", "mobile_number": "9866511388", "posted_by": "Sri B Ravindra", "remarks": "re", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 15:16:10"}
99 50 50 1 112255596137 7995009108 2025-12-05T09:37:42Z Closed Sri. Kaushik . {"id": "112255596137", "mobile_number": "7995009108", "posted_by": "Sri. Kaushik", "remarks": ".", "status": "Closed", "time_stamp": "05-DEC-2025 15:07:42"}
100 50 50 2 112255596137 8712013112 2025-12-04T03:01:20Z Open Sri Kancharla Bhargav, Dy.EE(SWM) ENGINEERING SECTION ELECTION DEPARTMENT {"id": "112255596137", "mobile_number": "8712013112", "posted_by": "Sri Kancharla Bhargav, Dy.EE(SWM)", "remarks": "ENGINEERING SECTION ELECTION DEPARTMENT", "status": "Open", "time_stamp": "04-DEC-2025 08:31:20"}

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