musiccaps_details (view)
2 rows where musiccaps_aspects contains "against all odds" and musiccaps_aspects contains "instrumental music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- against all odds · 2 ✖
- instrumental music · 2 ✖
- movie soundtrack 2
- philharmonic orchestra 2
- a great adventure 1
- adventure 1
- animated movie 1
- calming 1
- cellos playing lower register 1
- children’s movie 1
- composer 1
- concert hall 1
- conductor 1
- cyberwars 1
- dangerous game 1
- emotional 1
- fight the good fight 1
- fight the machines 1
- heart felt 1
- keyboard accompaniment 1
- medium tempo 1
- nostalgia 1
- ominous 1
- passion 1
- percussion hits 1
- poor audio quality 1
- relaxing 1
- romance 1
- sci-fi movie 1
- slow tempo 1
- sonic effects 1
- spirited 1
- string section harmony 1
- super hits 1
- ticking clock percussions 1
- trudge along 1
- various percussion effects 1
- various sound effects 1
musiccaps_names (array) 3 ✖
- Music 2
- Sad music 1
- Scary music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Nausicaä of the Valley of the Wind Soundtrack 2 | The song is an instrumental. The song is slow tempo with a philharmonic orchestra playing a string section harmony, lower register harmony Ina lilting manner. The song is emotional and heartfelt. The song is a movie soundtrack. | 2010-08-20T02:55:43Z | MyCrunchyCookie | Second part to the Nausicaa soundtrack. :) Hope you like it!!! Rate, Fave and Sub!!! Please??? :) | ["Music", "Sad music"] | ["instrumental music", "slow tempo", "calming", "philharmonic orchestra", "composer", "conductor", "concert hall", "string section harmony", "cellos playing lower register", "a great adventure", "nostalgia", "passion", "romance", "spirited", "trudge along", "fight the good fight", "against all odds", "relaxing", "emotional", "movie soundtrack", "children’s movie", "heart felt"] | 1 | bt8iHoIf2mo | 3664 | |
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;