musiccaps_details (view)
3 rows where musiccaps_aspects contains "keyboard accompaniment", musiccaps_aspects contains "youthful" and musiccaps_names contains "Angry music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- keyboard accompaniment · 3 ✖
- youthful · 3 ✖
- fast tempo 2
- adrenaline rush 1
- amplified instruments 1
- animated 1
- anthem 1
- ardent 1
- backup vocals 1
- bad audio quality 1
- bright bass lines 1
- bright electric guitar lead 1
- bright vocals 1
- buoyant 1
- cheer chant 1
- classic rock 1
- club music 1
- cymbals crashing 1
- dance music 1
- distorted guitar rhythm 1
- energetic 1
- energetic electric guitar harmony 1
- energetic vocal backup 1
- enthusiastic 1
- fans 1
- fast metal drumming 1
- female singer 1
- fervent 1
- foreign language introduction 1
- groovy bass lines 1
- groovy rhythm 1
- guitar lead 1
- heavy metal music 1
- infectious drumming 1
- insistent 1
- instrumental music 1
- male vocalist 1
- medium fast tempo 1
- passionate 1
- percussive bass line 1
- perky 1
- pop rock 1
- punchy 1
- rebellious 1
- recurring 1
- rhythmic chant 1
- song ending 1
- song fade 1
- spirited 1
- sports 1
- sports team 1
- teen pop 1
- vibrant 1
- vigorous drumming 1
- vivacious 1
musiccaps_names (array) 4 ✖
- Angry music · 3 ✖
- Music 3
- Heavy metal 1
- Rock music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
San Diego Chargers Theme Song!! | A male vocalist sings this energetic song. The tempo is medium fast with enthusiastic vocal backup, bright electric guitar lead and harmony, infectious drumming, keyboard accompaniment and groovy bass lines. The backup is a spirited recurring vocal riff. The song sounds like an anthem or cheer chant to show support for a team.it is passionate, enthusiastic, energetic, spirited, youthful and fervent. | 2009-04-01T01:48:11Z | justin gilliland | Chargers Theme Song BY P.O.D!!!!!!! | ["Music", "Angry music"] | ["male vocalist", "medium fast tempo", "cheer chant", "fervent", "ardent", "groovy bass lines", "sports team", "sports", "fans", "energetic vocal backup", "anthem", "infectious drumming", "bright electric guitar lead", "amplified instruments", "keyboard accompaniment", "rhythmic chant", "energetic", "youthful", "insistent", "recurring"] | 7 | QFhmzRkUx0I | 2606 | |
Hawaiian Roller Coaster Ride- Jump 5 (Lyrics) | A female vocalist sings this spirited pop song. The tempo is fast with vigorous drumming, animated electric guitar harmony, keyboard accompaniment and groovy bass lines along with backup vocals. The first bit of the song is sung in foreign language. The song is energetic, youthful, passionate, vibrant and vivacious with a dance groove. This song is Teen Pop/Pop Rock. | 2009-08-22T02:50:00Z | Javiix7 | lyrics this is one of my favorite songs | ["Music", "Angry music"] | ["female singer", "fast tempo", "vigorous drumming", "teen pop", "foreign language introduction", "vibrant", "vivacious", "teen pop", "dance music", "club music", "energetic electric guitar harmony", "bright bass lines", "bright vocals", "backup vocals", "animated", "youthful", "enthusiastic", "dance music", "perky", "punchy", "buoyant", "pop rock", "classic rock", "keyboard accompaniment"] | 7 | id5ibIqjRto | 4208 | |
W.A.S.P. - My Tortured Eyes LYRICS | The song is an instrumental. The tempo is fast with a fast metal drumming rhythm, complete with cymbal crashes, distorted guitar lead, guitar playing rhythm, and percussive bass line. The song is a death metal song ending with a bad audio quality. | 2011-08-19T16:13:10Z | nagito11 | ["Heavy metal", "Music", "Rock music", "Angry music"] | ["heavy metal music", "instrumental music", "fast metal drumming", "distorted guitar rhythm", "keyboard accompaniment", "instrumental music", "fast tempo", "groovy rhythm", "cymbals crashing", "song fade", "song ending", "passionate", "adrenaline rush", "spirited", "youthful", "rebellious", "bad audio quality", "guitar lead", "percussive bass line"] | 1 | nbb8vmfjHJs | 4563 |
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;