musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums" and musiccaps_names contains "Orchestra"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- acoustic drums · 3 ✖
- percussion 2
- acoustic guitars 1
- big-band/marching 1
- brass/horn section 1
- congas 1
- flutes 1
- higher pitch 1
- instrumental 1
- lively 1
- male voice singing 1
- maracas 1
- marimba 1
- medium to uptempo 1
- orchestra 1
- oriental/orchestral 1
- oud 1
- rhythmic 1
- strings 1
- tambourine 1
- upright bass 1
- uptempo 1
- xylophone 1
musiccaps_names (array) 4 ✖
- Orchestra · 3 ✖
- Glockenspiel 1
- Mallet percussion 1
- Marimba, xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Lior Boker playing "A gate that closed" in maqam sika | This composition contains acoustic guitars strumming chords panned to the right side of the speakers. Other plucked string instruments are playing a melody along. An acoustic drum is playing a simple dance groove with a pregnant hihat. In the background you can hear an upright bass and violins playing a melody on the next part of the song. A male voice is singing in the mid-to high range. This song may be playing live. | 2008-09-19T14:59:57Z | lior boker | Lior Boker with the Israeli Andalusian Orchestra and Shimon Sibony | ["Orchestra"] | ["oriental/orchestral", "acoustic guitars", "oud", "strings", "acoustic drums", "percussion", "upright bass", "male voice singing", "higher pitch", "medium to uptempo"] | 6 | DPW5M1FYxu4 | 1473 | |
Wedding Dress [impromptu] - Nanyang Polytechnic Chinese Orchestra (Percussionists) | This is a percussion orchestra performance. There are many percussive elements in this orchestra such as the congas, the maracas, the marimba and the xylophone. There is also an acoustic drum playing in the orchestra. The atmosphere is lively. | 2010-11-27T10:00:58Z | NYPChineseOrchestra | Nanyang Polytechnic Chinese Orchestra (Percussionists) Messing around during practice. ^^ Our Impromptu Wedding Dress. Hope you'll enjoy! :D | ["Orchestra", "Marimba, xylophone", "Glockenspiel", "Mallet percussion"] | ["orchestra", "instrumental", "percussion", "congas", "maracas", "xylophone", "marimba", "acoustic drums", "rhythmic", "lively"] | 9 | aURLQXt_6fE | 3544 | |
Bon Jovi - Rock Mix | This audio contains a musical composition played by a big horn section and a lot of flutes. Someone is playing a simple and loud groove on the drums. In the background you can hear someone playing a marimba. This song may be playing live at a big sports event. | 2015-01-17T18:50:12Z | Istvan Sentes | Kézdivásárhelyi Tanulók Klubja - Karácsonyi Koncert 2014 | ["Orchestra"] | ["big-band/marching", "brass/horn section", "acoustic drums", "tambourine", "flutes", "uptempo"] | 6 | wRWxsKN394Q | 5267 |
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;