videos
1 row where categoryId = 10 and "publishedAt" is on date 2007-03-20
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
PQ7cX2Cnusg | 2007-03-20T01:01:01Z | UCx1C9wEukBmdmlUVtM6_d2A | Dio - Time to Burn | Dio - Time To Burn Sacred Heart: The Video 86' | {"default": {"url": "https://i.ytimg.com/vi/PQ7cX2Cnusg/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/PQ7cX2Cnusg/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/PQ7cX2Cnusg/hqdefault.jpg", "width": 480, "height": 360}} | Pablo A. | ["Ronnie", "James", "Dio", "Time", "To", "Burn", "Sacred", "Heart", "The", "Video", "1986", "Metal"] | 10 | none | {"title": "Dio - Time to Burn", "description": "Dio - Time To Burn\r\nSacred Heart: The Video 86'"} | 178973 | 861 | 0 | 141 |
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);