musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy bass line" and musiccaps_names contains "Bowed string instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- emotional 2
- groovy bass line · 2 ✖
- medium tempo 2
- adore you 1
- ambient crowd noises 1
- bengali pop song 1
- cheerful 1
- clapping rhythm 1
- couples dan 1
- dance music 1
- family gatherings 1
- festive spirit 1
- folk dance music 1
- groovy music 1
- harpist 1
- indian music 1
- indian pop song 1
- instrumental duo 1
- instrumental music 1
- love anthem 1
- madly in love 1
- male singer 1
- message of kindness 1
- passionate 1
- people talking 1
- poor audio quality 1
- positive 1
- private music video 1
- romantic 1
- sentimental 1
- south american folk music 1
- spirited 1
- steady drumming rhythm 1
- tambourine percussion 1
- togetherness 1
- traditional custom dance 1
- ukulele accompaniment 1
- violinist 1
musiccaps_names (array) 8 ✖
- Bowed string instrument · 2 ✖
- Harp 1
- Music 1
- Musical instrument 1
- Pizzicato 1
- Plucked string instrument 1
- Ukulele 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PARARCA - OCT - 2013 - ARPA Y VIOLIN (A) | The song is instrumental. The tempo is medium with a harpist playing a bass line accompanying a violist. The song is folk-like with a dance rhythm. The audio quality is poor with ambient crowd noise. | 2013-11-01T18:51:07Z | Johnny Torres | ["Harp", "Violin, fiddle", "Pizzicato", "Bowed string instrument"] | ["harpist", "violinist", "dance music", "groovy bass line", "instrumental music", "couples dan", "family gatherings", "poor audio quality", "romantic", "south american folk music", "folk dance music", "instrumental duo", "people talking", "ambient crowd noises", "medium tempo", "sentimental", "emotional", "cheerful", "positive", "festive spirit", "togetherness", "traditional custom dance"] | 1 | 8DQbnR7hwpc | 904 | ||
Abar (আবার) Ukulele version by - Rafa | A male singer sings this delightful melody. The song is medium tempo with a ukulele accompaniment, steady drumming rhythm with various percussions like clapping and tambourine along with a keyboard accompaniment. The song is emotional and groovy. The song is a local Indian language pop song, most probably a Bengali pop song. | 2013-12-30T22:12:20Z | AvoidRafa | This song of mine is also available in Aurthohin's album Aushomapto 2. But that version is a whole lot heavier than this. This is my way of seeing into this piece of tune. Thanks a million to Bassbaba for writing the amazing words that made this song so positive. (Unlike me :P) Thanks to Nabil Khan for the insane video he pulled in just half an hour of shoot and one night of editing. I am very pleased to present you with this video. There will be more soon :) Here's the link for the song https://soundcloud.com/avoidraef/abar-ukulele-version | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument", "Bowed string instrument"] | ["male singer", "indian music", "ukulele accompaniment", "bengali pop song", "emotional", "spirited", "message of kindness", "passionate", "love anthem", "madly in love", "adore you", "medium tempo", "groovy music", "tambourine percussion", "steady drumming rhythm", "clapping rhythm", "groovy bass line", "indian pop song", "private music video"] | 1 | x1x54MgStxQ | 5301 |
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;