musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "background noises" and musiccaps_aspects contains "medium to uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic guitar · 2 ✖
- background noises · 2 ✖
- medium to uptempo · 2 ✖
- acoustic piano 1
- e-bass 1
- electric piano 1
- female voice singing 1
- flute 1
- male backing vocals 1
- male voice singing 1
- mid-range voice 1
- percussion 1
- pop 1
- sensitive 1
- sensual 1
musiccaps_names (array) 4 ✖
- Music 2
- /t/dd00003 1
- Sad music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Tiare Tahiti Hula Kaanapali, Maui | An acoustic drum is strumming chords while a percussion instrument is playing a bass sound along with an e-bass. A male choir is singing in the background while the female voice is singing the first melody. In the background you can hear voices. This song may be playing in a live performance. | 2009-04-14T04:32:37Z | Amrtvideo | Tiare Tahiti Hula is performed by the dancer Marie and the infectious singing sung by Alaka'i, "The Morning Goddess" of KPOA performed at the Royal Lahaina Resort Hotel in Kaanapali, Maui. | ["Music", "/t/dd00003"] | ["acoustic guitar", "e-bass", "female voice singing", "male backing vocals", "percussion", "background noises", "medium to uptempo", "sensual"] | 6 | C3o8pEsAu5U | 1323 | |
Teri Aahatein-Full Original Video Song-Ek Mein Aur Ekk Tu ft Imran Khan Kareena Kapoor | An acoustic piano is playing a melody along with a flute-sound and an acoustic guitar picking two notes repeatedly. Then the song breaks softly into a new part as the acoustic guitar and piano are fading out. In the background you can hear some insects chirping. Now an electric piano sound is playing a melody along with a male voice singing. His voice sounds sensitive. This song may be playing for a movie scene. | 2012-01-14T08:17:35Z | rfication rakesh | Ek Mein Aur Ekk Tu songs 2012 Teri Aahatein kareena Kapoor Imran Khan new bollywood songs 2012 2011 movies trailers karan johar | ["Singing", "Music", "Sad music"] | ["pop", "acoustic piano", "flute", "acoustic guitar", "electric piano", "male voice singing", "mid-range voice", "sensitive", "medium to uptempo", "background noises"] | 6 | lmrzR9cSMRY | 4419 |
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;