complaint_snapshots: 75
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 75 | 102265688330 | 2026-04-12T19:38:13Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688330 | Street Lights Glowing Continuously | new Mamatha Nagar Nagole | 8108956507 | 2026-02-01T02:08:47Z | Closed | sreeramulu | request to arrange automatic on and off for streetlight glowing please look in to the matter | AE/ENG,,Nagole | 7337557261 | 102265688330.jpg p2102265688330.jpg | {"comments": [{"id": "102265688330", "mobile_number": "8108956507", "posted_by": "Call Centre", "remarks": "Not Satisfied", "status": "Closed", "time_stamp": "02-FEB-2026 16:17:18"}, {"id": "102265688330", "mobile_number": "7337557261", "posted_by": "P Vineel Kumar Goud", "remarks": "rectified", "status": "Attended By Officer", "time_stamp": "01-FEB-2026 17:07:57"}], "grievance": {"assigned_to": "AE/ENG,,Nagole", "complaint_type": "Street Lights Glowing Continuously", "id": "102265688330", "land_mark": "new Mamatha Nagar Nagole", "mobile_number": "8108956507", "officer_remarks": "", "phone_to_call": "7337557261", "photo": "102265688330.jpg p2102265688330.jpg", "raised_by": "sreeramulu", "remarks": "request to arrange automatic on and off for streetlight glowing please look in to the matter", "status": "Closed", "time_stamp": "01-FEB-2026 07:38:47"}, "photos": [{"name": "102265688330.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688330.jpg"}, {"name": "p2102265688330.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688330.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688330"} | sha256:81a0c8e858e800fc5575b2a13714801619feaa440281bbc43906b64b438f5ac8 |