tweets
3 rows where "created_at" is on date 2021-09-01 and display_text_range = "[0, 279]" sorted by geo
This data as json, CSV (advanced)
id | user | created_at | full_text | retweeted_status | quoted_status | place | source | truncated | display_text_range | in_reply_to_status_id | in_reply_to_user_id | in_reply_to_screen_name | geo ▼ | coordinates | contributors | is_quote_status | retweet_count | favorite_count | favorited | retweeted | possibly_sensitive | lang | scopes |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1432864032235540480 | swyx 33521530 | 2021-09-01T00:33:01+00:00 | One of Java's advantages over C++ is automatic garbage collection, whereas one of Go's advantages over Java is its native CSP model. At a 50,000 ft view you can see languages as advancing by the number of hard problems that are elegantly solved by convention or language feature. https://twitter.com/swyx/status/1432864032235540480/photo/1 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1432864028842356736 | 33521530 | swyx | 0 | 4 | 17 | 0 | 0 | 0 | en | |||||||
1432864042343813120 | swyx 33521530 | 2021-09-01T00:33:03+00:00 | Cutting edge AWS stack for JS dev today: - App code in TypeScript - AWS CDK in TypeScript - 0.4-3 MB of SDK code serverside - (optional) 0.2-1 MB SDK code clientside - a dozen lines of config to make it work This is *good* - gives lots of control! Control that I may not need. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1432864040624091138 | 33521530 | swyx | 0 | 0 | 6 | 0 | 0 | en | ||||||||
1432977957388120064 | swyx 33521530 | 2021-09-01T08:05:43+00:00 | Sometimes it can be super frustrating when the machine just refuses to do what you want despite trying everything. But eventually you see that you just didn't understand the machine well enough. Humans made that machine, and there's always something you can do to take it apart. | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 279] | 1432977956259778565 | 33521530 | swyx | 0 | 5 | 68 | 0 | 0 | en |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [tweets] ( [id] INTEGER PRIMARY KEY, [user] INTEGER REFERENCES [users]([id]), [created_at] TEXT, [full_text] TEXT, [retweeted_status] INTEGER, [quoted_status] INTEGER, [place] TEXT REFERENCES [places]([id]), [source] TEXT REFERENCES [sources]([id]), [truncated] INTEGER, [display_text_range] TEXT, [in_reply_to_status_id] INTEGER, [in_reply_to_user_id] INTEGER, [in_reply_to_screen_name] TEXT, [geo] TEXT, [coordinates] TEXT, [contributors] TEXT, [is_quote_status] INTEGER, [retweet_count] INTEGER, [favorite_count] INTEGER, [favorited] INTEGER, [retweeted] INTEGER, [possibly_sensitive] INTEGER, [lang] TEXT, [scopes] TEXT, FOREIGN KEY([retweeted_status]) REFERENCES [tweets]([id]), FOREIGN KEY([quoted_status]) REFERENCES [tweets]([id]) ); CREATE INDEX [idx_tweets_source] ON [tweets] ([source]);