musiccaps_details (view)
2 rows where musiccaps_aspects contains "dramatic" and musiccaps_names contains "Trumpet"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- dramatic · 2 ✖
- background wind noise 1
- brass composition 1
- cinematic 1
- dangerous 1
- dynamic 1
- flat male vocal 1
- intense 1
- low quality 1
- marching drums 1
- orchestral 1
- slow tempo 1
- suspenseful orchestra 1
musiccaps_names (array) 2 ✖
- Brass instrument 2
- Trumpet · 2 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Priyamanaval Episode 176, 14/08/15 | The low quality recording features a flat male vocal speaking over suspenseful orchestra music. It sounds intense and dramatic and as soon as the male vocal stops speaking, the volume of the music goes up - which makes it dynamic overall. | 2015-08-14T16:00:01Z | VikatanTV | Priyamanaval பிரியமானவள் Episode 176 Subscribe: http://goo.gl/yeOTw3 Next Episode: https://goo.gl/o1XDi2 Prev Episode: https://goo.gl/mD3vAa Prabha and Saravanan share their love tale with each other 00:05 Anthony returns the money he snatched from Kavitha 04:17 Prabha meets Bhoomika 16:28 Priyamanaval All Episodes: http://goo.gl/78sst2 Sakash decorate for wedding night: http://goo.gl/VfqrEl Thulasi insults Tamil: http://goo.gl/T14w0u Kanagu's bike ride with Deepa: http://goo.gl/wrkbj6 Kuruvi is my nickname: http://goo.gl/KlJAQ8 Beautiful Kuttima: http://goo.gl/jIsNDs Kuruvi is my nickname: http://goo.gl/Y3hx0T Deivamagal Episode 699: http://goo.gl/hvbvh7 Azhagi Episode 965: http://goo.gl/wEqR1L Channel: http://www.youtube.com/user/VikatanTV Facebook: www.facebook.com/priyamanavalserial | ["Brass instrument", "Trumpet"] | ["low quality", "suspenseful orchestra", "flat male vocal", "intense", "dramatic", "dynamic"] | 4 | 3Xoz87_SUdw | 479 | |
Space Above and Beyond Trailer for Season 2 | This audio contains marching drums with a kick and snare rolls. A brass section starts to play a melody in the low to mid range up to the higher register. In the background you can hear a strong wind that seems not to be part of the song. This song may be playing in a pirate movie-scene. | 2007-02-07T02:35:50Z | sjc2006 | Trailer for possible continuation for a show that was cancelled way too soon. Maybe Morgan and Wong will get to see this and be inspired by knowing that the fanbase still holds out hope. We believe in you. Semper fi!!!!! | ["Brass instrument", "Trumpet"] | ["cinematic", "orchestral", "brass composition", "background wind noise", "marching drums", "dangerous", "dramatic", "slow tempo"] | 6 | F9LJIyqQFe8 | 1619 |
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;