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 
    plant_name,
    reactor_unit,
    current_power_level,
    operational_status,
    last_update_date
FROM public_data.nrc_reactor_status
WHERE last_update_date = (SELECT MAX(last_update_date) FROM public_data.nrc_reactor_status)
ORDER BY current_power_level DESC;

Track power output trends for a specific plant

SELECT 
    date,
    plant_name,
    reactor_unit,
    current_power_level,
    operational_status
FROM public_data.nrc_reactor_status_timeseries
WHERE plant_name = 'Diablo Canyon'
    AND date >= DATEADD(month, -6, CURRENT_DATE())
ORDER BY date, reactor_unit;

Analyze regional nuclear capacity utilization

SELECT 
    g.state_name,
    COUNT(DISTINCT r.plant_name) AS num_plants,
    SUM(r.rated_capacity_mw) AS total_capacity,
    AVG(r.current_power_level) AS avg_capacity_factor
FROM public_data.nrc_reactor_status AS r
JOIN public_data.geography AS g ON r.geo_id = g.geo_id
WHERE r.last_update_date = (SELECT MAX(last_update_date) FROM public_data.nrc_reactor_status)
GROUP BY g.state_name
ORDER BY total_capacity 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.