videos
2 rows where categoryId = 24 and "publishedAt" is on date 2007-09-14
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
TC4mH6nACm8 | 2007-09-14T06:07:52Z | UCob-dH1G0-Vs0e75I5gR0dg | Global Drum Project featuring Mickey Hart and Zakir Hussain | Four Grammy-winning master drummers invoke percussion gods from all corners of the world in a celebratory, boundary-shattering musical journey that joyously reaffirms the drum's primal potency in today's high-tech world. Global Drum Project reunites Grateful Dead percussionist Mickey Hart with Indian tabla master Zakir Hussain and two longtime friends and collaborators—Nigerian "talking-drum" ace Sikiru Adepoju and Latin conga legend Giovanni Hidalgo—for an evening of new music and classics from the Planet Drum recording that won the first-ever Grammy for Best World Music Album. Saturday, October 13, 2007 at 8 pm $46 / $38 / $28 http://www.flynncenter.org/show_pages/FLW08P.shtml | {"default": {"url": "https://i.ytimg.com/vi/TC4mH6nACm8/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/TC4mH6nACm8/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/TC4mH6nACm8/hqdefault.jpg", "width": 480, "height": 360}} | The Flynn | ["flynn", "center", "Global", "Drum", "Project", "Mickey", "Hart", "Zakir", "Hussain", "Sikiru", "Adepoju", "Giovanni", "Hidalgo", "vermont", "grateful", "dead", "conga"] | 24 | none | {"title": "Global Drum Project featuring Mickey Hart and Zakir Hussain", "description": "Four Grammy-winning master drummers invoke percussion gods from all corners of the world in a celebratory, boundary-shattering musical journey that joyously reaffirms the drum's primal potency in today's high-tech world. Global Drum Project reunites Grateful Dead percussionist Mickey Hart with Indian tabla master Zakir Hussain and two longtime friends and collaborators—Nigerian \"talking-drum\" ace Sikiru Adepoju and Latin conga legend Giovanni Hidalgo—for an evening of new music and classics from the Planet Drum recording that won the first-ever Grammy for Best World Music Album.\r\n\r\nSaturday, October 13, 2007 at 8 pm \r\n $46 / $38 / $28\r\n\r\nhttp://www.flynncenter.org/show_pages/FLW08P.shtml"} | 45206 | 53 | 0 | 8 | ||
WiAFUo2nxIk | 2007-09-14T19:58:53Z | UCmyJSf9Hnq5ftuuxeLj-oPA | DJ Kids Scratching! | this little dudes get down on the turntables!! Yeah they're bad asses. For those who continue to say it's fake check out their page: Sarahscratch. Their names are DJ Sara and DJ Ryusei. | {"default": {"url": "https://i.ytimg.com/vi/WiAFUo2nxIk/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/WiAFUo2nxIk/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/WiAFUo2nxIk/hqdefault.jpg", "width": 480, "height": 360}} | valentinesday01 | ["dj scratch kids turntables", "mix"] | 24 | none | {"title": "DJ Kids Scratching!", "description": "this little dudes get down on the turntables!! Yeah they're bad asses. For those who continue to say it's fake check out their page: Sarahscratch. Their names are DJ Sara and DJ Ryusei."} | 709666 | 2127 | 0 |
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);