musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "lively" and musiccaps_aspects contains "package opening"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
数字変形 Numbers transform to vehicles for kids | This is a toy package opening video with a jazz music piece in the background. In the piece, there is a clarinet playing the leading melody while other brass elements, the piano and the upright bass are accompanying it with backing tunes. The rhythm is being played by the upbeat jazz acoustic drums. The atmosphere of the piece is lively. If the package opening sounds could be removed, the piece would suit well in the soundtrack of a feelgood animation movie. | 2015-10-11T07:57:43Z | Talking Toyss | This video shows how Numbers transform to vehicles. The number includes 1,2,3. Hope you enjoy our video, pls subscribe, leave comments and check out TalkingToyss channel! learn to count numbers 1 to 10 for kids with street vechicles tomica and tomica factory https://www.youtube.com/watch?v=0ajlonqR7VY Choro-Q TRANSFORMERS チョロQ・トランスフォーマー for kids with Q Transformer and Hello Kitty cross over https://www.youtube.com/watch?v=1zDtV3Og5xY Learning Street Vehicles Names and Sounds for kids with tomica tayo robocar Poli https://www.youtube.com/watch?v=cFeJ-ORLYpI VooV ブーブ 変身 Transform street vehicles for kids with Trains https://www.youtube.com/watch?v=jfpBPYrCRrA VooV ブーブ 変身 Transform street vehicles for kids with Cars and Trucks 2 https://www.youtube.com/watch?v=OkVB75ZnwVw Learning street vehicle name with Roboca Poli English https://www.youtube.com/watch?v=99LFSxjHYbI VooV ブーブ 変身 Transform street vehicles for kids with Cars and Trucks https://www.youtube.com/watch?v=OrAW8wNYuas Vintage Lego 10196 Grand Carousel in white with sound and motor spin https://www.youtube.com/watch?v=rQ5-ycJZkyk Minions Stuart banana toys for minions movie 2015 with Sounds and Flash https://www.youtube.com/watch?v=H70IwYW9q2I Super Mario World Toys Collection unboxing https://www.youtube.com/watch?v=sFtsQvGhzJw 5 Kinder Surprise Eggs Airbus A330-300 Airplane collection https://www.youtube.com/watch?v=pZSbivWZqcw Play Doh meal makin kitchen Playset https://www.youtube.com/watch?v=iYTm2x5haM4 How to build Lego Emerald Express train - Lego Creator 31015 https://www.youtube.com/watch?v=1x0N3NGqP8c 20 Surprise Eggs,Play Doh Kinder Surprise Spongebob Disney Pixar Frozen Cars Mario https://www.youtube.com/watch?v=W4rtfPtjJ4A Toy Cutting Fruit Velcro Vegetable Salad Cooking Playset velcro steak fish chicken Cooking Playset https://www.youtube.com/watch?v=AkRYQf2gBwU Doraemon robot figure playset toy reviews https://www.youtube.com/watch?v=OG8pw04SN9I | ["Brass instrument", "Clarinet", "Trombone", "Trumpet", "Wind instrument, woodwind instrument"] | ["toy review", "package opening", "background music", "jazz", "clarinet", "brass", "upright bass", "piano", "acoustic drums", "cheerful", "lively"] | 9 | Pzp_oTEn0Yk | 2585 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;