musiccaps_details (view)
2 rows where musiccaps_aspects contains "heartfelt" and musiccaps_aspects contains "youtube music video"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- heartfelt · 2 ✖
- youtube music video · 2 ✖
- amateur singer 1
- bad audio quality 1
- band audio quality 1
- bansuri 1
- devotional music 1
- emotional 1
- flute solo 1
- friendship 1
- fusion music 1
- healing 1
- hindustaani music 1
- home music video 1
- inspiring 1
- instrumental music 1
- keyboards accompaniment 1
- live audience 1
- live performance 1
- love song 1
- male singer 1
- meditational 1
- memdium tempo 1
- modern pop hits 1
- pop song 1
- pop song cover 1
- range of emotions 1
- romantic 1
- romantic passionate 1
- sitar accompaniment 1
- slow tempo 1
- slow tempo po 1
- song cover 1
- soulful 1
- tabla percussion 1
- touching 1
- traditional indian instruments 1
- ukulele accompaniment 1
- ukulele playing rhythm 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ukulele Tutorial #54 (Count On Me, Bruno Mars) | A male singer sings this popular song. The tempo is medium with an ukulele playing rhythm accompanying the male vocals with no other instrumentation. The song is emotional and inspiring. The audio quality is bad. | 2010-07-06T19:06:01Z | Krankthat22 | NEW WEBSITE is up and running! Check it out and let me know what you think!! Feedback is much appreciated! Thank me later. Click here now! http://tinyurl.com/Krankthat22 Em - 0432 C - 0003 Am - 2000 F - 2010 Dm - 2210 G - 0121 verse/chorus C Em Am G F bridge #1 Dm Em F G Bridge #2 ("a shoulder to cry on" part of lyrics) Dm G C G | ["Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["male singer", "ukulele accompaniment", "bad audio quality", "inspiring", "amateur singer", "ukulele playing rhythm", "memdium tempo", "song cover", "emotional", "love song", "romantic", "touching", "youtube music video", "friendship", "touching", "heartfelt", "pop song", "pop song cover", "modern pop hits", "band audio quality", "home music video"] | 1 | MpjN21Z93JY | 2302 | |
Classical Instrumental (Fusion) - Raag Madhuvanti - Ateetam - Tabla|Sitar|Flute|Keyboard | The song is an instrumental. The tempo is slow with an Indian flute or bansuri playing soulfully to the keyboard accompaniment, sitar accompaniment and a tabla player waiting to join in. The music is soulful and emotional. The audio quality is poor. | 2015-04-17T11:38:44Z | Geethanjali - Indian Classical Music | Madhuvanti Raaga - Madhuvanti is the name of a raga used in Indian classical music. It is a Hindustani music raga, which is reported to have been borrowed into Carnatic music, and is structurally similar to Multani. This Raag is based on Kalyan Thaat(Mode).It is a romantic raga based on the foundation, eternity and colors of love. Madhu literally means honey. It is a very sweet raga with a very simple philosophy of love and romance. Sounds of Traditions Past, Energies of Momentous Present, and Imaginations of Futures Beyond, the musical creations of ATEETAM. The music of India includes multiple varieties of folk music, pop, and Indian classical music. India's classical music tradition, including Hindustani music and Carnatic, has a history spanning millennia and developed over several eras. Music in India began as an integral part of socio-religious life. PERCUSSIONS - VENKY D C SITAR - B. SIVARAMAKRISHNA RAO FLUTE - SHAKTHIDHAR V R KEYBOARD, AUDIO MIXING & MASTERING - VARUN PRADEEP GUEST ARTISTS - ANWAR MANUEL ALAM, JYOTSNA SRIKANTH, MANJUNATH N S & ANIL C J | ["Wind instrument, woodwind instrument", "Flute"] | ["hindustaani music", "flute solo", "bansuri", "meditational", "devotional music", "fusion music", "slow tempo", "keyboards accompaniment", "tabla percussion", "instrumental music", "slow tempo po", "traditional indian instruments", "soulful", "romantic passionate", "range of emotions", "live performance", "live audience", "youtube music video", "healing", "heartfelt", "sitar accompaniment"] | 1 | rW5YKFsiWM8 | 4883 |
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;