musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic guitar", musiccaps_aspects contains "repeating theme" and "youtube_published" is on date 2008-10-02
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 |
---|---|---|---|---|---|---|---|---|---|---|
(Full) Oogie Boogie's Song - Rodrigo y Gabriela [HQ] | This music is a flamenco piece. There are two acoustic guitars, one playing the leading arpeggio melody and the other creating the rhythmic background by strumming the chords. The characteristics of the song makes it clear that it is influenced by Spanish music. It could be used in a thriller movie soundtrack or as a flamenco dance accompaniment piece for dancing courses. | 2008-10-02T07:06:54Z | HSMRocksMedia | Nightmare Revisited Oogie Boogie's Song - Rodrigo y Gabriela No copyright infringement intended | ["Flamenco", "Music"] | ["flamenco", "acoustic guitar", "percussion", "instrumental", "repeating theme", "spanish"] | 9 | fow1TC_MpHs | 3977 |
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;