complaint_snapshots: 98
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98 | 102265688353 | 2026-04-12T19:38:37Z | https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688353 | Water logging | Gowrinathpuram Kapra opp to Indian Bank | 8008247122 | 2026-02-01T02:44:10Z | Closed | Prashanth | water supply leakage | AEE/ENG,,Kapra | 7995009082 | 102265688353.jpg p2102265688353.jpg p3102265688353.jpg | {"comments": [{"id": "102265688353", "mobile_number": "7995009082", "posted_by": "N. Abhishek", "remarks": "Drinking water line", "status": "Closed", "time_stamp": "06-FEB-2026 19:23:38"}], "grievance": {"assigned_to": "AEE/ENG,,Kapra", "complaint_type": "Water logging", "id": "102265688353", "land_mark": "Gowrinathpuram Kapra opp to Indian Bank", "mobile_number": "8008247122", "officer_remarks": "", "phone_to_call": "7995009082", "photo": "102265688353.jpg p2102265688353.jpg p3102265688353.jpg", "raised_by": "Prashanth", "remarks": "water supply leakage", "status": "Closed", "time_stamp": "01-FEB-2026 08:14:10"}, "photos": [{"name": "102265688353.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/102265688353.jpg"}, {"name": "p2102265688353.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p2102265688353.jpg"}, {"name": "p3102265688353.jpg", "url": "https://GhmcMobileApp.ghmc.gov.in//Areas/grievancephotos/p3102265688353.jpg"}], "url": "https://igs.ghmc.gov.in/Operator/Status?cpno=0102265688353"} | sha256:57ce086686e3f6347f37bb8b64fbdc61dc7946104b4146d8773493081a206adf |