Edward Tanguay's list of realistic API data

This is a list of API data useful for creating realistic coding examples that consume APIs.

Feel free to use this data any way you want.

json data and images stored on this site:

icons: e.g. https://tanguay-eu.vercel.app/share/images/icons/five.png
jobs and skills - two files in which i record a new job ad each day and the skills needed for it, these files are used by the site jobs.tanguay.eu
HTML Colors - over 100 HTML colors with HEX code
- http://edwardtanguay.vercel.app/share/htmlcolors.json
Emojis - over 1000 emojis as array
- http://edwardtanguay.vercel.app/share/emojis.json
techitems - my notes on computer languages, software, frameworks, etc.
- http://edwardtanguay.vercel.app/share/techitems.json
Fake Store API
- https://fakestoreapi.com
flashcards - my flashcards on tech topics, e.g. linux commands, git commands, etc.
- http://edwardtanguay.vercel.app/share/flashcards.json
germannouns - mostly german tech nouns with article, singular and plural, useful for e.g. die/der/das practice
- http://edwardtanguay.vercel.app/share/germanNouns.json
books - these are general books I have read or am reading, mostly on history, politics, philosophy
- http://edwardtanguay.vercel.app/share/books.json
- images: http://edwardtanguay.vercel.app/share/images/books/<idcode>.png
- e.g. http://edwardtanguay.vercel.app/share/images/books/epicofgilgamesh.png
- to reference book images locally in your site, download all techBook images here: books.zip
tech books - these are tech books mostly on web development and linux administration that i am currently reading
- http://edwardtanguay.vercel.app/share/techBooks.json
- images: http://edwardtanguay.vercel.app/share/images/techBooks/<idcode>.jpg
- e.g. http://edwardtanguay.vercel.app/share/images/techBooks/bashCookbook.jpg
- to reference tech book images locally in your site, download all techBook images here: techBooks.zip
employees - this is the northwind employees file with corresponding images created with the site thispersondoesnotexist.com generated with this bash script
- http://edwardtanguay.vercel.app/share/employees.json
- images: http://edwardtanguay.vercel.app/share/images/employees/employee_<employeeid>.jpg
- e.g. http://edwardtanguay.vercel.app/share/images/employees/employee_1.jpg
- employees.zip
SWAPI - READ-ONLY API about the Star Wars movies
- https://swapi.dev
planets and moons - data from nasa on planets and satellites (moons) that are orbiting them
- http://edwardtanguay.vercel.app/share/nasa-planets.json
  - Mass (1024kg)
  - Diameter (km)
  - Density (kg/m3)
  - Gravity (m/s2)
  - Escape Velocity (km/s)
  - Rotation Period (hours)
  - Length of Day (hours)
  - Distance from Sun (106 km)
  - Perihelion (106 km)
  - Aphelion (106 km)
  - Orbital Period (days)
  - Orbital Velocity (km/s)
  - Orbital Inclination (degrees)
  - Orbital Eccentricity
  - Obliquity to Orbit (degrees)
  - Mean Temperature (C)
  - Surface Pressure (bars)
  - Number of Moons (number)
  - Ring System? (Yes/No)
  - Global Magnetic Field? (Yes/No)
- http://edwardtanguay.vercel.app/share/nasa-satellites.json
  - planet: id of parent planet
  - name: name of the satellite
  - gm: GM (km3/sec2)
  - radius: Mean radius (km)
  - density: Mean density (g/cm3)
  - magnitude: Magnitude V0 or R
  - albedo: Geometric Albedo
tech books unstructured - these are 10 books which have incongruent data, e.g. properties are missing, not conform, etc. for use in api examples to show how to perform data cleansing
- http://edwardtanguay.vercel.app/share/techBooksUnstructured.json
- images: http://edwardtanguay.vercel.app/share/images/techbooks/<idcode>.jpg
- e.g. http://edwardtanguay.vercel.app/share/images/techbooks/bashcookbook.jpg
spanish verbs unstructured - these are rough notes on spanish verbs in json format, good for demonstrations how to derive clean data out of unstructured data
- http://edwardtanguay.vercel.app/share/techbooksunstructured.json
developer jobs and skills - job ads
- http://edwardtanguay.vercel.app/share/jobs.json
- http://edwardtanguay.vercel.app/share/skills.json

Other APIs and JSON files with realistic data:

Gutenberg Books - a searchable catalog of Gutenberg books, includes links to full text of books, images, and zip files
- https://gutendex.com/books/?search=berlin
Northwind Database - this is the 1990s sample database that was shipped with the Microsoft Access database, useful for coding examples since the tables have primary and foreign keys that relate the data together, e.g. customers contains orders which contain products, etc.
- https://github.com/graphql-compose/graphql-compose-examples/tree/master/examples/northwind/data/json
dummyjson.com - a full API that allows GET, POST, PUT, PATCH and DELETE operations
- https://dummyjson.com
mockaroo.com - mock data
- https://mockaroo.com
restcountries.com - info about countries and cities
- has a good example of how to do versioning for a REST API
- main site
- info on Germany
- info on capital city of Peru
themealdb a recipe API

SQLite Databases with realistic data:

Northwind Database - this is the SQLite version of the 1990s sample database that was shipped with the Microsoft Access database, useful for coding examples since the tables have primary and foreign keys that relate the data together, e.g. customers contains orders which contain products, etc.
- DOWNLOAD: northwind_database.zip

Flashcard/Category database - this is the SQLite database for the fullstack project Fullstack React site that uses backend API with SQLite data source, it has two tables flashcards and categories that can be connected in queries with a JOIN statement
- DOWNLOAD: db-flashcards-categories.zip

Other

20 user icons (zip file)

version 1.2