Chicago Energy Usage 2010

Explore Open Data from the City of Chicago

@kaggle.chicago_chicago_energy_usage_2010

Table List

1 table(13.7 MB)

Energy Usage 2010

@kaggle.chicago_chicago_energy_usage_2010.energy_usage_2010

13.7 MB
67051 rows
73 columns

community_area_name COMMUNITY AREA NAME	census_block CENSUS BLOCK	building_type BUILDING TYPE	building_subtype BUILDING SUBTYPE	kwh_january_2010 KWH JANUARY 2010	kwh_february_2010 KWH FEBRUARY 2010	kwh_march_2010 KWH MARCH 2010	kwh_april_2010 KWH APRIL 2010	kwh_may_2010 KWH MAY 2010	kwh_june_2010 KWH JUNE 2010	kwh_july_2010 KWH JULY 2010	kwh_august_2010 KWH AUGUST 2010	kwh_september_2010 KWH SEPTEMBER 2010	kwh_october_2010 KWH OCTOBER 2010	kwh_november_2010 KWH NOVEMBER 2010	kwh_december_2010 KWH DECEMBER 2010	total_kwh TOTAL KWH	electricity_accounts ELECTRICITY ACCOUNTS	zero_kwh_accounts ZERO KWH ACCOUNTS	therm_january_2010 THERM JANUARY 2010	therm_february_2010 THERM FEBRUARY 2010	therm_march_2010 THERM MARCH 2010	term_april_2010 TERM APRIL 2010	therm_may_2010 THERM MAY 2010	therm_june_2010 THERM JUNE 2010	therm_july_2010 THERM JULY 2010	therm_august_2010 THERM AUGUST 2010	therm_september_2010 THERM SEPTEMBER 2010	therm_october_2010 THERM OCTOBER 2010	therm_november_2010 THERM NOVEMBER 2010	therm_december_2010 THERM DECEMBER 2010	total_therms TOTAL THERMS	gas_accounts GAS ACCOUNTS	kwh_total_sqft KWH TOTAL SQFT	therms_total_sqft THERMS TOTAL SQFT	kwh_mean_2010 KWH MEAN 2010	kwh_standard_deviation_2010 KWH STANDARD DEVIATION 2010	kwh_minimum_2010 KWH MINIMUM 2010	kwh_1st_quartile_2010 KWH 1ST QUARTILE 2010	kwh_2nd_quartile_2010 KWH 2ND QUARTILE 2010	kwh_3rd_quartile_2010 KWH 3RD QUARTILE 2010	kwh_maximum_2010 KWH MAXIMUM 2010	kwh_sqft_mean_2010 KWH SQFT MEAN 2010	kwh_sqft_minimum_2010 KWH SQFT MINIMUM 2010	kwh_sqft_1st_quartile_2010 KWH SQFT 1ST QUARTILE 2010	kwh_sqft_2nd_quartile_2010 KWH SQFT 2ND QUARTILE 2010	kwh_sqft_3rd_quartile_2010 KWH SQFT 3RD QUARTILE 2010	kwh_sqft_maximum_2010 KWH SQFT MAXIMUM 2010	therm_mean_2010 THERM MEAN 2010	therm_standard_deviation_2010 THERM STANDARD DEVIATION 2010	therm_minimum_2010 THERM MINIMUM 2010	therm_1st_quartile_2010 THERM 1ST QUARTILE 2010	therm_2nd_quartile_2010 THERM 2ND QUARTILE 2010	therm_3rd_quartile_2010 THERM 3RD QUARTILE 2010	therm_maximum_2010 THERM MAXIMUM 2010	therms_sqft_mean_2010 THERMS SQFT MEAN 2010	therms_sqft_standard_deviation_2010 THERMS SQFT STANDARD DEVIATION 2010	therms_sqft_minimum_2010 THERMS SQFT MINIMUM 2010	therms_sqft_1st_quartile_2010 THERMS SQFT 1ST QUARTILE 2010	therms_sqft_2nd_quartile_2010 THERMS SQFT 2ND QUARTILE 2010	therms_sqft_3rd_quartile_2010 THERMS SQFT 3RD QUARTILE 2010	therms_sqft_maximum_2010 THERMS SQFT MAXIMUM 2010	total_population TOTAL POPULATION	total_units TOTAL UNITS	average_stories AVERAGE STORIES	average_building_age AVERAGE BUILDING AGE	average_housesize AVERAGE HOUSESIZE	occupied_units OCCUPIED UNITS	occupied_units_percentage OCCUPIED UNITS PERCENTAGE	renter_occupied_housing_units RENTER-OCCUPIED HOUSING UNITS	renter_occupied_housing_percentage RENTER-OCCUPIED HOUSING PERCENTAGE	occupied_housing_units OCCUPIED HOUSING UNITS
Archer Heights	170315704001006	Residential	Multi < 7														nan		2326	2131	1400	620	502	224	222	187	197	252	744	2112	10917	11		11134														1819.5	547.64322328	1061	1334	1864.5	2306	2487	1855.67	490.89374275	1382	1382	1779	2162	2650	89	24	2	71.33	3.87	23	0.9582	9	0.391	23
Ashburn	170317005014004	Residential	Multi 7+	7334	7741	4214	4284	2518	4273	4566	2787	3357	5540	15774	19676	82064	8	3														nan	10892		27354.67	22082.794487	8886	8886	21363	51815	51815	10892	10892	10892	10892	10892	10892															112	67	2	41	1.81	62	0.9254	50	0.8059	62
Auburn Gresham	170317105001006	Commercial	Multi < 7														nan	7	1561	1388	1507	701	486	380	18	16					6057	4		7347														3028.5	4150.0096988	94	94	3028.5	5963	5963	7347		7347	7347	7347	7347	7347	102	48	3	86	3	34	0.7082	23	0.6759	34
Austin	170312503003003	Commercial	Multi < 7														nan	2											9	391	400	Less than 4		2146														400		400	400	400	400	400	2146		2146	2146	2146	2146	2146	121	56	2	84	2.95	41	0.7321	32	0.78	41
Austin	170312504002008	Commercial	Multi < 7														nan	3	310	268	163	77	57	23	19	8	14	10			949	Less than 4		2146														949		949	949	949	949	949	2146		2146	2146	2146	2146	2146	62	23	2	85	3.26	19	0.8261	11	0.579	19
Austin	170312517001044	Commercial	Commercial								819	619	416	138	2	1994	Less than 4	1														nan	1512		1994		1994	1994	1994	1994	1994	1512	1512	1512	1512	1512	1512															54	18	2	131	3	18	1	10	0.556	18
Austin	170312518003009	Commercial	Commercial														nan		3041	2680	1151	373	124	26	29	25	49	177	670	3895	12240	Less than 4		69800														6120	3505.8354211	3641	3641	6120	8599	8599	34900	32244.069222	12100	12100	34900	57700	57700			1	54
Austin	170312520004000	Commercial	Multi < 7	1470	1325	294	391	366	2204	2345	2032	920	586	705	785	13423	Less than 4	3														nan	1988		13423		13423	13423	13423	13423	13423	1988	1988	1988	1988	1988	1988															64	63	2	131	1.02	59	0.9365	59	1	59
Austin	170312521011000	Residential	Multi 7+	2461	4888	2893	2737	2350	3037	3874	4861	5180	2984	2635	3597	41497	6															nan	4500		41497		41497	41497	41497	41497	41497	4500	4500	4500	4500	4500	4500															79	31	3	99	2.93	27	0.871	27	1	27
Austin	170312521011008	Residential	Multi 7+						511	904	1818	1968	738	450	2207	8596	Less than 4															nan	4500		8596		8596	8596	8596	8596	8596	4500	4500	4500	4500	4500	4500															84	33	3	99	3.82	22	0.6667	16	0.727	22


