musiccaps_details (view)
2 rows where musiccaps_author = 9 and musiccaps_names = "["Flamenco", "Music"]"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 16 ✖
- acoustic guitar 2
- afro-cuban 1
- dance 1
- energetic 1
- flamenco 1
- folk 1
- instrumental 1
- latin dance 1
- latin percussion 1
- lively 1
- male vocals 1
- percussion 1
- repeating theme 1
- spanish 1
- upright bass 1
- vibrant 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LEGENDARY MUSICIANS OF OLD HAVANA Pt 3 | This is an afro-cuban folk music compilation. There are male vocals singing in an energetic manner. There are acoustic guitars playing the main themes while upright bass is used for the lower range. The rhythmic background is provided by a variety of latin percussive instruments. There is a vibrant atmosphere. Parts of this recording can be used in latin dance courses as accompaniment pieces. | 2007-08-30T02:04:47Z | chak bay Grande | MORE of Alma de Cuba with Angel Abreu singing Meneame la cuna and El Manisero | ["Flamenco", "Music"] | ["afro-cuban", "folk", "latin dance", "male vocals", "acoustic guitar", "upright bass", "latin percussion", "dance", "vibrant", "energetic", "lively"] | 9 | 6AC84nr6ckM | 732 | |
(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;