media: 1427794053836410883
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1427794053836410883 | 1427794053836410883 | [268, 291] | http://pbs.twimg.com/ext_tw_video_thumb/1427794053836410883/pu/img/lwhRiIIz2v-hPMgr.jpg | https://pbs.twimg.com/ext_tw_video_thumb/1427794053836410883/pu/img/lwhRiIIz2v-hPMgr.jpg | https://t.co/NivIuKDR1P | pic.twitter.com/NivIuKDR1P | https://twitter.com/swyx/status/1427794159520256002/video/1 | video | {"thumb": {"w": 150, "h": 150, "resize": "crop"}, "small": {"w": 383, "h": 680, "resize": "fit"}, "large": {"w": 720, "h": 1280, "resize": "fit"}, "medium": {"w": 675, "h": 1200, "resize": "fit"}} | {"aspect_ratio": [9, 16], "duration_millis": 6105, "variants": [{"bitrate": 2176000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1427794053836410883/pu/vid/720x1280/_jpcseGvFu6_mAz3.mp4?tag=12"}, {"content_type": "application/x-mpegURL", "url": "https://video.twimg.com/ext_tw_video/1427794053836410883/pu/pl/TR5BPhwGq8RC_ooa.m3u8?tag=12&container=fmp4"}, {"bitrate": 632000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1427794053836410883/pu/vid/320x568/GjciJMozdzaApXTB.mp4?tag=12"}, {"bitrate": 950000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1427794053836410883/pu/vid/480x852/hc7PaXCtPVWmQIiF.mp4?tag=12"}]} | {"monetizable": false} |
Links from other tables
- 1 row from media_id in media_tweets