musiccaps_details (view)
2 rows where search matches "guitar" and "youtube_published" is on date 2010-11-08
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- acoustic guitar 1
- bass guitar 1
- brass section 1
- electric guitar 1
- gentle 1
- instrumental 1
- latin percussion 1
- mellow 1
- music to dance to 1
- no singer 1
- optimistic 1
- piano 1
- poor quality 1
- salsa genre 1
- strings 1
musiccaps_names (array) 6 ✖
- Music 2
- Bluegrass 1
- Echo 1
- Music of Latin America 1
- New-age music 1
- Salsa music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shout to the Lord - American Sign Language | This is a poor quality instrumental piece played in the background of a sign language video. There is an optimistic sounding tune being played by the strings, the piano and the acoustic guitar. The atmosphere is mellow and gentle. Samples from this piece could be lifted to be used in beat-making. | 2010-11-08T21:09:46Z | Ag00dgranma | Class, here is our new song for class. Sorry it took me so long to get it up. Hope you enjoy and happy signing. | ["Echo", "New-age music", "Music"] | ["poor quality", "no singer", "instrumental", "piano", "strings", "acoustic guitar", "gentle", "mellow", "optimistic"] | 9 | -RYtUAsNhF0 | 46 | |
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 |
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;