complaint_snapshots: 60
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 60 | 107255337714 | 2026-04-15T21:46:25Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337714 | Non Glowing of Street Lights | Swaroop beauty parlour | 9110352172 | 2025-07-01T01:05:24Z | Closed | gireesh | street light | AE/ENG,,Hayathnagar | 9502025421 | 107255337714.jpg p2107255337714.jpg p3107255337714.jpg | {"comments": [{"id": "107255337714", "mobile_number": "9110352172", "posted_by": "gireesh", "remarks": "Good response", "status": "Closed", "time_stamp": "04-JUL-2025 20:11:39"}, {"id": "107255337714", "mobile_number": "9154295249", "posted_by": "Sai Chandana", "remarks": "rec", "status": "Attended By Officer", "time_stamp": "04-JUL-2025 14:53:36"}, {"id": "107255337714", "mobile_number": "9704234838", "posted_by": "M Satya Narayana Reddy", "remarks": "belongs to begam bazer", "status": "Open", "time_stamp": "01-JUL-2025 09:00:20"}], "grievance": {"assigned_to": "AE/ENG,,Hayathnagar", "complaint_type": "Non Glowing of Street Lights", "id": "107255337714", "land_mark": "Swaroop beauty parlour", "mobile_number": "9110352172", "officer_remarks": "", "phone_to_call": "9502025421", "photo": "107255337714.jpg p2107255337714.jpg p3107255337714.jpg", "raised_by": "gireesh", "remarks": "street light", "status": "Closed", "time_stamp": "01-JUL-2025 06:35:24"}, "photos": [{"name": "107255337714.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337714.jpg"}, {"name": "p2107255337714.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337714.jpg"}, {"name": "p3107255337714.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3107255337714.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337714"} | sha256:d0be4cdc2e931446a89827fbd2b07f7c399d2a59e9a8d0853f843acbc6df8dc6 |