musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy bass line" and musiccaps_names contains "Maraca"
This data as json, CSV (advanced)
musiccaps_aspects (array) 56 ✖
- groovy bass line · 3 ✖
- poor audio quality 3
- groovy 2
- groovy bas slime 2
- male singer 2
- medium tempo 2
- amateur music mix 1
- ambient noises 1
- backup singers 1
- backups singers 1
- cheerful 1
- choppy music 1
- choral harmony 1
- christian contemporary music 1
- conversations 1
- crooning 1
- crowd noise 1
- cumbria rhythm 1
- cymbals crashing 1
- disconcerting music 1
- dj 1
- emotional 1
- gospel music 1
- guitar rhythm 1
- high gain volume 1
- hissing tones 1
- home video 1
- inspiring 1
- keyboard accompaniment 1
- kick drums 1
- kids dancing 1
- latin band 1
- latin dance band 1
- latin folk song 1
- latin male vocals 1
- latin percussions 1
- latin rhythm 1
- live performance 1
- mismatched tempos 1
- noise 1
- noisy crowds 1
- passionate 1
- passionately 1
- pop song 1
- pop superhit 1
- praise and worship 1
- remix 1
- school dance program 1
- school program 1
- song intro 1
- spirited 1
- steady drum rhythm 1
- steady drumming rhythm 1
- tambourine percussions 1
- techno dance rhythm 1
- techno dance song 1
musiccaps_names (array) 3 ✖
- Maraca · 3 ✖
- Music 3
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maracas dance of h.bautista elem school | A male singer sings this groovy melody. The song is a techno dance song with a groovy bass line, strong drumming rhythm and a keyboard accompaniment. The song is so groovy and serves as a dance track for the dancing children. The audio quality is very poor with high gains and hissing noise. | 2013-10-27T02:32:22Z | Alma Flores | Teacher's day | ["Music", "Maraca"] | ["live performance", "poor audio quality", "ambient noises", "school dance program", "crowd noise", "high gain volume", "hissing tones", "medium tempo", "techno dance song", "male singer", "groovy bass line", "techno dance rhythm", "keyboard accompaniment", "kids dancing", "noisy crowds", "home video", "school program", "noise"] | 1 | -1UWSisR2zo | 7 | |
Inka Gold-Sanjuanito Irlandes | Male singers engage in a conversation at the beginning of the song. The song is medium tempo with a guitar playing rhythm, steady drumming rhythm, tambourine percussion, kick drum percussion and keyboard accompaniment. The song is romantic and spirited. The audio quality is poor. | 2008-09-18T16:48:28Z | toml71 | This is a local Native American Band where I live. They call themselves Inka Gold. They make amazing music combining the guitar, drums and flute. I decided to make a video with the music called Sanjuanito Irlandes using an Eagle in flight. For more information on them check out their website...http://inkagoldmusic.com/ | ["Music of Africa", "Music", "Maraca"] | ["latin male vocals", "backup singers", "song intro", "groovy bass line", "medium tempo", "poor audio quality", "kick drums", "latin band", "latin dance band", "gospel music", "praise and worship", "christian contemporary music", "tambourine percussions", "steady drum rhythm", "groovy bas slime", "latin folk song", "latin folk song", "conversations", "passionately", "spirited", "groovy", "guitar rhythm"] | 1 | 4T_5clu_0OM | 574 | |
Happy Version cumbia - Pharrell Williams (Tato Dj) | A male singer sings this pop melody with back up singers in choral harmony. The song is medium tempo with a superimposed Latin Cumbia rhythm, which creates a discombobulated rhythm structure. The song audio quality is very poor. | 2014-03-14T22:04:39Z | Viktor Radchenko | Tato DJ Twitter: https://twitter.com/Tatoarata Original song by Pharrell Williams | ["Music", "Maraca"] | ["cumbria rhythm", "pop song", "choppy music", "latin rhythm", "disconcerting music", "cheerful", "pop superhit", "emotional", "inspiring", "groovy", "passionate", "male singer", "backups singers", "crooning", "choral harmony", "groovy bas slime", "steady drumming rhythm", "poor audio quality", "remix", "dj", "cymbals crashing", "groovy bass line", "latin percussions", "mismatched tempos", "amateur music mix"] | 1 | C6roSYqchkk | 1331 |
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;