snapshot_comments

6 rows where snapshot_pk = 24

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: mobile_number, status_text, posted_by, comment_timestamp (date)

comment_pk ▼ snapshot_pk ordinal complaint_id mobile_number comment_timestamp status_text posted_by remarks raw_comment_json
71 24 24 1 110255503094 7989823354 2025-12-05T08:54:07Z Attended By Officer Syed Yahiya Kamal Submit your registered documents through mee seva for mutation of property for further process {"id": "110255503094", "mobile_number": "7989823354", "posted_by": "Syed Yahiya Kamal", "remarks": "Submit your registered documents through mee seva for mutation of property for further process", "status": "Attended By Officer", "time_stamp": "05-DEC-2025 14:24:07"}
72 24 24 2 110255503094 8125668932 2025-12-02T14:21:44Z Open Krishna Anusuri GHMC records are not getting updated even after mutation fee is paid. I have attached mutation certificate also but no action is taken. I am chasing many times with no proper help. {"id": "110255503094", "mobile_number": "8125668932", "posted_by": "Krishna Anusuri", "remarks": "GHMC records are not getting updated even after mutation fee is paid. I have attached mutation certificate also but no action is taken. I am chasing many times with no proper help.", "status": "Open", "time_stamp": "02-DEC-2025 19:51:44"}
73 24 24 3 110255503094 8125668932 2025-12-01T20:42:40Z Open Krishna Anusuri I am attaching mutation certificate once again for you here that i have received in Feb 2025. I am not sure you are understanding my issue. I have already got mutation certificate. Do I still need to go to meeseva. Meeseva dept are saying to contact GHMC. Please assist. {"id": "110255503094", "mobile_number": "8125668932", "posted_by": "Krishna Anusuri", "remarks": "I am attaching mutation certificate once again for you here that i have received in Feb 2025. I am not sure you are understanding my issue. I have already got mutation certificate. Do I still need to go to meeseva. Meeseva dept are saying to contact GHMC. Please assist.", "status": "Open", "time_stamp": "02-DEC-2025 02:12:40"}
74 24 24 4 110255503094 7989823354 2025-12-01T06:36:51Z Attended By Officer Syed Yahiya Kamal For mutation of property, submit your registered documents and link also should be registered through mee seva for further process. {"id": "110255503094", "mobile_number": "7989823354", "posted_by": "Syed Yahiya Kamal", "remarks": "For mutation of property, submit your registered documents and link also should be registered through mee seva for further process.", "status": "Attended By Officer", "time_stamp": "01-DEC-2025 12:06:51"}
75 24 24 5 110255503094 8125668932 2025-11-29T23:08:11Z Open Krishna Anusuri I have already got mutation certificate / Transfer certificate. When getting mutation certificate only the link documents etc all got registered. GHMC records didnt get updated. Is it mee seva dept to update on GHMC staff to update. I have also requested online and I got acknowledgement number CTAO20251124231916. But no action taken till now. {"id": "110255503094", "mobile_number": "8125668932", "posted_by": "Krishna Anusuri", "remarks": "I have already got mutation certificate / Transfer certificate. When getting mutation certificate only the link documents etc all got registered. GHMC records didnt get updated. Is it mee seva dept to update on GHMC staff to update. I have also requested online and I got acknowledgement number CTAO20251124231916. But no action taken till now.", "status": "Open", "time_stamp": "30-NOV-2025 04:38:11"}
76 24 24 6 110255503094 7989823354 2025-10-02T10:05:03Z Attended By Officer Syed Yahiya Kamal submit your registered documents and link documents also should be registered and apply through meeseva for further process of mutation {"id": "110255503094", "mobile_number": "7989823354", "posted_by": "Syed Yahiya Kamal", "remarks": "submit your registered documents and link documents also should be registered and apply through meeseva for further process of mutation", "status": "Attended By Officer", "time_stamp": "02-OCT-2025 15:35:03"}

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