videos
2 rows where categoryId = 10 and "publishedAt" is on date 2008-10-03
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3ZhyXbwFQAM | 2008-10-03T23:56:49Z | UCLR5PGp0PdqpejYyDH_xvww | The Kovenant - Cybertrash | For you to Enjoy. | {"default": {"url": "https://i.ytimg.com/vi/3ZhyXbwFQAM/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/3ZhyXbwFQAM/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/3ZhyXbwFQAM/hqdefault.jpg", "width": 480, "height": 360}} | Ricksboycc | ["rock", "metal", "industrial", "kovenant", "cyber", "trash", "seti"] | 10 | none | {"title": "The Kovenant - Cybertrash", "description": "For you to Enjoy."} | 78019 | 434 | 0 | 29 | ||
RmDfwz0OG8E | 2008-10-03T14:48:46Z | UCsldY16lXCtidmgA8f5XwlA | Roy Jones Jr - I Smoke I Drank | Roy Jones Jr, Youngbloods and Body Head Bangerz | {"default": {"url": "https://i.ytimg.com/vi/RmDfwz0OG8E/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/RmDfwz0OG8E/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/RmDfwz0OG8E/hqdefault.jpg", "width": 480, "height": 360}} | Body Head Entertainment Films | ["Rap", "RoyJonesJr", "Body", "Head", "Bangerz", "Roy", "Jones", "Jr", "Boxing", "Fighter", "Magic", "BHE", "HBO", "Fight", "Bodyhead", "JayZ", "Youngbloodz"] | 10 | none | {"title": "Roy Jones Jr - I Smoke I Drank", "description": "Roy Jones Jr, Youngbloods and Body Head Bangerz"} | 5577838 | 56891 | 0 | 1323 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [videos] ( [id] TEXT PRIMARY KEY, [publishedAt] TEXT, [channelId] TEXT, [title] TEXT, [description] TEXT, [thumbnails] TEXT, [channelTitle] TEXT, [tags] TEXT, [categoryId] TEXT, [liveBroadcastContent] TEXT, [localized] TEXT, [viewCount] INTEGER, [likeCount] INTEGER, [favoriteCount] INTEGER, [commentCount] INTEGER, [defaultAudioLanguage] TEXT , [defaultLanguage] TEXT);