videos
2 rows where "publishedAt" is on date 2007-06-30
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
9YnYlDFKn-U | 2007-06-30T13:28:54Z | UCt-6GdAzeSxaXZkgRIEi3Tg | SummerQueen's 1st Scratch lesson | Summie aan het scratchen voor de eerste keer in januari 2005 | {"default": {"url": "https://i.ytimg.com/vi/9YnYlDFKn-U/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/9YnYlDFKn-U/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/9YnYlDFKn-U/hqdefault.jpg", "width": 480, "height": 360}} | SummerQueen | ["SummerQueen", "scratchen", "DJ"] | 22 | none | {"title": "SummerQueen's 1st Scratch lesson", "description": "Summie aan het scratchen voor de eerste keer in januari 2005"} | 21553 | 6 | 0 | 8 | ||
vd1dgdxlA94 | 2007-06-30T22:54:41Z | UCLctFR9M5jbF7nH0o6PPAIw | Chris Armstrong 1 - Glenfiddich Ceilidh | Not sure which year.. 2002 or 2003. | {"default": {"url": "https://i.ytimg.com/vi/vd1dgdxlA94/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/vd1dgdxlA94/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/vd1dgdxlA94/hqdefault.jpg", "width": 480, "height": 360}} | Chris Eyre | ["Glenfiddich", "ceilidh", "New", "Scotland", "Hotel", "piping", "bagpipe"] | 10 | none | {"title": "Chris Armstrong 1 - Glenfiddich Ceilidh", "description": "Not sure which year.. 2002 or 2003."} | 19398 | 44 | 0 | 8 |
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);