musiccaps_details (view)
5 rows where musiccaps_aspects contains "trumpets" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 73 ✖
- medium tempo 5
- trumpets · 5 ✖
- brass band 3
- conductor 3
- instrumental music 3
- philharmonic orchestra 3
- composer 2
- groovy 2
- latin dance hits 2
- latin dance music 2
- live audience 2
- male singer 2
- passionate 2
- poor audio quality 2
- spirited 2
- syncopated rhythms 2
- trombones 2
- tubas 2
- adrenaline rush 1
- ambient room noise 1
- bad sound quality 1
- bassoons 1
- blaring horns 1
- brass quartet 1
- brass section 1
- building anticipation 1
- clarinet player 1
- clarinets 1
- composers 1
- concert hall 1
- dance music 1
- danger 1
- energetic 1
- exciting 1
- exercise class 1
- grand 1
- groovy music 1
- groovy rhythm 1
- guitar accompaniment 1
- gym music 1
- high pitched melody 1
- home music video 1
- horn section 1
- humour 1
- instrumental squid 1
- latin percussion 1
- latin percussions 1
- live concert 1
- live performance 1
- marimba 1
- movie soundtrack 1
- mysterious 1
- mystery 1
- ominous 1
- people dancing 1
- percussive play 1
- pomp 1
- saxophone harmony 1
- saxophones 1
- song ending 1
- song fade 1
- strong bass line 1
- traditional latin dance 1
- triumphant 1
- trumpets blaring 1
- tuba 1
- western classic music influences 1
- western classical music 1
- wild life documentary soundtrack 1
- wooden xylophone 1
- workout playlist 1
- zumba dance hits 1
- zumba music 1
musiccaps_names (array) 10 ✖
- Brass instrument 3
- Music 2
- Trumpet 2
- Clarinet 1
- French horn 1
- Maraca 1
- Saxophone 1
- Scary music 1
- Song 1
- Sound effect 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Suspenso - Efectos de Sonidos | The song is an instrumental. The tempo is medium with various horns like trumpets, trombones and tubas playing blaring lots in harmony. The song is mysterious and ominous in nature. The song is a wildlife documentary soundtrack. | 2014-10-20T18:04:59Z | Efectos de Sonidos GRATIS | Descarga : http://adf.ly/t3m8R : Download Suspenso - Efectos de Sonidos Miedo - Efectos de Sonidos Terror - Efectos de Sonidos Drama - Efectos de Sonidos Para asustarse - Efectos de Sonidos Sustos - Efectos de Sonidos Mounstros - Efectos de Sonidos Feos - Efectos de Sonidos Sustos - Efectos de Sonidos Trama - Efectos de Sonidos Thriller - Sound Effects Fear - Sound Effects Terror - Sound Effects Drama - Sound Effects To scared - Sound Effects Scares - Sound Effects Monsters - Sound Effects Ugly - Sound Effects Scares - Sound Effects Plot - Sound Effects No olvides pedirme los sonidos que necesites Estare ayudandote siempre y cuando pueda ▶ Ayudame :) http://www.youtube.com/user/PutorialesC ▁ ▂ ▃ ▄ ▅ ▆ ▇ █ ▋▌ SuscribeTE ▌▋█ ▇ ▆ ▅ ▄ ▃ ▂ ▁ | ["Music", "Sound effect", "Scary music"] | ["brass band", "tubas", "trumpets", "trombones", "wild life documentary soundtrack", "mysterious", "building anticipation", "ominous", "brass quartet", "philharmonic orchestra", "conductor", "composer", "western classic music influences", "groovy", "percussive play", "danger", "mystery", "blaring horns", "instrumental music", "medium tempo"] | 1 | KurvLmoKCog | 2131 | |
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 | |
Immer Kleiner Philips Harmonie | The song is an instrumental. The tempo is medium with a clarinet playing lead supported by a wind section, horn section, brass section and other percussion. The song is exciting and energetic. The song is a western classic tune with bad audio quality issues. | 2010-02-08T15:01:49Z | juudruud | Guido van de Ven speelt 'Immer Kleiner' tijdens het nieuwjaarsconcert 2010 van de Philips Harmonie. dirigent: Matty Cilissen special guest star: Jos de Wit Guido van de Ven plays 'Always Smaller'. Newyearconcert 2010 Philips Harmonie Eindhoven. conductor: Matty Cilissen special guest star: Jos de Wit Bekijk ook het officiële Philips Harmonie Youtube-kanaal https://www.youtube.com/channel/UCD7B2SzauFUtJ58DHheWy4w | ["Brass instrument", "Clarinet", "Trumpet"] | ["clarinet player", "horn section", "brass section", "philharmonic orchestra", "instrumental music", "trumpets", "conductor", "medium tempo", "instrumental music", "concert hall", "high pitched melody", "syncopated rhythms", "grand", "exciting", "pomp", "humour", "energetic", "passionate", "composers", "conductor", "live audience", "live performance", "poor audio quality", "spirited", "tubas", "clarinets", "bassoons"] | 1 | Z-Vb1Ay-zNA | 3333 | |
Chicago Brass Festival 2009 | The song is an instrumental. The tempo is medium with a brass section including trumpets, trombones and tubas playing in an instrumental harmony. The song is emotional and spirited. The song is western classical music piece. | 2009-08-21T18:56:24Z | Chicagobrassfestival | The next Chicago Brass Festival will be held March 19 - 21, 2010. www.chicagobrassfestival.com for more information | ["Brass instrument", "French horn", "Trumpet"] | ["brass band", "trumpets", "tuba", "trombones", "western classical music", "philharmonic orchestra", "song fade", "song ending", "triumphant", "trumpets blaring", "instrumental music", "groovy", "movie soundtrack", "live concert", "live audience", "conductor", "composer", "medium tempo"] | 1 | _MjbdUaJcik | 3466 | |
Marimba Perla de Chiapas 2010 abeja miope | The song is an instrumental. The tempo is medium with a brass including trumpets and saxophones playing in harmony, wooden xylophones and Latin percussions play accompaniment to the band along with a male singer. The song is exciting and groovy. The audio quality is poor and probably a home recording. | 2010-01-15T12:34:08Z | Jawar TresCeros | Marimba Perla de Chiapas 2010 abeja miope | ["Brass instrument", "Saxophone"] | ["marimba", "latin dance music", "saxophones", "medium tempo", "instrumental squid", "traditional latin dance", "brass band", "trumpets", "groovy rhythm", "syncopated rhythms", "dance music", "people dancing", "male singer", "saxophone harmony", "wooden xylophone", "bad sound quality", "home music video", "latin dance hits", "latin percussions", "medium tempo"] | 1 | gb8PG-5i5YI | 4040 |
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;