complaint_snapshots: 40
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 40 | 109255451050 | 2026-04-15T15:19:03Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451050 | Street Sweeping Not Done | Road NO 3, | 9948050373 | 2025-09-01T01:25:44Z | Closed | Deepak | Citizen Complained regarding Street Sweeping is not done at H no 1-334, Road NO 3, mALLIKARJUNA NAGAR, Malkajgiri | AE,,Mehdipatnam | 7331189506 | {"comments": [{"id": "109255451050", "mobile_number": "9948050373", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "02-SEP-2025 10:19:13"}, {"id": "109255451050", "mobile_number": "7989301584", "posted_by": "Dr.K.Manjula", "remarks": "sweeping clear", "status": "Attended By Officer", "time_stamp": "01-SEP-2025 14:01:50"}], "grievance": {"assigned_to": "AE,,Mehdipatnam", "complaint_type": "Street Sweeping Not Done", "id": "109255451050", "land_mark": "Road NO 3,", "mobile_number": "9948050373", "officer_remarks": "", "phone_to_call": "7331189506", "photo": "", "raised_by": "Deepak", "remarks": "Citizen Complained regarding Street Sweeping is not done at H no 1-334, Road NO 3, mALLIKARJUNA NAGAR, Malkajgiri", "status": "Closed", "time_stamp": "01-SEP-2025 06:55:44"}, "photos": [], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0109255451050"} | sha256:9b256d4437a566e3a618a0c74031460a4d244f1215102e50abe96af7eb42f4ad |