videos
2 rows where categoryId = 10 and "publishedAt" is on date 2008-08-10
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
J0RzvGnQxD0 | 2008-08-10T08:24:19Z | UCmoaLLtUcxU4rkS2VYcGHgA | Danelectro Reel Echo Jam | I just tried out the 'Reel Echo' a bit. Settings are: https://dl.dropbox.com/u/7261736/WP_000222.jpg | {"default": {"url": "https://i.ytimg.com/vi/J0RzvGnQxD0/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/J0RzvGnQxD0/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/J0RzvGnQxD0/hqdefault.jpg", "width": 480, "height": 360}} | slugsvideos | ["Danelectro", "Reel", "Echo", "Jam", "Guitar"] | 10 | none | {"title": "Danelectro Reel Echo Jam", "description": "I just tried out the 'Reel Echo' a bit.\n\nSettings are: https://dl.dropbox.com/u/7261736/WP_000222.jpg"} | 24585 | 31 | 0 | 24 | ||
LRz6Y6oltQ4 | 2008-08-10T16:12:57Z | UCBePhvXJyy2AqSvbDVDS9JA | Tears in Heaven | Been learning the sax for a few months! Got a long way to go! | {"default": {"url": "https://i.ytimg.com/vi/LRz6Y6oltQ4/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/LRz6Y6oltQ4/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/LRz6Y6oltQ4/hqdefault.jpg", "width": 480, "height": 360}} | saxanon | ["sax", "tears", "in", "heaven", "saxanon"] | 10 | none | {"title": "Tears in Heaven", "description": "Been learning the sax for a few months! Got a long way to go!"} | 61894 | 12 | 0 | 1 |
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);