videos
3 rows where categoryId = 10 and "publishedAt" is on date 2007-07-31
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5rjQU4vOIlw | 2007-07-31T05:23:49Z | UCRZ7qL1d3Lat0vnG_yX5WOw | Re: Train songs and Fox Chase (harmonica) | My attempt at some train-type stuff. | {"default": {"url": "https://i.ytimg.com/vi/5rjQU4vOIlw/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/5rjQU4vOIlw/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/5rjQU4vOIlw/hqdefault.jpg", "width": 480, "height": 360}} | 12gagedan | ["Harp", "Harmonica", "train", "tutorial", "fox", "trot", "chord", "chug", "lesson", "how", "to", "instruction", "tip", "vamp", "puppet"] | 10 | none | {"title": "Re: Train songs and Fox Chase (harmonica)", "description": "My attempt at some train-type stuff."} | 41154 | 78 | 0 | 31 | ||
XvN-qr-WYmw | 2007-07-31T21:19:34Z | UCQ-CrBAOIAxkW9EjmBVrf2A | Stone Mountain 2005 Highland Games Massed Bands | This is closer to the end of the massed bands after they have already taken the field. This is from 2005 Stone Mountain Highland Games | {"default": {"url": "https://i.ytimg.com/vi/XvN-qr-WYmw/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/XvN-qr-WYmw/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/XvN-qr-WYmw/hqdefault.jpg", "width": 480, "height": 360}} | scoutquinn | ["stone", "mountain", "highland", "games", "pipe", "band", "bagpipes", "massed"] | 10 | none | {"title": "Stone Mountain 2005 Highland Games Massed Bands", "description": "This is closer to the end of the massed bands after they have already taken the field. This is from 2005 Stone Mountain Highland Games"} | 22841 | 29 | 0 | 3 | ||
YGWweVRzFrw | 2007-07-31T08:22:08Z | UCoGqm5AhyNTPhK-Kpkh52nQ | memory | romantic song played on the paraguayan harp at the castle of Petershagen, Germany | {"default": {"url": "https://i.ytimg.com/vi/YGWweVRzFrw/default.jpg", "width": 120, "height": 90}, "medium": {"url": "https://i.ytimg.com/vi/YGWweVRzFrw/mqdefault.jpg", "width": 320, "height": 180}, "high": {"url": "https://i.ytimg.com/vi/YGWweVRzFrw/hqdefault.jpg", "width": 480, "height": 360}} | Friedrich M. Hacheney | ["paraguayan", "harp", "arpa", "paraguaya", "barbra", "streisand", "musical", "cats"] | 10 | none | {"title": "memory", "description": "romantic song played on the paraguayan harp at the castle of Petershagen, Germany"} | 41345 | 136 | 0 | 8 |
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);