complaint_snapshots: 53
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 105255241089 | 2026-04-17T05:51:40Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241089 | Overflowing of Nala / Drain | GKR nivas (besides Bake basket) | 9951905888 | 2025-05-01T01:30:53Z | Closed | B Ravindra Reddy | drainage overflow | AEE/ENG,,Bahadurpura | 9989211406 | 105255241089.jpg | {"comments": [{"id": "105255241089", "mobile_number": "7337364212", "posted_by": "Sri Santosh Reddy", "remarks": "Dear citizen sorry for the inconvenience caused.Pertains to HMWS and SB. Thank you", "status": "Closed", "time_stamp": "02-MAY-2025 10:13:49"}], "grievance": {"assigned_to": "AEE/ENG,,Bahadurpura", "complaint_type": "Overflowing of Nala / Drain", "id": "105255241089", "land_mark": "GKR nivas (besides Bake basket)", "mobile_number": "9951905888", "officer_remarks": "", "phone_to_call": "9989211406", "photo": "105255241089.jpg", "raised_by": "B Ravindra Reddy", "remarks": "drainage overflow", "status": "Closed", "time_stamp": "01-MAY-2025 07:00:53"}, "photos": [{"name": "105255241089.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241089.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241089"} | sha256:502df280d95e8729551a5dbd412a042bcd35455079868359086e4b86ec8844ae |