musiccaps_details (view)
1 row where musiccaps_aspects contains "accordion music", musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "moderate tempo" and musiccaps_aspects contains "tuba"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ansambel Lojze Slak / Dezelica sonca in grozdja. | This waltz song features accordions playing in harmony. Male voices sing the main melody. The voices sing in harmony. When the voices start to sing, the accordions play the same melody as the voices. The bass is played on a tuba. An acoustic guitar strums chords. A tambourine plays the part of the percussion. There are trumpets and clarinets playing in this song. This is a folk song. The mood of this song is happy. | 2012-08-09T23:11:27Z | Johan Hopman | Lojzeta Slaka Was A Great Diatonic Button Accordion Player From Slovenia. Born: 23 July 1932 In Jordankal,Near Mirna Pec Died: 29 September 2011 In Ljubliana. Lojzeta Was Burried In Sentvid,He Was 79 Jears Old. | ["Accordion"] | ["accordion music", "tuba", "acoustic guitar", "male voices", "waltz song", "moderate tempo"] | 0 | zj2G-KVw4N4 | 5506 |
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;