musiccaps_details (view)
3 rows where musiccaps_aspects contains "uptempo", musiccaps_author = 6 and musiccaps_names = "["Music", "Exciting 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 |
---|---|---|---|---|---|---|---|---|---|---|
Sonic Adventure DX Music: BELIEVE IN MYSELF | The female voice sings in the mid range. The drums is playing a fast rock/hiphop groove along with an acoustic bass breaking along with it into another part of the song. One of the e-guitars is playing some chords running through a strong tremolo effect. While the other guitar sounds distorted and takes the lead. One is panned to the left, the other to the right side of the speakers. This song may be playing at a birthday party. | 2007-02-09T02:50:55Z | sonicKAI | This is Miles "Tails" Prower's theme tune in Sonic Adventure DX. The song is "Believe In Myself" by Karen Brake. | ["Music", "Exciting music"] | ["poprock", "e-bass", "e-guitars", "acoustic drums", "female singer", "uptempo"] | 6 | 0DizopdPMBw | 134 | |
120521 Kara - Mister [HD] @ MBC Korean Music Wave in Google | This audio contains a digital drum with a kick on every beat. An e-bass is playing a slightly funky groove. A synthesizer is playing a short fast melody. Another synth sound is playing a string/pad sound rising up into focus. A female voice is singing, then another female voice takes over singing. The crowd is cheering loudly. This song may be playing during a live show. | 2012-05-26T12:15:23Z | kpopcouchcrew | For more kpop concert updates follow~ http://twitter.com/couch_crew | ["Music", "Exciting music"] | ["amateur recording", "pop", "dance", "e-bass", "digital drums", "synth pluck", "strings", "female voice singing", "crowd cheering", "uptempo"] | 6 | 4Ua6i_VDYU4 | 575 | |
8. Mario P. Amigo - Hos Alvaro | HQ | Animation/Music Of The Week | This song contains a digital drum with a shaker panned to the left side of the speaker. There are other rhythmic sound effects panned to the right side of the speakers. A digital bass playing a repeating melody is the center of this song. This song may be playing in a dance battle. | 2012-04-15T09:37:39Z | Jsinnay | • https://vimeo.com/jsinnay http://soundcloud.com/mario-p-amigo | ["Music", "Exciting music"] | ["electro/dubstep/pop&lock", "digital drum", "digital bass sound", "sound effects", "uptempo", "uplifitng energy"] | 6 | 4dilYyxYLmM | 591 |
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;