musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_author = 9 and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- amateur recording · 2 ✖
- acoustic drums 1
- afro cuban dance 1
- bass guitar 1
- bongo 1
- conga 1
- electric guitar 1
- groovy 1
- guitar solo 1
- hard 1
- instrumental 1
- lively 1
- male vocals 1
- percussion 1
- piano 1
- raw 1
- rock music 1
- street performance 1
- timbale 1
- vibrant 1
musiccaps_names (array) 5 ✖
- Blues · 2 ✖
- Music 2
- Dance music 1
- Speech 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Afro Cuban Rumba music and dance -- havana, cuba | This is an amateur recording of an Afro-cuban dance music performance. There are male vocals singing joyfully. There is a percussion orchestra made up of diverse elements such as the conga, the bongo and the timbales are playing in the rhythmic background. The atmosphere is lively and vibrant. Although the audio quality is not that great, this piece can still be sampled for use in beat-making. | 2009-03-26T00:28:54Z | mathmuse | live at the palenque -- vedado, havana, cuba | ["Blues", "Traditional music", "Music", "Speech", "Dance music"] | ["afro cuban dance", "amateur recording", "street performance", "male vocals", "percussion", "conga", "bongo", "timbale", "lively", "vibrant"] | 9 | 07mS0mSTDjY | 124 | |
Journey - "Lights" guitar solo | This is an amateur recording of a guitar solo for a rock music piece. The solo is being played on an overdriven electric guitar while the piano and the bass guitar in the backing track play the main tune. There is a 6/8 rock beat played on the acoustic drums for the rhythm section. There is a raw feel to it. The piece can be used to gather electric guitar samples to be used in beat-making. | 2009-08-16T15:44:28Z | ChuckieVeee | Journey - "Lights" guitar solo played on an Epiphone Prophecy GX through a Roland Micro Cube | ["Blues", "Music"] | ["amateur recording", "rock music", "instrumental", "electric guitar", "guitar solo", "bass guitar", "piano", "acoustic drums", "groovy", "hard", "raw"] | 9 | s2GctT6NuyQ | 4917 |
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;