complaint_snapshots: 92
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 92 | 108255392707 | 2026-04-15T19:21:13Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392707 | Garbage Vehicle Not Arrived (SAT) | plot no 128, beside Rama residency, Chandanagar | 9892088322 | 2025-08-01T01:48:34Z | Attended By Officer | Saurabh | garbage picking person is not behaving properly. not picking garbage from last 5 days. troubling from last one month. pls call and help urgently | AE,,Bahadurpura | 8125971394 | 108255392707.jpg p2108255392707.jpg | {"comments": [{"id": "108255392707", "mobile_number": "8008103629", "posted_by": "A. Srinivas", "remarks": "attend", "status": "Attended By Officer", "time_stamp": "03-AUG-2025 22:39:49"}, {"id": "108255392707", "mobile_number": "7997951621", "posted_by": "Chanda Nagar", "remarks": "..", "status": "Open", "time_stamp": "01-AUG-2025 10:50:55"}], "grievance": {"assigned_to": "AE,,Bahadurpura", "complaint_type": "Garbage Vehicle Not Arrived (SAT)", "id": "108255392707", "land_mark": "plot no 128, beside Rama residency, Chandanagar", "mobile_number": "9892088322", "officer_remarks": "", "phone_to_call": "8125971394", "photo": "108255392707.jpg p2108255392707.jpg", "raised_by": "Saurabh", "remarks": "garbage picking person is not behaving properly. not picking garbage from last 5 days. troubling from last one month. pls call and help urgently", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 07:18:34"}, "photos": [{"name": "108255392707.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392707.jpg"}, {"name": "p2108255392707.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392707.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392707"} | sha256:9ea20e44151dff0ef5a96f4cd3ed7c698c5aa8bef5320b5a6a2bb9fd17370e9f |