videos
1 row where categoryId = 24 and "publishedAt" is on date 2010-07-19
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
vYP60jdTupc | 2010-07-19T13:18:56Z | UCLfAPXbjaxfGsriA6pBOYXg | [HQ] TELEPHONE live! by Lady Gaga & Beyonce feat. Sarah Geronimo | [HQ] TELEPHONE live! by Lady Gaga & Beyonce performed by: Sarah Geronimo | {"default": {"url": "https://i.ytimg.com/vi/vYP60jdTupc/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/vYP60jdTupc/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/vYP60jdTupc/hqdefault.jpg", "width": 480, "height": 360}} | jsv07 | ["telephone", "lady", "gaga", "beyonce", "sarah", "geronimo", "pop", "rnb", "hiphop", "asap", "xv", "concert", "awards", "korean pop music"] | 24 | none | {"title": "[HQ] TELEPHONE live! by Lady Gaga & Beyonce feat. Sarah Geronimo", "description": "[HQ] TELEPHONE live! by Lady Gaga & Beyonce \r\n\r\nperformed by:\r\nSarah Geronimo"} | 153912 | 756 | 0 | 46 |
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);