videos
2 rows where categoryId = 10 and "publishedAt" is on date 2010-08-29
This data as json, CSV (advanced)
Suggested facets: publishedAt (date), tags (array)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
7OgH3B49_E4 | 2010-08-29T19:54:25Z | UCsIwCDr6h6H8pKSEmHiuEJA | Static-X - Black And White | Lyrics: Lost in my own World Lost in my own World Lost in my Lost in my own World Lost in my own World Lost in my Getting to the right Getting to the wrong Getting mine Getting to the right Getting to the wrong Getting high Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Burning inside Burning inside Burning into white Burning inside Burning inside Burning into night Yourself collides Yourself collides Yourself into mine Yourself collides Yourself collides Yourself splinters like Losing your mind Losing your mind It's bluring It's fading Your soul's on fire It's black and white Blurring the light Blurring the light It's ours for the taking Flickering colors It's black and white | {"default": {"url": "https://i.ytimg.com/vi/7OgH3B49_E4/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/7OgH3B49_E4/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/7OgH3B49_E4/hqdefault.jpg", "width": 480, "height": 360}} | Triggerself | ["Static-X", "Wayne", "Static", "Black", "And", "White", "HQ", "Official", "Music", "Video", "HD", "High", "Quality", "Definition", "Nu", "Metal", "Nu-Metal"] | 10 | none | {"title": "Static-X - Black And White", "description": "Lyrics:\nLost in my own World \nLost in my own World \nLost in my \nLost in my own World \nLost in my own World \nLost in my \nGetting to the right \nGetting to the wrong \nGetting mine \nGetting to the right \nGetting to the wrong \nGetting high \n\nLosing your mind \nLosing your mind \nIt's bluring \nIt's fading \nYour soul's on fire \nIt's black and white \n\nBurning inside \nBurning inside \nBurning into white \nBurning inside \nBurning inside \nBurning into night \nYourself collides \nYourself collides \nYourself into mine \nYourself collides \nYourself collides \nYourself splinters like \n\nLosing your mind \nLosing your mind \nIt's bluring \nIt's fading \nYour soul's on fire \nIt's black and white \n\nBlurring the light \nBlurring the light \nIt's ours for the taking \nFlickering colors \nIt's black and white"} | 3693591 | 24286 | 0 | 1198 | en-US | |
NsYVaRI6rXg | 2010-08-29T11:39:18Z | UClNsYRkgahztdd_u0_xof8g | Pussycat Dolls - Beep (Live) | {"default": {"url": "https://i.ytimg.com/vi/NsYVaRI6rXg/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/NsYVaRI6rXg/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/NsYVaRI6rXg/hqdefault.jpg", "width": 480, "height": 360}} | Suniuke | ["Pussycat", "Dolls", "Beep", "@", "CDUK"] | 10 | none | {"title": "Pussycat Dolls - Beep (Live)", "description": " "} | 28564 | 63 | 0 | 5 |
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);