In [0]:

    

!pip install pyopenstates


    

    




Collecting pyopenstates
  Downloading https://files.pythonhosted.org/packages/f1/2e/cf7117f53fc5bd0c4b86dd5f6f4750d534e6fcf43f931c6db578819881da/pyopenstates-1.2.0-py2.py3-none-any.whl
Requirement already satisfied: requests in /usr/local/lib/python3.6/dist-packages (from pyopenstates) (2.21.0)
Requirement already satisfied: certifi>=2017.4.17 in /usr/local/lib/python3.6/dist-packages (from requests->pyopenstates) (2019.11.28)
Requirement already satisfied: chardet<3.1.0,>=3.0.2 in /usr/local/lib/python3.6/dist-packages (from requests->pyopenstates) (3.0.4)
Requirement already satisfied: urllib3<1.25,>=1.21.1 in /usr/local/lib/python3.6/dist-packages (from requests->pyopenstates) (1.24.3)
Requirement already satisfied: idna<2.9,>=2.5 in /usr/local/lib/python3.6/dist-packages (from requests->pyopenstates) (2.8)
Installing collected packages: pyopenstates
Successfully installed pyopenstates-1.2.0

In [0]:

    

from datetime import datetime
import os
import sys
import pandas as pd


    

In [0]:

    

import pyopenstates
pyopenstates.set_api_key('<api key here>')


    

In [0]:

    

def get_state_abbr(state):
    return state.get('abbreviation')


def get_state_name(state):
    return state.get('name')


def query_state(state, search_terms):
    """
    https://openstates.github.io/pyopenstates/pyopenstates%20module.html#pyopenstates.search_bills
    uses keyworded argument in function
    """
    print('Query for ' + state + ' bills')

    bills = pyopenstates.search_bills(state=state, q=search_terms)

    return bills


    

In [0]:

    

metadata = pyopenstates.get_metadata()
states = list(map(get_state_abbr, metadata))


    

In [0]:

    

bills = query_state('tx', 'firearms')


    

    




Query for tx bills

In [0]:

    

tx_bills_df = pd.DataFrame.from_dict(bills)


    

In [0]:

    

tx_bills_df


    

    
Out[0]:







  

    

      

      
title
      
summary
      
created_at
      
updated_at
      
id
      
all_ids
      
chamber
      
state
      
session
      
type
      
bill_id
      
actions
      
sources
      
sponsors
      
versions
      
documents
      
alternate_titles
      
votes
      
action_dates
      
scraped_subjects
      
alternate_bill_ids
      
subjects
      
companions
    
  
  

    

      
0
      
Relating to firearms training for county jailers.
      

      
2019-03-07 13:35:03
      
2020-03-31 09:21:27
      

      
[]
      
lower
      
tx
      
86
      
[bill]
      
HB 3503
      
