Skip to content

Latest commit

 

History

History
126 lines (96 loc) · 7.81 KB

README.md

File metadata and controls

126 lines (96 loc) · 7.81 KB

GeoNuclearData

This repository contains a database with information about Nuclear Power Plants worldwide.

Version

Database version: 0.17.0 (2020/04/19)
Dataset last updated in version: 0.17.17 (2024/03/03)

Changelog

See CHANGELOG file for details.

Data formats

Data is available in multiple formats (MySQL, JSON, and CSV).

Quick database summary (by reactor status)

Status Count Diff
Unknown 1
Planned 79 -1
Under Construction 61 +1
Operational 414 +3
Suspended Operation 25 -2
Shutdown 209
Suspended Construction 6
Cancelled Construction 4
Never Commissioned 2
Decommissioning Completed 3 0
Total 804 +1

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
  • iaea_id - IAEA PRIS reactor id

Notes

Data from source, last_updated_at, and iaea_id columns is for maintenance purposes only and is not recommended to be used.

Known Inconsistencies (GeoNuclearData vs. WNA vs. IAEA PRIS)

Operational Reactors

  • there are currently 414 reactors listed as being operational in the GeoNuclearData database, including China Experimental Fast Reactor (CEFR);
  • the PRIS database lists only 413 reactors as being operational (China Experimental Fast Reactor (CEFR) is not listed anymore) while the WNA's database has a slightly distinct category named Operable Reactors that probably also includes reactors in Suspended Operation.

Reactors Under Construction

  • The number of reactors listed as being under construction in the GeoNuclearData database does not match with either the number of reactors under construction from WNA's database or with the number from the PRIS database:
    • BALTIC-1 reactor (Russia) is shown as under construction in PRIS, but it was removed from the WNA's database in November 2000 (see here);
  • In addition to the list of reactors under construction from the PRIS database, the GeoNuclearData database also contains the following reactors (as in WNA's database):

Naming

  • The GeoNuclearData database usually follows the naming conventions from PRIS for reactors, but in WNA's database some nuclear reactors have completely different names. Some examples are:

Coordinates

  • the coordinates found in GeoNuclearData database are approximate;
  • the original source for the existing coordinates was an old Google Fusion Table dating back to March 2012 (probably sourced from WNA). Since the inception of this database some of the coordinates were manually corrected using Wikipedia/GeoHack and/or satellite imagery from Google Maps;
  • the operational Akademik Lomonosov-1 and 2 reactors (Russia) and planned Bohai Shipyard FNPP and Jiaodong Shipyard FNPP (China) reactors are floating nuclear power plants thus the coordinates from this database may not necessarily indicate their current location.

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 other sources are used, e.g., Wikipedia.

WNA data is also taken from the IAEA PRIS reactor database, with more recent information added if available (see here).