Difference between revisions of "City Format Demo"

Revision as of 21:27, 1 September 2017 (view source) Jessica Sandi (Talk | contribs) (Created page)		Revision as of 07:58, 5 September 2017 (view source) Bruce Norikane (Talk | contribs) (→‎20XX Elections: - added test of pasting John's DemEnter extract from 9:15pm on 9/4/17) Newer edit →
Line 496:		Line 496:
	|-		|-
	|  ||  || {{party|}} ||  ||		|  ||  || {{party|}} ||  ||
		+	|-
		+	|}
		+	(i) = incumbent
		+
		+	<br>
		+
		+	''' Example pasted from John's DemEnter test output by Bruce '''
		+
		+	From the Alamosa section of John's DemEnter test posted 9:15 pm 9/4/2017
		+	added |- between rows
		+
		+	{| class="wikitable" style="margin:left; text-align: center;"
		+	|-
		+	! Seat || Name || Party || Endorsements/Info || Contact
		+	|-
		+	| At Large || Jan Vigil || {{party|?}} || || email: [mailto: ] <br/> web: [ ]
		+	|-
		+	| Ward 4 || Michael Carson || {{party|?}} || || email: [mailto: ] <br/> web: [ ]
		+	|-
		+	| Ward 4 || Michael Stefano || {{party|?}} || || email: [mailto: ] <br/> web: [ ]
		+	|-
		+	| Ward 2 || David Broyles || {{party|?}} || || email: [mailto: ] <br/> web: [ ]
		+	|-
		+	| Ward 2 || Kristina Daniel || {{party|?}} || || email: [mailto: ] <br/> web: [ ]
	|-		|-
	|}		|}

---

Revision as of 07:58, 5 September 2017

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.

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)			Expression error: Unexpected >= operator.None: %Expression error: Unexpected >= operator. 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: % Associate's: % Some High School: % Master's: % Less than High School: % None: %		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 deailing 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)

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]

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 Elections

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

Example pasted from John's DemEnter test output by Bruce

From the Alamosa section of John's DemEnter test posted 9:15 pm 9/4/2017 added |- between rows

Seat	Name	Party	Endorsements/Info	Contact
At Large	Jan Vigil	?		email: [mailto: ] web: [ ]
Ward 4	Michael Carson	?		email: [mailto: ] web: [ ]
Ward 4	Michael Stefano	?		email: [mailto: ] web: [ ]
Ward 2	David Broyles	?		email: [mailto: ] web: [ ]
Ward 2	Kristina Daniel	?		email: [mailto: ] web: [ ]

(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	comment	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/

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:

Seat	Name	Party	Total Contributions	Total Expenditures	Total Cash On Hand	Total PACs	Notable Individuals
Ward 1	First Last	Unaffiliated	$10,000	$10,000	$0	$0	N/A
Ward 2	Meh Whatever	Unaffiliated	$50,000	$30,000	$20,000	$40,000	Random out-of-state billionaire - $25,000

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.