complaint_snapshots: 76
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 76 | 108255392691 | 2026-04-15T19:21:11Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392691 | Repairs to Road (Pot holes) | Near Plot No 70 Maruthi Nagar | 9246245252 | 2025-08-01T01:30:49Z | Attended By Officer | VenkateshwarRao | Pot holes on x roads | AE/ENG,,Karwan | 7995007400 | 108255392691.jpg p2108255392691.jpg | {"comments": [{"id": "108255392691", "mobile_number": "7337557278", "posted_by": "Kum. M. Madhuirima", "remarks": "sir cleared", "status": "Attended By Officer", "time_stamp": "26-AUG-2025 16:42:46"}, {"id": "108255392691", "mobile_number": "9246245252", "posted_by": "VenkateshwarRao", "remarks": "Despite of repeated requests n reminders there is no response from your end Too casual approach", "status": "Open", "time_stamp": "04-AUG-2025 11:26:58"}], "grievance": {"assigned_to": "AE/ENG,,Karwan", "complaint_type": "Repairs to Road (Pot holes)", "id": "108255392691", "land_mark": "Near Plot No 70 Maruthi Nagar", "mobile_number": "9246245252", "officer_remarks": "", "phone_to_call": "7995007400", "photo": "108255392691.jpg p2108255392691.jpg", "raised_by": "VenkateshwarRao", "remarks": "Pot holes on x roads", "status": "Attended By Officer", "time_stamp": "01-AUG-2025 07:00:49"}, "photos": [{"name": "108255392691.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/108255392691.jpg"}, {"name": "p2108255392691.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2108255392691.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0108255392691"} | sha256:dfc171769eb52fcb27f39d26e14bbf2e482566bbba22316ec9322e6224a72ec4 |