videos
2 rows where categoryId = 24 and "publishedAt" is on date 2011-07-14
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
bTLgeqCaYMY | 2011-07-14T14:45:35Z | UC3hgaGmh8kkV8wBuP_02_iw | DJ Kittens Scratching away on Decks | They may only be kittens, but these little guys know how to SCRATCH! | {"default": {"url": "https://i.ytimg.com/vi/bTLgeqCaYMY/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/bTLgeqCaYMY/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/bTLgeqCaYMY/hqdefault.jpg", "width": 480, "height": 360}} | Steve Larsen - Google Evangelist | ["turntables", "kittens", "music", "dj", "Guetta", "Tiesto", "cats", "kitty", "cute", "david", "remix"] | 24 | none | {"title": "DJ Kittens Scratching away on Decks", "description": "They may only be kittens, but these little guys know how to SCRATCH!"} | 2983690 | 14874 | 0 | 843 | ||
tG5C-Smp-eY | 2011-07-14T16:07:26Z | UCmlMdB7KiyocO8WkkkBJhLw | MCX Rap music video for Men's Wear | MCX rap video for Mens Wear Music and Lyrics: by Corey Johnson Singing: by Corey Johnson www.facebook.com/WhoisJohnny Jyeah.spreadshirt.com Music Director: Harper Hug Actors and Actress: Jenn Purviance, Jeremy Putansu, Jamie Spradley,Breyana Burton, MCX employees, Marines | {"default": {"url": "https://i.ytimg.com/vi/tG5C-Smp-eY/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/tG5C-Smp-eY/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/tG5C-Smp-eY/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/tG5C-Smp-eY/sddefault.jpg", "width": 640, "height": 480}} | mccs29palmstv | ["Rap music", "MCX", "Twentynine Palms", "MCAGCC", "Marines", "Saliors", "Mens Wear", "IRL", "Single Marines"] | 24 | none | {"title": "MCX Rap music video for Men's Wear", "description": "MCX rap video for Mens Wear\r\n\r\nMusic and Lyrics: by Corey Johnson\r\nSinging: by Corey Johnson \r\nwww.facebook.com/WhoisJohnny \r\nJyeah.spreadshirt.com \r\n\r\nMusic Director: Harper Hug\r\nActors and Actress: Jenn Purviance, Jeremy Putansu, Jamie Spradley,Breyana Burton, MCX employees, Marines"} | 3285 | 9 | 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);