Wolfram Data Repository

Immediate Computable Access to Curated Contributed Data

Sample Tabular Data: US Wind Turbines

Source Notebook

Data on 75,633 wind turbines covering 45 US states plus Guam and Puerto Rico

Details

United States Wind Turbine Database V8.0 (February 25, 2025): data on 75,633 wind turbines, including technical specifications and locations covering 45 US states plus Guam and Puerto Rico.

Examples

Basic Examples (4) 

In[1]:=
ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)]
Out[1]=

Data structure:

In[2]:=
TabularStructure[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)]]
Out[2]=

Column keys:

In[3]:=
ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\), "ColumnKeys"]
Out[3]=

Column types:

In[4]:=
ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\), "ColumnTypes"]
Out[4]=

Column descriptions:

In[5]:=
ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\), "ColumnDescriptions"]
Out[5]=

Scope & Additional Elements (3) 

Find the tallest turbines:

In[6]:=
TakeLargestBy[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)], "t_ttlh", 5]
Out[6]=

Find the turbines with the largest rotor swept area:

In[7]:=
TakeLargestBy[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)], "t_rsa", 5]
Out[7]=

Select off-shore turbines:

In[8]:=
Select[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)], #"t_offshore" == 1 &]
Out[8]=

Find how many turbines are off-shore:

In[9]:=
Length[%]
Out[9]=

Tally turbines per year they become operational and sort chronologically:

In[10]:=
yeartotal = SortBy[AggregateRows[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)], "year_total" -> Function[Length[#"p_year"]], "p_year"], "p_year"]
Out[10]=
In[11]:=
ListLinePlot[yeartotal -> {"p_year", "year_total"}, AxesLabel -> {"year"}, PlotLabel -> "Number of wind turbines that became operational in a given year"]
Out[11]=

Visualizations (3) 

Plot the turbines locations:

In[12]:=
GeoGraphics[Point[Normal[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)][[All, "t_loc"]]]]]
Out[12]=

Tally the turbines per state, sort descending and discard rows with missing state information:

In[13]:=
tot = Discard[ReverseSortBy[AggregateRows[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)], "total" -> Function[Length[#"t_state"]], "t_state"], "total"], Function[#"t_state" === Missing[_]]]
Out[13]=

Use Interpreter to convert state abbreviation into a valid Entity and visualize the totals for each state:

In[14]:=
GeoRegionValuePlot[ Interpreter["AdministrativeDivision" | "Country"][ Normal[tot[[All, 1]]]] -> Normal[tot[[All, 2]]]]
Out[14]=

Visualize the density of turbines over contiguous United States:

In[15]:=
GeoSmoothHistogram[Normal[ResourceData[\!\(\* TagBox["\"\<Sample Tabular Data: US Wind Turbines\>\"", #& , BoxID -> "ResourceTag-Sample Tabular Data: US Wind Turbines-Input", AutoDelete->True]\)][[All, "t_loc"]]], GeoRange -> GeoVariant[Entity["Country", "UnitedStates"], Automatic]]
Out[15]=

Gosia Konwerska, "Sample Tabular Data: US Wind Turbines" from the Wolfram Data Repository (2025)  

Data Resource History

  • Date Created:

Source Metadata

  • Citation:
    • Hoen, B.D., Diffendorfer, J.E., Rand, J.T., Kramer, L.A., Garrity, C.P., and Hunt, H.E., 2018, United States Wind Turbine Database V8.0 (February 25, 2025): U.S. Geological Survey, American Clean Power Association, and Lawrence Berkeley National Laboratory data release
    • https://doi.org/10.5066/F7TX3DN0

See Also

Data Downloads

Publisher Information

  • Prepared for the Wolfram Data Repository By: Gosia Konwerska
  • Publisher of Record: Gosia Konwerska