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 ='1' )
'
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
|
|
Nancy Barto
Office:Senator
Entity:Arizona Senate
District:15
Party:Republican
Email: nbarto@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5766
Fax:(602)417-3261%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Andy Biggs
Office:Senator
Entity:Arizona Senate
District:12
Party:Republican
Email: abiggs@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-4371
Fax:(602)417-3022%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Judy Burges
Office:Senator
Entity:Arizona Senate
District:22
Party:Republican
Email: jburges@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5861
Fax:(602)417-3104%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
No Photo |
Rich Crandall
Office:Senator
Entity:Arizona Senate
District:16
Party:Republican
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
|
|
Chester Crandell
Office:Senator
Entity:Arizona Senate
District:6
Party:Republican
Email: ccrandell@azleg.gov
Terms:0
Status: Foe
Harm Reduction:Oppose
Legalize Pot:Oppose
Phone Work:(602)926-5409
Fax:(602)417-3105%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Adam Driggs
Office:Senator
Entity:Arizona Senate
District:28
Party:Republican
Email: adriggs@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-3016
Fax:(602)417-3007%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
David Farnsworth
Office:Senator
Entity:Arizona Senate
District:16
Party:Republican
Email: dfarnsworth@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-3020
Fax:(602)417-3119%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Gail Griffin
Office:Senator
Entity:Arizona Senate
District:14
Party:Republican
Email: ggriffin@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5895
Fax:(602)417-3025%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
John McComish
Office:Senator
Entity:Arizona Senate
District:18
Party:Republican
Email: jmccomish@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5898
Fax:(602)417-3020%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Al Melvin
Office:Senator
Entity:Arizona Senate
District:11
Party:Republican
Email: amelvin@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-4326
Fax:(602)417-3159%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Rick Murphy
Office:Senator
Entity:Arizona Senate
District:21
Party:Republican
Email: rmurphy@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-4444
Fax:(602)417-3009%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Steve Pierce
Office:Senator
Entity:Arizona Senate
District:1
Party:Republican
Email: spierce@azleg.gov
Terms:0
Status: Foe
Harm Reduction:Oppose
Legalize Pot:Oppose
Phone Work:(602)926-5584
Fax:(602)417-3101%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Michele Reagan
Office:Senator
Entity:Arizona Senate
District:23
Party:Republican
Email: mreagan@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5828
Fax:(602)417-3255%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Don Shooter
Office:Senator
Entity:Arizona Senate
District:13
Party:Republican
Email: dshooter@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-4139
Fax:(602)417-3024%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Anna Tovar
Office:Senator
Entity:Arizona Senate
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
|
|
Kelli Ward
Office:Senator
Entity:Arizona Senate
District:5
Party:Republican
Email: kward@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-4138
Fax:(602)417-3165%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Bob Worsley
Office:Senator
Entity:Arizona Senate
District:25
Party:Republican
Email: bworsley@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5760
Fax:(602)417-3091%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Steve Yarbrough
Office:Senator
Entity:Arizona Senate
District:17
Party:Republican
Email: syarbrough@azleg.gov
Terms:0
Status: Unknown
Harm Reduction: Unknown
Legalize Pot: Unknown
Phone Work:(602)926-5863
Fax:(602)417-3258%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
Kimberly Yee
Office:Senator
Entity:Arizona Senate
District:20
Party:Republican
Email: kyee@azleg.gov
Terms:0
Status: Foe
Harm Reduction:Oppose
Legalize Pot:Oppose
Phone Work:(602)926-3024
Fax:(602)417-3110%
Incumbent
Terms 2013-01-01 - 2014-12-31
Attempts 1971-01-01 - 1971-01-01
|
|
|
Dennis's Web Page with the bureaucrats!!!!!
SAFER Arizona
Phoenix NORML
AZ4NORML
NORML in Arizona
Phoenix NORML
Tempe NORML
Arizona NORML Chapters
West Valley NORML
Tucson NORML
Arizona Weekly Weeder
Arizona Weekly Weeder - Phoenix
CAMP 420
CAMP 420