home / jun-2025 / complaint_snapshots

complaint_snapshots: 73

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
73 106255287966 2026-04-16T18:23:34Z https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287966 Garbage Vehicle Not Arrived (SAT) saileela enclave kapra 7799991113 2025-06-01T02:13:34Z Attended By Officer Mopidevi sarada it is been 1 week garbage is not collected they are not coming regularly to our colony if they even come they dont cover all the houses this time they came on monday and till today no one have come to collect the garbage especially to my home AE,,Keesara   8106977609 106255287966.jpg p2106255287966.jpg {"comments": [{"id": "106255287966", "mobile_number": "-", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "-", "time_stamp": "17-JUN-2025 14:29:34"}, {"id": "106255287966", "mobile_number": "9959997758", "posted_by": "S.Nagaraju", "remarks": "clear sir", "status": "Attended By Officer", "time_stamp": "03-JUN-2025 07:40:05"}, {"id": "106255287966", "mobile_number": "7997951601", "posted_by": "Kapra", "remarks": "Sanitation", "status": "Open", "time_stamp": "02-JUN-2025 08:58:53"}, {"id": "106255287966", "mobile_number": "7799991113", "posted_by": "Mopidevi sarada", "remarks": "no one came still garbage is there", "status": "Open", "time_stamp": "01-JUN-2025 11:03:56"}, {"id": "106255287966", "mobile_number": "7997951601", "posted_by": "Kapra", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 08:04:01"}], "grievance": {"assigned_to": "AE,,Keesara", "complaint_type": "Garbage Vehicle Not Arrived (SAT)", "id": "106255287966", "land_mark": "saileela enclave kapra", "mobile_number": "7799991113", "officer_remarks": "", "phone_to_call": "8106977609", "photo": "106255287966.jpg p2106255287966.jpg", "raised_by": "Mopidevi sarada", "remarks": "it is been 1 week garbage is not collected they are not coming regularly to our colony if they even come they dont cover all the houses this time they came on monday and till today no one have come to collect the garbage especially to my home", "status": "Attended By Officer", "time_stamp": "01-JUN-2025 07:43:34"}, "photos": [{"name": "106255287966.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/106255287966.jpg"}, {"name": "p2106255287966.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2106255287966.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0106255287966"} sha256:36fed59ee12e498dc01f4795a4a7c14c8e80cbc40f411e970ee2bf1168e1948f

Links from other tables

  • 2 rows from snapshot_pk in snapshot_photos
  • 5 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 1.826ms