musiccaps_details (view)
3 rows where "youtube_published" is on date 2010-06-27 sorted by musiccaps_caption
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- acoustic drum 1
- amateur recording 1
- applause 1
- cinematic 1
- crowd cheering 1
- dangerous atmosphere 1
- e-bass 1
- e-guitar 1
- female choir 1
- flutes 1
- live performance 1
- low string drone 1
- male voice singing 1
- organ 1
- percussive 1
- positive vibes 1
- rock&roll 1
- string section 1
- uptempo 1
musiccaps_names (array) 7 ✖
- Music 3
- Applause 1
- Choir 1
- Heavy metal 1
- Independent music 1
- Singing 1
- Timpani 1
video | youtube_link | musiccaps_caption ▼ | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ken Thorne - Superman ll (Original Soundtrack) 1980 | This composition contains percussion and percussive hits taking the main focus. A string section is playing a short melody along with flutes/oboes. This song sounds cinematic and may be playing in a dangerous movie-scene. | 2010-06-27T07:39:11Z | kenthornesuperman2 | Superman II (1980 Soundtrack) (Ken Thorne) Track List: 01 - Preface Superman II (1980) (Ken Thorne) 02 - Main Title Superman II (1980) (Ken Thorne) 03 - Lift Into Space; Release Of The Villains Superman II (1980) (Ken Thorne) 04 - Lex Escapes Superman II (1980) (Ken Thorne) 05 - Honeymoon Hotel Superman II (1980) (Ken Thorne) 06 - Lex And Miss Teschmacher To The Fortress Superman II (1980) (Ken Thorne) 07 - Clark Exposed As Superman Superman II (1980) (Ken Thorne) 08 - Lovers Fly North Superman II (1980) (Ken Thorne) 09 - Mother's Advice Superman II (1980) (Ken Thorne) 10 - TV President Resigns; Clark To Fortress Superman II (1980) (Ken Thorne) 11 - Aerial Battle; Superman Saves Spire Superman II (1980) (Ken Thorne) 12 - Sad Return Superman II (1980) (Ken Thorne) 13 - Ursa Flies Over Moon Superman II (1980) (Ken Thorne) 14 - Clark Fumbles Rescue Superman II (1980) (Ken Thorne) 15 - End Title Superman II (1980) (Ken Thorne) Full mp3 :- http://www.mediafire.com/?sharekey=b5b72fd0fc812693ed24a2875c7fa58e7167164733afc1fd759e682a8cd2154a | ["Timpani", "Heavy metal", "Music"] | ["cinematic", "percussive", "low string drone", "string section", "flutes", "dangerous atmosphere"] | 6 | hyGuS5WiPk8 | 4154 | |
Lied der Abschlussklasse 2010 (Nena 99 Luftballons ) | This is the ending of a female choir performing on stage. It appears to be in a graduation ceremony setting. The crowd starts cheering and applauding the choir after the show is over. | 2010-06-27T17:02:11Z | tanjanicole123 | Lied der Abschlussklassen 2010 | ["Singing", "Applause", "Music", "Choir"] | ["amateur recording", "live performance", "female choir", "crowd cheering", "applause"] | 9 | PJUffXn-LIk | 2526 | |
Strawberry Alarm Clock - California Day | This song contains acoustic drums playing a steady groove with an uplifting bassline that repeats itself. An e-guitar is playing a single note melody while strings and an organ are elevating the energy with long higher register chords. Some backing vocals are singing along to the strings while the male voice is singing his melody. This song may be playing on a sunny day at the park having a picnic. | 2010-06-27T08:13:10Z | Optinon | Genre: Pop/Psychedelic Pop Released: 1970 Release: California Day / Three | ["Music", "Independent music"] | ["rock&roll", "acoustic drum", "e-bass", "organ", "e-guitar", "male voice singing", "uptempo", "positive vibes"] | 6 | BHu95Y_kVQA | 1225 |
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;