musiccaps_details (view)
4 rows where musiccaps_aspects contains "digital drums", musiccaps_aspects contains "e-bass" and musiccaps_aspects contains "pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- digital drums · 4 ✖
- e-bass · 4 ✖
- pop · 4 ✖
- fast tempo 2
- female voice singing 2
- male voices singing 2
- amateur recording 1
- bongos 1
- crowd cheering 1
- dance 1
- dancing atmosphere 1
- e-guitar 1
- electric organ 1
- higher pitch 1
- higher register 1
- medium tempo 1
- melancholic 1
- strings 1
- synth pluck 1
- synth sounds 1
- synth strings 1
- uptempo 1
- violins 1
musiccaps_names (array) 7 ✖
- Music 4
- Afrobeat 1
- Christian music 1
- Exciting music 1
- Music of Asia 1
- Pop music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Roger Sanchez Feat. Lisa Pure - Lost - Original Mix (Video) | This song contains digital drums playing a four on the floor groove with a kick on every beat along to an e-bass. In the background you can hear additional bongo rhythms. A synth string sound is playing long chord notes in the background. An e-guitar is finger picking a chord melody. A female voice is singing in a higher key and with backing vocals. This song may be playing while cleaning the kitchen. | 2007-11-11T12:52:18Z | Zarmk (Mike Alcazar) | Vocal House track from the S-Man, a new house classic. Copyright belongs to the Record label Stealth Records and the artist | ["Music of Asia", "Music"] | ["pop", "synth strings", "e-guitar", "e-bass", "digital drums", "bongos", "female voice singing", "fast tempo", "melancholic"] | 6 | Hp-lgcs4VXY | 1836 | |
Khod Balak-Wael Jassar | This song contains digital drums playing a groove together with an e-bass. Different fast paced synth sounds are playing a rhythmic melody along to the drums. Violas are playing a countermelody to the male voices singing a melody creating a harmony. This song may be playing in a movie scene where someone is driving with a partner on a motorbike. | 2008-11-27T18:56:21Z | lebgirl2009 | NEW Wael Jassar 2008!!! | ["Afrobeat", "Singing", "Music", "Pop music"] | ["pop", "digital drums", "e-bass", "violins", "synth sounds", "male voices singing", "higher pitch", "fast tempo", "dancing atmosphere"] | 6 | hjrl1KHEuqE | 4132 | |
Brandon Flowers - Only The Young (Official Video) | A digital drum is playing a simple groove along with an e-bass. An organ is playing long chords with a lot of reverb. On top of that male voices sing a melody in harmony. Their voices sound high. This song may be playing with headphones while running. | 2010-10-13T00:00:08Z | BrandonFlowersVEVO | Music video by Brandon Flowers performing Only The Young. (C) 2010 The Island Def Jam Music Group #BrandonFlowers #OnlyTheYoung #Vevo | ["Christian music", "Music"] | ["pop", "electric organ", "digital drums", "e-bass", "male voices singing", "higher register", "medium tempo"] | 6 | uBENjCPS8LI | 5097 |
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;