Skip to content

Latest commit

 

History

History
72 lines (57 loc) · 2.87 KB

README.md

File metadata and controls

72 lines (57 loc) · 2.87 KB

GeoNuclearData

This repository contains a database in MySQL format with information about nuclear power plants around the world.

Data formats

Data is also available in formats like JSON and CSV, including a denormalized form.

Tables structure

countries

  • code - ISO 3166-1 alpha-2 country code
  • name - country name in English

nuclear_power_plant_status_type

  • id - numeric id key
  • type - nuclear power plant status

nuclear_reactor_type

  • id - numeric id key
  • type - nuclear reactor type acronym
  • description - nuclear reactor type long form

nuclear_power_plants

  • id - numeric id key
  • name - nuclear power plant name
  • latitude - latitude in decimal format
  • longitude - longitude in decimal format
  • country_code - ISO 3166-1 alpha-2 country code
  • status_id - nuclear power plant status id
  • reactor_type_id - nuclear reactor type id
  • reactor_model - nuclear reactor model
  • construction_start_at - date when nuclear power plant construction was started
  • operational_from - date when nuclear power plant became operational (also known as commercial operation date)
  • operational_to - date when nuclear power plant was shutdown (also known as permanent shutdown date)
  • capacity - nuclear power plant capacity (design net capacity in MWe)
  • source - source of the information
  • last_updated_at - date and time when information was last updated

Notes

Do not use the data from source and last_updated_at columns as it is for maintenance purpose only.

Usage

SELECT npp.`id`
	,npp.`name`
	,npp.latitude
	,npp.longitude
	,c.`name` 'country'
	,s.type 'status'
	,r.type 'reactor_type'
	,npp.reactor_model
	,npp.construction_start_at
	,npp.operational_from
	,npp.operational_to
FROM nuclear_power_plants npp
INNER JOIN countries AS c ON npp.country_code = c.`code`
INNER JOIN nuclear_power_plant_status_type AS s ON npp.status_id = s.id
LEFT OUTER JOIN nuclear_reactor_type AS r ON npp.reactor_type_id = r.id
ORDER BY npp.`id`

License

The GeoNuclearData database is made available under the Open Database License whose full text can be found at https://opendatacommons.org/licenses/odbl/1.0/.

Any rights in individual contents of the database are licensed under the Database Contents License whose full text can be found at https://opendatacommons.org/licenses/dbcl/1.0/.

Sources

Countries data is taken from Unicode Common Locale Data Repository.

Nuclear power plants data is taken from WNA/IAEA, but some of it comes from Wikipedia.

Showcase