musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental music", musiccaps_aspects contains "passionate" and musiccaps_aspects contains "song introduction"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- instrumental music · 2 ✖
- medium tempo 2
- passionate · 2 ✖
- song introduction · 2 ✖
- a great day 1
- acoustic song 1
- adventure 1
- ambient noises 1
- breathing sounds 1
- building anticipation 1
- classical music 1
- documentary soundtrack 1
- emotional 1
- energetic 1
- good vibes 1
- groovy rhythm 1
- guitar accompaniment 1
- hissing noises 1
- lilting 1
- modern pop instrumental 1
- movie soundtrack 1
- new places 1
- piano accompaniment 1
- poor audio quality 1
- pop music 1
- pop song 1
- positive 1
- rustling tones 1
- school recital 1
- sense of adventure 1
- senseof adventure 1
- spirited 1
- strong drum rhythm 1
- travel show 1
- vocal recital 1
musiccaps_names (array) 3 ✖
- Music 2
- Rustling leaves 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Walk Across America - Behind the Scenes | The song is an instrumental. The tempo is medium with a guitar accompaniment and leads into a strong drumming rhythm and bass line. The song is exciting and energetic. The song is a movie soundtrack for a travel show or a documentary. | 2010-07-21T22:40:16Z | walkUSA | Here is how we created Guy Walks Across America. You can see our entire route on Google Maps here: http://bit.ly/brNULW Music - "Down River" by The Temper Trap http://www.thetempertrap.com | ["Music", "Ukulele"] | ["instrumental music", "song introduction", "travel show", "new places", "senseof adventure", "a great day", "positive", "good vibes", "pop music", "adventure", "sense of adventure", "building anticipation", "groovy rhythm", "energetic", "passionate", "movie soundtrack", "guitar accompaniment", "strong drum rhythm", "modern pop instrumental", "documentary soundtrack", "medium tempo"] | 1 | cp8t27oT_ww | 3746 | |
Madison sings Who Has Seen the Wind | The song is an instrumental. The tempo is medium and has a piano accompaniment. The song has a lot of ambient noises like hissing, breathing and hushed tones. The song is emotional but of poor audio quality. | 2009-04-27T16:51:17Z | lmsouthern | Madison sings her competition solo, Who Has Seen the Wind, at the Choir Concert April 26th. | ["Music", "Rustling leaves"] | ["ambient noises", "piano accompaniment", "emotional", "lilting", "vocal recital", "passionate", "spirited", "classical music", "pop song", "acoustic song", "breathing sounds", "rustling tones", "instrumental music", "hissing noises", "poor audio quality", "school recital", "song introduction", "medium tempo", "classical music"] | 1 | oJyyNWuyig4 | 4616 |
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;