musiccaps_details (view)
1 row where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "racing car sounds" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
Ferrari 458 Best Car Commercial Engine Start Exhaust Sound Classic - New Carjam Radio 2011 | This audio clip features programmed percussion playing a trap beat. Hi-hats are played at a very fast tempo. The kick drum plays continuously in eighth notes. The sound of racing cars is the main point of focus in this clip. There are no voices. There are no other instruments and no melody. | 2011-09-02T08:52:42Z | CARJAM TV | Carjam Car Radio Show -- A Car Show About People Website: http://www.kclr96fm.com/presenters?id=531 Twitter: http://www.twitter.com/carjamradio Youtube: http://www.youtube.com/user/CarjamRadio carjamradio "car jam radio" "car radio show" "car talk radio show" "carjam" ferrari "car talk" "bbc top gear" "great car ad 2011" "funny commercials 2011" "banned car commercials 2011" f1 "formula one" "funny videos" "classic cars" evo "best car ads 2011" "funny car ads 2011" funniest "fail" "sexy car ad 2011" "road test" "road review" "car test" "road report" "driving test" hot sexy new nissan fast Porsche suv "celebrity car" maserati vw audi 4x4 estate lotus fiat "alfa romeo" subaru toyota ford impreza "high speed" "tractor" "rally car" crashes accidents | ["Music", "Accelerating, revving, vroom", "Race car, auto racing", "Medium engine (mid frequency)"] | ["trap beat", "instrumental", "racing car sounds", "no voices", "minimal instruments"] | 0 | OZv8mtQEgA0 | 2448 |
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;