musiccaps_details (view)
3 rows where musiccaps_aspects contains "classical music" and musiccaps_author = 6 sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- amateur recording 3
- classical music · 3 ✖
- slow tempo 3
- background car driving sounds 1
- background whispering 1
- bansuri flute 1
- dramatic 1
- flutes 1
- keyboard 1
- oboes 1
- orchestra 1
- shrutibox 1
- soft and dreamy 1
- string composition 1
- string section 1
- strings 1
musiccaps_names (array) 6 ✖
- Music 3
- Classical music 2
- Opera 1
- Theme music 1
- Traditional music 1
- Whir 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Asfindyar Momand Classical Music Concert pushto ghazal parogram amn TV parat 3 - YouTube.FLV | Someone is playing an indian bansuri with reverb along with a shrutibox. A keyboard is playing a soft bell sounding melody on top along with some strings. This is an amateur recording. This music may be playing at a live concert. | 2011-08-11T11:39:33Z | tajo65 | ["Traditional music", "Music", "Classical music"] | ["classical music", "bansuri flute", "shrutibox", "keyboard", "strings", "slow tempo", "amateur recording"] | 6 | LRUdmYcXFuM | 2187 | ||
GTA IV Mercedes vs BMW Test Drive Sound mod & Music Theme | A classical composition containing strings playing a short repeating melody. You can hear a lot of background noises that seem to come from cars racing. This is an amateur recording. This song may be playing sitting in a limousine. | 2013-05-09T18:22:51Z | oi3 | GTA IV Mercedes vs BMW Test Drive Sound mod & Music Theme Mod Pack includes ClockWorkMountain Retextured st_clkmnt04txd.wtd & objects4.ini Mercedes Sound Note! noise bug is from my Buged Engine resident.ivaud not included... Subaru impreza WRC Sound with Engine Resident.ivaud transmission whine turbo & shoting flames sounds & WRC Final PaintJob Preview on YouTube 1 »»» http://www.youtube.com/watch?v=VdYakZ4Yciw & 2 »»» http://www.youtube.com/watch?v=9_hiieGR2MA Download Now!»»» https://docs.google.com/file/d/0BzAYAOV1um71OHh0QlNFWXlVYnc/edit?usp=sharing | ["Theme music", "Music", "Whir"] | ["classical music", "string composition", "background car driving sounds", "amateur recording", "slow tempo"] | 6 | VdYakZ4Yciw | 3014 | |
Mara Galeazzi & Edward Watson in Romeo & Juliet. | A full orchestra is playing a slow dramatic, emotional and soft composition. In the background whispering can be heard. This is an amateur recording. This song may be playing at a theater dancing ballet. | 2013-09-24T15:32:40Z | Approximatesonata | Balcony scene pas de deux. Cor. Kenneth Mac Millan. | ["Music", "Opera", "Classical music"] | ["classical music", "orchestra", "flutes", "string section", "oboes", "slow tempo", "dramatic", "background whispering", "soft and dreamy", "amateur recording"] | 6 | q9zAlMM-A9I | 4759 |
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;