musiccaps_details (view)
3 rows where musiccaps_aspects contains "simple percussion" and musiccaps_names contains "Pop music" sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- simple percussion · 3 ✖
- male voice 2
- moderate tempo 2
- acoustic guitar 1
- ambient noises 1
- bass 1
- bassline 1
- female voice 1
- guitar lead 1
- live recording over song 1
- low quality recording 1
- pop ballad 1
- pop rock 1
- reverb guitar 1
- romantic song 1
- romantic theme 1
- simple bass 1
- slow rock 1
- slow tempo 1
- soul music 1
- synth backing 1
- wheels on concrete sound 1
musiccaps_names (array) 6 ✖
- Music 3
- Pop music · 3 ✖
- Rhythm and blues 1
- Skateboard 1
- Song 1
- Soul music 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
SWOOSH | This pop ballad features a female voice singing the main melody. This is accompanied by percussion playing a simple beat in the background. The bass plays the root notes of the chords. A synth plays chords and fills. The sound of wheels on concrete can be heard. The mood of this song is romantic. A live recording sound is overdubbed on this song. | 2015-07-14T14:58:23Z | William Strobeck | SWOOSH...A video for the Supreme/Nike SB GTS collection. Featuring: Alex Olson Kevin Bradley Brian Anderson & Sean Pablo 2015 @williamstrobeck | ["Music", "Pop music", "Skateboard"] | ["pop ballad", "moderate tempo", "female voice", "live recording over song", "synth backing", "simple percussion", "bass", "romantic song", "wheels on concrete sound", "ambient noises"] | 0 | 9Ijpv6e57a4 | 990 | |
Idiot Wind - Find The Rhythm In The Noise | This pop rock song features a male voice. This is accompanied by percussion playing a simple beat in common time. A lead guitar with heavy reverb plays a fill in between lines. An acoustic guitar strums chords in the background. A bass plays the root notes of the chords. The mood of this song is romantic. This song is played at a slow tempo. This song can be played in a retro romantic movie. | 2013-01-20T19:47:00Z | Paul Martin | http://www.idiotwind.se/se Amanda Bergman is a Swedish singer-songwriter. She performs under the stage name Idiot Wind and has also performed as Hajen and Jaw Lesson Bergman co-wrote the score for the Swedish movie En Gång Om Året (Once A Year). | ["Music", "Pop music", "Song", "Soul music"] | ["slow rock", "pop rock", "male voice", "guitar lead", "simple percussion", "slow tempo", "simple bass", "acoustic guitar", "reverb guitar"] | 0 | BjAL68IMlp0 | 1281 | |
Barry White - My first my last my everything (traduzione italiano) | This song features a male voice singing the main melody. The quality of recording is low. The musical instruments are not clearly distinguishable. The voice is accompanied by simple percussion playing in common time. The bass plays a soul type groovy bassline. This song is romantic. This song can be used in a romantic movie. | 2012-10-27T12:30:14Z | OffLimits27 | ["Music", "Pop music", "Rhythm and blues"] | ["low quality recording", "male voice", "bassline", "simple percussion", "soul music", "romantic theme", "moderate tempo"] | 0 | 75_dMqpSM4o | 810 |
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;