videos
1 row where categoryId = 2 and "publishedAt" is on date 2012-03-05
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sHbGsZUsisE | 2012-03-05T16:54:46Z | UCsT-1ld5FjGv-HS58vwmJFQ | Kid Rock - American Badass (DIRTY) HQ | Wallpaper made by me. Song: American Badass Artist: Kid Rock Album: History of rock | {"default": {"url": "https://i.ytimg.com/vi/sHbGsZUsisE/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/sHbGsZUsisE/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/sHbGsZUsisE/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/sHbGsZUsisE/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/sHbGsZUsisE/maxresdefault.jpg", "width": 1280, "height": 720}} | SickRockMusic | ["Badass", "Kid Rock", "Kid Rock (album)", "american", "badass", "wallpaper", "song", "epic", "usa", "harley", "davidson", "United States", "Cool", "Alternative", "metal", "heavy", "United States Army", "America"] | 2 | none | {"title": "Kid Rock - American Badass (DIRTY) HQ", "description": "Wallpaper made by me.\nSong: American Badass\nArtist: Kid Rock\nAlbum: History of rock"} | 11409980 | 68617 | 0 | 3413 |
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);