musiccaps_details (view)
1 row where musiccaps_aspects contains "cello", musiccaps_aspects contains "flute", musiccaps_aspects contains "no other instruments", musiccaps_aspects contains "no voices" and musiccaps_author = 0
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 |
---|---|---|---|---|---|---|---|---|---|---|
Marin Marais Les Folies d'Espagne pour flûte et violoncelle | This song features a flute playing the main melody. The flute plays staccato notes and allows only the last note to be sustained. This is accompanied by a cello playing the same melody in the lower register. There are no voices in this song. This song is an instrumental. This folk song features no other instruments. This song can be played in an animation movie featuring fairies. | 2011-04-07T21:54:26Z | susancello | Duo à Cord'Air Nathalie Lourties Flûte Susan Edward Violoncelle En concert le 3 avril 2011 à Salle Cuzin, Auch www.acordair.com | ["Wind instrument, woodwind instrument", "Flute"] | ["classical music", "flute", "cello", "no other instruments", "no voices", "instrumental", "moderate tempo"] | 0 | dUlQepCYXgw | 3793 |
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;