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 | 104255188629 | 2026-04-18T08:22:29Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188629 | Non Glowing of Street Lights | Street light oposite to 148, phase-2, Lane-34 | 9490412634 | 2025-04-01T01:04:47Z | Attended By Officer | RajeevMenon | Street light non functional | AE/ENG,,Keesara | 8712013141 | 104255188629.jpg | {"comments": [{"id": "104255188629", "mobile_number": "9100025128", "posted_by": "Sri. T.R.Prasad", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "05-APR-2025 18:01:04"}], "grievance": {"assigned_to": "AE/ENG,,Keesara", "complaint_type": "Non Glowing of Street Lights", "id": "104255188629", "land_mark": "Street light oposite to 148, phase-2, Lane-34", "mobile_number": "9490412634", "officer_remarks": "", "phone_to_call": "8712013141", "photo": "104255188629.jpg", "raised_by": "RajeevMenon", "remarks": "Street light non functional", "status": "Attended By Officer", "time_stamp": "01-APR-2025 06:34:47"}, "photos": [{"name": "104255188629.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188629.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188629"} | sha256:5b4b92bd17df3d44fb600683ce0e2df1d29c599cec40c007314c46fd21d1ea8f |