global-power-plants

Table actions

5 rows where owner = "Constellation Solar New Jersey LLC"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: commissioning_year

primary_fuel 1

owner 1

  • Constellation Solar New Jersey LLC · 5 ✖

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
24975 24975 USA United States of America Atlantic City Convention Center USA0056900 2.0 39.3639 -74.4408 Solar       2009.0 Constellation Solar New Jersey LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 59739 2017 2.85 2.9789999999999996 2.9819999999999998 3.0620000000000003 2.99 U.S. Energy Information Administration  
25203 25203 USA United States of America Benjamin Moore & Co. Solar USA0057733 1.4 40.8256 -74.7147 Solar       2011.0 Constellation Solar New Jersey LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 62713 2017 2.0540000000000003 2.03 2.0869999999999997 2.157 1.7919999999999998 U.S. Energy Information Administration  
29727 29727 USA United States of America NHA at Mansfield NJ USA0060378 5.0 40.76 -74.935 Solar       2016.0 Constellation Solar New Jersey LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration   2017       3.2030000000000003 7.504 U.S. Energy Information Administration 2.222573567212551
32202 32202 USA United States of America The City of Vineland at North Vineland USA0057746 2.3 39.505 -74.9977 Solar       2011.0 Constellation Solar New Jersey LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63132 2017 3.788 3.989 4.062 3.971 3.901 U.S. Energy Information Administration  
32203 32203 USA United States of America The City of Vineland at West Vineland USA0057745 3.7 39.4624 -75.07 Solar       2011.0 Constellation Solar New Jersey LLC U.S. Energy Information Administration http://www.eia.gov/electricity/data/browser/ U.S. Energy Information Administration 63140 2017 6.676 6.631 6.587000000000001 6.3870000000000005 6.335 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");