media
1 row where source_user_id_str = 975062337450213376 sorted by video_info
This data as json, CSV (advanced)
id | id_str | indices | media_url | media_url_https | url | display_url | expanded_url | type | sizes | video_info ▼ | additional_media_info | source_status_id | source_status_id_str | source_user_id | source_user_id_str |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1463568124230479879 | 1463568124230479879 | [91, 114] | http://pbs.twimg.com/media/FE-jdGVXsAcDs0U.jpg | https://pbs.twimg.com/media/FE-jdGVXsAcDs0U.jpg | https://t.co/vcevBEv9hg | pic.twitter.com/vcevBEv9hg | https://twitter.com/cssbasics/status/1463568127443222533/photo/1 | photo | {"thumb": {"w": 150, "h": 150, "resize": "crop"}, "medium": {"w": 1000, "h": 420, "resize": "fit"}, "small": {"w": 680, "h": 286, "resize": "fit"}, "large": {"w": 1000, "h": 420, "resize": "fit"}} | 1463568127443222533 | 1463568127443222533 | 975062337450213376 | 975062337450213376 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [media] ( [id] INTEGER PRIMARY KEY, [id_str] TEXT, [indices] TEXT, [media_url] TEXT, [media_url_https] TEXT, [url] TEXT, [display_url] TEXT, [expanded_url] TEXT, [type] TEXT, [sizes] TEXT , [video_info] TEXT, [additional_media_info] TEXT, [source_status_id] INTEGER, [source_status_id_str] TEXT, [source_user_id] INTEGER, [source_user_id_str] TEXT);