musiccaps_details (view)
5 rows where musiccaps_aspects contains "groovy rhythm", musiccaps_aspects contains "poor audio quality" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- groovy rhythm · 5 ✖
- poor audio quality · 5 ✖
- spirited · 5 ✖
- passionate 4
- instrumental music 3
- percussive bass line 3
- cymbals crashing 2
- dance rhythm 2
- emotional 2
- energetic 2
- exciting 2
- guitar lead 2
- medium tempo 2
- steady drumming rhythm 2
- adrenaline rush 1
- adventure of a lifetime 1
- ambient noises 1
- asian pop 1
- backing track 1
- classic rock 1
- death metal music 1
- enteric 1
- fast tempo 1
- female singers 1
- fusion music 1
- guitar demo 1
- guitar playing rhythm 1
- guitar rhythm 1
- guitar solo 1
- guitar strumming 1
- …
musiccaps_names (array) 9 ✖
- Music 5
- Rock music 2
- Angry music 1
- Country 1
- Flamenco 1
- Grunge 1
- Progressive rock 1
- Psychedelic rock 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Anil Shahi - Maya Mantra (Instrumental) | The song is an instrumental. The song is medium tempo with a percussive tabla rhythm, groovy bass line and a guitar strumming rhythm and playing lead. The song is Indian classical fusion with a poor audio quality. | 2013-02-23T19:05:58Z | NepaliLyricsChords | http://NepaliLyricsChords.com Anil Shahi performing Maya Mantra (Instrumental) in Thamel Square Grand Opening Program Program Name: Thamel Square Grand Opening Location: JP Road, Thamel. Kathmandu Facebook Page (Thamel Square): https://www.facebook.com/ThamelSquare Facebook Page (Nepali Lyrics Chords): http://www.facebook.com/Golomech | ["Country", "Flamenco", "Music"] | ["indian classical music", "hindustani music", "improvisational", "energetic", "exciting", "passionate", "spirited", "live audience", "ambient noises", "dance rhythm", "guitar lead", "poor audio quality", "poor audio quality", "tabla percussions", "groovy rhythm", "guitar strumming", "instrumental music", "percussive bass line", "fusion music"] | 1 | TWm_2QncYXg | 2841 | |
[2NE1 'I AM THE BEST' DANCE COVER] 2NE11 from LOS ANGELES | Female singers sing this vocal harmony with backup singers. The song is medium tempo with a groovy bass line, violin countermelody, and keyboard harmony. The song is entertaining and groovy. The song has a poor audio quality. | 2011-07-28T00:01:02Z | thebeatgoesboomcat | ***Thank you everyone who voted for us! We're happy we got to share our love for dance, music, and most importantly 2NE1 with so many of you guys :)*** WE LOVE 2NE1!!!!!!!! We are "2NE11" from Los Angeles! We're called "2NE11" because that's the year we made the video. Also, we almost have 11 dancers. We're just a bunch of college and post-grad-in-denial students dancing it away on the streets of LA until morning traffic hits :) We had a lot of fun making this video, and I hope you guys enjoyed watching it too! It was a lot of fun choreographing and dancing to 2NE1 again (we did it to Can't Nobody before... WOOHOO!!!!) Our project team consists of Korean, Japanese, Chinese, Taiwanese, Indonesian, and Vietnamese dancers :] HI 2NE1!!! If you happen to be reading this, we'd love to meet you guys in person :) Thank you for giving us an opportunity to pay tribute to our favorite group with our closest friends who share the same passions - dance, joking around, and 2NE1! :] ********************************************************* Thanks for voting for us at: http://www.youtube.com/ygevent They have other cool submission videos so check them out! ********************************************************* Now, here are the lovely dancers: Bart Wiharto Christie Tang Derick Ngan HoSeong Hwang Jennie Kim Justine Yoon Lucas Yu Naoya Nick Ogura Stephanie YoonJi Song Tiffany Hung Choreographers: Stephanie YoonJi Song Christie Tang Derick Ngan Naoya Nick Ogura ... with the help and input from all of our dancers :] | ["Music", "Zing"] | ["female singers", "poor audio quality", "asian pop", "vocal harmony", "techno dance pop", "trance music vibes", "groovy rhythm", "strong bas slide", "high gain limits", "steady drumming rhythm", "violin harmony", "dance rhythm", "passionate", "spirited"] | 7 | TworrkXAPuI | 2877 | |
Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | A male singer sings this cool spirited melody. The song is medium tempo with a steady drumming rhythm, guitar playing lead, guitar strumming, strong bass line and various percussion hits. The song is exciting and energetic. The song has poor audio quality. | 2009-05-26T06:56:15Z | SirHenryII | Eloy - Eloy ... Same (Mülltonnencover) - Rare Progressive | ["Music", "Psychedelic rock", "Rock music", "Progressive rock"] | ["male singer", "guitar rhythm", "percussive bass line", "medium tempo", "groovy rhythm", "old school music", "spirited singing", "retro pop music", "story telling", "steady drumming rhythm", "marching rhythm", "cymbals crashing", "snare hits", "enteric", "exciting", "positive cheerful", "spirited", "emotional", "vintage hits", "poor audio quality"] | 1 | ckOe-8qdaew | 3736 | |
Snap Crackle and how`s your Dad | The song is an instrumental. The song is medium tempo with a groovy bass line, rock drumming, tambourine percussion, guitar rhythm and guitar lead. The song is adventurous and emotional. The song is classic rock and has a poor audio quality. | 2010-06-19T06:13:50Z | BurnsErnst | Here is another special tune by The Shadows. Backing track is from the original vinyl record without the first lead. On some parts, where the lead was on both channels, I try to play as exactly along with Hank as I could. I hope it`s ok. | ["Music", "Grunge"] | ["instrumental music", "guitar lead", "soloist", "guitar solo", "vintage rock vibes", "emotional", "spirited", "passionate", "groovy rhythm", "psychedelic", "backing track", "classic rock", "tambourine percussions", "medium tempo", "steady rock drumming", "organ accompaniment", "poor audio quality", "home music video", "guitar demo", "retro rock music", "steady bass line", "adventure of a lifetime"] | 1 | g6f-LxiT9Eo | 4006 | |
Crematory - Tick Tack | The song is an instrumental. The tempo is medium fast with strong metal drumming, groovy bass line, distorted guitar playing rhythm and cymbals crashing. The song is high on adrenaline and exciting. The audio quality is poor. | 2009-05-09T13:45:07Z | pavenpaul | Artist: Crematory Song: Tick Tack Album: Revolution Genre: Gothic metal Track # 6 | ["Music", "Rock music", "Angry music"] | ["instrumental music", "death metal music", "retro death metal hits", "poor audio quality", "cymbals crashing", "fast tempo", "groovy rhythm", "guitar playing rhythm", "rock drumming", "energetic", "adrenaline rush", "passionate", "head banging", "mosh pit", "spirited", "percussive bass line"] | 1 | gCSShNsw-_A | 4013 |
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;