videos
3 rows where categoryId = 10 and "publishedAt" is on date 2009-05-27
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5a_Qxd4ECTo | 2009-05-27T05:06:01Z | UCmTVk9wjI_v18JQOJNPmIVA | Sasha - Boileroom | Title: Boileroom Artist: Sasha Album: Airdrawndagger Year: 2002 | {"default": {"url": "https://i.ytimg.com/vi/5a_Qxd4ECTo/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/5a_Qxd4ECTo/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/5a_Qxd4ECTo/hqdefault.jpg", "width": 480, "height": 360}} | trancehiyo | ["boileroom", "sasha", "2002", "progressive", "house", "airdrawndagger"] | 10 | none | {"title": "Sasha - Boileroom", "description": "Title: Boileroom\r\nArtist: Sasha\r\nAlbum: Airdrawndagger\r\nYear: 2002"} | 118049 | 576 | 0 | 54 | ||
FLJPxFCPeDY | 2009-05-27T05:57:03Z | UCpsvPmRVcCvQE5CfhFz3hog | Julio Chaidez Hombre de Negocios | Tono de Sib | {"default": {"url": "https://i.ytimg.com/vi/FLJPxFCPeDY/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/FLJPxFCPeDY/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/FLJPxFCPeDY/hqdefault.jpg", "width": 480, "height": 360}} | jgg171990 | ["Julio", "Chaidez", "Hombre", "de", "Negocios"] | 10 | none | {"title": "Julio Chaidez Hombre de Negocios", "description": "Tono de Sib"} | 14448 | 25 | 0 | 1 | ||
I-Z3gB6pfIA | 2009-05-27T05:02:05Z | UCwhKsUa0x1-yj_aOr_NTB3Q | Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09 | Great video of Sallie Ford and the Sound Outside singing "Not an animal" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009. | {"default": {"url": "https://i.ytimg.com/vi/I-Z3gB6pfIA/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/I-Z3gB6pfIA/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/I-Z3gB6pfIA/hqdefault.jpg", "width": 480, "height": 360}} | ConcordKurve | ["The", "Avett", "Brothers", "opening", "band", "Sallie", "Ford", "and", "the", "Sound", "Outside", "Not an animal", "at", "Crystal", "Ballroom", "May", "23", "2009"] | 10 | none | {"title": "Sallie Ford and the Sound Outside at The Crystal Ballroom 5-23-09", "description": "Great video of Sallie Ford and the Sound Outside singing \"Not an animal\" at the Crystal Ballroom. They opened for the Avett Brothers on May 22 and 23, 2009."} | 5905 | 12 | 0 | 6 |
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);