musiccaps_details (view)
3 rows where musiccaps_aspects contains "traditional" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- traditional · 3 ✖
- emotional 2
- low quality 2
- passionate 2
- passionate woodwind melody 2
- acoustic guitar chords 1
- ambient crowd noise 1
- brass instruments harmony 1
- child singer 1
- cowboys 1
- cymbals crashing 1
- dissonant string melody 1
- hypnotic 1
- joyful 1
- latin brass band 1
- latin country music 1
- latin folk music 1
- latin music 1
- mono 1
- noisy 1
- people talking 1
- romantic 1
- school concert 1
- slow tempo 1
- soulful 1
- spirited 1
- steady bass line 1
- trumpets blaring 1
- weird 1
- wide sustained strings 1
- wooden percussive elements 1
- yodelling music 1
musiccaps_names (array) 8 ✖
- Music 3
- Musical instrument · 3 ✖
- Clarinet 1
- Jazz 1
- Singing 1
- Traditional music 1
- Vocal music 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Kamil - Azerbaycan teraneleri | The low quality recording features a traditional song that consists of a passionate woodwind melody played over wooden percussive elements. It sounds soulful, passionate and emotional, even though the recording is in mono and noisy. | 2008-12-07T05:51:30Z | gunazyayim | Kamil Azerbaycan treraneleri | ["Clarinet", "Traditional music", "Music", "Musical instrument", "Wind instrument, woodwind instrument"] | ["low quality", "traditional", "noisy", "mono", "passionate woodwind melody", "wooden percussive elements", "soulful", "passionate", "emotional"] | 4 | 3w_LsKl-3Pk | 523 | |
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 | |
IPIROS PETROLOUKAS XALKIAS GAIDA KLARINO | The low quality recording features a traditional song that consists of a passionate woodwind melody playing over wide sustained strings, acoustic guitar chords and dissonant string melody. It sounds joyful, weird and hypnotic. | 2008-09-09T17:33:38Z | Lupo1908 | IPIROS PETROLOUKAS XALKIAS GAIDA KLARINO | ["Jazz", "Music", "Musical instrument"] | ["low quality", "traditional", "dissonant string melody", "acoustic guitar chords", "wide sustained strings", "passionate woodwind melody", "joyful", "weird", "hypnotic"] | 4 | mRKud6yP4iU | 4472 |
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;