complaint_snapshots: 70
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 70 | 103255140366 | 2026-04-21T14:15:31Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140366 | Garbage Dump | street garbage | 9010128515 | 2025-03-01T02:12:37Z | Attended By Officer | deepak | Vijaya diagnostic safilguda | AE,,Karwan | 7995007410 | 103255140366.jpg | {"comments": [{"id": "103255140366", "mobile_number": "7997951628", "posted_by": "Malkajgiri", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 17:59:28"}], "grievance": {"assigned_to": "AE,,Karwan", "complaint_type": "Garbage Dump", "id": "103255140366", "land_mark": "street garbage", "mobile_number": "9010128515", "officer_remarks": "", "phone_to_call": "7995007410", "photo": "103255140366.jpg", "raised_by": "deepak", "remarks": "Vijaya diagnostic safilguda", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 07:42:37"}, "photos": [{"name": "103255140366.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/103255140366.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140366"} | sha256:a0b355a07b65a1a812043b1cc285328607da8b3cc549be6180d95f8e3e23935f |