-
Postcodes (1,549,815 postal codes, 96 countries)
-
NYC Yellow Taxi Rides (246k rows - Jan 2022 example)
-
IMDb (12,188,623 names)
-
High Accuracy Locations (90k places from 216 countries)
-
Airports (74,451 airports)
-
MySQL.com example datasets (airportdb - 54,304,619 bookings)
These APIs are publicly accessible and require no login information.
Example curl and output provided
- AWS regions
- Beer styles
- Chess
- Dictionary word
- DuckDuckGo search results
- Earthquakes from USGS
- Gender of name
- github
- International Space Station (ISS) location
- News Headlines
- OpenStreetMap
- Postman
- State of Missouri Data Portal
- UK National Archives
- WikiData
These APIs are accessible for free, generally after registering your email.
- Amadeus Flight Data (Free API Key Required)
- Stocks - https://polygon.io/stocks
- US Congress (ProPublica) - https://www.propublica.org/datastore/api/propublica-congress-api (Free API Key Required)
- https://mixedanalytics.com/blog/list-actually-free-open-no-auth-needed-apis/
- https://apipheny.io/free-api/
- https://rapidapi.com/collection/list-of-free-apis, https://rapidapi.com/blog/most-popular-api/
- Airports - https://ourairports.com/data/
- Austin Texas MetroBike Data - https://data.austintexas.gov/Transportation-and-Mobility/Austin-MetroBike-Trips/tyfh-5r8s
- AWS Data Sets - https://registry.opendata.aws/
- CIA Factbook - https://www.cia.gov/the-world-factbook/about/archives/
- Data Hub - https://datahub.io/
- EPA Air Quality Datasets - https://www.epa.gov/outdoor-air-quality-data
- European Commission - https://data.europa.eu/en
- Freebase N-Triples (Archived copy) - https://developers.google.com/freebas
- Free GIS Data List - https://freegisdata.rtwilson.com/
- Free Music Archive - https://github.com/mdeff/fma
- GCP BigQuery Data Sets - https://cloud.google.com/bigquery/public-data
- GCP Data Sets- https://cloud.google.com/datasets
- GeoNames Data Sources - https://www.geonames.org/datasources/
- Google Public Data - https://www.google.com/publicdata/directory
- Google Dataset Search - https://datasetsearch.research.google.com/
- HathiTrust Digital Library - https://babel.hathitrust.org/
- International Monetary Fund (IMF) - https://data.imf.org/
- Internet Movie Database (IMDB) Data - https://www.imdb.com/interfaces/
- Ireland Open Data - https://data.cso.ie/
- ISBN (books) Database - https://isbndb.com/
- LibriSpeech ASR corpus (Audio data) - http://www.openslr.org/12/
- Kaggle - https://www.kaggle.com/
- Machine Learning Datasets - https://paperswithcode.com/datasets
- Million Songs Data - http://millionsongdataset.com/
- MovieLens Datasets - https://grouplens.org/datasets/movielens/
- NASA Data - https://data.nasa.gov/
- Nations Online - https://www.nationsonline.org/oneworld/information_sources.html
- NYC Citi Bike Ride History https://ride.citibikenyc.com/system-data
- NYC MTA https://bustime.mta.info/wiki/Developers/Index
- NYC Yellow Cab Ride History https://www.nyc.gov/site/tlc/about/tlc-trip-record-data.page
- Open Library - https://openlibrary.org/, https://openlibrary.org/developers/dumps
- Open Flights - https://openflights.org/data.html
- Organisation for Economic Co-operation and Development (OECD) Data https://data.oecd.org/
- Project Gutenberg (Free books) - https://www.gutenberg.org/
- Queensland Government DataSets - https://www.data.qld.gov.au/dataset/
- World Bank - https://data.worldbank.org/
- UK Open Data - https://www.data.gov.uk/
- US Census Data - https://data.census.gov/
- US Department of Transportation - https://www.transtats.bts.gov/DataIndex.asp
- US National Center for Education Statistics - https://nces.ed.gov/ccd/ccddata.asp
- US National Centers for Environmental Information (NOAA) - https://www.ncdc.noaa.gov/cdo-web/datasets
- US Government - https://data.gov/
- US Zip Codes - https://simplemaps.com/data/us-zips (Free & Paid), https://www.unitedstateszipcodes.org/zip-code-database/ (Free & Paid)
- United Nations Data - https://data.un.org/
- Yahoo Datasets - https://webscope.sandbox.yahoo.com/catalog.php?datatype=i&did=67
- Wikipedia Statistics - https://en.wikipedia.org/wiki/Wikipedia:Statistics
- World Bank - https://data.worldbank.org/
- OpenAIRE - https://explore.openaire.eu/
- AFL xScores - https://github.com/adamtunney/xScores/
- Brewery Data - https://openbrewerydb.org/
- Awesome Public Datasets - https://github.com/awesomedata/awesome-public-datasets
- Public Cloud Provider IP Ranges - https://github.com/tobilg/public-cloud-provider-ip-ranges
- TPC-H Data Files - https://github.com/tripl-ai/tpch/
- Open AQ Air Quality - https://openaq-data-archive.s3.amazonaws.com/
- Amazon Items and Reviews - https://amazon-reviews-2023.github.io/
- Countries as Polygons - https://datahub.io/core/geo-countries
- GeoNames - http://www.geonames.org/
- AWS Edge Locatinos - https://github.com/tobilg/aws-edge-locations
These datasets include load capabilities for databases. Attribution as noted.
- MySQL
- MySQL example databases including employee, Sakila, world, airport DB and menagerie.
- MySQL Sample database ecommerce
- MySQL Datacharmer employee database
- https://www.mockaroo.com/ (Free - Login Required)
- https://generatedata.com/ (Free - Login Required)
- https://www.onlinedatagenerator.com/
- https://www.fakenamegenerator.com/
- Test Data Generator https://smalldev.tools/test-data-generator-online
- FakerJS - https://fakerjs.dev/
- data.world - https://data.world/
- Nasdaq - https://data.nasdaq.com/search?filters=%5B%22Free%22%5D
- Aviation Tracking - https://aviation-edge.com/
- Crawl Feeds - https://crawlfeeds.com/datasets
- World Weather - https://meteostat.net/en/
- OAG Flight Data - https://www.oag.com/flight-data-sets
- ESRI (gdb) to GeoJSON https://mygeodata.cloud/converter/gdb-to-geojson
- Public Real-time streaming datasets - https://github.com/bytewax/awesome-public-real-time-datasets
- Mock Data Generator - https://github.com/tinybirdco/mockingbird/