musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "percussion" and musiccaps_aspects contains "rock and roll"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- fast tempo 2
- instrumental · 2 ✖
- percussion · 2 ✖
- rock and roll · 2 ✖
- animated 1
- bass drums 1
- brass band 1
- bright drumming 1
- dance groove 1
- emphatic percussion 1
- energetic 1
- enthusiastic 1
- lead guitar 1
- lively trumpets 1
- low quality audio 1
- no voices 1
- snare 1
- spirited 1
- swing 1
- tambourine beats 1
- trumpet harmony 1
musiccaps_names (array) 7 ✖
- Music 2
- Music of Asia 1
- Musical instrument 1
- Percussion 1
- Pop music 1
- Pulse 1
- Timpani 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
HD 120515 Girls' Generation SNSD TaeTiSeo TTS - Twinkle @ Show Champion | This music is an energetic Rock and Roll instrumental. The tempo is fast with animated, infectious drumming, lively trumpets and tambourine beats. The music is upbeat, pulsating, thumping, vivacious, bright, with a perky dance groove. This music is Rock and Roll. | 2012-05-18T01:47:44Z | Ky Pham | HD 120515 Girls' Generation SNSD TaeTiSeo TTS - Twinkle @ Show Champion Tiffany, Taeyeon, Seohyun - TAETISEO! 120503 120504 120505 120506 120510 120511 120512 120513 120517 120518 120519 120520 120521 120524 120525 120526 120527 120531 120601 120602 120603 120607 120608 120609 120619 120614 120615 120616 120617 120621 120622 120623 120624 | ["Timpani", "Music of Asia", "Music"] | ["instrumental", "fast tempo", "bright drumming", "dance groove", "animated", "energetic", "percussion", "emphatic percussion", "lively trumpets", "bass drums", "tambourine beats", "snare", "trumpet harmony", "brass band", "spirited", "animated", "enthusiastic", "swing", "rock and roll"] | 7 | OH2SQhJqZDg | 2420 | |
Masonics - Outside Looking In | This low quality audio features an electric guitar playing a solo. The sounds of the instruments are not clear due to the low audio quality. The percussion plays a fast beat in the background. There are no voices in this song. This song can be played in a car chase sequence in a movie. | 2006-12-12T13:44:19Z | beatsvillerecords | The Masonics perform "I'm on the Outside Looking In" at "The Cluny" in Newcastle-Upon-Tyne. | ["Music", "Musical instrument", "Pop music", "Pulse", "Percussion"] | ["rock and roll", "low quality audio", "percussion", "lead guitar", "no voices", "instrumental", "fast tempo"] | 0 | YqAsph_ouRM | 3314 |
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;