videos
2 rows where categoryId = 24 and "publishedAt" is on date 2009-07-26
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
YErpnsceZw8 | 2009-07-26T14:05:26Z | UC1OyVzzl6h_XKAOIu0VDxuQ | Quartet "Salut Salon" | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | {"default": {"url": "https://i.ytimg.com/vi/YErpnsceZw8/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/YErpnsceZw8/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/YErpnsceZw8/hqdefault.jpg", "width": 480, "height": 360}} | Dina Anunziata | ["Hamburgs", "Salut", "Salon", "music", "violin", "improvisation", "virtuoso", "импровизации", "виртуозы", "Гамбургский", "квартет", "Салют", "Салон", "музыка", "ск"] | 24 | none | {"title": "Quartet \"Salut Salon\"", "description": "\"Heartache\" concert of the Hamburgs quartet \"Salut Salon\" performed in St.Petersburg, Russia during \"Week of Germany\""} | 80918 | 158 | 0 | 16 | ||
oRUdvu3Qo-E | 2009-07-26T17:06:46Z | UCSK_k67pUYKF7Z6Mt23NzwA | Tap Dogs I Beams | {"default": {"url": "https://i.ytimg.com/vi/oRUdvu3Qo-E/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/oRUdvu3Qo-E/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/oRUdvu3Qo-E/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/oRUdvu3Qo-E/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/oRUdvu3Qo-E/maxresdefault.jpg", "width": 1280, "height": 720}} | Tap Dogs Official | 24 | none | {"title": "Tap Dogs I Beams", "description": " "} | 624776 | 2651 | 0 | 93 |
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);