musiccaps_details (view)
3 rows where musiccaps_aspects contains "acoustic drums", musiccaps_author = 6 and musiccaps_names contains "Background music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- acoustic drums · 3 ✖
- e-bass 2
- e-guitar 2
- piano 2
- ambient jazz 1
- e-piano 1
- energetic 1
- fast tempo 1
- keyboard flute 1
- medium to uptempo 1
- oriental/pop/ballad 1
- pad/string sounds 1
- plucked string instrument 1
- punkrock 1
- relaxing 1
- slow tempo 1
- synth lead sound 1
musiccaps_names (array) 5 ✖
- Background music · 3 ✖
- Music 3
- Ambient music 1
- Angry music 1
- New-age music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jerusalem Israel Song - Shira Chadasha Boys Choir Music Video | This song contains a piano playing a melody along with a digital flute and a plucked string instrument. An e-bass is playing a simple line with long notes along with acoustic drums being in the background. This song may be playing in a landscape video. | 2008-03-03T19:43:55Z | ShiraChadasha2 | The Shira Chadasha Boys Choir are about to release their second album The name of the album is Arayvim zeh l'zeh. Composed and conducted by Nachman Seltzer, arranged mostly by Jeff Horvitch with one song by Leib Yaacov Rigler. The album has twelve new songs and old songs from Dvekus composed by Abie Rotenberg. The thirteenth song is entitled Yizkarem and was composed by Nachman Seltzer in the memory of the boys from Mercaz Harav, on the day after the attack. With star soloists Yaacov Leebhoff, Moishe Bell and Simcha Levinstein this album is sure to be a hit. | ["Background music", "Music"] | ["oriental/pop/ballad", "keyboard flute", "acoustic drums", "piano", "plucked string instrument", "e-bass", "slow tempo", "relaxing"] | 6 | 8NIxqHJrL68 | 918 | |
アラド戦記/DFO/DnF - Final Pursuit BGM/Trailer Music (Extended) | This audio contains a fast complex drumpart playing along with a synth lead sound playing a complex melody in a high pitch. Then the song changes to a more calm part with a piano before changing back to action with a distorted e-guitar playing along the low notes with a e-bass. This song sounds very fast paced and may be playing in an arcade fighting game. | 2012-07-11T14:46:16Z | TakingIt2Easy | Playlist: http://www.youtube.com/playlist?list=PL96129456883939D6 From アラド戦記/Dungeon and Fighter/Dungeon Fighter Online, developed by Neople. Stage BGM for Final Pursuit dungeon. Also used in some of the trailers. No copyright infringement is intended. All credit is given to the original songs' respective creators and distributors. | ["Background music", "Music", "Angry music"] | ["punkrock", "e-guitar", "e-bass", "synth lead sound", "piano", "acoustic drums", "fast tempo", "energetic"] | 6 | KlD1u-EDx_g | 2115 | |
Ambient Jazz Ensemble (AJE) - Vibration | This song contains e-guitars playing short repeating melodies. An acoustic drum is playing a slow drum and bass like groove with 8th notes on the ride. An e-piano is playing single high pitched notes on top. In the strings a string/pad section is playing long notes/chords in the mid range. This song may be playing at home on a loud speaker. | 2015-05-11T07:25:25Z | Here & Now Recordings | Listen on Spotify, Apple, Deezer, Amazon https://song.link/album/gb/i/982389988 Download from Bandcamp https://www.goo.gl/3kpVzh https://www.hereandnowrecordings.com https://www.hereandnowrecordings.com/ambientjazzensemble https://www.hereandnowrecordings.com/suiteshop Follow AJE https://fb.com/ambientjazzensemble https://instagram.com/ambientjazzens https://twitter.com/ambientjazzens | ["Background music", "New-age music", "Music", "Ambient music"] | ["ambient jazz", "e-guitar", "pad/string sounds", "e-piano", "acoustic drums", "medium to uptempo"] | 6 | Q6SgmlYMYLA | 2593 |
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;