CREATE TABLE energy_usage_2010 (
  "community_area_name" VARCHAR,
  "census_block" DOUBLE,
  "building_type" VARCHAR,
  "building_subtype" VARCHAR,
  "kwh_january_2010" DOUBLE,
  "kwh_february_2010" DOUBLE,
  "kwh_march_2010" DOUBLE,
  "kwh_april_2010" DOUBLE,
  "kwh_may_2010" DOUBLE,
  "kwh_june_2010" DOUBLE,
  "kwh_july_2010" DOUBLE,
  "kwh_august_2010" DOUBLE,
  "kwh_september_2010" DOUBLE,
  "kwh_october_2010" DOUBLE,
  "kwh_november_2010" DOUBLE,
  "kwh_december_2010" DOUBLE,
  "total_kwh" DOUBLE,
  "electricity_accounts" VARCHAR,
  "zero_kwh_accounts" BIGINT,
  "therm_january_2010" DOUBLE,
  "therm_february_2010" DOUBLE,
  "therm_march_2010" DOUBLE,
  "term_april_2010" DOUBLE,
  "therm_may_2010" DOUBLE,
  "therm_june_2010" DOUBLE,
  "therm_july_2010" DOUBLE,
  "therm_august_2010" DOUBLE,
  "therm_september_2010" DOUBLE,
  "therm_october_2010" DOUBLE,
  "therm_november_2010" DOUBLE,
  "therm_december_2010" DOUBLE,
  "total_therms" DOUBLE,
  "gas_accounts" VARCHAR,
  "kwh_total_sqft" DOUBLE,
  "therms_total_sqft" DOUBLE,
  "kwh_mean_2010" DOUBLE,
  "kwh_standard_deviation_2010" DOUBLE,
  "kwh_minimum_2010" DOUBLE,
  "kwh_1st_quartile_2010" DOUBLE,
  "kwh_2nd_quartile_2010" DOUBLE,
  "kwh_3rd_quartile_2010" DOUBLE,
  "kwh_maximum_2010" DOUBLE,
  "kwh_sqft_mean_2010" DOUBLE,
  "kwh_sqft_standard_deviation_2010" DOUBLE,
  "kwh_sqft_minimum_2010" DOUBLE,
  "kwh_sqft_1st_quartile_2010" DOUBLE,
  "kwh_sqft_2nd_quartile_2010" DOUBLE,
  "kwh_sqft_3rd_quartile_2010" DOUBLE,
  "kwh_sqft_maximum_2010" DOUBLE,
  "therm_mean_2010" DOUBLE,
  "therm_standard_deviation_2010" DOUBLE,
  "therm_minimum_2010" DOUBLE,
  "therm_1st_quartile_2010" DOUBLE,
  "therm_2nd_quartile_2010" DOUBLE,
  "therm_3rd_quartile_2010" DOUBLE,
  "therm_maximum_2010" DOUBLE,
  "therms_sqft_mean_2010" DOUBLE,
  "therms_sqft_standard_deviation_2010" DOUBLE,
  "therms_sqft_minimum_2010" DOUBLE,
  "therms_sqft_1st_quartile_2010" DOUBLE,
  "therms_sqft_2nd_quartile_2010" DOUBLE,
  "therms_sqft_3rd_quartile_2010" DOUBLE,
  "therms_sqft_maximum_2010" DOUBLE,
  "total_population" DOUBLE,
  "total_units" DOUBLE,
  "average_stories" DOUBLE,
  "average_building_age" DOUBLE,
  "average_housesize" DOUBLE,
  "occupied_units" DOUBLE,
  "occupied_units_percentage" DOUBLE,
  "renter_occupied_housing_units" DOUBLE,
  "renter_occupied_housing_percentage" DOUBLE,
  "occupied_housing_units" DOUBLE
);