nov-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

43,201 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

77,863 rows

snapshot_photos

snapshot_pk, ordinal, name, url

31,302 rows

Views

Download SQLite DB: nov-2025.db 108.2 MB