musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "digital drums" and musiccaps_aspects contains "pop" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- digital drums · 3 ✖
- pop · 3 ✖
- bass 2
- e-guitar 2
- uptempo 2
- amateur recording 1
- bongos 1
- e-bass 1
- fast tempo 1
- female voice singing 1
- guitar melody 1
- higher register 1
- keyboard melodies 1
- male voice singing 1
- melancholic 1
- positive atmosphere 1
- synth strings 1
musiccaps_names (array) 4 ✖
- Music 3
- Burst, pop 1
- Music of Asia 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Roger Sanchez Feat. Lisa Pure - Lost - Original Mix (Video) | This song contains digital drums playing a four on the floor groove with a kick on every beat along to an e-bass. In the background you can hear additional bongo rhythms. A synth string sound is playing long chord notes in the background. An e-guitar is finger picking a chord melody. A female voice is singing in a higher key and with backing vocals. This song may be playing while cleaning the kitchen. | 2007-11-11T12:52:18Z | Zarmk (Mike Alcazar) | Vocal House track from the S-Man, a new house classic. Copyright belongs to the Record label Stealth Records and the artist | ["Music of Asia", "Music"] | ["pop", "synth strings", "e-guitar", "e-bass", "digital drums", "bongos", "female voice singing", "fast tempo", "melancholic"] | 6 | Hp-lgcs4VXY | 1836 | |
Elite car show Golf sound system | Someone is playing a song out of a speaker. The song contains a guitar melody and a digital drum hitting the bass drum on every beat along with a bass-melody. This is an amateur recording. The song is in very poor audio-quality. | 2010-07-04T23:20:07Z | Guillermo Leal | ["Music", "Burst, pop"] | ["pop", "amateur recording", "digital drums", "guitar melody", "bass", "uptempo"] | 6 | Qz8hNRg-7G0 | 2655 | ||
DANIJEL BOTO - URNEBES (OFFICIAL MUSIC VIDEO) | Digital drums are playing a four on the floor rhythm with a kick on every beat along with a bassline and a keyboard sound playing short rhythmic chords and a e-guitar playing a simple melody along. A male voice is singing in a higher key. This song may be playing at a folkfest. | 2012-10-31T00:15:59Z | CinematixStudios | Danijel Boto - Urnebes 1.dio Ima jeda smeđa mala oduvijek je plesat znala Kad zanjiše kukovima pomuti nam pamet svima... A,i ona mala plava kako pleše boli glava nezna čovjek šta bi reko ovaj stol je samo na njih čeko... REFREN: Hajmo svi na stol to je ovi fol hajmo svi a ples bit će URNEBES 2.dio Konobaru toči piće atmosfera luda biće donesi am piće svima mi smo već na stolovima Šta je ovo moji ljudi ova pjesma sve nas budi sve je ludo gori sve plešemo uz dobre ritmove... REFREN: Hajmo svi na stol 2x | ["Music", "Wedding music"] | ["pop", "digital drums", "e-guitar", "keyboard melodies", "male voice singing", "higher register", "bass", "uptempo", "positive atmosphere"] | 6 | -bgHkxwoliw | 65 |
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;