id	author	title	date	pages	extension	mime	words	sentences	flesch	summary	cache	txt
lawlesst-github-io-5080		Ted Lawless			.xml	application/rss+xml	1735	87	64	Note: The online Datasette that supported the sample queries below is no longer available The raw data is at: https://github.com/lawlesst/new-yorker-fiction-podcast-data. Summary: The Datasette API available at https://baseballdb.lawlesst.net now contains the full Lahman Baseball Database. Summary: publishing the Lahman Baseball Database with Datasette API available at https://baseballdb.lawlesst.net. For those of us interested in open data, an exciting new tool was released this month It's by Simon Willison and called Datasette Datasette allows you to very quickly convert CSV files to a sqlite database and publish on the web with an API Head over to Simon's site for more details The code below is an example of issuing a query to the Wikidata SPARQL endpoint and loading the data into a pandas dataframe and running basic operations on the returned data. With a few lines of code, we can connect data stored in SPARQL endpoints with pandas, the powerful Python data munging and analysis library.	./cache/lawlesst-github-io-5080.xml	./txt/lawlesst-github-io-5080.txt