musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording" and "youtube_published" is on date 2006-11-06
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- amateur recording · 2 ✖
- acoustic guitar 1
- aerophone 1
- background score 1
- background voices 1
- banjo 1
- besame mucho 1
- bluegrass 1
- congas beat 1
- free reed aerophone 1
- free reed instrument 1
- french harp 1
- harmonica 1
- instrumental 1
- latin songs 1
- lively accompaniment music 1
- medium tempo 1
- medium to uptempo 1
- muffled audio 1
- popular spanish songs 1
- spanish melody 1
- upright bass 1
- wind instrument 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bluegrass jam ( Rebecca) | An acoustic guitar is strumming chords while a banjo is playing a fast melody over it. In the background you can hear an upright bass playing a fast walking bassline. Also in the background noises of people speaking can be heard. This song may be playing live on the streets performed by buskers. | 2006-11-06T22:08:09Z | monrobro | Jamming at Memramcook Festival with True Blue Banjo- Dominic Cormier Bass- Jean-Marc Boucher Mandolin- Ron Girouard Guitar- 1st Break Michael Alain Guitar- 2nd Break Richard Bourque | ["Banjo", "Country", "Guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument", "Bluegrass"] | ["bluegrass", "amateur recording", "banjo", "acoustic guitar", "upright bass", "background voices", "medium to uptempo"] | 6 | 669Fk7afszw | 724 | |
Harmonica - Besame Mucho | This music is a soulful instrumental. The tempo is medium with a harmonica melody with a background track which is muffled. The melody is of a popular Spanish Classic song. This music is a Harmonica instrumental of Besame Mucho. | 2006-11-06T21:32:19Z | alliax | CLICK http://www.ALLIAX.net Besame Mucho played on a chromatic harmonica. If you play the harmonica and have videos on YouTube then join the Harmonica Group: http://www.youtube.com/group/harmonica | ["Harmonica", "Wind instrument, woodwind instrument"] | ["instrumental", "medium tempo", "harmonica", "french harp", "free reed instrument", "wind instrument", "aerophone", "free reed aerophone", "lively accompaniment music", "besame mucho", "popular spanish songs", "latin songs", "spanish melody", "background score", "muffled audio", "amateur recording", "congas beat"] | 7 | JtLNRHVGQuw | 2043 |
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;