home / merged / complaint_snapshots

complaint_snapshots: 90

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
90 108255392705 2026-04-15T19:21:13Z https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392705 Street Sweeping Not Done sri sai Avenue to Nala near cell tower Govt hospital Neredmet 9602450199 2025-08-01T01:47:31Z Attended By Officer C S Reddy Road sweeping not done. 3007255389419 dt 30 jul 24 closed with out doing job. kindly take necessary action in this regard AE,,Karwan   7995007410 108255392705.jpg p2108255392705.jpg {"comments": [{"id": "108255392705", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 13:35:23"}], "grievance": {"assigned_to": "AE,,Karwan", "complaint_type": "Street Sweeping Not Done", "id": "108255392705", "land_mark": "sri sai Avenue to Nala near cell tower Govt hospital Neredmet", "mobile_number": "9602450199", "officer_remarks": "", "phone_to_call": "7995007410", "photo": "108255392705.jpg p2108255392705.jpg", "raised_by": "C S Reddy", "remarks": "Road sweeping not done. 3007255389419 dt 30 jul 24 closed with out doing job. kindly take necessary action in this regard", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 07:17:31"}, "photos": [{"name": "108255392705.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392705.jpg"}, {"name": "p2108255392705.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392705.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392705"} sha256:5d989d06345de5fafb21a5e8e448cd86fb0b6152cb449f01426ace518dc31062

Links from other tables

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