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 | 110255503091 | 2026-04-15T13:17:22Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503091 | Repairs to Road (Pot holes) | Esamiya bazar Vishnu medical hall location | 6304158308 | 2025-09-30T20:26:58Z | Closed | Ramesh | main road side | AEE/ENG,,Yakutpura | 8712013131 | 110255503091.jpg p2110255503091.jpg p3110255503091.jpg | {"comments": [{"id": "110255503091", "mobile_number": "9440449486", "posted_by": "Sri S Sairam Reddy", "remarks": "it pertains to HMWSSB", "status": "Closed", "time_stamp": "06-OCT-2025 12:34:06"}], "grievance": {"assigned_to": "AEE/ENG,,Yakutpura", "complaint_type": "Repairs to Road (Pot holes)", "id": "110255503091", "land_mark": "Esamiya bazar Vishnu medical hall location", "mobile_number": "6304158308", "officer_remarks": "", "phone_to_call": "8712013131", "photo": "110255503091.jpg p2110255503091.jpg p3110255503091.jpg", "raised_by": "Ramesh", "remarks": "main road side", "status": "Closed", "time_stamp": "01-OCT-2025 01:56:58"}, "photos": [{"name": "110255503091.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503091.jpg"}, {"name": "p2110255503091.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503091.jpg"}, {"name": "p3110255503091.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3110255503091.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503091"} | sha256:8a934f3295c6c4f53b6288e7a79c06d10afdb8c41d24acbf16d511159545d1b6 |