musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy", musiccaps_aspects contains "passionate" and musiccaps_names contains "Speech"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- groovy · 2 ✖
- live performance 2
- passionate · 2 ✖
- aboriginal didgeridoo 1
- accordion melody 1
- ambient noises 1
- ancient customs 1
- crowd chattering 1
- didgeridoo 1
- didgeridoo player 1
- electric guitar melody 1
- emotional 1
- ethnic aboriginal instrument 1
- folk 1
- groovy bass 1
- hand percussions 1
- instrumental music 1
- low quality 1
- meditational 1
- medium tempo 1
- people talking 1
- percussive playing 1
- prayers 1
- punchy snare 1
- shimmering hi hats 1
- spirit connection 1
- spirited 1
- tapping rhythm 1
- traditional music 1
musiccaps_names (array) 9 ✖
- Music 2
- Speech · 2 ✖
- Accordion 1
- Didgeridoo 1
- Music of Latin America 1
- Musical instrument 1
- Orchestra 1
- Singing 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Samuel Rossi Orchestra Ringo Story Goleada polka | The low quality recording features a live performance of a folk song that consists of an accordion melody playing over groovy bass, shimmering hi hats, punchy snare and electric guitar melody. There are crowd chattering noises in the background. It sounds passionate and groovy. | 2009-07-03T12:40:13Z | Tuttofisa | Samuel Rossi Orchestra Ringo Story Goleada polka | ["Singing", "Traditional music", "Music", "Musical instrument", "Orchestra", "Speech", "Music of Latin America", "Accordion"] | ["low quality", "live performance", "crowd chattering", "folk", "groovy bass", "accordion melody", "electric guitar melody", "shimmering hi hats", "punchy snare", "passionate", "groovy"] | 4 | ChqJYrmQIN4 | 1394 | |
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;