musiccaps_details (view)
4 rows where "youtube_published" is on date 2010-11-04 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- chill 1
- christian music 1
- christian worship song 1
- classical composition 1
- dancehall 1
- devotional 1
- digital drum 1
- dub 1
- emotional 1
- female vocalist 1
- foreign language 1
- happy melody 1
- harpsichord song 1
- heartfelt 1
- indian classical 1
- indian music 1
- indian percussion 1
- jamaican 1
- keyboard 1
- lively 1
- low quality 1
- male vocal 1
- medium-to-high pitch singing 1
- mellow 1
- mellow piano chords 1
- moderate tempo 1
- no other instruments 1
- no voices 1
- passionate 1
- passionate male vocal 1
- punchy kick 1
- reggae 1
- rhythmic acoustic guitar 1
- saxophone 1
- shimmering hi hats 1
- slow tempo 1
- snappy rimshots 1
- soft bass 1
- soft melody 1
- sound for royalty 1
- south indian music 1
- tabla 1
- tambourine 1
- tamil christian worship 1
- tamil music 1
- vibrant 1
- violin harmony 1
- wood wind 1
musiccaps_names (array) 10 ✖
- Music 3
- Gospel music 1
- Harpsichord 1
- Independent music 1
- Keyboard (musical) 1
- Music of Africa 1
- Reggae 1
- Sad music 1
- Ska 1
- Song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Bach, English Suite, Pierre Hantaï | This song is played on a harpsichord. The harpsichord plays the bass and treble notes. This is a classical composition. There are no other instruments in this song. There are no voices in this song. This song can be used when a member of royalty arrives at a palace. | 2010-11-04T23:57:32Z | emiliend | ["Harpsichord", "Keyboard (musical)"] | ["harpsichord song", "classical composition", "no other instruments", "no voices", "moderate tempo", "sound for royalty", "happy melody"] | 0 | uoZ9Rs4E-6Y | 5136 | ||
Capleton, Turbulence, Chuck Fender, Chrisinti, Bascom X, Major Chris, Anthony Cruz Passi new songs dancehall ska roots | This is a dancehall music piece. There is a male vocalist singing at a medium-to-high pitch with a Jamaican accent. In the background, there is a keyboard playing the main melody. The atmosphere of the piece is vibrant. This piece could be used at beach parties and summer/vacation themed movies or TV shows. | 2010-11-04T07:12:42Z | reggaedownload | ["Music of Africa", "Music", "Reggae", "Ska", "Song"] | ["dancehall", "reggae", "dub", "jamaican", "male vocal", "medium-to-high pitch singing", "keyboard", "chill", "vibrant", "lively"] | 9 | zfkPKRn8ah8 | 5502 | ||
Tamil Christian Song - Nee illatha by Hema John- Zion Music Festival '09 | A female vocalist sings this soft melody. The tempo is slow with violin harmony, keyboard accompaniment, saxophone, digital drum, tabla and tambourine beats. The song is mellow, soft, melodic, soothing, calming , devotional and euphonious. This song is a Tamil Christian Song. | 2010-11-04T07:04:36Z | endtimezionministry | http://www.endtimezionministries.org Through Him (Jesus) all things were made; without Him nothing was made that has been made. In Him was life, and that life was the light of all mankind. John:1:3,4 | ["Gospel music", "Music", "Independent music"] | ["female vocalist", "slow tempo", "foreign language", "wood wind", "rhythmic acoustic guitar", "tabla", "indian percussion", "tambourine", "indian music", "indian classical", "south indian music", "tamil music", "violin harmony", "digital drum", "saxophone", "soft melody", "mellow", "devotional", "christian music", "christian worship song", "tamil christian worship"] | 7 | ghW2xZMvpIQ | 4046 | |
Googoosh Music Academy من همینم | The low quality recording features a passionate male vocal singing over mellow piano chords, shimmering hi hats, snappy rimshots, punchy kick and soft bass. It sounds emotional, passionate and heartfelt. | 2010-11-04T20:15:13Z | manototv | آکادمی موسیقی گوگوش 2010 اجرای گروهی «من همینم» آهنگساز : بابک سعیدی ترانه سرا : رها اعتمادی کارگردانان و خوانندگان به ترتیب حروف الفبا ارسلان ارغوان امیر سارا سروش فروغ کسرا هاله http://www.manoto1.com manoto1 Hotbird Frequency: 11317 Vertical Symbole Rate: 27500 | ["Music", "Sad music"] | ["low quality", "snappy rimshots", "shimmering hi hats", "mellow piano chords", "soft bass", "punchy kick", "passionate male vocal", "emotional", "passionate", "heartfelt"] | 4 | 1YPYQP6yupA | 286 |
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;