musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_names contains "Percussion" and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- amateur recording · 2 ✖
- acoustic drums 1
- backing track 1
- bassmarimba 1
- e-bass 1
- e-guitar 1
- maracas 1
- marimba orchestra 1
- medium to uptempo 1
- positive vibe 1
- reggae 1
- steel drums 1
- uptempo 1
musiccaps_names (array) 5 ✖
- Music 2
- Musical instrument 2
- Percussion · 2 ✖
- Steelpan · 2 ✖
- Marimba, xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
In the Jungle (Marimbas) | A lot of marimbas are being played with the same melody. Along with a bass marimba playing low notes as bassline. Maracas are providing the rhythm. This is an amateur recording. The audio-quality is not the best. This song may be playing for a live concert. | 2009-03-11T22:47:40Z | Dana Holle | Sunset View Elementary school's 5th grade Rugare Marimba Ensemble. These kids travel the Northwest to play for other schools and private groups. Their teacher is amazing and talented and inspiring. He invests a lot of time and care into these students. One of the best experiences our family has had! | ["Music", "Musical instrument", "Marimba, xylophone", "Percussion", "Steelpan"] | ["marimba orchestra", "maracas", "bassmarimba", "uptempo", "positive vibe", "amateur recording"] | 6 | 6Q5N1DfzGj0 | 753 | |
Is This Love? | This audio contains someone playing a melody on steeldrums along to a backing track containing an e-bass playing a melody along with an e-guitar. A kick is being played on every beat. This song may be played on the streets by a busker. | 2011-03-22T14:37:55Z | Steel Drum Music | Bob Marley's classic reggae hit played in 2011 at the Harbor Beach Marriott, Fort Lauderdale, Florida. This song is featured on the 'Steel Drum Rub-a-Dub: Bob Marley Tribute' album. You can get it at: iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA or directly from Bob Lyons' web site: http://www.SteelDrumMusic.net | ["Music", "Musical instrument", "Percussion", "Steelpan"] | ["amateur recording", "reggae", "backing track", "e-bass", "acoustic drums", "steel drums", "e-guitar", "medium to uptempo"] | 6 | msnm_tYXcYw | 4497 |
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;