musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic" and musiccaps_names contains "Ambient music" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- energetic · 2 ✖
- ad jingle 1
- advertisement soundtrack 1
- beep tones 1
- building tension 1
- creating awareness 1
- crescendo sounds 1
- different sound tracks 1
- digital 1
- drum banging loud 1
- electro 1
- excited 1
- instrumental music 1
- keyboard beeps 1
- loud synth lead melody 1
- low quality 1
- medium tempo 1
- mellow clapping 1
- poor audio quality 1
- punchy "4 on the floor" kick pattern 1
- repetitive synth bass 1
- retro ad spots 1
- shimmering hi hats 1
- short snare roll 1
- song ending 1
- subtle synth bells melody 1
- techno music 1
- thin 1
- timpani 1
musiccaps_names (array) 7 ✖
- Ambient music · 2 ✖
- Music 2
- Dance music 1
- Dubstep 1
- Electronic dance music 1
- Electronica 1
- Techno 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
As a beginner you need a special music maker software | The low quality recording features an electro song that consists of a punchy "4 on the floor" kick pattern, shimmering hi hats, mellow claps, repetitive synth bass, short snare roll, subtle synth bells melody and loud synth lead melody. Even though it is thin, it is still something you would hear as an energetic track in a club. | 2013-12-26T09:58:11Z | Rosanne Bertao | http://tinyurl.com/kczhfp9 As a beginner you need a special music maker software Just making slight modifications can be a horrible and frustrating struggle if you don't have a ton of experience. Not like Dr. Drum, which makes it all come naturally. | ["Music", "Techno", "Dubstep", "Electronic dance music", "Ambient music", "Dance music", "Electronica"] | ["low quality", "digital", "repetitive synth bass", "punchy \"4 on the floor\" kick pattern", "mellow clapping", "shimmering hi hats", "subtle synth bells melody", "loud synth lead melody", "short snare roll", "electro", "energetic", "thin"] | 4 | VDYqYuPzW8E | 2985 | |
Chris Brown-damage | The song is an instrumental. The tempo is variable, with a timpani crash, various beeping tones and a crescendo grungy keyboard harmony tone. The song is a soundtrack for an advertisement. The audio quality is very poor. | 2007-12-26T09:31:57Z | puddin713 | This song is a very good songand makes me cry everytime! | ["Music", "Ambient music"] | ["song ending", "keyboard beeps", "drum banging loud", "ad jingle", "techno music", "building tension", "excited", "energetic", "creating awareness", "retro ad spots", "advertisement soundtrack", "timpani", "beep tones", "crescendo sounds", "instrumental music", "medium tempo", "poor audio quality", "different sound tracks"] | 1 | DEnayQZiPGc | 1455 |
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;