W3C home > Mailing lists > Public > public-egov-ig@w3.org > July 2012

RE: The Olympics in Linked Data (Sort of)

From: Brand Niemann <bniemann@cox.net>
Date: Fri, 27 Jul 2012 21:21:08 -0400
To: "'Gannon Dick'" <gannon_dick@yahoo.com>, "'eGov IG \(Public\)'" <public-egov-ig@w3.org>
Cc: <public-lod@w3.org>
Message-ID: <0d5501cd6c5f$45b86de0$d12949a0$@cox.net>
http://gov.aol.com/2012/07/27/visualizing-data-guardian-shows-how-with-olymp
ic-medal-history/ with linked data

 

From: Gannon Dick [mailto:gannon_dick@yahoo.com] 
Sent: Friday, July 27, 2012 4:52 PM
To: eGov IG (Public)
Cc: public-lod@w3.org
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

 
Received on Saturday, 28 July 2012 01:21:44 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Saturday, 28 July 2012 01:21:45 GMT