media
1 row where source_user_id_str = 1389094644328271872 sorted by source_status_id
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1436002780704133122 | 1436002780704133122 | [112, 135] | http://pbs.twimg.com/ext_tw_video_thumb/1436002780704133122/pu/img/Bqx2EWJCI52XmuhC.jpg | https://pbs.twimg.com/ext_tw_video_thumb/1436002780704133122/pu/img/Bqx2EWJCI52XmuhC.jpg | https://t.co/c2Yq1GbSwR | pic.twitter.com/c2Yq1GbSwR | https://twitter.com/DevtoolsFM/status/1436002996660363267/video/1 | video | {"thumb": {"w": 150, "h": 150, "resize": "crop"}, "small": {"w": 383, "h": 680, "resize": "fit"}, "medium": {"w": 675, "h": 1200, "resize": "fit"}, "large": {"w": 1080, "h": 1920, "resize": "fit"}} | {"aspect_ratio": [9, 16], "duration_millis": 94063, "variants": [{"bitrate": 2176000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1436002780704133122/pu/vid/720x1280/89MP2BKQGIQc9KcW.mp4?tag=12"}, {"content_type": "application/x-mpegURL", "url": "https://video.twimg.com/ext_tw_video/1436002780704133122/pu/pl/HKjgidCWWhCwb2Ko.m3u8?tag=12&container=fmp4"}, {"bitrate": 950000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1436002780704133122/pu/vid/480x852/du3dxKu83N1LnO0a.mp4?tag=12"}, {"bitrate": 632000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1436002780704133122/pu/vid/320x568/loxmQxx_xGLKWVNl.mp4?tag=12"}]} | {"monetizable": false, "source_user": {"id": 1389094644328271872, "id_str": "1389094644328271872", "name": "devtools.fm", "screen_name": "DevtoolsFM", "location": "", "description": "A podcast about developer tools and the people who make them. Hosted by @hipstersmoothie and @zephraph. Interested in being a guest? Shoot us a DM!", "url": "https://t.co/wogF3t40ka", "entities": {"url": {"urls": [{"url": "https://t.co/wogF3t40ka", "expanded_url": "https://devtools.fm", "display_url": "devtools.fm", "indices": [0, 23]}]}, "description": {"urls": []}}, "protected": false, "followers_count": 639, "friends_count": 642, "listed_count": 12, "created_at": "Mon May 03 05:49:44 +0000 2021", "favourites_count": 333, "utc_offset": null, "time_zone": null, "geo_enabled": false, "verified": false, "statuses_count": 248, "lang": null, "contributors_enabled": false, "is_translator": false, "is_translation_enabled": false, "profile_background_color": "F5F8FA", "profile_background_image_url": null, "profile_background_image_url_https": null, "profile_background_tile": false, "profile_image_url": "http://pbs.twimg.com/profile_images/1394525762607190018/S_IZfnjy_normal.jpg", "profile_image_url_https": "https://pbs.twimg.com/profile_images/1394525762607190018/S_IZfnjy_normal.jpg", "profile_banner_url": "https://pbs.twimg.com/profile_banners/1389094644328271872/1640020971", "profile_link_color": "1DA1F2", "profile_sidebar_border_color": "C0DEED", "profile_sidebar_fill_color": "DDEEF6", "profile_text_color": "333333", "profile_use_background_image": true, "has_extended_profile": true, "default_profile": true, "default_profile_image": false, "following": false, "follow_request_sent": false, "notifications": false, "translator_type": "none", "withheld_in_countries": []}} | 1436002996660363267 | 1436002996660363267 | 1389094644328271872 | 1389094644328271872 |
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);