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

47,776 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

80,328 rows

snapshot_photos

snapshot_pk, ordinal, name, url

32,239 rows

Views

Download SQLite DB: oct-2025.db 115.9 MB