Name: Sunroof Solar
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Sunroof Solar

This dataset consists of information on states that have solar panels installed based on the amount of sunlight received. It includes columns such as zip code, state name, count qualified, yearly sunlight-kwh-kw threshold avg, number of panels total, and existing installs count, etc.

Tables

Sunroof Solar

@kaggle.cygmeda_sunroof_solar.sunroof_solar

3.53 MB
7,588 rows
32 columns

CREATE TABLE sunroof_solar (
  "zip_code" BIGINT,
  "state_name" VARCHAR,
  "lat_max" DOUBLE,
  "lat_min" DOUBLE,
  "lng_max" DOUBLE,
  "lng_min" DOUBLE,
  "lat_avg" DOUBLE,
  "lng_avg" DOUBLE,
  "yearly_sunlight_kwh_kw_threshold_avg" DOUBLE,
  "count_qualified" BIGINT,
  "percent_covered" DOUBLE,
  "percent_qualified" DOUBLE,
  "number_of_panels_n" BIGINT,
  "number_of_panels_s" BIGINT,
  "number_of_panels_e" BIGINT,
  "number_of_panels_w" BIGINT,
  "number_of_panels_f" BIGINT,
  "number_of_panels_median" DOUBLE,
  "number_of_panels_total" DOUBLE,
  "kw_median" DOUBLE,
  "kw_total" DOUBLE,
  "yearly_sunlight_kwh_n" DOUBLE,
  "yearly_sunlight_kwh_s" DOUBLE,
  "yearly_sunlight_kwh_e" DOUBLE,
  "yearly_sunlight_kwh_w" DOUBLE,
  "yearly_sunlight_kwh_f" DOUBLE,
  "yearly_sunlight_kwh_median" DOUBLE,
  "yearly_sunlight_kwh_total" DOUBLE,
  "install_size_kw_buckets" VARCHAR,
  "carbon_offset_metric_tons" DOUBLE,
  "existing_installs_count" BIGINT,
  "center_point" VARCHAR
);