videos
1 row where categoryId = 20 and "publishedAt" is on date 2012-12-22
This data as json, CSV (advanced)
Suggested facets: publishedAt (date), tags (array)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
fU9woCZqemw | 2012-12-22T04:38:48Z | UCh0ASf2IGLfzM5Ntitv-D8A | Guild Wars 2 Wintersday Bell Choir - Billie Jean | A cover of Billie Jean (originally by Michael Jackson), produced using only the notes available within the bell choir Wintersday activity in Guild Wars 2. Billie Jean is one of very few well known songs that can be fully (well, almost) played using the notes provided in the bell choir. What's a guy gotta do to get a nice simple major scale around here, eh? Happy Wintersday to all, and thanks to Arenanet for the cool minigame, even if it did use the wrong scale. | {"default": {"url": "https://i.ytimg.com/vi/fU9woCZqemw/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/fU9woCZqemw/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/fU9woCZqemw/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/fU9woCZqemw/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/fU9woCZqemw/maxresdefault.jpg", "width": 1280, "height": 720}} | Hecksa | ["Guild Wars 2", "Bell", "Choir", "GW2", "Billie Jean", "Michael Jackson"] | 20 | none | {"title": "Guild Wars 2 Wintersday Bell Choir - Billie Jean", "description": "A cover of Billie Jean (originally by Michael Jackson), produced using only the notes available within the bell choir Wintersday activity in Guild Wars 2. \n\nBillie Jean is one of very few well known songs that can be fully (well, almost) played using the notes provided in the bell choir. \n\nWhat's a guy gotta do to get a nice simple major scale around here, eh?\n\nHappy Wintersday to all, and thanks to Arenanet for the cool minigame, even if it did use the wrong scale."} | 36701 | 1003 | 0 | 67 |
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);