Page last modified 02:34, 15 Mar 2009 by ilan

Template:USSenateProfile

1. Voting Record
2. Cosponsored the following Pro-Information Rights Bills:
3. Cosponsored the following Anti-Information Rights Bills:

{{sunlight.getphoto{id: xml.Text(sunlightData,'//bioguide_id')} }}

Current Position: Senator -- {{ xml.Text(sunlightData,'//state') }}
Party: {{xml.Text(sunlightData,'//party')}}

Contact Information
Phone: {{xml.Text(sunlightData,'//phone')}}
Website: {{web.link(xml.Text(sunlightData,'//website'))}}
Email: {{xml.Text(sunlightData,'//email') ?? "Unavailable"}}
Contact Form: {{web.link(xml.Text(sunlightData,'//webform')) ?? "Unavailable"}}

Voting Record

{{ mysql.table("select title as Bill, votetype.votetype as 'GeekPAC Position', votetypegov.votetype as Voted from bills join geekpac_bills on bills.bill_id = geekpac_bills.bill_id join rolls on bills.bill_id=rolls.bill_id join votes on votes.roll_id=rolls.roll_id join votetype on geekpac_bills.geekpac_position = votetype.votetype_id join votetype as votetypegov on votes.vote=votetypegov.govtrack where govtrack_id=" .. xml.Text(sunlightData,'//govtrack_id') .. " group by Bill order by Bill, rolls.roll_id") }}

Cosponsored the following Pro-Information Rights Bills:

{{mysql.table("select title as Bill from bills join geekpac_bills on bills.bill_id = geekpac_bills.bill_id join cosponsors on cosponsors.bill_id = bills.bill_id where geekpac_position='1' and cosponsors.cosponsor_id=" .. xml.Text(sunlightData,'//govtrack_id')) }}

Cosponsored the following Anti-Information Rights Bills:

{{mysql.table("select title as Bill from bills join geekpac_bills on bills.bill_id = geekpac_bills.bill_id join cosponsors on cosponsors.bill_id = bills.bill_id where geekpac_position='2' and cosponsors.cosponsor_id=" .. xml.Text(sunlightData,'//govtrack_id')) }}

Tag page (Edit tags)

No tags

What links here

Files 0

Attach file or image

Images 0
No images to display in the gallery.

You must login to post a comment.