musiccaps_details (view)
5 rows where musiccaps_aspects contains "accordion" and musiccaps_aspects contains "male voice"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- accordion · 5 ✖
- male voice · 5 ✖
- acoustic drums 2
- violin 2
- acoustic guitar 1
- bass 1
- bass guitar 1
- double bass 1
- emotional song 1
- fast tempo 1
- folk music 1
- foreign language 1
- good mood 1
- higher register yodeling 1
- live performance 1
- lively 1
- low quality audio 1
- low quality recording 1
- mexican folk music 1
- moderate tempo 1
- pop song 1
- romantic mood 1
- rubab 1
- shakers 1
- shouting 1
- simple percussion 1
- slow tempo 1
- spanish pop 1
- string instrument 1
- upright/e-bass 1
- vibrant 1
- yodel/folkmusic 1
musiccaps_names (array) 8 ✖
- Music 4
- Accordion 2
- Blues 1
- Folk music 1
- Musical instrument 1
- Swing music 1
- Traditional 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 |
---|---|---|---|---|---|---|---|---|---|---|
Uzbek Classic Music | This folk song features a male voice singing the main melody in an emotional mood. This is accompanied by an accordion playing fills in the background. A violin plays a droning melody. There is no percussion in this song. This song can be played at a Central Asian classical concert. | 2008-01-24T15:19:53Z | TashChaynar | Bobomurod Hamdamov Ayrilma | ["Folk music", "Music"] | ["folk music", "rubab", "male voice", "slow tempo", "emotional song", "low quality audio", "violin", "accordion"] | 0 | -5f6hjZf9Yw | 12 | |
Marin Doru- Ramane masa saraca | This low quality recording features a male voice singing the main melody in a foreign language. This is accompanied by percussion playing a simple beat with a Latin feel. The bass is played on a double bass. The double bass plays a groovy bassline. Flute fills are played in the background. An accordion plays melodies in harmony with the voice. This song has romantic overtones. This song can be played at the end credits of a mafia romance movie. | 2011-04-20T14:52:21Z | Beto stylle | ["Traditional music", "Music", "Musical instrument", "Accordion"] | ["low quality recording", "pop song", "male voice", "foreign language", "accordion", "double bass", "violin"] | 0 | 2bCuw7U_Rac | 387 | ||
Landscapes and Music of Costa Rica | This Spanish pop song features a male voice singing the main melody. This is accompanied by percussion playing a Latin beat. A shaker or maracas plays a continuous rhythm. An accordion plays chords in the background. The bass plays the root note of the chords. This song can be played at a party. The mood of this song is romantic. | 2011-01-10T18:05:18Z | Heredia por Media Calle | Video of Costa Rica with diferent landscapes province by province. | ["Blues", "Music"] | ["spanish pop", "shakers", "simple percussion", "accordion", "male voice", "moderate tempo", "bass", "romantic mood"] | 0 | BdKiPR3kdjo | 1268 | |
Тирольские напевы / 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;