snapshot_comments
70,834 rows
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 | 106255287896 | 9642841166 | 2025-06-08T02:22:10Z | Closed | kiran | - | {"id": "106255287896", "mobile_number": "9642841166", "posted_by": "kiran", "remarks": "-", "status": "Closed", "time_stamp": "08-JUN-2025 07:52:10"} |
| 2 | 1 1 | 2 | 106255287896 | - | 2025-06-05T10:51:46Z | - | Call Centre | Not Satisfied | {"id": "106255287896", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-JUN-2025 16:21:46"} |
| 3 | 1 1 | 3 | 106255287896 | - | 2025-06-03T06:25:58Z | Attended By Officer | Ward134 | work is completed | {"id": "106255287896", "mobile_number": "-", "posted_by": "Ward134", "remarks": "work is completed", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 11:55:58"} |
| 4 | 1 1 | 4 | 106255287896 | 9000115068 | 2025-06-02T04:24:02Z | Under Process | Smt S Sravanthi | same complaint received more than one time. | {"id": "106255287896", "mobile_number": "9000115068", "posted_by": "Smt S Sravanthi", "remarks": "same complaint received more than one time.", "status": "Under Process", "time_stamp": "02-JUN-2025 09:54:02"} |
| 5 | 2 2 | 1 | 106255287895 | - | 2025-06-05T09:15:18Z | - | Call Centre | Not Satisfied | {"id": "106255287895", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-JUN-2025 14:45:18"} |
| 6 | 2 2 | 2 | 106255287895 | 9154299704 | 2025-06-02T09:34:35Z | Attended By Officer | Sri Narsing Rao | rectified | {"id": "106255287895", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 15:04:35"} |
| 7 | 2 2 | 3 | 106255287895 | 9154299704 | 2025-06-01T14:35:45Z | Under Process | Musharfuddin | under process | {"id": "106255287895", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUN-2025 20:05:45"} |
| 8 | 3 3 | 1 | 106255287898 | - | 2025-06-16T09:06:27Z | - | Call Centre | Not Satisfied | {"id": "106255287898", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "16-JUN-2025 14:36:27"} |
| 9 | 3 3 | 2 | 106255287898 | 9959552464 | 2025-06-15T18:17:35Z | Attended By Officer | T. Thirupathi Raju | dane | {"id": "106255287898", "mobile_number": "9959552464", "posted_by": "T. Thirupathi Raju", "remarks": "dane", "status": "Attended By Officer", "time_stamp": "15-JUN-2025 23:47:35"} |
| 10 | 3 3 | 3 | 106255287898 | 7780182817 | 2025-05-31T18:44:14Z | Open | Mohd Majid | Citizen Requested to Send Mosquito Fogging team at hNO 9-4-131/1/3 Near Al Ameen School ,Nadeem colony ,Tolichowki. | {"id": "106255287898", "mobile_number": "7780182817", "posted_by": "Mohd Majid", "remarks": "Citizen Requested to Send Mosquito Fogging team at hNO 9-4-131/1/3 Near Al Ameen School ,Nadeem colony ,Tolichowki.", "status": "Open", "time_stamp": "01-JUN-2025 00:14:14"} |
| 11 | 4 4 | 1 | 106255287899 | 9154369429 | 2025-06-08T08:04:24Z | Attended By Officer | Dr.Srikanth | complaint attended | {"id": "106255287899", "mobile_number": "9154369429", "posted_by": "Dr.Srikanth", "remarks": "complaint attended", "status": "Attended By Officer", "time_stamp": "08-JUN-2025 13:34:24"} |
| 12 | 5 5 | 1 | 106255287897 | 8125218065 | 2025-06-03T03:47:02Z | Attended By Officer | Dr. Srikanth Reddy | claer | {"id": "106255287897", "mobile_number": "8125218065", "posted_by": "Dr. Srikanth Reddy", "remarks": "claer", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 09:17:02"} |
| 13 | 5 5 | 2 | 106255287897 | 7997951620 | 2025-06-03T01:10:27Z | Open | Serilingampally | citizen saying sweeping not done | {"id": "106255287897", "mobile_number": "7997951620", "posted_by": "Serilingampally", "remarks": "citizen saying sweeping not done", "status": "Open", "time_stamp": "03-JUN-2025 06:40:27"} |
| 14 | 5 5 | 3 | 106255287897 | 7997951629 | 2025-06-01T04:42:38Z | Open | Secunderabad-29 | it is not related circle 29 | {"id": "106255287897", "mobile_number": "7997951629", "posted_by": "Secunderabad-29", "remarks": "it is not related circle 29", "status": "Open", "time_stamp": "01-JUN-2025 10:12:38"} |
| 15 | 5 5 | 4 | 106255287897 | 7997951627 | 2025-06-01T02:49:10Z | Open | Alwal-27 | Another ward | {"id": "106255287897", "mobile_number": "7997951627", "posted_by": "Alwal-27", "remarks": "Another ward", "status": "Open", "time_stamp": "01-JUN-2025 08:19:10"} |
| 16 | 6 6 | 1 | 106255287902 | 8125966592 | 2025-06-01T00:21:20Z | Attended By Officer | Dr. K. S. Ravi | clear | {"id": "106255287902", "mobile_number": "8125966592", "posted_by": "Dr. K. S. Ravi", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 05:51:20"} |
| 17 | 7 7 | 1 | 106255287903 | 9515050844 | 2025-06-19T07:45:22Z | Attended By Officer | B. PREM KUMAR | You can contact concerned tax inspector Sri K Deepak Kumar 9912556696 for rectification | {"id": "106255287903", "mobile_number": "9515050844", "posted_by": "B. PREM KUMAR", "remarks": "You can contact concerned tax inspector Sri K Deepak Kumar 9912556696 for rectification", "status": "Attended By Officer", "time_stamp": "19-JUN-2025 13:15:22"} |
| 18 | 7 7 | 2 | 106255287903 | 9963029149 | 2025-05-31T19:04:21Z | Open | gopal agarwal | Duplicate PTIN | {"id": "106255287903", "mobile_number": "9963029149", "posted_by": "gopal agarwal", "remarks": "Duplicate PTIN", "status": "Open", "time_stamp": "01-JUN-2025 00:34:21"} |
| 19 | 8 8 | 1 | 106255287900 | - | 2025-06-14T09:29:54Z | - | Call Centre | Not Satisfied | {"id": "106255287900", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "14-JUN-2025 14:59:54"} |
| 20 | 8 8 | 2 | 106255287900 | 8790522342 | 2025-06-12T12:43:53Z | Attended By Officer | Md. Nooullah Khan | fogging done | {"id": "106255287900", "mobile_number": "8790522342", "posted_by": "Md. Nooullah Khan", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "12-JUN-2025 18:13:53"} |
| 21 | 9 9 | 1 | 106255287907 | 9154369439 | 2025-06-02T14:05:32Z | Attended By Officer | G Likhitha | closed | {"id": "106255287907", "mobile_number": "9154369439", "posted_by": "G Likhitha", "remarks": "closed", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 19:35:32"} |
| 22 | 11 11 | 1 | 106255287906 | 9154768771 | 2025-06-10T00:45:46Z | Attended By Officer | S.Kiranmayee | rectified | {"id": "106255287906", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "10-JUN-2025 06:15:46"} |
| 23 | 12 12 | 1 | 106255287904 | 9000100058 | 2025-06-12T00:55:03Z | Attended By Officer | Dr. P. Anuradha | clear | {"id": "106255287904", "mobile_number": "9000100058", "posted_by": "Dr. P. Anuradha", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "12-JUN-2025 06:25:03"} |
| 24 | 13 13 | 1 | 106255287905 | 8074770950 | 2025-06-04T07:11:03Z | Attended By Officer | R. SUMITHRA | the encroachment will be removed duely with the help of traffic police in special drive. | {"id": "106255287905", "mobile_number": "8074770950", "posted_by": "R. SUMITHRA", "remarks": "the encroachment will be removed duely with the help of traffic police in special drive.", "status": "Attended By Officer", "time_stamp": "04-JUN-2025 12:41:03"} |
| 25 | 15 15 | 1 | 106255287911 | - | 2025-06-08T09:57:43Z | - | Call Centre | Not Satisfied | {"id": "106255287911", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "08-JUN-2025 15:27:43"} |
| 26 | 15 15 | 2 | 106255287911 | 8008060477 | 2025-06-05T11:52:48Z | Attended By Officer | N.Uday Kiran | attended | {"id": "106255287911", "mobile_number": "8008060477", "posted_by": "N.Uday Kiran", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "05-JUN-2025 17:22:48"} |
| 27 | 15 15 | 3 | 106255287911 | 9989930158 | 2025-06-02T07:23:19Z | Open | MD Masood ur rahman | As per location area H No 4-16-59, forward to connect ward Shastripuram Division | {"id": "106255287911", "mobile_number": "9989930158", "posted_by": "MD Masood ur rahman", "remarks": "As per location area H No 4-16-59, forward to connect ward Shastripuram Division", "status": "Open", "time_stamp": "02-JUN-2025 12:53:19"} |
| 28 | 15 15 | 4 | 106255287911 | 8686661965 | 2025-06-02T06:43:21Z | Open | Ward058 | forwarded | {"id": "106255287911", "mobile_number": "8686661965", "posted_by": "Ward058", "remarks": "forwarded", "status": "Open", "time_stamp": "02-JUN-2025 12:13:21"} |
| 29 | 15 15 | 5 | 106255287911 | 9989930158 | 2025-06-01T13:09:49Z | Open | MD Masood ur rahman | forward to grievance concern ward Shastripuram Division | {"id": "106255287911", "mobile_number": "9989930158", "posted_by": "MD Masood ur rahman", "remarks": "forward to grievance concern ward Shastripuram Division", "status": "Open", "time_stamp": "01-JUN-2025 18:39:49"} |
| 30 | 16 16 | 1 | 106255287909 | 9000701350 | 2025-09-20T10:59:05Z | Attended By Officer | P Srinivasa Rao | phone number updated as per your request | {"id": "106255287909", "mobile_number": "9000701350", "posted_by": "P Srinivasa Rao", "remarks": "phone number updated as per your request", "status": "Attended By Officer", "time_stamp": "20-SEP-2025 16:29:05"} |
| 31 | 16 16 | 2 | 106255287909 | 9989930662 | 2025-06-02T07:02:38Z | Open | M.A. Quadeer | pertains to Cir.5 Saroornagar | {"id": "106255287909", "mobile_number": "9989930662", "posted_by": "M.A. Quadeer", "remarks": "pertains to Cir.5 Saroornagar", "status": "Open", "time_stamp": "02-JUN-2025 12:32:38"} |
| 32 | 16 16 | 3 | 106255287909 | 7416998336 | 2025-05-31T19:19:37Z | Open | akshayakshay | issue is only with , mobile number updation..upon chnage of owner. rest of all mutation is done correctly. akshay agaldiviti is the owner with mobile number 7416998336. the statu 'pending with dc for approval' is shown for mobile number updation | {"id": "106255287909", "mobile_number": "7416998336", "posted_by": "akshayakshay", "remarks": "issue is only with , mobile number updation..upon chnage of owner. rest of all mutation is done correctly. akshay agaldiviti is the owner with mobile number 7416998336. the statu 'pending with dc for approval' is shown for mobile number updation", "status": "Open", "time_stamp": "01-JUN-2025 00:49:37"} |
| 33 | 17 17 | 1 | 106255287908 | 9989930461 | 2025-06-23T11:54:19Z | Attended By Officer | B.Ambika | fogging done | {"id": "106255287908", "mobile_number": "9989930461", "posted_by": "B.Ambika", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "23-JUN-2025 17:24:19"} |
| 34 | 18 18 | 1 | 106255287914 | - | 2025-06-07T09:25:00Z | - | Call Centre | Satisfied | {"id": "106255287914", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "07-JUN-2025 14:55:00"} |
| 35 | 18 18 | 2 | 106255287914 | 9182954615 | 2025-06-04T10:58:21Z | Attended By Officer | P.Venkateshwar Goud | rectified sir | {"id": "106255287914", "mobile_number": "9182954615", "posted_by": "P.Venkateshwar Goud", "remarks": "rectified sir", "status": "Attended By Officer", "time_stamp": "04-JUN-2025 16:28:21"} |
| 36 | 19 19 | 1 | 106255287913 | - | 2025-06-14T09:30:52Z | - | Call Centre | Satisfied | {"id": "106255287913", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "14-JUN-2025 15:00:52"} |
| 37 | 19 19 | 2 | 106255287913 | 8790522342 | 2025-06-12T12:44:24Z | Attended By Officer | Md. Nooullah Khan | fogging done | {"id": "106255287913", "mobile_number": "8790522342", "posted_by": "Md. Nooullah Khan", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "12-JUN-2025 18:14:24"} |
| 38 | 20 20 | 1 | 106255287912 | 9154768771 | 2025-06-12T20:23:29Z | Attended By Officer | S.Kiranmayee | rectified | {"id": "106255287912", "mobile_number": "9154768771", "posted_by": "S.Kiranmayee", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "13-JUN-2025 01:53:29"} |
| 39 | 20 20 | 2 | 106255287912 | 9704787711 | 2025-06-06T19:03:41Z | Open | vemuri | don’t we have a single light to fix in street no 4 OPP Mavajeevan apts Even for the street lights and Atreet Dogs we have to meet the ministers | {"id": "106255287912", "mobile_number": "9704787711", "posted_by": "vemuri", "remarks": "don’t we have a single light to fix in street no 4 OPP Mavajeevan apts Even for the street lights and Atreet Dogs we have to meet the ministers", "status": "Open", "time_stamp": "07-JUN-2025 00:33:41"} |
| 40 | 20 20 | 3 | 106255287912 | 9704787711 | 2025-06-06T06:51:10Z | Open | vemuri | no update and change after this | {"id": "106255287912", "mobile_number": "9704787711", "posted_by": "vemuri", "remarks": "no update and change after this", "status": "Open", "time_stamp": "06-JUN-2025 12:21:10"} |
| 41 | 20 20 | 4 | 106255287912 | 7207923077 | 2025-06-04T00:01:27Z | Open | G.Kavitha I/C | out of package | {"id": "106255287912", "mobile_number": "7207923077", "posted_by": "G.Kavitha I/C", "remarks": "out of package", "status": "Open", "time_stamp": "04-JUN-2025 05:31:27"} |
| 42 | 20 20 | 5 | 106255287912 | 9704787711 | 2025-05-31T19:37:47Z | Open | vemuri | since long time they stopped working at least fix one in the middle to shed light thanks | {"id": "106255287912", "mobile_number": "9704787711", "posted_by": "vemuri", "remarks": "since long time they stopped working at least fix one in the middle to shed light thanks", "status": "Open", "time_stamp": "01-JUN-2025 01:07:47"} |
| 43 | 21 21 | 1 | 106255287915 | - | 2025-06-29T11:48:07Z | - | Call Centre | Not Satisfied | {"id": "106255287915", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "29-JUN-2025 17:18:07"} |
| 44 | 21 21 | 2 | 106255287915 | 9959552464 | 2025-06-15T18:05:30Z | Attended By Officer | T. Thirupathi Raju | done | {"id": "106255287915", "mobile_number": "9959552464", "posted_by": "T. Thirupathi Raju", "remarks": "done", "status": "Attended By Officer", "time_stamp": "15-JUN-2025 23:35:30"} |
| 45 | 22 22 | 1 | 106255287917 | 7097137546 | 2025-06-05T11:43:36Z | Closed | vishal | - | {"id": "106255287917", "mobile_number": "7097137546", "posted_by": "vishal", "remarks": "-", "status": "Closed", "time_stamp": "05-JUN-2025 17:13:36"} |
| 46 | 22 22 | 2 | 106255287917 | 9182954615 | 2025-06-04T05:48:22Z | Attended By Officer | P.Venkateshwar Goud | rectified sir | {"id": "106255287917", "mobile_number": "9182954615", "posted_by": "P.Venkateshwar Goud", "remarks": "rectified sir", "status": "Attended By Officer", "time_stamp": "04-JUN-2025 11:18:22"} |
| 47 | 22 22 | 3 | 106255287917 | 9381459256 | 2025-06-03T04:08:04Z | Open | P.Venkateshwar Goud. | forward | {"id": "106255287917", "mobile_number": "9381459256", "posted_by": "P.Venkateshwar Goud.", "remarks": "forward", "status": "Open", "time_stamp": "03-JUN-2025 09:38:04"} |
| 48 | 22 22 | 4 | 106255287917 | 9182954615 | 2025-06-02T03:27:54Z | Open | P.Venkateshwar Goud | forward | {"id": "106255287917", "mobile_number": "9182954615", "posted_by": "P.Venkateshwar Goud", "remarks": "forward", "status": "Open", "time_stamp": "02-JUN-2025 08:57:54"} |
| 49 | 23 23 | 1 | 106255287921 | 9154909321 | 2025-09-09T04:28:49Z | Attended By Officer | K.Raju | car not remove | {"id": "106255287921", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "car not remove", "status": "Attended By Officer", "time_stamp": "09-SEP-2025 09:58:49"} |
| 50 | 23 23 | 2 | 106255287921 | 9700953354 | 2025-08-20T10:12:49Z | Open | Habeeb | its been more then two months the problem has bot been resolved....when i am trying to call the ae his phone is switched off | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "its been more then two months the problem has bot been resolved....when i am trying to call the ae his phone is switched off", "status": "Open", "time_stamp": "20-AUG-2025 15:42:49"} |
| 51 | 23 23 | 3 | 106255287921 | 9700953354 | 2025-07-20T20:56:22Z | Open | Habeeb | The officer came along with the ladder and they told that they cannot climb on such height through ladder,it required crane to solve it..it's been more then 2 months the issue hasn't resolved | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "The officer came along with the ladder and they told that they cannot climb on such height through ladder,it required crane to solve it..it's been more then 2 months the issue hasn't resolved", "status": "Open", "time_stamp": "21-JUL-2025 02:26:22"} |
| 52 | 23 23 | 4 | 106255287921 | 9700953354 | 2025-07-20T20:48:40Z | Attended By Officer | Habeeb | and moreover the photo uploaded by officer of streetlight is of beside pole | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "and moreover the photo uploaded by officer of streetlight is of beside pole", "status": "Attended By Officer", "time_stamp": "21-JUL-2025 02:18:40"} |
| 53 | 23 23 | 5 | 106255287921 | 9700953354 | 2025-07-20T20:45:00Z | Attended By Officer | Habeeb | the issue has not been resolved yet....in the status it's showing it's completed..never expected this from ghmc | {"id": "106255287921", "mobile_number": "9700953354", "posted_by": "Habeeb", "remarks": "the issue has not been resolved yet....in the status it's showing it's completed..never expected this from ghmc", "status": "Attended By Officer", "time_stamp": "21-JUL-2025 02:15:00"} |
| 54 | 23 23 | 6 | 106255287921 | - | 2025-06-08T09:58:44Z | - | Call Centre | Not Satisfied | {"id": "106255287921", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "08-JUN-2025 15:28:44"} |
| 55 | 23 23 | 7 | 106255287921 | 9154909321 | 2025-06-06T06:32:48Z | Attended By Officer | K.Raju | model lights rectified | {"id": "106255287921", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "model lights rectified", "status": "Attended By Officer", "time_stamp": "06-JUN-2025 12:02:48"} |
| 56 | 24 24 | 1 | 106255287918 | 7995020420 | 2025-08-23T12:39:22Z | Closed | Sri.N.Surya | ok | {"id": "106255287918", "mobile_number": "7995020420", "posted_by": "Sri.N.Surya", "remarks": "ok", "status": "Closed", "time_stamp": "23-AUG-2025 18:09:22"} |
| 57 | 25 25 | 1 | 106255287916 | - | 2025-06-02T06:08:43Z | - | Call Centre | Satisfied | {"id": "106255287916", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "02-JUN-2025 11:38:43"} |
| 58 | 25 25 | 2 | 106255287916 | 9063816967 | 2025-06-01T07:50:06Z | Attended By Officer | Dr Dipankar Pal | attended | {"id": "106255287916", "mobile_number": "9063816967", "posted_by": "Dr Dipankar Pal", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 13:20:06"} |
| 59 | 25 25 | 3 | 106255287916 | 9063816967 | 2025-06-01T00:48:15Z | Under Process | Dr Dipankar Pal | under process | {"id": "106255287916", "mobile_number": "9063816967", "posted_by": "Dr Dipankar Pal", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUN-2025 06:18:15"} |
| 60 | 26 26 | 1 | 106255287919 | - | 2025-06-07T08:30:49Z | - | Call Centre | Not Satisfied | {"id": "106255287919", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "07-JUN-2025 14:00:49"} |
| 61 | 26 26 | 2 | 106255287919 | 9154797217 | 2025-06-06T11:19:31Z | Attended By Officer | Y.Rajitha | Fogging done. | {"id": "106255287919", "mobile_number": "9154797217", "posted_by": "Y.Rajitha", "remarks": "Fogging done.", "status": "Attended By Officer", "time_stamp": "06-JUN-2025 16:49:31"} |
| 62 | 26 26 | 3 | 106255287919 | 9959542712 | 2025-06-04T13:55:17Z | Open | Umer | Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. | {"id": "106255287919", "mobile_number": "9959542712", "posted_by": "Umer", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "04-JUN-2025 19:25:17"} |
| 63 | 27 27 | 1 | 106255287923 | 9886866460 | 2025-06-11T08:34:34Z | Closed | Swetha | ok | {"id": "106255287923", "mobile_number": "9886866460", "posted_by": "Swetha", "remarks": "ok", "status": "Closed", "time_stamp": "11-JUN-2025 14:04:34"} |
| 64 | 27 27 | 2 | 106255287923 | 7207923101 | 2025-06-05T06:02:08Z | Attended By Officer | Dr.YADAGIRI | complete attend | {"id": "106255287923", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "complete attend", "status": "Attended By Officer", "time_stamp": "05-JUN-2025 11:32:08"} |
| 65 | 28 28 | 1 | 106255287924 | 9704234838 | 2025-06-05T06:05:02Z | Attended By Officer | M Satya Narayana Reddy | rectified | {"id": "106255287924", "mobile_number": "9704234838", "posted_by": "M Satya Narayana Reddy", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "05-JUN-2025 11:35:02"} |
| 66 | 28 28 | 2 | 106255287924 | 9154369423 | 2025-06-03T17:50:42Z | Open | M.satyanarayana Reddy | ae | {"id": "106255287924", "mobile_number": "9154369423", "posted_by": "M.satyanarayana Reddy", "remarks": "ae", "status": "Open", "time_stamp": "03-JUN-2025 23:20:42"} |
| 67 | 28 28 | 3 | 106255287924 | 8555902142 | 2025-06-02T02:59:18Z | Open | Sri.K.Raju | forward | {"id": "106255287924", "mobile_number": "8555902142", "posted_by": "Sri.K.Raju", "remarks": "forward", "status": "Open", "time_stamp": "02-JUN-2025 08:29:18"} |
| 68 | 29 29 | 1 | 106255287922 | 8121041420 | 2025-06-03T03:11:13Z | Attended By Officer | Dr.Abdul Basith | Sir attend a complaint and dog cautch for arv | {"id": "106255287922", "mobile_number": "8121041420", "posted_by": "Dr.Abdul Basith", "remarks": "Sir attend a complaint and dog cautch for arv", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 08:41:13"} |
| 69 | 30 30 | 1 | 106255287920 | - | 2025-06-16T09:08:51Z | - | Call Centre | Satisfied | {"id": "106255287920", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "16-JUN-2025 14:38:51"} |
| 70 | 30 30 | 2 | 106255287920 | 8790522342 | 2025-06-12T09:53:11Z | Attended By Officer | Md. Nooullah Khan | fogging done | {"id": "106255287920", "mobile_number": "8790522342", "posted_by": "Md. Nooullah Khan", "remarks": "fogging done", "status": "Attended By Officer", "time_stamp": "12-JUN-2025 15:23:11"} |
| 71 | 30 30 | 3 | 106255287920 | 9959965818 | 2025-06-10T15:30:17Z | Open | Citizen | Citizen informed that the grievance has been pending So please take necessary action Thank you sir. | {"id": "106255287920", "mobile_number": "9959965818", "posted_by": "Citizen", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "10-JUN-2025 21:00:17"} |
| 72 | 30 30 | 4 | 106255287920 | 9959965818 | 2025-06-09T18:09:27Z | Open | Citizen | Citizen informed that the grievance has been pending So please take necessary action Thank you sir. | {"id": "106255287920", "mobile_number": "9959965818", "posted_by": "Citizen", "remarks": "Citizen informed that the grievance has been pending So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "09-JUN-2025 23:39:27"} |
| 73 | 30 30 | 5 | 106255287920 | 8008060413 | 2025-06-06T10:38:06Z | Open | B.Bhaskar | complaint belong to another ward | {"id": "106255287920", "mobile_number": "8008060413", "posted_by": "B.Bhaskar", "remarks": "complaint belong to another ward", "status": "Open", "time_stamp": "06-JUN-2025 16:08:06"} |
| 74 | 30 30 | 6 | 106255287920 | 9959965818 | 2025-06-03T18:04:09Z | Open | Citizen | Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. | {"id": "106255287920", "mobile_number": "9959965818", "posted_by": "Citizen", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "03-JUN-2025 23:34:09"} |
| 75 | 31 31 | 1 | 106255287925 | - | 2025-06-05T09:17:17Z | - | Call Centre | Satisfied | {"id": "106255287925", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "05-JUN-2025 14:47:17"} |
| 76 | 31 31 | 2 | 106255287925 | 9154299704 | 2025-06-02T09:35:11Z | Attended By Officer | Sri Narsing Rao | rectified | {"id": "106255287925", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 15:05:11"} |
| 77 | 31 31 | 3 | 106255287925 | 9154299704 | 2025-06-01T14:35:09Z | Under Process | Musharfuddin | under process | {"id": "106255287925", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUN-2025 20:05:09"} |
| 78 | 32 32 | 1 | 106255287926 | 9705252127 | 2025-06-05T06:27:41Z | Closed | SamreenFatima | Attended the non glowing of street light grievance they just came have a talk with us and said that they could not repair the street light as they dont have ladder and asking us for ladder they didnot even bother to solve our isssue and two persons left whole lane is dark at night please take serious action regarding our grievance we couldnot come out of our house after 7 | {"id": "106255287926", "mobile_number": "9705252127", "posted_by": "SamreenFatima", "remarks": "Attended the non glowing of street light grievance they just came have a talk with us and said that they could not repair the street light as they dont have ladder and asking us for ladder they didnot even bother to solve our isssue and two persons left whole lane is dark at night please take serious action regarding our grievance we couldnot come out of our house after 7", "status": "Closed", "time_stamp": "05-JUN-2025 11:57:41"} |
| 79 | 32 32 | 2 | 106255287926 | 9154299704 | 2025-06-03T10:24:46Z | Attended By Officer | Sri Narsing Rao | tree cutting | {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "tree cutting", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 15:54:46"} |
| 80 | 32 32 | 3 | 106255287926 | 9154299704 | 2025-06-02T09:51:21Z | Open | Sri Narsing Rao | transfer | {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "transfer", "status": "Open", "time_stamp": "02-JUN-2025 15:21:21"} |
| 81 | 32 32 | 4 | 106255287926 | 9705252127 | 2025-06-02T09:48:53Z | Open | SamreenFatima | Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. | {"id": "106255287926", "mobile_number": "9705252127", "posted_by": "SamreenFatima", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "02-JUN-2025 15:18:53"} |
| 82 | 32 32 | 5 | 106255287926 | 9154299704 | 2025-06-02T05:24:08Z | Open | Musharfuddin | pertain to Mehdipatnam | {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "pertain to Mehdipatnam", "status": "Open", "time_stamp": "02-JUN-2025 10:54:08"} |
| 83 | 32 32 | 6 | 106255287926 | 9154299704 | 2025-06-02T05:23:21Z | Under Process | Musharfuddin | under process | {"id": "106255287926", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "02-JUN-2025 10:53:21"} |
| 84 | 33 33 | 1 | 106255287927 | - | 2025-06-03T06:03:49Z | - | Call Centre | Not Satisfied | {"id": "106255287927", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "03-JUN-2025 11:33:49"} |
| 85 | 33 33 | 2 | 106255287927 | 9154299704 | 2025-06-02T10:48:06Z | Attended By Officer | Sri Narsing Rao | rectified | {"id": "106255287927", "mobile_number": "9154299704", "posted_by": "Sri Narsing Rao", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 16:18:06"} |
| 86 | 33 33 | 3 | 106255287927 | 9154299704 | 2025-06-01T14:34:04Z | Under Process | Musharfuddin | under process | {"id": "106255287927", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "under process", "status": "Under Process", "time_stamp": "01-JUN-2025 20:04:04"} |
| 87 | 33 33 | 4 | 106255287927 | 9154299704 | 2025-06-01T14:33:27Z | Open | Musharfuddin | pertain to Tolichowki | {"id": "106255287927", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "pertain to Tolichowki", "status": "Open", "time_stamp": "01-JUN-2025 20:03:27"} |
| 88 | 34 34 | 1 | 106255287928 | 9959552464 | 2025-06-15T18:44:34Z | Attended By Officer | T. Thirupathi Raju | done | {"id": "106255287928", "mobile_number": "9959552464", "posted_by": "T. Thirupathi Raju", "remarks": "done", "status": "Attended By Officer", "time_stamp": "16-JUN-2025 00:14:34"} |
| 89 | 35 35 | 1 | 106255287929 | 8008556852 | 2025-10-03T06:56:56Z | Attended By Officer | Sri E. Nagi Reddy | Action willbe initiated following due procedure of law. | {"id": "106255287929", "mobile_number": "8008556852", "posted_by": "Sri E. Nagi Reddy", "remarks": "Action willbe initiated following due procedure of law.", "status": "Attended By Officer", "time_stamp": "03-OCT-2025 12:26:56"} |
| 90 | 35 35 | 2 | 106255287929 | 7075543399 | 2025-06-22T12:36:29Z | Open | Not | What type of solution u done.no one can attend still now. | {"id": "106255287929", "mobile_number": "7075543399", "posted_by": "Not", "remarks": "What type of solution u done.no one can attend still now.", "status": "Open", "time_stamp": "22-JUN-2025 18:06:29"} |
| 91 | 35 35 | 3 | 106255287929 | 8008556852 | 2025-06-21T11:30:28Z | Attended By Officer | Sri E. Nagi Reddy | Encroachments drive will be conducted with the coordination of traffic police and will be removed. | {"id": "106255287929", "mobile_number": "8008556852", "posted_by": "Sri E. Nagi Reddy", "remarks": "Encroachments drive will be conducted with the coordination of traffic police and will be removed.", "status": "Attended By Officer", "time_stamp": "21-JUN-2025 17:00:28"} |
| 92 | 36 36 | 1 | 106255287932 | 9154295249 | 2025-06-03T11:17:49Z | Attended By Officer | Sai Chandana | rec | {"id": "106255287932", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rec", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 16:47:49"} |
| 93 | 37 37 | 1 | 106255287930 | 9154299632 | 2025-06-02T10:47:31Z | Attended By Officer | Sri T R Prasad | rectified | {"id": "106255287930", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "02-JUN-2025 16:17:31"} |
| 94 | 37 37 | 2 | 106255287930 | 9154299632 | 2025-06-01T16:31:37Z | Under Process | Sri T R Prasad | informed to electrician | {"id": "106255287930", "mobile_number": "9154299632", "posted_by": "Sri T R Prasad", "remarks": "informed to electrician", "status": "Under Process", "time_stamp": "01-JUN-2025 22:01:37"} |
| 95 | 39 39 | 1 | 106255287935 | 9346014249 | 2025-06-01T04:31:23Z | Attended By Officer | Dr.Bheekya | attended | {"id": "106255287935", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 10:01:23"} |
| 96 | 41 41 | 1 | 106255287931 | 9154299640 | 2025-06-09T11:39:10Z | Attended By Officer | Smt. M. Sushma | retrieved | {"id": "106255287931", "mobile_number": "9154299640", "posted_by": "Smt. M. Sushma", "remarks": "retrieved", "status": "Attended By Officer", "time_stamp": "09-JUN-2025 17:09:10"} |
| 97 | 43 43 | 1 | 106255287936 | - | 2025-06-17T04:22:03Z | - | Call Centre | Partially Satisfied | {"id": "106255287936", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "-", "time_stamp": "17-JUN-2025 09:52:03"} |
| 98 | 43 43 | 2 | 106255287936 | - | 2025-06-03T06:33:34Z | Attended By Officer | Ward134 | work is completed | {"id": "106255287936", "mobile_number": "-", "posted_by": "Ward134", "remarks": "work is completed", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 12:03:34"} |
| 99 | 43 43 | 3 | 106255287936 | 9121245035 | 2025-06-02T14:39:31Z | Open | Sri K. Raghupathi reddy | other ward | {"id": "106255287936", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "other ward", "status": "Open", "time_stamp": "02-JUN-2025 20:09:31"} |
| 100 | 45 45 | 1 | 106255287939 | 8712013115 | 2025-07-08T07:07:48Z | Attended By Officer | T Ravi chandra AEE | solved | {"id": "106255287939", "mobile_number": "8712013115", "posted_by": "T Ravi chandra AEE", "remarks": "solved", "status": "Attended By Officer", "time_stamp": "08-JUL-2025 12:37:48"} |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);