videos
2 rows where categoryId = 10 and "publishedAt" is on date 2011-08-18
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
-wVWjl9Kq6U | 2011-08-18T07:00:00Z | UCDcSZ1Wjn8A36CCakDV6V8A | Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta) | Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment | {"default": {"url": "https://i.ytimg.com/vi/-wVWjl9Kq6U/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/-wVWjl9Kq6U/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/-wVWjl9Kq6U/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/-wVWjl9Kq6U/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/-wVWjl9Kq6U/maxresdefault.jpg", "width": 1280, "height": 720}} | TedeschiTrucksVEVO | ["Masterworks", "Midnight in Harlem (Live from Atlanta)", "Rock", "Tedeschi Trucks Band"] | 10 | none | {"title": "Tedeschi Trucks Band - Midnight in Harlem (Live from Atlanta)", "description": "Music video by Tedeschi Trucks Band performing Midnight in Harlem (Live from Atlanta). (C) 2011 Sony Music Entertainment"} | 2369260 | 18509 | 0 | 1062 | ||
C6-JxDWYJ-A | 2011-08-18T06:05:27Z | UCs-7dt5SOgJBC0kXq33dNRg | John Fred and The Playboys - Shirley - Great Late 50's Rock and Roll | Fantastic Louisiana sound here | {"default": {"url": "https://i.ytimg.com/vi/C6-JxDWYJ-A/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/C6-JxDWYJ-A/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/C6-JxDWYJ-A/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/C6-JxDWYJ-A/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/C6-JxDWYJ-A/maxresdefault.jpg", "width": 1280, "height": 720}} | PJDooWop | ["Shirley", "John Fred", "Playboys", "Montel", "Baton Rouge", "Louisiana", "Rock and Roll", "50s", "1950's", "1959", "'59", "single", "styrene", "45"] | 10 | none | {"title": "John Fred and The Playboys - Shirley - Great Late 50's Rock and Roll", "description": "Fantastic Louisiana sound here"} | 187626 | 728 | 0 | 57 |
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);