videos
2 rows where "publishedAt" is on date 2009-01-29
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Qz2PIXM60iE | 2009-01-29T23:06:39Z | UCRo66zgp0KMYze4zEk3lfGg | Haymarket Riot-Trip On Out | U.S Psychedelic Garage Fuzz,1968. | {"default": {"url": "https://i.ytimg.com/vi/Qz2PIXM60iE/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Qz2PIXM60iE/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Qz2PIXM60iE/hqdefault.jpg", "width": 480, "height": 360}} | scrambledheadz | ["haymarket", "riot", "garage", "psych", "fuzz", "1968"] | 10 | none | {"title": "Haymarket Riot-Trip On Out", "description": "U.S Psychedelic Garage Fuzz,1968."} | 15598 | 158 | 0 | 12 | ||
W00eTCOgUNs | 2009-01-29T20:00:09Z | UC5v8zDvwyE58wXKt1k52kDw | I'm Sorry I Love You - The Magnetic Fields | I'm Sorry I Love You - The Magnetic Fields | {"default": {"url": "https://i.ytimg.com/vi/W00eTCOgUNs/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/W00eTCOgUNs/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/W00eTCOgUNs/hqdefault.jpg", "width": 480, "height": 360}} | mojorisin1986 | ["I'm", "Sorry", "Love", "You", "The", "Magnetic", "Fields"] | 10 | none | {"title": "I'm Sorry I Love You - The Magnetic Fields", "description": "I'm Sorry I Love You - The Magnetic Fields"} | 171235 | 441 | 0 | 25 |
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);