videos
2 rows where categoryId = 22 and "publishedAt" is on date 2010-12-28
This data as json, CSV (advanced)
id ▼ | publishedAt | channelId | title | description | thumbnails | channelTitle | tags | categoryId | liveBroadcastContent | localized | viewCount | likeCount | favoriteCount | commentCount | defaultAudioLanguage | defaultLanguage |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Grtmre_r9yI | 2010-12-28T01:13:19Z | UCxJDXnfTBudHR04RJyNuOxQ | حفل الدوحه | " نجوى كرم" عم يرجف | {"default": {"url": "https://i.ytimg.com/vi/Grtmre_r9yI/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/Grtmre_r9yI/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/Grtmre_r9yI/hqdefault.jpg", "width": 480, "height": 360}} | Tn7Tv1 | ["3myrgf", "njwa"] | 22 | none | {"title": "حفل الدوحه | \" نجوى كرم\" عم يرجف", "description": " "} | 1271743 | 2021 | 0 | 143 | |||
RcfaWoTywcA | 2010-12-28T06:44:31Z | UCWA-4WwACdQwJEogvf7PBGg | Turkish Pop Dance Music | {"default": {"url": "https://i.ytimg.com/vi/RcfaWoTywcA/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/RcfaWoTywcA/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/RcfaWoTywcA/hqdefault.jpg", "width": 480, "height": 360}} | gagangahra1 | ["Turkish", "Pop", "Dance", "Music"] | 22 | none | {"title": " Turkish Pop Dance Music", "description": " "} | 104040 | 651 | 0 | 20 |
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);