musiccaps_details (view)
2 rows where musiccaps_aspects contains "keyboard accompaniment" and musiccaps_aspects contains "percussion hits"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- keyboard accompaniment · 2 ✖
- medium tempo 2
- movie soundtrack 2
- percussion hits · 2 ✖
- poor audio quality 2
- adventure 1
- against all odds 1
- animated movie 1
- asian soap opera 1
- cyberwars 1
- dangerous game 1
- emotional 1
- fight the machines 1
- hissing tones 1
- instrumental music 1
- love song 1
- male singer 1
- music video 1
- ominous 1
- philharmonic orchestra 1
- piano accompaniment 1
- romantic song 1
- sci-fi movie 1
- shakers percussions 1
- sonic effects 1
- subtle drumming 1
- super hits 1
- ticking clock percussions 1
- tv show theme 1
- various percussion effects 1
- various sound effects 1
musiccaps_names (array) 4 ✖
- Music 2
- Music of Asia 1
- Scary music 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mouse Loves Rice | A male singer sings this emotional melody. The song is medium tempo with shakers and other percussion, keyboard accompaniment and a subtle bass line. The audio quality is poor. The song is romantic and emotional.the song is probably a music video or a movie sound track. | 2008-10-01T08:57:41Z | tropicalhut6 | Tammy Chen And Ambrose Hsu | ["Music of Asia", "Music", "Song"] | ["emotional", "male singer", "poor audio quality", "asian soap opera", "medium tempo", "romantic song", "love song", "movie soundtrack", "music video", "percussion hits", "piano accompaniment", "subtle drumming", "shakers percussions", "keyboard accompaniment", "tv show theme", "hissing tones"] | 1 | W85w938G5ZM | 3069 | |
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;