musiccaps_details (view)
2 rows where musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- slow tempo · 2 ✖
- traditional · 2 ✖
- amateur recording 1
- ambient crowd noise 1
- bagpipes 1
- brass instruments harmony 1
- child singer 1
- cowboys 1
- cymbals crashing 1
- emotional 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin music 1
- passionate 1
- people talking 1
- romantic 1
- school concert 1
- spirited 1
- steady bass line 1
- trumpets blaring 1
- yodelling music 1
musiccaps_names (array) 6 ✖
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 | |
gaida gajda goat goat bagpipes Na Stojan Gosti mu dojdoa lele гајда гайда Risto Todoroski | Someone is playing a fast melody on bagpipes in the lower higher register accompanied by a base drone sound. This song may be playing during a traditional ceremony or event. | 2009-03-21T16:24:34Z | Risto Todoroski | Goat Bagipes (gaida) available from Risto. sirulsko@gmail.com. The bag with the goat's head is unusual in the Balkans - usually the leather is turned outward and there is no head, but Risto would play this type of gaida on special occasions like a wedding. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "bagpipes", "slow tempo", "traditional"] | 6 | f1NV9qTjOv8 | 3915 |
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;