musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate male vocal", musiccaps_aspects contains "shimmering hi hats" and musiccaps_names contains "Music of Asia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- groovy bass 3
- passionate male vocal · 3 ✖
- shimmering hi hats · 3 ✖
- harmonizing background vocals 2
- low quality 2
- passionate 2
- claps 1
- electric guitar chords 1
- emotional 1
- energetic 1
- exciting 1
- groovy 1
- mellow piano melody 1
- people cheering sounds 1
- pop 1
- punchy kick 1
- punchy snare 1
- snappy rimshot 1
- snare roll 1
- soul 1
- tinny snare 1
- wide electric guitar melody 1
- wide sustained strings melody 1
- wide wooden percussions 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chemong ding chu - Janglal Khongsai | The Soul song features a passionate male vocal singing over shimmering hi hats and shakers, groovy bass, widely spread wooden percussions, punchy kick and snare hits, wide sustained strings melody and mellow piano melody. It sounds emotional and passionate. | 2015-11-12T17:56:14Z | Bombiel Media | Senorita 3: Thadou-Kuki Visual Album M.Lien Thugs Production | ["Music of Asia", "Christian music", "Music", "Song"] | ["soul", "passionate male vocal", "wide wooden percussions", "punchy kick", "groovy bass", "wide sustained strings melody", "mellow piano melody", "shimmering hi hats", "punchy snare", "emotional", "passionate"] | 4 | BiQik0xsWxk | 1279 | |
365 Days- Leon Thomas III Ft. Victoria Justice W/Lyrics | The low quality recording features a pop song that consists of a passionate male vocal, alongside harmonizing background vocals, singing over people cheering sounds, shimmering hi hats, claps, snare rolls, groovy bass and wide electric guitar melody. It sounds energetic and exciting. | 2011-10-09T01:46:15Z | stephylove33 | Just in time for October!! Think Pink For Breast Cancer =) XOXO | ["Music of Asia"] | ["low quality", "pop", "harmonizing background vocals", "people cheering sounds", "claps", "shimmering hi hats", "snare roll", "passionate male vocal", "groovy bass", "wide electric guitar melody", "energetic", "exciting"] | 4 | JXS5eW7g4HY | 2016 | |
A Love I Can Feel Riddim (26 songs) - Beres, Sanchez, Frankie Paul, Busy Signal, etc. | The low quality recording features a passionate male vocal, alongside harmonizing background vocals, singing over tinny snares, snappy rimshots, shimmering hi hats, groovy bass and electric guitar chords. It sounds groovy and passionate. | 2012-05-24T15:52:14Z | DJ Riddim | Timeless lover's rock riddim Facebook – https://www.facebook.com/DJRiddimNYC?ref=hl Instagram - http://instagram.com/djriddim_ Twitter – https://twitter.com/DJRiddim_ | ["Music of Asia", "Funk", "Music", "Pop music", "Ska"] | ["low quality", "passionate male vocal", "harmonizing background vocals", "tinny snare", "shimmering hi hats", "snappy rimshot", "groovy bass", "electric guitar chords", "groovy", "passionate"] | 4 | c-85TtcfVSI | 3672 |
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;