complaint_snapshots: 47
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47 | 102265688302 | 2026-04-12T19:37:44Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688302 | Repairs to Road (Pot holes) | Bhavans school | 9642313581 | 2026-02-01T00:47:57Z | Attended By Officer | Karthik | Bhavans-CDM road | AEE/ENG,,Moula Ali | 7995007396 | 102265688302.png | {"comments": [{"id": "102265688302", "mobile_number": "7995007396", "posted_by": "K.satyalakshmi", "remarks": "sir shortly repair the potholes", "status": "Attended By Officer", "time_stamp": "10-FEB-2026 12:50:59"}], "grievance": {"assigned_to": "AEE/ENG,,Moula Ali", "complaint_type": "Repairs to Road (Pot holes)", "id": "102265688302", "land_mark": "Bhavans school", "mobile_number": "9642313581", "officer_remarks": "", "phone_to_call": "7995007396", "photo": "102265688302.png", "raised_by": "Karthik", "remarks": "Bhavans-CDM road", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 06:17:57"}, "photos": [{"name": "102265688302.png", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688302.png"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688302"} | sha256:664f23714fce07d5450c2eb141c7703eebb0b1d3c8b9c55cb235184d9fee267c |