musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording" and musiccaps_aspects contains "background sounds"
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- amateur recording · 3 ✖
- background sounds · 3 ✖
- cinematic 2
- brass section 1
- cinematic/orchestra 1
- gamesounds 1
- string section 1
- uplifting 1
- uptempo 1
musiccaps_names (array) 6 ✖
- Music 3
- Breaking 1
- Duck 1
- Inside, small room 1
- Quack 1
- Theme music 1
youtube_published (date) 3 ✖
- 2007-10-07 1
- 2010-11-26 1
- 2015-06-05 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PERCY THE SMALL, MEDIUM, and LARGE ENGINE vs Indominus Rex LEGO Thomas & Friends Train | An orchestra is playing a piece full of mallets playing a part of the melody, along with strings, flutes and oboes playing the main melody. Timpani hits and cymbals are setting accents to give the composition its power. In the background you can hear a whistle blowing sound and other noise that seem not to belong to the music. This song may be playing in an adventure movie-scene with little insects. | 2015-06-05T13:00:03Z | Train Tsar Fun | Please subscribe: http://bit.ly/1v93HUT My Website: http://www.traintsarfun.com PERCY THE SMALL, MEDIUM, and LARGE ENGINE vs Indominus Rex LEGO. Percy The Small Engine from Thomas the Tank Engine & Friends. The 'small" Ho Scale Percy, the "medium" O Scale Percy, and the "large" G Scale Percy and Troublesome Trucks take on the LEGO Indominus re from Jurassic World. Which does better? Also some videos of the different Percy locomotives running on all 3 tracks! Royalty Free Music "Call to Adventure" and "Villainous Treachery" by Kevin MacLeod www.incompetech.com | ["Theme music", "Music"] | ["cinematic/orchestra", "amateur recording", "background sounds", "uptempo"] | 6 | Ld5G00HlbQs | 2209 | |
Jack Black parodies Spiderman by MAD TV (ORIGINAL) | An orchestra is playing a melody with a string section and a brass section giving it a feeling of something great is about to come. Apart from the music you can hear sounds of things breaking and a beeping sound. This is an amateur recording and not of the best audio-quality. This song may be playing in a heroic movie scene. | 2007-10-07T09:47:38Z | poobearpanda345 | MAD TV's Spiderman parody from the early 00s. Sorry for the bad quality! | ["Music", "Breaking", "Inside, small room"] | ["cinematic", "string section", "brass section", "background sounds", "amateur recording"] | 6 | SyJT8XsFsmE | 2801 | |
Duck Pond Dash (King) 14.691 | This recording is full of digital game noises along with short instrumentation sounds. Then a country song starts to play a composition in a very bad quality along with duck sounds. Nature sounds like water and birds chirping can be noticed. This recording is of poor audio quality and may be playing for a simple videogame. | 2010-11-26T02:46:50Z | skillgaming | ["Music", "Quack", "Duck"] | ["cinematic", "background sounds", "gamesounds", "amateur recording", "uplifting"] | 6 | fEfe8jznp5Q | 3936 |
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;