home / feb-2025 / complaint_snapshots

complaint_snapshots: 15

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
15 102255097100 2026-04-21T22:43:04Z https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097100 Mosquitoes Fogging Required Neeraj colony Lane 2 9030574746 2025-01-31T18:54:20Z Attended By Officer MOHAMMED SULAIMAN no fogging done but closing request in 10 minutes -null Ward Entomology Supervisor,,Shamshabad   8790522342 102255097100.jpg p2102255097100.jpg p3102255097100.jpg {"comments": [{"id": "102255097100", "mobile_number": "9154299594", "posted_by": "B.Ramesh", "remarks": "done", "status": "Attended By Officer", "time_stamp": "05-FEB-2025 10:09:07"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Shamshabad", "complaint_type": "Mosquitoes Fogging Required", "id": "102255097100", "land_mark": "Neeraj colony Lane 2", "mobile_number": "9030574746", "officer_remarks": "", "phone_to_call": "8790522342", "photo": "102255097100.jpg p2102255097100.jpg p3102255097100.jpg", "raised_by": "MOHAMMED SULAIMAN", "remarks": "no fogging done but closing request in 10 minutes -null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 00:24:20"}, "photos": [{"name": "102255097100.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097100.jpg"}, {"name": "p2102255097100.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102255097100.jpg"}, {"name": "p3102255097100.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102255097100.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097100"} sha256:72002ce10ab9afa95b76c3604f3cffc2aedbaeda7bf0521b75746409170ca310

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