musiccaps_details (view)
2 rows where musiccaps_aspects contains "bass", musiccaps_aspects contains "female voice" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- bass · 2 ✖
- dance song 2
- female voice · 2 ✖
- moderate tempo 2
- club music 1
- congo 1
- cowbell 1
- percussion 1
- piano 1
- programmed percussion 1
- salsa song 1
- saxophone 1
- synth backing 1
- trombone 1
- trumpets 1
- uptempo 1
musiccaps_names (array) 3 ✖
- Music 2
- Music of Latin America · 2 ✖
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ain't Nobody (Salsa Version)-Alex Wilson | This salsa song features a female voice singing the main melody. This is accompanied by percussion on a drum kit as well as on a congo. The congo gives this song the salsa feel. The drum kit plays the cowbell and high pitched snare drum to add more of the salsa vibe. The bass plays groovy fills. Trumpets, trombones and saxophones play fills in between lines. They play in harmony. A piano plays jazzy chords in the background. This song can be played in a dance club for a salsa night. | 2010-05-06T09:50:53Z | tsiostini | ["Music", "Music of Latin America", "Salsa music"] | ["salsa song", "female voice", "percussion", "trumpets", "congo", "cowbell", "trombone", "saxophone", "dance song", "bass", "piano", "moderate tempo"] | 0 | gMgN50wSnNc | 4025 | ||
Natura apresenta MULHERES | This dance song features a female voice singing the main melody. This is accompanied by programmed percussion playing a simple beat which starts off with a drum roll. The bass plays the root notes of the chords. A synth plays chords in the background. This song has an upbeat mood. This song can be played in a club. | 2016-04-26T17:50:24Z | Maquiagem Natura | Convidamos a Maíra Freitas para reinterpretar a música mais famosa do seu pai - o Martinho da Vila. O resultado? Uma homenagem a todas as diversas e possíveis belezas, cores, estilos e muitos amores. Natura apresenta MULHERES. #AdoroMaquiagem #MULHERES #VivaSuaBelezaViva | ["Music", "Music of Latin America"] | ["dance song", "female voice", "moderate tempo", "programmed percussion", "bass", "synth backing", "uptempo", "club music"] | 0 | x1KyLxsnJY0 | 5299 |
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;