musiccaps_details (view)
4 rows where musiccaps_aspects contains "higher pitch", musiccaps_aspects contains "male voice singing" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- higher pitch · 4 ✖
- male voice singing · 4 ✖
- uptempo · 4 ✖
- acoustic drums 3
- e-bass 2
- e-guitar 2
- piano 2
- chimes 1
- crowd cheering 1
- digital drums 1
- indie7rock/pop 1
- organ 1
- pop 1
- reggae 1
- techno 1
musiccaps_names (array) 7 ✖
- Music 3
- Independent music 2
- Singing 2
- Disco 1
- Music of Asia 1
- Pop music 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ngayong Gabi - brownman revival | This audio contains reggae-like drums playing along with a bass. An e-guitar is strumming short chords on the backbeat giving this song its typical reggae feel. An organ is playing a melody panned to the left side of the speakers playing short fast chords. A male voice is singing a melody in a higher pitch than a piano is walking down the scale creating a melody then a chime comes in getting the song ready for the next part. This song may be playing while sitting by a lake with your friends. | 2010-09-06T03:16:22Z | gin2141 | ["Soul music"] | ["reggae", "e-bass", "e-guitar", "acoustic drums", "male voice singing", "higher pitch", "organ", "piano", "chimes", "uptempo"] | 6 | 8HHrlxQuZKE | 909 | ||
Michael Jackson (Ease On Down The Road) | This song contains digital drums playing a four on the floor rhythm with a strong kick on every beat. A male voice is singing at a higher pitch. This song may be playing in a techno club. | 2007-12-05T07:08:08Z | Mredwards12 | A Tribute To Michael Jackson (You Will Be Missed) | ["Disco", "Music"] | ["techno", "digital drums", "male voice singing", "higher pitch", "uptempo"] | 6 | Obtx-A9Lt5c | 2450 | |
Top 30 Indie Songs I Think You Should Listen To | This song contains someone playing acoustic drums along with an e-bass. They both sound in the foreground. A male voice is singing in the high mids and with reverb and a little delay on his voice. Then the song breaks into the next part and an e-guitar comes in with a strummed melody. This song may be playing with headphones lost in thoughts. | 2009-09-27T17:23:53Z | top30music | Follow me on twitter!: @Top30music 30 great indie songs from bands from 12 different countries!!... if you know a good indie song dont keep it to yourself... comment about it! If you're looking for new music, don't hesitate on clicking here: http://www.youtube.com/watch?v=1xXuKvtOlaw amazing artist! | ["Singing", "Music", "Independent music"] | ["indie7rock/pop", "male voice singing", "higher pitch", "acoustic drums", "e-bass", "e-guitar", "uptempo"] | 6 | atWaDoSyGgY | 3584 | |
BEAST - You / Fiction LIVE | THis song contains a piano playing a major chord progression in the midrange with the left hand playing bass notes creating a simple bassline. An acoustic drum is playing a constant groove without any big changes. A male voice is singing in a higher register getting backing vocals from another male voice. In the background you can hear the crowd cheering. It mostly sounds like female voices. This song may be playing at a live concert. | 2011-06-16T14:16:43Z | DBSKtelevison | Having already won a triple crown for "Fiction", the B2ST boys performed a special goodbye stage for their fans on today's Mnet M! Countdown. Though it has only been a month, the boys are wrapping up promotions on a high, having won triple crowns on M! Countdown and Music Bank, and being a two-time Mutizen winner on Inkigayo. In gratitude, B2ST will present their fans with a performance of their cute and lively song, "You". The production crew for M! Countdown stated, "B2ST, who showed their sorrowful and charismatic performance with their song 'Fiction', will be showing their sweet and lovely side through this performance. Please look forward to it!" | ["Singing", "Music of Asia", "Music", "Independent music", "Pop music"] | ["pop", "piano", "acoustic drums", "crowd cheering", "male voice singing", "higher pitch", "uptempo"] | 6 | yIFP8fkq8GU | 5398 |
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;