musiccaps_details (view)
3 rows where "youtube_published" is on date 2007-08-30 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- acoustic guitar 1
- afro-cuban 1
- continuous drone 1
- cover 1
- dance 1
- deep bass sound 1
- didgeridoo 1
- energetic 1
- folk 1
- latin dance 1
- latin percussion 1
- lively 1
- low pitch 1
- low quality 1
- low quality recording 1
- male vocals 1
- no percussion 1
- no voices 1
- noisy 1
- passionate 1
- pedal tapping noise 1
- r&b/soul 1
- repetitive melody 1
- resonant sound 1
- soulful 1
- steel guitar solo melody 1
- upright bass 1
- vibrant 1
- wind instrument 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel ▼ | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
LEGENDARY MUSICIANS OF OLD HAVANA Pt 3 | This is an afro-cuban folk music compilation. There are male vocals singing in an energetic manner. There are acoustic guitars playing the main themes while upright bass is used for the lower range. The rhythmic background is provided by a variety of latin percussive instruments. There is a vibrant atmosphere. Parts of this recording can be used in latin dance courses as accompaniment pieces. | 2007-08-30T02:04:47Z | chak bay Grande | MORE of Alma de Cuba with Angel Abreu singing Meneame la cuna and El Manisero | ["Flamenco", "Music"] | ["afro-cuban", "folk", "latin dance", "male vocals", "acoustic guitar", "upright bass", "latin percussion", "dance", "vibrant", "energetic", "lively"] | 9 | 6AC84nr6ckM | 732 | |
yidaki didjeridoo | This instrumental song is played on a didgeridoo. This is a continuous drone sound which is resonant and played in a low pitch. There is no percussion in this song. The instrument is played in a repetitive pattern producing low sounds with higher pitched vibrating sounds inter-spread in between notes. There are no voices in this song. | 2007-08-30T21:47:28Z | febi51 | un semplice tubo ricavato da un ramo vuoto. con una sola nota. a queste condizioni bisogna per forza essere creativi. | ["Didgeridoo", "Music"] | ["low quality recording", "didgeridoo", "deep bass sound", "resonant sound", "continuous drone", "low pitch", "no percussion", "wind instrument", "repetitive melody", "no voices"] | 0 | vWiq7n4yTAw | 5188 | |
Take Me As I Am | The low quality recording features a cover of an R & B/soul song and it consists of a steel guitar solo melody. There are some pedal tapping noises. Overall the recording is noisy and it sounds passionate and soulful. | 2007-08-30T00:32:01Z | jazzrone | steel guitar | ["Music", "Musical instrument", "Steel guitar, slide guitar", "Distortion"] | ["low quality", "noisy", "steel guitar solo melody", "r&b/soul", "cover", "pedal tapping noise", "soulful", "passionate"] | 4 | YOA1JOyd7cw | 3282 |
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;