home / apr-2025 / complaint_snapshots

complaint_snapshots: 74

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
74 104255188656 2026-04-18T08:22:32Z https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188656 Fallen Tree Branch 33-71/25 Sri v o colony near maishamma te mple r k puram 9177087177 2025-04-01T02:15:52Z Closed Subramanyam raju fallen tree branches not lifted which were cut on Friday 28th March noon UBD Manager,,Karwan   8639457193 104255188656.jpg {"comments": [{"id": "104255188656", "mobile_number": "9177087177", "posted_by": "Subramanyam raju", "remarks": "attended immediately thank you", "status": "Closed", "time_stamp": "01-APR-2025 20:03:25"}, {"id": "104255188656", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "complaint attended", "status": "Attended By Officer", "time_stamp": "01-APR-2025 12:23:55"}], "grievance": {"assigned_to": "UBD Manager,,Karwan", "complaint_type": "Fallen Tree Branch", "id": "104255188656", "land_mark": "33-71/25 Sri v o colony near maishamma te mple r k puram", "mobile_number": "9177087177", "officer_remarks": "", "phone_to_call": "8639457193", "photo": "104255188656.jpg", "raised_by": "Subramanyam raju", "remarks": "fallen tree branches not lifted which were cut on Friday 28th March noon", "status": "Closed", "time_stamp": "01-APR-2025 07:45:52"}, "photos": [{"name": "104255188656.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188656.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188656"} sha256:e7453fb03a8427d41be0e7db21971d89e26483cbe113ea1b2900decbbe73b16e

Links from other tables

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