musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "electric guitar" and musiccaps_names contains "Exciting music"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 24 ✖
- acoustic drums · 3 ✖
- bass guitar 3
- electric guitar · 3 ✖
- energetic 2
- female vocal 2
- melodic singing 2
- 80s pop 1
- alternative 1
- country music 1
- easygoing 1
- grandiose 1
- high tempo 1
- keyboard 1
- live performance 1
- male vocal 1
- nu-metal 1
- pad 1
- piano 1
- pop music 1
- repeated tune 1
- rock 1
- simple tune 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 4 ✖
- Exciting music · 3 ✖
- Music 3
- Happy music 1
- Music of Asia 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
She's All That shouting out Music Music! (live @ Rheinkultur Bonn 2009) | This is a nu-metal piece performed live on the stage. There is a male vocal shouting the words at the end of the song. The electric guitar is repeating the same tune while the bass guitar is playing in the background. The drummer plays fills on the acoustic drums to provide the rhythmic background. There is a high energy atmosphere to this piece. It could be used in an ad targeted for teenagers. | 2009-07-05T21:32:23Z | pnolle | Those Nu-Break-maniacs give you the ultimate thrill on stage, hiding their identity behind bizarre masks. A ferocious mixture of electro, ragga, punk and breakbeat. Visit www.shesallthat.de SATrk09 SuperKid 640x360 | ["Music", "Exciting music"] | ["nu-metal", "alternative", "live performance", "male vocal", "electric guitar", "repeated tune", "bass guitar", "acoustic drums", "energetic"] | 9 | 79tuMIiWMZ4 | 816 | |
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 | |
Hot Top Country Music Josie Brandon - So Cool (Official Music Video) | This is a country music piece. There is a female vocalist singing melodically at the forefront. The melodic background consists of the electric guitar, the bass guitar and the piano. The rhythmic background is provided by a simple acoustic drum beat. The atmosphere is upbeat and easygoing. This piece could be playing in the background at a rock bar. It could also work well as an advertisement jingle. | 2012-07-10T23:34:20Z | ARIZONA HEALING RETREATS PAIN TO PROMISE WORKSHOP | DOWNLOAD ALBUM OR SONGS AT www.JosieBrandonMusic.Com Top Hot Original Country Music, Crazy Week, Original Music & Lyrics by Josie Brandon, Nigel Lythgoe. This Opening Act Will Rock The House! CMT Country Music Television, Sexiest Country Music Videos, Great American Country, Country Hits | ["Music", "Happy music", "Exciting music"] | ["country music", "rock", "female vocal", "melodic singing", "electric guitar", "piano", "bass guitar", "acoustic drums", "simple tune", "upbeat", "easygoing"] | 9 | suX7Cri4kAo | 4986 |
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;