videos
2 rows where categoryId = 19 and tags contains "barcelona"
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
lYJAqOpp6RM | 2012-01-27T19:13:50Z | UC7uXH33L6uzFaL0C_xfrVRQ | Mohamed El guercifi - Aandek Tik 2012.wmv | {"default": {"url": "https://i.ytimg.com/vi/lYJAqOpp6RM/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/lYJAqOpp6RM/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/lYJAqOpp6RM/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/lYJAqOpp6RM/sddefault.jpg", "width": 640, "height": 480}} | TheOujdi67 | ["maroc", "algerie", "tunisie", "berkane", "oujda", "guercif", "reggada", "chaabi", "aarfa", "nhari", "2012", "2011", "2013", "nador", "rif", "casa", "foot", "barça", "real", "madrid", "barcelone", "barcelona", "usa", "50", "cent", "the", "game", "dr", "dre", "detox", "snoop", "dogg", "nate", "can", "rohff", "booba", "b2oba", "rim", "113"] | 19 | none | {"title": "Mohamed El guercifi - Aandek Tik 2012.wmv", "description": " "} | 610892 | 1240 | 0 | 31 | |||
t-CjLfu9zCk | 2007-05-27T15:37:31Z | UCJkkPu49nBVv-ldjwG3423Q | Flamenco Guitar Barcelona | Pair of flamenco guitarists outside Barcelona Cathedral in the Gothic Quarter, Friday, May 25, 2007 | {"default": {"url": "https://i.ytimg.com/vi/t-CjLfu9zCk/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/t-CjLfu9zCk/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/t-CjLfu9zCk/hqdefault.jpg", "width": 480, "height": 360}} | hendu2006 | ["chris", "arnold", "2007", "barcelona", "flamenco", "guitar"] | 19 | none | {"title": "Flamenco Guitar Barcelona", "description": "Pair of flamenco guitarists outside Barcelona Cathedral in the Gothic Quarter, Friday, May 25, 2007"} | 3512876 | 10378 | 0 | 1384 |
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);