musiccaps_details (view)
2 rows where musiccaps_aspects contains "strong drum rhythm" and musiccaps_author = 1
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- instrumental music 2
- strong drum rhythm · 2 ✖
- a great day 1
- adventure 1
- building anticipation 1
- dance all night 1
- dance club 1
- dance rhythm 1
- dj 1
- documentary soundtrack 1
- drum machine 1
- electronic dance music 1
- electronic synth hardware 1
- energetic 1
- good vibes 1
- groovy bass line 1
- groovy rhythm 1
- guitar accompaniment 1
- home studio sessions 1
- house party mix 1
- medium tempo 1
- modern pop instrumental 1
- movie soundtrack 1
- music demo 1
- new places 1
- passionate 1
- people dancing 1
- pop music 1
- positive 1
- rehearsal time 1
- sense of adventure 1
- senseof adventure 1
- shakers percussions 1
- slow tempo 1
- song introduction 1
- steady rhythm 1
- synth module 1
- trance music 1
- travel show 1
musiccaps_names (array) 7 ✖
- Music 2
- Drum machine 1
- Musical instrument 1
- Sampler 1
- Synthesizer 1
- Techno 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
sven liveset Techno jam elektron analog rytm | The song is an instrumental. The tempo is slow with a steady drum rhythm, various percussion hits and shakers playing percussively. The song is groovy and muted in the harmony section. The audio quality is average. | 2015-07-11T19:36:55Z | Sven Glania Musik Film Art | LIVE JAM TECHNO von sven Minimal Techno (Musical Genre) | ["Sampler", "Music", "Musical instrument", "Techno", "Drum machine", "Synthesizer"] | ["drum machine", "synth module", "instrumental music", "people dancing", "dj", "rehearsal time", "home studio sessions", "electronic synth hardware", "music demo", "strong drum rhythm", "trance music", "house party mix", "dance club", "dance all night", "groovy bass line", "shakers percussions", "steady rhythm", "slow tempo", "dance rhythm", "electronic dance music"] | 1 | EKt_KEbqQfQ | 1546 | |
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 |
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;