complaint_snapshots

43,201 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: status_text, scraped_at (date), grievance_timestamp (date)

Next page

CREATE TABLE complaint_snapshots (
    snapshot_pk INTEGER PRIMARY KEY,
    complaint_id TEXT NOT NULL,
    scraped_at TEXT NOT NULL,
    source_url TEXT NOT NULL,
    complaint_type TEXT NOT NULL,
    landmark TEXT NOT NULL,
    mobile_number TEXT NOT NULL,
    grievance_timestamp TEXT NOT NULL,
    status_text TEXT NOT NULL,
    raised_by TEXT NOT NULL,
    remarks TEXT NOT NULL,
    assigned_to TEXT NOT NULL,
    officer_remarks TEXT NOT NULL,
    phone_to_call TEXT NOT NULL,
    grievance_photo_text TEXT NOT NULL,
    raw_payload_json TEXT NOT NULL,
    content_hash TEXT NOT NULL,
    UNIQUE(complaint_id, content_hash)
);
CREATE INDEX idx_complaint_snapshots_complaint_id
    ON complaint_snapshots(complaint_id);
CREATE INDEX idx_complaint_snapshots_scraped_at
    ON complaint_snapshots(scraped_at);