complaint_snapshots: 34
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 34 | 109255451044 | 2026-04-15T15:19:02Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451044 | Bulk garbage dumps on roads | Near st Thomas church | 9663887878 | 2025-09-01T01:16:46Z | Attended By Officer | Srinivasareddy | Garbage dumpling | AE,,Bahadurpura | 8125971394 | {"comments": [{"id": "109255451044", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 18:52:13"}], "grievance": {"assigned_to": "AE,,Bahadurpura", "complaint_type": "Bulk garbage dumps on roads", "id": "109255451044", "land_mark": "Near st Thomas church", "mobile_number": "9663887878", "officer_remarks": "", "phone_to_call": "8125971394", "photo": "", "raised_by": "Srinivasareddy", "remarks": "Garbage dumpling", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 06:46:46"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451044"} | sha256:a4077bba7d3dd1daa8934dfbcd555a11f078ab22edef84dd1443089fe951ac8b |