home / merged / complaint_snapshots

complaint_snapshots: 56

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
56 108255392666 2026-04-15T19:21:09Z https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392666 Mosquito Menace in the Locality beside at Ann’s school petbasheerabad 9959012344 2025-08-01T00:58:44Z Open madhava in center of the city petbasheerabad for national hiway its just less than 200mtrs here in our street its looks like its a jungle area there so many trees inside there so many dogs snakes and pigs and many other animals with this we facing dengue fever and malaria there is no maintaince on this govt land I request you to plz remove all the trees and manitain its clean and green Ward Entomology Supervisor,,Golconda   9849117184 108255392666.jpg p2108255392666.jpg p3108255392666.jpg {"comments": [{"id": "108255392666", "mobile_number": "9989930451", "posted_by": "B.Uma Rani", "remarks": "Garbage", "status": "Open", "time_stamp": "02-AUG-2025 16:21:17"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Golconda", "complaint_type": "Mosquito Menace in the Locality", "id": "108255392666", "land_mark": "beside at Ann’s school petbasheerabad", "mobile_number": "9959012344", "officer_remarks": "", "phone_to_call": "9849117184", "photo": "108255392666.jpg p2108255392666.jpg p3108255392666.jpg", "raised_by": "madhava", "remarks": "in center of the city petbasheerabad for national hiway its just less than 200mtrs here in our street its looks like its a jungle area there so many trees inside there so many dogs snakes and pigs and many other animals with this we facing dengue fever and malaria there is no maintaince on this govt land I request you to plz remove all the trees and manitain its clean and green", "status": "Open", "time_stamp": "01-AUG-2025 06:28:44"}, "photos": [{"name": "108255392666.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392666.jpg"}, {"name": "p2108255392666.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392666.jpg"}, {"name": "p3108255392666.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3108255392666.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392666"} sha256:f16da8f3523650938cc98e988768a90b4497f268e7b346abddd9a44af1e8e0f8

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 1 row from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 2.25ms