musiccaps_details (view)
2 rows where musiccaps_aspects contains "mellow", musiccaps_aspects contains "saxophone" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Meschiya Lake and the Little Big Horns-Luck Devil | This is a jazz music piece. There is a saxophone playing a jazzy solo for the melody. There is an upright bass playing in the background. The rhythmic background consists of a slow tempo acoustic drum beat that is played with brushes. The atmosphere is mellow. This piece could be playing in the background of a classy restaurant or a coffee shop. | 2011-03-06T05:41:05Z | raystewification | The Title Track from "Lucky Devil" Duplicated because youtube sucks. | ["Brass instrument", "Saxophone", "Wind instrument, woodwind instrument"] | ["jazz", "instrumental", "saxophone", "upright bass", "acoustic drums", "brushes", "mellow", "gentle", "slow tempo"] | 9 | 9UCLvFqkFxk | 1012 | |
Tamil Christian Song - Nee illatha by Hema John- Zion Music Festival '09 | A female vocalist sings this soft melody. The tempo is slow with violin harmony, keyboard accompaniment, saxophone, digital drum, tabla and tambourine beats. The song is mellow, soft, melodic, soothing, calming , devotional and euphonious. This song is a Tamil Christian Song. | 2010-11-04T07:04:36Z | endtimezionministry | http://www.endtimezionministries.org Through Him (Jesus) all things were made; without Him nothing was made that has been made. In Him was life, and that life was the light of all mankind. John:1:3,4 | ["Gospel music", "Music", "Independent music"] | ["female vocalist", "slow tempo", "foreign language", "wood wind", "rhythmic acoustic guitar", "tabla", "indian percussion", "tambourine", "indian music", "indian classical", "south indian music", "tamil music", "violin harmony", "digital drum", "saxophone", "soft melody", "mellow", "devotional", "christian music", "christian worship song", "tamil christian worship"] | 7 | ghW2xZMvpIQ | 4046 |
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;