musiccaps_details (view)
1 row where musiccaps_aspects contains "organ keys chords", musiccaps_aspects contains "plastic sound effect", musiccaps_aspects contains "soft kick hits" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Little Heroes 10 - The Spark, The Police Car, The Fire Engine and The Dump Truck | The low quality recording features a children's song that consists of organ keys chords, groovy piano chords, light snare hits, soft kick hits, shimmering hi hats, and flute melody. There are some squeaky sound effects, alongside plastic foley effects and outdoor ambience sounds. It sounds fun and happy, like something kids would listen to. | 2015-09-06T15:11:33Z | New Sky Kids | In Little Heroes Episode 10 the Spark is back and the cops in their kids police car and the firemen in their kids fire engine are trying to catch this fire starting bad guy! The little kid heroes rush to the rescue as he sets a tractor and dump truck on fire. --------- More Little Heroes Episodes from New Sky Kids Little Heroes 1 - Firemen Helping Others: https://youtu.be/WJfVLW6Rn2U Little Heroes 2 - The New Fire Engine, The Mayor and The Spark: https://youtu.be/LvjZ7nPF-b4 Little Heroes 3 - Firemen with their Fire Engine Teaching Darth Vader a Few Lessons: https://youtu.be/8MrH676G4hM Little Heroes 4 - The Stealer, The Fire Engine and The Batmobile: https://youtu.be/i73IBlKr1cg Little Heroes 5 - The Cops, The Fire Engine and The Return of The Spark: https://youtu.be/HOciBhi-GDc Little Heroes 6 - Firemen With Their Fire Engine Teaching Darth Vader Fire Safety: https://youtu.be/KHPy3nnLqcw Little Heroes 7 - The Germ Police And Their Cop Car - With Spiderman, The Hulk, And Darth Vader: https://youtu.be/gcAej0IHjIk Little Heroes 8 - The Spark, The Fire Engine, The Tractor And The Farm Fire: https://youtu.be/KzeIGSDpvhw Little Heroes 9 - The Police Car, The Stealer, The Fire Engine and Spiderman: https://youtu.be/VE3Cy9vmqm4 | ["Jingle (music)", "Music"] | ["low quality", "plastic sound effect", "squeaky sound effect", "light snare hits", "outdoor sound effects", "organ keys chords", "groovy piano chords", "shimmering shakers", "claps", "soft kick hits", "flute melody", "fun", "happy"] | 4 | tWexzTJPxQs | 5046 |
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;