complaint_snapshots: 4
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4 | 110255503074 | 2026-04-15T13:17:20Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503074 | Non Glowing of Street Lights | near chirragoni residency apartments | 9246534147 | 2025-09-30T18:38:59Z | Attended By Officer | A Rama Devi | street lights not coming | AE/ENG,,Karwan | 7995009103 | 110255503074.jpg p2110255503074.jpg | {"comments": [{"id": "110255503074", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "sir rectified", "status": "Attended By Officer", "time_stamp": "08-OCT-2025 15:46:22"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Non Glowing of Street Lights", "id": "110255503074", "land_mark": "near chirragoni residency apartments", "mobile_number": "9246534147", "officer_remarks": "", "phone_to_call": "7995009103", "photo": "110255503074.jpg p2110255503074.jpg", "raised_by": "A Rama Devi", "remarks": "street lights not coming", "status": "Attended By Officer", "time_stamp": "01-OCT-2025 00:08:59"}, "photos": [{"name": "110255503074.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/110255503074.jpg"}, {"name": "p2110255503074.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2110255503074.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0110255503074"} | sha256:b17f6ab4f6f4462ef8b7746b0009d4510c34c174957f5cd4ee1aa37fdb1be4be |