musiccaps_details (view)
2 rows where musiccaps_author = 6 and "youtube_published" is on date 2009-03-11
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic drums 1
- amateur recording 1
- bass 1
- bassmarimba 1
- female voice singing 1
- guitar 1
- keys 1
- maracas 1
- marimba orchestra 1
- positive vibe 1
- reggae 1
- relaxing mood 1
- slower tempo 1
- uptempo 1
- white noise 1
musiccaps_names (array) 7 ✖
- Music 2
- Marimba, xylophone 1
- Musical instrument 1
- Percussion 1
- Reggae 1
- Soul music 1
- Steelpan 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 | |
CHERRY PIE RIDDIM - ??? & ERIC DONALDSON | The drums are just playing the hihat and the kick on the second beat which is typical for reggae. The keys are playing one chord on the offbeat. A guitar is playing some repeating chords along while the bass is playing a simple rhythmic pattern to support the drums. The female voice is singing with some reverb on her voice. This song may be playing on a sunny day at home with open windows mixed with the noises of a lovely small town. | 2009-03-11T20:18:42Z | Micha Otto | ▬► Mr.Rek .... | ["Music", "Reggae", "Soul music"] | ["reggae", "acoustic drums", "white noise", "bass", "keys", "guitar", "female voice singing", "slower tempo", "relaxing mood"] | 6 | C5MhO2HM2Wg | 1327 |
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;