List view
Import from TPJ.
Overdue by 5 year(s)•Due by August 30, 2020Explore Tableau public. download Tableau Public https://public.tableau.com/en-us/s/ play around with the templates (you can pick BBC style guide, etc.) search for "donor information dashboards" and see what you find You can do a lot with the free version. Basically, you upload your spreadsheet (like the top 10 donors one) and then drag and drop the fields. Thus, you can create one pie chart template, and it will autopopulate the data for all the legislators. You can then filter down to isolate one particular lawmaker. Ask Amy for Excel spreadsheet to play with. @amy.m.mosley
Overdue by 4 year(s)•Due by September 30, 2021"Does This Bill Have a Chance in Hell of Passing?" metric. Unfortunately, bill content doesn't really matter. Which of the 7,000 bills that are introduced at the beginning of a session should you pay attention to? (1) is the author a freshman or experienced lawmaker? (2) is the author a committee chairman? (3) does the bill have bipartisan support? (4) does the bill have a companion in the House (or Senate)? (Method: use the Admin Portal to research and input the data points on the lawmakers (like # of years in office, Dem or Repub, what committees they chair, if any). Pull bill companion info off TLO.) *** Create a list of bills to test: some that passed and some that did not *** Need Committee Assignments added to legi Bills signed by Governor in 86th Session: https://capitol.texas.gov/Search/BillSearchResults.aspx?NSP=1&SPL=False&SPC=False&SPA=True&SPS=False&Leg=86&Sess=R&ChamberH=True&ChamberS=True&BillType=B;JR;;;;;&AuthorCode=&SponsorCode=&ASAndOr=O&IsPA=True&IsJA=False&IsCA=False&IsPS=True&IsJS=False&IsCS=False&CmteCode=&CmteStatus=&OnDate=&FromDate=&ToDate=&FromTime=&ToTime=&LastAction=False&Actions=E020;&AAO=O&Subjects=&SAO=&TT=&ID=IHZ7Sxv9D
Overdue by 5 year(s)•Due by December 15, 2020Records obtained via open records request to State of Texas: https://www.dropbox.com/sh/wwzlqy8umfm0usm/AADBTMD12JRl6INMH8fCyxRPa?dl=0 Converting directly to text (no html). Using Tabula (used by NYT and ProPublica). Java library. Find open source meta data file categorizing names of stocks with industry categories. Texas Secretary of State -- list of categories of businesses
Overdue by 5 year(s)•Due by August 15, 2020•4/4 issues closedCreate admin portal so non-technical users can contribute data to the database, as government data often contains irregularities which require manual input/correction.
No due date•1/1 issues closedEach House and Senate member serves on multiple committees. It is essential that we note these committees on each lawmaker's profile page. The goal is to be able to sort by committee -- and to pull up the lawmakers that serve on that committee and aggregate their top donor $. (***Example: The members of the Senate Transportation Committee got ridiculous amounts of money from ABC Transportation Company.***) https://house.texas.gov/committees/ https://senate.texas.gov/committees.php Texas Legislature Online -- you can sort several different ways: https://capitol.texas.gov/Committees/Membership.aspx
Overdue by 5 year(s)•Due by July 31, 2020•0/1 issues closedSuper important! Urgent! This is the easiest way to tell who has skin in the game of a bill.
Overdue by 4 year(s)•Due by January 1, 2022•1/4 issues closedNEW PLAN: Pop up box that request first name only + email address to continue Enable Users and Logins/Authentication. Purpose: * Allows for an authentication function, includes API. * Users can save preferences. * Allows for more user interaction, by saving Bills or Legislators for easy reference later, or alerts. * Allows for better user engagement.
Overdue by 5 year(s)•Due by July 31, 2020•0/6 issues closedFOCUS ON: (1) The House and/or Senate committee that a bill came out of and (2) Witness Lists scraping (do not list entities as "pro" or "con" but as "stakeholders") This will work, because we are focusing on bills that passed and became law -- so all of these bills received a public hearing and came out of a committee. Add Industry classification to Bills and Contributors. Use: Center for Responsive Politics categories: https://www.opensecrets.org/resources/ftm/ch12p1.php Purpose: * Allow for Industry specific context. * Determine influence of industry on legislative actions. * Allow filtering by industry on Bills and Contributions.
Overdue by 4 year(s)•Due by January 1, 2022•0/5 issues closedImprove display and interactive design of data. Purpose: * Improve user engagement. * Determine how to integrate more context around Votes and Bill subjects. * Allow for historical data to be displayed meaningfully. * Mobile/Tablet vs. Desktop considerations. * Allow filtering by different axes.
No due date•7/8 issues closedUse ***Legiscan*** to import vote data. Previously used OpenStates.org, which is now defunct for Texas. * downloaded JSON files from Legiscan, because the Legiscan API sucks. * https://legiscan.com/datasets * Click on "data sets" in top menu bar * Then go to Texas * You can download the entire 86th session in a JSON file. It contains bills people and votes. (There may be an ID problem with Jarvis Johnson from District 139. Otherwise, it's pretty bug-free.) * As far as we know, it is accurate. You can spot-test accuracy (using the Legiscan Search box on the home page), and it seems to be accurately collecting all the actions of bills and correctly identifying the final votes. **(They) tried to use the Legiscan API and it sucked. That's why they went the download route. Also, interestingly enough, the Legiscan IDs correspond with https://votesmart.org/ (which is another service that sucks). Implement our own data gathering methods. Purpose: * Remove dependence on external sources. * Improve accuracy and consistency. * Allow for importing historical data. * Allow importing from different sources.
Overdue by 4 year(s)•Due by November 1, 2021•1/4 issues closedAdd an API application to the Django framework. Purpose: * Allows for more frontend development. * Allows for API driven object creation. * Allows for authenticated access to objects.
Overdue by 6 year(s)•Due by September 30, 2019•2/3 issues closed