musiccaps_details (view)
4 rows where musiccaps_aspects contains "poor audio quality", musiccaps_aspects contains "spirited" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 59 ✖
- poor audio quality · 4 ✖
- spirited · 4 ✖
- home recording 2
- instrumental 2
- adrenaline rush 1
- amplified guitar 1
- asian pop 1
- banjo 1
- banjo lead 1
- bluegrass 1
- boomy 1
- country 1
- country music 1
- dance rhythm 1
- death metal 1
- death metal music 1
- distorted guitar rhythm 1
- electric guitar lead 1
- energetic 1
- enthusiastic 1
- fast tempo 1
- female singers 1
- folk 1
- folk song 1
- groovy rhythm 1
- guitar playing rhythm 1
- hard rock 1
- high gain limits 1
- high pitched sounds 1
- lively 1
- long sustained vocals 1
- loud electric guitar feedback 1
- male singer 1
- medium tempo 1
- melodious 1
- metal 1
- mic feedback 1
- mic feedback tones 1
- muddled audio 1
- muddy 1
- muffled sound 1
- no accompaniment 1
- passionate 1
- regional music 1
- rock 1
- screaming vocals 1
- sonic power 1
- steady drumming rhythm 1
- string instrument 1
- stringed instrument 1
- strong bas slide 1
- strong metal drumming 1
- techno dance pop 1
- trance music vibes 1
- vigorous 1
- violin harmony 1
- vocal harmony 1
- world music 1
- youthful 1
musiccaps_names (array) 11 ✖
- Music 4
- Angry music 1
- Banjo 1
- Bass guitar 1
- Bluegrass 1
- Distortion 1
- Effects unit 1
- Electric guitar 1
- Heavy metal 1
- Tapping (guitar technique) 1
- Zing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DiMarzio Crunch Lab and LiquiFire Drive Sound Test (check up with an Ibanez S570B) | This music is an electric guitar instrumental Rock. The tempo is medium with an electric guitar lead. The music is loud and boomy with an intense riff. The audio quality is inferior so the sound is muffled and muddy. The music however is energetic, youthful, spirited and enthusiastic. | 2010-12-17T12:36:42Z | darkcashyz | ["Bass guitar", "Tapping (guitar technique)", "Effects unit", "Electric guitar", "Heavy metal", "Music", "Distortion"] | ["instrumental", "amplified guitar", "youthful", "spirited", "sonic power", "enthusiastic", "muddy", "muffled sound", "medium tempo", "loud electric guitar feedback", "vigorous", "poor audio quality", "boomy", "electric guitar lead", "string instrument", "rock", "metal", "hard rock", "youthful", "enthusiastic", "muddled audio", "home recording"] | 7 | 6ayVxYbKBe0 | 769 | ||
cluck old hen | This music clip is a Lively Banjo instrumental. The tempo is fast with a spirited Banjo lead harmony. The music is simple, cheerful, happy, festive, upbeat and vivacious. The audio is not very clear as it is a home recording. The music has a country or folk song vibe. | 2009-06-29T15:04:18Z | janepc123 | Played on my newly acquired John Grey open back courtesy of the generosity of Joemac | ["Banjo", "Music", "Bluegrass"] | ["instrumental", "fast tempo", "lively", "spirited", "country music", "folk song", "regional music", "banjo", "banjo lead", "no accompaniment", "world music", "melodious", "poor audio quality", "home recording", "stringed instrument", "country", "bluegrass", "folk", "high pitched sounds"] | 7 | R1RGIgC-xKw | 2661 | |
[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 | |
Seether Remedy lyrics video | A male singer sings this screaming metal vocal. The song is medium tempo with strong metal drumming, guitar rhythm, groovy bass line and mic feedback tone.The song is energetic and an adrenaline rush. The song has poor audio quality. | 2008-05-26T01:14:13Z | icemaster377 | DO NOT POST CORRECTIONS TO THESE LYRICS, THE LYRICS *ARE* CORRECT I CHECKED THEM MANY TIMES this is the longer version which is 3:30 instead of 2:46, so it has an extra verse copyright 2005, No copyright infringement intended. buy this song and more here: http://www.seether.com/dashboard/store.asp Thanks To All Who Love This Vid lyrics: (for copying and pasting if you so choose.) Throw your dollar bills and leave your thrills all here with me And speak, but don't pretend I won't defend you anymore you see It aches in every bone, I'll die alone, but not for you My eyes don't need to see that ugly thing, I know it's me you fear If you want me hold me back! Frail! The skin is dry and pale! The pain will never fail! And so we go back to the remedy! Clip! The wings that get you high! Just leave them where they lie! And tell yourself, "You'll be the death of me" I don't need a friend, I need to mend so far away So come sit by the fire and play a while, but you can't stay too long It aches in every bone, I'll die alone, but not for pleasure I see my heart explode; it's been eroded by the weather here If you want me hold me back! Frail! The skin is dry and pale! The pain will never fail! And so we go back to the remedy! Clip! The wings that get you high! Just leave them where they lie! And tell yourself, "You'll be the death of me" Frail! The skin is dry and pale! The pain will never fail! And so we go back to the remedy! Clip! The wings that get you high! Just leave them where they lie! And tell yourself, "You'll be the death of me" Hold your eyes closed, take me in Hold your eyes closed, take me in (backround: Yeah,Yeah,Yeah,) If you want me hold me back! Frail! The skin is dry and pale! The pain will never fail! And so we go back to the remedy! Clip! The wings that get you high! Just leave them where they lie! And tell yourself, "You'll be the death of me" Frail! The skin is dry and pale! The pain will never fail! And so we go back to the remedy! Clip! The wings that get you high! Just leave them where they … | ["Music", "Angry music"] | ["male singer", "screaming vocals", "death metal music", "distorted guitar rhythm", "death metal", "mic feedback", "long sustained vocals", "poor audio quality", "strong metal drumming", "guitar playing rhythm", "mic feedback tones", "distorted guitar rhythm", "energetic", "spirited", "adrenaline rush"] | 7 | bTVl2GeNfqI | 3627 |
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;