This GitHub repo provides the underlying source data for the Nationwide Wastewater Monitoring Network data visualizations at biobot.io/data. We provide both Biobot-generated wastewater SARS-CoV-2 concentrations and the associated clinical data used as comparison.
Biobot's data is the largest publicly available dataset on SARS-CoV-2 concentrations in wastewater.
We first launched a pro bono campaign to monitor COVID-19 in wastewater across the United States in March 2020, in collaboration with the Alm lab at MIT (Wu et al., 2020) (Wu et al., 2021) In June 2020, we transitioned to a full-service offering and currently have over 200 participating locations regularly monitoring SARS-CoV-2 wastewater concentrations in their communities on a weekly or monthly basis. As a result of this effort, we have generated a wastewater SARS-CoV-2 dataset consisting of nearly 20,000 samples.
Set up a free account, get access to NASDAQ data through their APIs.
The Covid Act Now API provides access to comprehensive COVID data — both current and historical. The data is available for all US states, counties, and metros and is aggregated from a number of official sources, quality assured, and updated daily. It is available in JSON and CSV formats.
A carefully curated list of CSV-related tools and resources
CSV remains the most futuristic data format from the distant past.
XML has risen and fallen. JSON is just a flash in the pan. YAML is a poisoned chalice. CSV will outlast them all.
When the final cockroach breathes her last breath, her dying act will be to scratch her date of death in a CSV file for posterity.
A Chrome extension that makes CSV files in your browser look pretty and thus easier to read without importing them into a spreadsheet application. Click on the toolbar icon, it'll ask you some questions, and then let it run.
A CLI tool that lets you run SQL queries against CSV and TSV (tab-separated values) files. This includes data from shell pipes, like the output of ps or other tools.
A list of interesting aircraft - Governments, Dictators, Military, Historic and just plain odd.
Schema:
ICAO,Ident,Operator,Type,CMPG,$Tag,#$Tag2,Category,#$Link
FormatExpress is an easy-to-use online formatter where you simply paste some bunch of raw XML, JSON, CSS or SQL, to get it automatically beautified. The most common use-case is to help reading minified input found in logs or web services.
A CLI tool to convert CSV / Excel / HTML / JSON / Jupyter Notebook / LDJSON / LTSV / Markdown / SQLite / SSV / TSV / Google-Sheets to a SQLite database file. Can also pull data from supplied URLs.
Convert CSV files into a SQLite database. Designed for use with Datasette. Requires Python 3.
Datasette provides an instant, read-only JSON API for any SQLite database, even those applications on your system maintain. It also provides tools for packaging the database up as a Docker container and deploying that container to hosting providers such as Zeit Now. Got CSV data? Use csvs-to-sqlite to convert them to SQLite. Runs its own webserver on localhost:8001 so you don't need to write code to use it, just point it at a .sqlite3 file.
Requires Python 3.
Command line utility which lets you run SQL queries against CSV and TSV files.
A set of online data analysis tools designed to teach you how to analyze data and not so much do all the heavy lifting for you. Word counter, CSV analysis and debugging, file diffing, and more.