musiccaps_details (view)
4 rows where "youtube_published" is on date 2010-06-23
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Sarah Brightman performing 'Music Of the Night' at Queen Mother's 90th Birthday Gala 1990 | Dramatic female opera singer accompanied by orchestra and brass and cymbal crash. | 2010-06-23T02:57:11Z | tapesalvage | Sarah Brightman performing 'Music Of the Night' from Phantom Of the Opera at Queen Mother's 90th Birthday Gala 1990 | ["Singing", "Music", "Opera", "Classical music"] | ["opera", "dramatic", "cymbal crash", "orchestral brass", "orchestral accompaniment"] | 8 | XUzaEsoOlWQ | 3187 | |
| breath | The low quality recording features an intense, suspenseful movie scene that consists of panicked female breathing, whining and mellow wide synth chords playing in the background. | 2010-06-23T18:18:56Z | chaplainyuras | breath | ["Music", "Breathing"] | ["wide synth chords", "panic female breathing", "whining", "intense", "suspenseful", "low quality", "movie scene"] | 4 | je96vkMY60c | 4271 | |
| Dj Chuckie - Party Bounce | This audio contains a digital reggaeton beat that uses some acoustic samples. In the background you can hear a soft bass playing along with the kick. A lot of male voices are rapping/speaking providing backing vocals that are spread across both sides of the speakers. This song may be playing at a party outside on the streets. | 2010-06-23T22:40:03Z | abtotdec | Enjoy the Song Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use | ["Afrobeat", "Singing", "Music", "Rapping", "Hip hop music"] | ["reggeaton", "male voices rapping/talking", "bass", "digital drums", "medium to uptempo"] | 6 | ou3LJpAM4mk | 4663 | |
| Giovanni Gabrieli Sacra Symphonia Sonata Pian'e Forte | This song features the brass section of a symphonic orchestra. The melody is played on trumpets. It is accompanied by a trombone and a brass horn playing individual parts. This song is at a slow tempo and has a relaxing feel. There are no voices in this song. There is no percussion in this song. This song can be played when a hero is returning victorious from a battle. | 2010-06-23T21:36:58Z | Maurizio De Marco | Zubin Metha conducts The Brass Section of the Bayerische Staatsoper | ["Brass instrument", "Trombone", "Trumpet"] | ["brass instruments", "orchestral music", "trombone", "symphonic feel", "horn", "no percussion", "instrumental music", "no voice", "slow tempo", "relaxing song"] | 0 | rQeikHMQGOM | 4876 |
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;