musiccaps_details (view)
3 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "percussive 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 |
---|---|---|---|---|---|---|---|---|---|---|
BILLA 2 Theme music [Original sound track] | The song is an instrumental music section. The song is medium tempo with a string section playing percussively with violins and cellos in harmony, flute playing a melancholic solo, percussive hits and steady bass line. The song is full of suspense and passion. The song is a Tamil movie instrumental soundtrack. | 2012-05-02T14:19:34Z | Palani Kumar | ["Theme music", "Music"] | ["instrumental music", "string orchestra", "ominous music", "movie soundtrack", "emotional", "passionate", "spirited", "flute playing poignantly", "medium tempo", "steady drumming", "cellos playing percussively", "strong harmony", "trumpets playing furiously", "suspense", "tamil movie soundtrack", "average sound quality", "majestic and scary", "percussive hits"] | 1 | fRpJfrfjoZo | 3947 | ||
06) Stopping Cecil - The Secret is Out Part 1 | The song's instrumental tempo is slow with various percussive hits, harp playing and a French horn playing a gentle yet strong melody. The song is emotional and full of hope. The song is an adventure movie soundtrack. | 2010-11-13T07:49:38Z | Deadpool Fan | Created by Alan Silvestri Music From Night at the Museum and Night At the Museum Soundtrack I just organized it the way it's setup in the movie. I take no credit at all for this. | ["Brass instrument", "French horn"] | ["french horn plays", "philharmonic orchestra", "horn section", "rhythm section", "western classical music", "emotional", "adventurous", "instrumental music", "opera hall", "harp plays", "slow tempo", "percussive hits", "mysterious", "an incredible journey", "mysterious", "happy", "positive", "hopeful", "various percussive hits", "movie soundtrack"] | 1 | m4bBsvuS4EU | 4444 | |
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;