musiccaps_details (view)
3 rows where musiccaps_aspects contains "spirited" and musiccaps_names contains "Sad music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 55 ✖
- instrumental music 3
- spirited · 3 ✖
- movie soundtrack 2
- philharmonic orchestra 2
- slow tempo 2
- string section harmony 2
- a great adventure 1
- against all odds 1
- aggressive 1
- bell tones 1
- calming 1
- cellos playing lower register 1
- children’s movie 1
- composer 1
- concert hall 1
- conductor 1
- distorted tones 1
- documentary soundtrack 1
- echoes 1
- electric guitar lead 1
- emotional 1
- exciting 1
- experimental 1
- fight the good fight 1
- goofing around 1
- guitar overtones 1
- guitar practice routine 1
- hard metal 1
- heart felt 1
- inspiring 1
- jarring tones 1
- keyboard harmony 1
- medium tempo 1
- motivational 1
- never give up 1
- never say die 1
- no 1
- no other instrumentation 1
- no percussion instrumentation 1
- nostalgia 1
- passion 1
- passionate 1
- percussion instruments 1
- playing alone 1
- playing rhythmically 1
- poignant 1
- poor audio quality 1
- rebellious 1
- relaxing 1
- rock music 1
- romance 1
- steady drumming rhythm 1
- strong bass line 1
- trudge along 1
- violin playing emotionally 1
musiccaps_names (array) 4 ✖
- Music 3
- Sad music · 3 ✖
- Distortion 1
- Electric guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
You will never win if you never begin(Nick Vujicic: Life Without Limbs).wmv | The song is an instrumental. The tempo is slow with a lion playing an emotional solo, string section harmony, strong drumming rhythm and a steady bass line. The song is emotional and inspiring. The audio quality is poor. | 2011-01-21T20:42:38Z | 89chatty | The man originally born to win life. | ["Music", "Sad music"] | ["instrumental music", "violin playing emotionally", "never say die", "string section harmony", "slow tempo", "steady drumming rhythm", "echoes", "keyboard harmony", "philharmonic orchestra", "strong bass line", "inspiring", "motivational", "poor audio quality", "poignant", "spirited", "passionate", "documentary soundtrack", "movie soundtrack", "never give up"] | 1 | KxjiEi2Eywk | 2135 | |
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 | |
Kirby's Epic Yarn: Fanmade boss battle music (intro) | The song is an instrumental. The song is medium tempo with an overdriven guitar playing a jarring lead in rhythmic fashion and guitar over tones that sound like bell tones. The song is aggressive and experimental. The song is a modern rock intro. | 2010-06-20T16:06:40Z | joinmebowser9000 | the title says it all. maybe its to heavy for this kirby game xD | ["Electric guitar", "Music", "Distortion", "Sad music"] | ["electric guitar lead", "distorted tones", "experimental", "playing alone", "guitar practice routine", "no percussion instrumentation", "goofing around", "instrumental music", "playing rhythmically", "guitar overtones", "no", "percussion instruments", "jarring tones", "bell tones", "rock music", "exciting", "spirited", "rebellious", "aggressive", "no other instrumentation", "medium tempo", "hard metal"] | 1 | rfah0bhmYkc | 4893 |
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;