musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_names = "["Music", "Ambient music"]" and musiccaps_names contains "Ambient music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Abandoned trains. Old abandoned steam engine trains in USA. Abandoned steam locomotives | The music is purely instrumental and it features an atmospheric vibe. In the beginning two or more flutes are playing melodies which are overlapping because of an added reverb effect. I believe a clarinet can be heard in one instance. Percussion drums are also present and a bell-like sound can be heard in the second half of the music excerpt. I believe the purpose of this music is to create floating vibes. | 2015-09-29T20:31:08Z | Abandoned places | I will show you awesome compilation of old abandoned steam engine trains and locomotives in USA, abandoned on old train trucks. Many of them are dying in the woods. You will see amazing train pictures. | ["Music", "Ambient music"] | ["flutes", "reverb effect", "clarinet", "percussion", "bell-like sound", "atmospheric", "instrumental", "no voice"] | 2 | BKQYrrJVg6g | 1228 | |
Super Smash Bros 64 move swap | This song is an instrumental. The tempo is fast with an animated keyboard harmony, funky bass lines; groovy electric guitar melody, slick drumming and synthesiser arrangements. The instrumental is upbeat, catchy, vibrant, animated, youthful and vivacious. This song is an Electro Rock/ Synth Rock. | 2009-04-18T22:29:08Z | YoYoSpln | Super Smash Bros 64 move swap HEX | ["Music", "Ambient music"] | ["instrumental", "fast tempo", "synthesiser articulation", "electric guitar melody", "keyboard harmony", "upbeat", "vivacious", "youthful", "electric guitar feedback", "groovy bass lines", "intense drumming", "animated", "vibrant", "catchy", "youthful", "upbeat vivacious", "rock", "synth rock", "punk rock"] | 7 | VNjYW4OXqTs | 2996 |
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;