home / aug-2025 / complaint_snapshots

complaint_snapshots: 2

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
2 108255392612 2026-04-15T19:21:02Z https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392612 Mosquitoes Fogging Required Near zeenath masjid 9848812381 2025-07-31T18:37:35Z Closed Abedali khan Citizen Requested to Send Mosquito Fogging team at H NO 19-1-421/A Near zeenath masjid,bahadurpura,kamatipuri,RAMNASTURAPURA. Ward Entomology Supervisor,,Adibatla   9989930380   {"comments": [{"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-AUG-2025 10:07:08"}, {"id": "108255392612", "mobile_number": "7993360295", "posted_by": "M.Satish Kumar", "remarks": "done", "status": "Attended By Officer", "time_stamp": "06-AUG-2025 11:24:21"}, {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "M.Satish Kumar,Assistant Entomologist 7993360295 officer said he resolved as soon as possible", "status": "Open", "time_stamp": "05-AUG-2025 12:32:43"}, {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "Kept conference with M.Satish Kumar,Assistant Entomologist 7993360295 but call is not connecting", "status": "Open", "time_stamp": "04-AUG-2025 12:29:16"}, {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "03-AUG-2025 00:06:04"}, {"id": "108255392612", "mobile_number": "9848812381", "posted_by": "Abedali khan", "remarks": "Citizen informed that the grievance has been pending.So please take necessary action.Thank you sir.", "status": "Open", "time_stamp": "01-AUG-2025 19:42:18"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Adibatla", "complaint_type": "Mosquitoes Fogging Required", "id": "108255392612", "land_mark": "Near zeenath masjid", "mobile_number": "9848812381", "officer_remarks": "", "phone_to_call": "9989930380", "photo": "", "raised_by": "Abedali khan", "remarks": "Citizen Requested to Send Mosquito Fogging team at H NO 19-1-421/A Near zeenath masjid,bahadurpura,kamatipuri,RAMNASTURAPURA.", "status": "Closed", "time_stamp": "01-AUG-2025 00:07:35"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392612"} sha256:12378731e68c189bc553274550295bb6f35f3b5252490024443f269ff7afd0a8

Links from other tables

  • 0 rows from snapshot_pk in snapshot_photos
  • 6 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 16.254ms