videos
2 rows where categoryId = 22 and "publishedAt" is on date 2014-06-16
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Byk9p21g51g | 2014-06-16T15:27:33Z | UCKpmYvOmTtCQEibGnYdfETw | DJ MANY REMIX RIHANNA TE AMO VS SALSA GITANO 2014 | reggaeton mambo merengue funk salsa latino gitano rumba mariage new jack bachata prince royce toby love michael Jackson gomez fraco Porto Rico DOMINICANO DOMINICANA CUBA RNB CHAMPETTA RAP MAFIA URBANA CRISTIANO JENNIFER LOPEZ DELERIA SANTIAGO FERNANDEZ | {"default": {"url": "https://i.ytimg.com/vi/Byk9p21g51g/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Byk9p21g51g/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Byk9p21g51g/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/Byk9p21g51g/sddefault.jpg", "width": 640, "height": 480}} | santiago dj many | 22 | none | {"title": "DJ MANY REMIX RIHANNA TE AMO VS SALSA GITANO 2014", "description": "reggaeton mambo merengue funk salsa latino gitano rumba mariage new jack bachata prince royce toby love michael Jackson gomez fraco Porto Rico DOMINICANO DOMINICANA CUBA RNB CHAMPETTA RAP MAFIA URBANA CRISTIANO JENNIFER LOPEZ DELERIA SANTIAGO FERNANDEZ "} | 3703 | 15 | 0 | 3 | |||
TKSFbf-wQ8I | 2014-06-16T22:09:35Z | UCLMp64Dvea6WZf9eb08IfLA | Battle of Sounds in Lapu-Lapu City Mactan,Cebu... | Category: 4pcs.Compression Driver Tweeter, 4pcs.15inches Mid-Speakers, 4pcs.18inches Sub-Speakers,3pcs.Power Amplifier unlimited wattage of Amps.,Speakers & Processors Quantity... | {"default": {"url": "https://i.ytimg.com/vi/TKSFbf-wQ8I/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/TKSFbf-wQ8I/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/TKSFbf-wQ8I/hqdefault.jpg", "width": 480, "height": 360}, "standard": {"url": "https://i.ytimg.com/vi/TKSFbf-wQ8I/sddefault.jpg", "width": 640, "height": 480}, "maxres": {"url": "https://i.ytimg.com/vi/TKSFbf-wQ8I/maxresdefault.jpg", "width": 1280, "height": 720}} | jim earl | 22 | none | {"title": "Battle of Sounds in Lapu-Lapu City Mactan,Cebu...", "description": "Category: 4pcs.Compression Driver Tweeter, 4pcs.15inches Mid-Speakers, 4pcs.18inches Sub-Speakers,3pcs.Power Amplifier unlimited wattage of Amps.,Speakers & Processors Quantity..."} | 253615 | 438 | 0 | 84 |
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);