musiccaps_details (view)
1 row where musiccaps_aspects contains "advertisement music track", musiccaps_aspects contains "female singers", musiccaps_aspects contains "radio tuning signals" and musiccaps_aspects contains "tv spot"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Radio Receiver Software | The song has different music tracks played in succession. The song has guitar accompaniment and a groovy bass followed by female singer singing vocal chants with male backup singer in vocal harmony, on a groovy drum rhythm and keyboard harmony with white noise added. The song is probably an ad jingle. | 2012-09-27T10:44:13Z | SoftwareRadioOnline | http://linkclick.me/OnlineRadio ◄ Retail version (no ads) http://linkclick.me/FreeRadio ◄ Radio Receiver Software Enjoy 5,325 world Radio stations with No monthly fees! Listen to thousands of HQ radio stations from your computer! 2 minutes and your computer will become an amazing Music player! Turn your computer into a multi-channel WEB Radio! With our service you can listen to thousands of Radio stations from all over the world, Installation is simple and easy - in just a few seconds you will be able to listen to thousands of stations. Online Radio is the perfect solution, a simple and convenient alternative to Satellite Radio. Absolutely ZERO monthly costs -- Online Radio is free of any monthly charge or recurring monthly subscription. A lifetime license for free updates is included in this package. Thousands of stations - Select your favorites out of thousands international internet based stations from all over the world. No additional hardware required - This is software only, one that can be installed on any Internet enabled PC desktop or Laptop. There is no need to add additional hardware such as a Radio tuner or DVR card. Easy to use -- Everyone can use this. A simple interface makes it as easy as listening to your regular radio set! Works everywhere in the world --Listen to internet Radio with your PC in any country with Internet access. 100% Legal -- This software is not illegal in any way, as it streams all the free FREE web stations available on the Internet. Runs on Windows Platform -- Works smoothly on every PC running any version of the Microsoft Windows operating system including Windows 98, XP, Vista and Windows 7. A one time payment of less Than $15 and you can stream over thousands of web Radio stations free! A free Premier auto update license is included in this package. | ["Music", "Radio"] | ["guitar lead", "groovy bass line", "white noise", "medium tempo", "exciting", "passionate", "dance groove", "ad jingle", "radio tuning signals", "tv spot", "female singers", "male backup singers", "different keys", "steady drumming rhythm", "churchy audio signal", "vocal chanting", "groovy rhythm", "pop music", "advertisement music track", "different music tracks"] | 1 | 2FQKfGCwjSE | 342 |
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;