musiccaps_details (view)
2 rows where musiccaps_names contains "Drum" and musiccaps_names contains "Orchestra" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- bongos 1
- brass instruments 1
- dance 1
- energetic 1
- energetic drums 1
- exotic 1
- groovy 1
- intricate piano playing 1
- jazz 1
- latin music 1
- live performance 1
- low quality 1
- mono 1
- noisy 1
- passionate 1
- saxophone 1
- steel drums melody 1
- traditional percussive instruments 1
- trumpets 1
musiccaps_names (array) 7 ✖
- Drum · 2 ✖
- Orchestra · 2 ✖
- Percussion 2
- Drum kit 1
- Music 1
- Musical instrument 1
- Steelpan 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Marvin Diz Performs in the LP Studio | This is a jazz song with some latin infusions into the style. The brass section plays bright and ascending melodies. The percussionists play bongos and snares with brushes. The song is fun and suitable for some loose dancing. | 2009-12-15T20:54:15Z | Latin Percussion | The Marvin Diz Band Performs "Pensando en la Habana" LP Instruments: LP Bata Drums LP Giovanni Palladium Series Congas LP Giovanni Palladium Series Bongos LP Tito Puente Timbales LP Jam Block LP Salsa Cowbell | ["Drum", "Orchestra", "Percussion"] | ["jazz", "latin music", "brass instruments", "trumpets", "saxophone", "traditional percussive instruments", "bongos", "intricate piano playing", "groovy", "dance"] | 3 | A6HJBIU1rD0 | 1068 | |
Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 |
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;