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

57,010 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

87,399 rows

snapshot_photos

snapshot_pk, ordinal, name, url

36,846 rows

Views

Download SQLite DB: aug-2025.db 132.5 MB