musiccaps_details (view)
1 row where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "flute like instrument", musiccaps_aspects contains "higher key" and musiccaps_aspects contains "male voice singing"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Jordania y su Música | This song contains a male voice loudly singing in a higher key. A flutelike instrument is playing a melody out of tune accompanied by an accordion sound. This is an amateur recording. | 2009-11-10T08:33:59Z | rauloleono | El Reino Hachemita de Jordania es uno de los países que alberga en sus regiones deserticas a una gran cantidad de árabes beduinos. Este grupo social nómada tiene fuerte influencia sobre Jordania, principalmente en la música tradicional jordana. Los beduinos poseen sus propios maneras de desarrollar sus constumbres y tradiciones; las danzas es una manera de demostrar su cultura y la música a pesar de poseer escalas un tanto primitivas, mantienen un lugar popular en el folklór árabe. Espero disfruten de éstas 2 piezas tradicionales beduinas. Me hubiera gustado publicar más pero desafortunadamente la música de Jordania es escaza para conseguir, pero de todas maneras, lo que he publicado para ustedes narra claramente a "Jordania y su Música". Saludos a todos(as) y que lo disfruten. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["amateur recording", "male voice singing", "higher key", "flute like instrument", "medium uptempo"] | 6 | gI-ovjTWBzo | 4022 |
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;