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