musiccaps_details (view)
2 rows where musiccaps_aspects contains "poor audio quality", musiccaps_aspects contains "sonic effects" and musiccaps_names contains "Scary music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- instrumental music 2
- medium tempo 2
- poor audio quality · 2 ✖
- sonic effects · 2 ✖
- adventure 1
- against all odds 1
- animated movie 1
- competition 1
- cyberwars 1
- dangerous game 1
- eerie harmonies 1
- fashion show tune 1
- fear 1
- fight the machines 1
- groovy music 1
- keyboard accompaniment 1
- movie soundtrack 1
- ominous 1
- percussion hits 1
- percussive hits 1
- philharmonic orchestra 1
- sci-fi movie 1
- show soundtrack 1
- stress 1
- strong bass line 1
- super hits 1
- suspense 1
- synth string pads 1
- tension 1
- ticking clock percussions 1
- various percussion effects 1
- various percussion hits 1
- various sound effects 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Transformers 3 Soundtrack #3 Lost Signal- Steve Jablonsky | The song is instrumental. The tempo is medium with a steady percussive rhythm, keyboard accompaniment, string section harmony and various sound effects. The song is ominous and full of suspense. The song is a movie soundtrack and has poor audio quality. | 2011-07-01T17:15:00Z | TheP1291pictures | soundtrack | ["Music", "Scary music"] | ["movie soundtrack", "sci-fi movie", "instrumental music", "poor audio quality", "various percussion effects", "dangerous game", "adventure", "against all odds", "fight the machines", "cyberwars", "animated movie", "super hits", "sonic effects", "philharmonic orchestra", "ticking clock percussions", "various sound effects", "percussion hits", "ominous", "instrumental music", "medium tempo", "keyboard accompaniment"] | 1 | zSq2D_GF00o | 5479 |
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;