complaint_snapshots: 47
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 47 | 107255337702 | 2026-04-15T21:46:23Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337702 | Fallen Tree Branch | P and T - VSTColony | 9000498796 | 2025-07-01T00:24:18Z | Closed | DVYadagiri Rao | Tree branches fallen on road laying since one week | UBD Manager,,Masab Tank | 7981815871 | 107255337702.jpg p2107255337702.jpg | {"comments": [{"id": "107255337702", "mobile_number": "9505107172", "posted_by": "Maheshwari", "remarks": "electric", "status": "Closed", "time_stamp": "02-JUL-2025 18:45:54"}], "grievance": {"assigned_to": "UBD Manager,,Masab Tank", "complaint_type": "Fallen Tree Branch", "id": "107255337702", "land_mark": "P and T - VSTColony", "mobile_number": "9000498796", "officer_remarks": "", "phone_to_call": "7981815871", "photo": "107255337702.jpg p2107255337702.jpg", "raised_by": "DVYadagiri Rao", "remarks": "Tree branches fallen on road laying since one week", "status": "Closed", "time_stamp": "01-JUL-2025 05:54:18"}, "photos": [{"name": "107255337702.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337702.jpg"}, {"name": "p2107255337702.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337702.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337702"} | sha256:153bc33d963af5f07759b0177743d15e818911710c9138d4455fba876836cc69 |