home / nov-2025 / complaint_snapshots

complaint_snapshots: 50

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
50 111255552201 2026-04-15T10:59:13Z https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552201 Footpath Blocked UMA RAMALINGESWARA TEMPLE, BHAWANI COLONY 9398584237 2025-11-01T01:23:42Z Closed ADITYA footpath encroachment by shopkeepers and tent service people with too many dead bushes and exposed metals and exposed garbage ACP,,Badangpet   9032027021 111255552201.jpg p2111255552201.jpg p3111255552201.jpg {"comments": [{"id": "111255552201", "mobile_number": "9398584237", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "25-NOV-2025 14:30:02"}, {"id": "111255552201", "mobile_number": "7075506696", "posted_by": "C. SREEDHAR", "remarks": "It is to inform you that this office will fixed up a mass encroachment removal program as soon as possible with assistance of police department.", "status": "Attended By Officer", "time_stamp": "12-NOV-2025 23:15:35"}, {"id": "111255552201", "mobile_number": "9398584237", "posted_by": "ADITYA", "remarks": "footpath still blocked, material from tent shop still lying around, bushes are still outgrowing", "status": "Open", "time_stamp": "07-NOV-2025 16:52:01"}, {"id": "111255552201", "mobile_number": "7075506696", "posted_by": "C. SREEDHAR", "remarks": "It is to inform you that this office will fixed up a mass Encroachment removel program as soon as possible with assistance of police department.", "status": "Attended By Officer", "time_stamp": "06-NOV-2025 10:44:07"}], "grievance": {"assigned_to": "ACP,,Badangpet", "complaint_type": "Footpath Blocked", "id": "111255552201", "land_mark": "UMA RAMALINGESWARA TEMPLE, BHAWANI COLONY", "mobile_number": "9398584237", "officer_remarks": "", "phone_to_call": "9032027021", "photo": "111255552201.jpg p2111255552201.jpg p3111255552201.jpg", "raised_by": "ADITYA", "remarks": "footpath encroachment by shopkeepers and tent service people with too many dead bushes and exposed metals and exposed garbage", "status": "Closed", "time_stamp": "01-NOV-2025 06:53:42"}, "photos": [{"name": "111255552201.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552201.jpg"}, {"name": "p2111255552201.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552201.jpg"}, {"name": "p3111255552201.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3111255552201.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552201"} sha256:cd6ff8a627a13b256f35cd4b9310600cf845b0bc1e0f6b4790db04a41298c0a4

Links from other tables

  • 3 rows from snapshot_pk in snapshot_photos
  • 4 rows from snapshot_pk in snapshot_comments
Powered by Datasette · Queries took 0.948ms