Dataset: Sunroof Solar

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.37 MB
7588 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
);