musiccaps_details (view)
2 rows where musiccaps_names contains "Soul music" and "youtube_published" is on date 2013-05-13
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- animated movie soundtrack 1
- battle march 1
- cartoon soundtrack 1
- double pedal kick 1
- drum & bass 1
- echoing vocal melody 1
- electric guitar harmony 1
- emotional 1
- energetic 1
- instrumental music 1
- manic 1
- manically played hi hats 1
- marching drum rhythm 1
- medium tempo 1
- poor audio quality 1
- punchy snare 1
- retro arcade game music 1
- retro pop music 1
- serious 1
- steady bass line 1
- string section 1
- string synth harmony 1
- uptempo 1
- victory march 1
- wide piano chords 1
- wide reverberant riser 1
- wide synth pad chords 1
musiccaps_names (array) 5 ✖
- Music 2
- Soul music · 2 ✖
- Background music 1
- Drum and bass 1
- Electronica 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
2013 BMW ActiveHybrid 3 M Sport engine sound and 0-100km/h | The Drum & Bass song features wide piano chords layered with wide synth pad chords, followed by echoing vocal melody at the beginning, double pedal kick, punchy snare and manically played hi hats. Right before the beat drops, there is a wide reverberant riser that lifts the energy of the track, preparing the listener for it. It sounds energetic, uptempo and manic - like something you would hear on commercials. | 2013-05-13T03:23:06Z | PDriveTV | 2013 BMW ActiveHybrid 3 M Sport engine sound and 0-100km/h. Head over to http://performancedrive.com.au/2013-bmw-activehybrid-3-m-sport-review-video/ for the full review. 2013 BMW ActiveHybrid 3 M Sport 3.0-litre turbo inline six-cylinder with 40kW/210Nm electric motor assist 250kW and 450Nm Eight-speed sports automatic with paddle shifters, rear-wheel drive 0-100km/h in 5.4 seconds (as tested) | ["Drum and bass", "Music", "Soul music", "Electronica"] | ["drum & bass", "wide piano chords", "echoing vocal melody", "double pedal kick", "punchy snare", "manically played hi hats", "wide reverberant riser", "wide synth pad chords", "manic", "energetic", "uptempo"] | 4 | 2zjtZYqg3Ow | 426 | |
Heavy Metal Veteran of the Psychic Wars | The song is an instrumental. The tempo is medium with a steady drum march rhythm, steady bass line, keyboard harmony and a synth string section. The song is Eros’s and emotional. The song has poor audio quality. | 2013-05-13T06:03:31Z | MARIO DANIEL DEMAYO | ["Background music", "Music", "Soul music"] | ["poor audio quality", "battle march", "retro pop music", "retro arcade game music", "string section", "instrumental music", "electric guitar harmony", "string synth harmony", "marching drum rhythm", "victory march", "medium tempo", "emotional", "cartoon soundtrack", "animated movie soundtrack", "serious", "steady bass line"] | 1 | uCCdUB7D10U | 5098 |
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;