complaint_snapshots: 11
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11 | 102255097095 | 2026-04-21T22:43:04Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097095 | New Street Light Requirement | shalivahan nagar street no3 near D/56 and D/101 | 8095811109 | 2025-01-31T18:48:08Z | Attended By Officer | madhuri | because of no street light since one month all men are passing urine in front of our building and throwing garbage -null | AE/ENG,,Uppal | 7995007435 | 102255097095.jpg p2102255097095.jpg | {"comments": [{"id": "102255097095", "mobile_number": "9154909321", "posted_by": "K.Raju", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "10-MAY-2025 16:44:47"}], "grievance": {"assigned_to": "AE/ENG,,Uppal", "complaint_type": "New Street Light Requirement", "id": "102255097095", "land_mark": "shalivahan nagar street no3 near D/56 and D/101", "mobile_number": "8095811109", "officer_remarks": "", "phone_to_call": "7995007435", "photo": "102255097095.jpg p2102255097095.jpg", "raised_by": "madhuri", "remarks": "because of no street light since one month all men are passing urine in front of our building and throwing garbage -null", "status": "Attended By Officer", "time_stamp": "01-FEB-2025 00:18:08"}, "photos": [{"name": "102255097095.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102255097095.jpg"}, {"name": "p2102255097095.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102255097095.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102255097095"} | sha256:cac4d6200983162da9a563ad1e6e7b9a344deeb28f32d25d427a8cce64248a34 |