musiccaps_details (view)
1 row where musiccaps_aspects contains "keyboard", musiccaps_aspects contains "violin solo" and musiccaps_names contains "Wind instrument, woodwind instrument"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Bob Dylan Blackbushe 1978 Live Compilation - Best Sound Quality | This amateur recording features a classic song. This is an instrumental song featuring a violin solo. This is accompanied by percussion playing a simple beat. A keyboard plays chords in the background with fills in between bars. The bass plays the root note and the lower fifth of the chord. There are no voices in this song. Due to the low quality of sound, the other instruments are unclear. This song can be played in a classic movie. | 2011-01-10T02:05:36Z | BobDylanBlackbushe78 | I took along a new JVC CD-1635 Mk II portable recorder, 3 Fuji C90 cassettes and got a stiff arm holding a heavy microphone above the sea of heads for a very long set of great music. Harvey Goldsmith had not skimped on the PA system. The sound in the area I had picked was powerful and clear. Gusts of wind did not affect the recording quality. The original audio three cassettes are well preserved - in perfect condition. They are for sale on EBAY UK for a very reasonable price. Below is the list of tracks of snippets used in the video of the first nine songs of the set. This video contains excerpts of the following Bob Dylan songs: 1. My Back Pages (Instrumental) - Live Original 2. Love Her With A Feeling - Live Original 3. Baby Please Stop Crying - Live Original 4. Just Like Tom Thumb's Blues - Live Original 5. Shelter From The Storm - Live Original 6. It's All Over Now Baby Blue - Live Original 7. Girl From The North Country - Live Original 8. Ballad Of A Thin Man - Live Original 9. Maggie's Farm - Live Original Complete Set List 1. My Back Pages 2. Love Her With a Feelin' 3. Baby, Stop Crying 4. Just Like Tom Thumb's Blues 5. Shelter From the Storm 6. It's All Over Now, Baby Blue 7. Girl From the North Country 8. Ballad of a Thin Man 9. Maggie's Farm 10. Simple Twist of Fate 11. Like a Rolling Stone 12. I Shall Be Released 13. Is Your Love in Vain? 14. Where Are You Tonight? 15. A Change Is Gonna Come 16. Mr. Tambourine Man 17. The Long and Winding Road 18. The Man in Me 19. Gates of Eden 20. True Love Tends to Forget 21. One More Cup of Coffee (Valley Below) 22. Blowin' in the Wind 23. I Want You 24. Señor 25. Masters of War 26. Just Like a Woman 27. To Ramona 28. Don't Think Twice, It's All Right 29. All Along the Watchtower 30. All I Really Want to Do 31. It's Alright, Ma (I'm Only Bleeding) 32. Forever Young 33. Encore: Changing of the Guards 34. Encore: The Times They Are A-Changin' | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "classic rock", "violin solo", "keyboard", "live performance", "simple percussion", "moderate tempo"] | 0 | 0NZY0GHQBP0 | 155 |
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;