musiccaps_details (view)
2 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "female voice singing" and musiccaps_names contains "Exciting music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- e-bass · 2 ✖
- female voice singing · 2 ✖
- uptempo 2
- acoustic drums 1
- amateur recording 1
- crowd cheering 1
- dance 1
- digital drums 1
- e-guitars 1
- keys 1
- male backing voice 1
- pop 1
- rock 1
- strings 1
- synth pluck 1
musiccaps_names (array) 4 ✖
- Exciting music · 2 ✖
- Music 2
- Happy music 1
- Rhythm and blues 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Tra La La Song Music Video - Full Version | An acoustic drum is playing a simple rock groove with some drum fills on the toms and snare along with a distorted e-bass and e-guitar playing the same line. Panned to the right side of the speaker you can hear a piano sound playing a little melody. A female voice is singing a happy sounding melody while male backing voices are supporting her. This song may be playing sitting in your room enjoying being at home alone. | 2010-02-11T03:47:04Z | Derek Bartholomaus | This is the full version of "The Tra La La Song (One Banana, Two Banana)" aka The Banana Splits Theme as performed by Liz Phair and Material Issue for the Saturday Morning Cartoons' Greatest Hits music and video project. This version was not released on home video and was only aired on MTV. This material is © 1995 by MCA Records. | ["Music", "Rhythm and blues", "Happy music", "Exciting music"] | ["rock", "e-guitars", "e-bass", "acoustic drums", "keys", "female voice singing", "male backing voice", "uptempo"] | 6 | -JvB5AL59fM | 36 | |
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 |
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;