This chart shows national and regional trends of wastewater viral activity levels of SARS-COV-2.
Datasets can be downloaded as CSV files.
csvkit is a suite of command-line tools for converting to and working with CSV, the king of tabular file formats.
Convert XLS to CSV, JSON to CSV and vice-versa. Analyze and reorganize CSV files in various ways. Limited processing of the data. SQL-like querying of files. Import and export CSV files from Postgres.
The nationwide RadNet system monitors the nation's air to track radiation in the environment. Over time, RadNet sample testing and monitoring results show the fluctuations in normal background levels of environmental radiation. The RadNet system will also detect higher than normal radiation levels during a radiological incident.
I don't know if they have an API but there is a way to download parts of their data as CSV files.
Interactive query builder: https://radnet.epa.gov/radnet-public/query.do
Wastewater surveillance may complement other existing human surveillance systems to monitor influenza. Wastewater data cannot determine the source of influenza A viruses. Detections could come from a human or from an animal (like a bird) or an animal product (like milk from an infected cow).
No API but the data can be downloaded as a CSV file: https://www.cdc.gov/e0e53cec-a7e1-4357-a582-dd64f0cc3b1f
There is some data here that can be analyzed: https://www.cdc.gov/wcms/vizdata/NCEZID_DIDRI/FluA/H5N1Map.json
This has a tl;dr: https://www.cdc.gov/wcms/vizdata/NCEZID_DIDRI/FluA/H5N1Databites.json
Go to their editor. Paste in a well-formed data document. Watch it generate a graph for you out of the data. You can even download the generated image. No API yet.
Setup process:
cd jsoncrack.com
pnpm install
cd src
pnpm build
cd ..
You want to copy the contents of the out/ subdirectory up to your web server because that's where all the business is.
A utility that lets you query CSV, JSON and Parquet files with regular SQL statements. If DuckDB is okay with it, it'll run. Has both a fire-and-forget CLI and an interactive TUI.
This repository contains Open Source freely usable Threat Intel feeds that can be used without additional requirements. The file ThreatIntelFeeds.csv is stored in a structured manner based on the Vendor, Description, Category and the URL. The vendors offering ThreatIntelFeeds are described below. The following feed categories are available:
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.
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.