videos
2 rows where categoryId = 10 and "publishedAt" is on date 2009-02-27
This data as json, CSV (advanced)
Suggested facets: publishedAt (date)
| id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Sr2Grfi3lFg | 2009-02-27T19:39:47Z | UCGOb5f_bD18sfge8xJdKRhw | Lily Allen - Alfie | Lily Allen's brand new track "Hard Out Here" is available to download on iTunes now here: http://smarturl.it/HardOutHere?IQid=vevoyt Watch the video here: http://smarturl.it/HardOutHereVideo?IQid=vevoyt Also out now is "Somewhere Only We Know" as featured in the TV Advert here! http://smarturl.it/lilysowk?IQid=vevoyt Follow Lily online: http://www.lilyallenmusic.com https://twitter.com/LilyAllen https://www.facebook.com/lilyallen http://instagram.com/lilyallen http://lilyallenmusic.tumblr.com https://plus.google.com/+lilyallen | {"default": {"url": "https://i.ytimg.com/vi/Sr2Grfi3lFg/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Sr2Grfi3lFg/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Sr2Grfi3lFg/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/Sr2Grfi3lFg/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/Sr2Grfi3lFg/maxresdefault.jpg", "width": 1280, "height": 720}} | Parlophone Records | ["Lily Allen", "Lily Rose Cooper", "LDN", "Smile", "British", "Indie", "Pop", "Female", "It's Not Me It's You", "Alright Still", "Lyrics", "The Fear", "22", "Fuck You", "Parlophone", "Regal"] | 10 | none | {"title": "Lily Allen - Alfie", "description": "Lily Allen's brand new track \"Hard Out Here\" is available to download on iTunes now here: http://smarturl.it/HardOutHere?IQid=vevoyt \nWatch the video here: http://smarturl.it/HardOutHereVideo?IQid=vevoyt \n\nAlso out now is \"Somewhere Only We Know\" as featured in the TV Advert here! http://smarturl.it/lilysowk?IQid=vevoyt \n\nFollow Lily online:\n\nhttp://www.lilyallenmusic.com\nhttps://twitter.com/LilyAllen\nhttps://www.facebook.com/lilyallen\nhttp://instagram.com/lilyallen\nhttp://lilyallenmusic.tumblr.com\nhttps://plus.google.com/+lilyallen"} | 8573314 | 63485 | 0 | 3456 | en-US | |
| qie2k2gZ7wA | 2009-02-27T12:49:06Z | UCF1zPYW69VPxj2BzTvseYPw | Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988) | Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988). | {"default": {"url": "https://i.ytimg.com/vi/qie2k2gZ7wA/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/qie2k2gZ7wA/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/qie2k2gZ7wA/hqdefault.jpg", "width": 480, "height": 360}} | Christo Toupa | ["Guns", "N'", "Roses", "Rocket", "Queen", "Steven", "Adler", "Drum", "Solo", "Live", "in", "Australia", "1988", "Axl", "Rose", "Slash", "Duff", "Izzy", "Appetite", "for", "Destruction", "Hard", "Rock", "Band"] | 10 | none | {"title": "Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988)", "description": "Guns N' Roses - Rocket Queen (Steven Adler Drum Solo) (Live in Australia 1988)."} | 124298 | 1111 | 0 | 181 |
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);