videos
2 rows where categoryId = 22 and "publishedAt" is on date 2007-08-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
puAclKsCbes | 2007-08-19T18:07:06Z | UCuCNivgspj8r52J9RU3r19g | Sam Bush and the Infamous Stringdusters | Otis Mountain Festival, Elizabethtown, NY. 8/18/07 | {"default": {"url": "https://i.ytimg.com/vi/puAclKsCbes/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/puAclKsCbes/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/puAclKsCbes/hqdefault.jpg", "width": 480, "height": 360}} | Nina | ["sam", "bush", "infamous", "stringdusters", "bluegrass", "otis", "mountain", "festival", "www.otismountain.com"] | 22 | none | {"title": "Sam Bush and the Infamous Stringdusters", "description": "Otis Mountain Festival, Elizabethtown, NY. 8/18/07"} | 47431 | 47 | 0 | 12 | ||
w0QJT6ywza0 | 2007-08-19T15:24:41Z | UCseOJZyJDZqPEv9ZZKChtlQ | PROFESSOR EATS A PEA WHILE I PLAY UNFITTING MUSIC | rip michael jackson, teena marie, triforce mike, adam yauch, donna summer, neil armstrong, dave brubeck, polygon jim, paul walker, danny wells, nelson mandela, nelson "remix" reyes, "GamerJoe," robin williams, origa, monty oum, swift rock, scott weiland, david bowie, alan rickman, umberto eco, phife dawg, prince, muhammad ali, kimbo slice, christina grimmie, anton yelchin, yvain gnabro, bobby 'lil loco' garcia, carrie fisher, marcus intalex, prodigy, chester bennington, holger czukay, troy gentry, x atencio, edith windsor, lt. col. stanislav petrov, emer prevost, aretha franklin, stan lee, pua magasiva and kim english ;_; | {"default": {"url": "https://i.ytimg.com/vi/w0QJT6ywza0/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/w0QJT6ywza0/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/w0QJT6ywza0/hqdefault.jpg", "width": 480, "height": 360}} | MarkieV101 | ["you'll", "never", "guess", "what's", "for", "breakfast", "supper", "villain", "swallow", "it", "eat"] | 22 | none | {"title": "PROFESSOR EATS A PEA WHILE I PLAY UNFITTING MUSIC", "description": "rip michael jackson, teena marie, triforce mike, adam yauch, donna summer, neil armstrong, dave brubeck, polygon jim, paul walker, danny wells, nelson mandela, nelson \"remix\" reyes, \"GamerJoe,\" robin williams, origa, monty oum, swift rock, scott weiland, david bowie, alan rickman, umberto eco, phife dawg, prince, muhammad ali, kimbo slice, christina grimmie, anton yelchin, yvain gnabro, bobby 'lil loco' garcia, carrie fisher, marcus intalex, prodigy, chester bennington, holger czukay, troy gentry, x atencio, edith windsor, lt. col. stanislav petrov, emer prevost, aretha franklin, stan lee, pua magasiva and kim english ;_;"} | 509639 | 7364 | 0 | 1835 |
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);