musiccaps_details (view)
1 row where musiccaps_aspects contains "r&b/pop", musiccaps_aspects contains "synth pluck", musiccaps_aspects contains "triangle" and musiccaps_names contains "Singing"
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 |
---|---|---|---|---|---|---|---|---|---|---|
True Steppers Feat Dane Bowers & Victoria Beckham Out Of Your Mind Official Video | This song contains digital drums almost playing a drum&bass groove along with a triangle sound. A synth bass is playing a melody with digital strings in a higher key. A synth pluck is playing a short melody on top. A female voice is singing the main melody. This song may be playing in a 90/2000s club. | 2012-05-26T02:20:27Z | icecreamrecordstv | This track was first released on the 14th of August 2000. After their release of Buggin feat Dane Bowers True Steppers were just about to move up a gear, as journalistic spin ensued, they made front page news. Victoria Beckham was on the trail of The Steppers, and looking for that garage sound. Step in Posh and hold on tight, True Steppers 'Out Of Your Mind' feat Dane Bowers and Victoria Beckham was the biggest hyped record of 2000, going head to head for the number 1 spot with one of the biggest dance tracks in the last decade, Spiller feat Sophie Ellis Bextor. True Steppers sold over 50,000 records in the first day of release (unheard of these days) and kept the number 1 slot on mid-week sales until the very last day, ending up at no 2, selling just fewer than 200,000 records, in the first week alone. True steppers are Andy Lysandrou (Founder of Ice Cream Records) and Jonny L ( One of the best Drum and Bass producers) | ["Singing", "Music", "Exciting music"] | ["r&b/pop", "digital drums", "sub bass", "digital strings", "synth pluck", "triangle", "female voice singing", "higher pitch", "uptempo"] | 6 | Qf87MJcWZQI | 2634 |
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;