videos
2 rows where categoryId = 22 and "publishedAt" is on date 2008-11-17
This data as json, CSV (advanced)
Suggested facets: tags (array)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PduP4CpaDtY | 2008-11-17T01:21:15Z | UCF0xuIzJ5I2CBvepPdT2zPw | ダンシングサンタさん | 少し早いけどお家をクリスマスに | {"default": {"url": "https://i.ytimg.com/vi/PduP4CpaDtY/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/PduP4CpaDtY/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/PduP4CpaDtY/hqdefault.jpg", "width": 480, "height": 360}} | ohanacafe | ["クリスマス"] | 22 | none | {"title": "ダンシングサンタさん", "description": "少し早いけどお家をクリスマスに"} | 48176 | 64 | 0 | 7 | ||
lFv1MJSSWNs | 2008-11-17T00:00:20Z | UCp8A8REr84j6bc5j-ppY7OQ | TOOTH TUNES Junior | TOOTH TUNES Junior | {"default": {"url": "https://i.ytimg.com/vi/lFv1MJSSWNs/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/lFv1MJSSWNs/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/lFv1MJSSWNs/hqdefault.jpg", "width": 480, "height": 360}} | CapMem | ["TOOTH", "TUNES", "Junior"] | 22 | none | {"title": "TOOTH TUNES Junior", "description": "TOOTH TUNES Junior"} | 3054 | 6 | 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);