musiccaps_details (view)
3 rows where musiccaps_aspects contains "fast tempo", musiccaps_aspects contains "groovy rhythm" and musiccaps_aspects contains "poor audio quality"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- fast tempo · 3 ✖
- groovy rhythm · 3 ✖
- poor audio quality · 3 ✖
- instrumental music 2
- acoustic guitar 1
- adrenaline rush 1
- ambient street noises 1
- cheering sounds 1
- congregational music 1
- cymbals crashing 1
- death metal music 1
- devotional 1
- emotional 1
- energetic 1
- exciting 1
- fast harp passages 1
- fats harp playing 1
- folk music 1
- guitar playing rhythm 1
- harmonium player 1
- harmonium playing accompaniment 1
- harpist 1
- head banging 1
- high gain recording 1
- instrumental duet 1
- latin dance music 1
- latin folk music 1
- male singer 1
- mosh pit 1
- passionate 1
- people chanting 1
- people chapping 1
- percussive bass line 1
- punjabi music 1
- religious fervour 1
- religious song 1
- retro death metal hits 1
- rhythm guitar 1
- rock drumming 1
- romantic 1
- sikh music 1
- spirited 1
- tabla playing 1
- talented duo 1
- traditional instruments 1
- trance music 1
- youthful 1
musiccaps_names (array) 8 ✖
- Angry music 1
- Drum 1
- Harp 1
- Music 1
- Percussion 1
- Pizzicato 1
- Rock music 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bhai Kulwant Singh ji jalandhar Kaki Pind Wale AKJ | The song is primarily an instrumental with male voices chanting prayers. The song is fast tempo with tabla percussions and harmonium playing accompaniment. The song is spirited and devotional with a trance like feel to it. The audio quality is very poor. | 2007-11-06T08:23:39Z | Parminder Singh | #BhaiParminderSinghAustralia WATCH | LIKE | SUBSCRIBE | SHARE Bhai Kulwant Singh ji jalandhar Kaki Pind Wale AKJ kirtan at raensbai after amrit sanchaar. -~-~~-~~~-~~-~- Must watch: "Zafarnama ਜ਼ਫਰਨਾਮਾ" https://www.youtube.com/watch?v=sUQJ7JNGJYA -~-~~-~~~-~~-~- | ["Tabla", "Drum", "Percussion"] | ["tabla playing", "instrumental music", "groovy rhythm", "sikh music", "people chanting", "punjabi music", "trance music", "religious song", "devotional", "fast tempo", "trance music", "traditional instruments", "people chapping", "cheering sounds", "religious fervour", "poor audio quality", "harmonium playing accompaniment", "harmonium player", "congregational music"] | 1 | 4gEmWJCPZGo | 593 | |
El karma - abraham gonzalez | A male singer sings this Latin dance melody. The tempo is fast with a harpist playing fast passages with an acoustic guitar strumming rhythm. The song is emotional and energetic. The audio quality is bad with ambient Street noises and high gain. | 2014-10-31T22:33:27Z | Abraham Gonzalez | Abraham gonzalez y flavio vega esperemos le guste amigos dios los vendiga siempre...!! | ["Harp", "Pizzicato"] | ["harpist", "acoustic guitar", "fast harp passages", "talented duo", "instrumental duet", "rhythm guitar", "fast tempo", "folk music", "latin folk music", "fats harp playing", "exciting", "romantic", "poor audio quality", "high gain recording", "youthful", "latin folk music", "latin dance music", "groovy rhythm", "emotional", "ambient street noises", "male singer"] | 1 | A2pgKzeDRqg | 1062 | |
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;