FedSearch - Federated network search engine

By offering a #CSV export option it simplifies the process of creating a shared #GoogleSpreadsheet rendition which is also a one-click journey to a #KnowledgeGraph.

https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit#gid=1714230245&range=A1

#DataConnectivity #OpenWeb

#csv #googlespreadsheet #knowledgegraph #dataconnectivity #openweb

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

336 followers · 604 posts · Server mastodon.social

Open media

#URL that denotes a #CSV rendition of the #GoogleSpreadsheet hosted #Database.

https://docs.google.com/spreadsheets/d/1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios/gviz/tq?tqx=out:csv&range=A2:E108&sheet=AwesomeCollectionFromGithub

URL for generating a #KnowledgeGraph directly from the CSV link above.

https://linkeddata.uriburner.com/about/html/https://docs.google.com/spreadsheets/d/1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios/gviz/tq?tqx=out:csv&range=A2:E108&sheet=AwesomeCollectionFromGithub

URL for exploring Knowledge Graph:
https://linkeddata.uriburner.com/describe/?uri=https%3A%2F%2Flinkeddata.uriburner.com%2Fabout%2Fid%2Fentity%2Fhttps%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios%2Fgviz%2Ftq%3Ftqx%3Dout%3Acsv%26range%3DA2%3AE108%26sheet%3DAwesomeCollectionFromGithub

URL for page that describes an Ontology automatically derived from the CSV data:

https://linkeddata.uriburner.com/describe/?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios%2Fgviz%2Ftq%3Ftqx%3Dout%3Acsv%26range%3DA2%3AE108%26sheet%3DAwesomeCollectionFromGithub%23ontology&distinct=1

URL that denotes page about a specific item from the Awesome-nostr.

https://linkeddata.uriburner.com/describe/?url=https%3A%2F%2Flinkeddata.uriburner.com%2Fproxy-iri%2F78622369d227bdf0a3c9cb8e1a15b2188014319c&distinct=1

/cc @melvincarvalho @Mastodon

#url #csv #googlespreadsheet #database #knowledgegraph

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

336 followers · 595 posts · Server mastodon.social

Open media

Courtesy of #XSLT, #HTML Tidy, and #TSV output, here's a #Database published via a #GoogleSpreadsheet at:

https://docs.google.com/spreadsheets/d/1AzZKVS5v9_QA-UHObtVjknaBR1sRVO7d1xx44NeXios/edit#gid=0&range=A1

The source content is from the Awesome #nostr portal on #Github: https://github.com/aljazceru/awesome-nostr.

/cc @melvincarvalho

#xslt #html #tsv #database #googlespreadsheet #nostr #github

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

241 followers · 304 posts · Server mastodon.social

Open media

To generate a #KnowledgeGraph directly from a #CSV rendition of the #GoogleSpreadsheet, use the following #URL:

https://linkeddata.uriburner.com/describe/?url=https%3A%2F%2Fdocs.google.com%2Fspreadsheets%2Fd%2F18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw%2Fgviz%2Ftq%3Ftqx%3Dout%3Acsv%26sheet%3DFediverseLandscape%26range%3DA2%3AF169&sponger-get=add

And then click on the value of the "mainEntity" property to start exploration.

#LinkedData

#knowledgegraph #csv #googlespreadsheet #url #linkeddata

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

241 followers · 303 posts · Server mastodon.social

Open media

To obtain the content of the #GoogleSpreadsheet hosted #database, in #CSV format, you can issue the following #HTTP request.

