home / may-2025 / complaint_snapshots

complaint_snapshots: 21

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
21 105255241057 2026-04-17T05:51:27Z https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241057 TSSPDCL Hillview house Shramik Nagar in Google maps/ old john and roger school 9849131619 2025-04-30T21:43:10Z Open PVR SASTRY Three road side grown very tall causing very close electric line severe thunders bz of winds .Heavy thunders while the trees touched wires.. immediate action required pl.several thunders and sparks on 30 /4/25 night repeatedly.. emergency -     105255241057.jpg p2105255241057.jpg p3105255241057.jpg {"comments": [{"id": "105255241057", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "branches on electricity wires", "status": "Open", "time_stamp": "01-MAY-2025 18:14:00"}], "grievance": {"assigned_to": "-", "complaint_type": "TSSPDCL", "id": "105255241057", "land_mark": "Hillview house Shramik Nagar in Google maps/ old john and roger school", "mobile_number": "9849131619", "officer_remarks": "", "photo": "105255241057.jpg p2105255241057.jpg p3105255241057.jpg", "raised_by": "PVR SASTRY", "remarks": "Three road side grown very tall causing very close electric line severe thunders bz of winds .Heavy thunders while the trees touched wires.. immediate action required pl.several thunders and sparks on 30 /4/25 night repeatedly.. emergency", "status": "Open", "time_stamp": "01-MAY-2025 03:13:10"}, "photos": [{"name": "105255241057.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241057.jpg"}, {"name": "p2105255241057.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2105255241057.jpg"}, {"name": "p3105255241057.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3105255241057.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241057"} sha256:b244af86c31d576f8a3cc4fd1d7b6866af15ce0a3fd83807b35f3c8201598a8a

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