media: 1301163422869053440
This data as json
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1301163422869053440 | 1301163422869053440 | [61, 84] | http://pbs.twimg.com/ext_tw_video_thumb/1301163422869053440/pu/img/HElF6sIVPcgToGm2.jpg | https://pbs.twimg.com/ext_tw_video_thumb/1301163422869053440/pu/img/HElF6sIVPcgToGm2.jpg | https://t.co/HsCRBDAacL | pic.twitter.com/HsCRBDAacL | https://twitter.com/forrestbrazeal/status/1301182968766107656/video/1 | video | {"thumb": {"w": 150, "h": 150, "resize": "crop"}, "small": {"w": 680, "h": 680, "resize": "fit"}, "medium": {"w": 720, "h": 720, "resize": "fit"}, "large": {"w": 720, "h": 720, "resize": "fit"}} | {"aspect_ratio": [1, 1], "duration_millis": 139375, "variants": [{"bitrate": 1280000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1301163422869053440/pu/vid/720x720/8-_fQGia_gS-ztAO.mp4?tag=10"}, {"bitrate": 432000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1301163422869053440/pu/vid/320x320/YJ6MI5pCRDc2dgbz.mp4?tag=10"}, {"content_type": "application/x-mpegURL", "url": "https://video.twimg.com/ext_tw_video/1301163422869053440/pu/pl/Cytgjf6gicyikilF.m3u8?tag=10"}, {"bitrate": 832000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1301163422869053440/pu/vid/480x480/hlvUipnTc9Gg-W_N.mp4?tag=10"}]} | {"monetizable": false, "source_user": {"id": 3239330680, "id_str": "3239330680", "name": "Forrest Brazeal", "screen_name": "forrestbrazeal", "location": "Charlotte, NC", "description": "Cloud bard at @google, author, cartoonist, and Pwnie Award-winning songwriter. Ex-AWS Hero. Here to help.", "url": "https://t.co/cAbK6f4Jbz", "entities": {"url": {"urls": [{"url": "https://t.co/cAbK6f4Jbz", "expanded_url": "https://bio.link/forrestbrazeal", "display_url": "bio.link/forrestbrazeal", "indices": [0, 23]}]}, "description": {"urls": []}}, "protected": false, "followers_count": 21778, "friends_count": 137, "listed_count": 339, "created_at": "Wed May 06 18:59:20 +0000 2015", "favourites_count": 6141, "utc_offset": null, "time_zone": null, "geo_enabled": false, "verified": false, "statuses_count": 4826, "lang": null, "contributors_enabled": false, "is_translator": false, "is_translation_enabled": false, "profile_background_color": "000000", "profile_background_image_url": "http://abs.twimg.com/images/themes/theme1/bg.png", "profile_background_image_url_https": "https://abs.twimg.com/images/themes/theme1/bg.png", "profile_background_tile": false, "profile_image_url": "http://pbs.twimg.com/profile_images/1431705570327805955/K9Tgg3WV_normal.jpg", "profile_image_url_https": "https://pbs.twimg.com/profile_images/1431705570327805955/K9Tgg3WV_normal.jpg", "profile_banner_url": "https://pbs.twimg.com/profile_banners/3239330680/1587563860", "profile_link_color": "FF691F", "profile_sidebar_border_color": "000000", "profile_sidebar_fill_color": "000000", "profile_text_color": "000000", "profile_use_background_image": false, "has_extended_profile": false, "default_profile": false, "default_profile_image": false, "following": true, "follow_request_sent": false, "notifications": false, "translator_type": "none", "withheld_in_countries": []}} | 1301182968766107656 | 1301182968766107656 | 3239330680 | 3239330680 |
Links from other tables
- 2 rows from media_id in media_tweets