Experiments


Whose Birthday is Today?

chdl-0001-c

See performers and composers from Carnegie Hall’s performance history who were born on this day. Click on each name to view information on that person from our online Performance History Search, and view matching items in Wikidata.

read lab report return to experiments

Birth Year Name with PHS Link Birth Place Matching Wikidata Item
1684 Johann Gottfried Walther born in Erfurt Wikidata Item
1765 Oliver Holden born in Shirley Wikidata Item
1786 Justinus Andreas Christian Kerner born in Ludwigsburg Wikidata Item
1859 John L. Bates born in Easton Wikidata Item
1859 Victor Kuzdo born in Budapest No Wikidata Item
1860 Alberto Franchetti born in Turin Wikidata Item
1860 Clinton Scollard born in Clinton Wikidata Item
1872 Carl Friedberg born in Bingen am Rhein Wikidata Item
1875 Henriette Renié born in Paris Wikidata Item
1893 Arthur Benjamin born in Sydney Wikidata Item
1894 Willard Robison born in Shelbina Wikidata Item
1897 Pablo Sorozábal born in Donostia-San Sebastián Wikidata Item
1897 Sam H. Stept born in Odessa Wikidata Item
1897 Hugh Porter born in Heron Lake No Wikidata Item
1900 Willis Laurence James born in Montgomery Wikidata Item
1905 Agnes De Mille born in New York City Wikidata Item
1905 Eddie Anderson born in Oakland Wikidata Item
1909 Alexandre Derevitsky born in Naples Wikidata Item
1909 Irvin Graham born in Philadelphia Wikidata Item
1910 Josef Tal born in Pniewy Wikidata Item
1910 Leon Stein born in Chicago Wikidata Item
1918 Willis Page born in Rochester Wikidata Item
1923 Bill Irwin born in New York City No Wikidata Item
1926 Tadeusz Kerner born in Warsaw No Wikidata Item
1937 Norman Dinerstein born in Springfield No Wikidata Item
1939 Steve Marcus born in New York City Wikidata Item
1941 Hafliði Hallgrimsson born in Akureyri Wikidata Item
1942 Robert S. Frost born in Albany Wikidata Item
1943 Imant Raminsh born in Ventspils Wikidata Item
1944 Michael Franks born in La Jolla Wikidata Item
1946 Veikko Juntunen born in Posio Wikidata Item
1949 Thomas Fulton born in Memphis Wikidata Item
1951 Ben Carson born in Detroit Wikidata Item
1953 John McGlinn born in Bryn Mawr Wikidata Item
1955 Louis Sauter born in Rome No Wikidata Item
1956 Umewaka Kisho born in Japan No Wikidata Item
1960 Stephen Flaherty born in Pittsburgh Wikidata Item
1963 John Powell born in London Wikidata Item
1971 Anna Netrebko born in Krasnodar Wikidata Item
1972 Simone Dinnerstein born in New York City Wikidata Item
1975 Balázs Havasi born in Hungary Wikidata Item
1977 Cody J. Wright born in San Diego No Wikidata Item
1979 Simon Trpceski born in Skopje Wikidata Item
1980 Jonathan Biss born in Bloomington Wikidata Item

lab report


EXPERIMENT LABEL/TITLE

List: Whose Birthday is Today?

TL;DR

See which composers and performers from Carnegie Hall’s performance history were born on this day, with their birth year, birthplace, and a link to their corresponding Wikidata item.


The scope is limited to those people for whom we have birthdate and birthplace information.

METHODS

We created a SPARQL query using data.carnegiehall.org, which finds people from Carnegie Hall's performance history (e.g. performers, and/or creators like composers, arrangers, lyricists, etc.) born on today's date. Since birthdates have been stored as ISO-8601 dates assigned datatypes like xsd:date (YYYY-MM-DD), xsd:gYearMonth (YYYY-MM), or xsd:gYear (YYYY), we can use SPARQL's FILTER to find only those people born on today's month and day. Birthplaces are identified using GeoNames URIs (when the birth city is not known, birth country will be used; people with no birthplace recorded will not appear in the query). The query will also return the Wikidata item ID for anyone whose Carnegie Hall ID has been aligned with Wikidata using the skos:exactMatch property.


              PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
              PREFIX dbo: <http://dbpedia.org/ontology/#>
              PREFIX schema: <http://schema.org/##>
              PREFIX foaf: <http://xmlns.com/foaf/0.1/##>
              PREFIX geo-pos: <http://www.w3.org/2003/01/geo/wgs84_pos##>
              PREFIX skos: <http://www.w3.org/2004/02/skos/core##>
              SELECT ?personName ?birthPlace ?birthPlaceLabel ?lat ?long ?opasID ?wikidataLink (YEAR(?date) as ?year)
              (IRI(CONCAT("https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&pf=",
                            (STR(ENCODE_FOR_URI(?personName))))) AS ?perfLink)
              (IRI(CONCAT("https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&cmp=",
                            (STR(ENCODE_FOR_URI(?personName))))) AS ?compLink)
              WHERE
              {
                  BIND(MONTH(NOW()) AS ?nowMonth)
                  BIND(DAY(NOW()) AS ?nowDay)

                  ?personID schema:birthDate ?date ;
                          foaf:name ?personName ;
                          dbo:birthPlace ?birthPlace .
                  ?birthPlace rdfs:label ?birthPlaceLabel ;
                              geo-pos:lat ?lat ;
                              geo-pos:long ?long .
                  OPTIONAL { ?personID skos:exactMatch ?wikidataLink .
                      filter contains(str(?wikidataLink), "wikidata")}
                  BIND(REPLACE(str(?personID), "http://data.carnegiehall.org/names/", "") as ?opasID)
                  FILTER (MONTH(?date) = ?nowMonth && DAY(?date) = ?nowDay)

              }
              ORDER BY ?year
              LIMIT 100
            

In order to provide an easily human-readable version of each person’s history at the hall, we also use SPARQL to create a link to Performance History Search, an HTML presentation of essentially the same dataset that we published first in 2013 (and predates our experiments with LOD). (In the query, this is found right after the SELECT statement, where you'll see (IRI(CONCAT( etc.)

CONCLUSIONS

what we learned

You might be asking why we need to formulate different versions of the PHS link. The HTML version launched in 2013, well prior to our release of the same data as RDF in 2017; although the source database is the same, the process that translates the data for display is a bit different and was developed separately. This creates a few challenges when attempting to create links to PHS search filters:

  • Our source database for CH’s performance history data, a proprietary SQL-based product designed for concert planning, stores performers and composers in separate tables. When the data is surfaced in the HTML Performance History Search (PHS), that separation between composers and performers remains. Query filters are constructed from a search index based on the name string of the composer or performer.
  • Our RDF version of the data solves this problem of (potential) dual IDs by creating a single ID for each named entity, with statements defining their role according to associations with creative works (as a composer, arranger, lyricist, etc.) and/or events (as a performer).
  • In order to construct the PHS link, a URL-safe version of the Wikidata item label (i.e. the name of the composer or performer, with URL-encoded characters replacing spaces and other reserved characters) must be concatenated with a base URL, e.g. https://www.carnegiehall.org/About/History/Performance-History-Search?q=&dex=prod_PHS&pf=Juan%20Tizol.

further investigation

Eventually our goal is to bring all online historical content — our performance history and digital collections — into a single, unified user experience using our LOD as the metadata "backbone". The Carnegie Hall Data Lab is a first step in that direction, where we can begin experimenting with user-friendly ways to surface our performance history data.


return to experiments