musiccaps_details (view)
11 rows where musiccaps_aspects contains "amateur recording", musiccaps_aspects contains "strings" and musiccaps_author = 6
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- amateur recording · 11 ✖
- strings · 11 ✖
- female voice singing 3
- slow tempo 3
- acoustic drums 2
- cinematic 2
- e-bass 2
- flute 2
- oriental 2
- percussion's 2
- uptempo 2
- atmospherical sounds 1
- bansuri flute 1
- cinematic/horror 1
- classical music 1
- crowd cheering 1
- cymbal rolls 1
- dance 1
- dark 1
- digital drums 1
- door knocking 1
- dulcimer 1
- epic 1
- footsteps or door-knocking 1
- glitter sounds 1
- high pitch 1
- high pitched screaming 1
- higher pitch 1
- hindi song 1
- horn section 1
- italian ballad 1
- keyboard 1
- male choir 1
- male opera voice 1
- male voices singing 1
- medium tempo 1
- medium to uptempo 1
- mid range singing 1
- opera 1
- oriental sound 1
- piano 1
- pop 1
- relaxing 1
- screeching sound 1
- shrutibox 1
- slow to medium tempo 1
- slower to medium tempo 1
- synth pluck 1
- tablas 1
- tencion 1
- timpani hits 1
- white noise 1
musiccaps_names (array) 19 ✖
- Music 11
- /t/dd00003 2
- Singing 2
- Traditional music 2
- /m/05zppz 1
- Carnatic music 1
- Choir 1
- Classical music 1
- Exciting music 1
- Humming 1
- Inside, small room 1
- Knock 1
- Middle Eastern music 1
- Music of Bollywood 1
- Scary music 1
- Song 1
- Tambourine 1
- Thunk 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
120521 Kara - Mister [HD] @ MBC Korean Music Wave in Google | This audio contains a digital drum with a kick on every beat. An e-bass is playing a slightly funky groove. A synthesizer is playing a short fast melody. Another synth sound is playing a string/pad sound rising up into focus. A female voice is singing, then another female voice takes over singing. The crowd is cheering loudly. This song may be playing during a live show. | 2012-05-26T12:15:23Z | kpopcouchcrew | For more kpop concert updates follow~ http://twitter.com/couch_crew | ["Music", "Exciting music"] | ["amateur recording", "pop", "dance", "e-bass", "digital drums", "synth pluck", "strings", "female voice singing", "crowd cheering", "uptempo"] | 6 | 4Ua6i_VDYU4 | 575 | |
kashmiri song: sod roz thud tul niqab- Ghulam nabi sheikh | This recording contains a dulcimer playing a melody along with loud tablas playing a lot of deep hits that are overloading the recording speakers. At the end a string sound comes underlining with long pad notes. This song may be playing in a live event. | 2009-02-18T14:55:11Z | Arfat Sheikh | A tribute to legendary kashmiri singer - Ghulam nabi sheikh with Shanawaz taing. Join Ghulam nabi sheikh community on facebook for many more songs by the great artist!! http://www.facebook.com/group.php?gid=52122694398 | ["Carnatic music", "Music", "Middle Eastern music"] | ["oriental", "amateur recording", "strings", "dulcimer", "tablas", "slow to medium tempo"] | 6 | 4i11P4OCRfk | 595 | |
The Singing Priests Rehearse O Holy Night | This audio contains male voices singing together an opera in a higher pitch creating harmonies. In the background you can hear strings playing. This song may be playing live in a theater. | 2008-06-09T19:53:50Z | PlaceForMusic | http://www.thepriests.com Amazingly beautiful christian Music by "The Priests". The Priests are recording in the studio. The Priests are: Father Eugene O'Hagan of the Parish of Ballyclare and Ballygowan: Church of The Sacred Heart and Church of The Holy Family. Dioceses of Down and Connor Father Martin O'Hagan of the Parish of Cushendun: Church of St. Patrick (Craigagh), Church of St. Mary, The Star of the Sea (Culraney). Dioceses of Down and Connor. Father David Delargy of the Parish of Hannahstown: Church of St. Joseph and Church of St. Peter, the Rock , Dioceses of Down and Connor. It was at St. MacNissi's College, Co Antrim, a local school in Derry, where Father Eugene O'Hagan, Father Martin O'Hagen and Father David Delargy met for the first time... | ["Music", "Choir", "/t/dd00003"] | ["amateur recording", "opera", "male voices singing", "higher pitch", "strings", "slow tempo"] | 6 | 6FQ1nQ0FvgQ | 738 | |
Rahe gi sada yaha,,pyar ki ye dastaan...by B4Beeni | This song contains a female voice singing a melody along with a flute and strings playing the same melody. You can hear white noise that almost sounds like rain. This song may be playing in a movie scene. | 2010-03-02T16:47:07Z | b4beenii | http://www.b4beeni.blogspot.com/ | ["Humming", "Music"] | ["oriental sound", "flute", "strings", "cymbal rolls", "glitter sounds", "female voice singing", "amateur recording", "white noise", "relaxing", "amateur recording"] | 6 | AcX6rAwFTiY | 1146 | |
Dress Sense - JACK AND DEAN | This composition contains a string section playing a rising and dissonant chord along with strings playing short notes. In the background you can hear atmospheric noises. This song may be playing in a scary movie scene. | 2012-06-20T15:16:46Z | Jack and Dean | What a rip off. New merch: http://jackanddean.livenationmerch.com/ Our twitter followers saw this sketch before you: http://twitter.com/JackHoward http://twitter.com/deanitsomfg Fac-e-book: http://www.facebook.com/OMFGItsJackAndDean Camera & Lighting: http://youtube.com/ElliotExplicit | ["Music", "Scary music"] | ["cinematic", "amateur recording", "tencion", "dark", "strings", "atmospherical sounds", "slow tempo"] | 6 | B3q2wHpzhoM | 1201 | |
ChiosSheep | An acoustic guitar is strumming chords. A violin is playing a melody along with a flue and another hammered string instrument. Percussions are being played in a rhythm that is not a 4 bar count. All the instruments are spread across the sides of the speakers. This song may be playing in a desert movie scene. | 2012-03-01T06:52:33Z | Surendra Gowda | ["Traditional music", "Music"] | ["oriental", "acoustic drums", "strings", "flute", "percussion's", "medium to uptempo", "amateur recording"] | 6 | DG5d4megH8g | 1456 | ||
Dota 2 Daily WTF - Techies Stories: Minefield | The song sounds epic and is fully orchestrated with a string section; brass section; a male choir in the background, fast timpani hits and strings playing a melody. When the song stops, a door knocking sound can be heard along with a short video-game music sequence that does not belong to the previous song. The first song may be playing in a movie trailer. | 2015-10-08T12:58:09Z | Dota Watafak | Dota 2 fail/win compilation Submit your clip / Manda tu video: http://dotawatafak.com/ Check out the WTF Tees: http://shrsl.com/?~8c3r Facebook https://www.facebook.com/DotaWatafak Twitter: https://twitter.com/Dota2WTF Thumbnail Art by: Louissry http://louissry.deviantart.com/ ES_Choirs Of War 3 - Johannes Bornlöf (epidemicsound) RoccoW_-_Break-A-Leg (freemusicarchive.org) -Licensed under Creative Commons: By Attribution 3.0 http://creativecommons.org/licenses/by/3.0/ | ["Music", "Knock"] | ["cinematic", "epic", "strings", "horn section", "male choir", "timpani hits", "door knocking", "uptempo", "amateur recording"] | 6 | IKq2OF8jq1c | 1895 | |
Asfindyar Momand Classical Music Concert pushto ghazal parogram amn TV parat 3 - YouTube.FLV | Someone is playing an indian bansuri with reverb along with a shrutibox. A keyboard is playing a soft bell sounding melody on top along with some strings. This is an amateur recording. This music may be playing at a live concert. | 2011-08-11T11:39:33Z | tajo65 | ["Traditional music", "Music", "Classical music"] | ["classical music", "bansuri flute", "shrutibox", "keyboard", "strings", "slow tempo", "amateur recording"] | 6 | LRUdmYcXFuM | 2187 | ||
Anita's Dance Factory-Old Hindi Songs Medley | This song contains a female voice singing in a high pitch along to strings playing their own supportive melody and percussion's holding a groove with different elements. This is an amateur recording. This song may be playing at a gym during dancing classes. | 2013-12-23T13:14:15Z | It's Anita Arora | Music: Aaj Phir Jeene Ki Tamana Hai-Guide Hothon Pe Aasi Baat-Jewal Thief Mera Naam Chin Chin Choo-Howrah Bridge http://www.anitasdancefactory.co.uk/ https://www.facebook.com/anitasdancefactory anitasdancefactory@mail.com | ["Singing", "Music", "Song", "Tambourine", "Music of Bollywood"] | ["hindi song", "female voice singing", "high pitch", "strings", "percussion's", "slower to medium tempo", "amateur recording"] | 6 | N_LKZjw9DLk | 2349 | |
Sallie Gets Grounded in 6 Days | This musical piece belongs to a cinematic scene. Strings are playing a creepy melody and fill in along with screeching sounds while there is the sound of someone knocking the door and then someone is screaming. | 2014-08-19T21:22:00Z | Jeremy Dragon-Shapeshifter | Credit to all who use grounded in number of days. Sallie would never stop being a trouble maker so she's grounded. XD Enjoy the episode, peeps. =) - created at http://goanimate.com/ | ["Music", "Thunk", "Inside, small room"] | ["cinematic/horror", "strings", "piano", "screeching sound", "high pitched screaming", "footsteps or door-knocking", "amateur recording"] | 6 | T5YZwhC7Br8 | 2808 | |
Francis Coppola singing Male Femmena | A male voice is singing loudly with an opera technique while an acoustic drum is playing along with a e-bassline. Underlined by strings playing a melody. This song may be playing at a wedding. | 2007-07-23T20:57:52Z | Francis Coppola | Russo's on the Bay Howard beach NYC- Born in Queens NYC Frankie singing mala femmena 2004. My Origin is from Pomigliano D'arco, Castello di Cisterno and Brusciano.; NAPOLI Mt. Versuvio | ["Singing", "Music", "/m/05zppz", "Vocal music", "/t/dd00003"] | ["italian ballad", "strings", "acoustic drums", "e-bass", "male opera voice", "mid range singing", "medium tempo", "amateur recording"] | 6 | zdtVT2xwrHU | 5500 |
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;