musiccaps_details (view)
2 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "digital drums" and musiccaps_names contains "Electronic music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 13 ✖
- amateur recording · 2 ✖
- digital drums · 2 ✖
- uptempo 2
- digital strings 1
- electro/techo 1
- female voice 1
- higher register 1
- male kids voice 1
- male voice singing 1
- synth arpeggios 1
- synth pluck 1
- synth sound 1
- techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I Like Turtles TECHNO REMIX | This song contains digital drums playing a groove along with an aggressive synth saw wave pad repeating the same simple melody. A male kid's voice is chopped into a sample creating a rhythmic phrase. The same goes for a female voice. So it sounds like they are singing. This is an amateur recording. This song may be playing in a funny video. | 2008-08-06T15:14:12Z | R H | Thank you for over 1 Million views! :) Please also check out my other videos on my channel! Techno Remix of the "Zombie Kid Likes Turtles" video. Music made, as always, in Fruity Loops. Thanks for watching, and if you want, subscribing. Dont forget: I LIKE TURTLES | ["Electronic music", "Music", "Techno"] | ["techno", "amateur recording", "male kids voice", "female voice", "synth sound", "digital drums", "uptempo"] | 6 | A0XXmVts1y0 | 1058 | |
grind wiv me 4x4 mix | This song contains digital drums playing a four on the floor groove with a kick on every beat. A low synth arpeggio is serving as bassline rather than pitching up one octave while synth pluck instruments are playing a fast and repeating melody. A male voice is singing a melody in a higher key. The voice is panned to the right side of the speakers and is not the loudest element in the mix. You can hear a high pitch string drone. This song may be playing at a private houseparty. | 2007-05-14T10:48:21Z | boybetterknow06 | jus listen | ["Electronic music", "Music", "Zing"] | ["electro/techo", "digital drums", "male voice singing", "higher register", "digital strings", "synth arpeggios", "synth pluck", "uptempo", "amateur recording"] | 6 | TzPuAqjoL80 | 2879 |
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;