[{'date': '2019-03-06 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/86...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
None
      
{'first': 2019-03-06 00:00:00, 'last': 2019-06...
      
[Corrections--Jails & Prisons (I0092), Occupat...
      
[]
      
[]
      
[]
    
    

      
1
      
Relating to the continuation and functions of ...
      

      
2019-03-01 12:54:30
      
2020-03-31 09:18:10
      

      
[]
      
lower
      
tx
      
86
      
[bill]
      
HB 1545
      
[{'date': '2019-02-28 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/86...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
None
      
{'first': 2019-02-28 00:00:00, 'last': 2019-06...
      
[Alcoholic Beverage Regulation (I0025), Govern...
      
[]
      
[]
      
[]
    
    

      
2
      
Relating to the offense of possessing a weapon...
      

      
2019-01-30 11:41:09
      
2020-03-31 09:20:47
      

      
[]
      
lower
      
tx
      
86
      
[bill]
      
HB 1168
      
[{'date': '2019-01-29 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/86...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
None
      
{'first': 2019-01-29 00:00:00, 'last': 2019-06...
      
[Crimes--Miscellaneous (I0200), Transportation...
      
[]
      
[]
      
[]
    
    

      
3
      
Relating to granting limited state law enforce...
      

      
2019-03-08 13:55:52
      
2020-03-31 09:08:24
      

      
[]
      
lower
      
tx
      
86
      
[bill]
      
HB 3863
      
[{'date': '2019-03-07 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/86...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
None
      
{'first': 2019-03-07 00:00:00, 'last': 2019-06...
      
[Agriculture (I0020), Law Enforcement (I0510),...
      
[]
      
[]
      
[]
    
    

      
4
      
Relating to the regulation of firearms, air gu...
      

      
2019-03-06 13:16:03
      
2020-03-31 09:19:52
      

      
[]
      
lower
      
tx
      
86
      
[bill]
      
HB 3231
      
[{'date': '2019-03-05 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/86...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
None
      
{'first': 2019-03-05 00:00:00, 'last': 2019-06...
      
[City Government--General (I0060), County Gove...
      
[]
      
[]
      
[]
    
    

      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
      
...
    
    

      
168
      
Relating to the creation of the offense of ind...
      

      
2017-07-26 05:24:41
      
2018-10-23 05:27:56
      
TXB00059103
      
[TXB00059103]
      
lower
      
tx
      
851
      
[bill]
      
HB 309
      
[{'date': '2017-07-25 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/85...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
None
      
{'first': 2017-07-25 00:00:00, 'last': 2017-07...
      
[Crimes--Against Persons--Sexual (I0171), Crim...
      
[]
      
[]
      
[]
    
    

      
169
      
Relating to the carrying of a firearm by a per...
      

      
2017-07-25 05:24:17
      
2018-10-23 05:28:29
      
TXB00059060
      
[TXB00059060]
      
lower
      
tx
      
851
      
[bill]
      
HB 296
      
[{'date': '2017-07-24 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/85...
      
[{'leg_id': None, 'type': 'cosponsor', 'name':...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
[]
      
None
      
{'first': 2017-07-24 00:00:00, 'last': 2017-07...
      
[Crimes--Miscellaneous (I0200), Weapons (I0887...
      
[]
      
[]
      
[]
    
    

      
170
      
Relating to exempting the intrastate manufactu...
      

      
2017-07-22 05:21:17
      
2018-10-23 05:27:48
      
TXB00058622
      
[TXB00058622]
      
upper
      
tx
      
851
      
[bill]
      
SB 100
      
[{'date': '2017-07-21 00:00:00', 'action': 'Re...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/85...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
[]
      
None
      
{'first': 2017-07-21 00:00:00, 'last': 2017-07...
      
[Business & Commerce--General (I0050), Weapons...
      
[]
      
[]
      
[]
    
    

      
171
      
Relating to an exemption from the sales tax fo...
      

      
2017-07-21 05:17:41
      
2018-10-23 05:28:45
      
TXB00058778
      
[TXB00058778]
      
lower
      
tx
      
851
      
[bill]
      
HB 216
      
[{'date': '2017-07-18 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/85...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
[]
      
None
      
{'first': 2017-07-18 00:00:00, 'last': 2017-07...
      
[Parks & Wildlife--Hunting & Fishing (I0560), ...
      
[]
      
[]
      
[]
    
    

      
172
      
Relating to the offense of possessing a weapon...
      

      
2017-07-21 05:17:38
      
2018-10-23 05:28:32
      
TXB00058618
      
[TXB00058618]
      
lower
      
tx
      
851
      
[bill]
      
HB 175
      
[{'date': '2017-07-17 00:00:00', 'action': 'Fi...
      
[{'url': 'ftp://ftp.legis.state.tx.us/bills/85...
      
[{'leg_id': None, 'type': 'primary', 'name': '...
      
[{'mimetype': 'text/html', 'url': 'ftp://ftp.l...
      
[]
      
[]
      
None
      
{'first': 2017-07-17 00:00:00, 'last': 2017-07...
      
[Transportation--Aviation (I0822), Weapons (I0...
      
[]
      
[]
      
[]
    
  

173 rows × 23 columns

In [0]: