videos
2 rows where categoryId = 10 and "publishedAt" is on date 2012-08-26
This data as json, CSV (advanced)
Suggested facets: tags (array)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0hfU27A6tus | 2012-08-26T21:47:41Z | UC8KohmSf7RhJwWIwBfyJwow | Susie & Mick Darling - Rattle Tattle Gypsy | Friday 24th August 2012 - http://www.fb.com/saltburnopen | {"default": {"url": "https://i.ytimg.com/vi/0hfU27A6tus/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/0hfU27A6tus/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/0hfU27A6tus/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/0hfU27A6tus/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/0hfU27A6tus/maxresdefault.jpg", "width": 1280, "height": 720}} | Teesside Steve | ["SOAP", "Saltburn", "acoustic", "music", "live"] | 10 | none | {"title": "Susie & Mick Darling - Rattle Tattle Gypsy", "description": "Friday 24th August 2012 - \nhttp://www.fb.com/saltburnopen"} | 4976 | 42 | 0 | 3 | ||
ZNGvyFsCx4g | 2012-08-26T11:07:18Z | UCVs92oHCjeaMKDJWCea57Jg | Ringo - Rub a dub style | The late and great johnny ringo | {"default": {"url": "https://i.ytimg.com/vi/ZNGvyFsCx4g/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/ZNGvyFsCx4g/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/ZNGvyFsCx4g/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/ZNGvyFsCx4g/sddefault.jpg", "width": 640, "height": 480}} | Ronald Parker | ["dub", "roots", "Reggae", "Bob Marley", "Jamaica", "Style"] | 10 | none | {"title": "Ringo - Rub a dub style", "description": "The late and great johnny ringo"} | 3190 | 28 | 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);