Posts
Data license: Public Domain
7 rows where thread_id = 2804
This data as json, CSV (advanced)
Suggested facets: author_username, post_date
| post_id ▼ | thread_id | thread_title | post_number | author_username | post_date | post_date_iso | post_body |
|---|---|---|---|---|---|---|---|
| 100061 | 2804 | Gato Heroi for Trade/Sale | 1 | NewportLogger | Jul 25, 2016 | 2016-07-25T16:19:22-0400 | Looking to trade this Gato noserider model. Ideally for another Gato, but open to offers... 9'6" x 23" x 3" Attached files |
| 100081 | 2804 | Gato Heroi for Trade/Sale | 2 | Guest | Jul 26, 2016 | 2016-07-26T05:14:27-0400 | Thats nice bro. Can we see the rails? Logoless? Robin never does that |
| 100082 | 2804 | Gato Heroi for Trade/Sale | 3 | applekat | Jul 26, 2016 | 2016-07-26T05:27:22-0400 | i was wondering about the logo as well, OD. Image processing. Refresh page to view |
| 100189 | 2804 | Gato Heroi for Trade/Sale | 4 | NewportLogger | Jul 27, 2016 | 2016-07-27T10:32:48-0400 | Robin has not been putting logos on any of the US Gatos for about the past year. Only Japan, Europe and Australia (which is phasing out the logos) |
| 100191 | 2804 | Gato Heroi for Trade/Sale | 5 | Guest | Jul 27, 2016 | 2016-07-27T10:45:37-0400 | Other than another gato what types of boards are you looking to trade for? |
| 100192 | 2804 | Gato Heroi for Trade/Sale | 6 | applekat | Jul 27, 2016 | 2016-07-27T10:45:58-0400 | i miss the plaid happy cat, admittedly.. Image processing. Refresh page to view |
| 100324 | 2804 | Gato Heroi for Trade/Sale | 7 | NewportLogger | Jul 28, 2016 | 2016-07-28T14:24:50-0400 | Maybe a Christenson Chris Craft.... |
Advanced export
JSON shape: default, array, newline-delimited, object
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);