videos
1 row where categoryId = 24 and "publishedAt" is on date 2008-11-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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
IlUcHzBzZvg | 2008-11-26T23:03:40Z | UCtrBZw8AwU96gtqRq4JpzLQ | SKREW MSK AWR ARTIST WRITING | GUERILLAONE.COM IS A TEN YEAR OLD GRAFFITI SITE THAT HAS BEEN AROUND FOR TEN YEARS, IF YOU DONT KNOW ASK SOMEBODY OR VISIT http://www.guerillaone.com/ OR http://blog.guerillaone.com/ | {"default": {"url": "https://i.ytimg.com/vi/IlUcHzBzZvg/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/IlUcHzBzZvg/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/IlUcHzBzZvg/hqdefault.jpg", "width": 480, "height": 360}} | Eddie Donaldson | ["art", "awr", "book", "com", "drawing", "graffiti", "guerillaone", "ink", "msk", "pen", "piece", "skrew", "street", "taging", "writing"] | 24 | none | {"title": "SKREW MSK AWR ARTIST WRITING", "description": "GUERILLAONE.COM IS A TEN YEAR OLD GRAFFITI SITE THAT HAS BEEN AROUND FOR TEN YEARS, IF YOU DONT KNOW ASK SOMEBODY OR VISIT http://www.guerillaone.com/ OR http://blog.guerillaone.com/"} | 7630 | 8 | 0 | 7 |
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);