videos
2 rows where categoryId = 2 and "publishedAt" is on date 2015-02-16
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
sDX_95H0f9Q | 2015-02-16T19:00:04Z | UCyoSWGYKkusssZWzRrsX4RA | Porsche 918 Spyder, Aventador: Supercar Hunting Vlog! | Here's yesterday's action from my Sunday Supercar Hunt! Featuring a huge array of supercars! One of the best days this year! Subscribe and follow our journey: http://bit.ly/SubscribetoSOL My First Supercar Sponsors: SB Race Engineering- http://www.sbraceengineering.co.uk Aspect Valeting- http://www.aspectvaleting.com Projex UK- http://www.projexuk.com Armytrix Exhaust- http://www.armytrix.com Clothing Sponsor: http://www.piratadellastrada.com | {"default": {"url": "https://i.ytimg.com/vi/sDX_95H0f9Q/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/sDX_95H0f9Q/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/sDX_95H0f9Q/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/sDX_95H0f9Q/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/sDX_95H0f9Q/maxresdefault.jpg", "width": 1280, "height": 720}} | SOL - Supercars of London | ["armytrix", "audi", "r8", "supercar", "living with a", "my first supercar", "v8", "exhaust", "acceleration", "rev", "start up", "sound", "fun", "video", "blog", "vlog", "joke", "hilarious", "fail", "failarmy", "lord aleem", "ferrari", "laferrari", "458 italia", "enzo", "lamborghini", "aventador", "gallardo", "huracan", "veneno", "bugatti veyron", "pagani", "zonda", "porsche", "mercedes benz", "drag race", "drift", "crazy", "powerslide", "supercarsoflondon"] | 2 | none | {"title": "Porsche 918 Spyder, Aventador: Supercar Hunting Vlog!", "description": "Here's yesterday's action from my Sunday Supercar Hunt! Featuring a huge array of supercars! One of the best days this year!\n\nSubscribe and follow our journey: http://bit.ly/SubscribetoSOL\n\nMy First Supercar Sponsors:\nSB Race Engineering- http://www.sbraceengineering.co.uk\nAspect Valeting- http://www.aspectvaleting.com\nProjex UK- http://www.projexuk.com\nArmytrix Exhaust- http://www.armytrix.com\n\nClothing Sponsor: http://www.piratadellastrada.com"} | 20121 | 650 | 0 | 90 | ||
ywuR9AfpA_E | 2015-02-16T10:58:59Z | UCQ3miVWSbZpbrbKrV1JSjGg | Morgan World Premiere Teaser - Geneva 2015 | The countdown begins to the impending release... watch this space for the latest updates www.morgan-motor.co.uk/mmc/geneva2015.html | {"default": {"url": "https://i.ytimg.com/vi/ywuR9AfpA_E/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/ywuR9AfpA_E/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/ywuR9AfpA_E/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/ywuR9AfpA_E/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/ywuR9AfpA_E/maxresdefault.jpg", "width": 1280, "height": 720}} | Morgan Motor Company | ["Morgan Motor Company (Automobile Company)", "morgan", "car", "teaser", "geneva", "motorshow", "2015", "launch", "fast", "speed"] | 2 | none | {"title": "Morgan World Premiere Teaser - Geneva 2015", "description": "The countdown begins to the impending release... watch this space for the latest updates\n\nwww.morgan-motor.co.uk/mmc/geneva2015.html"} | 55071 | 91 | 0 | 17 |
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);