City Format Demo

This page gives a basic format skeleton for the City level pages. It can be as adaptable as necessary depending on each municipality's needs, but they will generally follow this format. Go to the "Edit" tab to see the coding.

(Municipality) Overview

See Broomfield for an example.

(CR = Colorado Resistance Target Race)

• City Council: # R, # D, # Unaffiliateds (U), etc. As applicable.
• Mayor: Rep, D, Unaffiliated (U), etc.
• County Commissioners: (Link to page), plus list # R, # D, # Unaffiliateds (U), etc. As applicable.
• School Districts: (Link to pages and list)
• State House: (Link, list, and label party)
• State Senators: (Link, list, and label party)
• Congressional: (Link, list, and label party)

(Municipality) Demographics

Raw Table:

Population	Median Age	Median Household Income	Registered Voters	Presidential Results (County County)	Religion (County County)	Poverty	Cost of Living Index	Median House Value	Median Rent	Race	Age	Education	Foreign Born	Marital Status	Unemployment	Air Quality Index
	years (-36.4 years to CO)	$ (-$58,823 to CO)			None: % Catholic: % Evangelical Protestant: % Other: % Mainline Protestant: %	% Other Race: % Native American: % Hispanic/Latino: % Native Hawaiian / Pacific Islander: % Black: % Two or More Races: % White: %			$	White: % Hispanic/Latino: % Black: % Asian: % Two or More Races: % Native American: % Native Hawaiian / Pacific Islander: % Other Race: %	Older Adult 40-64: % Younger Adult 22-39: % Children 0-17: % Senior 65+: % College 18-21: %	High School: % Some College: % Bachelor's: % Some High School: % Associate's: % Less than High School: % Master's: % None: % Professional: % Doctorate: %		Now married: % Never married: % Divorced: % Widowed: % Separated: %

NOTES:

• The example table on the page states there's an error. The "error" is there is no information entered in. This was done deliberately so the template can be easily copied and pasted elsewhere via the code in the Edit tab of this page.
• Source: Statistical Atlas for Age Group and Educational Level breakdowns
• Source: City-Data.com for everything else.
• For items that involve percentages, no need to put in the %. Simply put in the raw number, including any decimals.
• For items detailing with money, no need to put in a $ sign.
• For numbers in the thousands and beyond, do put in the commas.
• For subcategories listed (such as Married, Separated, etc, in the main category of Marital Status), reorder them according to descending order.
• at "Begin demographics|County", in lieu of "County", put in the name of the county's demographics being used, such as "Adams" or "Summit", etc.

Completed Example Table

Here is an example of a completed Demographic table (from Aurora, with "Adams" in the County value). Compare the raw table against the completed table via the Edit tab:

Population	Median Age	Median Household Income	Registered Voters	Presidential Results (Adams County)	Religion (Adams County)	Poverty	Cost of Living Index	Median House Value	Median Rent	Race	Age	Education	Foreign Born	Marital Status	Unemployment	Air Quality Index
353,108 (Female: 52.2%) (Male: 47.8%)	33.5 years (-2.9 years to CO)	$49,142 (-$9,681 to CO)		2016: Clinton 50% Trump: 42% 2012: Obama 56% Romney: 41% 2008: Obama 58% McCain: 40% 2004: Kerry 51% Bush: 48%	None: 70.6% Catholic: 16% Evangelical Protestant: 7.8% Other: 3.9% Mainline Protestant: 1.6%	18% Other Race: 37.4% Native American: 30.4% Hispanic/Latino: 29% Native Hawaiian / Pacific Islander: 21.5% Black: 18.7% Two or More Races: 18% White: 9.5%	108.2 (+8.2 to US)	$176,200 (-$64,300 to CO)	$987	White: 45.4% Hispanic/Latino: 29.1% Black: 15.7% Asian: 5.1% Two or More Races: 3.8% Native American: 0.3% Native Hawaiian / Pacific Islander: 0.3% Other Race: 0.2%	Older Adult 40-64: 30.4% Younger Adult 22-39: 27.6% Children 0-17: 27.2% Senior 65+: 9.44% College 18-21: 5.32%	High School: 25.6% Some College: 24.6% Bachelor's: 18.3% Associate's: 9.3% Some High School: 7.3% Master's: 6.3% Less than High School: 5.4% None: 1.4%	19.7% (+10.2% to CO)	Now married: 47.5% Never married: 34.1% Divorced: 11.4% Widowed: 4.4% Separated: 2.6%	3.7% (+0.4% to CO)	107 (+32 to US)

(Municipality) City Council

Or:

• "Elected City Officials", as some municipalities have other elected officials such as City Clerk or City Treasurer.
• "Town Council"
• "Town Board"
• "Board of Trustees"
• Or whatever the respective municipality calls its municipal body.

