musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar" and youtube_description contains "No copyright infringement intended"
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- acoustic guitar · 2 ✖
- digital drums 1
- female and male voice sample 1
- flamenco 1
- instrumental 1
- percussion 1
- repeating theme 1
- spanish 1
- techo 1
- uptempo 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Gusto- Disco's revenge (original mix) | This audio contains a techno drum with a kick on every beat. A low male voice sample serves as bassline. A female voice sample is singing a repeated melody in the higher register. In the background you can hear an acoustic guitar being strummed like a flamenco guitar. This song may be playing in a club. | 2010-01-12T23:12:31Z | angel29476 | Gusto- Disco's revenge (original mix) (i don't own the music) NO COPYRIGHT INFRINGEMENT INTENDED | ["Disco", "Music"] | ["techo", "female and male voice sample", "digital drums", "acoustic guitar", "uptempo"] | 6 | UOC4VWQpnDM | 2912 | |
(Full) Oogie Boogie's Song - Rodrigo y Gabriela [HQ] | This music is a flamenco piece. There are two acoustic guitars, one playing the leading arpeggio melody and the other creating the rhythmic background by strumming the chords. The characteristics of the song makes it clear that it is influenced by Spanish music. It could be used in a thriller movie soundtrack or as a flamenco dance accompaniment piece for dancing courses. | 2008-10-02T07:06:54Z | HSMRocksMedia | Nightmare Revisited Oogie Boogie's Song - Rodrigo y Gabriela No copyright infringement intended | ["Flamenco", "Music"] | ["flamenco", "acoustic guitar", "percussion", "instrumental", "repeating theme", "spanish"] | 9 | fow1TC_MpHs | 3977 |
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;