complaint_snapshots: 120
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 120 | 105255241155 | 2026-04-17T05:52:09Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241155 | Illegal Road Cutting | vmr convention hall | 8801549988 | 2025-05-01T03:01:22Z | Closed | naveennaveen | manholes buried for new road construction | AE/ENG,,Kapra | 7337557237 | 105255241155.jpg | {"comments": [{"id": "105255241155", "mobile_number": "7331189510", "posted_by": "Sri. D. Raj Kumar", "remarks": "pertains to HMWS", "status": "Closed", "time_stamp": "14-MAY-2025 13:07:52"}], "grievance": {"assigned_to": "AE/ENG,,Kapra", "complaint_type": "Illegal Road Cutting", "id": "105255241155", "land_mark": "vmr convention hall", "mobile_number": "8801549988", "officer_remarks": "", "phone_to_call": "7337557237", "photo": "105255241155.jpg", "raised_by": "naveennaveen", "remarks": "manholes buried for new road construction", "status": "Closed", "time_stamp": "01-MAY-2025 08:31:22"}, "photos": [{"name": "105255241155.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/105255241155.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0105255241155"} | sha256:b2454428436483dfeaf98a8459fcc1ea5263fcbb87fe91c0140d082bca78e1bf |