Home > Products > Join our Movement > Get Your Organization Involved > Campaign Resources: All Organizations

All Organizations

View pledge drivers from current and past campaigns by clicking on the appropriate year.

The "Change a Light" campaign began in 2006 and ran through Earth Day 2008. Beginning Earth Day 2008, the "Change the World" campaign went into effect.

653 Total Pledge Drivers

All A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Organization ^ Location ^ Partner Type % to goal lbs of Greenhouse Gas Emissions ^ Recommit for 2014-15
Cumberland County Schools, Fayetteville, NC North Carolina K-12 N/A 0  
Cumberland County Elementary School Kentucky K-12 N/A 0  
ctsc Washington College/University N/A 0  
CTB/McGraw-Hill California Corporate N/A 0  
CSRware, Inc. California Utility N/A 0  
Crittenden Co. Elementary Kentucky K-12 N/A 0  
Crestwood Elementary Kentucky K-12 N/A 0  
Cree, Inc. North Carolina Retailer/Manufacturer of ENERGY STAR qualified lighting N/A 1,666,684  
Creative Riot Software Small Business N/A 0  
Cranford Environmental Commission New Jersey Local N/A 32,662  
Cousins Properties - Inverness Center Alabama Corporate N/A 0  
Courtney Strong Inc. New York Small Business N/A 0  
Coronado Bay Club Resort Apartments California Small Business N/A 0  
Conway Middle School Kentucky K-12 N/A 0  
Consumers Energy (MI) Michigan Utility N/A 0  
Conservation Conversations Minnesota Environmental/Energy N/A 0  
Connecticut Green Building Council (CTGBC) Connecticut Environmental/Energy N/A 0  
Conant High School Illinois K-12 N/A 0  
Con Edison New York Utility N/A 0  
Computers-IT Consulting Services (CIC) Small Business N/A 0  
Comparance.com Trade/Membership N/A 0  
Colorado Springs Utilities Colorado Utility N/A 0  
Colorado Interfaith Power and Light Colorado Environmental/Energy N/A 0  
Colorado Governor's Energy Office Colorado State N/A 0  
Cohens Electronics and Appliances Alabama Small Business N/A 0  
Cohaven Massachusetts Small Business N/A 0  
Coastal Bend Green Built Texas Other, Builders Association N/A 0  
ClimateMaster, Inc. Oklahoma Other, Manufacturer of Geothermal Heat Pumps N/A 0  
ClimateMama New Jersey Small Business N/A 0  
Cliffside Park Green Committee New Jersey Local N/A 0  
Clevleand Clinic Ohio Other, healthcare N/A 39,923  
City of Virginia Beach Virginia Local N/A 0  
City of Topeka Kansas Local N/A 0  
City of Pittsfield, MA Massachusetts Local N/A 0  
City of North Little Rock, Arkansas Arkansas Local N/A 0  
City of Newark New Jersey Local N/A 3,692  
City Of Naperville, IL Illinois Local N/A 0  
City of Kingsport, TN Tennessee Local N/A 133,362  
City of Fort Lauderdale Florida Local N/A 16,249  
City of Evanston Illinois Local N/A 6,519  
City of Elizabeth New Jersey Local N/A 0  
City of Elgin Illinois Local N/A 0  
City of Aurora Illinois Illinois Local N/A 0  
City of Arlington, Texas Texas Local N/A 900  
CIR Electrical Construction Corp. New York Corporate N/A 0  
CIC ENERGY CONSTRUCTION Illinois Small Business N/A 0  
Chikaskia'dan Adventures Oklahoma Environmental/Energy N/A 0  
Chicago Public School Illinois K-12 N/A 0  
Chester Township New Jersey Local N/A 0  
Central Regional School District New Jersey K-12 N/A 0  
1 2 3 4 5 6 7 8 9 10 11 12 13 14


Debugging Information
ColdFusion Server Enterprise 10,0,13,287689
Template /index.cfm
Time Stamp 23-Jul-14 12:46 PM
Locale English (US)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 192.168.15.110
Host Name 192.168.15.110


Execution Time

