musiccaps_details (view)
2 rows where musiccaps_aspects contains "techno dance song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- techno dance song · 2 ✖
- ambient noises 1
- bass 1
- crowd noise 1
- female voice 1
- groovy bass line 1
- high gain volume 1
- hissing tones 1
- home video 1
- keyboard accompaniment 1
- kids dancing 1
- live performance 1
- low quality audio 1
- male singer 1
- medium tempo 1
- moderate tempo 1
- noise 1
- noisy crowds 1
- poor audio quality 1
- programmed percussion 1
- school dance program 1
- school program 1
- synth bursts 1
- techno dance rhythm 1
musiccaps_names (array) 4 ✖
- Music 2
- Electronic music 1
- Maraca 1
- Techno 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Maracas dance of h.bautista elem school | A male singer sings this groovy melody. The song is a techno dance song with a groovy bass line, strong drumming rhythm and a keyboard accompaniment. The song is so groovy and serves as a dance track for the dancing children. The audio quality is very poor with high gains and hissing noise. | 2013-10-27T02:32:22Z | Alma Flores | Teacher's day | ["Music", "Maraca"] | ["live performance", "poor audio quality", "ambient noises", "school dance program", "crowd noise", "high gain volume", "hissing tones", "medium tempo", "techno dance song", "male singer", "groovy bass line", "techno dance rhythm", "keyboard accompaniment", "kids dancing", "noisy crowds", "home video", "school program", "noise"] | 1 | -1UWSisR2zo | 7 | |
techno dance | This techno song features a female voice singing the main melody. This is accompanied by programmed percussion playing a techno beat. The kick is played at every count. The hi-hi-hat is played on every 'and' of the count. The bass plays a disco pattern using the root notes of the chords being played. Synth bursts are played in between lines. This song can be played in a club. The audio quality is low. | 2006-03-26T07:52:07Z | weregoingxdown | www.myspace.com/downtononekc | ["Electronic music", "Music", "Techno"] | ["low quality audio", "techno dance song", "female voice", "moderate tempo", "programmed percussion", "bass", "synth bursts"] | 0 | Kt2MwCHV3Ko | 2129 |
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;