complaint_snapshots: 74
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 74 | 111255552226 | 2026-04-15T10:59:16Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552226 | Garbage Dump | khilwath | 8309677074 | 2025-11-01T02:09:41Z | Closed | moinuddin | NO SWEEPING BESIDE THE HOUSE SINCE 15 days. SPOKE TO SWEEPER LADY SHE REFUSED. | AE,,Hayathnagar | 7331170681 | 111255552226.jpg p2111255552226.jpg p3111255552226.jpg | {"comments": [{"id": "111255552226", "mobile_number": "8309677074", "posted_by": "Call Centre", "remarks": "Satisfied", "status": "Closed", "time_stamp": "08-NOV-2025 17:14:01"}, {"id": "111255552226", "mobile_number": "9949906795", "posted_by": "Dr. Chakrapani", "remarks": "Dear Citizen your grievance is resolved🙏", "status": "Attended By Officer", "time_stamp": "01-NOV-2025 13:15:31"}], "grievance": {"assigned_to": "AE,,Hayathnagar", "complaint_type": "Garbage Dump", "id": "111255552226", "land_mark": "khilwath", "mobile_number": "8309677074", "officer_remarks": "", "phone_to_call": "7331170681", "photo": "111255552226.jpg p2111255552226.jpg p3111255552226.jpg", "raised_by": "moinuddin", "remarks": "NO SWEEPING BESIDE THE HOUSE SINCE 15 days. SPOKE TO SWEEPER LADY SHE REFUSED.", "status": "Closed", "time_stamp": "01-NOV-2025 07:39:41"}, "photos": [{"name": "111255552226.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/111255552226.jpg"}, {"name": "p2111255552226.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2111255552226.jpg"}, {"name": "p3111255552226.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3111255552226.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0111255552226"} | sha256:29a3b3383aec6cf573a14c63199fb386179bb7886b3379d229717412ddcb9cd8 |