tweets
6 rows where retweeted = 0 and source = "f0976f342215a984184a13a54b26877ece8cebba" sorted by is_quote_status
This data as json, CSV (advanced)
Suggested facets: is_quote_status, created_at (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1446485504468398085 | Geoffrey Miller 🔍 3656836876 | 2021-10-08T14:39:53+00:00 | Any school system that doesn't allow separate classes for very smart ('gifted & talented') kids either doesn't understand very smart kids at all, or it sadistically wants them to be suffer through boredom, frustration, alienation, & bullying. | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 250] | 0 | 1039 | 7594 | 0 | 0 | en | |||||||||||
1452445875159044098 | Lívia Labate 769920 | 2021-10-25T01:24:16+00:00 | A screw it, let's do it: TL,DR: AMP format doesn't support JavaScript in the way you can use it on regular web pages. This prevents publishers from using header bidding with AMP (limits how many ad exchanges one can connect to @ a time, making it less desirable/useful; see doc) | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 280] | 1452430810880122885 | 769920 | livlab | 0 | 48 | 251 | 0 | 0 | en | ||||||||
1467261215915364353 | Adam Gordon Bell 🤓 191034488 | 2021-12-04T22:35:08+00:00 | @swyx I wrote a thing about this: https://earthly.dev/blog/confidently-uncertain/ | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [6, 57] | 1467260899874512906 | 191034488 | adamgordonbell | 0 | 1 | 6 | 0 | 0 | 0 | en | |||||||
1470366530936483841 | Intercontinental Breakfast Missile 41402543 | 2021-12-13T12:14:33+00:00 | Still thinking about this bird's nest made out of anti-bird spikes https://twitter.com/potatojunkie/status/1470366530936483841/photo/1 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 66] | 0 | 2365 | 16602 | 0 | 0 | 0 | en | ||||||||||
1412032180465831939 | Brittney Postma 36686876 | 2021-07-05T12:54:40+00:00 | Check it out, I was on Svelte Radio! I still can't believe it. Thank you for having me, I had so much fun! Also, check out the Purrfect dev with @swyx talking about Svelte. https://codingcat.dev/podcast/1-15-whats-up-with-svelte #svelte @sveltejs https://twitter.com/svelteradio/status/1411882780959596549 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 217] | 1 | 4 | 31 | 0 | 0 | 0 | en | ||||||||||
1457887975115612164 | Chris DiBona 44423 | 2021-11-09T01:49:14+00:00 | Hey, I did a thing. I'm about to hate listen to myself and be super judgemental. Gotta lance that boil! It's the only way to get better..... https://twitter.com/thenewstack/status/1457830540011245572 | Twitter for Android f0976f342215a984184a13a54b26877ece8cebba | 0 | [0, 140] | 1 | 5 | 45 | 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]);