videos
1 row where categoryId = 24 and "publishedAt" is on date 2013-01-26
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
HrPnGYGrvm0 | 2013-01-26T14:37:58Z | UCERDvPv9U4o9-zol9JKK8qQ | George Formby - Leaning on a Lampost Solo (Normal Speed and Slowed Down) | Hope this video helps! | {"default": {"url": "https://i.ytimg.com/vi/HrPnGYGrvm0/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/HrPnGYGrvm0/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/HrPnGYGrvm0/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/HrPnGYGrvm0/sddefault.jpg", "width": 640, "height": 480}} | AngusLUkulele | ["leaning", "lampost", "solo", "banjo", "ukulele", "abbott", "monarch", "greenfield", "graham", "copy", "george", "formby", "slow", "tutorial"] | 24 | none | {"title": "George Formby - Leaning on a Lampost Solo (Normal Speed and Slowed Down)", "description": "Hope this video helps!"} | 6002 | 26 | 0 | 2 |
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);