musiccaps_details (view)
4 rows where musiccaps_aspects contains "accordion", musiccaps_author = 3 and musiccaps_names contains "Music"
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Oromo Wedding Reception Entrance at Forum Banquet Halls in Toronto | Forever Video | This song has a traditional African Arabic feel to it. There is an accordion, an upbeat vibe, and an ethnic vocal performance by the male vocalist. It is a live recording and the audio quality is not professional. | 2010-04-08T10:02:47Z | Forever Video - Toronto Videography Photography | The video is about the grand entrance at an Oromo wedding reception at Forum Banquet Halls & Convention Center in Rexdale Toronto. For more wedding reception grand entrance: https://bit.ly/3aWBsnA. Forum Banquet Halls & Convention Center is one of the economic wedding halls we can suggest. The Forum Banquet Halls address: 1771 Albion Rd, #2, Toronto, ON M9W 5S7. Forever Video provides experienced videographers and photographers for weddings, sweet sixteen birthday parties, bar/bat mitzvah, baptisms, anniversaries, commercial, corporate events, and all events at affordable prices in Toronto, Ontario, and Canada. Please feel free to contact us if you require videographers or photographers' services for your weddings, birthday parties, or any other event in Toronto (phone: 647-500-0898, 416-519-8433, email: info@forever-video.com), website: https://www.forever-video.com. To watch more than 2,000 weddings, birthday parties, or any other special event videos that our videographers and photographers filmed in Canada and USA, please visit our YouTube channel and SUBSCRIBE. For your convenience, we organize our videos into different playlists, which are composed of similar or related videos on a particular subject. Our YouTube Channel: https://bit.ly/3hBLyLT Wedding and Event PHOTO Samples: https://bit.ly/2LgrwdO 1. The Bride & Groom's Key Moments on a Wedding Day：https://bit.ly/3n8LgNH 2. Banquet Halls and Event Venues | Birthday and Anniversary Parties：https://bit.ly/3prD7FN 3. Indian Weddings, Birthday Parties, and Special Events in Toronto：https://bit.ly/3hAhaSn 4. Chinese Weddings, Wedding Officiant, and MC：https://bit.ly/2JHVgjA 5. Wedding Videos (in Nationality Alphabet Order: A - I)：https://bit.ly/3b2kLr9 6. Wedding Videos (I - P)：https://bit.ly/3rNNWUI 7. Wedding Videos (P - Z)：https://bit.ly/3rUEH6J 8. Editor's Pick: Weddings, Birthday Parties, and Events：https://bit.ly/3xV3Py7 9. Cooperate and Private Events：https://bit.ly/3odPrcA 10. Entertainment Events：https://bit.ly/39jHErc 11. Uplo… | ["Music", "Wedding music", "Music of Latin America"] | ["live recording", "male ethnic vocals", "low quality audio", "traditional african arabic music", "somali music", "upbeat", "fun", "dance", "celebration", "accordion"] | 3 | 2YAyM0aHFRU | 375 | |
| NAWAZ SHARIF "SONG"HUM DEKHEN GAY | This is a traditional south asian song. We have an accordion-like instrument for the melodic component and a tabla for percussion. The singer has a passionate voice. The audio quality is poor and the song distorts. | 2010-08-21T08:14:10Z | TheSaifpakiloverboy | ["Music", "Middle Eastern music"] | ["south asian music", "low quality audio", "distortion", "accordion", "tabla", "passionate male vocalist"] | 3 | GjE_iD2BbFg | 1751 | ||
| Quartet "Salut Salon" | This is a live performance by a female vocal quartet. They harmonise their voices and sing in a vibrant and cheerful way. They sing in French. Later, we hear two violins playing in sync as well as an accordion. The recording quality of the audio is poor. | 2009-07-26T14:05:26Z | Dina Anunziata | "Heartache" concert of the Hamburgs quartet "Salut Salon" performed in St.Petersburg, Russia during "Week of Germany" | ["Music", "Musical instrument", "Violin, fiddle", "Classical music", "Bowed string instrument", "A capella"] | ["live recording", "live performance", "female singing quarter", "poor audio quality", "violins", "accordion", "cheerful", "happy", "upbeat", "harmonies", "vintage european"] | 3 | YErpnsceZw8 | 3268 | |
| schöne arabische musik | This is a middle eastern song with a rapid and intricate accordion melody as the main basis. The song would be suitable as a backing track for a belly dancer. There's a traditional percussion instrument in the background. | 2011-06-27T13:50:49Z | ChandaniRani | ... | ["Folk music", "Music"] | ["arabic music", "middle eastern", "accordion", "upbeat", "dance", "belly dance", "intricate percussion", "traditional percussion instruments"] | 3 | vrNQbCbBlLY | 5212 |
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;