musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard song" and musiccaps_aspects contains "moderate tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- keyboard song · 2 ✖
- moderate tempo · 2 ✖
- children's music 1
- funk rock 1
- funky bass 1
- happy feel 1
- keyboard layers 1
- male voice 1
- no voices 1
- programmed percussion 1
- repetitive piano melody 1
- simple percussion 1
- truck sounds 1
- twinkling sounds 1
musiccaps_names (array) 4 ✖
- Music 2
- Funk 1
- Rhythm and blues 1
- Tire squeal 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funk Initiative - Architects [Official Music Video] | This funk rock song features a male voice singing the main melody. This is accompanied by percussion playing a simple beat. A tambourine, snare and kick are played simultaneously on every count. The tambourine plays on the eighth note. This song is common time. A repetitive piano melody is played in the background. The bass plays the root notes with fills. A whistling sound is played in the gap between lines. At the beginning and toward the middle of the song, the sound of strings is heard playing a short lick. This song can be played in a spy romance movie. | 2013-02-12T16:28:54Z | Funk Initiative | Music by Funk Initiative Song and lyrics by Paul Torpiano Vocals - Gianluca Bezzina Bass guitar - Shaun Abdilla Guitar - Daniel Cassar Sax - Fabian Bonello Drums - Daniel Buttigieg Keys - Paul Torpiano Recorded and produced by Niki Gravino at Foreface Studios. Video: - Directed and Produced by Jacques Norris Special thanks to: - ELSA - SACES - INSITE - Chris Mintoff - Jake Dalli - Nichi Agius - Andrew Schembri - Rob Rizzo - Simon Callus - Deborah Farrugia - Warren Sammut | ["Funk", "Music", "Rhythm and blues"] | ["funk rock", "male voice", "repetitive piano melody", "funky bass", "simple percussion", "keyboard song", "keyboard layers", "moderate tempo"] | 0 | ONfd_rHtL74 | 2433 | |
Leo the truck - The car transporter. Kids' cartoons. | This children's song features truck sounds. This is accompanied by a keyboard playing a melody using a flute-like sound. A twinkling melody is played in the background. The percussion is programmed. The percussion plays a simple beat. The bass plays the root and fifth notes of the chords. The mood of the song is happy. There are no voices in this song. This song can be used in a children's animated movie. | 2015-05-29T06:54:51Z | KidsFirstTV | What car can transport cars for kids? A car transporter! Build new kids' vehicles with Leo the Truck and play with trucks for kids on our KidsFirstTV channel for children! Play fun kids' games and watch kids' cartoons & animations for kids with cars and trucks! Build a new car every episode! Leo the Truck English learning video. Join Leo’s games! Appstore or Google Play: https://l.projectfirst.tv/Games Buy Watch the best cartoons & videos in our app https://l.projectfirst.tv/KKapp Buy Leo the truck & toys http://l.projectfirst.tv/LeoToysUS Sing with Leo! https://distrokid.com/hyperfollow/leothetruck/leos-favourite-nursery-rhymes-2 Funny kids' songs with Leo https://distrokid.com/hyperfollow/leothetruck/sing-with-leo Build cars 🚗 and trucks 🚚 with Leo the Truck https://www.youtube.com/watch?v=EvPF5upenRQ&list=PLdqtsRz9B9qd19PGLcFQjHkXdQAw6U2kr ⚙️ Repair cars with doctor McWheelie 🔧 https://www.youtube.com/watch?v=P987mDsp0xI&list=PLdqtsRz9B9qdmX0udNwnsRIZYA04ZOaIB Play & learn 🚒 vehicles 🏎️ with Excavator Max https://www.youtube.com/watch?v=vHKVE6hV2nI&list=PLdqtsRz9B9qfwOBUqFQZNzSsU3HJk_e7w Find us in VK https://vk.com/kidsfirsttv Facebook https://www.facebook.com/KidsFirstTV Subscribe KidsFirstTV channel here https://www.youtube.com/user/KidsFirstTV?sub_confirmation=1 | ["Music", "Tire squeal"] | ["children's music", "twinkling sounds", "truck sounds", "keyboard song", "no voices", "programmed percussion", "moderate tempo", "happy feel"] | 0 | tWseBEYhE1M | 5047 |
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;