complaint_snapshots: 41
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 41 | 104255188623 | 2026-04-18T08:22:28Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188623 | Garbage Dump | opp manjeera tank | 9000103654 | 2025-04-01T00:51:48Z | Attended By Officer | narayana | garbage not cleared. please clear daily | AE,,Karwan | 7995007410 | 104255188623.jpg p2104255188623.jpg | {"comments": [{"id": "104255188623", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "garbage lifted", "status": "Attended By Officer", "time_stamp": "01-APR-2025 12:26:46"}], "grievance": {"assigned_to": "AE,,Karwan", "complaint_type": "Garbage Dump", "id": "104255188623", "land_mark": "opp manjeera tank", "mobile_number": "9000103654", "officer_remarks": "", "phone_to_call": "7995007410", "photo": "104255188623.jpg p2104255188623.jpg", "raised_by": "narayana", "remarks": "garbage not cleared. please clear daily", "status": "Attended By Officer", "time_stamp": "01-APR-2025 06:21:48"}, "photos": [{"name": "104255188623.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188623.jpg"}, {"name": "p2104255188623.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2104255188623.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188623"} | sha256:714b2edf8c1293b303a96d67ab03c1e254c7a6f83ff2369bab78b77c145af9d7 |