global-power-plants

Table actions

9 rows where owner = "Public Service Co of NM"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: other_fuel1, generation_gwh_2013, generation_gwh_2014, generation_gwh_2015, generation_gwh_2016

primary_fuel 3

owner 1

  • Public Service Co of NM · 9 ✖

country_long 1

Link rowid ▼ country country_long name gppd_idnr capacity_mw latitude longitude primary_fuel other_fuel1 other_fuel2 other_fuel3 commissioning_year owner source url geolocation_source wepp_id year_of_capacity_data generation_gwh_2013 generation_gwh_2014 generation_gwh_2015 generation_gwh_2016 generation_gwh_2017 generation_data_source estimated_generation_gwh
24673 24673 USA United States of America Afton Generating Station USA0055210 287.0 32.1142 -106.8465 Gas       2003.91637630662 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 48292 2017 0.0 0.0 0.0 0.0 401.978 U.S. Energy Information Administration  
24722 24722 USA United States of America Algodones USA0002475 45.0 35.3844 -106.4642 Gas Oil     1955.666666666667 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30271 2017             317.0461135034452
28717 28717 USA United States of America La Luz Energy Center USA0058284 42.3 34.6161 -106.815 Gas       2016.0 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017     0.24600000000000002 22.133000000000003 10.484000000000002 U.S. Energy Information Administration 298.02334669323847
29008 29008 USA United States of America Lordsburg Generating USA0007967 88.0 32.3505 -108.698 Gas       2002.0 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 34508 2017 8.711 22.265 19.845 12.552999999999999 8.855 U.S. Energy Information Administration  
29063 29063 USA United States of America Luna Energy Facility USA0055343 650.0 32.2993 -107.7834 Gas       2006.0 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 49133 2017 1999.3429999999998 2052.629 1717.308 2319.172 2479.67 U.S. Energy Information Administration  
30705 30705 USA United States of America Prosperity Energy Storage Facility USA0058899 1.3 35.0019 -106.6372 Storage Solar     2011.0 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 0.716 0.665 0.665 0.877 0.736 U.S. Energy Information Administration  
30895 30895 USA United States of America Reeves USA0002450 154.0 35.171 -106.6019 Gas       1960.857142857143 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30897 2017 0.0 0.0 0.0 0.0 86.81 U.S. Energy Information Administration  
30948 30948 USA United States of America Rio Bravo USA0055039 150.0 35.026 -106.644 Gas Oil     2000.0 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017 22.409000000000002 18.434 73.41 111.84100000000001 82.287 U.S. Energy Information Administration  
31295 31295 USA United States of America San Juan USA0002451 924.0 36.8006 -108.4386 Coal Oil     1980.0032467532467 Public Service Co of NM U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 30899 2017 10510.457443 10360.010125 9007.454963 10277.563614 10859.285926999999 U.S. Energy Information Administration  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "global-power-plants" (
"country" TEXT,
  "country_long" TEXT,
  "name" TEXT,
  "gppd_idnr" TEXT,
  "capacity_mw" REAL,
  "latitude" REAL,
  "longitude" REAL,
  "primary_fuel" TEXT,
  "other_fuel1" TEXT,
  "other_fuel2" TEXT,
  "other_fuel3" TEXT,
  "commissioning_year" REAL,
  "owner" TEXT,
  "source" TEXT,
  "url" TEXT,
  "geolocation_source" TEXT,
  "wepp_id" TEXT,
  "year_of_capacity_data" INTEGER,
  "generation_gwh_2013" REAL,
  "generation_gwh_2014" REAL,
  "generation_gwh_2015" REAL,
  "generation_gwh_2016" REAL,
  "generation_gwh_2017" REAL,
  "generation_data_source" TEXT,
  "estimated_generation_gwh" REAL
);
CREATE INDEX ["global-power-plants_country_long"] ON [global-power-plants]("country_long");
CREATE INDEX ["global-power-plants_owner"] ON [global-power-plants]("owner");