snapshot_comments
61,584 rows
This data as json, CSV (advanced)
Suggested facets: 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 | 103255140297 | 9154299594 | 2025-03-07T15:55:54Z | Attended By Officer | B.Ramesh | done | {"id": "103255140297", "mobile_number": "9154299594", "posted_by": "B.Ramesh", "remarks": "done", "status": "Attended By Officer", "time_stamp": "07-MAR-2025 21:25:54"} |
| 2 | 1 1 | 2 | 103255140297 | 7993360295 | 2025-03-01T10:32:29Z | Open | M.Satish Kumar | circle 13 | {"id": "103255140297", "mobile_number": "7993360295", "posted_by": "M.Satish Kumar", "remarks": "circle 13", "status": "Open", "time_stamp": "01-MAR-2025 16:02:29"} |
| 3 | 2 2 | 1 | 103255140298 | 9121245035 | 2025-03-03T19:14:33Z | Attended By Officer | Sri K. Raghupathi reddy | clear | {"id": "103255140298", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 00:44:33"} |
| 4 | 2 2 | 2 | 103255140298 | 9121245035 | 2025-03-02T00:18:16Z | Under Process | Sri K. Raghupathi reddy | box problem | {"id": "103255140298", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "box problem", "status": "Under Process", "time_stamp": "02-MAR-2025 05:48:16"} |
| 5 | 3 3 | 1 | 103255140299 | - | 2025-03-09T08:50:13Z | - | Call Centre | Not Satisfied | {"id": "103255140299", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "09-MAR-2025 14:20:13"} |
| 6 | 3 3 | 2 | 103255140299 | 9989930461 | 2025-03-05T10:48:42Z | Attended By Officer | B.Ambika | fogging done with vmf | {"id": "103255140299", "mobile_number": "9989930461", "posted_by": "B.Ambika", "remarks": "fogging done with vmf", "status": "Attended By Officer", "time_stamp": "05-MAR-2025 16:18:42"} |
| 7 | 4 4 | 1 | 103255140300 | 9100025128 | 2025-03-01T01:49:51Z | Attended By Officer | Sri. T.R.Prasad | rectified | {"id": "103255140300", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 07:19:51"} |
| 8 | 4 4 | 2 | 103255140300 | 9553410495 | 2025-02-28T18:40:59Z | Open | archana | 1 | {"id": "103255140300", "mobile_number": "9553410495", "posted_by": "archana", "remarks": "1", "status": "Open", "time_stamp": "01-MAR-2025 00:10:59"} |
| 9 | 5 5 | 1 | 103255140302 | 9100025128 | 2025-03-04T08:09:13Z | Attended By Officer | Sri. T.R.Prasad | rectified | {"id": "103255140302", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 13:39:13"} |
| 10 | 5 5 | 2 | 103255140302 | 9100025128 | 2025-03-03T06:40:25Z | Under Process | Sri. T.R.Prasad | under Process | {"id": "103255140302", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "under Process", "status": "Under Process", "time_stamp": "03-MAR-2025 12:10:25"} |
| 11 | 5 5 | 3 | 103255140302 | 9100025128 | 2025-03-01T01:40:37Z | Open | Sri. T.R.Prasad | 2 | {"id": "103255140302", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "2", "status": "Open", "time_stamp": "01-MAR-2025 07:10:37"} |
| 12 | 6 6 | 1 | 103255140301 | 9154299594 | 2025-03-13T09:57:37Z | Attended By Officer | B.Ramesh | done | {"id": "103255140301", "mobile_number": "9154299594", "posted_by": "B.Ramesh", "remarks": "done", "status": "Attended By Officer", "time_stamp": "13-MAR-2025 15:27:37"} |
| 13 | 8 8 | 1 | 103255140306 | 8897713985 | 2025-03-01T11:09:56Z | Attended By Officer | Smt.Ch.Rajeshwari | conducted inspection. | {"id": "103255140306", "mobile_number": "8897713985", "posted_by": "Smt.Ch.Rajeshwari", "remarks": "conducted inspection.", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 16:39:56"} |
| 14 | 9 9 | 1 | 103255140303 | - | 2025-03-09T08:52:39Z | - | Call Centre | Not Satisfied | {"id": "103255140303", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "09-MAR-2025 14:22:39"} |
| 15 | 9 9 | 2 | 103255140303 | 8008050361 | 2025-03-05T07:36:57Z | Attended By Officer | Ch.Mahesh Kuamr | Complaint attended | {"id": "103255140303", "mobile_number": "8008050361", "posted_by": "Ch.Mahesh Kuamr", "remarks": "Complaint attended", "status": "Attended By Officer", "time_stamp": "05-MAR-2025 13:06:57"} |
| 16 | 10 10 | 1 | 103255140304 | 9000036998 | 2025-08-06T10:55:56Z | Attended By Officer | Sri V.Surender | kindly submit the doct | {"id": "103255140304", "mobile_number": "9000036998", "posted_by": "Sri V.Surender", "remarks": "kindly submit the doct", "status": "Attended By Officer", "time_stamp": "06-AUG-2025 16:25:56"} |
| 17 | 11 11 | 1 | 103255140307 | 9154803583 | 2025-03-01T09:41:12Z | Attended By Officer | Vanaja | compelent attend ALO activity done | {"id": "103255140307", "mobile_number": "9154803583", "posted_by": "Vanaja", "remarks": "compelent attend ALO activity done", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 15:11:12"} |
| 18 | 12 12 | 1 | 103255140308 | - | 2025-03-05T11:19:41Z | - | Call Centre | Not Satisfied | {"id": "103255140308", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-MAR-2025 16:49:41"} |
| 19 | 12 12 | 2 | 103255140308 | 7702775284 | 2025-03-01T11:55:54Z | Attended By Officer | T R Prasad I/C | rectified | {"id": "103255140308", "mobile_number": "7702775284", "posted_by": "T R Prasad I/C", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 17:25:54"} |
| 20 | 13 13 | 1 | 103255140309 | 9154909227 | 2025-03-03T03:18:21Z | Attended By Officer | Dr.K.Nagarjuna | Attend | {"id": "103255140309", "mobile_number": "9154909227", "posted_by": "Dr.K.Nagarjuna", "remarks": "Attend", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 08:48:21"} |
| 21 | 14 14 | 1 | 103255140310 | 9121242764 | 2025-03-22T10:21:12Z | Attended By Officer | P Anusha | rectified | {"id": "103255140310", "mobile_number": "9121242764", "posted_by": "P Anusha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "22-MAR-2025 15:51:12"} |
| 22 | 15 15 | 1 | 103255140311 | 7207923077 | 2025-04-24T03:36:09Z | Attended By Officer | G.Kavitha I/C | resolve | {"id": "103255140311", "mobile_number": "7207923077", "posted_by": "G.Kavitha I/C", "remarks": "resolve", "status": "Attended By Officer", "time_stamp": "24-APR-2025 09:06:09"} |
| 23 | 15 15 | 2 | 103255140311 | 9966883677 | 2025-04-18T13:37:28Z | Open | Shaik azes | Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. | {"id": "103255140311", "mobile_number": "9966883677", "posted_by": "Shaik azes", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "18-APR-2025 19:07:28"} |
| 24 | 15 15 | 3 | 103255140311 | 9966883677 | 2025-04-01T12:50:52Z | Open | Shaik azes | Citizen informed that the grievance has been pending. So please take necessary action Thank you sir. | {"id": "103255140311", "mobile_number": "9966883677", "posted_by": "Shaik azes", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action Thank you sir.", "status": "Open", "time_stamp": "01-APR-2025 18:20:52"} |
| 25 | 15 15 | 4 | 103255140311 | 9966883677 | 2025-03-11T07:45:06Z | Open | Shaik azes | Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir. | {"id": "103255140311", "mobile_number": "9966883677", "posted_by": "Shaik azes", "remarks": "Citizen informed that the grievance has been pending. So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "11-MAR-2025 13:15:06"} |
| 26 | 15 15 | 5 | 103255140311 | 9966883677 | 2025-03-08T16:03:44Z | Open | Shaik azes | Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir. | {"id": "103255140311", "mobile_number": "9966883677", "posted_by": "Shaik azes", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "08-MAR-2025 21:33:44"} |
| 27 | 16 16 | 1 | 103255140312 | - | 2025-04-20T10:37:18Z | - | Call Centre | Satisfied | {"id": "103255140312", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "20-APR-2025 16:07:18"} |
| 28 | 16 16 | 2 | 103255140312 | 9121242764 | 2025-04-11T12:07:19Z | Attended By Officer | P Anusha | rectified | {"id": "103255140312", "mobile_number": "9121242764", "posted_by": "P Anusha", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "11-APR-2025 17:37:19"} |
| 29 | 17 17 | 1 | 103255140313 | 7331151746 | 2025-03-07T06:07:25Z | Attended By Officer | N.Prashant | hi inconvenience caused regretted it is pertaining to hmwssb kindly contact hmwssb manager thank you | {"id": "103255140313", "mobile_number": "7331151746", "posted_by": "N.Prashant", "remarks": "hi inconvenience caused regretted it is pertaining to hmwssb kindly contact hmwssb manager thank you", "status": "Attended By Officer", "time_stamp": "07-MAR-2025 11:37:25"} |
| 30 | 17 17 | 2 | 103255140313 | 7331151746 | 2025-03-02T02:39:44Z | Under Process | N.Prashant | .. | {"id": "103255140313", "mobile_number": "7331151746", "posted_by": "N.Prashant", "remarks": "..", "status": "Under Process", "time_stamp": "02-MAR-2025 08:09:44"} |
| 31 | 18 18 | 1 | 103255140314 | 9154299594 | 2025-03-18T09:58:55Z | Attended By Officer | B.Ramesh | done | {"id": "103255140314", "mobile_number": "9154299594", "posted_by": "B.Ramesh", "remarks": "done", "status": "Attended By Officer", "time_stamp": "18-MAR-2025 15:28:55"} |
| 32 | 19 19 | 1 | 103255140315 | 9704670163 | 2025-05-05T11:52:19Z | Attended By Officer | Sri. Rama rao | g | {"id": "103255140315", "mobile_number": "9704670163", "posted_by": "Sri. Rama rao", "remarks": "g", "status": "Attended By Officer", "time_stamp": "05-MAY-2025 17:22:19"} |
| 33 | 20 20 | 1 | 103255140316 | 7702439660 | 2025-03-04T06:47:06Z | Closed | Sreenivas | Thank you for quick response and personally i want to thank the person, who came and spreyed | {"id": "103255140316", "mobile_number": "7702439660", "posted_by": "Sreenivas", "remarks": "Thank you for quick response and personally i want to thank the person, who came and spreyed", "status": "Closed", "time_stamp": "04-MAR-2025 12:17:06"} |
| 34 | 20 20 | 2 | 103255140316 | 9885198396 | 2025-03-04T05:24:22Z | Attended By Officer | Dr. Vijay Mohan Rao | spreying work | {"id": "103255140316", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "spreying work", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 10:54:22"} |
| 35 | 21 21 | 1 | 103255140317 | 9989930461 | 2025-03-06T11:15:39Z | Attended By Officer | B.Ambika | fogging done with vmf | {"id": "103255140317", "mobile_number": "9989930461", "posted_by": "B.Ambika", "remarks": "fogging done with vmf", "status": "Attended By Officer", "time_stamp": "06-MAR-2025 16:45:39"} |
| 36 | 22 22 | 1 | 103255140318 | 9989930461 | 2025-03-06T11:13:56Z | Attended By Officer | B.Ambika | fogging done with vmf | {"id": "103255140318", "mobile_number": "9989930461", "posted_by": "B.Ambika", "remarks": "fogging done with vmf", "status": "Attended By Officer", "time_stamp": "06-MAR-2025 16:43:56"} |
| 37 | 23 23 | 1 | 103255140319 | 9550746801 | 2025-03-11T13:32:28Z | Attended By Officer | G.Rambabu | fogging done at complaint address | {"id": "103255140319", "mobile_number": "9550746801", "posted_by": "G.Rambabu", "remarks": "fogging done at complaint address", "status": "Attended By Officer", "time_stamp": "11-MAR-2025 19:02:28"} |
| 38 | 25 25 | 1 | 103255140321 | - | 2025-03-09T10:25:53Z | - | Call Centre | Satisfied | {"id": "103255140321", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "09-MAR-2025 15:55:53"} |
| 39 | 25 25 | 2 | 103255140321 | 9849906752 | 2025-03-06T14:04:24Z | Attended By Officer | Sri B Venkat Raju,Dy.EE | clear | {"id": "103255140321", "mobile_number": "9849906752", "posted_by": "Sri B Venkat Raju,Dy.EE", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "06-MAR-2025 19:34:24"} |
| 40 | 26 26 | 1 | 103255140322 | 9154299704 | 2025-04-14T08:13:09Z | Attended By Officer | Musharfuddin | k | {"id": "103255140322", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "k", "status": "Attended By Officer", "time_stamp": "14-APR-2025 13:43:09"} |
| 41 | 28 28 | 1 | 103255140325 | - | 2025-03-04T08:41:26Z | - | Call Centre | Not Satisfied | {"id": "103255140325", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "04-MAR-2025 14:11:26"} |
| 42 | 28 28 | 2 | 103255140325 | 8919690076 | 2025-03-01T06:49:58Z | Attended By Officer | Dr Wasim | complaint attended | {"id": "103255140325", "mobile_number": "8919690076", "posted_by": "Dr Wasim", "remarks": "complaint attended", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 12:19:58"} |
| 43 | 29 29 | 1 | 103255140326 | 9912140536 | 2025-03-09T06:54:54Z | Closed | pavan | please close the grievance | {"id": "103255140326", "mobile_number": "9912140536", "posted_by": "pavan", "remarks": "please close the grievance", "status": "Closed", "time_stamp": "09-MAR-2025 12:24:54"} |
| 44 | 29 29 | 2 | 103255140326 | 9154369424 | 2025-03-04T07:20:34Z | Attended By Officer | Dr.B.J. Vanaja Kumari | ABC DOGS | {"id": "103255140326", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "ABC DOGS", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 12:50:34"} |
| 45 | 30 30 | 1 | 103255140327 | - | 2025-03-03T09:32:40Z | - | Call Centre | Satisfied | {"id": "103255140327", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "03-MAR-2025 15:02:40"} |
| 46 | 30 30 | 2 | 103255140327 | 7207923101 | 2025-03-02T06:19:04Z | Attended By Officer | Dr.YADAGIRI | Attended | {"id": "103255140327", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "Attended", "status": "Attended By Officer", "time_stamp": "02-MAR-2025 11:49:04"} |
| 47 | 30 30 | 3 | 103255140327 | 8712034408 | 2025-03-01T04:51:21Z | Under Process | Dr Srinivas | Dear citizen your grevience Assigned to dog squad team please | {"id": "103255140327", "mobile_number": "8712034408", "posted_by": "Dr Srinivas", "remarks": "Dear citizen your grevience Assigned to dog squad team please", "status": "Under Process", "time_stamp": "01-MAR-2025 10:21:21"} |
| 48 | 31 31 | 1 | 103255140324 | 9154803583 | 2025-03-01T15:23:25Z | Attended By Officer | Vanaja | fogingg done | {"id": "103255140324", "mobile_number": "9154803583", "posted_by": "Vanaja", "remarks": "fogingg done", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 20:53:25"} |
| 49 | 32 32 | 1 | 103255140328 | - | 2025-03-25T09:01:15Z | - | Call Centre | Satisfied | {"id": "103255140328", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "25-MAR-2025 14:31:15"} |
| 50 | 32 32 | 2 | 103255140328 | 9848535998 | 2025-03-01T02:40:37Z | Attended By Officer | S Mallesh | clear | {"id": "103255140328", "mobile_number": "9848535998", "posted_by": "S Mallesh", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 08:10:37"} |
| 51 | 33 33 | 1 | 103255140329 | - | 2025-03-05T09:28:33Z | - | Call Centre | Not Satisfied | {"id": "103255140329", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-MAR-2025 14:58:33"} |
| 52 | 33 33 | 2 | 103255140329 | 8074002645 | 2025-03-01T07:50:08Z | Attended By Officer | Dr K.Nagarjuna I/c | attended | {"id": "103255140329", "mobile_number": "8074002645", "posted_by": "Dr K.Nagarjuna I/c", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 13:20:08"} |
| 53 | 33 33 | 3 | 103255140329 | 8074002645 | 2025-03-01T00:55:56Z | Under Process | Dr K.Nagarjuna I/c | under process | {"id": "103255140329", "mobile_number": "8074002645", "posted_by": "Dr K.Nagarjuna I/c", "remarks": "under process", "status": "Under Process", "time_stamp": "01-MAR-2025 06:25:56"} |
| 54 | 35 35 | 1 | 103255140331 | 9989930380 | 2025-03-03T11:57:29Z | Attended By Officer | J. Chandulal | attend | {"id": "103255140331", "mobile_number": "9989930380", "posted_by": "J. Chandulal", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 17:27:29"} |
| 55 | 36 36 | 1 | 103255140332 | - | 2025-04-17T11:34:09Z | - | Call Centre | Partially Satisfied | {"id": "103255140332", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Partially Satisfied", "status": "-", "time_stamp": "17-APR-2025 17:04:09"} |
| 56 | 36 36 | 2 | 103255140332 | 9121242764 | 2025-04-11T07:10:26Z | Attended By Officer | P Anusha | r | {"id": "103255140332", "mobile_number": "9121242764", "posted_by": "P Anusha", "remarks": "r", "status": "Attended By Officer", "time_stamp": "11-APR-2025 12:40:26"} |
| 57 | 36 36 | 3 | 103255140332 | 9246575745 | 2025-03-04T02:47:53Z | Open | anuradha reddy | Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir | {"id": "103255140332", "mobile_number": "9246575745", "posted_by": "anuradha reddy", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir", "status": "Open", "time_stamp": "04-MAR-2025 08:17:53"} |
| 58 | 37 37 | 1 | 103255140333 | 9121242764 | 2025-04-11T13:03:26Z | Attended By Officer | P Anusha | r | {"id": "103255140333", "mobile_number": "9121242764", "posted_by": "P Anusha", "remarks": "r", "status": "Attended By Officer", "time_stamp": "11-APR-2025 18:33:26"} |
| 59 | 37 37 | 2 | 103255140333 | 9966651103 | 2025-03-05T14:37:09Z | Open | BVenkat | working now | {"id": "103255140333", "mobile_number": "9966651103", "posted_by": "BVenkat", "remarks": "working now", "status": "Open", "time_stamp": "05-MAR-2025 20:07:09"} |
| 60 | 38 38 | 1 | 103255140334 | 6281450159 | 2025-03-15T10:14:57Z | Attended By Officer | Sri.K.Balaiah | completed | {"id": "103255140334", "mobile_number": "6281450159", "posted_by": "Sri.K.Balaiah", "remarks": "completed", "status": "Attended By Officer", "time_stamp": "15-MAR-2025 15:44:57"} |
| 61 | 39 39 | 1 | 103255140335 | 9154296589 | 2025-03-11T12:26:23Z | Attended By Officer | P.Venkateshwar Goud | Rectified | {"id": "103255140335", "mobile_number": "9154296589", "posted_by": "P.Venkateshwar Goud", "remarks": "Rectified", "status": "Attended By Officer", "time_stamp": "11-MAR-2025 17:56:23"} |
| 62 | 40 40 | 1 | 103255140336 | 7386999029 | 2025-03-04T03:55:03Z | Closed | vinaysingh | - | {"id": "103255140336", "mobile_number": "7386999029", "posted_by": "vinaysingh", "remarks": "-", "status": "Closed", "time_stamp": "04-MAR-2025 09:25:03"} |
| 63 | 40 40 | 2 | 103255140336 | 9121245035 | 2025-03-04T02:27:08Z | Attended By Officer | Sri K. Raghupathi reddy | sir Rectified | {"id": "103255140336", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir Rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 07:57:08"} |
| 64 | 40 40 | 3 | 103255140336 | 9121245035 | 2025-03-04T02:26:12Z | Attended By Officer | Sri K. Raghupathi reddy | sir Rectified | {"id": "103255140336", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir Rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 07:56:12"} |
| 65 | 41 41 | 1 | 103255140337 | 7207923101 | 2025-03-03T08:39:47Z | Attended By Officer | Dr.YADAGIRI | attended caught 2 Dogs | {"id": "103255140337", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "attended caught 2 Dogs", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 14:09:47"} |
| 66 | 42 42 | 1 | 103255140338 | 9951960555 | 2025-09-03T15:10:33Z | Attended By Officer | Kishore Movva | ok | {"id": "103255140338", "mobile_number": "9951960555", "posted_by": "Kishore Movva", "remarks": "ok", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 20:40:33"} |
| 67 | 42 42 | 2 | 103255140338 | 9951960555 | 2025-09-03T15:09:10Z | Attended By Officer | Kishore Movva | ok | {"id": "103255140338", "mobile_number": "9951960555", "posted_by": "Kishore Movva", "remarks": "ok", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 20:39:10"} |
| 68 | 42 42 | 3 | 103255140338 | 9951960555 | 2025-09-03T15:07:00Z | Attended By Officer | Kishore Movva | ok | {"id": "103255140338", "mobile_number": "9951960555", "posted_by": "Kishore Movva", "remarks": "ok", "status": "Attended By Officer", "time_stamp": "03-SEP-2025 20:37:00"} |
| 69 | 42 42 | 4 | 103255140338 | 9885198396 | 2025-03-07T09:44:32Z | Attended By Officer | Dr. Vijay Mohan Rao | Spray work | {"id": "103255140338", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "Spray work", "status": "Attended By Officer", "time_stamp": "07-MAR-2025 15:14:32"} |
| 70 | 43 43 | 1 | 103255140339 | 9154931433 | 2025-03-01T05:32:16Z | Attended By Officer | Dr Y Hema latha | compliant resolved asp per SFA confirmation | {"id": "103255140339", "mobile_number": "9154931433", "posted_by": "Dr Y Hema latha", "remarks": "compliant resolved asp per SFA confirmation", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 11:02:16"} |
| 71 | 44 44 | 1 | 103255140340 | 8008556852 | 2025-04-21T18:39:33Z | Attended By Officer | Sri E. Nagi Reddy | Action may be initiated as per the due procedure of law. | {"id": "103255140340", "mobile_number": "8008556852", "posted_by": "Sri E. Nagi Reddy", "remarks": "Action may be initiated as per the due procedure of law.", "status": "Attended By Officer", "time_stamp": "22-APR-2025 00:09:33"} |
| 72 | 48 48 | 1 | 103255140344 | 9100025128 | 2025-03-04T13:27:31Z | Attended By Officer | Sri. T.R.Prasad | rectified | {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 18:57:31"} |
| 73 | 48 48 | 2 | 103255140344 | 9246180220 | 2025-03-03T14:19:04Z | Attended By Officer | asrinivasaRao | problem not solved and ticket says it is resolved … lights still blinking and not working properly .pl resolve properly and solve the problem . without solving don’t close the tickets | {"id": "103255140344", "mobile_number": "9246180220", "posted_by": "asrinivasaRao", "remarks": "problem not solved and ticket says it is resolved … lights still blinking and not working properly .pl resolve properly and solve the problem . without solving don’t close the tickets", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 19:49:04"} |
| 74 | 48 48 | 3 | 103255140344 | 9100025128 | 2025-03-03T13:11:49Z | Attended By Officer | Sri. T.R.Prasad | rectified | {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 18:41:49"} |
| 75 | 48 48 | 4 | 103255140344 | 9100025128 | 2025-03-01T06:00:00Z | Open | Sri. T.R.Prasad | f | {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "f", "status": "Open", "time_stamp": "01-MAR-2025 11:30:00"} |
| 76 | 48 48 | 5 | 103255140344 | 9100025128 | 2025-03-01T01:41:16Z | Open | Sri. T.R.Prasad | 2 | {"id": "103255140344", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "2", "status": "Open", "time_stamp": "01-MAR-2025 07:11:16"} |
| 77 | 49 49 | 1 | 103255140345 | - | 2025-03-05T11:20:52Z | - | Call Centre | Satisfied | {"id": "103255140345", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "05-MAR-2025 16:50:52"} |
| 78 | 49 49 | 2 | 103255140345 | 7207923101 | 2025-03-03T08:45:40Z | Attended By Officer | Dr.YADAGIRI | attended caught 2 Dogs | {"id": "103255140345", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "attended caught 2 Dogs", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 14:15:40"} |
| 79 | 49 49 | 3 | 103255140345 | 7207923101 | 2025-03-03T08:45:05Z | Attended By Officer | Dr.YADAGIRI | attended caught 2 Dogs | {"id": "103255140345", "mobile_number": "7207923101", "posted_by": "Dr.YADAGIRI", "remarks": "attended caught 2 Dogs", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 14:15:05"} |
| 80 | 50 50 | 1 | 103255140346 | 9989930669 | 2025-03-01T03:34:33Z | Attended By Officer | Ajaj Kumar | solved | {"id": "103255140346", "mobile_number": "9989930669", "posted_by": "Ajaj Kumar", "remarks": "solved", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 09:04:33"} |
| 81 | 51 51 | 1 | 103255140347 | - | 2025-03-10T09:41:13Z | - | Call Centre | Satisfied | {"id": "103255140347", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "10-MAR-2025 15:11:13"} |
| 82 | 51 51 | 2 | 103255140347 | 8374865307 | 2025-03-03T04:07:43Z | Attended By Officer | Dr. Bharghava Narayana | clear | {"id": "103255140347", "mobile_number": "8374865307", "posted_by": "Dr. Bharghava Narayana", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 09:37:43"} |
| 83 | 53 53 | 1 | 103255140349 | 9154909250 | 2025-03-02T01:28:29Z | Attended By Officer | Dr.Md Irshad Iqbal | Issue has been resolved, thank you | {"id": "103255140349", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Issue has been resolved, thank you", "status": "Attended By Officer", "time_stamp": "02-MAR-2025 06:58:29"} |
| 84 | 53 53 | 2 | 103255140349 | 9182761947 | 2025-03-01T05:46:31Z | Attended By Officer | Idrees | Not cleaned yet | {"id": "103255140349", "mobile_number": "9182761947", "posted_by": "Idrees", "remarks": "Not cleaned yet", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 11:16:31"} |
| 85 | 53 53 | 3 | 103255140349 | 9154909250 | 2025-03-01T05:38:33Z | Attended By Officer | Dr.Md Irshad Iqbal | Issue has been resolved | {"id": "103255140349", "mobile_number": "9154909250", "posted_by": "Dr.Md Irshad Iqbal", "remarks": "Issue has been resolved", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 11:08:33"} |
| 86 | 55 55 | 1 | 103255140351 | 9154299704 | 2025-04-30T09:15:50Z | Attended By Officer | Musharfuddin | k | {"id": "103255140351", "mobile_number": "9154299704", "posted_by": "Musharfuddin", "remarks": "k", "status": "Attended By Officer", "time_stamp": "30-APR-2025 14:45:50"} |
| 87 | 56 56 | 1 | 103255140352 | - | 2025-03-05T04:58:13Z | - | Call Centre | Not Satisfied | {"id": "103255140352", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-MAR-2025 10:28:13"} |
| 88 | 56 56 | 2 | 103255140352 | 9154369424 | 2025-03-01T09:44:24Z | Attended By Officer | Dr.B.J. Vanaja Kumari | attended 2 to 4 abc dogs | {"id": "103255140352", "mobile_number": "9154369424", "posted_by": "Dr.B.J. Vanaja Kumari", "remarks": "attended 2 to 4 abc dogs", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 15:14:24"} |
| 89 | 57 57 | 1 | 103255140353 | 9346014249 | 2025-03-10T02:51:46Z | Attended By Officer | Dr.Bheekya | Attend | {"id": "103255140353", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "Attend", "status": "Attended By Officer", "time_stamp": "10-MAR-2025 08:21:46"} |
| 90 | 57 57 | 2 | 103255140353 | 7675035221 | 2025-03-08T18:44:38Z | Attended By Officer | vaishnavi | no one came | {"id": "103255140353", "mobile_number": "7675035221", "posted_by": "vaishnavi", "remarks": "no one came", "status": "Attended By Officer", "time_stamp": "09-MAR-2025 00:14:38"} |
| 91 | 57 57 | 3 | 103255140353 | - | 2025-03-03T05:57:17Z | - | Call Centre | Not Satisfied | {"id": "103255140353", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "03-MAR-2025 11:27:17"} |
| 92 | 57 57 | 4 | 103255140353 | 9346014249 | 2025-03-01T06:29:05Z | Attended By Officer | Dr.Bheekya | attended | {"id": "103255140353", "mobile_number": "9346014249", "posted_by": "Dr.Bheekya", "remarks": "attended", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 11:59:05"} |
| 93 | 59 59 | 1 | 103255140355 | - | 2025-03-05T10:54:30Z | - | Call Centre | Not Satisfied | {"id": "103255140355", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-MAR-2025 16:24:30"} |
| 94 | 59 59 | 2 | 103255140355 | 8121041420 | 2025-03-01T04:53:07Z | Attended By Officer | Dr.Abdul Basith | Sir this complaint pertains to the ameenpur muncipality limits | {"id": "103255140355", "mobile_number": "8121041420", "posted_by": "Dr.Abdul Basith", "remarks": "Sir this complaint pertains to the ameenpur muncipality limits", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 10:23:07"} |
| 95 | 59 59 | 3 | 103255140355 | 9908019558 | 2025-03-01T02:14:58Z | Open | shareef | Citizen Informed That The Grievance Has Been Pending. So Please Take Necessary Action.Thank You Sir | {"id": "103255140355", "mobile_number": "9908019558", "posted_by": "shareef", "remarks": "Citizen Informed That The Grievance Has Been Pending. So Please Take Necessary Action.Thank You Sir", "status": "Open", "time_stamp": "01-MAR-2025 07:44:58"} |
| 96 | 60 60 | 1 | 103255140356 | 9885198396 | 2025-03-05T08:01:43Z | Attended By Officer | Dr. Vijay Mohan Rao | drone spraying at khajaguda chervu | {"id": "103255140356", "mobile_number": "9885198396", "posted_by": "Dr. Vijay Mohan Rao", "remarks": "drone spraying at khajaguda chervu", "status": "Attended By Officer", "time_stamp": "05-MAR-2025 13:31:43"} |
| 97 | 60 60 | 2 | 103255140356 | 9154848199 | 2025-03-01T02:07:42Z | Open | THE FIRST BY DSR AOMACS | mosquito MENACE | {"id": "103255140356", "mobile_number": "9154848199", "posted_by": "THE FIRST BY DSR AOMACS", "remarks": "mosquito MENACE", "status": "Open", "time_stamp": "01-MAR-2025 07:37:42"} |
| 98 | 61 61 | 1 | 103255140357 | 7989301584 | 2025-03-05T03:13:40Z | Attended By Officer | Dr.K.Manjula | sweeping clear | {"id": "103255140357", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "05-MAR-2025 08:43:40"} |
| 99 | 61 61 | 2 | 103255140357 | 8885522255 | 2025-03-04T11:21:49Z | Attended By Officer | Nagendra | No show by the Sweepers inspite of repeated complaints. The Officer is just closing the complaint when ai tried to call and reach no response on the phone number. The image uploaded in the comments is not our street. Wake up | {"id": "103255140357", "mobile_number": "8885522255", "posted_by": "Nagendra", "remarks": "No show by the Sweepers inspite of repeated complaints. The Officer is just closing the complaint when ai tried to call and reach no response on the phone number. The image uploaded in the comments is not our street. Wake up", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 16:51:49"} |
| 100 | 61 61 | 3 | 103255140357 | 7989301584 | 2025-03-02T22:59:11Z | Attended By Officer | Dr.K.Manjula | sweeping clear | {"id": "103255140357", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "03-MAR-2025 04:29:11"} |
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)
);