Total Time Avg Time Count Template
1883 ms 942 ms 2 /data/cf_code/estar/index.cfm
1879 ms 940 ms 2 /data/cf_code/estar/fbx_fusebox30_cf50.cfm
1773 ms 1773 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/fbx_switch.cfm
1756 ms 1756 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/fa_showorganizations.cfm
1288 ms 1288 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_showorganizations.cfm
128 ms 128 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_orgtypecats.cfm
113 ms 113 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/dsp_showorganizations.cfm
105 ms 105 ms 1 /data/cf_code/estar/Application.cfm
33 ms 33 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/fbx_settings.cfm
20 ms 20 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/view_showorganizations.cfm
16 ms 16 ms 1 /data/cf_code/estar/ia/fbx_layouts.cfm
9 ms 5 ms 2 /data/cf_code/estar/fbx_settings.cfm
6 ms 6 ms 1 /data/cf_code/estar/ia/dsp_menu.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/act_metatags_set.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/fbx_settings.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/lay_english_standard.cfm
3 ms 3 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_getstates.cfm
2 ms 1 ms 2 /data/cf_code/estar/fbx_circuits.cfm
2 ms 1 ms 2 /data/cf_code/estar/ia/dsp_footer.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/act_pagecrumb_set.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/dsp_header.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/metadata/metadata.wddx
1 ms 1 ms 1 /data/cf_code/estar/ia/partners/fbx_settings.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/val_showorganizations.cfm
1 ms 1 ms 1 /data/cf_code/estar/ia/products/globalwarming/act_leftmenuconfiguration.cfm
1 ms 1 ms 1 /data/cf_code/estar/template/fbx_switch.cfm
0 ms 0 ms 1 /data/cf_code/estar/OnRequestEnd.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_cache_init.cfm
0 ms 0 ms 1 /data/cf_code/estar/act_debug_init.cfm
0 ms 0 ms 2 /data/cf_code/estar/act_layoutoption_init.cfm
0 ms 0 ms 2 /data/cf_code/estar/act_message_init.cfm
0 ms 0 ms 2 /data/cf_code/estar/act_specialurlformat_init.cfm
0 ms 0 ms 3 /data/cf_code/estar/fbx_server.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_js_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_layout_pick.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/act_pagetitle_set.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_acrobat_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_devnotes.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_email_link.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/dsp_footer_links.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_googletagmanager.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_megamenu.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_photo.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_printable_link.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sections.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_sitesearch_textbox.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_slogan.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/dsp_trail.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/fbx_settings.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/fbx_layouts.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/partners/promotions/change_light/join/val_iframelayout.cfm
0 ms 0 ms 1 /data/cf_code/estar/ia/partners/promotions/fbx_settings.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_language.cfm
0 ms 0 ms 2 /data/cf_code/estar/ia/val_layout.cfm
0 ms 0 ms 1 /data/cf_code/estar/lockoutapps.cfm
0 ms 0 ms 1 /data/cf_code/estar/template/dsp_standard.cfm
0 ms 0 ms 1 /data/cf_code/estar/template/fbx_settings.cfm
0 ms 0 ms 1 /data/coldfusion10/cfusion/CustomTags/inputfilter.cfm
39 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2012 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

12:46:26.026 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template template/fbx_Layouts.cfm.
	    
12:46:26.026 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template fbx_Layouts.cfm.
	    
12:46:26.026 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template ia/partners/promotions/change_light/fbx_Layouts.cfm.
	    
12:46:26.026 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template ia/partners/promotions/fbx_Layouts.cfm.
	    
12:46:26.026 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template ia/partners/fbx_Layouts.cfm.
	    
12:46:26.026 - MissingInclude Exception - in /data/cf_code/estar/fbx_fusebox30_cf50.cfm : line 311
	    Could not find the included template fbx_Layouts.cfm.
	    


SQL Queries

getStates (Datasource=star_read, Time=2ms, Records=75) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_getstates.cfm @ 12:46:25.025
SELECT
	s_code,
	state_name
FROM ref_state
WHERE
	cntry_code IN (?,?)
	AND (
		s_historical_yn = ?
		OR s_historical_yn IS NULL
	)
ORDER BY state_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = US
Parameter #2(CF_SQL_VARCHAR) = CA
Parameter #3(CF_SQL_VARCHAR) = N

qOrgTypeCats (Datasource=star_read, Time=1ms, Records=18) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_orgtypecats.cfm @ 12:46:25.025
SELECT
	rc.cal_org_type_cat_code,
	rc.cal_org_type_cat_name,
	r.cal_org_type_code AS value,
	r.cal_org_type_name AS display
FROM
	ref_cal_orgtype r,
	xref_cal_orgtype_cat x,
	ref_cal_orgtype_cat rc
WHERE
	r.cal_org_type_historical_yn = ?
	AND r.cal_org_type_code = x.cal_org_type_code
	AND x.cal_org_type_cat_code = rc.cal_org_type_cat_code
