musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "live performance" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- emotional · 3 ✖
- live performance · 3 ✖
- passionate 2
- aboriginal didgeridoo 1
- acoustic guitar 1
- ambient noises 1
- ancient customs 1
- crowd cheering 1
- crowd clapping 1
- didgeridoo 1
- didgeridoo player 1
- ethnic aboriginal instrument 1
- flamenco 1
- footstep sound 1
- fruity male vocal 1
- groovy 1
- hand percussions 1
- instrumental music 1
- low quality 1
- male vocal 1
- meditational 1
- medium tempo 1
- mixed harmonizing choir 1
- mono 1
- noisy 1
- passionate singing 1
- people talking 1
- percussive playing 1
- prayers 1
- soulful 1
- spanish 1
- spirit connection 1
- spirited 1
- tapping rhythm 1
- traditional music 1
- vibrant 1
musiccaps_names (array) 11 ✖
- Music 3
- Speech · 3 ✖
- Singing 2
- /m/05zppz 1
- /t/dd00003 1
- Choir 1
- Didgeridoo 1
- Flamenco 1
- Guitar 1
- Music of Latin America 1
- Opera 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Antonio José canta por fandangos (Directo Málaga) | This is the live performance of a flamenco music piece. There is a male vocalist singing passionately in the Spanish language. An acoustic guitar strums a characteristic flamenco tune. Sounds of the crowd cheering can be heard in the background. The atmosphere is vibrant. | 2015-04-27T20:37:09Z | Carmen SV | Concierto sala Tenessee (Málaga) 26/04/2015 | ["Singing", "Flamenco", "Guitar", "Music", "Speech", "Music of Latin America"] | ["flamenco", "live performance", "spanish", "male vocal", "passionate singing", "acoustic guitar", "crowd cheering", "emotional", "vibrant"] | 9 | GUwBLItoJXk | 1727 | |
Treorchy Male Choir & Tom Jones singing Amazing Grace | The low quality recording features a live performance of a harmonizing mixed choir, introduced by a fruity male vocal. There is a footstep and crowd clapping sound right after introduction. The recording is a bit noisy, in mono and it sounds passionate, emotional and soulful. | 2009-11-27T01:22:15Z | Llantrisant | Tom Jones and the Treorchy Male Choir performing "Amazing Grace" on his Christmas TV Show, 1969. Visit www.treorchymalechoir.com | ["Singing", "Music", "Opera", "/m/05zppz", "Speech", "Choir", "/t/dd00003"] | ["low quality", "noisy", "mono", "footstep sound", "fruity male vocal", "crowd clapping", "mixed harmonizing choir", "emotional", "passionate", "soulful", "live performance"] | 4 | V5HMIxuAtv8 | 2973 | |
Aboriginal Didgeridoo part 1 | The song is an instrumental. The tempo is medium with an aborigine playing a didgeridoo and a tapping rhythm in a percussive manner. The audio quality is bad with ambient crowd talking sounds. The music is traditional and deeply meditative in nature. | 2007-08-16T23:13:45Z | Jeffrey Siegel | The didgeridoo (or didjeridu) is a wind instrument of the Indigenous Australians of northern Australia. | ["Didgeridoo", "Music", "Speech"] | ["didgeridoo", "aboriginal didgeridoo", "groovy", "ethnic aboriginal instrument", "didgeridoo player", "people talking", "ambient noises", "hand percussions", "medium tempo", "instrumental music", "tapping rhythm", "percussive playing", "meditational", "traditional music", "ancient customs", "emotional", "passionate", "spirited", "spirit connection", "prayers", "live performance"] | 1 | lUp9WnLYetg | 4404 |
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;