musiccaps_details (view)
4 rows where musiccaps_aspects contains "brass section" and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- brass section · 4 ✖
- bass 1
- bass guitar 1
- bongos 1
- busy percussion 1
- cheery 1
- claves 1
- congas 1
- cowbell 1
- crowd chattering 1
- electric guitar 1
- fun 1
- hand percussion 1
- happy 1
- latin 1
- latin percussion 1
- latin pop 1
- lively male singer 1
- low quality 1
- male voice 1
- melodic female vocal 1
- mono 1
- music to dance to 1
- noisy 1
- percussion 1
- piano 1
- romantic mood 1
- salsa genre 1
- slow dance song 1
- string bass 1
- syncopated bass 1
- trombone 1
- tumbao 1
- upbeat 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Orq. Bronco - Duena De Mi Cuerpo | This Latin pop song features a male voice singing the main melody. The voice sings at a high pitch. This is accompanied by Latin style percussion. A variety of percussion is used including the claves and cowbell. The bass plays a groovy bassline. The piano plays chords with a Latin feel. The brass section plays fills in between lines. This song has a romantic mood. This song can be played in a party for a slow dance. | 2010-03-26T03:09:29Z | EdwardMulenze | gran orquesta venezolana de finales de los 80.. se caracteriza por la finura y la cuerda de sus trombones disfrutenlo... | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop", "male voice", "slow dance song", "bass", "percussion", "piano", "brass section", "romantic mood", "claves"] | 0 | 92QYLjfo68Q | 972 | |
Beginners Salsa Steps with Music - Walkbacks & Walkrounds | The salsa music features a melody being played by an electric guitar in unison with another instrument like flute or clarinet. The percussion is latin specific and drives the pulse of the music forward. A bass guitar alternates between playing the melody in unison with the electric guitar and playing something different. At the end of the music excerpt a brass section can be heard playing a short accentuated melody. | 2010-11-08T20:47:46Z | SalsaMish | Salsa Mish & Aiste demonstrating beginners - intermediates salsa steps to a beautiful slow Salsa song from Palenke. By far the best way to learn these moves is to come along to Salsa Mish's classes at Greenwood Park, St Albans - every Friday night. You will have a great time, meet lots of friendly people, hear some fantastic music and lose any inhibitions you may have in no time. See www.salsamish.co.uk for details. | ["Music", "Music of Latin America", "Bluegrass", "Salsa music"] | ["latin percussion", "bass guitar", "brass section", "electric guitar", "music to dance to", "salsa genre"] | 2 | SkZ7mGbs3SI | 2786 | |
Jodłowanie w Maurzycach k. Łowicza. 2003 r. | The low quality recording features a mono recording located only in the right channel of the stereo image. It consists of at least brass section melody, shimmering cymbals and melodic female vocals. There are some crowd chattering noises too, but it sounds fun and happy. | 2009-03-18T20:56:59Z | Łowiczak123 | Występ kapeli po zakończeniu przemówienia prezydenta Kwaśniewskiego.Sorry za złą jakość dźwięku-mono. | ["Yodeling", "Music", "Music of Latin America"] | ["low quality", "mono", "noisy", "brass section", "melodic female vocal", "happy", "fun", "crowd chattering"] | 4 | _n9boKzVRhs | 3491 | |
Frankie Ruiz - Bailando | Cheery, upbeat Latin music featuring a lively male singer, busy percussion including hand percussion like bongos and congas as well as cowbell and more. String bass plays a syncopated tumbao rhythm while a brass section accompanies a trombone. | 2008-02-09T16:00:37Z | jjaime99 | Frankie Ruiz | ["Singing", "Music of Latin America"] | ["latin", "busy percussion", "brass section", "trombone", "lively male singer", "tumbao", "syncopated bass", "hand percussion", "bongos", "congas", "string bass", "cowbell", "upbeat", "cheery"] | 8 | w62KGC7um_Y | 5240 |
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;