musiccaps_details (view)

4 rows where musiccaps_author = 2 and musiccaps_names contains "Music of Latin America"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
DR. RING DING - "Latin Goes Ska" The instrumental music features a medium sized band playing Latin music. The melody is being played in unison by the saxophones, trumpets and trombones in an almost fast tempo. A bass guitar is playing repeating lines in the low register. The drums play a busy rhythm. An electric guitar is playing a chord on the second half of every beat. 2012-01-16T08:38:37Z thegroverrecords Album - DANDIMITE www.moskito-mailorder.com ["Swing music", "Funk", "Music", "Music of Latin America", "Salsa music"] ["trumpets", "saxophones", "trombones", "drums", "bass guitar", "electric guitar", "instrumental", "no voice", "latin music", "almost fast tempo"] 2 CuUu6L5hhMs 1412
Little girls dancing to Hello Good Morning/wobble (trimmed) The hip-hop music features a male voice singing repetitive short bits of melody. The music excerpt contains a strong beat rhythm which drives the pulsation of the music. A synth sound is playing a repeating melody throughout the passage. The music sounds as if it was recorded by a phone from a playing speaker. 2010-10-11T01:45:52Z Mooruneque Texas Girls Fair, Dallas texas ["Disco", "Music", "Rock and roll", "Music of Latin America"] ["male voice", "hip-hop beat", "synth sound", "speakers", "hip-hop genre"] 2 MVq9PYtypy0 2275
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
Rusty Frank tap dances at the Cicada Club The jazz music features a swing band playing in the background. In the foreground one can hear tap dancing sounds and the crowd cheering. This and the low audio quality leads me to believe this is a recording of a live tap dancing show. 2007-07-04T16:41:40Z Rusty Frank Sunday, July 1st 2007, Rusty Frank tap dances to the sounds of the Dean Mora Orchestra at Maxwell DeMille's Cicada Club ["Music", "Tap", "Music of Latin America"] ["crowd cheering", "tap dancing sounds", "swing music", "jazz genre", "low quality audio recording"] 2 vDrbslhtX8o 5164

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;