musiccaps_details (view)
2 rows where musiccaps_aspects contains "fast tempo" and musiccaps_aspects contains "organ" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- fast tempo · 2 ✖
- organ · 2 ✖
- backing vocals 1
- digital drums 1
- fast guitar strums 1
- foreign language 1
- happy mood 1
- male voice 1
- male voice singing/rapping 1
- pad sounds 1
- simple percussion 1
- spanish rock 1
- synth lead 1
- techno/pop 1
- trumpets 1
musiccaps_names (array) 8 ✖
- Music 2
- Dance music 1
- Disco 1
- Dubstep 1
- Hip hop music 1
- Ska 1
- Techno 1
- Trance music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Inspector - Me Estoy Enamorando (Video Oficial) | This Spanish rock song features a male voice singing the main melody. This is accompanied by rock percussion playing a simple beat. The bass plays the root notes of the chords. A guitar strums chords with upstrokes. A trumpet, saxophone and trombone plays fills in between verses. An organ pays fills at every alternate count. The mood of this song is happy and upbeat. This song can be played in a comedy movie. | 2014-05-14T20:37:22Z | Inspector Oficial | EL PRIMER SENCILLO DEL DISCO "SKA A LA CARTA" Escucha a Inspector en todas las plataformas digitales: https://ONErpm.lnk.to/inspector Escucha la playlist Mucho Ska https://ONErpm.lnk.to/MuchoSka | ["Music", "Ska"] | ["spanish rock", "fast guitar strums", "organ", "trumpets", "simple percussion", "male voice", "fast tempo", "happy mood", "foreign language"] | 0 | oswsd_r-GI8 | 4660 | |
Snap Crackle Pop (Tankypookins Remix) | The kick is playing on every beat along with a fast paced high hat and a snare sound. The digital bass is adding some spice and sounds overdriven. Pad sounds can be heard in the background while a synth lead sound is playing a simple repetitive melody. A male voice is rapping/singing. A lot of backing vocals with delay are adding energy to the mix. This song may be playing in a car. | 2011-12-02T03:59:40Z | Logan Smith | Ice Ice Ice Ice Cream Soda Pop, Let Me See Them Chains Drop! Trip to Norway, Dance team, and I decided to do a little Dubstep remix of the song they were using. The song is, though silly, about the Lord Jesus breaking chains off of our lives. Lemme hear an Amen if you've experienced THAT! You can download this track at http://tank2.bandcamp.com/track/snap-crackle-pop-tankypookins-remix. Thanks all! | ["Disco", "Music", "Techno", "Trance music", "Dubstep", "Dance music", "Hip hop music"] | ["techno/pop", "digital drums", "synth lead", "organ", "pad sounds", "male voice singing/rapping", "backing vocals", "fast tempo"] | 6 | -qcTD2o6I9s | 89 |
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;