Once data exists in structured form its reusability increases immensely.

For instance, I can construct a #CSV #URL scoped to my #GoogleSpreadheet (https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/gviz/tq?tqx=out:csv&range=A1:AA729&sheet=ConsolidatedFollows) that functions as a Data Source Name (#DSN) for automated conversion into a #KnowledgeGraph using terms defined in a variety of vocabularies.

Here's a #SPARQL Query against said Knowledge Graph.

https://linkeddata.uriburner.com/sparql?default-graph-uri=&query=%23+DEFINE+get%3Asoft+%22soft%22+%0D%0ASELECT+DISTINCT+%3Fwebid+%3Fname+%3FdateCreated%0D%0A+++++++%23+%28+IF%28+%3FfollowsCount+%3E+0%2C+%28%3FfollowsCount+%2F+%3FfollowersCount%29%2C+%22NA%22%29+AS+%3FfollowerTofolloweeRatio+%29%0D%0A+++++++%28xsd%3Ainteger%28%3FfollowersCount%29+AS+%3Ffollowers%29%0D%0A+++++++%28xsd%3Ainteger%28%3FfollowsCount%29+AS+%3Ffollows%29%0D%0A+++++++%0D%0AFROM+%3Curn%3Akidehen%3Amastodon%3Afollows%3E+%0D%0AWHERE+%7B+%0D%0A++++++++%3Fwebid+a+%3FentityType+%3B%0D%0A+++++++++++schema%3Aname+%3Fname+%3B%0D%0A+++++++++++schema%3Aidentifier+%3FlocalID+%3B%0D%0A+++++++++++schema%3AdateCreated+%3FdateCreated+%3B%0D%0A+++++++++++schema%3Adescription+%3Fdescription+%3B%0D%0A+++++++++++opltw%3AfollowersCount+%3FfollowersCount+%3B%0D%0A+++++++++++opltw%3AfollowsCount+%3FfollowsCount+%3B+%0D%0A+++++++++++schema%3AmainEntityOfPage+%3FmainEntityOfPage+.%0D%0A%0D%0A++++++%7D+%0D%0AORDER+BY+DESC+%28%3FdateCreated%29%0D%0A%0D%0A%0D%0A%0D%0A%0D%0A&should-sponge=&format=text%2Fx-html%2Btr&timeout=30000

Just click to explore.

/cc @observablehq @mauforonda @Mastodon @judell

#LinkedData #DataConnectivity