musiccaps_details (view)
1 row where musiccaps_aspects = "["cinematic", "soundeffects", "horn honking"]"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Airport Diary - Episode 53 - Safe driving license! - Airplane cartoons for children | This audio contains sound effects like horn honking and mallet instruments walking up the scale. This may be playing on a machine in a casino. | 2015-08-26T15:39:20Z | For Kids TV | All episodes: http://bit.ly/AirportDiary #animation for #children about #planes and #cars! All of the cars at the Fluffy airport are to go through a driving test for a safety driving. Miko doesn't want to practice. She thinks she's the best driver. But Miko is the only one who fails the driving test! Winkie, a small airliner, whose dream is to travel around the world comes to the Fluffy Airport and meets various airplanes and cars. This animation also reveals secret stories about airplanes and airport! Subscribe: https://www.youtube.com/user/EnglishForKidsTV WATCH MORE GREAT CARTOONS: Captain Kraken: http://bit.ly/CaptainKrakenAndHisCrew Learn to count: http://bit.ly/HappyCounting Nursery Rhymes Three Kittens: http://bit.ly/ThreeKittens Nursery Songs : http://bit.ly/BaekoSongs Om Nom Stories (Cut the Rope): http://bit.ly/Om_NomStories Let’s colour Om Nom: http://bit.ly/colouringBooks Otto’s walk: http://bit.ly/OttoS_Walk Cars, cars http://bit.ly/CarsCars Alien Monkeys: http://bit.ly/AlienMonkeys BOTOS: http://bit.ly/BotoS Colouring books: http://bit.ly/MyColouringBook Airport Diary: http://bit.ly/AirportDiary Welcome to Qumiland: http://bit.ly/Qumi-qumi | ["Silence", "Music"] | ["cinematic", "soundeffects", "horn honking"] | 6 | z4ewUsnIJKI | 5456 |
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;