videos
2 rows where categoryId = 10 and "publishedAt" is on date 2011-09-18
This data as json, CSV (advanced)
Suggested facets: publishedAt (date)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
fpVlYpgTKZI | 2011-09-18T12:27:21Z | UCnLI0Y2jDcKp5q7Nxve-M2g | Lossy - Rain Came Down | http://lossylossylossy.tumblr.com http://soundcloud.com/lossylossylossy | {"default": {"url": "https://i.ytimg.com/vi/fpVlYpgTKZI/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/fpVlYpgTKZI/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/fpVlYpgTKZI/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/fpVlYpgTKZI/sddefault.jpg", "width": 640, "height": 480}} | miroNZ1983 | ["Lossy", "Rain", "Came", "Down"] | 10 | none | {"title": "Lossy - Rain Came Down", "description": "http://lossylossylossy.tumblr.com\r\nhttp://soundcloud.com/lossylossylossy"} | 15947 | 159 | 0 | 14 | ||
vMU7ZKY2Eso | 2011-09-18T02:16:01Z | UCMkBVDQAl7ouGKSgo2TstRA | Toño Rosario-El Hot Dog | {"default": {"url": "https://i.ytimg.com/vi/vMU7ZKY2Eso/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/vMU7ZKY2Eso/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/vMU7ZKY2Eso/hqdefault.jpg", "width": 480, "height": 360}} | TheBombers27 | ["Toño", "Rosario", "El", "Hot", "Dog"] | 10 | none | {"title": "Toño Rosario-El Hot Dog", "description": ""} | 2713482 | 13135 | 0 | 337 |
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);