videos
2 rows where categoryId = 23 and tags contains "blue"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7h6nTyP7d9o | 2009-06-21T14:49:49Z | UCCNjBqyzWajijK_s_MOiyiQ | Barney's Mind - Episode 7 | HALF LIFE: BLUE SHIFT By: Ian Riley Inspired (and endorsed) by: Ross Scott (Freeman's Mind) Follow the thoughts of Mr. Barney Calhoun, a Black Mesa security guard and pessimistic individual. In this episode our protagonist slips and slides, coins the term 'head humpers', and shoots some people. Episode 8: http://www.youtube.com/watch?v=t7eUoF1XSGA | {"default": {"url": "https://i.ytimg.com/vi/7h6nTyP7d9o/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/7h6nTyP7d9o/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/7h6nTyP7d9o/hqdefault.jpg", "width": 480, "height": 360}} | IRAMightyPirate | ["Barney's", "Mind", "episode", "freemans", "mind", "half", "life", "blue", "shift", "black", "mesa"] | 23 | none | {"title": "Barney's Mind - Episode 7", "description": "HALF LIFE: BLUE SHIFT\r\nBy: Ian Riley\r\nInspired (and endorsed) by:\r\nRoss Scott (Freeman's Mind)\r\n\r\nFollow the thoughts of Mr. Barney Calhoun, a Black Mesa security guard and pessimistic individual. In this episode our protagonist slips and slides, coins the term 'head humpers', and shoots some people.\r\n\r\nEpisode 8: http://www.youtube.com/watch?v=t7eUoF1XSGA"} | 150615 | 1044 | 0 | 494 | ||
Kt2MwCHV3Ko | 2006-03-26T07:52:07Z | UChdRIkFvTX3CgGbFmQrT9sQ | techno dance | www.myspace.com/downtononekc | {"default": {"url": "https://i.ytimg.com/vi/Kt2MwCHV3Ko/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Kt2MwCHV3Ko/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Kt2MwCHV3Ko/hqdefault.jpg", "width": 480, "height": 360}} | weregoingxdown | ["techno", "dance", "gay", "blue", "springs", "south", "beotch", "steve", "michael", "swedish", "funny"] | 23 | none | {"title": "techno dance", "description": "www.myspace.com/downtononekc"} | 1751273 | 2279 | 0 | 1094 |
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);