tweets
6 rows where "created_at" is on date 2021-07-28 and source = "95f3aaaddaa45937ac94765e0ddb68ba2be92d20" sorted by lang
This data as json, CSV (advanced)
Suggested facets: display_text_range, retweet_count, retweeted
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1420174513824620546 | swyx 33521530 | 2021-07-28T00:09:24+00:00 | @monicalimco look at my blog analytics lol | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [13, 42] | 1419848153428234248 | 1265436714136297473 | monicalimco | 0 | 0 | 22 | 0 | 0 | en | ||||||||
1420174594644742156 | swyx 33521530 | 2021-07-28T00:09:43+00:00 | RT @DominikTornow: @temporalio is all about scalability and reliability while guaranteeing functional correctness. There is a lot to unpac… | 1420085405349662721 1420085405349662721 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 7 | 0 | 0 | 1 | en | ||||||||||
1420211877276049408 | swyx 33521530 | 2021-07-28T02:37:52+00:00 | @matiasfha @Rich_Harris @stolinski @gndx Svelte also has one way data flow under the hood, but uses binding and syntax sugar to simulate LOCAL two way data flow. its not that different. data propagation with stores vs context however are very different. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [41, 255] | 1420201456108441603 | 12816182 | matiasfha | 0 | 2 | 24 | 0 | 0 | en | ||||||||
1420234701059416066 | swyx 33521530 | 2021-07-28T04:08:34+00:00 | RT @supabase: #supalaunchweek Day 2: 🔥 Supabase Storage is now in Beta 🔥 https://supabase.io/blog/2021/07/27/storage-beta - Streaming Media - Public Buckets - No… | 1420043000344768517 1420043000344768517 | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [0, 140] | 0 | 32 | 0 | 0 | 1 | 0 | en | |||||||||
1420235876483813378 | swyx 33521530 | 2021-07-28T04:13:14+00:00 | @lesliecdubs @tiberriver256 wow what a well written blogpost | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [28, 60] | 1420188172726771714 | 22217773 | lesliecdubs | 0 | 0 | 1 | 0 | 0 | en | ||||||||
1420309857895272456 | swyx 33521530 | 2021-07-28T09:07:12+00:00 | @Andy_W_Farrell @maxlynch @benedictfritz and yet. any company large enough is not homogeneous. they can use multiple frameworks in different apps. willing to bet that react is majority of greenfield. | Twitter for iPhone 95f3aaaddaa45937ac94765e0ddb68ba2be92d20 | 0 | [41, 199] | 1420167119337967620 | 17500142 | Andy_W_Farrell | 0 | 0 | 0 | 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]);