https://carbon.now.sh/?bg=rgba%28171%2C+184%2C+195%2C+1%29&t=seti&wt=none&l=auto&width=680&ds=true&dsyoff=20px&dsblur=68px&wc=true&wa=true&pv=56px&ph=56px&ln=false&fl=1&fm=Hack&fs=14px&lh=133%25&si=false&es=2x&wm=false&code=curl%2520-kI%2520%2522https%253A%252F%252Fdocs.google.com%252Fspreadsheets%252Fd%252F18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw%252Fgviz%252Ftq%253Ftqx%253Dout%253Acsv%2526sheet%253DFediverse%2526range%253DA2%253AF169%2522%250AHTTP%252F1.1%2520200%2520OK%250AContent-Type%253A%2520text%252Fcsv%253B%2520charset%253Dutf-8%250AX-Robots-Tag%253A%2520noindex%252C%2520nofollow%252C%2520nosnippet%250ACache-Control%253A%2520no-cache%252C%2520no-store%252C%2520max-age%253D0%252C%2520must-revalidate%250APragma%253A%2520no-cache%250AExpires%253A%2520Mon%252C%252001%2520Jan%25201990%252000%253A00%253A00%2520GMT%250ADate%253A%2520Wed%252C%252007%2520Dec%25202022%252021%253A28%253A55%2520GMT%250AContent-Disposition%253A%2520attachment%253B%2520filename%253D%2522data.csv%2522%253B%2520filename*%253DUTF-8%27%27data.csv%250AContent-Length%253A%252028502%250Ave%250AServer%253A%2520Mastodon%250A

#HowTo

#googlespreadsheet #database #csv #http #howto

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

241 followers · 302 posts · Server mastodon.social

Open media

Delightful Fediverse Apps is a cool collection of #fediverse apps and services published to a #github repo at:

https://codeberg.org/fediverse/delightful-fediverse-apps

Here's a publicly accessible #GoogleSpreadsheet hosted #database generated from the repo that provides an alternative data view.

https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit#gid=2069391068&range=A2

#fediverse #github #googlespreadsheet #database

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

226 followers · 252 posts · Server mastodon.social

Open media

Extending my #GoogleSpreadsheet based #Database with new tabs per additional data source related to
#Mastodon accounts.

Naturally, that #spreadsheet will also double as foundation for #KnowledgeGraph generation that supports #SQL, #GraphQL and #SPARQL access.

Note the new #Wikidata tab!

* https://mastodon.social/@kidehen/109435758466961883 -- new data from Wikidata (derived from @egonw's query collection)

#googlespreadsheet #database #mastodon #spreadsheet #knowledgegraph #sql #graphql #sparql #wikidata

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

226 followers · 252 posts · Server mastodon.social

I am going to extend this #GoogleSpreadsheet based #Database with new tabs per additional data source related to @joinmastodon. Naturally, it will also double as foundation for #KnowledgeGraph generation that supports #SQL, #GraphQL and #SPARQL access.

Note new #Wikidata tab!

#googlespreadsheet #database #knowledgegraph #sql #graphql #sparql #wikidata

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

226 followers · 252 posts · Server mastodon.social

@mguhlin,

You could simply adopt the variant I made for subsequent entries.

It's just a #Database deployed using a #GoogleSpreadsheet.

Anyone that wants to import the data can do so via the #CSV rendition (a function or URL-patterns).

/cc @dougholton

#database #googlespreadsheet #csv

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

226 followers · 252 posts · Server mastodon.social

Open media

@dougholton,

Here's a rendition of your #GoogleSpreadsheet comprising a few #database centric tweaks 😀

https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/edit?usp=sharing

Benefits?

Easier to transform into a relational table via the #CSV export option (e.g., https://docs.google.com/spreadsheets/d/18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw/gviz/tq?tqx=out:csv&range=A1:J413) .

Also easier to transform into a webby #KnowledgeGraph.

http://linkeddata.uriburner.com/describe/?url=http%3A%2F%2Flinkeddata.uriburner.com%2Fabout%2Fid%2Fentity%2Fhttps%2Fdocs.google.com%2Fspreadsheets%2Fd%2F18Pi1AeQezbTdjjPcb6ol0Rxwx-hq5JkA4RoPsTapPqw%2Fgviz%2Ftq%3Ftqx%3Dout%3Acsv%26range%3DA1%3AJ413&gp=3&go=&lp=10&distinct=1

/cc @mguhlin @edutooters @judell

#googlespreadsheet #database #csv #knowledgegraph

Last updated 2 years ago

Original post

Kingsley Uyi Idehen · @kidehen

226 followers · 252 posts · Server mastodon.social

@simon,

The following also resolves to a page comprising an HTML Table that isn't readable via the ImportHtml() provided by #GoogleSpreadsheet for accessing Tables.

#googlespreadsheet

Last updated 2 years ago

Original post