dec-2025

Custom SQL query

Tables

complaint_snapshots

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

42,454 rows

snapshot_comment_photos

comment_pk, ordinal, name, url

0 rows

snapshot_comments

comment_pk, snapshot_pk, ordinal, complaint_id, mobile_number, comment_timestamp, status_text, posted_by, remarks, raw_comment_json

73,968 rows

snapshot_photos

snapshot_pk, ordinal, name, url

29,679 rows

Views

Download SQLite DB: dec-2025.db 104.7 MB