musiccaps_details (view)
3 rows where musiccaps_aspects contains "positive vibe" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- positive vibe · 3 ✖
- uptempo 2
- accordion 1
- acoustic drums/percussion's 1
- acoustic guitar 1
- amateur recording 1
- bassmarimba 1
- e-bass 1
- e-guitar 1
- female backing voice 1
- hindi/pop 1
- loud cheering and clapping 1
- male voice high register singing 1
- male voice rapping 1
- maracas 1
- marimba orchestra 1
- singer-songwriter/rap 1
- upbeat 1
musiccaps_names (array) 11 ✖
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 | |
Hum Bhi Agar Bachhe Hote - Hindi Animation Song for kids @JingleToons | Drums and percussion are playing a groove that animates to dance along with a bassline. In the background you can hear a clean e-guitar strumming chords. A male voice is singing in a higher register and an accordion ends the phrase with a short and fast melody. This song may be playing at a kids party. | 2013-11-28T08:35:43Z | Jingle Toons | #HumBhiAgarBachche #SongForKids #JingleToons Hum Bhi agar bachhe hote is an animation song based on a popular Hindi song. This animated version is brought to you by Jingle Toons. | ["Jingle (music)", "Music", "Music of Bollywood"] | ["hindi/pop", "e-guitar", "e-bass", "acoustic drums/percussion's", "accordion", "male voice high register singing", "positive vibe", "upbeat"] | 6 | EKZvq0dUk50 | 1545 | |
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;