musiccaps_details (view)
2 rows where musiccaps_aspects contains "low quality audio", musiccaps_author = 0 and musiccaps_names contains "Music of Latin America"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- low quality audio · 2 ✖
- male voice 2
- dance music 1
- fast paced percussion 1
- fast tempo song 1
- keyboard 1
- percussion 1
- salsa song 1
- trumpet song 1
- trumpets 1
- workout song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Salsa at Mango's Tropical Cafe, Miami South Beach, FL | This low quality audio features a salsa song. A male voice sings the main melody. The audio starts off with a solo being played on a trumpet. This is accompanied by percussion playing a salsa beat. A keyboard plays chords in salsa style. Other instruments are not heard clearly due to the low quality of the audio. | 2009-08-16T21:50:59Z | Alex Kronenberg | Salsa at Mango's Tropical Cafe, Miami South Beach, FL 11.08.2009 | ["Flamenco", "Music of Latin America"] | ["low quality audio", "salsa song", "male voice", "trumpets", "dance music", "keyboard", "percussion"] | 0 | 72_Hk1cdoxk | 805 | |
Zumba Michelle Marco Island (Da La Vuelta) | This low quality audio features a male voice singing the main melody. This is accompanied by percussion playing a simple but fast paced beat. Trumpets are featured in this song playing fills at high pitch. This song can be played in an aerobics workout session where fast movements are required. | 2010-09-18T04:28:34Z | Michelle Jordan | Choreography by Michelle Jordan | ["Song", "Music of Latin America", "Salsa music", "Maraca"] | ["low quality audio", "fast tempo song", "male voice", "trumpet song", "fast paced percussion", "workout song"] | 0 | jIoDR_eskaU | 4245 |
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;