complaint_snapshots: 101
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 101 | 104255188683 | 2026-04-18T08:22:35Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188683 | HMWSSB | opposite Naraya hotel management college | 9985318034 | 2025-04-01T02:43:33Z | Attended By Officer | sarath Das | drain block overflowing | - | 104255188683.jpg | {"comments": [{"id": "104255188683", "mobile_number": "9849907745", "posted_by": "B Swamy", "remarks": "work is complete", "status": "Attended By Officer", "time_stamp": "09-APR-2025 13:37:14"}, {"id": "104255188683", "mobile_number": "9063816950", "posted_by": "Sri G Varun Dev", "remarks": "Pertains to HMWSSB.", "status": "Open", "time_stamp": "01-APR-2025 10:59:47"}], "grievance": {"assigned_to": "-", "complaint_type": "HMWSSB", "id": "104255188683", "land_mark": "opposite Naraya hotel management college", "mobile_number": "9985318034", "officer_remarks": "", "photo": "104255188683.jpg", "raised_by": "sarath Das", "remarks": "drain block overflowing", "status": "Attended By Officer", "time_stamp": "01-APR-2025 08:13:33"}, "photos": [{"name": "104255188683.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/104255188683.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0104255188683"} | sha256:05e346f865227eecdc017622e29628d45b065cb2b4499445269deffa360dcf97 |