musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance" and musiccaps_aspects contains "mysterious" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- live performance · 3 ✖
- mysterious · 3 ✖
- instrumental music 2
- adventurous 1
- ambient noise 1
- bass clarinet 1
- cell player 1
- chromatic harmony 1
- clarinet 1
- clarinet melody 1
- classic western music 1
- classical 1
- crystal glass harp solo 1
- dramatic 1
- emotional 1
- fast tempo 1
- fugue 1
- glass harp 1
- grand piano 1
- grandiose 1
- groovy rhythm 1
- hissing tones 1
- horn and string quartet 1
- live audience 1
- magical journey 1
- medium tempo 1
- melancholic music 1
- minor key 1
- no singer 1
- passionate 1
- people talking 1
- poor audio quality 1
- rich quality 1
- rock music cover 1
- solo performance 1
- song cover 1
- trombone 1
- virtuoso glass harpist 1
- western classical quartet 1
musiccaps_names (array) 11 ✖
- Music 2
- Brass instrument 1
- Clarinet 1
- Classical music 1
- Electric piano 1
- Glass 1
- Harpsichord 1
- Keyboard (musical) 1
- Piano 1
- Trombone 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 |
---|---|---|---|---|---|---|---|---|---|---|
J.S.Bach - Toccata and Fugue in D Minor (BWV 565), performed by R. Härdtner & Jazz-Trio 2001 | This is a live performance of a classical music piece. There is a grand piano playing dramatically in minor keys. The piece has a grandiose and mysterious aura to it. This piece could be used in the soundtrack of a horror movie. It could also be used in a horror video game theme. | 2014-12-06T13:27:56Z | Roland Härdtner | This music is also on Roland Härdtner's CD "AIRevolution / Swinging Mallets play Bach" (track 03). For more information please visit: http://shop.roland-haerdtner.com/inde... If you're interested to see more from Roland Härdtner's musical activities (more than 200 concert videos in the near future), please subscribe to his new channel https://www.youtube.com/user/rolandha... and you will always be informed about the most recent clips. Enjoy it! | ["Electric piano", "Harpsichord", "Music", "Keyboard (musical)", "Piano", "Classical music"] | ["classical", "fugue", "minor key", "no singer", "grand piano", "mysterious", "grandiose", "dramatic", "live performance"] | 9 | xM4p5pmRAxM | 5323 | |
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 | |
"Fade to Black" by Metallica, for clarinet, bassoon, trombone, and cello | The song is an instrumental. The song is in medium tempo with a cello playing percussively, a clarinet in melody and supported in harmony by a bass clarinet and a trombone. The song is a rock song cover played live. The song is engaging and rich in quality. | 2013-04-28T00:01:16Z | Ceylan Yagmur | From Ceylan Yagmur's Senior Recital, part 6/6 April 5, 2013 UCLA Popper Theater Audio / Video by Umberto Belfiore Arr. by Ceylan Yagmur Alexander Chay - bassoon Eunice Heo - cello Adam Korynta - trombone Ceylan Yagmur - clarinet | ["Brass instrument", "Clarinet", "Trombone"] | ["clarinet", "bass clarinet", "trombone", "cell player", "rich quality", "western classical quartet", "song cover", "rock music cover", "medium tempo", "clarinet melody", "horn and string quartet", "live performance", "groovy rhythm", "instrumental music", "melancholic music", "mysterious", "live audience"] | 1 | cSBRb4KF5xs | 3708 |
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;