musiccaps_details (view)
2 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2011-06-24
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- instrumental 2
- airy 1
- ambient house 1
- booming bass 1
- dance song 1
- electronic drums 1
- electronic music 1
- moderate tempo 1
- no singer 1
- no voices 1
- percussive elements 1
- programmed percussion 1
- psychedelic song 1
- repeated theme 1
- resonating 1
- reverberating 1
- sound effects 1
- synth 1
- synth layers 1
- synth lead 1
- techno song 1
- trance 1
musiccaps_names (array) 6 ✖
- Music · 2 ✖
- Ambient music 1
- Electronic dance music 1
- Electronic music 1
- New-age music 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Car Wash Equipment: High Pressure Water Cleaners | This is an ambient house music piece. There is no singer in the music. There are various resonating synth sounds used with ambient sound effects. Electronic drum hits can be heard reverberating in the piece. The atmosphere is airy. The best use for this piece would be either as an advertisement jingle or as a background music for a tutorial/instructive video. | 2011-06-24T03:27:58Z | NewEdgeCorp | These high pressure cleaners that use water allow easy cleaning of cars and trucks. Distribution in Malaysia: sales@newedgecorp.com | ["New-age music", "Music", "Ambient music"] | ["electronic music", "ambient house", "no singer", "instrumental", "synth", "repeated theme", "electronic drums", "percussive elements", "sound effects", "airy", "resonating", "reverberating"] | 9 | ABSLnckbB8w | 1079 | |
Techno wolf two songs.wmv | This techno song features a synth lead playing the main melody. This is accompanied by programmed percussion playing a simple kick focused beat. The hi-hat is accented in an open position on the 3-and count of every bar. The synth plays the bass part with a voicing that sounds like a cello. This techno song can be played in a club. | 2011-06-24T21:46:03Z | Meiloe | I own nothing in this video. Two songs in order are Two Hearts Together by Neimer And Manian, Ravers Fantasy (Puma Scorz Extended Remix) | ["Electronic music", "Music", "Techno", "Electronic dance music"] | ["techno song", "synth lead", "programmed percussion", "booming bass", "synth layers", "no voices", "instrumental", "moderate tempo", "dance song", "psychedelic song", "trance"] | 0 | KOb-tRHYK68 | 2078 |
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;