Template:USSenateProfile

    {{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
    You must login to post a comment.
    Powered by MindTouch Core