complaint_snapshots: 53
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 53 | 107255337708 | 2026-04-15T21:46:24Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337708 | Fallen Tree Branch | Next to my house | 9391012969 | 2025-07-01T00:48:11Z | Open | kirti kapadia | since long cutting tree lying anf full of garbage opp construction work | UBD Manager,,Moosarambagh | 9010403052 | 107255337708.jpg p2107255337708.jpg | {"comments": [{"id": "107255337708", "mobile_number": "8074413745", "posted_by": "Smt.G.Joshna Priyadharshini", "remarks": "by lifting", "status": "Open", "time_stamp": "02-JUL-2025 11:31:30"}, {"id": "107255337708", "mobile_number": "7997951617", "posted_by": "Kharathabad", "remarks": ".", "status": "Open", "time_stamp": "02-JUL-2025 10:53:41"}], "grievance": {"assigned_to": "UBD Manager,,Moosarambagh", "complaint_type": "Fallen Tree Branch", "id": "107255337708", "land_mark": "Next to my house", "mobile_number": "9391012969", "officer_remarks": "", "phone_to_call": "9010403052", "photo": "107255337708.jpg p2107255337708.jpg", "raised_by": "kirti kapadia", "remarks": "since long cutting tree lying anf full of garbage opp construction work", "status": "Open", "time_stamp": "01-JUL-2025 06:18:11"}, "photos": [{"name": "107255337708.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/107255337708.jpg"}, {"name": "p2107255337708.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2107255337708.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0107255337708"} | sha256:58bf7e6ff7059cd376447a99bd459714689f0c5e48d73bedfc903082f2f1d095 |