media: 1398777451535339520
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1398777451535339520 | 1398777451535339520 | [146, 169] | http://pbs.twimg.com/ext_tw_video_thumb/1398777451535339520/pu/img/0jKnj-kZobhRtItg.jpg | https://pbs.twimg.com/ext_tw_video_thumb/1398777451535339520/pu/img/0jKnj-kZobhRtItg.jpg | https://t.co/zAGm5QZ7JC | pic.twitter.com/zAGm5QZ7JC | https://twitter.com/AMHband/status/1398777575514771459/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": 28235, "variants": [{"bitrate": 632000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1398777451535339520/pu/vid/320x568/MMUDv_9IT7WCzhXE.mp4?tag=12"}, {"bitrate": 2176000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1398777451535339520/pu/vid/720x1280/MxQ-qoMMBf3MTTbY.mp4?tag=12"}, {"bitrate": 950000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1398777451535339520/pu/vid/480x852/OC7uXbuPmlGVuEhH.mp4?tag=12"}, {"content_type": "application/x-mpegURL", "url": "https://video.twimg.com/ext_tw_video/1398777451535339520/pu/pl/iGMIOnHMthx-vFF9.m3u8?tag=12"}]} | {"monetizable": false, "source_user": {"id": 1113219155447173120, "id_str": "1113219155447173120", "name": "AMH", "screen_name": "AMHband", "location": "", "description": "Follow Our Other Socials Below!🤘", "url": "https://t.co/dmNvfLwMlW", "entities": {"url": {"urls": [{"url": "https://t.co/dmNvfLwMlW", "expanded_url": "https://direct.me/amhband", "display_url": "direct.me/amhband", "indices": [0, 23]}]}, "description": {"urls": []}}, "protected": false, "followers_count": 15291, "friends_count": 73, "listed_count": 23, "created_at": "Tue Apr 02 23:18:24 +0000 2019", "favourites_count": 1245, "utc_offset": null, "time_zone": null, "geo_enabled": false, "verified": false, "statuses_count": 173, "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/1354585857508990977/y_r53qAH_normal.jpg", "profile_image_url_https": "https://pbs.twimg.com/profile_images/1354585857508990977/y_r53qAH_normal.jpg", "profile_banner_url": "https://pbs.twimg.com/profile_banners/1113219155447173120/1580055140", "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": false, "default_profile": true, "default_profile_image": false, "following": false, "follow_request_sent": false, "notifications": false, "translator_type": "none", "withheld_in_countries": []}} | 1398777575514771459 | 1398777575514771459 | 1113219155447173120 | 1113219155447173120 |
Links from other tables
- 1 row from media_id in media_tweets