musiccaps_details (view)
2 rows where musiccaps_aspects contains "accordion", musiccaps_aspects contains "acoustic drums" and musiccaps_aspects contains "male voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- accordion · 2 ✖
- acoustic drums · 2 ✖
- male voice · 2 ✖
- acoustic guitar 1
- bass guitar 1
- fast tempo 1
- good mood 1
- higher register yodeling 1
- live performance 1
- lively 1
- mexican folk music 1
- shouting 1
- string instrument 1
- upright/e-bass 1
- vibrant 1
- yodel/folkmusic 1
musiccaps_names (array) 4 ✖
- Accordion 1
- Music 1
- Swing music 1
- Yodeling 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Тирольские напевы / JODELN / Йодль | An accordion is playing short notes on the offbeat along with soft snare hits being played with brushes. A bass is playing straight, changing the note on every beat. Another accordion is answering the yodeling male voice with a short melody. The male voice is loud, clear and sings a melody in the higher register. A guitar-like instrument is strumming chords in the higher register. The instruments are panned to the left and right side of the speakers. This song may be playing at a concert in the countryside. | 2013-04-27T14:32:58Z | Prometheus | ["Swing music", "Yodeling", "Music"] | ["yodel/folkmusic", "accordion", "acoustic drums", "upright/e-bass", "string instrument", "male voice", "higher register yodeling", "fast tempo", "good mood"] | 6 | IyJ3a5uuCOs | 1956 | ||
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;