Wow, a very pretty (and informative) visualization. It certainly could not have been done without linked data and the "advertising model" can not do it, IMHO*. Wait a minute, you're one of those <i>Data Journalists</i> guys I've heard about, right ? --Gannon
* Metadata about Olympic Medals has related verifiable facts, just as a probable location for Fans relies on locations which already exist. The advertising model uses predictions (and a bit of magic) to create a virtual location suitable for a Fan to live. The big advertising model also creates lamed virtual institutions ... a Library with no books is just another rooftop. I'll leave that aside for the moment. ________________________________ From: Brand Niemann <[email protected]> To: 'Gannon Dick' <[email protected]>; 'eGov IG (Public)' <[email protected]> Cc: [email protected] Sent: Friday, July 27, 2012 8:21 PM Subject: RE: The Olympics in Linked Data (Sort of) http://gov.aol.com/2012/07/27/visualizing-data-guardian-shows-how-with-olympic-medal-history/ with linked data From:Gannon Dick [mailto:[email protected]] Sent: Friday, July 27, 2012 4:52 PM To: eGov IG (Public) Cc: [email protected] Subject: The Olympics in Linked Data (Sort of) All, It occurred to me this morning that the Olympics provides an interesting example of Social Networking. I made four tables in xhtml and CSV. http://www.rustprivacy.org/2012/roadmap/olympics/ or http://www.rustprivacy.org/2012/roadmap/olympics/olympics.zip 1. all_keys (676 Rows) 2. team_keys (203 Rows) 3. v_fan_counts (242 Rows) 4. v_fan_places (4348 Rows) CSV Only a. (1) includes the ISO 639-1 two character codes, Country Names in English and French, and links to the LOC id Servers. b. In addition, (1) includes a "Virtual Fan Of" key. This table includes all possible two character codes. Some Countries do not have Teams. c. (2) includes a cross reference to the Official Teams. The Teams are not "National", and some Countries field multiple Teams (e.g. Puerto Rico has its own Team). d. The Fans of a Country may be related to multiple Teams, and a Country may be related to multiple places, internal or overseas, States, Territories, etc. e. (3) is a list of the relations, with counts of the subdivisions. There are 39 "extra" places Fans can lurk, which do not field Teams. f. (4) CSV Only, link on the (3) page is a full listing of all the States, Provinces, etc. where Olympic Fans dwell. g. The Linked Data URI's are of the form {dot gov dot country code}. Hopefully no one will easily convert them to URL's (which won't work) Snarky initial observations ------------------------------------ Aland Islanders are rooting for Team Finland. Sorry to spoil the surprise. You did not miss Team Vatican City at the opening ceremonies. They have Fans, though. Not all Fans are included, since Fans are not "rational". UK Fans root for the UK but are included anyway, however irrational they may be. Ain't Linked Data Grand ? (have fun) --Gannon
