home / may-2025 / complaint_snapshots

complaint_snapshots: 43

This data as json

snapshot_pk complaint_id scraped_at source_url complaint_type landmark mobile_number grievance_timestamp status_text raised_by remarks assigned_to officer_remarks phone_to_call grievance_photo_text raw_payload_json content_hash
43 105255241079 2026-04-17T05:51:36Z https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241079 Desilting of Nala / Drain ,near kesari apartmen 9705311037 2025-05-01T01:14:48Z Attended By Officer Shiva prasad Citizen requested for removal of Debris from square shape man hole at h no 16-10-234/4/A/2,near kesari apartment,municipal colony,old malakpet, AE/ENG,,Uppal   7995007435   {"comments": [{"id": "105255241079", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "05-MAY-2025 16:35:16"}, {"id": "105255241079", "mobile_number": "9154172347", "posted_by": "Mubeen Pasha", "remarks": "Attended by IRT", "status": "Attended By Officer", "time_stamp": "03-MAY-2025 21:55:49"}], "grievance": {"assigned_to": "AE/ENG,,Uppal", "complaint_type": "Desilting of Nala / Drain", "id": "105255241079", "land_mark": ",near kesari apartmen", "mobile_number": "9705311037", "officer_remarks": "", "phone_to_call": "7995007435", "photo": "", "raised_by": "Shiva prasad", "remarks": "Citizen requested for removal of Debris from square shape man hole at h no 16-10-234/4/A/2,near kesari apartment,municipal colony,old malakpet,", "status": "Attended By Officer", "time_stamp": "01-MAY-2025 06:44:48"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241079"} sha256:487519ac764b1801ba8f66c45f4571a5821e52be39d1b6e42e98d97a700d54ac

Links from other tables

  • 0 rows from snapshot_pk in snapshot_photos
  • 2 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.051ms