musiccaps_details (view)
3 rows where "youtube_published" is on date 2011-09-18 sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 41 ✖
- energetic 2
- acoustic piano 1
- addictive 1
- animated piano 1
- bouncy 1
- brass band 1
- brass instruments 1
- bright trumpet 1
- buoyant 1
- buzzy groovy synth bass 1
- congas 1
- dance music 1
- echoing passionate female vocal 1
- enthusiastic 1
- enthusiastic drumming 1
- fast tempo 1
- female voice singing 1
- groovy 1
- groovy bass lines 1
- indie/alternative 1
- keyboard harmony 1
- latin dance music 1
- latin folk 1
- latin music 1
- latin pop 1
- laughter 1
- lively piano 1
- male singer 1
- passionate 1
- pop-ballad/comedy 1
- punchy kick 1
- slow tempo 1
- soft claps 1
- spanish guitar 1
- synth keys chords 1
- tinny off beat percussion 1
- upbeat 1
- vibrant 1
- vigorous 1
- world music 1
- youthful 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
鐵獅玉玲瓏-你著忍耐Prohibition of laughter 曾寶儀Bowie Tseng P.1 | A female voice is singing emotionally along to an acoustic piano. In the background you can hear people laughing. This song may be playing in a tv-show. | 2011-09-18T17:26:26Z | opqaa | 這一次要忍耐的是 曾寶儀Bowie Tseng | ["Music of Asia", "Music", "Chuckle, chortle"] | ["pop-ballad/comedy", "acoustic piano", "female voice singing", "laughter", "slow tempo"] | 6 | S7TYAcOEPt4 | 2740 | |
Toño Rosario-El Hot Dog | A male vocalist sings this lively Latino song. The tempo is fast with an animated piano accompaniment, bright trumpets, energetic and rhythmic drumming, groovy bass and keyboard. The song is energetic, lively, buoyant, bouncy, vibrant and vivacious with a dance groove. This song is Latin Pop. | 2011-09-18T02:16:01Z | TheBombers27 | ["Music", "Music of Latin America", "Salsa music"] | ["male singer", "fast tempo", "brass band", "brass instruments", "vibrant", "animated piano", "youthful", "buoyant", "bouncy", "enthusiastic", "energetic", "vigorous", "latin music", "bright trumpet", "groovy bass lines", "keyboard harmony", "enthusiastic drumming", "spanish guitar", "upbeat", "latin pop", "latin dance music", "latin folk", "lively piano", "world music", "congas", "dance music", "latin pop"] | 7 | vMU7ZKY2Eso | 5174 | ||
Lossy - Rain Came Down | The Alternative/Indie song features an echoing, passionate female vocal singing over groovy, buzzy synth bass, punchy kick, soft claps, tinny offbeat percussion and synth keys chords that appear at the end of the loop. It sounds groovy, energetic, passionate and addictive. | 2011-09-18T12:27:21Z | miroNZ1983 | http://lossylossylossy.tumblr.com http://soundcloud.com/lossylossylossy | ["Music", "Rhythm and blues", "Drum machine"] | ["indie/alternative", "echoing passionate female vocal", "soft claps", "tinny off beat percussion", "punchy kick", "buzzy groovy synth bass", "synth keys chords", "energetic", "groovy", "passionate", "addictive"] | 4 | fpVlYpgTKZI | 3979 |
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;