Skip to main content

US Nuclear Regulatory Commission (NRC)

Overview​

The US Nuclear Regulatory Commission (NRC) is an independent agency of the United States government that regulates the commercial use of nuclear materials. The NRC provides comprehensive data on nuclear reactor operations, including power reactor status reports, event notifications, and safety monitoring data. We currently track the Power Reactor Status Reports which provide detailed operational status information for all commercial nuclear power reactors in the United States.

Key Attributes​

Geographic CoverageUnited States
Entity LevelNuclear Power Plant
Time GranularityDaily
Release FrequencyDaily Updates
History1999 onwards

Description​

All Snowflake products follow the EAV (entity, attributes, value) model with a unified schema. Entities are tangible objects (e.g. geography, nuclear power plant) that Snowflake provides data on. All timeseries' dates and values that refer to the entity are included in a timeseries table. Descriptors of the timeseries are included in an attributes table. Data is joinable across all Snowflake products that have a GEO_ID. Refer to Snowflake Data Concepts for more details.

NRC data revolves around Nuclear Power Plant entities identified by unique reactor identifiers. The Power Reactor Status Reports contain daily operational data including:

  • Reactor Power Levels: Current power output as a percentage of rated capacity
  • Operational Status: Whether reactors are online, offline, or in maintenance
  • Event Notifications: Safety-related events and operational anomalies
  • Maintenance Windows: Planned and unplanned outages
  • Geographic Information: Plant locations and regional data

The data provides insight into nuclear power generation capacity, operational efficiency, and safety performance across the US commercial nuclear fleet. This information is valuable for energy market analysis, grid reliability planning, and regulatory compliance monitoring.

Sample Queries​

Find current operational status of all nuclear reactors

SELECT 
    ts.variable,
    att.plant_name,
    att.reactor_unit,
    ts.power_level_percent,
    ts.operational_status,
    ts.date
FROM public_data.nrc_reactor_status_timeseries AS ts
JOIN public_data.nrc_reactor_status_attributes AS att ON ts.variable = att.variable
WHERE ts.date = (SELECT MAX(date) FROM public_data.nrc_reactor_status_timeseries)
    AND ts.power_level_percent IS NOT NULL
ORDER BY ts.power_level_percent DESC;

Track power output trends for a specific plant

SELECT 
    ts.date,
    att.plant_name,
    att.reactor_unit,
    ts.power_level_percent,
    ts.operational_status
FROM public_data.nrc_reactor_status_timeseries AS ts
JOIN public_data.nrc_reactor_status_attributes AS att ON ts.variable = att.variable
WHERE att.plant_name = 'Diablo Canyon'
    AND ts.date >= DATEADD(month, -6, CURRENT_DATE())
    AND ts.power_level_percent IS NOT NULL
ORDER BY ts.date, att.reactor_unit;

Analyze regional nuclear capacity utilization by state

SELECT 
    att.state,
    COUNT(DISTINCT att.plant_name) AS num_plants,
    SUM(att.rated_capacity_mw) AS total_capacity_mw,
    AVG(ts.power_level_percent) AS avg_capacity_factor
FROM public_data.nrc_reactor_status_timeseries AS ts
JOIN public_data.nrc_reactor_status_attributes AS att ON ts.variable = att.variable
WHERE ts.date = (SELECT MAX(date) FROM public_data.nrc_reactor_status_timeseries)
    AND ts.power_level_percent IS NOT NULL
GROUP BY att.state
ORDER BY total_capacity_mw DESC;

Snowflake Products​

Tables above are available in the following Snowflake data products:

Disclaimers​

The data in this product is sourced from the US Nuclear Regulatory Commission.

Snowflake is not endorsed by or affiliated with any of these providers. Contact https://snowforce.my.site.com/s/consumer-reporting for questions.