complaint_snapshots: 45
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 45 | 109255451056 | 2026-04-15T15:19:04Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451056 | Garbage Dump | sathi reddy colony, malkajgiri | 9000979737 | 2025-09-01T01:37:01Z | Attended By Officer | phani Kumar | garbage clearance | AE,,Mehdipatnam | 7331189506 | 109255451056.jpg p2109255451056.jpg | {"comments": [{"id": "109255451056", "mobile_number": "9000979737", "posted_by": "phani Kumar", "remarks": "not cleared.", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 16:47:29"}, {"id": "109255451056", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "garbage Lifting", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 12:27:49"}], "grievance": {"assigned_to": "AE,,Mehdipatnam", "complaint_type": "Garbage Dump", "id": "109255451056", "land_mark": "sathi reddy colony, malkajgiri", "mobile_number": "9000979737", "officer_remarks": "", "phone_to_call": "7331189506", "photo": "109255451056.jpg p2109255451056.jpg", "raised_by": "phani Kumar", "remarks": "garbage clearance", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 07:07:01"}, "photos": [{"name": "109255451056.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/109255451056.jpg"}, {"name": "p2109255451056.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2109255451056.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451056"} | sha256:7d61aa79f9e28314ef6d4c3abe4503395fe193a8e939b6e41f20e232b1ca0282 |