musiccaps_details (view)
1 row where musiccaps_names contains "Bass guitar", musiccaps_names contains "Music" and "youtube_published" is on date 2014-01-25
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 |
---|---|---|---|---|---|---|---|---|---|---|
Sadowsky & DNA Amps 1350 Bass Groove at Bass Club Chicago by Shaun Gotti | The low quality recording features a buzzy bass guitar playing. It sounds passionate, even though the recording is very noisy. | 2014-01-25T02:16:37Z | Bass Club Chicago | http://www.bassclubchicago.com I was in the process of shooting a demo on the DNA Amps 1350 Bass head and Lawrence Calloway (AKA Shaun Gotti) came into the store. I was able to capture him trying out a few different Sadowsky Basses. Shaun is a MONSTER player and I was lucky enough to capture some of his madness. The Basses he played are listed below. DNA 1350 bass demo will soon follow. Youre hearing a 50/50 split of DI & Mic. At certain points in the demo, the mic was a few feet away from the cab, I wasnt prepared to start shooting when he got there. I basically plugged him in and capture him groovin on the fly. Sadowsky RV5 : https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=SADMETRORV5BLACK Sadowsky M5-24 : https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=SadowskyModernW DNA 1350 Head: https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=DNA1350 DNA 210 Cab: https://www.bassclubchicago.com/ProductDetails.asp?ProductCode=DNADNS210 Contact us at: (773) 561-3521 if you have any questions. Be sure to check out our website at: http://www.bassclubchicago.com Video Shot & Edited by http://www.JodyMichaelMiller.com Friend us on Facebook! http://www.facebook.com/bassclubchicago Follow us on Twitter http://www.twitter.com/bassclubchicago Follow us on Instagram http://www.instagram.com/bassclubchicago | ["Bass guitar", "Electric guitar", "Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument"] | ["low quality", "noisy", "buzzy bass guitar", "passionate"] | 4 | iePMcLYozYY | 4212 |
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;