musiccaps_details (view)
3 rows where "youtube_published" is on date 2010-09-26
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- amateur band 1
- couple dancing 1
- drums solo 1
- e-guitars 1
- emotional 1
- energetic 1
- groovy bass line 1
- guitar accompaniment 1
- home video soundtrack 1
- keybiard accompaniment 1
- keyboard accompaniment 1
- konkani love songs 1
- konkani music 1
- lilting melody 1
- low quality 1
- male singer 1
- male voice singing 1
- medium tempo 1
- melancholic vibe 1
- mono 1
- noisy 1
- poor audio quality 1
- punchy kick 1
- punchy snare 1
- rock 1
- romantic 1
- shimmering hi hats 1
- slow tempo 1
- snare roll 1
- steady drumming rhythm 1
- together forever 1
- uptempo 1
- waltz time 1
- wedding dance music 1
- wedding song 1
musiccaps_names (array) 11 ✖
- Music 2
- Bass drum 1
- Drum 1
- Drum kit 1
- Drum roll 1
- Grunge 1
- Percussion 1
- Psychedelic rock 1
- Rimshot 1
- Snare drum 1
- Wedding music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
solo de murga..ritmo marcha camion. musica de uruguay. | The low quality recording features a drum solo that consists of punchy snare hits and occasional snare roll, punchy kick and shimmering hi-hats. It sounds energetic and the recording is in mono and noisy. | 2010-09-26T04:48:15Z | Mud Riders Adventure 🇺🇾 | LOS VIDEOS FUERON FILMADOS POR JUAN MANUEL HARAN,098 711012. En el video les muestro algo de lo que he aprendido con nicolas arnicho en sus clases. les recomiendo su dvd global rhythm. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "mono", "uptempo", "drums solo", "punchy snare", "shimmering hi hats", "punchy kick", "snare roll", "energetic"] | 4 | 3Yc7_n6mDsI | 480 | |
22-20s- Shake_ Shiver and Moan (live ep) | This song contains e-guitars playing melodies and rhythmic strumming that are spread to both sides of the speakers. A male voice is singing a melancholic melody in a higher key sitting in the middle of the track. This song may be playing while walking through the park while listening to this song with headphones. | 2010-09-26T10:25:28Z | etsithahtan | 22-20s- Shake_ Shiver and Moan (live ep) | ["Music", "Psychedelic rock", "Grunge"] | ["rock", "e-guitars", "male voice singing", "medium tempo", "melancholic vibe"] | 6 | IiBgER0W8iA | 1930 | |
Goan Wedding Song I Tum ani Hanv I Goan Song | A male singer sings this romantic melody. The song is slow tempo with a steady drumming rhythm, steady bass line, keyboard and guitar accompaniment. The song is romantic and emotional. The song is a Konkani wedding song and has a poor audio quality. | 2010-09-26T22:46:00Z | Ivor D'Cunha | #goanweddingsong #newkonkanisong Song: Tum ani Hanv Original Singer: Lulu Fortes Composer: Francisco Fernandes (2009) Music: Emiliano De Cruz Schubert dedicates Tum ani Hanv as wedding special for Ronny and Nifa (August 2010) MUSIC AVAILABLE ON ALL MAJOR MUSIC PLATFORMS Apple Music: https://music.apple.com/us/artist/ivor-dcunha/1603122816 Spotify: https://open.spotify.com/artist/3vsHf2hj3EbcBa8gu3QMuA Amazon: https://www.amazon.com/s?k=Ivor+D%27Cunha&i=digital-music&ref=nb_sb_noss Deezer: https://www.deezer.com/us/artist/156244122 #Goa #Celebration #ivordcunha #music #goanentertainment #goandance #Goanpopmusic #Goanmusic #Goanparty #musicfromgoa #konkanimusic #konkanisongs #Goanweddingsong | ["Music", "Wedding music"] | ["konkani music", "wedding song", "romantic", "konkani love songs", "wedding dance music", "home video soundtrack", "keyboard accompaniment", "emotional", "slow tempo", "waltz time", "couple dancing", "together forever", "poor audio quality", "keybiard accompaniment", "guitar accompaniment", "steady drumming rhythm", "groovy bass line", "male singer", "lilting melody", "amateur band"] | 1 | VzYc-c-uHjI | 3051 |
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;