musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass lines", musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "medium fast tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 40 ✖
- groovy bass lines · 2 ✖
- keyboard accompaniment · 2 ✖
- medium fast tempo · 2 ✖
- amplified instruments 1
- anthem 1
- ardent 1
- bright electric guitar lead 1
- catchy riff 1
- chant 1
- cheer chant 1
- contemporary 1
- devotional 1
- energetic 1
- energetic vocal backup 1
- enigmatic 1
- fans 1
- female singer 1
- fervent 1
- flute melody 1
- hypnotic 1
- indian classical 1
- indian god 1
- infectious drumming 1
- insistent 1
- male vocalist 1
- meditative 1
- melodious 1
- psychedelic harmony 1
- puja 1
- recurring 1
- rhythmic chant 1
- small hand cymbals 1
- sports 1
- sports team 1
- steel pan percussion 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- trance 1
- worship 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 2
- Angry music 1
- Folk music 1
- Mantra 1
- Middle Eastern music 1
- Song 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 | |
Maha Mantra Hare Krishna | A female vocalist sings this pleasant chant. The song is medium fast tempo with groovy basslines, mellifluous flute, steel pan beat,small hand cymbals and synthesiser arrangement. The song is sweet, melodic, hypnotic, enthralling, enigmatic, trance-like, trippy and psychedelic. This song is a contemporary indian worship song. | 2010-06-28T19:06:46Z | Nettan Von Pavarga | Hare Krishna mantra sung by Krishna Premi Krishna Premi (ACBSP) from her album "Nectar of the Holy Name". | ["Mantra", "Folk music", "Music", "Middle Eastern music", "Song"] | ["female singer", "medium fast tempo", "enigmatic", "hypnotic", "trance", "contemporary", "synthesiser arrangements", "flute melody", "small hand cymbals", "groovy bass lines", "keyboard accompaniment", "steel pan percussion", "synthesiser arrangement", "psychedelic harmony", "chant", "meditative", "indian classical", "puja", "devotional", "catchy riff", "melodious", "contemporary", "indian god", "worship"] | 7 | tdrz4EkIsow | 5055 |
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;