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

48,154 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

61,584 rows

snapshot_photos

snapshot_pk, ordinal, name, url

28,675 rows

Views

Download SQLite DB: mar-2025.db 103.1 MB