musiccaps_details (view)
3 rows where musiccaps_names contains "Music" and "youtube_published" is on date 2009-07-26
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- live performance 2
- accordion 1
- adrenaline junkies 1
- calming 1
- cheerful 1
- dance rhythm 1
- energetic 1
- energetic drumming rhythm 1
- entertaining 1
- female singing quarter 1
- groovy bass line 1
- happy 1
- harmonies 1
- instrumental music 1
- live audience 1
- live recording 1
- male deep voice singing 1
- mantra 1
- meditation 1
- medium fast tempo 1
- people cheering 1
- percussive tap dancing 1
- poor audio quality 1
- positive 1
- relaxing 1
- slow tempo 1
- snares riding fast 1
- spirited 1
- synth pads 1
- tap dancers 1
- upbeat 1
- various percussion hits 1
- vintage european 1
- violins 1
- youthful 1
musiccaps_names (array) 10 ✖
- Music · 3 ✖
- A capella 1
- Bowed string instrument 1
- Chant 1
- Classical music 1
- Mantra 1
- Musical instrument 1
- New-age music 1
- Tap 1
- Violin, fiddle 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Quartet "Salut Salon" | This is a live performance by a female vocal quartet. They harmonise their voices and sing in a vibrant and cheerful way. They sing in French. Later, we hear two violins playing in sync as well as an accordion. The recording quality of the audio is poor. | 2009-07-26T14:05:26Z | Dina Anunziata | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "A capella"] | ["live recording", "live performance", "female singing quarter", "poor audio quality", "violins", "accordion", "cheerful", "happy", "upbeat", "harmonies", "vintage european"] | 3 | YErpnsceZw8 | 3268 | |
Tap Dogs I Beams | The song is an instrumental. The song is medium fast tempo with a groovy bass line, energetic drumming, and tap dancers in a percussive groove. The song is entertaining and energetic. | 2009-07-26T17:06:46Z | Tap Dogs Official | ["Music", "Tap"] | ["tap dancers", "percussive tap dancing", "adrenaline junkies", "live audience", "live performance", "instrumental music", "groovy bass line", "people cheering", "energetic drumming rhythm", "medium fast tempo", "various percussion hits", "snares riding fast", "entertaining", "energetic", "positive", "spirited", "youthful", "dance rhythm"] | 1 | oRUdvu3Qo-E | 4628 | ||
Mantra for Tibet - Buddhist Monk Chant 2 | Synthesizers are playing pads. There is a low pad sound serving as bass, mid and high string pad sounds. A low male voice is singing. The whole recording has reverb on it. This song may be playing while meditating. | 2009-07-26T11:12:51Z | TI3ET | THE LAMA'S CHANTS - Songs Of Awakening - LAMA GYURME: The Tsok Offering | ["Mantra", "Chant", "New-age music", "Music"] | ["meditation", "mantra", "synth pads", "male deep voice singing", "relaxing", "calming", "slow tempo"] | 6 | vmz9kAEiTSc | 5203 |
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;