ORDER BY
	rc.cal_org_type_display_order,
	r.cal_org_type_display_order
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = N

qDistinctOrgCats (Datasource=, Time=56ms, Records=5) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_orgtypecats.cfm @ 12:46:25.025
SELECT DISTINCT cal_org_type_cat_name
FROM qOrgTypeCats
qPledgeDrivers (Datasource=star_read, Time=1207ms, Records=653) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_showorganizations.cfm @ 12:46:26.026
SELECT
	cpd_id,
	TRIM(cp_org_name) AS display,
	cp_umbrella_org_yn,
	cp_other_org_type,
	state_name AS location,
	cal_org_type_name,
	cpd_id AS value,
	cpd_goal AS goal,
	pledges,
	cpd_ghg_goal,
	cpd_year,
	(
		SELECT cpd_campaign_year
		FROM cal_pledge_driver
		WHERE
			cpd_id = orgs.cpd_id
			AND cal_status_code NOT IN (?,?) 
	) AS cpd_current_year,
	
	(
		NVL((select sum(sum(g.total_co2_saving)) over (partition by cpd_id, year) total_co2_saving
        from gw_pledge_driver_summary g
        where cpd_id = orgs.cpd_id
        and year = ?
        group by cpd_id, year
        ),0) + 
        NVL((select sum(sum(g.total_co2_saving)) over (partition by g.cpd_id, year) total_co2_saving
        from gw_pledge_driver_summary g, cal_pledge_driver cpd, xref_cal_member_participant
        where g.cpd_id = cpd.cpd_id
        and cpd.cp_id = cp_id_child
        and cp_id_parent = orgs.cp_id
        and YEAR = ?
        group by rollup (g.cpd_id, year) 
        having  GROUPING_ID (g.cpd_id, year) = 3
        ),0) 
		
	
  ) AS cpd_ghg_credited
	
FROM (
	SELECT
		cp.cp_id,
		cp.cp_org_name,
		cp.cp_other_org_type,
		cp.cp_umbrella_org_yn,
		rs.state_name,
		rco.cal_org_type_name,
		cpd.cpd_id,
		cpd.cpd_goal,
		NVL(cpd.cpd_total_pledges_credited,0) AS pledges,
		cpd_ghg_goal,
		NVL(cpd_ghg_credited,0) AS cpd_ghg_credited,
		cpd_campaign_year AS cpd_year
	FROM
		cal_participant cp,
		cal_pledge_driver cpd,
		ref_zip rz,
		ref_state rs,
		xref_cal_participant_orgtype xcpo,
		ref_cal_orgtype rco
	WHERE
		cpd.cal_status_code = ?
		AND cpd.cpd_campaign_year = ?
		AND cp.cp_id = cpd.cp_id
	
		AND SUBSTR(cp.cp_zip, 0, 5) = rz.zip_5 (+)
		AND rz.s_code = rs.s_code (+)
	
		AND cp.cp_id = xcpo.cp_id (+)
		AND xcpo.cal_org_type_code = rco.cal_org_type_code (+)
	UNION
	SELECT
		DISTINCT cp.cp_id,
		CASE
			WHEN length(cp.CP_ORG_NAME) > 65
			THEN substr(cp.CP_ORG_NAME,1,60)||'....'
			ELSE cp_org_name
		END AS cp_org_name,
		cp.cp_other_org_type,
		cp.cp_umbrella_org_yn,
		rcm.state_name,
		cal_org_type_name,
		cpd.cpd_id,
		cpd.cpd_goal,
		NVL(cpda.cpd_total_pledges_credited,0) AS pledges,
		0 AS cpd_ghg_goal,
		0 AS cpd_ghg_credited,
		cpd_year
	FROM
		CAL_PLEDGE_DRIVER cpd,
		cal_pledge_driver_archive cpda,
		cal_participant cp,
		(
			SELECT
				zip_5 AS zip_code,
				ref_state.s_code,
				ref_state.state_name
			FROM
				ref_zip,
				ref_state
			WHERE
				zip_5 IS NOT NULL
				AND ref_state.s_code = ref_zip.s_code
		) rcm,
		xref_cal_participant_orgtype xcpo,
		ref_cal_orgtype rco
	WHERE
		cpda.cal_status_code = ?
		AND cpda.cpd_year = ?
		AND cpda.cpd_id = cpd.cpd_id
		AND cp.cp_id = cpd.cp_id
		AND SUBSTR(cp.cp_zip, 0, 5) = rcm.zip_code (+)
	
		AND cp.cp_id = xcpo.cp_id (+)
		AND xcpo.cal_org_type_code = rco.cal_org_type_code (+)
	
	) orgs
