tweets
9 rows where "created_at" is on date 2021-08-11 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: user, in_reply_to_user_id, is_quote_status, retweet_count, favorite_count
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1425266629017890816 | swyx 33521530 | 2021-08-11T01:23:39+00:00 | @ritakozlov_ i mean sure that works too i wouldnt overreact 😅 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 61] | 1425265547550158848 | 232076816 | ritakozlov_ | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1425267775967096832 | swyx 33521530 | 2021-08-11T01:28:12+00:00 | @ritakozlov_ @jasnell reject cloud embrace corn | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 47] | 1425267547469848584 | 232076816 | ritakozlov_ | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1425297614539423747 | swyx 33521530 | 2021-08-11T03:26:46+00:00 | @jsjoeio @Rich_Harris Svelte is the trickle down framework | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [22, 58] | 1425183828063047682 | 1567529924 | jsjoeio | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1425301069903523842 | swyx 33521530 | 2021-08-11T03:40:30+00:00 | @slightlylate i like the “special occasion food” phrasing! do you think React Server Components solve this problem well? I went back in your history and only saw mentions about JSF but on this specific “turn off clientside JS by default” goal, it is supposed to do that, runtime aside. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [14, 288] | 1425137032461004800 | 229237555 | slightlylate | 0 | 0 | 1 | 0 | 0 | en | ||||||||
| 1425301392323801088 | swyx 33521530 | 2021-08-11T03:41:47+00:00 | @QuinnyPig @dumpkopf @LAURIESMOOZ she asked for “highly-respected” | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [34, 66] | 1425225538092765185 | 97114171 | QuinnyPig | 0 | 0 | 2 | 0 | 0 | en | ||||||||
| 1425476793327259651 | Trung Phan 🇨🇦 945817135816654848 | 2021-08-11T15:18:46+00:00 | 12/ Quick video cut of @elonmusk breaking down SpaceX’s 5-Step design and manufacturing process: https://twitter.com/TrungTPhan/status/1425476793327259651/video/1 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 96] | 1425474192925888515 | 945817135816654848 | TrungTPhan | 0 | 439 | 1935 | 0 | 1 | 0 | en | |||||||
| 1425477419524308994 | Justin ETH 💰Samuels 3311526940 | 2021-08-11T15:21:15+00:00 | Everyone attending @renderATL will: 1. Show proof of vaccination or negative COVID test 📝 2. Receive KN95 masks 😷 3. Take an on-site rapid COVID test ⭐️ We’ve taken the unprecedented step of swabbing everyone attending! Learn more here 👉🏾 https://bit.ly/3xBKvSS https://twitter.com/renderATL/status/1425473400957440008 | Atlanta 8173485c72e78ca5 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 270] | 1 | 38 | 122 | 0 | 0 | 0 | en | |||||||||
| 1425503610213785600 | swyx 33521530 | 2021-08-11T17:05:19+00:00 | RT @ReactSummit: There was a time before #ReactJS, and there will be life after. If you tie yourself too closely to any tech, you might tra… | 1425487171172044815 1425487171172044815 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 6 | 0 | 0 | 1 | en | ||||||||||
| 1425513684202258432 | swyx 33521530 | 2021-08-11T17:45:21+00:00 | @spitleaf And Staging and UAT | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [10, 29] | 1425512781487431683 | 357427736 | spitleaf | 0 | 0 | 1 | 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]);