musiccaps_details (view)
4 rows where musiccaps_aspects contains "grandiose", musiccaps_author = 9 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- grandiose · 4 ✖
- bass guitar 2
- classical 2
- dramatic 2
- electric guitar 2
- female vocal 2
- grand piano 2
- live performance 2
- melodic singing 2
- 80s pop 1
- accentuated playing 1
- acoustic drums 1
- contemporary 1
- electronic drums 1
- emotional 1
- energetic 1
- female choir 1
- fugue 1
- groovy 1
- high tempo 1
- hip-hop 1
- instrumental 1
- keyboard 1
- male vocal 1
- minor key 1
- mysterious 1
- no singer 1
- pad 1
- pop music 1
- r&b 1
- soul 1
- vibrant 1
musiccaps_names (array) 11 ✖
- Music · 4 ✖
- Music of Asia 2
- Classical music 1
- Crowd 1
- Electric piano 1
- Exciting music 1
- Harpsichord 1
- Keyboard (musical) 1
- Piano 1
- Salsa music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sound Of Music - 02 Magic Night (1987) | This is a pop music piece with 80s characteristics. There is a female vocalist in the lead singing melodically. The main theme is played by a keyboard and an electric guitar at the same time in the major scale. There is a bass guitar and a medium-to-high range pad in the background. The rhythmic background is provided by a loud but simple acoustic drum beat. There is a maximalist, vibrant and energetic atmosphere. This piece could be used in the soundtrack of a romance movie. It could also fit very nicely as the soundtrack of an anime. | 2009-12-25T08:13:42Z | mixtis carminibus | Sound Of Music was a Swedish pop group who recorded two albums 1986-1987. Peter Grönvall, who wrote the music, is the son of Benny Andersson from Abba. The other two members were Nanne Grönvall and Angelique Widengren. | ["Music of Asia", "Music", "Exciting music"] | ["pop music", "80s pop", "female vocal", "melodic singing", "keyboard", "bass guitar", "electric guitar", "pad", "acoustic drums", "grandiose", "vibrant", "energetic", "high tempo"] | 9 | TN53jpjqAGI | 2833 | |
Puff Daddy Ill Be Missing You | This is an R&B/soul music piece. There is a female vocal singing at a high pitch joined by a male vocal singing at a medium pitch and a female choir backing. The beat has a repeating electric guitar tune. There is a groovy bass line. The rhythm is provided by an electronic drum beat. The atmosphere is emotional and grandiose. This piece could be playing in the background at a memorial event. | 2009-03-24T09:22:59Z | Noti1986 | ["Singing", "Music of Asia", "Crowd", "Music"] | ["r&b", "soul", "hip-hop", "live performance", "female vocal", "male vocal", "female choir", "melodic singing", "electric guitar", "bass guitar", "electronic drums", "groovy", "emotional", "grandiose"] | 9 | vxIF3B4YqW8 | 5221 | ||
Music and Dance of Cuba Salsa, Timba, Casino, Rueda! | This is a contemporary classical music performance. The piece is being played on the grand piano with an accentuated playing style. There is a lot of emphasis on the notes. The atmosphere is dramatic. Parts of this piece could be included in the soundtrack of a documentary. It could also be used in the soundtrack of a mystery/horror video game. | 2011-06-23T08:26:17Z | ozeasme | ["Music", "Salsa music"] | ["classical", "contemporary", "instrumental", "grand piano", "accentuated playing", "grandiose", "dramatic"] | 9 | xJMTA3Ay5FI | 5315 | ||
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 |
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;