complaint_snapshots: 2

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
2 103255140298 2026-04-21T14:15:24Z https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140298 Non Glowing of Street Lights sri ram nagar,near Sai Baba temple 9959723506 2025-02-28T18:38:33Z Attended By Officer mdhaji last 4days se kon se bhi lights nai aatre AE/ENG,,Narsingi   7995007425 103255140298.jpg p2103255140298.jpg p3103255140298.jpg {"comments": [{"id": "103255140298", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "clear", "status": "Attended By Officer", "time_stamp": "04-MAR-2025 00:44:33"}, {"id": "103255140298", "mobile_number": "9121245035", "posted_by": "Sri K. Raghupathi reddy", "remarks": "box problem", "status": "Under Process", "time_stamp": "02-MAR-2025 05:48:16"}], "grievance": {"assigned_to": "AE/ENG,,Narsingi", "complaint_type": "Non Glowing of Street Lights", "id": "103255140298", "land_mark": "sri ram nagar,near Sai Baba temple", "mobile_number": "9959723506", "officer_remarks": "", "phone_to_call": "7995007425", "photo": "103255140298.jpg p2103255140298.jpg p3103255140298.jpg", "raised_by": "mdhaji", "remarks": "last 4days se kon se bhi lights nai aatre", "status": "Attended By Officer", "time_stamp": "01-MAR-2025 00:08:33"}, "photos": [{"name": "103255140298.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/103255140298.jpg"}, {"name": "p2103255140298.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2103255140298.jpg"}, {"name": "p3103255140298.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3103255140298.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0103255140298"} sha256:9f79d96a57124984774198f5b2fbf8cbc5d6bdeba1d0270c54bb124334a1abad

Links from other tables