musiccaps_details (view)
3 rows where musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "mysterious" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 57 ✖
- fast tempo · 3 ✖
- mysterious · 3 ✖
- instrumental music 2
- adventurous 1
- ambient noise 1
- animated 1
- blasts 1
- booming sounds 1
- brass section 1
- bumblebee 1
- chromatic harmony 1
- classic western music 1
- composer 1
- concert hall 1
- conductor 1
- creepy 1
- crystal glass harp solo 1
- deep vocal riff 1
- eerie 1
- electro pop 1
- electro rock 1
- emotional 1
- energetic 1
- enthusiastic drumming 1
- exciting 1
- funny 1
- glass harp 1
- great journey 1
- hissing tones 1
- horn section 1
- keyboard arrangement 1
- live performance 1
- magical 1
- magical journey 1
- male singer 1
- muffled background sounds 1
- opera hall 1
- orchestra 1
- passionate 1
- people screaming 1
- people talking 1
- poor audio quality 1
- positive 1
- psychotic 1
- pulsating 1
- shooting 1
- sinister 1
- solo performance 1
- spine tingling 1
- string section harmony 1
- thrilling 1
- twists and turns 1
- violin accompaniment 1
- virtuoso 1
- virtuoso glass harpist 1
- wondrous 1
- wooden xylophone 1
musiccaps_names (array) 7 ✖
- Music 2
- Boom 1
- Drum and bass 1
- Electronic music 1
- Glass 1
- Orchestra 1
- Tubular bells 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Musical Crystal Glasses Like Never Before | The song is an instrumental piece. The song is fast tempo with a glass harpist playing an extremely intricate solo with no other instrumentation . The song is magical and mysterious. The song is a live performance with ambient sounds of people talking in the background. | 2008-02-14T01:47:31Z | Amplify | I've only seen this in dramatized situations (film, cartoon). This man is ridiculous. I bet he could satisfy a classroom of women all at once. | ["Tubular bells", "Glass", "Music"] | ["crystal glass harp solo", "glass harp", "live performance", "hissing tones", "people talking", "instrumental music", "mysterious", "adventurous", "magical journey", "instrumental music", "solo performance", "emotional", "passionate", "chromatic harmony", "fast tempo", "virtuoso glass harpist", "classic western music", "poor audio quality", "ambient noise"] | 1 | ew-7SwLcHBg | 3909 | |
"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 | |
SAW DRUM AND BASS REMIX | A male uses a vocal phrase to the rhythm of background music. The tempo is fast with vigorous drumming, keyboard arrangements and muffled sounds of blasts, people screaming and shooting. This song is aggressive, sinister, creepy, mysterious and spine-tingling. This song is an Electro Pop/Rock. | 2008-02-19T15:43:42Z | mrDOTstretch | saw film drum and bass remix | ["Drum and bass", "Electronic music", "Music", "Boom"] | ["male singer", "fast tempo", "enthusiastic drumming", "people screaming", "shooting", "muffled background sounds", "spine tingling", "mysterious", "psychotic", "electro pop", "electro rock", "keyboard arrangement", "booming sounds", "blasts", "deep vocal riff", "sinister", "eerie", "creepy", "thrilling"] | 7 | RZmH4hGiYBg | 2711 |
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;