musiccaps_details (view)
2 rows where musiccaps_names = "["Double bass", "Pizzicato", "Bowed string instrument"]"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
A First Look At The Stagg Electric Upright Bass | This music is instrumental. The tempo is medium with an intense electric upright double bass harmony. The music is dense, deep, powerful, full bodied and vibrant. | 2008-08-12T11:27:12Z | roger alcantara | The Stagg Electric Upright Bass | ["Double bass", "Pizzicato", "Bowed string instrument"] | ["instrumental", "medium tempo", "intense bass", "dense", "rich", "double elcetric bass", "classic acoustic string instrument", "jazz", "blues", "rock and roll", "intense", "full bodied"] | 7 | RJViDdqUYyo | 2692 | |
Godzilla Ultimate Fan Contest - Enter to Win! | The low quality recording features a filtered monster growl, followed by a wide arpeggiated synth. It sounds spooky and haunting. | 2014-04-08T19:11:29Z | Nerdist | Enter to Win at http://ultimatefancontest.godzillamovie.com Are you the ultimate Godzilla fan? Prove it! Get creative and send your videos showing why you are Godzilla's #1 fan! Prizing: The ultimate Godzilla fan from the US will be joining their #1 fan counterparts from around the world on a trip to London for the European premiere and press junket where the fans will get a chance to meet and interview director Gareth Edwards! Do: Get creative, stand out from the crowd. Show off what makes you the biggest fan. Don't: Use movie footage from the trailer or other Godzilla movies Use music that you did not create Do anything that puts yourself or anyone else in danger Subscribe for more from Nerdist: http://bit.ly/Sub2Nerdist Follow us on Twitter: https://twitter.com/NerdistDotCom Check out Nerdist.com: http://www.nerdist.com | ["Double bass", "Pizzicato", "Bowed string instrument"] | ["low quality", "filtered monster growl", "wide arpeggiated synth", "scary", "spooky", "haunting"] | 4 | pcOPueObfWs | 4727 |
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;