complaint_snapshots: 57
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 57 | 108255392667 | 2026-04-15T19:21:09Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392667 | Encroachment of Roads | road number 20 | 9444723155 | 2025-08-01T01:00:32Z | Closed | krishna | sewerage overflow safety hazard and road blocking | ACP,,Shamshabad | 8712495966 | 108255392667.jpg p2108255392667.jpg p3108255392667.jpg | {"comments": [{"id": "108255392667", "mobile_number": "9949994037", "posted_by": "P Balananda Swamy", "remarks": "This complaint doesn't pertains to my circle", "status": "Closed", "time_stamp": "11-OCT-2025 16:06:06"}], "grievance": {"assigned_to": "ACP,,Shamshabad", "complaint_type": "Encroachment of Roads", "id": "108255392667", "land_mark": "road number 20", "mobile_number": "9444723155", "officer_remarks": "", "phone_to_call": "8712495966", "photo": "108255392667.jpg p2108255392667.jpg p3108255392667.jpg", "raised_by": "krishna", "remarks": "sewerage overflow safety hazard and road blocking", "status": "Closed", "time_stamp": "01-AUG-2025 06:30:32"}, "photos": [{"name": "108255392667.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392667.jpg"}, {"name": "p2108255392667.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392667.jpg"}, {"name": "p3108255392667.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3108255392667.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392667"} | sha256:0c26184b37ea5b403db7740ea5a9bbc7b9b21b401fe154e1aeb90a600e62a35f |