musiccaps_details (view)
3 rows where musiccaps_aspects contains "dramatic", musiccaps_aspects contains "instrumental" and musiccaps_aspects contains "strings"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- dramatic · 3 ✖
- instrumental · 3 ✖
- strings · 3 ✖
- clarinet 1
- comedy 1
- contemporary classical 1
- fighting 1
- footsteps 1
- gong 1
- goofy tune 1
- male voices 1
- martial arts movie 1
- no singer 1
- paigu 1
- percussion 1
- piano 1
- repeated theme 1
- shouting 1
- suspense 1
- tension 1
- violin 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"Breathtaking Sights" - Erik Zilliacus (Piano, Orchestral) | This is a contemporary classical music piece. It is an instrumental piece. There is a strings section playing the chords while the violin in the lead is playing a dramatic tune. The piano is playing accentuated notes. There is a percussion line in the rhythmic background. There is a dramatic atmosphere that is full of suspense. This piece could be used in the soundtrack of a sci-fi drama movie, especially during the scenes where a big revelation is about to take place. | 2014-06-26T09:56:05Z | TheMusicFlowChannel | This was composed by Erik Zilliacus. For more music by the composer: https://youtube.com/user/drunkensailorful SoundCloud: https://soundcloud.com/erik-zilliacus TheMusicFlowChannel on Facebook: https://facebook.com/TheMusicFlowChannel Wallpaper: http://mediafire.com/convkey/73fa/mr0n5n56236eea4fg.jpg?size_id=a * TMFC has the permission to promote "Breathtaking Sights" by Erik Zilliacus. * | ["Orchestra"] | ["contemporary classical", "no singer", "instrumental", "violin", "strings", "piano", "percussion", "repeated theme", "dramatic", "suspense"] | 9 | 7JE2eBK1f9M | 828 | |
Jet lie- wonderful kong fuo video | These are the sounds coming from a martial arts movie. There are male voices shouting at each other. Sounds of footsteps and the movements of fighting can be heard. The music in the background has a dramatic tune being played on the strings. The rhythmic background is composed of Chinese paigu drums and the gong. There is a feeling of tension in this track. Some parts of this recording can be sampled for use in beat-making. | 2007-05-24T14:30:15Z | bashar105 | Jet lie beating an arrogant guy with some wonderful moves. sport.go to: wrongthings.org | ["Music", "Scary music", "Outside, urban or manmade"] | ["martial arts movie", "instrumental", "male voices", "shouting", "footsteps", "fighting", "strings", "gong", "paigu", "tension", "dramatic"] | 9 | MdsRmMxkF4k | 2284 | |
Ranma 1/2 Live Action Cast | This is an instrument comedy music piece. There is a clarinet playing a goofy tune. Then, the clarinet stops and the strings section starts playing a dramatic melody. This piece could be sampled to be used as instrumentals in an advertisement jingle. | 2011-10-21T00:40:13Z | Rumic World | The cast of the new Ranma 1/2 special in full costume. The special will air on December 9, 2011 at 7:00pm on NTV. Kento Kaku (male Ranma) Natsuna Wantanabe (female Ranma) Yui Aragaki (Akane) Kyoko Hasegawa (Kasumi) Shosuke Tanihara (Dr. Tofu) Maki Nishiyama (Nabiki) Kento Nagayama (Tatewaki Kuno) Yuta Kanai (Hikaru Gosunkugi) Arata Furuta (Genma) Katsuhisa Namase (Soun) Ryousei Tayama (Okamada) The song is "Lychee & Jasmine" from the Movie 1 OST. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["comedy", "instrumental", "clarinet", "goofy tune", "strings", "dramatic"] | 9 | fvTh5m9RHZw | 3988 |
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;