videos
1 row where categoryId = 29 and "publishedAt" is on date 2014-12-02
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
jUJNETNCxh0 | 2014-12-02T07:09:41Z | UCDrX0b6TKoN7opLl0ASmrIg | “Art of Wadaiko– The Heartbeat of Japan,” Taiko by Eitetsu Hayashi | [people. power. media] Demo Reel of Eitetsu Hayashi & Eitetsu Fu-un no Kai Ensemble "Art of Wadaiko - The Heartbeat of Japan" 1 Nov 2014 | {"default": {"url": "https://i.ytimg.com/vi/jUJNETNCxh0/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/jUJNETNCxh0/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/jUJNETNCxh0/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/jUJNETNCxh0/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/jUJNETNCxh0/maxresdefault.jpg", "width": 1280, "height": 720}} | people power media | 29 | none | {"title": "“Art of Wadaiko– The Heartbeat of Japan,” Taiko by Eitetsu Hayashi", "description": "[people. power. media] Demo Reel of Eitetsu Hayashi & Eitetsu Fu-un no Kai Ensemble \"Art of Wadaiko - The Heartbeat of Japan\" 1 Nov 2014"} | 7252 | 98 | 0 | 0 |
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);