musiccaps_details (view)
2 rows where musiccaps_aspects contains "positive vibe" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- positive vibe · 2 ✖
- uptempo · 2 ✖
- acoustic guitar 1
- amateur recording 1
- bassmarimba 1
- female backing voice 1
- loud cheering and clapping 1
- male voice rapping 1
- maracas 1
- marimba orchestra 1
- singer-songwriter/rap 1
musiccaps_names (array) 9 ✖
- Music 2
- Inside, large room or hall 1
- Marimba, xylophone 1
- Musical instrument 1
- Percussion 1
- Singing 1
- Steelpan 1
- Whoop 1
- Yell 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 | |
Room39 - Mixed Song @ FAT Fest 10 | An acoustic guitar is strumming chords along with a male voice rapping that gets backing vocals from a female voice for a moment. A lot of people are clapping and cheering. This song may be playing at a live concert. | 2010-11-07T17:27:20Z | KaitoGallery | from iPhone upload by http://www.entertainstation.com | ["Singing", "Music", "Whoop", "Yell", "Inside, large room or hall"] | ["singer-songwriter/rap", "acoustic guitar", "male voice rapping", "loud cheering and clapping", "female backing voice", "uptempo", "positive vibe"] | 6 | sOSU7p9pLjs | 4946 |
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;