musiccaps_details (view)
2 rows where musiccaps_aspects contains "pop song" and musiccaps_names contains "New-age music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- no percussion 2
- pop song · 2 ✖
- accordion song 1
- dreamy music 1
- fantasy music 1
- female voice 1
- foreign language 1
- instrumental 1
- meditation music 1
- minimal instruments 1
- moderate tempo 1
- no voices 1
- relaxing song 1
- romantic theme 1
- slow tempo 1
- synth sounds 1
musiccaps_names (array) 3 ✖
- Music 2
- New-age music · 2 ✖
- Music of Bollywood 1
youtube_published (date) 2 ✖
- 2010-05-19 1
- 2012-04-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Space We Live In - FULL HD Video | This song has a relaxing feel. It starts off with a synth playing a chord sequence. This is followed by synth strings playing a high pitched melody. The notes fade into each other. Another synth plays the bass notes in the background. There is no percussion in this song. The mood of this song is dreamy. This song can be played in a dream sequence in a movie. | 2012-04-05T09:20:06Z | MatthiasM.de | my Video Shop: https://matthiasm.de/shop Like on Facebook: https://www.facebook.com/MatthiasM.de +1: http://goo.gl/ZUHpb Tools: 3ds max - Krakatoa + Frost - particle flow + box#3 - FumeFX - BerconMaps, FREE plugin: (http://ylilammi.com/BerconMaps.shtml) - BetterWind, FREE plugin: (http://rpmanager.com/plugins/BetterWind.htm) a little insight, some flows, setups and procedural maps of the last scene: http://matthiasm.de/images/last_scene_tswli.jpg Music: Rameses B - Memoirs (Cinematic Version) http://youtube.com/RamesesB | ["New-age music", "Music"] | ["pop song", "relaxing song", "synth sounds", "no percussion", "meditation music", "no voices", "instrumental", "dreamy music", "fantasy music", "slow tempo"] | 0 | a-11dtG7aK4 | 3509 | |
New-Age Korean traditional music group IS - MBC drama, HyangDanJeon | This pop song features a female voice singing the main melody in a foreign language. This is accompanied by an accordion playing a harmonized melody in the background. There is no percussion in this song. Minimal instruments are used in this song. The theme of this song feels romantic. | 2010-05-19T12:42:41Z | InfinityofSound | MBC drama, HyangDanJeon | ["New-age music", "Music", "Music of Bollywood"] | ["pop song", "romantic theme", "female voice", "foreign language", "accordion song", "moderate tempo", "no percussion", "minimal instruments"] | 0 | aJHv6TV7JpY | 3528 |
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;