musiccaps_details (view)
2 rows where musiccaps_aspects contains "latin music" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 47 ✖
- latin music · 2 ✖
- slow tempo · 2 ✖
- ambient crowd noise 1
- ancient lineage instrument 1
- brass instruments harmony 1
- buzzing sound 1
- calming 1
- catholic prayer 1
- catholic salutation 1
- celestial 1
- child singer 1
- classical music 1
- cowboys 1
- cymbals crashing 1
- dreamy 1
- dulcet 1
- elegy 1
- emotional 1
- enchanting 1
- enthralling 1
- falsetto 1
- female harpist 1
- female singer 1
- harp 1
- high notes 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin song 1
- meditative 1
- melodic 1
- mystical 1
- oldest instrument 1
- passionate 1
- people talking 1
- plucking 1
- resonator 1
- romantic 1
- school concert 1
- serene 1
- soprano 1
- spirited 1
- steady bass line 1
- traditional 1
- trumpets blaring 1
- western classical 1
- yodelling music 1
musiccaps_names (array) 5 ✖
- Music 2
- Musical instrument 1
- Opera 1
- Singing 1
- Vocal music 1
youtube_published (date) 2 ✖
- 2006-08-09 1
- 2009-12-04 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sebastien De La Cruz, EL CHARRO DE ORO, EL PASTOR | A child singer sings this passionate Latin melody. The song is slow tempo with steady drumming, tambourine percussions, a strong bass line and brass instruments playing countermelody. The song is spirited and passionate. The song has poor audio quality and has ambient crowd noises. | 2009-12-04T04:56:07Z | Juan De La Cruz | MARIACHI VARGAS EXTRAVAGANZA 2009 EL PASTOR, 7YR OLD WOW, THIRD PLACE VOCAL FINALIST | ["Singing", "Music", "Musical instrument", "Vocal music"] | ["child singer", "latin music", "ambient crowd noise", "steady bass line", "cymbals crashing", "people talking", "trumpets blaring", "school concert", "latin folk music", "latin folk music", "traditional", "cowboys", "latin country music", "yodelling music", "spirited", "passionate", "romantic", "emotional", "brass instruments harmony", "slow tempo", "latin brass band"] | 1 | 6C0HoQe4Y-Y | 734 | |
Ave Maria by Schubert, Soprano and harpist Marsha Long | A female vocalist sings this melodious harmony. The tempo is slow with a dulcet Harp accompaniment . The song is soft, mellow, meditative, angelic, celestial,mystical, dreamy and mellifluous. This song is a Catholic prayer or salutation. | 2006-08-09T21:52:26Z | cherubofmusic | Ave Maria by Schubert performed by soprano and harpist Marsha Long | ["Music", "Opera"] | ["female singer", "slow tempo", "dreamy", "meditative", "calming", "dulcet", "high notes", "soprano", "falsetto", "buzzing sound", "harp", "female harpist", "plucking", "melodic", "celestial", "enchanting", "mystical", "enthralling", "ancient lineage instrument", "classical music", "western classical", "resonator", "oldest instrument", "latin song", "latin music", "elegy", "catholic prayer", "catholic salutation", "serene", "calming"] | 7 | ByOqw8M2U-Q | 1310 |
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;