musiccaps_details (view)
2 rows where musiccaps_aspects contains "vibrant" and musiccaps_names = "["Accordion"]"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Prieta Linda "Adrian Duran y Fred Mancilla" | This song is a lively instrumental. The tempo is medium fast with an enthusiastic accordion harmony and acoustic guitar accompaniment. The music is spirited, melodious, warm, cheerful, happy, vivacious and colourful. This music is a Folk song instrumental. | 2011-07-20T01:59:52Z | chikiturris1 | para contractiones # (714) 579-9074 Chubbz # (909) 277- 8651 Nanas | ["Accordion"] | ["instrumental", "medium fast tempo", "acordion harmony", "acoustic guitar accompaniment", "lively", "cheerful", "happy", "warm", "enthusiastic", "energetic", "vibrant", "folk music"] | 7 | 6dFCMXNlmzQ | 773 | |
EL ORIGINAL DE LA SIERRA "LA DESVELADA" | This is a Mexican folk music piece being performed live. There is male voice shouting at the end of the piece. The accordion is playing the main melody. The acoustic guitar and the bass guitar are playing in the background. The rhythmic background consists of a latin acoustic drum beat. The atmosphere is lively. This piece could be playing in the background at a Mexican restaurant. | 2009-10-14T02:38:05Z | FRONTERAVISUAL09 | MUSICAL EN BILLBOARD | ["Accordion"] | ["mexican folk music", "live performance", "male voice", "shouting", "accordion", "bass guitar", "acoustic guitar", "acoustic drums", "lively", "vibrant"] | 9 | XOsHEjo-RSg | 3181 |
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;