videos
2 rows where categoryId = 24 and "publishedAt" is on date 2012-07-29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
UEel3wTf0Sk | 2012-07-29T11:35:46Z | UCtl_7aqlAwylVMafQ6ug1qQ | Da HONK - Need all my friends | Da HONK - UNBEWEGLICH 2012 | {"default": {"url": "https://i.ytimg.com/vi/UEel3wTf0Sk/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/UEel3wTf0Sk/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/UEel3wTf0Sk/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/UEel3wTf0Sk/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/UEel3wTf0Sk/maxresdefault.jpg", "width": 1280, "height": 720}} | da honk | ["dahonk", "reggae", "ska", "heavy reggae", "honk", "need", "all", "my", "friends", "DaHONK"] | 24 | none | {"title": "Da HONK - Need all my friends", "description": "Da HONK - UNBEWEGLICH 2012"} | 1443 | 10 | 0 | 0 | ||
Xxe6vTEwFvs | 2012-07-29T15:34:40Z | UC1a83B2To0xG2QsWCc-PKBw | Shake, rattle an roll | Sesame street babies | {"default": {"url": "https://i.ytimg.com/vi/Xxe6vTEwFvs/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Xxe6vTEwFvs/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Xxe6vTEwFvs/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/Xxe6vTEwFvs/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/Xxe6vTEwFvs/maxresdefault.jpg", "width": 1280, "height": 720}} | Yvonne Bradt | ["Sesame"] | 24 | none | {"title": "Shake, rattle an roll", "description": "Sesame street babies"} | 57906 | 41 | 0 | 0 |
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);