Mike add a sort by government entity radio button modifiy the other buttons to sort by entity

query='select name, district_n, district_a, comments, party, elected_officials.political_party, party_image, party_css, political_party_text, '' as office, terms_in_offices, elected_officials.harm_reduction, elected_officials.legalize_pot, harm_reduction_text, harm_reduction_image, harm_reduction_css, legalize_pot_text, legalize_pot_image, legalize_pot_css, status_image, status_css, status_overall_css, photo, email, status_text, title_actual, phone_home, phone_work, phone_cell, phone_fax, elected_officials.id_title, government_entitys.name_entity, titles.title, titles.title_actual, candidate, incumbent, date_1st_term_start, date_last_term_end, date_1st_candidacy, date_last_candidacy from elected_officials, status, harm_reduction, political_parties, titles, legalize_pot, government_entitys where elected_officials.political_party = political_parties.political_party and elected_officials.harm_reduction = harm_reduction.harm_reduction and elected_officials.legalize_pot = legalize_pot.legalize_pot and elected_officials.id_title = titles.id_title and elected_officials.government_entity = government_entitys.id_entity and elected_officials.status = status.status and ( elected_officials.government_entity ='2' ) '
Government Bureaucrats - Voting records of Arizona politicians and elected officials on their marijuana voting record

Government Bureaucrats

Voting records of Arizona elected officials on marijuana issues

Sort by: Name      District      Party, Name      Party, District
Status, Name      Status, District
Harm Reduction, Name      Harm Reduction, District
Legalize Marijuana, Name      Legalize Marijuana, District

Search for

by name
by email

by party
by districts
by issues
Harm reduction
Legalize marijuana
Status
Government Entity
Title

	John Allen Office:Representative Entity:Arizona House District:15 Party:Republican Email: jallen@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4916 Fax:(602)417-3150 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Brenda Barton Office:Representative Entity:Arizona House District:6 Party:Republican Email: bbarton@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4129 Fax:(602)417-3010 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Sonny Borrelli Office:Representative Entity:Arizona House District:5 Party:Republican Email: sborrelli@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5051 Fax:(602)417-3003 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Paul Boyer Office:Representative Entity:Arizona House District:20 Party:Republican Email: pboyer@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4173 Fax:(602)417-3153 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Kate Brophy McGee Office:Representative Entity:Arizona House District:28 Party:Republican Email: kbrophymcgee@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4486 Fax:(602)417-3170 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Heather Carter Office:Representative Entity:Arizona House District:15 Party:Republican Email: hcarter@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5503 Fax:(602)417-3107 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Doug Coleman Office:Representative Entity:Arizona House District:16 Party:Republican Email: dcoleman@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-3160 Fax:(602)417-3151 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Jeff Dial Office:Representative Entity:Arizona House District:18 Party:Republican Email: jdial@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5550 Fax:(602)417-3120 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Karen Fann Office:Representative Entity:Arizona House District:1 Party:Republican Email: kfann@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5874 Fax:(602)417-3001 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Eddie Farnsworth Office:Representative Entity:Arizona House District:12 Party:Republican Email: efarnsworth@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5735 Fax:(602)417-3122 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Thomas Forese Office:Representative Entity:Arizona House District:17 Party:Republican Email: tforese@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5168 Fax:(602)417-3021 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Doris Goodale Office:Representative Entity:Arizona House District:5 Party:Republican Email: dgoodale@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5408 Fax:(602)417-3103 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	David M. Gowan Sr. Office:Representative Entity:Arizona House District:0 Party:Unknown Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
No Photo	Majority Leader Office:Representative Entity:Arizona House District:14 Party:Republican Email: dgowan@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-3312 Fax:(602)417-3130 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Rick Gray Office:Representative Entity:Arizona House District:0 Party:Unknown Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
No Photo	Majority Whip Office:Representative Entity:Arizona House District:21 Party:Republican Email: rgray@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5993 Fax:(602)417-3225 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	John Kavanagh Office:Representative Entity:Arizona House District:23 Party:Republican Email: jkavanagh@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5170 Fax:(602)417-3108 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Adam Kwasman Office:Representative Entity:Arizona House District:11 Party:Republican Email: akwasman@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5839 Fax:(602)417-3026 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Debbie Lesko Office:Representative Entity:Arizona House District:21 Party:Republican Email: dlesko@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5413 Fax:(602)417-3109 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	David Livingston Office:Representative Entity:Arizona House District:22 Party:Republican Email: dlivingston@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4178 Fax:(602)417-3154 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Phil Lovas Office:Representative Entity:Arizona House District:22 Party:Republican Email: plovas@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-3297 Fax:(602)417-3004 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Javan "J.D." Mesnard Office:Representative Entity:Arizona House District:17 Party:Republican Email: jmesnard@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4481 Fax:(602)417-3152 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Darin Mitchell Office:Representative Entity:Arizona House District:13 Party:Republican Email: dmitchell@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5894 Fax:(602)417-3012 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Steve Montenegro Office:Representative Entity:Arizona House District:13 Party:Republican Email: smontenegro@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5955 Fax:(602)417-3168 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Justin Olson Office:Representative Entity:Arizona House District:25 Party:Republican Email: jolson@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5288 Fax:(602)417-3161 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Ethan Orr Office:Representative Entity:Arizona House District:9 Party:Republican Email: eorr@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-3235 Fax:(602)417-3030 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Warren Petersen Office:Representative Entity:Arizona House District:12 Party:Republican Email: wpetersen@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4136 Fax:(602)417-3222 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Justin Pierce Office:Representative Entity:Arizona House District:25 Party:Republican Email: jpierce@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5495 Fax:(602)417-3019 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Frank Pratt Office:Representative Entity:Arizona House District:8 Party:Republican Email: fpratt@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5761 Fax:(602)417-3023 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Bob Robson Office:Representative Entity:Arizona House District:18 Party:Republican Email: brobson@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5549 Fax:(602)417-3157 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Carl Seel Office:Representative Entity:Arizona House District:20 Party:Republican Email: cseel@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-3018 Fax:(602)417-3006 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	T.J. Shope Office:Representative Entity:Arizona House District:8 Party:Republican Email: tshope@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-3012 Fax:(602)417-3123 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Steve Smith Office:Representative Entity:Arizona House District:11 Party:Republican Email: stsmith@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5685 Fax:(602)417-3167 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	David W. Stevens Office:Representative Entity:Arizona House District:14 Party:Republican Email: dstevens@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4321 Fax:(602)417-3146 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Bob Thorpe Office:Representative Entity:Arizona House District:6 Party:Republican Email: bthorpe@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5219 Fax:(602)417-3118 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Andy Tobin Office:Representative Entity:Arizona House District:1 Party:Republican Email: atobin@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-5172 Fax:(602)417-3085 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Kelly Townsend Office:Representative Entity:Arizona House District:16 Party:Republican Email: ktownsend@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4467 Fax:(602)417-3018 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01
	Michelle Ugenti Office:Representative Entity:Arizona House District:23 Party:Republican Email: mugenti@azleg.gov Terms:0 Status: Unknown Harm Reduction: Unknown Legalize Pot: Unknown Phone Work:(602)926-4480 Fax:(602)417-3155 Incumbent Terms 2013-01-01 - 2014-12-31 Attempts 1971-01-01 - 1971-01-01