musiccaps_details (view)
5 rows where "youtube_published" is on date 2011-10-11 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 43 ✖
- amateur playing 1
- amateur rock band 1
- ambient music 1
- autotuned vocal 1
- background ad-libs 1
- background shouting 1
- brass instruments 1
- casual rock 1
- chill-out music 1
- classic rock influences 1
- conga 1
- differing tones 1
- digital drums 1
- e-piano 1
- echo tones 1
- female voice singing 1
- filler music 1
- flat male vocal 1
- groovy bass line 1
- guitar lead 1
- happy 1
- higher key 1
- home recording 1
- keyboard harmony 1
- low quality 1
- medium to uptempo 1
- modern pop 1
- mono 1
- noisy 1
- out of time 1
- pop 1
- random percussion 1
- reggae style rhythm 1
- relaxing 1
- shaker 1
- slow tempo 1
- south asian dance music 1
- speaking 1
- steady drumming rhythm 1
- synth keys melody 1
- trumpets 1
- tutorial 1
- vibrant 1
musiccaps_names (array) 16 ✖
- Music 3
- Distortion 1
- Drum 1
- Electric guitar 1
- Electric piano 1
- Keyboard (musical) 1
- Music of Africa 1
- New-age music 1
- Percussion 1
- Piano 1
- Reggae 1
- Rock music 1
- Sad music 1
- Song 1
- Steel guitar, slide guitar 1
- Tabla 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gonder | The song is a traditional south asian dance song with clear reggae influences. It is upbeat, vibrant and features bouncy reggae percussion. There are brass instruments playing cheerful motifs, and the lead singer has reverb and ample autotune applied to his vocal. There's a background vocalist adding shouted ad-libs to the song. | 2011-10-11T01:52:05Z | Addis | ["Music of Africa", "Music", "Reggae", "Song"] | ["south asian dance music", "reggae style rhythm", "brass instruments", "trumpets", "autotuned vocal", "background shouting", "background ad-libs", "vibrant"] | 3 | L5Uu_0xEZg4 | 2152 | ||
Toques de Celular. Iphone/Nokia/Samsung (por Beto Veríssimo) | The low quality recording features a flat male vocal talking, after which there is a synth key melody playing. The recording is noisy, in mono and it sounds happy. | 2011-10-11T03:54:45Z | Alberto Veríssimo | Os mais famosos toques de celular, por Beto Veríssimo no piano | ["Electric piano", "Keyboard (musical)", "Piano"] | ["synth keys melody", "flat male vocal", "low quality", "noisy", "mono", "happy"] | 4 | KauCO8zH5bw | 2098 | |
Relaxation Music Progressive Rock | The song is an instrumental music piece. The song is slow tempo with an electric guitar playing lead with heavy echoes, steady drumming and a keyboard harmony. The song is casual and slightly out of rhythm. The song is an instrumental with a casual listening vibe. | 2011-10-11T06:06:56Z | Gothenburg Music | Relaxation Music Progressive Rock, Rock jam and improvisation | ["Electric guitar", "New-age music", "Music", "Rock music", "Steel guitar, slide guitar", "Distortion"] | ["slow tempo", "guitar lead", "steady drumming rhythm", "filler music", "relaxing", "home recording", "chill-out music", "modern pop", "classic rock influences", "amateur rock band", "ambient music", "groovy bass line", "echo tones", "relaxing", "out of time", "amateur playing", "keyboard harmony", "casual rock"] | 1 | UrgzGbGVV8I | 2948 | |
Conga Lessons with Jerry Rivera | This is a tutorial on how to use the conga percussion instrument. The American tutor narrates his actions as he plays. There are two tones - the open tone is lower and the closed tone is higher pitched. | 2011-10-11T17:07:31Z | trueseven | Conga Lesson 1 with Jerry Rivera | ["Tabla", "Drum", "Percussion"] | ["conga", "tutorial", "speaking", "random percussion", "differing tones"] | 3 | xXRGgPVnkqk | 5338 | |
Alexz Johnson | Look At Those Eyes [Official Music Video] | This song contains an e-piano playing a major and minor chord melody along with a minimalistic digital drum groove that has a delay on it. A female voice is singing with a little reverb on her voice. The song sounds minimalistic. There is a lot of room for the voice to sing and for the other instruments. A shaker sound is spun to the right side of the speaker. This song may be playing with headphones running through the park. | 2011-10-11T19:34:57Z | Alexz Johnson | In cooperation with Kids Help Phone, fans can download the single "Look At Those Eyes" for free. It's a simple as that -- no email collections, accounts, etc. For every download, Alexz and her record company will donate 1 cent to the Kids Help Phone on-going fundraising efforts. Fans can access the free download at: http://www.indiscover.net/News.aspx?ID=10979 www.kidshelpphone.com Directed by Jason Romolo & shot by Kevin Hall [www.heartstringstv.com] Look At Those Eyes from Voodoo Reloaded available on itunes now. www.alexzjohnson.com www.twitter.com/alexzjohnson Alexz Johnson on Facebook: http://www.facebook.com/pages/Alexz-Johnson/18041967827 | ["Music", "Sad music"] | ["pop", "digital drums", "e-piano", "shaker", "female voice singing", "higher key", "medium to uptempo"] | 6 | 7YtKrL6ScXA | 857 |
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;