Posts

All individual posts.

Data license: Public Domain

2 rows where thread_id = 2803

✎ View and edit SQL

This data as json, CSV (advanced)

post_id ▼ thread_id thread_title post_number author_username post_date post_date_iso post_body
100053 2803 FS: 6'4 Josh Oldenburg Hullcrux 1 ToddsontheNose Jul 25, 2016 2016-07-25T15:31:10-0400 Awesome board. Going to see about getting a custom egg shape by Josh. I never take this thing out. $20 less for jammers. http://sandiego.craigslist.org/csd/for/5700771188.html Let me know if you have any questions/interested. Thanks! Todd
100173 2803 FS: 6'4 Josh Oldenburg Hullcrux 2 ToddsontheNose Jul 27, 2016 2016-07-27T06:49:04-0400 Too expensive? $400 for Jammers! Comes with new 8" Skip Frye fin and FCS leash.

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);