media
1 row where additional_media_info = "{"monetizable": false, "source_user": {"id": 101560178, "id_str": "101560178", "name": "Vincent Santa🎅loni", "screen_name": "panlepan", "location": "France", "description": "Author w/@edsouthall of #GeometrySnacks (and More G.S.) • #mathGIF • GeoGebra Ambassador • Once a teacher...", "url": "https://t.co/UDyl5FT14H", "entities": {"url": {"urls": [{"url": "https://t.co/UDyl5FT14H", "expanded_url": "https://www.tarquingroup.com/geometry-snacks.html", "display_url": "tarquingroup.com/geometry-snack…", "indices": [0, 23]}]}, "description": {"urls": []}}, "protected": false, "followers_count": 15355, "friends_count": 1208, "listed_count": 305, "created_at": "Sun Jan 03 20:04:48 +0000 2010", "favourites_count": 24829, "utc_offset": null, "time_zone": null, "geo_enabled": true, "verified": false, "statuses_count": 27447, "lang": null, "contributors_enabled": false, "is_translator": false, "is_translation_enabled": false, "profile_background_color": "64AD7E", "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": true, "profile_image_url": "http://pbs.twimg.com/profile_images/1141980240769617921/Iy_0SIIC_normal.png", "profile_image_url_https": "https://pbs.twimg.com/profile_images/1141980240769617921/Iy_0SIIC_normal.png", "profile_banner_url": "https://pbs.twimg.com/profile_banners/101560178/1574118177", "profile_link_color": "4D004D", "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": false, "default_profile_image": false, "following": true, "follow_request_sent": false, "notifications": false, "translator_type": "none", "withheld_in_countries": []}}" sorted by id descending
This data as json, CSV (advanced)
additional_media_info 1 ✖
- {"monetizable": false, "source_user": {"id": 101560178, "id_str": "101560178", "name": "Vincent Santa🎅loni", "screen_name": "panlepan", "location": "France", "description": "Author w/@edsouthall of #GeometrySnacks (and More G.S.) • #mathGIF • GeoGebra Ambassador • Once a teacher...", "url": "https://t.co/UDyl5FT14H", "entities": {"url": {"urls": [{"url": "https://t.co/UDyl5FT14H", "expanded_url": "https://www.tarquingroup.com/geometry-snacks.html", "display_url": "tarquingroup.com/geometry-snack…", "indices": [0, 23]}]}, "description": {"urls": []}}, "protected": false, "followers_count": 15355, "friends_count": 1208, "listed_count": 305, "created_at": "Sun Jan 03 20:04:48 +0000 2010", "favourites_count": 24829, "utc_offset": null, "time_zone": null, "geo_enabled": true, "verified": false, "statuses_count": 27447, "lang": null, "contributors_enabled": false, "is_translator": false, "is_translation_enabled": false, "profile_background_color": "64AD7E", "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": true, "profile_image_url": "http://pbs.twimg.com/profile_images/1141980240769617921/Iy_0SIIC_normal.png", "profile_image_url_https": "https://pbs.twimg.com/profile_images/1141980240769617921/Iy_0SIIC_normal.png", "profile_banner_url": "https://pbs.twimg.com/profile_banners/101560178/1574118177", "profile_link_color": "4D004D", "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": false, "default_profile_image": false, "following": true, "follow_request_sent": false, "notifications": false, "translator_type": "none", "withheld_in_countries": []}} · 1 ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1434551399254216707 | 1434551399254216707 | [115, 138] | http://pbs.twimg.com/ext_tw_video_thumb/1434551399254216707/pu/img/Oc2jmakrUE6OahSv.jpg | https://pbs.twimg.com/ext_tw_video_thumb/1434551399254216707/pu/img/Oc2jmakrUE6OahSv.jpg | https://t.co/AIWlUgGIwx | pic.twitter.com/AIWlUgGIwx | https://twitter.com/panlepan/status/1434556932879261702/video/1 | video | {"thumb": {"w": 150, "h": 150, "resize": "crop"}, "small": {"w": 680, "h": 403, "resize": "fit"}, "large": {"w": 1168, "h": 692, "resize": "fit"}, "medium": {"w": 1168, "h": 692, "resize": "fit"}} | {"aspect_ratio": [292, 173], "duration_millis": 38168, "variants": [{"content_type": "application/x-mpegURL", "url": "https://video.twimg.com/ext_tw_video/1434551399254216707/pu/pl/S7wezcYNo3yGgLZe.m3u8?tag=12&container=fmp4"}, {"bitrate": 2176000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1434551399254216707/pu/vid/1168x692/XjE3KtAlDua52yT3.mp4?tag=12"}, {"bitrate": 832000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1434551399254216707/pu/vid/606x360/yZco4suqexAoYOec.mp4?tag=12"}, {"bitrate": 256000, "content_type": "video/mp4", "url": "https://video.twimg.com/ext_tw_video/1434551399254216707/pu/vid/454x270/ahch1K2rX2SWjy7o.mp4?tag=12"}]} | {"monetizable": false, "source_user": {"id": 101560178, "id_str": "101560178", "name": "Vincent Santa🎅loni", "screen_name": "panlepan", "location": "France", "description": "Author w/@edsouthall of #GeometrySnacks (and More G.S.) • #mathGIF • GeoGebra Ambassador • Once a teacher...", "url": "https://t.co/UDyl5FT14H", "entities": {"url": {"urls": [{"url": "https://t.co/UDyl5FT14H", "expanded_url": "https://www.tarquingroup.com/geometry-snacks.html", "display_url": "tarquingroup.com/geometry-snack…", "indices": [0, 23]}]}, "description": {"urls": []}}, "protected": false, "followers_count": 15355, "friends_count": 1208, "listed_count": 305, "created_at": "Sun Jan 03 20:04:48 +0000 2010", "favourites_count": 24829, "utc_offset": null, "time_zone": null, "geo_enabled": true, "verified": false, "statuses_count": 27447, "lang": null, "contributors_enabled": false, "is_translator": false, "is_translation_enabled": false, "profile_background_color": "64AD7E", "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": true, "profile_image_url": "http://pbs.twimg.com/profile_images/1141980240769617921/Iy_0SIIC_normal.png", "profile_image_url_https": "https://pbs.twimg.com/profile_images/1141980240769617921/Iy_0SIIC_normal.png", "profile_banner_url": "https://pbs.twimg.com/profile_banners/101560178/1574118177", "profile_link_color": "4D004D", "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": false, "default_profile_image": false, "following": true, "follow_request_sent": false, "notifications": false, "translator_type": "none", "withheld_in_countries": []}} | 1434556932879261702 | 1434556932879261702 | 101560178 | 101560178 |
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);