musiccaps_details (view)
3 rows where musiccaps_aspects contains "mid range" and musiccaps_aspects contains "uptempo" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- mid range · 3 ✖
- uptempo · 3 ✖
- e-bass 2
- acoustic drums 1
- acoustic piano 1
- amateur recording 1
- backing vocals 1
- bongos 1
- cowbell 1
- drums 1
- e-guitar 1
- e-guitars 1
- male and female voices singing 1
- male voice singing 1
- male voices singing 1
- maracas 1
- maxican folkrock 1
- organ 1
- percussions 1
- popmusic 1
- salsa 1
- tambourine 1
- uplifting mood 1
musiccaps_names (array) 10 ✖
- Music 3
- Music of Latin America 2
- Afrobeat 1
- Disco 1
- Music of Africa 1
- Reggae 1
- Salsa music 1
- Singing 1
- Ska 1
- Tambourine 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mothers Day Special Service by Denver Tamil Church - Tambourine Praise dance | A drum is playing a four on the floor groove with a kick on every beat along to a bassline and a tambourine. Two e-guitars are strumming funky sounding chords. Male singers are singing a melody together in the mid-range. This song may be playing live at a local event. | 2012-05-09T06:42:04Z | Denver TamilChurch | Tambourine Praise dance by: Sis.Yolanda Moses Music from VIDUTHALAI album by Bro Moses Maharaja www.DenverTamilChurch.Org | ["Singing", "Music", "Ska", "Tambourine", "Music of Latin America"] | ["popmusic", "e-guitars", "drums", "tambourine", "male voices singing", "mid range", "e-bass", "amateur recording", "uptempo"] | 6 | HDSV7Pzq8CA | 1780 | |
RAGS & RICHES - EL WATUSI LA BAMBA (SPECIAL DANCE MIX VERSION) | This song contains acoustic drums playing a kick on every beat and playing the hi hat with 16th notes. An e-bass is playing a simple line along with an organ sound in the background. Percussions are adding rhythms that want to make you dance. An e-guitar is playing another melody while the male and female voices are singing together creating harmonies. This song may be playing at a beach bar. | 2011-10-20T12:18:29Z | Marty Cruz | Label: Casablanca Records Format: Vinyl, 12" Country: US Released: 1983 Genre: Funk / Soul Style: Disco Tracklist ▼. A Medley: TT 22:07 B EL Watusi-La Bamba (Disco Version) 6:42 | ["Afrobeat", "Music of Africa", "Disco", "Music", "Reggae"] | ["maxican folkrock", "acoustic drums", "percussions", "e-guitar", "organ", "male and female voices singing", "mid range", "e-bass", "uptempo", "uplifting mood"] | 6 | CJjyrDGmxIY | 1350 | |
angel bonne - Si faltas tu - letra | This salsa song contains percussive elements as maracas,cowbell and bongos creating a typical salsa rhythm spread across both sides of the speakers. An e-bass is playing a complex walking bassline. An acoustic piano is playing a melody up and down the scales along with backing vocals singing in harmony as a countermelody to the male lead voice singing in the midrange. This song may be playing in a latin bar. | 2010-02-11T04:19:51Z | Beto Mina | para los verdaderos amantes de la musica cubana, una excelente cancion de un icono de la timba cubana. espero que la disfruten cancion: Si faltas tú interprete: Angel Bonne album: Pa' decir lo que siento año: 1995 | ["Music", "Music of Latin America", "Salsa music"] | ["salsa", "cowbell", "bongos", "maracas", "acoustic piano", "backing vocals", "male voice singing", "mid range", "uptempo"] | 6 | gsEk62Efbh4 | 4063 |
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;