musiccaps_details (view)
3 rows where "youtube_published" is on date 2007-11-18 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 58 ✖
- live performance 2
- ambient background sounds 1
- ambient rock 1
- ambient room noises 1
- baby crying incessantly 1
- bad audio quality 1
- bollywood movie song 1
- bollywood music 1
- brass band 1
- bright trumpeting 1
- buoyant 1
- cheering 1
- clapping 1
- consoling a baby’s cry 1
- crackling male vocals 1
- dance groove 1
- emotional 1
- emotional music 1
- energetic 1
- enthusiastic 1
- enthusiastic electronic guitar melody 1
- fast tempo 1
- flute melody 1
- groovy bass line 1
- hard hitting drumming 1
- high spirited 1
- hissing vocals 1
- instrumental 1
- i’d kan movie song 1
- jive 1
- keyboard harmony 1
- love song 1
- low quality 1
- make singer 1
- male singer 1
- medium tempo 1
- memdium tempo 1
- mono 1
- muddy 1
- muffled 1
- muffled music 1
- noises 1
- noisy 1
- orchestra 1
- passionate 1
- people talking 1
- phon playing music 1
- poor audio quality 1
- pulsating 1
- retro hindi hits 1
- retro rock 1
- rhythmic acoustic guitar 1
- rock and roll 1
- shimmering cymbals 1
- sustained brass melody 1
- sustained strings melody 1
- upbeat 1
- wind instruments 1
musiccaps_names (array) 5 ✖
- Music 2
- Baby cry, infant cry 1
- Orchestra 1
- Rock and roll 1
- Roll 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Star Trek Suite | The low quality recording features a live performance of an orchestra playing sustained brass melody, shimmering cymbals and sustained strings melody. It sounds muddy and muffled, as it was probably recorded with a poor quality microphone, but also passionate. The recording is noisy and in mono. | 2007-11-18T07:49:15Z | George Yefchak | "Star Trek Through the Years" (excerpts). Nova Vista Symphony conducted by George Yefchak while wearing a Starfleet Commander uniform (sciences division, circa 2373). | ["Orchestra"] | ["live performance", "low quality", "orchestra", "muffled", "muddy", "mono", "noisy", "sustained brass melody", "shimmering cymbals", "sustained strings melody", "passionate"] | 4 | Y8plCTF8xsY | 3258 | |
Torvill and Dean 1983 Rock n Roll OSP | This music is a high energy Rock and Roll. The tempo is fast with a vivacious electric guitar melody, punchy drumming, animated trumpets, funky bass line, keyboard and acoustic guitar accompaniment . The music is high energy, vivacious, bright, groovy,enthusiastic and animated Rock and Roll instrumental. | 2007-11-18T01:14:20Z | BJH1981 | Torvill & Dean's Rock n Roll OSP from 1983 World Championships | ["Music", "Roll", "Rock and roll"] | ["instrumental", "fast tempo", "ambient background sounds", "clapping", "live performance", "poor audio quality", "muffled music", "cheering", "people talking", "enthusiastic electronic guitar melody", "hard hitting drumming", "bright trumpeting", "groovy bass line", "rhythmic acoustic guitar", "keyboard harmony", "brass band", "wind instruments", "dance groove", "jive", "rock and roll", "retro rock", "energetic", "enthusiastic", "pulsating", "buoyant", "upbeat", "high spirited"] | 7 | fEHsR679g1M | 3934 | |
طفلة تبكي من سماع موسيقى حزينة baby crying When she hear a s | The track is of a baby crying incessantly being consoled by a song being played on a phone. The song is medium tempo with a male singer singing to Bollywood music. The audio quality is extremely poor. | 2007-11-18T23:30:01Z | شريف روما | طفلة تبكي من سماع موسيقى حزينة baby crying When she hear a sad music | ["Music", "Baby cry, infant cry"] | ["baby crying incessantly", "phon playing music", "bollywood movie song", "retro hindi hits", "ambient room noises", "male singer", "flute melody", "medium tempo", "emotional music", "bad audio quality", "i’d kan movie song", "bollywood music", "make singer", "ambient rock", "noises", "hissing vocals", "memdium tempo", "retro hindi hits", "emotional", "crackling male vocals", "love song", "consoling a baby’s cry"] | 1 | K8On7nUJuP8 | 2060 |
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;