DataHub v1 is the original DataHub catalog of 11,000+ open datasets, now migrated to PortalJS Arc.
Dataset

swissjazzorama

The Swiss Jazz archive calls itself SwissJazzOrama (SJO). Founded 1989 in Rheinfelden as "Pro Jazz Switzerland", it has been located in Uster near Zurich since 1998.

albums
musicians2albums
musicians
tracks
genres
instruments
About

The Swiss Jazz archive calls itself SwissJazzOrama (SJO). Founded 1989 in Rheinfelden as "Pro Jazz Switzerland", it has been located in Uster near Zurich since 1998.

SwissJazzOrama collects and archives all kinds of sound carriers, pictures, literature and other testimonies from the Jazz universe. It collects information about as many different types of Jazz as possible. Whether it is published/unpublished, popular/fringe. The SwissJazzOrama volunteers enter these documents in databases that are continuously updated and provide quick access.

This dataset contains part of the database queryable at http://jazzdaten.ch, the database where all of the various pieces of information it collects about the music are stored. First and foremost, it contains music metadata related to Switzerland:

  • Recordings by or featuring Swiss artists
  • recordings of concerts in Switzerland
  • releases of Swiss labels
  • Recordings of music by Swiss composers

The data was first released in 2016 on occasion of the 2nd Swiss Open Cultural Data Hackathon. To encourage its reuse a JSON data package (view source, more information and tools) containing metadata that describes the structure and contents of the package as well as the JSON Table Schemas (more information) describing the tables were added by the uploader. These files were not provided nor checked by the data provider.

Please note: SwissJazzOrama has a media collection, but cannot provide digital access to any of the recordings!

Download & API
albumscsv
Releases table
Download
musicians2albumscsv
Relations between musicians and releases
Download
musicianscsv
Musicians table
Download
trackscsv
Tracks table
Download
genrescsv
Genres table
Download
instrumentscsv
Instruments table
Download
datapackage.jsonjson
A [data package](http://data.okfn.org/tools/view?url=https%3A%2F%2Fdatahub.io%2Fdataset%2Ff48d986e-71f0-4a77-b3f1-2ed10a36cb50%2Fresource%2F03a8726c-91aa-41a2-8965-2427c33526e6%2Fdownload%2Fdatapackage.json) ([more information](http://dataprotocols.org/data-packages/)) containing the metadata that describes the structure and contents of the package and its resources such as data files that form the contents of the package. Created by the uploader, not the data provider.
Download
musicians2trackszip:csv
Relations between musicians and tracks
Download
db_overviewpdf
Graphical overview of the jazzdaten database
Download
SQL dump of tableszip:sql
#### Prepare system #### 1. Install MySQL/MariaDB 2. Create database, e.g. `jazzora_jazzschweiz` #### Import Files in ascending order, e.g. using the command line: #### `mysql -u root -p jazzora_jazzschweiz < Alben_r.sql` `mysql -u root -p jazzora_jazzschweiz < Genre.sql` `mysql -u root -p jazzora_jazzschweiz < Instrumente_r.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Alben.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_0.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_1.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_2.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_3.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_4.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_5.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_6.sql` `mysql -u root -p jazzora_jazzschweiz < Link_Musiker2Tracks_r_7.sql` `mysql…
Download
readmetxt
Download
Sources & license
License
  • cc-zero