Posts
Data license: Public Domain
8 rows where thread_id = 2806
This data as json, CSV (advanced)
Suggested facets: author_username
| post_id ▼ | thread_id | thread_title | post_number | author_username | post_date | post_date_iso | post_body |
|---|---|---|---|---|---|---|---|
| 100100 | 2806 | Longboard spot of the day | 1 | Roadmaster | Jul 26, 2016 | 2016-07-26T09:21:44-0400 | obscure wave in Europe Attached files |
| 100102 | 2806 | Longboard spot of the day | 2 | Guest | Jul 26, 2016 | 2016-07-26T09:25:10-0400 | MY L O C A L Image processing. Refresh page to view |
| 100103 | 2806 | Longboard spot of the day | 3 | applekat | Jul 26, 2016 | 2016-07-26T10:00:18-0400 | shooting the pier at dusk. Image processing. Refresh page to view :? |
| 100108 | 2806 | Longboard spot of the day | 4 | Left Coast 46 | Jul 26, 2016 | 2016-07-26T10:57:43-0400 | OrangeDog wrote: MY L O C A L Image processing. Refresh page to view Click to expand... Look at that glass!!! |
| 100113 | 2806 | Longboard spot of the day | 5 | SMUKES | Jul 26, 2016 | 2016-07-26T11:15:20-0400 | Thot cardiff was your local |
| 100114 | 2806 | Longboard spot of the day | 6 | miscreant | Jul 26, 2016 | 2016-07-26T11:17:46-0400 | Roadmaster wrote: obscure wave in Europe Click to expand... i'd surf that. |
| 100116 | 2806 | Longboard spot of the day | 7 | Guest | Jul 26, 2016 | 2016-07-26T11:21:39-0400 | SMUKES wrote: Thot cardiff was your local Click to expand... In the fall and winter. Avoid in the spring summer |
| 100117 | 2806 | Longboard spot of the day | 8 | Roadmaster | Jul 26, 2016 | 2016-07-26T11:24:38-0400 | here are a couple of guys headed out to the obscure spot; called Ondalarga, located on Spains central coast. Attached files |
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);