musiccaps_details (view)
3 rows where musiccaps_aspects contains "happy mood", musiccaps_aspects contains "low quality audio" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- happy mood · 3 ✖
- low quality audio · 3 ✖
- moderate tempo 3
- percussion · 3 ✖
- bass 2
- blues song 1
- celebration song 1
- children's song 1
- choir 1
- hand claps 1
- holiday song 1
- male voice 1
- male voices 1
- overdriven guitar 1
- repetitive music 1
- rock song 1
- string section 1
- synth 1
- trumpets 1
- vocable 1
musiccaps_names (array) 4 ✖
- Music 2
- Exciting music 1
- Orchestra 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
TrackMaster Music Videos: Let's Be Brave! (REMIX) | This children's song features a male voice singing the main melody. Other voices sing vocables in harmony in the beginning and after the lyrics are sung. This is accompanied by percussion playing a fast beat. The bass plays the root notes of the chords. A synth plays an ascending lick with the vocables in the beginning. When the words are sung, the synth plays the same melody as the main voice. This is a moderate tempo song. The mood of this song is happy. This song can be sung in a children's action movie. | 2014-10-31T00:58:25Z | MrEngine88 Reviewer | NOTE: Thomas & Friends © Copyright of HiT Entertainment. Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for -fair use- for purposes such as criticism, comment, news reporting, teaching, SCHOLARSHIP, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. It's almost Halloween. So I tried another REMIX. Creating these for fun. Listen to more music everyday! Comment about what kind of music do you like. Give this video a thumbs up if you enjoyed listening to this music video. You can also share this with your friends. And subscribe for more musical videos! MAKE SURE TO GO TO THESE ACCOUNTS: Main Channel (MrEngine88): http://www.youtube.com/user/MrEngine88 2nd YouTube Channel (MrEngine88 Reviewer): http://www.youtube.com/user/MrEngine88Reviewer 3rd YouTube Channel (DisneyCarsFan88) http://www.youtube.com/user/DisneyCarsFan88 Twitter: http://www.twitter.com/HGreen88 Blog (MrEngine88 Reviewer): http://MrEngine88Reviewer.blogspot.com/ Tumblr (#MrEngine88): http://mrengine88.tumblr.com | ["Music", "Exciting music"] | ["children's song", "low quality audio", "vocable", "male voices", "repetitive music", "happy mood", "percussion", "bass", "synth", "moderate tempo"] | 0 | KCs_VPmsnKo | 2065 | |
Sesame Street - ZZ Blues | This blues song features a male voice singing the main melody at a comfortable pitch. This is accompanied by percussion playing a simple rock beat in common time. An overdriven guitar plays a blues riff. After one bar, the guitar and bass pause while the percussion and voice continues. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played in a bar scene in a movie. | 2008-04-25T05:25:53Z | mstatz | A group that looks much like ZZ Top sings about the letter Z in ZZ Blues! A bluesy kind of song and another great lesson for kids. Big Bird makes an appearance before the video begins here. | ["Music", "Ska"] | ["rock song", "blues song", "male voice", "low quality audio", "overdriven guitar", "percussion", "bass", "happy mood", "moderate tempo"] | 0 | aLnBwjLUZao | 3530 | |
Jingle Bells - Auckland Symphony Orchestra | This song features the main melody sung by a choir. This is accompanied by the string section and brass section featuring violins and trumpets. Hand claps are heard on every count. Orchestral percussion plays in the background. As the quality of audio is low, many instruments cannot be heard. This song can be played in a celebration. | 2008-12-09T09:20:44Z | Calum Anderson | The Auckland Symphony Orchestra along with a combined choir perform Jingle Bells at their annual Christmas concert in the Auckland Town Hall in 2008. | ["Orchestra"] | ["celebration song", "holiday song", "string section", "low quality audio", "hand claps", "choir", "trumpets", "percussion", "moderate tempo", "happy mood"] | 0 | bQ9vpp_yXvk | 3624 |
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;