musiccaps_details (view)
3 rows where "youtube_published" is on date 2011-04-15 sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- airy suspended open chords 1
- amateur recording 1
- ambient sounds 1
- birds chirping 1
- boomy kicks 1
- car engine 1
- carousel 1
- carousel music 1
- children’s music 1
- children’s toy music 1
- clapping 1
- electronic music 1
- engine sound 1
- engine whirring 1
- folk 1
- groovy bass 1
- groovy electric guitar chords 1
- harmonica solo 1
- home video 1
- ice-cream cart 1
- instrumental 1
- joyful 1
- low fidelity 1
- low quality 1
- low quality audio 1
- medium tempo 1
- merry-go round 1
- outdoors 1
- paper shuffling 1
- passionate 1
- passionate female vocal 1
- people’s voices 1
- punchy snare 1
- shimmering hi hats 1
- solo live direct input acoustic guitar strumming 1
- thudding 1
- xylophone melody 1
musiccaps_names (array) 6 ✖
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
1st Ice Cream Truck of the Year | This music is instrumental. The tempo is medium with an electronic xylophone melody. The audio is of inferior quality and it sounds like it is being played outdoors. There are ambient nature sounds like birds chirping, a car engine, a loud thud and people’s voices. | 2011-04-15T01:41:18Z | Elizabeth's Adventures | Here is a video that I took of the first ice cream truck of the year. This truck comes around almost every day in front of our building. The song is the Mr Softee song | ["Ice cream truck, ice cream van", "Music"] | ["instrumental", "medium tempo", "engine sound", "car engine", "people’s voices", "low quality audio", "amateur recording", "home video", "outdoors", "ice-cream cart", "merry-go round", "carousel", "carousel music", "engine whirring", "thudding", "xylophone melody", "birds chirping", "electronic music", "children’s music", "children’s toy music"] | 7 | ZsmxO0wnqdQ | 3423 | |
Noel Gallagher - Everybody Is On The Run (Unreleased Material From Sound Check) | low fidelity audio from a live performance featuring a solo direct input acoustic guitar strumming airy, suspended open chords. Also present are occasional ambient sounds, perhaps papers being shuffled. | 2011-04-15T12:03:37Z | themaddarevillo | Noel Gallagher - Everybody Is On The Run (Unreleased Material From Sound Check) | ["Music", "Wedding music", "Classical music"] | ["solo live direct input acoustic guitar strumming", "airy suspended open chords", "low fidelity", "ambient sounds", "paper shuffling"] | 8 | -4SYC2YgzL8 | 10 | |
It's Not the Bullet that Kills You (It's the Hole) | The low quality recording features a folk song that consists of a passionate female vocal singing over harmonica solo, groovy bass, shimmering hi hats, punchy snare, boomy kicks, groovy electric guitar melody and some claps. It sounds passionate and joyful. | 2011-04-15T23:19:29Z | cxbmusic | Track length = 3:47. Before Laurie Anderson had a record contract, she released this - her first single, apparently sponsored by the Holly Solomon Gallery for an installation (a jukebox containing this and a number of other songs including 'New York Social Life'). The song was dedicated to Chris Burden. The image is of Laurie Anderson in the 1970s. | ["Harmonica", "Wind instrument, woodwind instrument"] | ["low quality", "folk", "groovy bass", "harmonica solo", "clapping", "groovy electric guitar chords", "shimmering hi hats", "boomy kicks", "punchy snare", "passionate female vocal", "passionate", "joyful"] | 4 | -zA6LL78KYU | 106 |
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;