musiccaps_details (view)
2 rows where musiccaps_aspects contains "love song" and musiccaps_aspects contains "nostalgia"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- love song · 2 ✖
- nostalgia · 2 ✖
- romantic 2
- amateur quality recording 1
- cymbal crashes 1
- elanchoilic 1
- emotional 1
- flute playing 1
- good old times 1
- groovy dance rhythm 1
- guitar strumming 1
- indian dhol percussion 1
- indian traditional music 1
- instrumental music 1
- keyboard organ accompaniment 1
- male singer 1
- medium tempo 1
- modern pop song 1
- old memories 1
- poignant mood 1
- reflecting 1
- sentimental 1
- slow tempo 1
- song introduction 1
- steady drumming rhythm 1
- stringed harmony 1
- stringed instrumental melody 1
- strong bass line 1
- tambourine percussions 1
- techno drum rhythm 1
- vocal echoes 1
musiccaps_names (array) 3 ✖
- Music 2
- Blues 1
- Folk music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Sivert Høyem - Where Is My Moon? (Official Music Video) | A male singer sings this poignant melody. The tempo pop is slow with a steady drumming rhythm, cymbal crashes, guitar accompaniment, keyboard organ accompaniment and a strong bass line. The song is a poignant love song. | 2012-08-22T13:37:36Z | Sivert Høyem | New single, taken off the upcoming "Where s My Moon EP" - out Sept 21th. Buy/Stream: WiMP: http://www.smarturl.it/moonwimp iTunes: http://smarturl.it/moonitunes Spotify: http://smarturl.it/moonspotify EP iTunes: http://itunes.apple.com/no/album/where-is-my-moon-ep/id556250399?l=nb WiMP: http://wimp.no/album/16905855 Spotify: http://open.spotify.com/album/5ClXDaBHFRHBlMlpl2YoZt Follow Sivert: http://www.siverthoyem.com http://www.facebook.com/sivert.hoyem http://www.twitter.com/siverthoyem Directed & Produced by Thor Brenne DOP: Martin Edelsteen fnf Edit: Thor Brenne VFX & Online: Cato Lauvli Typography: Christian Albriktsen Gaffers: Daniel Berrum & Jon-Andrè Hakvåg Grip: Espen Zubi/Gripservice Sivert Høyem - Autumn in Arcadia - Solo European Tour: Norway: 04. okt - Tromsø, Verdensteatret 05. okt - Tromsø, Verdensteatret 06. okt - Sortland, Kinoen 11. okt - Trondheim, Byscenen 12. okt - Bergen, Gamle Logen 13. okt - Oslo, Kulturkirken Jakob 20. okt - Drammen Teater Europe: 31 okt - Kofmehl, Solothurn, Switzerland 1 nov - Plaza, Zurich, Sveits 3 nov - Faust, Hannover, Germany 4 nov - Heimathafen, Berlin, Germany 5 nov - Mousonturm, Frankfurt, Germany 6 nov - Petit Bain, Paris, France 8 nov - Paradjiskerk, Rotterdam, Holland 9 nov - Amstelkerk, Amsterdam, Holland 10 nov - Trix, Antwerp, Belgium 11 nov - Bush Hall, London, UK 28 nov - Lithografion, Patra, Greece 29 nov - Acropol, Aten, Greece 30 nov - Stage Club Larissa, Larissa, Greece | ["Blues", "Music"] | ["male singer", "poignant mood", "slow tempo", "reflecting", "nostalgia", "old memories", "good old times", "vocal echoes", "guitar strumming", "keyboard organ accompaniment", "steady drumming rhythm", "cymbal crashes", "elanchoilic", "emotional", "sentimental", "romantic", "love song", "modern pop song", "strong bass line"] | 1 | 6jeq5lP5Up0 | 782 | |
Full Karaoke ( music track ) - Nepali folk duet song America green card ko khel of Ram Prasad Khanal | The song is an instrumental. The tempo is medium with a techno drumming rhythm, various string instruments playing melodies, flute playing, Indian dhol percussion and a tambourine playing percussively. The song is romantic and has Indian classical music influences. The song has poor audio quality. | 2015-10-26T01:14:41Z | Ram Prasad Khanal | Full Karaoke ( music track ) - Nepali folk duet song America green card ko khel of Ram Prasad Khanal | ["Folk music", "Music"] | ["instrumental music", "indian traditional music", "tambourine percussions", "indian dhol percussion", "stringed instrumental melody", "flute playing", "techno drum rhythm", "groovy dance rhythm", "nostalgia", "stringed harmony", "romantic", "love song", "song introduction", "amateur quality recording", "medium tempo"] | 1 | PTLOLz9YzmM | 2540 |
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;