tweets
5 rows where "created_at" is on date 2021-10-03 and is_quote_status = 1 sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, lang
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1444498121854124035 | swyx 33521530 | 2021-10-03T03:02:44+00:00 | this is a worthwhile talk (direct link https://youtu.be/hV3dJur69SU) We are dealing w/ similar issues at @temporalio: how to guide someone to learn your system and be able to find the answer to every important question in the shortest time? Docs, like the SDLC, should be nonlinear. https://twitter.com/editingemily/status/1443381760935534592 | 1443381760935534592 1443381760935534592 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 280] | 1 | 0 | 5 | 0 | 0 | 0 | en | |||||||||
| 1444544841149341700 | swyx 33521530 | 2021-10-03T06:08:23+00:00 | This thread of backend engineers discovering what ACID databases are, and asking if it matters, feels like it touches on a fundamental tension in our industry Would you require that a backend engineer know what ACID is to hire them? Even if they sling PostgreSQL like a champ? https://twitter.com/Coding_Career/status/1444542756647419909 https://twitter.com/swyx/status/1444544841149341700/photo/1 | 1444542756647419909 1444542756647419909 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 301] | 1 | 45 | 339 | 0 | 0 | 0 | en | |||||||||
| 1444556693673701378 | swyx 33521530 | 2021-10-03T06:55:28+00:00 | @jlengstorf @astrodotbuild right here with ya :) https://twitter.com/swyx/status/1172690454363672577?s=20 | 1172690454363672577 1172690454363672577 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [27, 72] | 1442707241627385860 | 15668072 | jlengstorf | 1 | 1 | 14 | 0 | 0 | 0 | en | ||||||
| 1444560899797176321 | swyx 33521530 | 2021-10-03T07:12:11+00:00 | Unsolicited compliment: I am enjoying watching along how @9ranty is building his Loom competitor in public. Lots of little gems and the video result looks great! Worth checking out http://tella.tv Am not a regular user yet but #BuildInPublic updates keep me interested. https://twitter.com/TellaHQ/status/1443129037854019589 | 1443129037854019589 1443129037854019589 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [0, 280] | 1 | 0 | 14 | 0 | 0 | 0 | en | |||||||||
| 1444781745409179655 | swyx 33521530 | 2021-10-03T21:49:45+00:00 | @threepointone 👁️👄👁️ https://twitter.com/swyx/status/1417165280522821632 | 1417165280522821632 1417165280522821632 | Twitter Web App 1f89d6a41b1505a3071169f8d0d028ba9ad6f952 | 0 | [15, 46] | 1444737710116196353 | 1593171 | threepointone | 1 | 0 | 12 | 0 | 0 | 0 | und |
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]);