Posts

Data license: Public Domain

3,482 rows where thread_id = 501

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE posts (
            post_id         TEXT PRIMARY KEY,
            thread_id       TEXT,
            thread_title    TEXT,
            post_number     INTEGER,
            author_username TEXT,
            post_date       TEXT,
            post_date_iso   TEXT,
            post_body       TEXT,
            FOREIGN KEY (thread_id) REFERENCES threads(thread_id)
        );
CREATE INDEX idx_posts_thread   ON posts(thread_id);
CREATE INDEX idx_posts_author   ON posts(author_username);
CREATE INDEX idx_posts_date     ON posts(post_date_iso);