Format in Description:

• Term lengths; term limits (Usually "4 years; limited to 2 consecutive terms", sometimes Mayors and some seats have differing terms, plus some municipalities have either extended term limits or have gotten rid of them entirely)
• How Mayors are elected/selected (Sometimes by popular vote; sometimes appointed by vote of the council; sometimes elected as a council member and then elected by council members).
• How Pro-Tems are selected (Sometimes by Mayor; sometimes by vote of all council members).

Raw Table:

Title	Name	Party	Next Election November	Contact	2019 Margin	2017 Margin	2015 Margin	2013 Margin	2011 Margin
						1

• Repeat the "Council Member" portion of the code for as many seats required for that body.
• "Party" only requires a D for Democrat, an R for Republican, or a U for Unaffiliated. On occasion, party cannot be definitively confirmed one way or another. In that case, put in "(Cannot confirm)".
• "Margin" is the difference between the Winner's percentage minus the percentage of the second-most voted.
• If office is elected At-Large, put as the entered value for "Margin" as ATLARGE, then put the percentage they won with in the "Total" line.
• If the winner ran unopposed, put as the entered value for "Margin" as UNOPPOSED. Nothing further required for the "Total" line.
• "Total" is from the total percentage the Winner received.
• The lines with "a" or "b" attached to the year are for candidates who ran against the winner and did not win. Or if the Winner is different than the current seatholder. There can also be "c" and "d" lines, etc.
• Different winners will be noted with their name surrounded by a single pair of parentheses--(First Last)
• Defeated candidates will have the set up "candidate|First Last|0.00%|U" between the squiggle brackets (as seen in the following Complete Example Table in the Edits Tab.
• "| 20XXnote = 1" establishes a footnote attached to the Winner's results, and "| 20XXnote1 = (Insert footnote info here)" puts in the text of the footnote.
• If footnotes require to be attached to a different section than the Winner's results, see the Ward 1 2015 results posted below in the Edit tab (it is in the "| 2015a = " section.
• Can put in more than one footnote per seat per year. Use 2, 3, onward. Can also attach multiple footnotes to a single item. Be sure to put in a comma ("1,2").

Complete Example Table

Here is an example of a completed City Council table (from Lakewood). Compare the raw table against the completed table via the Edit tab:

Title	Name	Party	Next Election November	Contact	2019 Margin	2017 Margin	2015 Margin	2013 Margin	2011 Margin
Mayor	Adam Paul	Unaffiliated	2019	303.987.7040 apaul@lakewood.org			1.18% (50.59%) Ramey Johnson 49.5%	X	64.7% (82.3%) (Bob Murphy) Source Linda Lou Delay 17.6%	X
Ward 1	Ramey Johnson	Republican	2017	303.232.1567 rjohnson@lakewood.org			X	UNOPPOSED	33.9% (66.7%) 1 Briana Peterson 33% 1 Special Election	(Vicky Slack)
Ward 1	Charley Able	Unaffiliated Selected Record from his website Called "Reformer" by local blog	2019	303.233.7275 cable@lakewood.org			3.15% (41.79%) Jeff Yeager 38.64% 1 Ty Hull (Una) 29.57% 1 Called "establishment" by blog	X	25.3% (62.6%) Karen Kellen Cathy Kentner 37.3	X
Ward 2	Scott Koop	Republican	2017	303.232.7275 skoop@lakewood.org			X	UNOPPOSED	X	32.6% (68.1%) Frank Teunissen 31.9
Ward 2	Sharon Vincent	Democrat	2019	303.987.7040 svincent@lakewood.org			6.3% (45.7%) Richard Dick Bryant 39.27 Steven T. Ly 14.83	X	(Cindy Baroway) 1 Endorsed various Democrats	X
Ward 3	Shakti	Democrat	2017	303.987.7740 shakti@lakewood.org			X	6.3% (53.1%) Dan Smith 46.8%	X	UNOPPOSED (Sue King)
Ward 3	Pedro (Pete) Roybal	Unaffiliated Called "Reformer" by local blog	2019	303.432.7554 proybal@lakewood.org			18.3% (59.1%) Gary Harty 40.8%	X	X	7.9% (41.8%) Carolyn Evans 33.9% Mark Barrington 24.1%
Ward 4	Dave Weichman	Republican	2017	303.986.4818 dweichman@lakewood.org			X	8.1% (54.%) Betty Boyd 45.9%	X	3.7% (51.8%) Amy Attwood 48.1% 1 1 Source
Ward 4	Barb Franks	Unaffiliated Called "Reformer" by local blog	2019	303.515.6501 bfranks@lakewood.org			18.1% (59%) Michael C Coughlin 40.9	X	(Adam Paul 1) 1 Endorsed by both GOP and Dem for Mayor	X
Ward 5	Karen Harrison	Republican JeffCO GOP ID's her as GOP	2017	303.987.7767 kharrison@lakewood.org			X	32.5% (66.2%) Michael "Gunner" Gunstanson 33.7% 1,2 1 Blog post appears made by Gunner 2 Allegedly highlights Anschutz connection	X	4.3% (52.1%) (Diana M. Allen) Natalie Menten 47.8 1 1 Source
Ward 5	Dana Gutwein	Democrat	2019	303.987.7040 dgutwein@lakewood.org			1.3% (50.6%) Jessica Skimel 49.3	X	(Tom Quinn) 1 Endorsed Various Democrats	X

Default is November of odd years. If anything other than that, do this coding as seen in the Edit Tab at "Begin Council" and for the years (for example, the next most common municipal general elections are April of even years):

Title	Name	Party	Next Election April	Contact	2018 Margin	2016 Margin	2014 Margin	2012 Margin	2010 Margin

Completed Example Table

[Example not yet available]

Expanded Historical Election Results

Raw Table

Ward	20XX Results	20XX Results	20XX Results	20XX Results
Seat 1	Winner XX% (XXXX votes) Challenger XX% (XXXX votes) Challenger XX% (XXXX votes)	X	Winner XX% (XXXX votes) Challenger XX% (XXXX votes) Challenger XX% (XXXX votes)	X
Seat 2	X	Winner XX% (XXXX votes) Challenger XX% (XXXX votes) Challenger XX% (XXXX votes)	X	Winner XX% (XXXX votes) Challenger XX% (XXXX votes) Challenger XX% (XXXX votes)

• If registered Democrat, do the blue code. If registered Republican, do the red code. If registered unaffiliated or affiliation is unknown, no code necessary.

Completed Example Table

Example taken from the Greenwood Village page.

Ward	2015 Results	2013 Results	2011 Results	2009 Results
Mayor	Ron Rakowsky UNOPPOSED	X	Ron Rakowsky UNOPPOSED	X
District 1	Freda Miklin 30.27% (827 votes) Dave Bullock 25.88% (707 votes) Henny Lasley 24.01% (656 votes) Luke Towle 19.84% (542 votes)	ELECTION CANCELLED	Jerry Presley 50.83% (855 votes) Denise Rose 49.17% (827 votes)	Denise Rose 51.01% (354 votes) Jerry Presley 48.99% (340 votes)
District 2	Leslie Schluter 53.19% (584 votes) Darryl Jones 46.81% (514 votes)	ELECTION CANCELLED	Leslie Schluter 31.27% (430 votes) Jeff Roemer 34.40% (473 votes) Kathleen Chapman 16.73% (230 votes) John Herbers 17.60% (242 votes)	Dave Kerber 50.68% (447 votes) Jeff Roemer 49.32% (435 votes)
District 3	Steve Moran 28.83% (551 votes) George Lantz 25.54% (488 votes) David Seserman 23.29% (445 votes) Brent Neiser 22.34% (427 votes)	ELECTION CANCELLED	Gary Kramer 50.75% (711 votes) Bette Todd 49.25% (690 votes)	Bette Todd 51.56% (464 votes) Gary Kramer 48.44% (436 votes)
District 4	T.J. Gordon 51.28% (720 votes) Tom Bishop 48.72% (684 votes)	ELECTION CANCELLED	T.J. Gordon 44.72% (660 votes) Tom Bishop 44.58% (658 votes) Amber Pleiss 10.70% (158 votes)	Ron Rakowsky 39.89% (671 votes) Gary Kleeman 35.49% (597 votes) Steve Frankel 16.47% (277 votes) Lindy Scialla 8.15% (137 votes)

Special Interests

Local

• Group 1
• Group II
• Group Trois
• Group Quatro

Group Name

If an individual group warrants enough to have it's own subsection, create one here. Do so for each individual group that so warrants.

General

• Statewide
• Nationwide

Group Name

If an individual group warrants enough to have it's own subsection, create one here. Do so for each individual group that so warrants.

20XX Election

Put date of election here. Put seats up for vote here. State what seat(s) is/are termed out.

Candidates

Raw Table

Seat	Name	Party	Endorsements/Info	Contact

(i) = incumbent

Complete Example Table

From the Lakewood page.

Seat	Name	Party	Endorsements/Info	Contact
Ward 1	Ramey Johnson (i)	Republican	Supported moratorium on growth. "Reformer" according to Lakewood Pols	email Website
Ward 1	Kyra Elise deGruy	Democrat	Endorsed by Denver Area Labor Federation	email Facebook
Ward 2 incumbent, Scott Koop (R) is term-limited and cannot run.
Ward 2	Jacob Bruce LaBure	Democrat	Endorsed by Denver Area Labor Federation	email Website Facebook
Ward 2	Charles Kenneth Davis	Democrat		email
Ward 3	Michael Bieda	Republican		email Website
Ward 3	Michael Gifford			email
Ward 4 incumbent, David Wiechman (R) is term-limited and cannot run.
Ward 4	William Furman	Democrat		email Website Facebook
Ward 4	David Skilling	Unaffiliated		email Website
Ward 4	LaDawn Sperling	Republican		email Facebook
Ward 5	Karen Harrison (i)	Unaffiliated		email Website
Ward 5	Nancy Pallozzi	Republican		email Website

(i) = incumbent

Former Candidates

Raw Table

Seat	Name	Party	Comment	Contact

Complete Example Table

Example from the Aurora page.

Ward	Name	Party	Info	Contact
Ward 3	Kevin Cox	Democrat	Instead running for Aurora Public Schools	Online Contact Form: http://kevincoxforaurora.com/contact/
At-Large	Julie Weinheimer	Unaffiliated	Votes for Mike Coffman	contact form: http://weinheimerforaurora.com/contact-us-or-volunteer web: http://weinheimerforaurora.com/
At-Large	PK Kaiser	Democrat	Dropped out to concentrate on 2018 County Assessor race	email: vote4kaiser@gmail.com web: https://jsfulton.wordpress.com/

(Year) Election Issues

Raw Table

• Can add or subtract Issue Columns. To add, put "||" in between issues (with one space on both sides around it).

Usually for municipalities, issues can be (but are not limited to):

• Immigration (Sanctuary Cities)
• Affordable Housing
• Development (which may lead to gentrification)
• Infrastructure
• Zoning issues

Seat	Candidate	(Issue 1)	(Issue 2)	(Issue 3)	(Issue 4)	(Issue 5)

Complete Example Table

In development

Campaign Finance

For each candidate, each filing:

• Total contributions
• Total expenditures
• Total Cash On Hand (Can be a negative value--Debt)
• Any PAC donations, plus amount
• Individual contributions by notable individual donors, plus amount

NOTE: If using Open Secrets, only count from the PAC column, do not solely use the "Total" column, as the "Individual" column and "PAC" column are added together. "Individuals" are everyday people who happen to be employed by those companies, but not donating as those companies. This is in accordance to FEC regulations, where if an individual donates more than a certain amount, they must report their employer and it gets added to the employer's pot. Some campaigns or donation sites ask for employer regardless of donation amount.

First Filing

Month Day, Year

(Temporary raw data table. Data table specific to this being developed.)

Raw Table:

Seat	Name	Party	Total Contributions	Total Expenditures	Total Cash On Hand	Total PACs	Notable Individuals

Complete Example Table:

Example taken from Aurora. (Further development in progress)

Seat	Name	Party	Total Contributions	Total Expenditures	Total Cash On Hand	Total PACs	Notable Individuals
Ward 2	Robert O'Riley	Unaffiliated	$0	$0	$0
Ward 2	Jeff Wilson	Libertarian	$219.12	$101.78	$117.34		In-kind contributions: $250.00 for production of campaign materials Mostly self-funded: $200 from Jeff Wilson
Ward 3	Masha Berzins	Republican	$2,188.00	$950.55 (Previous CoH: $57.09)	$1,294.54		Individuals giving mostly $25-100 Jake Jabs - $400 Jabs is a major Republican donor with financial donations to American Tradition Partnership, an anti-environment right-wing group.
At-Large	Dave Gruber	Republican	$4,285.00	$1,112.55	$3,172.45		Mostly $100-$200 from individuals
At-Large	Abel Gebre Laeke	Democrat	$4,390.00	$4,112.08	$277.92		Mostly small contributions ($10-$50) from individuals Gaim Tedia - $2,000
At-Large	Tom Tobiassen	Democrat	$28,925.00	$2,017.04	$26,907.96		Many contributions in $100-$500 range from both individuals and businesses, in Aurora and other cities. Loan from Tom and Carol Tobiassen - $13,000

• Then do subsections for "Second Filing", "Third Filing", etc.

Ballot Measures

Ballot Measure Name or Descriptive Title

Brief description.

Brief history of Ballot measure.

Ballot Language

"Language here"

Amendment Language

"Language here"

Arguments For

• Reason 1
• Reason 2
• Etc.

Can give quotes from notable people, with citations.

Arguments Against

• Reason 1
• Reason 2
• Etc.

Can give quotes from notable people with citations.

Special Interests

Sometimes special interests get involved. Detail those specific to each individual Ballot Measure here. If applicable, also put down any money spent in either direction for or against the measure.

May not require a table, as it could be a bulleted list.