musiccaps_details (view)
2 rows where musiccaps_names contains "Tire squeal" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- breakbeat 1
- children's music 1
- dance 1
- electronic dance music 1
- electronic drums 1
- happy feel 1
- hip 1
- instrumental 1
- keyboard song 1
- moderate tempo 1
- no voices 1
- pad 1
- programmed percussion 1
- strings 1
- synth bass 1
- truck sounds 1
- twinkling sounds 1
- urban 1
youtube_published (date) 2 ✖
- 2009-10-17 1
- 2015-05-29 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1986 mustang GT 5.0 burning out and tearing up the town | This is a breakbeat piece. There is a groovy electronic drum beat providing the rhythmic structure. A medium pitched pad is playing a repeated theme. There is a synth bass in the background. Occasional string stab hits can be heard. This piece could fit well in the soundtracks of crime movies taking place in the city and car racing video games. | 2009-10-17T18:37:44Z | Champalamp Johnson | clownin in como. drifting | ["Music", "Rapping", "Tire squeal"] | ["breakbeat", "electronic dance music", "instrumental", "electronic drums", "synth bass", "pad", "strings", "dance", "urban", "hip"] | 9 | 9TkW1M_ZRr0 | 1010 | |
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;