complaint_snapshots: 44
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 44 | 109255451055 | 2026-04-15T15:19:04Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451055 | Repairs to Road (Pot holes) | nuvvullabanda outstand lane | 9348922221 | 2025-09-01T01:35:16Z | Closed | shivakumar | gunta | AE/ENG,,Boduppal | 9963370985 | 109255451055.jpg | {"comments": [{"id": "109255451055", "mobile_number": "7331170681", "posted_by": "Sri. B. Laxmi Deepak", "remarks": "Hmwssb", "status": "Closed", "time_stamp": "13-OCT-2025 13:57:49"}, {"id": "109255451055", "mobile_number": "7331170681", "posted_by": "Sri. B. Laxmi Deepak", "remarks": "sanction", "status": "Under Process", "time_stamp": "10-OCT-2025 15:31:32"}, {"id": "109255451055", "mobile_number": "7331189510", "posted_by": "Sri. D. Raj Kumar", "remarks": "ward no 11", "status": "Open", "time_stamp": "01-SEP-2025 15:23:32"}], "grievance": {"assigned_to": "AE/ENG,,Boduppal", "complaint_type": "Repairs to Road (Pot holes)", "id": "109255451055", "land_mark": "nuvvullabanda outstand lane", "mobile_number": "9348922221", "officer_remarks": "", "phone_to_call": "9963370985", "photo": "109255451055.jpg", "raised_by": "shivakumar", "remarks": "gunta", "status": "Closed", "time_stamp": "01-SEP-2025 07:05:16"}, "photos": [{"name": "109255451055.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/109255451055.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451055"} | sha256:14c590fadf89e7a2593ad739fbac8fbffedc14afe3e0c26ec3099ae7b900a620 |