musiccaps_details (view)
2 rows where musiccaps_names contains "Country" and musiccaps_names contains "Wedding music" sorted by musiccaps_author
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author ▼ | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Star Wars Theme - Double Bass Solo | This is an instrumental track featuring the double bass and acoustic guitar. Initially, chords are strummed on the acoustic guitar, and then arpeggio notes are played. The double bass is played with a bow and plays the leading melodic motif in the song. The song feels like it would be suitable in an adventure movie. | 2015-12-22T22:50:11Z | TESEO | Star Wars Theme - Double Bass Solo - Plays Francesco Tesei - New Fan Page https://www.facebook.com/Teseoguitar - SUBSCRIBE! http://www.youtube.com/user/teseoguitar?sub_confirmation=1 | ["Country", "Music", "Wedding music"] | ["double bass", "acoustic guitar", "guitar arpeggios", "fantasy", "exciting"] | 3 | X6Q53uXgaHc | 3161 | |
Sweet Memories- Tess Sears tribute to her mom Dawn Sears | The low quality recording features a classical live performance of sustained violin melody, shimmering hi hats, electric guitar melody, theremin solo melody and subtle female vocals at the end of the loop. There are some crowd clapping sounds in the background. It is noisy, in mono and it sounds passionate and emotional. | 2014-12-23T23:40:06Z | Tesla Dawn | Tess Sears sings her moms song Sweet Memories in memory of her mother Dawn Sears at the first Monday night Time Jumper meeting after her passing. | ["Singing", "Country", "Guitar", "Music", "Wedding music"] | ["classical", "sustained violin melody", "crowd clapping", "shimmering hi hats", "theremin solo", "subtle female vocal", "live performance", "electric guitar melody", "low quality", "noisy", "mono", "passionate", "emotional"] | 4 | -WvVG0wHcTc | 57 |
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;