home / jun-2025 / complaint_snapshots

complaint_snapshots: 19

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
19 106255287913 2026-04-16T18:23:28Z https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287913 Mosquitoes Fogging Required Royal see hotel, 9866098728 2025-05-31T19:47:59Z Attended By Officer Jaya Ram Citizen Requested to Send Mosquito Fogging team at h no 12-1-490/9, Near Royal see hotel, Shanker Nagar, Mehdipatnam. Ward Entomology Supervisor,,Chandrayangutta   9849691788   {"comments": [{"id": "106255287913", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "-", "time_stamp": "14-JUN-2025 15:00:52"}, {"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"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Chandrayangutta", "complaint_type": "Mosquitoes Fogging Required", "id": "106255287913", "land_mark": "Royal see hotel,", "mobile_number": "9866098728", "officer_remarks": "", "phone_to_call": "9849691788", "photo": "", "raised_by": "Jaya Ram", "remarks": "Citizen Requested to Send Mosquito Fogging team at h no 12-1-490/9, Near Royal see hotel, Shanker Nagar, Mehdipatnam.", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 01:17:59"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287913"} sha256:94ceaff4a43fcf547b1f120367ec626f6507a7bebd6f0d1e337dde4f14443e23

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 6.049ms