musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "nostalgic" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- instrumental · 2 ✖
- nostalgic · 2 ✖
- ambient 1
- analog sounding 1
- cozy 1
- electronic 1
- electronica 1
- granular synth 1
- melancholic 1
- mellow sounding 1
- mellow tune 1
- no singer 1
- piano 1
- synth 1
- synthwave 1
- uneasy 1
- warp effect 1
musiccaps_names (array) 4 ✖
- Electronic music 1
- Music 1
- Singing bowl 1
- Synthesizer 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Helios - Bless This Morning Year | This is an ambient/electronica music piece. It is an instrumental piece. There is a granular synth playing a vague sounding melody while a warp effect enters and a piano starts playing gently. There is a nostalgic and melancholic feel to it. This piece could be playing in the soundtrack of a drama movie during a scene where the feeling of regret is emphasized. | 2011-12-30T17:19:20Z | 搖滾後 | Urban Exploration Skåne Early 2010 Music: Helios - Bless this morning year - http://myspace.com/heliosmusic | ["Singing bowl"] | ["ambient", "electronica", "no singer", "instrumental", "granular synth", "mellow sounding", "warp effect", "piano", "uneasy", "melancholic", "nostalgic"] | 9 | DQrdOgRb-oA | 1475 | |
starRo - Milk | Majestic Color | This is a synthwave music piece. It is an instrumental piece. There is an analog sounding synth playing a mellow tune. An overall feeling of nostalgia can be felt from this piece. It could be used in the soundtrack of a drama movie that is about a protagonist who cannot adapt to modernity. | 2016-04-16T18:16:20Z | Majestic Casual | Picture by http://avalcarcel.tumblr.com/ ❤ ● Download copyright free: http://smarturl.it/c42s3e ● Explore more free to use music → http://smarturl.it/cdjl7e ---------------------------------------------------------------------------------------- Majestic Color is our series of free to use music — from creators for creators. You can use Majestic Color tracks for your YouTube videos without having to worry about copyright issues. We want to challenge today's status quo of the music industry who protect their property from "infringers". We in contrast believe that music should be accessible for everyone. Why the name Majestic Color? Well, we believe in the variety of music, that listening to music should be something free of boundaries. Every color has its own unique voice. Just like every of the music pieces we release. ---------------------------------------------------------------------------------------- If you use this copyright & royalty free music you MUST in your description: ● Include the full title of the track. ● Include a link to the track on Majestic Casual's YouTube. ---------------------------------------------------------------------------------------- FOLLOW US HERE ● Spotify - http://smarturl.it/majesticcspotify ● SoundCloud http://soundcloud.com/majesticcasual ● Facebook - https://facebook.com/majesticcasual ● Instagram - https://instagram.com/majesticcasual ● Twitter - https://twitter.com/majesticcasual ● Snapchat - 'majesticcasual' ---------------------------------------------------------------------------------------- Follow starRo ● https://soundcloud.com/starro ● https://facebook.com/starRoofficial ● https://twitter.com/starRo75 ---------------------------------------------------------------------------------------- Follow Majestic Casual Records ● https://facebook.com/majesticcasualrecords ● https://soundcloud.com/majesticcasualrecords ● https://instagram.com/majesticcasualrecords ---------------------------------------------------------------------------------------- SOUNDS LIK… | ["Electronic music", "Music", "Synthesizer"] | ["electronic", "synthwave", "instrumental", "synth", "analog sounding", "mellow tune", "nostalgic", "cozy"] | 9 | mWL9_WIbykw | 4476 |
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;