ORDER BY
	
	UPPER(display) desc,
		
	cpd_id,
	cal_org_type_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = REJ
Parameter #2(CF_SQL_VARCHAR) = DEL
Parameter #3(CF_SQL_NUMERIC) = 2012
Parameter #4(CF_SQL_NUMERIC) = 2012
Parameter #5(CF_SQL_VARCHAR) = APR
Parameter #6(CF_SQL_NUMERIC) = 2012
Parameter #7(CF_SQL_VARCHAR) = APR
Parameter #8(CF_SQL_NUMERIC) = 2012

getOrgLetters (Datasource=star_read, Time=8ms, Records=32) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_showorganizations.cfm @ 12:46:26.026
SELECT DISTINCT letter
FROM (
	SELECT SUBSTR(UPPER(cp_org_name), 1, 1) AS letter
	FROM
		cal_participant cp,
		cal_pledge_driver cpd
	WHERE
		cpd.cpd_campaign_year = ?
		AND cpd.cal_status_code = ?
		AND cpd.cp_id = cp.cp_id
)
	
UNION
SELECT DISTINCT letter
FROM (
	SELECT SUBSTR(UPPER(cp_org_name), 1, 1) AS letter
	FROM
		cal_participant cp,
		cal_pledge_driver cpd,
		cal_pledge_driver_archive cpda
	WHERE
		cpd.cpd_id = cpda.cpd_id
		AND cpd.cp_id = cp.cp_id
)
	
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 2012
Parameter #2(CF_SQL_VARCHAR) = APR

getTotalPledgeDrivers (Datasource=, Time=12ms, Records=653) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_showorganizations.cfm @ 12:46:26.026
SELECT DISTINCT cpd_id
FROM qPledgeDrivers
getPDCount (Datasource=star_read, Time=5ms, Records=653) in /data/cf_code/estar/ia/partners/promotions/change_light/join/qry_showorganizations.cfm @ 12:46:26.026
SELECT cpd_id
FROM cal_pledge_driver
WHERE
	cpd_campaign_year = ?
	AND cal_status_code = ?
UNION
SELECT cpd_id
FROM cal_pledge_driver_archive
WHERE
	cpd_year = ?
	AND cal_status_code = ? 
Query Parameter Value(s) -
Parameter #1(CF_SQL_NUMERIC) = 2012
Parameter #2(CF_SQL_VARCHAR) = APR
Parameter #3(CF_SQL_NUMERIC) = 2012
Parameter #4(CF_SQL_VARCHAR) = APR

getMenuItems (Datasource=, Time=4ms, Records=8) in /data/cf_code/estar/ia/dsp_menu.cfm @ 12:46:26.026
SELECT *
FROM menuItems
ORDER BY
  itemGroup,
  itemOrder


Scope Variables

Application Variables:
applicationname=ghg_campaign
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/data/cf_code/estar/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=x-gzip, gzip, deflate
HTTP_ACCEPT_LANGUAGE=en-us,en-gb,en;q=0.7,*;q=0.3
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.energystar.gov
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/2.0 (http://commoncrawl.org/faq/)
PATH_INFO=
PATH_TRANSLATED=/data/cf_code/estar/index.cfm
QUERY_STRING=fuseaction=join_change_the_world.showOrganizations&startrow=451&campaign_year=2012&alpha=&orderby=display&sortorder=desc&s_code=&org_type=
REMOTE_ADDR=192.168.15.110
REMOTE_HOST=192.168.15.110
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.energystar.gov
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=
WEB_SERVER_API=
Client Variables:
cfid=19822761
cftoken=a50657ab5599f9bb-E92AB113-E31F-A730-EA54C4A055100D0D
hitcount=1
lastvisit={ts '2014-07-23 12:46:24'}
timecreated={ts '2014-07-23 12:46:24'}
urltoken=CFID=19822761&CFTOKEN=a50657ab5599f9bb-E92AB113-E31F-A730-EA54C4A055100D0D
Cookie Variables:
CFID=19822761
CFTOKEN=a50657ab5599f9bb-E92AB113-E31F-A730-EA54C4A055100D0D
URL Parameters:
alpha=
campaign_year=2012
fuseaction=join_change_the_world.showOrganizations
orderby=display
org_type=
s_code=
sortorder=desc
startrow=451
Debug Rendering Time: 25 ms