musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "e-guitar", musiccaps_author = 6 and musiccaps_names contains "Punk rock"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Crushing Day (Live) - Joe Satriani | An acoustic drumset plays a rock groove along with a bassline building the foundation of the song. Someone is playing a solo melody on an e-guitar. This recording is of poor quality. This song may be playing at a live concert. | 2007-05-19T20:38:22Z | lemoners | Footage of Joe playing Crushing Day live. He actually played it during this 2002 Strange Beautiful Music tour webcast. Joe never plays Crushing Day live because it's "cursed". He says that every time he plays it live, someting goes wrong, like the rhythm speeding up, or him messing up on the difficult solo. Also, it's his only composed solo. Most others are improvised, which allows him to have more flexibility in his live performance. His band members usually don't like playing the song either because the rhythm section is quite boring for them. Enjoy this rare footage, sorry about the quality. | ["Music", "Punk rock"] | ["rock", "e-guitar", "e-bass", "acoustic drums", "uptempo", "amateur recording"] | 6 | I6wri5XQQbU | 1876 |
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;