musiccaps_details (view)
2 rows where musiccaps_aspects contains "brass section" and musiccaps_aspects contains "funny"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- brass section · 2 ✖
- funny · 2 ✖
- acoustic piano 1
- animated 1
- bumblebee 1
- composer 1
- concert hall 1
- conductor 1
- energetic 1
- exciting 1
- fast tempo 1
- flute 1
- great journey 1
- horn section 1
- instrumental music 1
- jazz/pop 1
- magical 1
- male voices singing 1
- mysterious 1
- opera hall 1
- orchestra 1
- positive 1
- pulsating 1
- string section harmony 1
- twists and turns 1
- upright bass 1
- uptempo 1
- violin accompaniment 1
- virtuoso 1
- wondrous 1
- wooden xylophone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Robbie Williams I Wan'na Be Like You feat Olly Murs The Graham Norton | A male voice is singing in the midrange then another male voice joins singing in a lower harmony. In the background you can hear a jazz drum playing along with an upright bass and a flute. An acoustic piano is playing jazzy licks. Then the drum breaks the beat with strong fill-ins before a brass section elevates the piece. This song may be playing live during a jazz performance. | 2013-11-23T09:37:56Z | Jenny Ocean | ["Singing", "Music", "Ska"] | ["jazz/pop", "male voices singing", "acoustic piano", "flute", "upright bass", "brass section", "uptempo", "funny"] | 6 | XhV4zf-Xlmk | 3213 | ||
"Flight of the Bumblebee" - Patrick De Smet, Carlo Willems & Il Novecento | The song is an instrumental. The tempo is fast , with a philharmonic orchestra consisting of string section, rhythm section and horns accompanying a virtuoso wooden xylophone playing this western classical hit. The song is energetic and exciting. | 2009-01-14T18:27:23Z | NOTPvids | Patrick De Smet, Carlo Willems & Il Novecento - "Flight of the Bumblebee" Night of the Proms (France, 2007) | ["Orchestra"] | ["violin accompaniment", "virtuoso", "wooden xylophone", "orchestra", "instrumental music", "horn section", "brass section", "conductor", "composer", "opera hall", "concert hall", "fast tempo", "exciting", "bumblebee", "funny", "animated", "wondrous", "magical", "great journey", "twists and turns", "energetic", "pulsating", "mysterious", "positive", "string section harmony", "fast tempo"] | 1 | uZHE9b1WDuM | 5124 |
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;