musiccaps_details (view)
1 row where musiccaps_aspects contains "oriental/pop/ballad", musiccaps_aspects contains "plucked string instrument" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jerusalem Israel Song - Shira Chadasha Boys Choir Music Video | This song contains a piano playing a melody along with a digital flute and a plucked string instrument. An e-bass is playing a simple line with long notes along with acoustic drums being in the background. This song may be playing in a landscape video. | 2008-03-03T19:43:55Z | ShiraChadasha2 | The Shira Chadasha Boys Choir are about to release their second album The name of the album is Arayvim zeh l'zeh. Composed and conducted by Nachman Seltzer, arranged mostly by Jeff Horvitch with one song by Leib Yaacov Rigler. The album has twelve new songs and old songs from Dvekus composed by Abie Rotenberg. The thirteenth song is entitled Yizkarem and was composed by Nachman Seltzer in the memory of the boys from Mercaz Harav, on the day after the attack. With star soloists Yaacov Leebhoff, Moishe Bell and Simcha Levinstein this album is sure to be a hit. | ["Background music", "Music"] | ["oriental/pop/ballad", "keyboard flute", "acoustic drums", "piano", "plucked string instrument", "e-bass", "slow tempo", "relaxing"] | 6 | 8NIxqHJrL68 | 918 |
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;