musiccaps_details (view)
3 rows where musiccaps_aspects contains "male voice" and musiccaps_names contains "Accordion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- male voice · 3 ✖
- accordion 2
- accordion lesson 1
- acoustic drums 1
- acoustic guitar 1
- bass guitar 1
- double bass 1
- foreign language 1
- instructive speaking 1
- lesson recording 1
- live performance 1
- lively 1
- low quality recording 1
- mexican folk music 1
- poor quality 1
- pop song 1
- shouting 1
- spanish language 1
- vibrant 1
- violin 1
musiccaps_names (array) 4 ✖
- Accordion · 3 ✖
- Music 1
- Musical instrument 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | ||
SUEÑA INTOCABLE instruccional | This is the recording of an accordion lesson. There is a male voice describing the way a certain song is meant to be played on the accordion in the Spanish language. The quality of the recording is quite poor and there is a very frequent peak sound that crackles while the instructor is speaking. | 2012-07-06T02:57:22Z | Grupo Infiel Oficial | Hola amigos fans ue siguen a su camarada luis del grupo infiel aqui les traigo este instruccional de sueña que me lo pidio un camarada alex y toda la gente que se reporta que me brinda su apoyo para lo que en verdad me quieren apoyar asi como lo yo hago inscribanse a mi facebook y voten por mi grupo que estamos en concurso gracias su amigo luis http://www.facebook.com/#!/luisillo.perron y para votar por mi grupo aqui tomense un poco de tiempo no sean malos amigos http://app.getresponse.com/survey.html?survey_id=11559. LINK de la tercer BATALLA VOTEN por grupo INFIEL AMIGOS VAMOS EN PRIMER LUGAR VAMOS Atlanta demostremos el APOYO PURO INFIELLLL si tuviera 1 voto por cada uno d ustedes seguro GANAMOS ANIMO | ["Accordion"] | ["lesson recording", "accordion lesson", "poor quality", "male voice", "spanish language", "instructive speaking"] | 9 | ScAlKYCgHV0 | 2779 | |
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;