videos
1 row where categoryId = 15 and "publishedAt" is on date 2009-04-04
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3PuzzYmTDA4 | 2009-04-04T16:07:11Z | UCsUQAgGeOwlnaHgKig5W27Q | Top 10 Most Dangerous Animals | Top 10 . These weights are totally bogus, I was a tad nuts the day I made the video. | {"default": {"url": "https://i.ytimg.com/vi/3PuzzYmTDA4/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/3PuzzYmTDA4/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/3PuzzYmTDA4/hqdefault.jpg", "width": 480, "height": 360}} | Angelo Ierullo | ["dangerous", "OneTrueMedia", "animals", "elephant", "lion", "buffalo", "shark", "jellyfish", "frog", "scary", "deadly", "danger", "freaky", "top", "10", "zoo", "hunting", "wildlife", "tiger", "safari", "lions", "nature", "africa", "deer", "arizona", "tigers", "phoenix", "youtube", "hurts"] | 15 | none | {"title": "Top 10 Most Dangerous Animals", "description": "Top 10 . These weights are totally bogus, I was a tad nuts the day I made the video."} | 154537 | 143 | 0 | 108 |
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);