complaint_snapshots: 20
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 102265688275 | 2026-04-12T19:37:16Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688275 | Mosquitoes Fogging Required | near swagat function hall | 9618645206 | 2026-01-31T19:39:33Z | Closed | siddharth | lot of mosquitos in the area | Ward Entomology Supervisor,,Boduppal | 8008050632 | 102265688275.jpg | {"comments": [{"id": "102265688275", "mobile_number": "9618645206", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "06-MAR-2026 15:23:18"}, {"id": "102265688275", "mobile_number": "8008050632", "posted_by": "Naresh Reddy", "remarks": "Attended", "status": "Attended By Officer", "time_stamp": "05-MAR-2026 16:44:26"}, {"id": "102265688275", "mobile_number": "8008060510", "posted_by": "Ramesh", "remarks": "not pertains to Kapra", "status": "Open", "time_stamp": "01-FEB-2026 10:03:45"}], "grievance": {"assigned_to": "Ward Entomology Supervisor,,Boduppal", "complaint_type": "Mosquitoes Fogging Required", "id": "102265688275", "land_mark": "near swagat function hall", "mobile_number": "9618645206", "officer_remarks": "", "phone_to_call": "8008050632", "photo": "102265688275.jpg", "raised_by": "siddharth", "remarks": "lot of mosquitos in the area", "status": "Closed", "time_stamp": "01-FEB-2026 01:09:33"}, "photos": [{"name": "102265688275.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688275.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688275"} | sha256:0557a5a1d6d41c17f5d81b32fe2b06c4fdd1ccf90568f57ebb29901b935a0e20 |