musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music", musiccaps_aspects contains "various percussion hits" and musiccaps_author = 1
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 |
---|---|---|---|---|---|---|---|---|---|---|
App Manager 3 / Apps to SD Review | The song is an instrumental. The tempo is medium fast with a strong techno drumming groove, strong bass line, keyboard harmony and various percussion hits. The song is energetic and passionate. The audio quality is poor. | 2013-12-01T06:21:53Z | RootJunky | App Manager 3 / Apps to SD review Link to Google Play App Manger 3 https://play.google.com/store/apps/details?id=com.a0soft.gphone.app2sd&hl=en Check out PhonLab E-Campus, if you want to learn tons more about Phone repairs tips and tricks to help you repair smartphones. https://phonlabtech.com/mobile-repair-tech/ How to install Android Device drivers http://youtu.be/j_KPGUMzrjU Why Root Android devices video http://youtu.be/6vqnnLnOn3g Android device hacking explained http://youtu.be/UUTwYHfmHv4 Universal UnRoot App for all Devices http://youtu.be/ySNStU8OTuk FOLLOW ME http://RootJunky.com www.facebook.com/rootjunky https://twitter.com/Tomsgt2 youtube.com/tomsgt123 google.com/+Tomsgt123 PLEASE READ Warning... do this at your own risk. I am happy to help with any problems my subscribers are having on their android devices. I am going to need lots of info from you to help. 1. What device you are on. 2. What android version you are running. 3. What custom rom or stock rom / build number you are on. 4. What you have done to the device. 5. What recovery system you are using. With this info I will be able to help much faster. | ["Didgeridoo", "Music"] | ["techno dance music", "grunge keyboard tones", "poor audio quality", "dance-off", "energetic", "trance music", "club mix", "dj", "dance floor", "people dancing", "retro techno music", "groovy music", "electronic dance music", "various percussion hits", "keyboard harmony", "home music studio", "strong bass line", "medium fast tempo", "techno drumming"] | 1 | 769EHEG4Mqc | 811 | |
Vivienne Mackinder demonstrates the latest techniques to create short style haircuts | The song is an instrumental. The tempo is medium with a keyboard accompaniment, sonic effects, various percussion hits, strong bass line and synth pad section. The song is eerie and full of tension. The song is tv show theme and has poor audio quality. | 2011-08-12T02:03:07Z | hikariscissors | Vivienne Mackinder is one of the most highly respected international leaders and innovators in the hairdressing profession today. In her work as Artistic Director for industry 'Grand Masters' Vidal Sassoon and Trevor Sorbie, Vivienne developed an expertise for precision cutting and an eye for original hair design, from the classic and the commercial, to the avant-garde. Based in New York City, she grew up in London and subsequently opted to 'spread her wings' to the United States. She has been honoured with numerous awards, including the prestigious IBS 'Editors' Choice Awards (three times). As well as, the much coveted North American Hairstyling Awards (NAHA) (five times), including "Masters." Honouree - North American Hair Styling Awards "Life Time Achievement" 2009. For more information on Vivienne Mackinder, please visit her website www.hairdesignertv.com. | ["Music", "Scary music"] | ["instrumental music", "suspense", "tension", "fashion show tune", "show soundtrack", "percussive hits", "strong bass line", "synth string pads", "eerie harmonies", "fear", "stress", "medium tempo", "sonic effects", "various percussion hits", "groovy music", "poor audio quality", "competition", "medium tempo"] | 1 | oC0e8GXYy_4 | 4610 |
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;