visualizing data with pandas#
import pandas as pd
import matplotlib.pyplot as plt
A module that was compiled using NumPy 1.x cannot be run in
NumPy 2.0.1 as it may crash. To support both 1.x and 2.x
versions of NumPy, modules must be compiled with NumPy 2.0.
Some module may need to rebuild instead e.g. with 'pybind11>=2.12'.
If you are a user of the module, the easiest solution will be to
downgrade to 'numpy<2' or try to upgrade the affected module.
We expect that some modules will need time to support NumPy 2.
Traceback (most recent call last): File "/Users/fcalado/.conda/envs/jb/lib/python3.11/runpy.py", line 198, in _run_module_as_main
return _run_code(code, main_globals, None,
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/runpy.py", line 88, in _run_code
exec(code, run_globals)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel_launcher.py", line 18, in <module>
app.launch_new_instance()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/traitlets/config/application.py", line 1075, in launch_instance
app.start()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelapp.py", line 739, in start
self.io_loop.start()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/tornado/platform/asyncio.py", line 205, in start
self.asyncio_loop.run_forever()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/asyncio/base_events.py", line 608, in run_forever
self._run_once()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/asyncio/base_events.py", line 1936, in _run_once
handle._run()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/asyncio/events.py", line 84, in _run
self._context.run(self._callback, *self._args)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 545, in dispatch_queue
await self.process_one()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 534, in process_one
await dispatch(*args)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 437, in dispatch_shell
await result
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/ipkernel.py", line 362, in execute_request
await super().execute_request(stream, ident, parent)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 778, in execute_request
reply_content = await reply_content
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/ipkernel.py", line 449, in do_execute
res = shell.run_cell(
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/zmqshell.py", line 549, in run_cell
return super().run_cell(*args, **kwargs)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3075, in run_cell
result = self._run_cell(
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3130, in _run_cell
result = runner(coro)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/async_helpers.py", line 128, in _pseudo_sync_runner
coro.send(None)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3334, in run_cell_async
has_raised = await self.run_ast_nodes(code_ast.body, cell_name,
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3517, in run_ast_nodes
if await self.run_code(code, result, async_=asy):
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3577, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)
File "/var/folders/z6/8hbw1n6n3dq2jdw3_zjysj5sws21gh/T/ipykernel_71519/1492400551.py", line 1, in <module>
import pandas as pd
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/pandas/__init__.py", line 26, in <module>
from pandas.compat import (
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/pandas/compat/__init__.py", line 27, in <module>
from pandas.compat.pyarrow import (
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/pandas/compat/pyarrow.py", line 8, in <module>
import pyarrow as pa
File "/Users/fcalado/.local/lib/python3.11/site-packages/pyarrow/__init__.py", line 65, in <module>
import pyarrow.lib as _lib
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
AttributeError: _ARRAY_API not found
A module that was compiled using NumPy 1.x cannot be run in
NumPy 2.0.1 as it may crash. To support both 1.x and 2.x
versions of NumPy, modules must be compiled with NumPy 2.0.
Some module may need to rebuild instead e.g. with 'pybind11>=2.12'.
If you are a user of the module, the easiest solution will be to
downgrade to 'numpy<2' or try to upgrade the affected module.
We expect that some modules will need time to support NumPy 2.
Traceback (most recent call last): File "/Users/fcalado/.conda/envs/jb/lib/python3.11/runpy.py", line 198, in _run_module_as_main
return _run_code(code, main_globals, None,
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/runpy.py", line 88, in _run_code
exec(code, run_globals)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel_launcher.py", line 18, in <module>
app.launch_new_instance()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/traitlets/config/application.py", line 1075, in launch_instance
app.start()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelapp.py", line 739, in start
self.io_loop.start()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/tornado/platform/asyncio.py", line 205, in start
self.asyncio_loop.run_forever()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/asyncio/base_events.py", line 608, in run_forever
self._run_once()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/asyncio/base_events.py", line 1936, in _run_once
handle._run()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/asyncio/events.py", line 84, in _run
self._context.run(self._callback, *self._args)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 545, in dispatch_queue
await self.process_one()
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 534, in process_one
await dispatch(*args)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 437, in dispatch_shell
await result
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/ipkernel.py", line 362, in execute_request
await super().execute_request(stream, ident, parent)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/kernelbase.py", line 778, in execute_request
reply_content = await reply_content
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/ipkernel.py", line 449, in do_execute
res = shell.run_cell(
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/ipykernel/zmqshell.py", line 549, in run_cell
return super().run_cell(*args, **kwargs)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3075, in run_cell
result = self._run_cell(
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3130, in _run_cell
result = runner(coro)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/async_helpers.py", line 128, in _pseudo_sync_runner
coro.send(None)
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3334, in run_cell_async
has_raised = await self.run_ast_nodes(code_ast.body, cell_name,
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3517, in run_ast_nodes
if await self.run_code(code, result, async_=asy):
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/IPython/core/interactiveshell.py", line 3577, in run_code
exec(code_obj, self.user_global_ns, self.user_ns)
File "/var/folders/z6/8hbw1n6n3dq2jdw3_zjysj5sws21gh/T/ipykernel_71519/1492400551.py", line 1, in <module>
import pandas as pd
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/pandas/__init__.py", line 49, in <module>
from pandas.core.api import (
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/pandas/core/api.py", line 9, in <module>
from pandas.core.dtypes.dtypes import (
File "/Users/fcalado/.conda/envs/jb/lib/python3.11/site-packages/pandas/core/dtypes/dtypes.py", line 24, in <module>
from pandas._libs import (
File "/Users/fcalado/.local/lib/python3.11/site-packages/pyarrow/__init__.py", line 65, in <module>
import pyarrow.lib as _lib
---------------------------------------------------------------------------
AttributeError Traceback (most recent call last)
AttributeError: _ARRAY_API not found
df = pd.read_csv('https://bit.ly/anti-trans-tracker-csv')
df
| State | Number | Summary | Bill Type | Date | Status | Youth State Risk | Adult State Risk | Notes | URL | Sponsors | Calendar | History | Manual Status | Change Hash | Bill ID | Bill Analysis (AI Automated) | Bill PDF | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Alabama | HB111 | Sex-based terms, defined; vital statistics, r... | End Legal Recognition | 4/23/2024 | Read for the Second Time and placed on the Cal... | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" l... | https://legiscan.com/AL/bill/HB111/2024 | Susan DuBose | Hearing 2024-02-21 13:30 Room 200, Hearing 202... | H 2024-02-06 Read for the first time and refer... | Failed | 5a62a592eb85f81158d0550d3eb938a5 | 1838621.0 | https://www.legislature.state.al.us/pdf/Search... | NaN | https://drive.google.com/open?id=1BTppJ8TUEUAY... |
| 1 | Alabama | HB4 | Crimes and offenses, further provides for obsc... | Book Ban | 7/8/2024 | Pending House Judiciary | Worst | Worst | Prefiled for 2025 session; re: K12 & public li... | https://legiscan.com/AL/bill/HB4/2025 | NaN | NaN | NaN | Roll Over | NaN | NaN | NaN | NaN | NaN |
| 2 | Alabama | HB130 | Education, instruction about gender identity a... | Don't Say Gay Expansion | 5/2/2024 | Read for the Second Time and placed on the Cal... | Worst | Worst | complete ban up to 12th grade | https://legiscan.com/AL/bill/HB130/2024 | Mack Butler | Hearing 2024-03-06 13:30 Room 206, Hearing 202... | H 2024-02-07 Read for the first time and refer... | Failed | d53c58b7b3378898787e527d624fde66 | 1839515.0 | https://www.legislature.state.al.us/pdf/Search... | NaN | https://drive.google.com/open?id=1UzKr3cDOPU-h... |
| 3 | Alabama | HB164 | Consumer Protection; online distribution of ma... | Online Obscenity Law | 4/24/2024 | Enacted | Worst | Worst | NaN | https://legiscan.com/AL/bill/HB164/2024 | Ben Robbins | Hearing 2024-02-21 13:30 Room 200, Hearing 202... | H 2024-02-14 Read for the first time and refer... | Enacted | 741891759bc2063ba90929a5b6be2023 | 1846509.0 | https://www.legislature.state.al.us/pdf/Search... | NaN | https://drive.google.com/open?id=1god4bODWxmQY... |
| 4 | Alabama | HB167 | Consumer protection; filter requirements on In... | Online Obscenity Law | 5/7/2024 | Read for the Second Time and placed on the Cal... | Worst | Worst | NaN | https://legiscan.com/AL/bill/HB167/2024 | Chris Sells | Hearing 2024-03-06 15:00 Room 418, Hearing 202... | H 2024-02-14 Read for the first time and refer... | Failed | ff90e16338864dce71e75783f3964655 | 1847116.0 | https://www.legislature.state.al.us/pdf/Search... | NaN | https://drive.google.com/open?id=1tcwtNRRI9sRr... |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 669 | Wyoming | SF0031 | Sex offender registration-promoting obscenity. | Book Ban | 2/21/2024 | 3rd Reading:Failed 13-17-0-0-1 | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0031/2024 | Judiciary | Hearing 2024-02-16 07:30 Capitol Extension Roo... | 2023-12-19 Bill Number Assigned, S 2024-01-24... | Failed | e9ac0ad30ab6480059e4548899baccf9 | 1793746.0 | https://www.wyoleg.gov/2024/Introduced/SF0031.pdf | NaN | https://drive.google.com/open?id=1nw7YD0dlOnKt... |
| 670 | Wyoming | SF0094 | An act regarding compelled speech and state em... | Pronoun Ban | 3/5/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0094/2024 | Clarence Styvar, Jeanette Ward, Tim French, Ly... | Hearing 2024-02-20 00:00 Capitol Extension Roo... | 2024-02-12 Bill Number Assigned, S 2024-02-13... | Failed | ae25521ff8a0e30914f17c71c58a67b6 | 1844771.0 | https://www.wyoleg.gov/2024/Introduced/SF0094.pdf | NaN | https://drive.google.com/open?id=12dzkDfznmNR-... |
| 671 | Wyoming | SF0098 | Statute of limitations-medical procedures on m... | Liability Law/Backdoor Ban | 3/5/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0098/2024 | Ocean Andrew, Robert Davis, Scott Heiner, Ben ... | NaN | 2024-02-12 Bill Number Assigned, S 2024-02-13... | Failed | 4552970efbdbad7a30e0385b759efcf5 | 1844757.0 | https://www.wyoleg.gov/2024/Introduced/SF0098.... | NaN | https://drive.google.com/open?id=1GTklx_Fi2CFl... |
| 672 | Wyoming | SF0099 | Children gender change prohibition. | Gender Affirming Care Ban | 3/22/2024 | Assigned Chapter Number 113 | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0099/2024 | Ocean Andrew, Robert Davis, Scott Heiner, Ben ... | Hearing 2024-03-04 07:30 Capitol Extension Roo... | 2024-02-12 Bill Number Assigned, S 2024-02-13... | Enacted | 8f280aa911e8bccd972722d692d163fc | 1844767.0 | https://www.wyoleg.gov/2024/Introduced/SF0099.... | NaN | https://drive.google.com/open?id=1AFZI2vaM3qSx... |
| 673 | Wyoming | SF0130 | The equality state not equity state act. | DEI Ban | 3/5/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0130/2024 | Dennis Biteman | Hearing 2024-02-20 00:00 Capitol Extension Roo... | 2024-02-14 Bill Number Assigned, S 2024-02-15... | Failed | 55aa87189ccf45b5afcff6f07c42710f | 1846701.0 | https://www.wyoleg.gov/2024/Introduced/SF0130.pdf | NaN | https://drive.google.com/open?id=1gE0W5UICVqYz... |
674 rows × 19 columns
df.info()
<class 'pandas.core.frame.DataFrame'>
RangeIndex: 674 entries, 0 to 673
Data columns (total 19 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 State 674 non-null object
1 Number 674 non-null object
2 Summary 673 non-null object
3 Bill Type 674 non-null object
4 Date 674 non-null object
5 Status 674 non-null object
6 Youth State Risk 674 non-null object
7 Adult State Risk 674 non-null object
8 Notes 365 non-null object
9 URL 674 non-null object
10 Sponsors 530 non-null object
11 Calendar 255 non-null object
12 History 526 non-null object
13 Manual Status 626 non-null object
14 Change Hash 527 non-null object
15 Bill ID 527 non-null float64
16 PDF 527 non-null object
17 Bill Analysis (AI Automated) 4 non-null object
18 Bill PDF 508 non-null object
dtypes: float64(1), object(18)
memory usage: 100.2+ KB
df.columns
Index(['State', 'Number', 'Summary', 'Bill Type', 'Date', 'Status',
'Youth State Risk', 'Adult State Risk', 'Notes', 'URL', 'Sponsors',
'Calendar', 'History', 'Manual Status', 'Change Hash', 'Bill ID', 'PDF',
'Bill Analysis (AI Automated)', 'Bill PDF'],
dtype='object')
sorting values#
using sort_values() and value_counts(), with some of their arguments
df.sort_values('Youth State Risk')
| State | Number | Summary | Bill Type | Date | Status | Youth State Risk | Adult State Risk | Notes | URL | Sponsors | Calendar | History | Manual Status | Change Hash | Bill ID | Bill Analysis (AI Automated) | Bill PDF | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 46 | Florida | H1639 | Gender and Biological Sex | End Legal Recognition | 3/8/2024 | Died in Rules | DO NOT TRAVEL | DO NOT TRAVEL | NaN | https://legiscan.com/FL/bill/H1639/2024 | Insurance & Banking Subcommittee, Select Commi... | Hearing 2024-01-22 15:00 , Hearing 2024-02-01 ... | H 2024-01-09 Filed, H 2024-01-09 1st Reading (... | Failed | ff40924856b0eb94ec83bddcc6fe3fd6 | 1800662.0 | https://www.flsenate.gov/Session/Bill/2024/163... | NaN | https://drive.google.com/open?id=1vxjPheUnGvQk... |
| 59 | Florida | S1780 | Defamation, False Light, and Unauthorized Publ... | Anti-Journalism | 3/8/2024 | Died in Fiscal Policy | DO NOT TRAVEL | DO NOT TRAVEL | NaN | https://legiscan.com/FL/bill/S1780/2024 | Judiciary, Jason Brodeur | Hearing 2024-02-05 14:30 110 Senate Building | S 2024-01-05 Filed, S 2024-01-11 Referred to J... | Failed | 4ae7b34729047180e677d79511b611c9 | 1799256.0 | https://www.flsenate.gov/Session/Bill/2024/178... | NaN | https://drive.google.com/open?id=1FWY9GPoPeofH... |
| 58 | Florida | S1728 | Providing the rights of members of single-sex ... | Legal Discrimination in Education | 3/8/2024 | Died in Education Postsecondary | DO NOT TRAVEL | DO NOT TRAVEL | Could allow for discrimination against trans m... | https://legiscan.com/FL/bill/S1728/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 57 | Florida | S1722 | Child Protective Investigations | Trans Child Abuse | 3/8/2024 | Died in Children, Families, and Elder Affairs | DO NOT TRAVEL | DO NOT TRAVEL | NaN | https://legiscan.com/FL/bill/S1722/2024 | Erin Grall | NaN | S 2024-01-05 Filed, S 2024-01-11 Referred to C... | Failed | 3bbec64081bb522195687b3d5ea74eab | 1799196.0 | https://www.flsenate.gov/Session/Bill/2024/172... | NaN | https://drive.google.com/open?id=1qd-sMTLiIKNQ... |
| 56 | Florida | S1708 | Public Safety Programs | Anti-LGBTQ+ Law Enforcement Bill | 3/8/2024 | Died in Judiciary | DO NOT TRAVEL | DO NOT TRAVEL | NaN | https://legiscan.com/FL/bill/S1708/2024 | Clay Yarborough | NaN | S 2024-01-05 Filed, S 2024-01-11 Referred to J... | Failed | 96ba33f8aec775878cecd143212a001d | 1799156.0 | https://www.flsenate.gov/Session/Bill/2024/170... | NaN | https://drive.google.com/open?id=1GQP88QsVOrLb... |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 266 | Mississippi | SB2722 | Safe Dormitories Act; enact. | Trans Segregation Bill | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/SB2722/2024 | Joseph Seymour | NaN | S 2024-02-19 Referred To Universities and Coll... | Failed | 107690b20ce8f8f5f9b07c74fada9975 | 1851792.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1bxUMhIyd2P6O... |
| 265 | Mississippi | SB2594 | Safety and privacy in correctional facility ro... | Prison Placement Ban | 3/5/2024 | Died In Committee | Worst | Worst | NaN | https://legiscan.com/MS/bill/SB2594/2024 | Jeremy England | NaN | S 2024-02-19 Referred To Corrections, S 2024-0... | Failed | f62ca848a25b12f0bdcc1ef815a1e89c | 1851286.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1_UUVc6T09Eqd... |
| 264 | Mississippi | SB2553 | Mississippi Families' Rights and Responsibilit... | Don't Say Gay/Forced Outing By Schools | 3/5/2024 | Died In Committee | Worst | Worst | NaN | https://legiscan.com/MS/bill/SB2553/2024 | Joey Fillingane | NaN | S 2024-02-16 Referred To Public Health and Wel... | Failed | 5a6b06286b348a8e2437e55b14120331 | 1849036.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1prJp9m0bB9zU... |
| 278 | Missouri | HB1543 | Modifies the offense of providing explicit sex... | Book Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1543/2024 | Jeff Coleman | NaN | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | 1e317d6a8b3cca809011ced02a8456a9 | 1790340.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1Gy_TxSoD8uLQ... |
| 673 | Wyoming | SF0130 | The equality state not equity state act. | DEI Ban | 3/5/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0130/2024 | Dennis Biteman | Hearing 2024-02-20 00:00 Capitol Extension Roo... | 2024-02-14 Bill Number Assigned, S 2024-02-15... | Failed | 55aa87189ccf45b5afcff6f07c42710f | 1846701.0 | https://www.wyoleg.gov/2024/Introduced/SF0130.pdf | NaN | https://drive.google.com/open?id=1gE0W5UICVqYz... |
674 rows × 19 columns
We can use various parameters to customize the sort_values() function. You can see all of them on the docs entry for pandas.DataFrame.sort_values
# inplace
df.sort_values('Bill Type', inplace=True)
df
| State | Number | Summary | Bill Type | Date | Status | Youth State Risk | Adult State Risk | Notes | URL | Sponsors | Calendar | History | Manual Status | Change Hash | Bill ID | Bill Analysis (AI Automated) | Bill PDF | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169 | Kansas | HB2404 | Enacting the Kansas protection of pensions and... | Anti-Boycotts Act | 4/30/2024 | House Died in Committee | Worst | Worst | Carried over from 2023 | https://legiscan.com/KS/bill/HB2404/2023 | Federal and State Affairs | NaN | H 2023-02-10 House Introduced, H 2023-02-10 Ho... | Failed | 5e2241cd3fac86ddc4d5cab54d9657c1 | 1703141.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | NaN |
| 334 | Missouri | SB980 | Creates new restrictions on certain business p... | Anti-Boycotts Act | 2/29/2024 | Hearing Conducted S Governmental Accountabilit... | Worst | High | NaN | https://legiscan.com/MO/bill/SB980/2024 | Rusty Black | Hearing 2024-02-29 08:30 Senate Lounge | S 2023-12-01 Prefiled, S 2024-01-03 S First Re... | Failed | 0f15387a63f8c049d3de6b0dada2ae41 | 1790744.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=1suZ_biqfQ6Hu... |
| 187 | Kansas | SB512 | Prohibiting insurance companies from using env... | Anti-Boycotts Act | 4/30/2024 | Senate Died in Committee | Worst | Worst | NaN | https://legiscan.com/KS/bill/SB512/2023 | Federal and State Affairs | NaN | S 2024-02-14 Senate Introduced, S 2024-02-15 S... | Failed | c719603f4a9136b8815cc3c71d493cc5 | 1846647.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | https://drive.google.com/open?id=1yhIYBEwCj3_S... |
| 283 | Missouri | HB1699 | Prohibits state contracts with companies that ... | Anti-Boycotts Act | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1699/2024 | Justin Sparks | NaN | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | f474b83c7433bd68f3862b20171b6a97 | 1790473.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=135tBGfzMzcq3... |
| 171 | Kansas | HB2436 | Senate Substitute for HB 2436 by Committee on ... | Anti-Boycotts Act | 4/29/2024 | Senate Motion to override veto prevailed; Yea:... | Worst | Worst | Bill enacted but marked here as failed because... | https://legiscan.com/KS/bill/HB2436/2023 | Federal and State Affairs | Hearing 2023-03-08 09:00 Room 582-N | H 2023-02-22 House Introduced, H 2023-02-22 Ho... | Failed | dd472b1bfc525eb4c1484bfed4fc4497 | 1717961.0 | https://kslegislature.org/li/b2023_24/measures... | NaN | https://drive.google.com/open?id=1kgyUJsERDroy... |
| ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... | ... |
| 266 | Mississippi | SB2722 | Safe Dormitories Act; enact. | Trans Segregation Bill | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/SB2722/2024 | Joseph Seymour | NaN | S 2024-02-19 Referred To Universities and Coll... | Failed | 107690b20ce8f8f5f9b07c74fada9975 | 1851792.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1bxUMhIyd2P6O... |
| 245 | Mississippi | HB1521 | "Safe Dormitories Act"; establish. | Trans Segregation Bill | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/HB1521/2024 | Gene Newman | NaN | H 2024-02-19 Referred To Universities and Coll... | Failed | 73ddd015ad2238296c05624c8490f033 | 1850955.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=17oJZVFFMJOYB... |
| 487 | Tennessee | HB2816 | AN ACT to amend Tennessee Code Annotated, Titl... | Trans Surveillance Bill | 3/13/2024 | Taken off notice for cal. in Health Committee | Worst | Worst | Crossfiled partner SB2396 failed | https://legiscan.com/TN/bill/HB2816/2023 | Jeremy Faison | Hearing 2024-03-05 13:30 House Hearing Room IV | H 2024-01-31 Filed for introduction, H 2024-02... | Failed | dbfdc6d7821e87f2e62255939dee3bf5 | 1833604.0 | https://www.capitol.tn.gov/Bills/113/Bill/HB28... | NaN | https://drive.google.com/open?id=1CPRK5XRTIqgP... |
| 503 | Tennessee | SB2396 | AN ACT to amend Tennessee Code Annotated, Titl... | Trans Surveillance Bill | 3/12/2024 | Failed in Senate Commerce and Labor Committee ... | Worst | Worst | NaN | https://legiscan.com/TN/bill/SB2396/2023 | Joseph Hensley | NaN | S 2024-01-30 Filed for introduction, S 2024-01... | Failed | 1b7375d72063fd771f056bf75cfea47e | 1832394.0 | https://www.capitol.tn.gov/Bills/113/Bill/SB23... | NaN | https://drive.google.com/open?id=1JmOu3xqOF24z... |
| 117 | Illinois | HB4355 | IDPH-PUBERTY BLOCKER REPORT | Trans Surveillance Bill | 1/16/2024 | Referred to Rules Committee | Safest | Safest | Non-identifying information on puberty blocker... | https://legiscan.com/IL/bill/HB4355/2023 | Tom Weber | NaN | H 2024-01-04 Filed with the Clerk by Rep. Tom ... | Failed | 10774a3248cdbe8f0a9bfdf1d76879f2 | 1798337.0 | https://www.ilga.gov/legislation/103/HB/10300H... | NaN | https://drive.google.com/open?id=1vYlOfmSqecJj... |
674 rows × 19 columns
# another way of saving the df is to set it to a new variable
sorted = df.sort_values(['Bill Type', 'State'])
sorted.head(50)
| State | Number | Summary | Bill Type | Date | Status | Youth State Risk | Adult State Risk | Notes | URL | Sponsors | Calendar | History | Manual Status | Change Hash | Bill ID | Bill Analysis (AI Automated) | Bill PDF | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 169 | Kansas | HB2404 | Enacting the Kansas protection of pensions and... | Anti-Boycotts Act | 4/30/2024 | House Died in Committee | Worst | Worst | Carried over from 2023 | https://legiscan.com/KS/bill/HB2404/2023 | Federal and State Affairs | NaN | H 2023-02-10 House Introduced, H 2023-02-10 Ho... | Failed | 5e2241cd3fac86ddc4d5cab54d9657c1 | 1703141.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | NaN |
| 187 | Kansas | SB512 | Prohibiting insurance companies from using env... | Anti-Boycotts Act | 4/30/2024 | Senate Died in Committee | Worst | Worst | NaN | https://legiscan.com/KS/bill/SB512/2023 | Federal and State Affairs | NaN | S 2024-02-14 Senate Introduced, S 2024-02-15 S... | Failed | c719603f4a9136b8815cc3c71d493cc5 | 1846647.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | https://drive.google.com/open?id=1yhIYBEwCj3_S... |
| 171 | Kansas | HB2436 | Senate Substitute for HB 2436 by Committee on ... | Anti-Boycotts Act | 4/29/2024 | Senate Motion to override veto prevailed; Yea:... | Worst | Worst | Bill enacted but marked here as failed because... | https://legiscan.com/KS/bill/HB2436/2023 | Federal and State Affairs | Hearing 2023-03-08 09:00 Room 582-N | H 2023-02-22 House Introduced, H 2023-02-22 Ho... | Failed | dd472b1bfc525eb4c1484bfed4fc4497 | 1717961.0 | https://kslegislature.org/li/b2023_24/measures... | NaN | https://drive.google.com/open?id=1kgyUJsERDroy... |
| 179 | Kansas | SB224 | Enacting the Kansas protection of pensions and... | Anti-Boycotts Act | 4/30/2024 | Senate Died in Committee | Worst | Worst | Carried over from 2023 | https://legiscan.com/KS/bill/SB224/2023 | Federal and State Affairs | Hearing 2023-03-07 10:30 Room 144-S | S 2023-02-09 Senate Introduced, S 2023-02-10 S... | Failed | 650b001436c6a44804db1e4f8a2d2b0e | 1702612.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | NaN |
| 334 | Missouri | SB980 | Creates new restrictions on certain business p... | Anti-Boycotts Act | 2/29/2024 | Hearing Conducted S Governmental Accountabilit... | Worst | High | NaN | https://legiscan.com/MO/bill/SB980/2024 | Rusty Black | Hearing 2024-02-29 08:30 Senate Lounge | S 2023-12-01 Prefiled, S 2024-01-03 S First Re... | Failed | 0f15387a63f8c049d3de6b0dada2ae41 | 1790744.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=1suZ_biqfQ6Hu... |
| 283 | Missouri | HB1699 | Prohibits state contracts with companies that ... | Anti-Boycotts Act | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1699/2024 | Justin Sparks | NaN | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | f474b83c7433bd68f3862b20171b6a97 | 1790473.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=135tBGfzMzcq3... |
| 311 | Missouri | SB1061 | Creates new provisions relating to public cont... | Anti-Boycotts Act | 1/25/2024 | Second Read and Referred S Governmental Accoun... | Worst | High | NaN | https://legiscan.com/MO/bill/SB1061/2024 | Mary Coleman | NaN | S 2023-12-01 Prefiled, S 2024-01-03 S First Re... | Failed | d7792245d1830ef0d5b21f2aa563da00 | 1789959.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=16r5Qj3rbPCta... |
| 342 | Nebraska | LB743 | Adopt the Investment Neutrality in Public Fund... | Anti-Boycotts Act | 4/18/2024 | Indefinitely postponed | Worst | High | NaN | https://legiscan.com/NE/bill/LB743/2023 | Kathleen Kauth | Hearing 2023-02-13 13:30 Room 1507 | L 2023-01-18 Date of introduction, L 2023-01-2... | Failed | 4e56bf40768150d58550af72eedc681d | 1665462.0 | https://nebraskalegislature.gov/FloorDocs/108/... | NaN | https://drive.google.com/open?id=1j0HD6L4E7NbN... |
| 59 | Florida | S1780 | Defamation, False Light, and Unauthorized Publ... | Anti-Journalism | 3/8/2024 | Died in Fiscal Policy | DO NOT TRAVEL | DO NOT TRAVEL | NaN | https://legiscan.com/FL/bill/S1780/2024 | Judiciary, Jason Brodeur | Hearing 2024-02-05 14:30 110 Senate Building | S 2024-01-05 Filed, S 2024-01-11 Referred to J... | Failed | 4ae7b34729047180e677d79511b611c9 | 1799256.0 | https://www.flsenate.gov/Session/Bill/2024/178... | NaN | https://drive.google.com/open?id=1FWY9GPoPeofH... |
| 56 | Florida | S1708 | Public Safety Programs | Anti-LGBTQ+ Law Enforcement Bill | 3/8/2024 | Died in Judiciary | DO NOT TRAVEL | DO NOT TRAVEL | NaN | https://legiscan.com/FL/bill/S1708/2024 | Clay Yarborough | NaN | S 2024-01-05 Filed, S 2024-01-11 Referred to J... | Failed | 96ba33f8aec775878cecd143212a001d | 1799156.0 | https://www.flsenate.gov/Session/Bill/2024/170... | NaN | https://drive.google.com/open?id=1GQP88QsVOrLb... |
| 515 | US | HB4366 | United States Parole Commission Additional Ext... | Appropriations | 3/9/2024 | Became Public Law No: 118-42. | High | High | Bill enacted but marked here as "failed" becau... | https://legiscan.com/US/bill/HB4366/2023 | John Carter | Hearing 2023-07-25 15:00 H-313, CAPITOL | H 2023-06-27 Introduced in House, H 2023-06-27... | Failed | 1f19e1397f6db93973b2fca336c5160f | 1773292.0 | https://www.congress.gov/118/bills/hr4366/BILL... | NaN | https://drive.google.com/open?id=1wgoV4lLu0Fi6... |
| 537 | US | HB9026 | Making appropriations for the Departments of C... | Appropriations / DEI Ban / End Legal Recogniti... | 7/11/2024 | Placed on the Union Calendar, Calendar No. 482. | High | High | Can't block funding because recipient defines ... | https://legiscan.com/US/bill/HB9026/2023 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 516 | US | HB4664 | Financial Services and General Government Appr... | Appropriations / Gender Affirming Care Ban | 11/9/2023 | POSTPONED PROCEEDINGS - Pursuant to clause 1(c... | High | High | NaN | https://legiscan.com/US/bill/HB4664/2023 | Steve Womack | Hearing 2023-11-06 16:00 H-313, CAPITOL | H 2023-07-17 Introduced in House, H 2023-07-17... | Failed | b1d52bc64f64ccab933438793bbab5c0 | 1774612.0 | https://www.congress.gov/118/bills/hr4664/BILL... | NaN | https://drive.google.com/open?id=1_queqRScgHlg... |
| 533 | US | HB8752 | Making appropriations for the Department of Ho... | Appropriations / Gender Affirming Care Ban | 6/28/2024 | The Clerk was authorized to correct section nu... | High | High | DHS omnibus budget with a funding ban on GAC f... | https://legiscan.com/US/bill/HB8752/2023 | NaN | NaN | NaN | Pass One Chamber | NaN | NaN | NaN | NaN | NaN |
| 551 | US | SB4638 | A bill to authorize appropriations for fiscal ... | Appropriations / Gender Affirming Care Ban | 7/8/2024 | Placed on Senate Legislative Calendar under Ge... | High | High | Defense Appropriations bill that includes a ba... | https://legiscan.com/US/bill/SB4638/2023 | NaN | NaN | NaN | Pass Committee | NaN | NaN | NaN | NaN | NaN |
| 518 | US | HB5893 | Commerce, Justice, Science, and Related Agenci... | Appropriations / Gender Affirming Care Ban / D... | 11/14/2023 | Rules Committee Resolution H. Res. 869 Reporte... | High | High | GAC funding ban; Can't block funding because r... | https://legiscan.com/US/bill/HB5893/2023 | Harold Rogers | Hearing 2023-11-14 14:00 H-313, CAPITOL, Heari... | H 2023-10-06 Introduced in House, H 2023-10-25... | Failed | d2825a33d29149f36024ce218c9ee438 | 1779856.0 | https://www.congress.gov/118/bills/hr5893/BILL... | NaN | https://drive.google.com/open?id=11JpS6cWGE5-K... |
| 535 | US | HB8774 | Making appropriations for the Department of De... | Appropriations / Gender Affirming Care Ban / D... | 9/12/2024 | Read twice. Placed on Senate Legislative Calen... | High | High | DoD appropriations omnibus bill which includes... | https://legiscan.com/US/bill/HB8774/2023 | NaN | NaN | NaN | Pass One Chamber | NaN | NaN | NaN | NaN | NaN |
| 514 | US | HB4365 | Department of Defense Appropriations Act, 2024 | Appropriations / Gender Affirming Care Ban / D... | 10/16/2023 | Received in the Senate. Read twice. Placed on ... | High | High | Includes ban on paying for military dependent ... | https://legiscan.com/US/bill/HB4365/2023 | NaN | Hearing 2023-09-12 16:00 H-313, CAPITOL, Heari... | H 2023-06-27 Introduced in House, H 2023-06-27... | Failed | c5438762110e18fd30ebb7413ee2a52d | 1773284.0 | https://www.congress.gov/118/bills/hr4365/BILL... | NaN | https://drive.google.com/open?id=1J3K_p3Q94fAo... |
| 531 | US | HB8070 | To authorize appropriations for fiscal year 20... | Appropriations / Gender Affirming Care Ban / D... | 7/8/2024 | Received in the Senate. | High | High | DoD appropriations omnibus bill which includes... | https://legiscan.com/US/bill/HB8070/2023 | NaN | NaN | NaN | Pass One Chamber | NaN | NaN | NaN | NaN | NaN |
| 536 | US | HB8998 | Making appropriations for the Department of th... | Appropriations / Gender Affirming Care Ban / D... | 9/12/2024 | Read twice. Placed on Senate Legislative Calen... | High | High | DoInterior appropriations which includes prohi... | https://legiscan.com/US/bill/HB8998/2023 | NaN | NaN | NaN | Pass One Chamber | NaN | NaN | NaN | NaN | NaN |
| 534 | US | HB8771 | Making appropriations for the Department of St... | Appropriations / Gender Affirming Care Ban / D... | 9/12/2024 | Read twice. Placed on Senate Legislative Calen... | High | High | Various amendments include restrictions on usi... | https://legiscan.com/US/bill/HB8771/2023 | NaN | NaN | NaN | Pass One Chamber | NaN | NaN | NaN | NaN | NaN |
| 517 | US | HB4665 | Department of State, Foreign Operations, and R... | Appropriations / Gender Affirming Care Ban / D... | 10/3/2023 | Received in the Senate. Read twice. Placed on ... | High | High | Include restrictions on using DOD funds to pay... | https://legiscan.com/US/bill/HB4665/2023 | Mario Diaz-Balart | Hearing 2023-09-22 13:00 H-313, CAPITOL | H 2023-07-17 Introduced in House, H 2023-07-17... | Failed | e20fe3521a65e71ff462b15cbaf6c66a | 1774610.0 | https://www.congress.gov/118/bills/hr4665/BILL... | NaN | https://drive.google.com/open?id=1ppyZFdhv57Pl... |
| 519 | US | HB5894 | Department of Education Appropriations Act, 20... | Appropriations / Gender Affirming Care Ban / S... | 11/15/2023 | POSTPONED PROCEEDINGS - Pursuant to clause 1(c... | High | High | NaN | https://legiscan.com/US/bill/HB5894/2023 | Robert Aderholt | Hearing 2023-11-13 16:00 H-313, CAPITOL | H 2023-10-06 Introduced in House, H 2023-10-25... | Failed | dd4a5b74e1605912db9a81986ac2b2c8 | 1779845.0 | https://www.congress.gov/118/bills/hr5894/BILL... | NaN | https://drive.google.com/open?id=14ygn-SJxb1MF... |
| 538 | US | HB9029 | Making appropriations for the Departments of L... | Appropriations / Gender Affirming Care Ban / b... | 7/12/2024 | Placed on the Union Calendar, Calendar No. 485. | High | High | Appropriations bill for listed agencies, inclu... | https://legiscan.com/US/bill/HB9029/2023 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 513 | US | HB2670 | CONVENE Act of 2023 Sensible Classification Ac... | Appropriations / Pride Flag Ban | 12/22/2023 | Became Public Law No: 118-31. | High | High | Includes a ban on display of unapproved flags ... | https://legiscan.com/US/bill/HB2670/2023 | Mike D. Rogers, Adam Smith | Hearing 2023-05-11 12:00 2212 RHOB, Hearing 20... | H 2023-04-18 Introduced in House, H 2023-04-18... | Enacted | ccfa8fba0550b39bb71af841122e2132 | 1757049.0 | https://www.congress.gov/118/bills/hr2670/BILL... | NaN | https://drive.google.com/open?id=1N7TiQTZ0ssEu... |
| 532 | US | HB8580 | Making appropriations for military constructio... | Appropriations / Pride Flag Ban / Gender Affir... | 9/12/2024 | Placed on Senate Legislative Calendar under Ge... | High | High | Contains riders which ban funding GAC for vete... | https://legiscan.com/US/bill/HB8580/2023 | NaN | NaN | NaN | Pass One Chamber | NaN | NaN | NaN | NaN | NaN |
| 216 | Louisiana | SB5 | Requires fiduciaries for public retirement sys... | Ban On Public Investment in ESG Funds | 3/11/2024 | Introduced in the Senate; read by title. Rules... | Worst | Worst | Failed at sine die on 6/3/2024 | https://legiscan.com/LA/bill/SB5/2024 | Blake Miguez | Hearing 2024-02-20 09:00 Room A-B, Hearing 202... | S 2024-01-25 Prefiled and under the rules prov... | Failed | e4542a6d1307f4b7173627e579888d57 | 1828830.0 | https://www.legis.la.gov/Legis/ViewDocument.as... | NaN | https://drive.google.com/open?id=1ZuiJFUqVN8_p... |
| 11 | Alaska | HB174 | An Act restricting fiduciary actions by a fidu... | Ban on Public Investment in ESG Funds | 2/26/2024 | COSPONSOR(S): MCKAY | Moderate | Moderate | state money can't invest in pro or anti- gende... | https://legiscan.com/AK/bill/HB174/2023 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 182 | Kansas | SB291 | House Substitute for SB 291 by Committee on Le... | Ban on Public Investment in ESG Funds | 4/30/2024 | Senate Approved by Governor on Thursday, May 9... | Worst | Worst | Bill enacted but was a complete replacement an... | https://legiscan.com/KS/bill/SB291/2023 | Legislative Modernization | NaN | S 2023-03-06 Senate Introduced, S 2023-03-06 S... | Failed | f0fa58aaea1fd7f7813660a8e0ba5991 | 1727992.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | https://drive.google.com/open?id=1Eibp5MeBWJos... |
| 284 | Missouri | HB1700 | Modifies provisions relating to the fiduciary ... | Ban on Public Investment in ESG Funds | 2/13/2024 | Public Hearing Completed (H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1700/2024 | Justin Sparks | Hearing 2024-02-13 08:30 House Hearing Room 5 | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | caab633cfa6e26e37507fe6e9929b5de | 1790700.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=14Psnh7ZCIZwz... |
| 363 | New Hampshire | SB520 | Relative to the fiduciary duty and proxy votin... | Ban on Public Investment in ESG Funds | 2/21/2024 | Inexpedient to Legislate, Motion Adopted, Voic... | High | High | NaN | https://legiscan.com/NH/bill/SB520/2024 | William Gannon, Keith Murphy, Kevin Avard, Sha... | Hearing 2024-01-31 09:00 Room 103, State House | S 2023-12-14 To Be Introduced 01/03/2024 and R... | Failed | c3a23a2e6f3632b9ffef0277c603b55b | 1793633.0 | https://gencourt.state.nh.us/bill_status/legac... | NaN | https://drive.google.com/open?id=1srYqJURkShfQ... |
| 619 | West Virginia | HB5615 | Prohibiting contracts with companies that use ... | Ban on Public Investment in ESG Funds | 2/12/2024 | To House Government Organization | High | High | Specifies GAC for minors | https://legiscan.com/WV/bill/HB5615/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 620 | West Virginia | HB5616 | Prohibiting contracts, affiliations or employm... | Ban on Public Investment in ESG Funds | 2/12/2024 | To House Government Organization | High | High | Specifies GAC for minors | https://legiscan.com/WV/bill/HB5616/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 397 | Oklahoma | HB3022 | Prisons and reformatories; changing rooms and ... | Bathroom Ban/Prison Placement Ban | 3/19/2024 | Second Reading referred to Public Safety | Worst | Worst | Passed one chamber but failed at sine die 5/30... | https://legiscan.com/OK/bill/HB3022/2024 | Justin Humphrey, Jessica Garvin, Kevin McDugle | Hearing 2024-02-07 10:30 Room 206, Hearing 202... | H 2024-02-05 First Reading, H 2024-02-05 Autho... | Failed | f673597040056d6a64a53629e88d6301 | 1814073.0 | http://webserver1.lsb.state.ok.us/cf_pdf/2023-... | NaN | https://drive.google.com/open?id=1AWRV2h-TI_z8... |
| 85 | Hawaii | HB291 | Relating To Certificates Of Birth. | Birth Certificate Change Ban | 12/11/2023 | Carried over to 2024 Regular Session. | Safest | Safest | No birth certificate changes for trans minors;... | https://legiscan.com/HI/bill/HB291/2024 | David Alcos | NaN | H 2023-01-19 Pending introduction., H 2023-01-... | Failed | b1e2678da1e874ee408f0a2d0d9c2a64 | 1816592.0 | https://www.capitol.hawaii.gov/sessions/sessio... | NaN | NaN |
| 269 | Mississippi | SB2813 | Birth certificate; require designation of sex ... | Birth Certificate Change Ban | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/SB2813/2024 | Angela Burks Hill | NaN | S 2024-02-19 Referred To Judiciary, Division A... | Failed | b697de78c3509b559c28a077995234ce | 1852282.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1NTKthD2akhuN... |
| 408 | Oklahoma | SB1196 | Officers; dual office holding; adding exemptio... | Birth Certificate Change Ban | 3/12/2024 | Vetoed 03/12/2024 | Worst | Worst | Until amended on day of veto, it banned any de... | https://legiscan.com/OK/bill/SB1196/2024 | NaN | NaN | NaN | Vetoed | NaN | NaN | NaN | NaN | NaN |
| 593 | West Virginia | HB4233 | The purpose of this bill is to require birth c... | Birth Certificate Change Ban | 4/22/2024 | Chapter 217, Acts, Regular Session, 2024 | High | High | "non-binary" may not be used to designate sex ... | https://legiscan.com/WV/bill/HB4233/2024 | NaN | NaN | NaN | Enacted | NaN | NaN | NaN | NaN | NaN |
| 6 | Alabama | HB425 | Provision of sexual content to minor, prohibit... | Book Ban | 4/4/2024 | Pending House Judiciary | Worst | Worst | defines "gender ideology" as sexual content an... | https://legiscan.com/AL/bill/HB425/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 1 | Alabama | HB4 | Crimes and offenses, further provides for obsc... | Book Ban | 7/8/2024 | Pending House Judiciary | Worst | Worst | Prefiled for 2025 session; re: K12 & public li... | https://legiscan.com/AL/bill/HB4/2025 | NaN | NaN | NaN | Roll Over | NaN | NaN | NaN | NaN | NaN |
| 34 | California | SB1435 | An act to add Section 18112 to the Education C... | Book Ban | 4/24/2024 | April 24 set for first hearing. Failed passage... | Safest | Safest | For K8 material; amended to replace word "obsc... | https://legiscan.com/CA/bill/SB1435/2023 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 75 | Georgia | SB394 | "Restricting Explicit and Adult-designated Edu... | Book Ban | 2/26/2024 | Senate Read Second Time | Worst | Moderate | NaN | https://legiscan.com/GA/bill/SB394/2023 | Clint Dixon, Jason Anavitarte, Randy Robertson... | Hearing 2024-02-21 17:00 450 CAP | S 2024-01-24 Senate Hopper, S 2024-01-25 Senat... | Failed | 93f73e61cc4c1a82015c58e75f5199d3 | 1827773.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=18n84nK3QoGm8... |
| 72 | Georgia | SB154 | Sale or Distribution of Harmful Materials to M... | Book Ban | 2/26/2024 | Senate Read Second Time | Worst | Moderate | "school" exemption from laws regulating distri... | https://legiscan.com/GA/bill/SB154/2023 | Greg Dolezal, Colton Moore, Clint Dixon, Chuck... | Hearing 2024-02-20 14:30 307 CLOB, Hearing 202... | S 2023-02-13 Senate Hopper, S 2023-02-14 Senat... | Failed | e3431d829f5667d059179b0220a10f97 | 1706063.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=1sLDjia5MY0C8... |
| 91 | Idaho | H0384 | Amends and adds to existing law to prohibit ce... | Book Ban | 1/18/2024 | U.C. to be returned to State Affairs Committee | Worst | Worst | NaN | https://legiscan.com/ID/bill/H0384/2024 | State Affairs Committee | Hearing 2024-01-15 09:00 Room EW40 | H 2024-01-10 Introduced, read first time, refe... | Failed | 9c724c4466a7784e0aca9f2f84dbdbfd | 1808590.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1Gx3e7IpynIEY... |
| 111 | Idaho | S1289 | Adds to existing law to establish standards fo... | Book Ban | 2/22/2024 | Filed in Office of the Secretary of Senate | Worst | Worst | NaN | https://legiscan.com/ID/bill/S1289/2024 | State Affairs Committee | Hearing 2024-02-12 08:00 Room WW55 | S 2024-02-07 Introduced; read first time; refe... | Failed | 34fbf239786a460b1b2bebbc63fb14a0 | 1839802.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1xIj_EbAQpbvm... |
| 104 | Idaho | H0710 | Amends and adds to existing law to prohibit ce... | Book Ban | 4/10/2024 | Reported Signed by Governor on April 10, 2024 ... | Worst | Worst | NaN | https://legiscan.com/ID/bill/H0710/2024 | State Affairs Committee | Hearing 2024-03-13 10:00 , Hearing 2024-03-20 ... | H 2024-03-11 Introduced, read first time, refe... | Enacted | 374862b1132e4d12811584aeb07c8b33 | 1862873.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1r_fHa0Ny8ZI7... |
| 107 | Idaho | S1221 | Amends and adds to existing law to establish p... | Book Ban | 1/15/2024 | Reported Printed; referred to State Affairs | Worst | Worst | NaN | https://legiscan.com/ID/bill/S1221/2024 | State Affairs Committee, Linda Hartgen, Josh W... | NaN | S 2024-01-12 Introduced; read first time; refe... | Failed | 7f1f5cb61693c77b32035a4db25ed4fc | 1812843.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=12XxFQunkWIb8... |
| 125 | Indiana | HB1221 | Material that is obscene or harmful to minors. | Book Ban | 1/11/2024 | Representative McGuire J added as coauthor | Worst | High | NaN | https://legiscan.com/IN/bill/HB1221/2024 | David Abbott, Martin Carbaugh, Julie McGuire | NaN | H 2024-01-09 Coauthored by Representative Carb... | Failed | b9698d77d216916d44a43bb5af6aee79 | 1800332.0 | https://iga.in.gov/pdf-documents/123/2024/hous... | NaN | https://drive.google.com/open?id=1aDeP-EKutDuG... |
| 136 | Iowa | HF2040 | A bill for an act relating to obscenity exempt... | Book Ban | 1/16/2024 | Introduced, referred to Education. H.J. 90. | Worst | High | Failed crossover deadline of 3/14/24 | https://legiscan.com/IA/bill/HF2040/2023 | Jeff Shipley | NaN | H 2024-01-16 Introduced, referred to Education... | Failed | 539e43335ed5e2ae123f0f32d1c90561 | 1813683.0 | https://www.legis.iowa.gov/docs/publications/L... | NaN | https://drive.google.com/open?id=1zK7rSc6d8DiY... |
| 188 | Kansas | SB531 | Creating a civil cause of action against schoo... | Book Ban | 4/30/2024 | Senate Died in Committee | Worst | Worst | NaN | https://legiscan.com/KS/bill/SB531/2023 | Federal and State Affairs | NaN | S 2024-02-22 Senate Introduced, S 2024-02-23 S... | Failed | a7a21289b7fa943da7a6b508702d3866 | 1853456.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | https://drive.google.com/open?id=1rOtzWgGoihiZ... |
risk = df.sort_values(['Youth State Risk', 'Bill Type'])
risk.tail(50)
| State | Number | Summary | Bill Type | Date | Status | Youth State Risk | Adult State Risk | Notes | URL | Sponsors | Calendar | History | Manual Status | Change Hash | Bill ID | Bill Analysis (AI Automated) | Bill PDF | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 98 | Idaho | H0560 | Adds to existing law to provide for equality i... | Social Credit Score | 2/14/2024 | Reported Printed and Referred to State Affairs | Worst | Worst | NaN | https://legiscan.com/ID/bill/H0560/2024 | State Affairs Committee | NaN | H 2024-02-13 Introduced, read first time, refe... | Failed | 26fbe327fc87aa0c567ae9a0a47862dc | 1845843.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1elg55a5RJV0C... |
| 486 | Tennessee | HB2669 | AN ACT to amend Tennessee Code Annotated, Titl... | Social Credit Score | 2/7/2024 | Assigned to s/c Banking & Consumer Affairs Sub... | Worst | Worst | NaN | https://legiscan.com/TN/bill/HB2669/2023 | David Hawk | NaN | H 2024-01-31 Filed for introduction, H 2024-02... | Failed | d4b37fd4290e9d7f29d0b3bc6a2fb700 | 1832914.0 | https://www.capitol.tn.gov/Bills/113/Bill/HB26... | NaN | https://drive.google.com/open?id=1EJRuPjgJumTK... |
| 504 | Tennessee | SB2560 | AN ACT to amend Tennessee Code Annotated, Titl... | Social Credit Score | 2/5/2024 | Passed on Second Consideration, refer to Senat... | Worst | Worst | NaN | https://legiscan.com/TN/bill/SB2560/2023 | Brent Taylor | NaN | S 2024-01-31 Filed for introduction, S 2024-02... | Failed | ef4617dbc7e5bc3d56e789a335e7c412 | 1833665.0 | https://www.capitol.tn.gov/Bills/113/Bill/SB25... | NaN | https://drive.google.com/open?id=1A1Kn4in85jyk... |
| 147 | Iowa | HF2409 | A bill for an act relating to discrimination i... | Social Credit Score | 2/8/2024 | Introduced, referred to Commerce. H.J. 227. | Worst | High | NaN | https://legiscan.com/IA/bill/HF2409/2023 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 309 | Missouri | HB2885 | Establishes the offense of contributing to soc... | Social Transition Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB2885/2024 | Jamie Gragg | NaN | H 2024-02-29 Introduced and Read First Time (H... | Failed | e176fc280e68c873595c676a2c3d616b | 1856891.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1VGmSqMTa7kAa... |
| 290 | Missouri | HB1981 | Modifies guidelines for student participation ... | Sports Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1981/2024 | Jamie Burger | NaN | H 2023-12-18 Prefiled (H), H 2024-01-03 Read F... | Failed | 326db0fe9b30b026eaacd5801b09c065 | 1795934.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1XidsR0KnriVR... |
| 322 | Missouri | SB1440 | Prohibits public and private elementary and se... | Sports Ban | 5/7/2024 | Hearing Conducted S Select Committee on Empowe... | Worst | High | NaN | https://legiscan.com/MO/bill/SB1440/2024 | Mary Coleman | NaN | S 2024-02-22 S First Read, S 2024-03-07 Second... | Failed | 51e4b38a9b6c25cae635c711b756d8d9 | 1852906.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=1PU5C5dPY80KQ... |
| 664 | Wyoming | HB0136 | Gender identity-definition repeal. | Sports Ban | 2/16/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/HB0136/2024 | Abby Angelos, John Bear, Scott Heiner, Ben Hor... | NaN | 2024-02-08 Bill Number Assigned, H 2024-02-09... | Failed | 2d2c05fc7bc1141ed209d90bc5088b16 | 1840891.0 | https://www.wyoleg.gov/2024/Introduced/HB0136.pdf | NaN | https://drive.google.com/open?id=1aIyr7NIzd5eL... |
| 317 | Missouri | SB1246 | Repeals the 2027 expiration of a provision of ... | Sports Ban | 1/25/2024 | Second Read and Referred S Emerging Issues Com... | Worst | High | NaN | https://legiscan.com/MO/bill/SB1246/2024 | Holly Thompson Rehder | NaN | S 2023-12-05 Prefiled, S 2024-01-03 S First Re... | Failed | 3f024f841f30d4f3cccd66ede76d6ff8 | 1790525.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=1TlTDFAdUfD0v... |
| 292 | Missouri | HB2145 | Removes an expiration date of provisions gover... | Sports Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB2145/2024 | Brian Seitz | NaN | H 2024-01-02 Prefiled (H), H 2024-01-03 Read F... | Failed | ab0fd31537a34cac2229b97884e51e70 | 1795682.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1Tm12HFaYYV0v... |
| 76 | Georgia | SB438 | Georgia Public Schools; to operate or facilita... | Sports Ban | 2/1/2024 | Senate Read and Referred | Worst | Moderate | NaN | https://legiscan.com/GA/bill/SB438/2023 | Carden Summers, John Kennedy, Steve Gooch, Jas... | NaN | S 2024-01-31 Senate Hopper, S 2024-02-01 Senat... | Failed | ebfcd1e439a75e6fddfe47070fbaef3f | 1834525.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=1rTQFhaTMf2ud... |
| 393 | Ohio | SCR11 | To urge Congress and the President of the Unit... | Sports Ban | 5/22/2024 | Referred to committee: Education | Worst | High | NaN | https://legiscan.com/OH/bill/SCR11/2023 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 390 | Ohio | HCR17 | To express the General Assembly's opposition t... | Sports Ban | 5/21/2024 | Introduced and Referred to Committee: Civil Ju... | Worst | High | NaN | https://legiscan.com/OH/bill/HCR17/2023 | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 558 | Utah | HB0172 | Student Athlete Participation Amendments | Sports Ban | 3/12/2024 | Governor Signed in Lieutenant Governor's offic... | Worst | Worst | NaN | https://legiscan.com/UT/bill/HB0172/2024 | Jordan Teuscher, Lincoln Fillmore | Hearing 2024-01-23 14:00 , Hearing 2024-02-09 ... | 2024-01-05 Bill Numbered but not Distributed ... | Enacted | 1e4f651cc82e968180ba3f90c0c5b9c1 | 1799398.0 | https://le.utah.gov/~2024/bills/hbillint/HB017... | NaN | https://drive.google.com/open?id=1hBkK62iI-Oy3... |
| 571 | Utah | SB0219 | School Activity Eligibility Commission Modific... | Sports Ban | 3/21/2024 | Governor Signed in Lieutenant Governor's offic... | Worst | Worst | NaN | https://legiscan.com/UT/bill/SB0219/2024 | Michael Kennedy, Kera Birkeland | Hearing 2024-02-12 16:00 , Hearing 2024-02-23 ... | 2024-02-08 Bill Numbered but not Distributed ... | Enacted | dc1ea736a19ed427c8941ea64f7e44bc | 1840924.0 | https://le.utah.gov/~2024/bills/sbillint/SB021... | NaN | https://drive.google.com/open?id=1PUwsO4EKrwsx... |
| 569 | Utah | HJR301 | Concurrent Resolution-directives to Government... | Sports Ban / Legal Discrimination in Education | 6/21/2024 | House/ to Lieutenant Governor in Lieutenant Go... | Worst | Worst | In extended session X3; in response to the Bid... | https://legiscan.com/UT/bill/HJR301/2024/X3 | NaN | NaN | NaN | Comp Enacted | NaN | NaN | NaN | NaN | NaN |
| 568 | Utah | HCR301 | Concurrent Resolution-directives to Government... | Sports Ban / Legal Discrimination in Education | 6/21/2024 | Governor Signed in Lieutenant Governor's offic... | Worst | Worst | In extended session X3; in response to the Bid... | https://legiscan.com/UT/bill/HCR301/2024/X3 | NaN | NaN | NaN | Enacted | NaN | NaN | NaN | NaN | NaN |
| 105 | Idaho | HCR020 | States findings of the Legislature and recogni... | Straight Pride Month Resolution | 2/9/2024 | Reported Printed and Referred to State Affairs | Worst | Worst | NaN | https://legiscan.com/ID/bill/HCR020/2024 | State Affairs Committee | NaN | H 2024-02-08 Introduced, read first time, refe... | Failed | 16044c8d0fa0d1a923e94dbbba36f393 | 1841124.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1wM1VFktxiAxV... |
| 106 | Idaho | HCR035 | States findings of the Legislature and recogni... | Straight Pride Month Resolution | 3/15/2024 | Introduced, read first time; referred to: Stat... | Worst | Worst | NaN | https://legiscan.com/ID/bill/HCR035/2024 | State Affairs Committee | NaN | H 2024-03-06 Introduced, read first time, refe... | Failed | 64f338a43e5452f8287f36f9013cc780 | 1860349.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1tTdjlDjb52p5... |
| 281 | Missouri | HB1674 | Establishes the "Employee Restroom and Locker ... | Trans Bathroom Ban | 1/24/2024 | Action Postponed (H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1674/2024 | Mark Matthiesen | Hearing 2024-01-17 14:00 House Hearing Room 6,... | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | d190708cef83f43f19c11d70225d82de | 1790243.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1PMgoJvXHpUI2... |
| 244 | Mississippi | HB1428 | "SAFER Act"; create to regulate public buildings. | Trans Bathroom Ban | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/HB1428/2024 | Celeste Hurst, Randal Rushing, Mark Tullos, An... | NaN | H 2024-02-19 Referred To Public Property;Judic... | Failed | e3fb8b466764d1790189eee080dcea74 | 1850544.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1ygoev9qQoyDK... |
| 461 | South Carolina | S1213 | South Carolina Student Physical Privacy Act | Trans Bathroom Ban | 3/27/2024 | Referred to Committee on Education | Worst | High | Yet another iteration of Alliance Defending Fr... | https://legiscan.com/SC/bill/S1213/2023 | Wes Climer, Joshua Kimbrell | NaN | S 2024-03-27 Introduced and read first time, S... | Failed | a4922974dda19646e214d08c077f8819 | 1868172.0 | https://www.scstatehouse.gov/sess125_2023-2024... | NaN | https://drive.google.com/open?id=1cxKAGWcji6GE... |
| 299 | Missouri | HB2355 | Requires all public school shower rooms, locke... | Trans Bathroom Ban | 1/31/2024 | HCS Reported Do Pass (H) - AYES: 10 NOES: 4 PR... | Worst | High | Yet another iteration of Alliance Defending Fr... | https://legiscan.com/MO/bill/HB2355/2024 | Ben Baker | Hearing 2024-01-17 14:00 House Hearing Room 6,... | H 2024-01-09 Introduced and Read First Time (H... | Failed | eb037b8114cee47788c5c76e7f93f9bd | 1801739.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1b592M9N1vNFd... |
| 460 | South Carolina | H5407 | Amend The South Carolina Code Of Laws By Enact... | Trans Bathroom Ban | 4/16/2024 | Referred to Committee on Judiciary | Worst | High | Yet another Student Physical Privacy Act; a ve... | https://legiscan.com/SC/bill/H5407/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 478 | Tennessee | HB1949 | AN ACT to amend Tennessee Code Annotated, Sect... | Trans Bathroom Ban | 4/3/2024 | Taken off notice for cal in s/c Criminal Justi... | Worst | Worst | Criminal on the basis of expectation and priva... | https://legiscan.com/TN/bill/HB1949/2023 | John Ragan | Hearing 2024-02-20 12:00 House Hearing Room II... | H 2024-01-23 Filed for introduction, H 2024-01... | Failed | 0c406147942d9d480a3653d10518160d | 1825523.0 | https://www.capitol.tn.gov/Bills/113/Bill/HB19... | NaN | https://drive.google.com/open?id=1tuu6ibVmsGuT... |
| 449 | South Carolina | H4538 | South Carolina Student Physical Privacy Act | Trans Bathroom Ban | 2/13/2024 | Member(s) request name added as sponsor: Mitch... | Worst | High | Yet another iteration of Alliance Defending Fr... | https://legiscan.com/SC/bill/H4538/2023 | April Cromer, Ashley Trantham, Melissa Oremus,... | NaN | H 2023-11-16 Prefiled, H 2023-11-16 Referred t... | Failed | cbd193e0ea992e9d9bd7faf21c3a9d4d | 1784420.0 | https://www.scstatehouse.gov/sess125_2023-2024... | NaN | https://drive.google.com/open?id=1-9-nJgGPPZE2... |
| 448 | South Carolina | H4535 | Safety in Private Spaces Act | Trans Bathroom Ban | 1/18/2024 | Member(s) request name added as sponsor: McCravy | Worst | High | Almost identical to the FL bill that passed -A... | https://legiscan.com/SC/bill/H4535/2023 | Thomas Beach, Ashley Trantham, Patrick Haddon,... | NaN | H 2023-11-16 Prefiled, H 2023-11-16 Referred t... | Failed | 0152f1a64a6372d21e6b8de6b0075613 | 1784341.0 | https://www.scstatehouse.gov/sess125_2023-2024... | NaN | https://drive.google.com/open?id=1d37jbkJC400C... |
| 508 | Tennessee | SB2781 | AN ACT to amend Tennessee Code Annotated, Sect... | Trans Bathroom Ban | 3/27/2024 | Deferred to Summer Study | Worst | Worst | NaN | https://legiscan.com/TN/bill/SB2781/2023 | Janince Bowling | Hearing 2024-03-11 13:00 Cordell Hull Building... | S 2024-01-31 Filed for introduction, S 2024-02... | Failed | ddee52716f72e9127ae8210d79639b4b | 1834061.0 | https://www.capitol.tn.gov/Bills/113/Bill/SB27... | NaN | https://drive.google.com/open?id=18VPc_sSAvJNa... |
| 297 | Missouri | HB2308 | Enacts provisions governing emerging issues in... | Trans Bathroom Ban | 1/24/2024 | Action Postponed (H) | Worst | High | School Bathroom Ban + rewriting anti-discrimin... | https://legiscan.com/MO/bill/HB2308/2024 | Adam Schnelting | Hearing 2024-01-17 14:00 House Hearing Room 6,... | H 2024-01-05 Introduced and Read First Time (H... | Failed | 796f2ec85c0e57fb16c05541ed223ed4 | 1798864.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1qzRT-Uis4qbc... |
| 154 | Iowa | SF2055 | A bill for an act prohibiting persons from ent... | Trans Bathroom Ban | 1/22/2024 | Subcommittee: Salmon, Celsi, and Westrich. S.J... | Worst | High | Adult public restroom ban -Allison | https://legiscan.com/IA/bill/SF2055/2023 | Sandy Salmon | NaN | S 2024-01-17 Introduced, referred to State Gov... | Failed | 507f174d7cdcdbf7b3913dfdc2414b2e | 1818469.0 | https://www.legis.iowa.gov/docs/publications/L... | NaN | https://drive.google.com/open?id=1qxFkRlsZJk6S... |
| 68 | Georgia | HB836 | Education; provide safety of students; require... | Trans Bathroom Ban | 1/8/2024 | House Second Readers | Worst | Moderate | GAC ban with 2 year civil liability for practi... | https://legiscan.com/GA/bill/HB836/2023 | Mitchell Scoggins, Joseph Gullett, Josh Bonner... | NaN | H 2023-03-27 House Hopper, H 2023-03-29 House ... | Failed | a8ccfa3d6cc76ecbf29bd23f993d9d30 | 1748443.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=186Jl_EeMhriC... |
| 391 | Ohio | SB104 | To amend sections 3302.03, 3314.03, 3326.11, 3... | Trans Bathroom Ban | 6/26/2024 | Informally passed | Worst | High | The Trans Bathroom Ban for K12 and Colleges fr... | https://legiscan.com/OH/bill/SB104/2023 | NaN | NaN | NaN | Pass Both Chambers | NaN | NaN | NaN | NaN | NaN |
| 560 | Utah | HB0253 | Use of Sex-designated Facilities in Public and... | Trans Bathroom Ban | 3/1/2024 | House/ filed in House file for bills not passed | Worst | Worst | NaN | https://legiscan.com/UT/bill/HB0253/2024 | Phil Lyman | NaN | 2024-01-11 Bill Numbered but not Distributed ... | Failed | 1cc89f101ddcb3c6e6f1bcc4cc3bf5b5 | 1811614.0 | https://le.utah.gov/~2024/bills/hbillint/HB025... | NaN | https://drive.google.com/open?id=1atU1cL8eia8Y... |
| 561 | Utah | HB0257 | Sex-based Designations for Privacy, Anti-bully... | Trans Bathroom Ban | 1/30/2024 | Governor Signed in Executive Branch - Lieutena... | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/UT/bill/HB0257/2024 | Kera Birkeland, Daniel McCay | Hearing 2024-01-17 14:00 , Hearing 2024-01-22 ... | 2024-01-11 Bill Numbered but not Distributed ... | Enacted | 1ffbd951f7160b7819dd3bbd92fb1c73 | 1811447.0 | https://le.utah.gov/~2024/bills/hbillint/HB025... | NaN | https://drive.google.com/open?id=19wmudem_l2vF... |
| 71 | Georgia | HB936 | Education; provide safety of students; require... | Trans Bathroom Ban | 1/23/2024 | House Second Readers | Worst | Moderate | Variation on ADF's Student Physical Privacy Act | https://legiscan.com/GA/bill/HB936/2023 | Josh Bonner, Mitchell Scoggins, Joseph Gullett... | NaN | H 2024-01-12 House Hopper, H 2024-01-22 House ... | Failed | 15db5e88c2d4a94a2f5c32f462e5e507 | 1813271.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=1qoLDZ47GC3Ir... |
| 300 | Missouri | HB2357 | Requires all public school shower rooms, locke... | Trans Bathroom Ban | 1/31/2024 | HCS Reported Do Pass (H) - AYES: 10 NOES: 4 PR... | Worst | High | Yet another iteration of Alliance Defending Fr... | https://legiscan.com/MO/bill/HB2357/2024 | Chris Lonsdale | Hearing 2024-01-17 14:00 House Hearing Room 6,... | H 2024-01-09 Introduced and Read First Time (H... | Failed | f94cb2cf2cb34911cb57595fef129344 | 1803495.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1B5zRhqsxVhmg... |
| 333 | Missouri | SB974 | Requires all public school shower rooms, locke... | Trans Bathroom Ban | 1/25/2024 | Second Read and Referred S Emerging Issues Com... | Worst | High | requires parental consent for trans student to... | https://legiscan.com/MO/bill/SB974/2024 | Travis Fitzwater | NaN | S 2023-12-01 Prefiled, S 2024-01-03 S First Re... | Failed | c602253c00676841074971274f2ddf6f | 1790594.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=17O36gEWAVdt-... |
| 383 | Ohio | HB183 | Regards single-sex bathroom access in schools,... | Trans Bathroom Ban | 4/10/2024 | Reported - Substitute: Higher Education | Worst | High | Yet another iteration of Alliance Defending Fr... | https://legiscan.com/OH/bill/HB183/2023 | Beth Lear, Adam Bird, Tim Barhorst, Thaddeus C... | Hearing 2023-10-04 13:00 Room 017, Hearing 202... | H 2023-05-23 Introduced, H 2023-06-07 Referred... | Pass Committee | a30ec7f1743358021a0cabb1ac2507e6 | 1767656.0 | https://search-prod.lis.state.oh.us/solarapi/v... | The provided text describes House Bill No. 183... | https://drive.google.com/open?id=16oeemN7QmBbl... |
| 320 | Missouri | SB1274 | Establishes provisions relating to physical pr... | Trans Bathroom Ban | 1/25/2024 | Second Read and Referred S Emerging Issues Com... | Worst | High | Yet another iteration of Alliance Defending Fr... | https://legiscan.com/MO/bill/SB1274/2024 | Nick Schroer | NaN | S 2023-12-15 Prefiled, S 2024-01-03 S First Re... | Failed | 3fd1940a63a5c6aaa3153e399582a04c | 1792501.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=1Zh_Qt7e2oqmA... |
| 459 | South Carolina | H5100 | Make Appropriations And To Provide Revenues To... | Trans Bathroom Ban / Appropriations | 6/27/2024 | Ratified R 252 | Worst | High | State Budget bill with an amendment (No. 48) w... | https://legiscan.com/SC/bill/H5100/2023 | NaN | NaN | NaN | Enacted | NaN | NaN | NaN | NaN | NaN |
| 271 | Mississippi | SC549 | A Concurrent Resolution Suspending The Deadlin... | Trans Bathroom Ban / End Legal Recognition | 5/3/2024 | Enrolled Bill Signed | Worst | Worst | Meta legislation to extend deadline for SB 275... | https://legiscan.com/MS/bill/SC549/2024 | NaN | NaN | NaN | Enacted | NaN | NaN | NaN | NaN | NaN |
| 256 | Mississippi | HC65 | A Concurrent Resolution Suspending The Deadlin... | Trans Bathroom Ban / End Legal Recognition | 5/14/2024 | Died In Committee | Worst | Worst | Meta re: SB 2753, which was enacted | https://legiscan.com/MS/bill/HC65/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 267 | Mississippi | SB2753 | SAFER Act; enact. | Trans Bathroom Ban / End Legal Recognition | 5/13/2024 | Approved by Governor | Worst | Worst | Securing Areas for Females Effectively and Res... | https://legiscan.com/MS/bill/SB2753/2024 | Josh Harkins, Jeremy England, Jason Barrett, A... | NaN | S 2024-02-19 Referred To Judiciary, Division A... | Enacted | 51cab74c4503fa3ed49a80b9af1e3b55 | 1852074.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1JWhQhsZIlneW... |
| 257 | Mississippi | HC66 | A Concurrent Resolution Suspending The Deadlin... | Trans Bathroom Ban / End Legal Recognition | 5/14/2024 | Died In Committee | Worst | Worst | Meta re: SB 2753, which was enacted | https://legiscan.com/MS/bill/HC66/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 340 | Nebraska | LB575 | Adopt the Sports and Spaces Act | Trans Bathroom Ban/ Sports Ban | 4/18/2024 | Indefinitely postponed | Worst | High | A K12 bathroom ban and also a K12 Trans Girls ... | https://legiscan.com/NE/bill/LB575/2023 | Kathleen Kauth | Hearing 2023-02-13 13:30 Room 1525 | L 2023-01-17 Date of introduction, L 2023-01-1... | Failed | 63cfcea9234e600bbab69f8b9983172e | 1662403.0 | https://nebraskalegislature.gov/FloorDocs/108/... | NaN | https://drive.google.com/open?id=1-n1TAtBP9B0O... |
| 252 | Mississippi | HB585 | "Dignity and Safety for Incarcerated Women Act... | Trans Bathroom Bill / Trans Segregation Bill /... | 4/2/2024 | Died In Committee | Worst | Worst | Bans in housing, bathrooms, changing rooms, an... | https://legiscan.com/MS/bill/HB585/2024 | Gene Newman, Carolyn Crawford | NaN | H 2024-01-24 Referred To Corrections, H 2024-0... | Failed | 00fee9d1536b5d26332edbf899888ed5 | 1827121.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1V_EYNU1SjuTM... |
| 266 | Mississippi | SB2722 | Safe Dormitories Act; enact. | Trans Segregation Bill | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/SB2722/2024 | Joseph Seymour | NaN | S 2024-02-19 Referred To Universities and Coll... | Failed | 107690b20ce8f8f5f9b07c74fada9975 | 1851792.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1bxUMhIyd2P6O... |
| 245 | Mississippi | HB1521 | "Safe Dormitories Act"; establish. | Trans Segregation Bill | 3/5/2024 | Died In Committee | Worst | Worst | Uses IWF and WoLF's "Women's Bill of Rights" L... | https://legiscan.com/MS/bill/HB1521/2024 | Gene Newman | NaN | H 2024-02-19 Referred To Universities and Coll... | Failed | 73ddd015ad2238296c05624c8490f033 | 1850955.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=17oJZVFFMJOYB... |
| 487 | Tennessee | HB2816 | AN ACT to amend Tennessee Code Annotated, Titl... | Trans Surveillance Bill | 3/13/2024 | Taken off notice for cal. in Health Committee | Worst | Worst | Crossfiled partner SB2396 failed | https://legiscan.com/TN/bill/HB2816/2023 | Jeremy Faison | Hearing 2024-03-05 13:30 House Hearing Room IV | H 2024-01-31 Filed for introduction, H 2024-02... | Failed | dbfdc6d7821e87f2e62255939dee3bf5 | 1833604.0 | https://www.capitol.tn.gov/Bills/113/Bill/HB28... | NaN | https://drive.google.com/open?id=1CPRK5XRTIqgP... |
| 503 | Tennessee | SB2396 | AN ACT to amend Tennessee Code Annotated, Titl... | Trans Surveillance Bill | 3/12/2024 | Failed in Senate Commerce and Labor Committee ... | Worst | Worst | NaN | https://legiscan.com/TN/bill/SB2396/2023 | Joseph Hensley | NaN | S 2024-01-30 Filed for introduction, S 2024-01... | Failed | 1b7375d72063fd771f056bf75cfea47e | 1832394.0 | https://www.capitol.tn.gov/Bills/113/Bill/SB23... | NaN | https://drive.google.com/open?id=1JmOu3xqOF24z... |
filtering by values: booleans and strings#
df['Bill Type'] == 'Book Ban'
169 False
334 False
187 False
283 False
171 False
...
266 False
245 False
487 False
503 False
117 False
Name: Bill Type, Length: 674, dtype: bool
books = df['Bill Type'] == 'Book Ban'
df[books]
| State | Number | Summary | Bill Type | Date | Status | Youth State Risk | Adult State Risk | Notes | URL | Sponsors | Calendar | History | Manual Status | Change Hash | Bill ID | Bill Analysis (AI Automated) | Bill PDF | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 189 | Kentucky | HB191 | AN ACT relating to materials, programs, or eve... | Book Ban | 2/29/2024 | to Education (H) | Worst | Moderate | NaN | https://legiscan.com/KY/bill/HB191/2024 | Josh Calloway, Shane Baker, Jennifer Henson De... | NaN | H 2024-01-08 introduced in House, H 2024-01-08... | Failed | 6c6dfd9eadca77770147a2e4cf45722f | 1800381.0 | https://apps.legislature.ky.gov/recorddocument... | NaN | https://drive.google.com/open?id=1cWp-RFkd6KQU... |
| 555 | Utah | HB0029 | Sensitive Material Review Amendments | Book Ban | 3/18/2024 | Governor Signed in Lieutenant Governor's offic... | Worst | Worst | NaN | https://legiscan.com/UT/bill/HB0029/2024 | Ken Ivory, Todd Weiler | Hearing 2024-01-23 14:00 , Hearing 2024-02-09 ... | 2023-12-19 Bill Numbered but not Distributed ... | Enacted | 0ad73fec40b8b8e960fbdadc26e3620b | 1793887.0 | https://le.utah.gov/~2024/bills/hbillint/HB002... | NaN | https://drive.google.com/open?id=1y7GGgkj4r_L0... |
| 188 | Kansas | SB531 | Creating a civil cause of action against schoo... | Book Ban | 4/30/2024 | Senate Died in Committee | Worst | Worst | NaN | https://legiscan.com/KS/bill/SB531/2023 | Federal and State Affairs | NaN | S 2024-02-22 Senate Introduced, S 2024-02-23 S... | Failed | a7a21289b7fa943da7a6b508702d3866 | 1853456.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | https://drive.google.com/open?id=1rOtzWgGoihiZ... |
| 136 | Iowa | HF2040 | A bill for an act relating to obscenity exempt... | Book Ban | 1/16/2024 | Introduced, referred to Education. H.J. 90. | Worst | High | Failed crossover deadline of 3/14/24 | https://legiscan.com/IA/bill/HF2040/2023 | Jeff Shipley | NaN | H 2024-01-16 Introduced, referred to Education... | Failed | 539e43335ed5e2ae123f0f32d1c90561 | 1813683.0 | https://www.legis.iowa.gov/docs/publications/L... | NaN | https://drive.google.com/open?id=1zK7rSc6d8DiY... |
| 501 | Tennessee | SB2173 | AN ACT to amend Tennessee Code Annotated, Titl... | Book Ban | 3/6/2024 | Deferred to Summer Study | Worst | Worst | NaN | https://legiscan.com/TN/bill/SB2173/2023 | Joseph Hensley | Hearing 2024-03-06 15:00 Cordell Hull Building | S 2024-01-30 Filed for introduction, S 2024-01... | Failed | 7b2c36c55abcdc998bc204dbdb458d1b | 1831445.0 | https://www.capitol.tn.gov/Bills/113/Bill/SB21... | NaN | https://drive.google.com/open?id=1bZCYBBoWyi1p... |
| 364 | New Hampshire | SB523 | Relative to the regulation of public school ma... | Book Ban | 4/11/2024 | Shall House Consider: Motion Failed DV 187-193... | High | High | NaN | https://legiscan.com/NH/bill/SB523/2024 | Kevin Avard, Carrie Gendreau, Leah Cushman, Ji... | Hearing 2024-01-30 09:15 Room 101, Legislative... | S 2023-12-14 To Be Introduced 01/03/2024 and R... | Failed | 450b86e72db62bec3c4bece103c669e4 | 1793245.0 | https://gencourt.state.nh.us/bill_status/legac... | NaN | https://drive.google.com/open?id=1c9PxcqyS3YD_... |
| 125 | Indiana | HB1221 | Material that is obscene or harmful to minors. | Book Ban | 1/11/2024 | Representative McGuire J added as coauthor | Worst | High | NaN | https://legiscan.com/IN/bill/HB1221/2024 | David Abbott, Martin Carbaugh, Julie McGuire | NaN | H 2024-01-09 Coauthored by Representative Carb... | Failed | b9698d77d216916d44a43bb5af6aee79 | 1800332.0 | https://iga.in.gov/pdf-documents/123/2024/hous... | NaN | https://drive.google.com/open?id=1aDeP-EKutDuG... |
| 75 | Georgia | SB394 | "Restricting Explicit and Adult-designated Edu... | Book Ban | 2/26/2024 | Senate Read Second Time | Worst | Moderate | NaN | https://legiscan.com/GA/bill/SB394/2023 | Clint Dixon, Jason Anavitarte, Randy Robertson... | Hearing 2024-02-21 17:00 450 CAP | S 2024-01-24 Senate Hopper, S 2024-01-25 Senat... | Failed | 93f73e61cc4c1a82015c58e75f5199d3 | 1827773.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=18n84nK3QoGm8... |
| 72 | Georgia | SB154 | Sale or Distribution of Harmful Materials to M... | Book Ban | 2/26/2024 | Senate Read Second Time | Worst | Moderate | "school" exemption from laws regulating distri... | https://legiscan.com/GA/bill/SB154/2023 | Greg Dolezal, Colton Moore, Clint Dixon, Chuck... | Hearing 2024-02-20 14:30 307 CLOB, Hearing 202... | S 2023-02-13 Senate Hopper, S 2023-02-14 Senat... | Failed | e3431d829f5667d059179b0220a10f97 | 1706063.0 | https://www.legis.ga.gov/api/legislation/docum... | NaN | https://drive.google.com/open?id=1sLDjia5MY0C8... |
| 6 | Alabama | HB425 | Provision of sexual content to minor, prohibit... | Book Ban | 4/4/2024 | Pending House Judiciary | Worst | Worst | defines "gender ideology" as sexual content an... | https://legiscan.com/AL/bill/HB425/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 498 | Tennessee | SB1858 | As introduced, gives a parent of a child who a... | Book Ban | 4/1/2024 | Rcvd. from S., held on H. desk. | Worst | Worst | Crossfiled with HB1632; passed one chamber; fa... | https://legiscan.com/TN/bill/SB1858/2023 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 278 | Missouri | HB1543 | Modifies the offense of providing explicit sex... | Book Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1543/2024 | Jeff Coleman | NaN | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | 1e317d6a8b3cca809011ced02a8456a9 | 1790340.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1Gy_TxSoD8uLQ... |
| 184 | Kansas | SB358 | Prohibiting school districts and local librari... | Book Ban | 4/30/2024 | Senate Died in Committee | Worst | Worst | NaN | https://legiscan.com/KS/bill/SB358/2023 | Federal and State Affairs | NaN | S 2024-01-18 Senate Introduced, S 2024-01-19 S... | Failed | db75808ebbfedb1fe3f6200443987431 | 1821213.0 | http://kslegislature.org/li/b2023_24/measures/... | NaN | https://drive.google.com/open?id=1n-AqclcCkIYb... |
| 353 | New Hampshire | HB1419 | Relative to prohibiting obscene or harmful sex... | Book Ban | 2/15/2024 | Indefinitely Postpone (Rep. Myler): Motion Ado... | High | High | NaN | https://legiscan.com/NH/bill/HB1419/2024 | Glenn Cordelli, JD Bernardy, Kristin Noble, Kr... | Hearing 2024-01-18 09:30 Legislative Office Bu... | H 2023-12-06 Introduced 01/03/2024 and referre... | Failed | 39db05526a7405d1c14f6476a0054f3c | 1792929.0 | https://gencourt.state.nh.us/bill_status/legac... | NaN | https://drive.google.com/open?id=1XBgdxPM0cmvm... |
| 350 | New Hampshire | HB1308 | Relative to parent access to children's librar... | Book Ban | 3/7/2024 | Inexpedient to Legislate: Motion Adopted Regul... | High | High | NaN | https://legiscan.com/NH/bill/HB1308/2024 | Arlene Quaratiello, Carroll Brown, Riche Colco... | Hearing 2024-01-30 11:00 Legislative Office Bu... | H 2023-12-06 Introduced 01/03/2024 and referre... | Failed | 2cca133ddd28de3394f784ed738c8c0e | 1793487.0 | https://gencourt.state.nh.us/bill_status/legac... | NaN | https://drive.google.com/open?id=1iEe8hrg3u2e3... |
| 669 | Wyoming | SF0031 | Sex offender registration-promoting obscenity. | Book Ban | 2/21/2024 | 3rd Reading:Failed 13-17-0-0-1 | Worst | Moderate | NaN | https://legiscan.com/WY/bill/SF0031/2024 | Judiciary | Hearing 2024-02-16 07:30 Capitol Extension Roo... | 2023-12-19 Bill Number Assigned, S 2024-01-24... | Failed | e9ac0ad30ab6480059e4548899baccf9 | 1793746.0 | https://www.wyoleg.gov/2024/Introduced/SF0031.pdf | NaN | https://drive.google.com/open?id=1nw7YD0dlOnKt... |
| 260 | Mississippi | SB2085 | Crime of distribution of obscene materials; de... | Book Ban | 3/5/2024 | Died In Committee | Worst | Worst | NaN | https://legiscan.com/MS/bill/SB2085/2024 | Angela Burks Hill | NaN | S 2024-01-19 Referred To Judiciary, Division B... | Failed | 98941eb3608f7f784e5cc514e23fab49 | 1822216.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1akpeCLwXwzQk... |
| 91 | Idaho | H0384 | Amends and adds to existing law to prohibit ce... | Book Ban | 1/18/2024 | U.C. to be returned to State Affairs Committee | Worst | Worst | NaN | https://legiscan.com/ID/bill/H0384/2024 | State Affairs Committee | Hearing 2024-01-15 09:00 Room EW40 | H 2024-01-10 Introduced, read first time, refe... | Failed | 9c724c4466a7784e0aca9f2f84dbdbfd | 1808590.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1Gx3e7IpynIEY... |
| 1 | Alabama | HB4 | Crimes and offenses, further provides for obsc... | Book Ban | 7/8/2024 | Pending House Judiciary | Worst | Worst | Prefiled for 2025 session; re: K12 & public li... | https://legiscan.com/AL/bill/HB4/2025 | NaN | NaN | NaN | Roll Over | NaN | NaN | NaN | NaN | NaN |
| 279 | Missouri | HB1574 | Prohibits the state librarian from disbursing ... | Book Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB1574/2024 | Mazzie Christensen | NaN | H 2023-12-01 Prefiled (H), H 2024-01-03 Read F... | Failed | 3552bb5654ebd6bc440d46a2d85174e2 | 1789905.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1JYJcK1_Jpnmw... |
| 663 | Wyoming | HB0088 | Public display of obscene material. | Book Ban | 2/16/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/HB0088/2024 | Robert Davis, Ben Hornok, Pepper Ottman, Sarah... | NaN | 2024-01-29 Bill Number Assigned, H 2024-02-01... | Failed | 14d54b4819db8bdbe46e6df7051ab638 | 1830955.0 | https://www.wyoleg.gov/2024/Introduced/HB0088.pdf | NaN | https://drive.google.com/open?id=1eMSSOlAY2xbO... |
| 661 | Wyoming | HB0068 | Obscenity-impartial conformance. | Book Ban | 2/16/2024 | Did not Consider for Introduction | Worst | Moderate | NaN | https://legiscan.com/WY/bill/HB0068/2024 | Abby Angelos, John Bear, Ben Hornok, Chip Neim... | NaN | 2024-01-22 Bill Number Assigned, H 2024-01-24... | Failed | 5a1b9d919c822231d449a47ad14c77b9 | 1823478.0 | https://www.wyoleg.gov/2024/Introduced/HB0068.pdf | NaN | https://drive.google.com/open?id=1dXozmc00Ct6V... |
| 339 | Nebraska | LB441 | Change provisions relating to obscenity | Book Ban | 4/18/2024 | Indefinitely postponed | Worst | High | NaN | https://legiscan.com/NE/bill/LB441/2023 | Joni Albrecht | Hearing 2023-03-24 13:30 Room 1113 | L 2023-01-13 Date of introduction, L 2023-01-1... | Failed | 7b8ef979d6cd9bd80403d60b7894d266 | 1658135.0 | https://nebraskalegislature.gov/FloorDocs/108/... | NaN | https://drive.google.com/open?id=1XjAdtMZMKUZM... |
| 253 | Mississippi | HB610 | Libraries; regulate the material that is curat... | Book Ban | 3/5/2024 | Died In Committee | Worst | Worst | NaN | https://legiscan.com/MS/bill/HB610/2024 | Jill Ford | NaN | H 2024-01-24 Referred To Judiciary B, H 2024-0... | Failed | ba659b36cc8f1e32a47dbc70ecf1ba71 | 1827135.0 | https://billstatus.ls.state.ms.us/documents/20... | NaN | https://drive.google.com/open?id=1iVXooqVDVWfU... |
| 453 | South Carolina | H4654 | Public school libraries | Book Ban | 1/9/2024 | Referred to Committee on Education and Public ... | Worst | High | NaN | https://legiscan.com/SC/bill/H4654/2023 | April Cromer, Roger Nutt | NaN | H 2023-12-14 Prefiled, H 2023-12-14 Referred t... | Failed | f7b3dc7a9e08bc89f901a7ad044bf6c8 | 1792124.0 | https://www.scstatehouse.gov/sess125_2023-2024... | NaN | https://drive.google.com/open?id=1gu6W4lMFwzpY... |
| 224 | Maryland | SB355 | Criminal Law - Display of Obscene Material to ... | Book Ban | 1/30/2024 | Hearing 2/02 at 10:30 a.m. | Safest | Safest | NaN | https://legiscan.com/MD/bill/SB355/2024 | Johnny Salling | Hearing 2024-02-02 10:30 | S 2024-01-16 First Reading Judicial Proceeding... | Failed | a1b31fccc9bd1059f4bb100cd1dea59c | 1813615.0 | https://mgaleg.maryland.gov/2024RS/bills/sb/sb... | NaN | https://drive.google.com/open?id=1ki1wuxTLwu_W... |
| 457 | South Carolina | H4701 | READER Act | Book Ban | 1/9/2024 | Referred to Committee on Education and Public ... | Worst | High | NaN | https://legiscan.com/SC/bill/H4701/2023 | Micajah Caskey, Brandon Guffey, Thomas Pope, R... | NaN | H 2023-12-14 Prefiled, H 2023-12-14 Referred t... | Failed | 200adb7a91ae713b25a22bc2b80750e4 | 1792138.0 | https://www.scstatehouse.gov/sess125_2023-2024... | NaN | https://drive.google.com/open?id=1n_umUt45vYRC... |
| 302 | Missouri | HB2374 | Requires schools to adopt school policies gove... | Book Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB2374/2024 | Mazzie Christensen | NaN | H 2024-01-10 Introduced and Read First Time (H... | Failed | 8368255e43c9449bdf7a22bc29c35a9b | 1808316.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=1cbBrLWW-dd5Q... |
| 636 | West Virginia | SB741 | Prohibiting creation, production, distribution... | Book Ban | 3/8/2024 | On 3rd reading with right to amend, Special Ca... | High | High | NaN | https://legiscan.com/WV/bill/SB741/2024 | Amy Nichole Grady, Ryan Weld, Charles Trump, L... | Hearing 2024-02-14 15:00 Senate Judiciary Comm... | S 2024-02-09 Filed for introduction, S 2024-02... | Failed | bfcbef7c9a4088241d892d0e1ce91d08 | 1842521.0 | http://www.wvlegislature.gov/Bill_Status/bills... | NaN | https://drive.google.com/open?id=1h1bl6qVPzauL... |
| 303 | Missouri | HB2408 | Prohibits the state librarian from disbursing ... | Book Ban | 5/17/2024 | Referred: General Laws(H) | Worst | High | NaN | https://legiscan.com/MO/bill/HB2408/2024 | Jamie Gragg | NaN | H 2024-01-16 Introduced and Read First Time (H... | Failed | bff4ebaebbd553bec70f58db204d0dc4 | 1813740.0 | https://documents.house.mo.gov/billtracking/bi... | NaN | https://drive.google.com/open?id=10sC75bfkSG59... |
| 220 | Maryland | HB671 | Criminal Law - Display of Obscene Material to ... | Book Ban | 1/31/2024 | Hearing 2/14 at 1:00 p.m. | Safest | Safest | NaN | https://legiscan.com/MD/bill/HB671/2024 | Robin Grammer, Lauren Arikan, Brian Chisholm, ... | Hearing 2024-02-14 13:00 | H 2024-01-25 First Reading Ways and Means, H 2... | Failed | 8947eac1afb97c8796443b187d631c7a | 1827883.0 | https://mgaleg.maryland.gov/2024RS/bills/hb/hb... | NaN | https://drive.google.com/open?id=1ifjLDX7Qhi6_... |
| 218 | Maryland | HB25 | Public Schools - Sexually Explicit Materials -... | Book Ban | 2/19/2024 | Unfavorable Report by Ways and Means | Safest | Safest | NaN | https://legiscan.com/MD/bill/HB25/2024 | Nino Mangione | Hearing 2024-01-31 13:00 | H 2023-08-28 Pre-filed, H 2024-01-10 First Rea... | Failed | 8390af30a0a627a696fa634e59d835b5 | 1798393.0 | https://mgaleg.maryland.gov/2024RS/bills/hb/hb... | NaN | https://drive.google.com/open?id=1A9OkZ4ibVOET... |
| 462 | South Dakota | HB1113 | Prohibit the use of state resources for the pr... | Book Ban | 1/24/2024 | State Affairs Deferred to the 41st legislative... | Worst | Moderate | NaN | https://legiscan.com/SD/bill/HB1113/2024 | Carl Perry, Aaron Aylward, Rocky Blare, Julie ... | Hearing 2024-01-24 00:00 | H 2024-01-18 First read in House and referred ... | Failed | 9caaa47c9c7d11dc35cb803a31de7f89 | 1819718.0 | https://mylrc.sdlegislature.gov/api/Documents/... | NaN | https://drive.google.com/open?id=1KWrzfHuhZ3t3... |
| 214 | Louisiana | HB545 | Provides relative to certain materials in publ... | Book Ban | 5/7/2024 | Read by title, returned to the calendar. | Worst | Worst | Passed a committee in the House but failed at ... | https://legiscan.com/LA/bill/HB545/2024 | Beryl Amedee | Hearing 2024-04-16 09:30 Room 6 | H 2024-03-01 Prefiled., H 2024-03-01 Under the... | Failed | a9068dc615adf12db572fa16cd3a54c3 | 1857939.0 | https://www.legis.la.gov/Legis/ViewDocument.as... | NaN | https://drive.google.com/open?id=1mCuLbEGEFEyd... |
| 34 | California | SB1435 | An act to add Section 18112 to the Education C... | Book Ban | 4/24/2024 | April 24 set for first hearing. Failed passage... | Safest | Safest | For K8 material; amended to replace word "obsc... | https://legiscan.com/CA/bill/SB1435/2023 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 213 | Louisiana | HB425 | Provision of sexual content to minor, prohibit... | Book Ban | 4/4/2024 | Pending House Judiciary | Worst | Worst | defines "gender ideology" as sexual content an... | https://legiscan.com/AL/bill/HB425/2024 | NaN | NaN | NaN | Failed | NaN | NaN | NaN | NaN | NaN |
| 574 | Virginia | HB1206 | Obscene materials; modifies restrictions on pu... | Book Ban | 2/13/2024 | Left in Courts of Justice | High | Low | Carried forward to 2025 Session | https://legiscan.com/VA/bill/HB1206/2024 | Phillip Scott, Wendell Walker, Eric Zehr | Hearing 2024-01-31 08:00 House Committee Room ... | H 2024-01-10 Prefiled and ordered printed; off... | Roll Over | 3f9d15a4baef3c45c5490b389dee8b36 | 1810011.0 | https://lis.virginia.gov/cgi-bin/legp604.exe?2... | NaN | https://drive.google.com/open?id=1sQPNRbMQFbfk... |
| 341 | Nebraska | LB635 | Provide requirements regarding access to digit... | Book Ban | 4/18/2024 | Indefinitely postponed | Worst | High | NaN | https://legiscan.com/NE/bill/LB635/2023 | Joni Albrecht | Hearing 2023-03-06 13:30 Room 1525 | L 2023-01-18 Date of introduction, L 2023-01-2... | Failed | c59723f16281222e28aa3bcd15dfb4c8 | 1665134.0 | https://nebraskalegislature.gov/FloorDocs/108/... | NaN | https://drive.google.com/open?id=1UK9KfO8QUt5c... |
| 319 | Missouri | SB1272 | Modifies provisions relating to providing expl... | Book Ban | 1/25/2024 | Second Read and Referred S Select Committee on... | Worst | High | NaN | https://legiscan.com/MO/bill/SB1272/2024 | Nick Schroer | NaN | S 2023-12-15 Prefiled, S 2024-01-03 S First Re... | Failed | 22343d8f8634d520da58e2bf41c6679d | 1792474.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=1yiyJrvVldJDF... |
| 439 | Pennsylvania | SB7 | In terms and courses of study, providing for p... | Book Ban | 10/25/2023 | Referred to EDUCATION | Low | Low | NaN | https://legiscan.com/PA/bill/SB7/2023 | Ryan Aument, David Argall, Cris Dush, Michele ... | Hearing 2023-10-18 10:30 | S 2023-04-20 Referred to EDUCATION, S 2023-10-... | Pass One Chamber | dc9e2b884e41d874a71948d8b4eeac83 | 1757726.0 | https://www.legis.state.pa.us/cfdocs/legis/PN/... | NaN | https://drive.google.com/open?id=1IuGdqdjNIfkD... |
| 206 | Kentucky | SB246 | AN ACT relating to materials, programs, or eve... | Book Ban | 2/26/2024 | to Education (S) | Worst | Moderate | NaN | https://legiscan.com/KY/bill/SB246/2024 | Lindsey Tichenor, Stephen Meredith | NaN | S 2024-02-22 introduced in Senate, S 2024-02-2... | Failed | 794631c997d4cd5bd8caf1ec1abc8517 | 1853463.0 | https://apps.legislature.ky.gov/recorddocument... | NaN | https://drive.google.com/open?id=11Wr3drYo35O1... |
| 111 | Idaho | S1289 | Adds to existing law to establish standards fo... | Book Ban | 2/22/2024 | Filed in Office of the Secretary of Senate | Worst | Worst | NaN | https://legiscan.com/ID/bill/S1289/2024 | State Affairs Committee | Hearing 2024-02-12 08:00 Room WW55 | S 2024-02-07 Introduced; read first time; refe... | Failed | 34fbf239786a460b1b2bebbc63fb14a0 | 1839802.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1xIj_EbAQpbvm... |
| 611 | West Virginia | HB5191 | Relating to permitting obscenity in schools | Book Ban | 1/25/2024 | To House Judiciary | High | High | Online Obscenity law as well | https://legiscan.com/WV/bill/HB5191/2024 | Margitta Mazzocchi | NaN | H 2024-01-25 Filed for introduction, H 2024-01... | Failed | 6eca3418da626d17e7245795e3b09824 | 1828252.0 | http://www.wvlegislature.gov/Bill_Status/bills... | NaN | https://drive.google.com/open?id=14T_iitzxUklz... |
| 476 | Tennessee | HB1661 | AN ACT to amend Tennessee Code Annotated, Titl... | Book Ban | 3/25/2024 | Taken off notice for cal. in Government Operat... | Worst | Worst | NaN | https://legiscan.com/TN/bill/HB1661/2023 | John Ragan, Jody Barrett | Hearing 2024-02-07 09:00 House Hearing Room II... | H 2024-01-08 Filed for introduction, H 2024-01... | Failed | e105559b3c2c37d314cb726985eb2f95 | 1799842.0 | https://www.capitol.tn.gov/Bills/113/Bill/HB16... | NaN | https://drive.google.com/open?id=1hL77KirimMb8... |
| 599 | West Virginia | HB4654 | Removing bona fide schools, public libraries, ... | Book Ban | 2/20/2024 | To Judiciary | High | High | NaN | https://legiscan.com/WV/bill/HB4654/2024 | Brandon Steele, Henry Dillon, Geoff Foster | Hearing 2024-01-19 09:15 House Judiciary Commi... | H 2024-01-12 Filed for introduction, H 2024-01... | Failed | 0784c91cf3881bba57cc5c6c8372b66a | 1812462.0 | http://www.wvlegislature.gov/Bill_Status/bills... | NaN | https://drive.google.com/open?id=1nWqKk1RBYJc5... |
| 104 | Idaho | H0710 | Amends and adds to existing law to prohibit ce... | Book Ban | 4/10/2024 | Reported Signed by Governor on April 10, 2024 ... | Worst | Worst | NaN | https://legiscan.com/ID/bill/H0710/2024 | State Affairs Committee | Hearing 2024-03-13 10:00 , Hearing 2024-03-20 ... | H 2024-03-11 Introduced, read first time, refe... | Enacted | 374862b1132e4d12811584aeb07c8b33 | 1862873.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=1r_fHa0Ny8ZI7... |
| 474 | Tennessee | HB1632 | AN ACT to amend Tennessee Code Annotated, Titl... | Book Ban | 4/17/2024 | Taken off notice for cal in s/c Finance, Ways,... | Worst | Worst | NaN | https://legiscan.com/TN/bill/HB1632/2023 | Gino Bulso, Jody Barrett | Hearing 2024-01-30 16:30 House Hearing Room II... | H 2024-01-02 Filed for introduction, H 2024-01... | Failed | 7612b6ad495ecf375de2eb5fc7ae2343 | 1795310.0 | https://www.capitol.tn.gov/Bills/113/Bill/HB16... | NaN | https://drive.google.com/open?id=1KVLzRF7pcYqN... |
| 107 | Idaho | S1221 | Amends and adds to existing law to establish p... | Book Ban | 1/15/2024 | Reported Printed; referred to State Affairs | Worst | Worst | NaN | https://legiscan.com/ID/bill/S1221/2024 | State Affairs Committee, Linda Hartgen, Josh W... | NaN | S 2024-01-12 Introduced; read first time; refe... | Failed | 7f1f5cb61693c77b32035a4db25ed4fc | 1812843.0 | https://legislature.idaho.gov/wp-content/uploa... | NaN | https://drive.google.com/open?id=12XxFQunkWIb8... |
| 427 | Oklahoma | SB1994 | Unlawful occupation of property; assistance fr... | Book Ban | 6/5/2024 | Approved by Governor 06/05/2024 | Worst | Worst | Obscenity ban entirely replaced by a bill abou... | https://legiscan.com/OK/bill/SB1994/2024 | Rob Standridge, Ross Ford, Terry O'Donnell, Jo... | Hearing 2024-02-20 14:00 Room 4S.9 , Hearing 2... | S 2024-02-05 First Reading, S 2024-02-05 Autho... | Failed | 47515140c6f7a413a12fbe8d69a5ebbb | 1821179.0 | http://webserver1.lsb.state.ok.us/cf_pdf/2023-... | NaN | https://drive.google.com/open?id=18wYm1UQfAzW_... |
| 591 | West Virginia | HB4011 | To modify exemptions from criminal liability t... | Book Ban | 1/10/2024 | To House Judiciary | High | High | NaN | https://legiscan.com/WV/bill/HB4011/2024 | Geno Chiarelli | NaN | H 2024-01-10 Filed for introduction, H 2024-01... | Failed | a2c7f653d0415c82ba774cc8673ef1d1 | 1809701.0 | http://www.wvlegislature.gov/Bill_Status/bills... | NaN | https://drive.google.com/open?id=1oJt3Y55cK6dt... |
| 331 | Missouri | SB950 | Modifies provisions relating to the offense of... | Book Ban | 4/2/2024 | Hearing Conducted S Select Committee on Empowe... | Worst | High | NaN | https://legiscan.com/MO/bill/SB950/2024 | Rick Brattin | Hearing 2024-04-02 12:00 Senate Lounge, Hearin... | S 2023-12-01 Prefiled, S 2024-01-03 S First Re... | Failed | 3e467cc5554348fecef10650832643d4 | 1790626.0 | https://www.senate.mo.gov/24info/pdf-bill/intr... | NaN | https://drive.google.com/open?id=161_AbOWGrgEO... |
Now you can ask questions like, Which states have the most book bans?
df[books].value_counts('State')
State
Missouri 6
West Virginia 4
Idaho 4
Tennessee 4
Maryland 3
New Hampshire 3
Wyoming 3
Kentucky 2
Louisiana 2
Kansas 2
Mississippi 2
Nebraska 2
South Carolina 2
Georgia 2
Alabama 2
California 1
Iowa 1
Oklahoma 1
Pennsylvania 1
South Dakota 1
Indiana 1
Utah 1
Virginia 1
Name: count, dtype: int64
df['Bill Type'].str.contains('Bathroom')
169 False
334 False
187 False
283 False
171 False
...
266 False
245 False
487 False
503 False
117 False
Name: Bill Type, Length: 674, dtype: bool
bathrooms = df['Bill Type'].str.contains('Bathroom')
df[bathrooms].info()
<class 'pandas.core.frame.DataFrame'>
Index: 42 entries, 397 to 252
Data columns (total 19 columns):
# Column Non-Null Count Dtype
--- ------ -------------- -----
0 State 42 non-null object
1 Number 42 non-null object
2 Summary 42 non-null object
3 Bill Type 42 non-null object
4 Date 42 non-null object
5 Status 42 non-null object
6 Youth State Risk 42 non-null object
7 Adult State Risk 42 non-null object
8 Notes 35 non-null object
9 URL 42 non-null object
10 Sponsors 34 non-null object
11 Calendar 18 non-null object
12 History 34 non-null object
13 Manual Status 41 non-null object
14 Change Hash 34 non-null object
15 Bill ID 34 non-null float64
16 PDF 34 non-null object
17 Bill Analysis (AI Automated) 1 non-null object
18 Bill PDF 34 non-null object
dtypes: float64(1), object(18)
memory usage: 6.6+ KB
df[bathrooms].value_counts('State')
State
Missouri 7
Mississippi 6
South Carolina 5
West Virginia 3
Arizona 2
Georgia 2
Utah 2
Tennessee 2
Ohio 2
Oregon 1
Virginia 1
US 1
Alabama 1
Oklahoma 1
Alaska 1
Nebraska 1
Minnesota 1
Louisiana 1
Iowa 1
New Hampshire 1
Name: count, dtype: int64
plotting data#
df.plot()
<Axes: >
df.plot(kind='bar')
<Axes: >
df.value_counts('Bill Type').plot(kind='bar')
<Axes: xlabel='Bill Type'>
df.value_counts('Bill Type')
Bill Type
Online Obscenity Law 86
Gender Affirming Care Ban 61
Book Ban 51
Sports Ban 43
DEI Ban 40
..
Bathroom Ban/Prison Placement Ban 1
Omnibus Anti-trans Bill 1
Ban On Public Investment in ESG Funds 1
Drag Ban/Book Ban 1
Forced Outing By Schools/ Trans Bathroom Ban 1
Name: count, Length: 83, dtype: int64
df['Bill Type'].plot(kind='bar')
---------------------------------------------------------------------------
TypeError Traceback (most recent call last)
Cell In[25], line 1
----> 1 df['Bill Type'].plot(kind='bar')
File ~/.conda/envs/jb/lib/python3.11/site-packages/pandas/plotting/_core.py:1030, in PlotAccessor.__call__(self, *args, **kwargs)
1027 label_name = label_kw or data.columns
1028 data.columns = label_name
-> 1030 return plot_backend.plot(data, kind=kind, **kwargs)
File ~/.conda/envs/jb/lib/python3.11/site-packages/pandas/plotting/_matplotlib/__init__.py:71, in plot(data, kind, **kwargs)
69 kwargs["ax"] = getattr(ax, "left_ax", ax)
70 plot_obj = PLOT_CLASSES[kind](data, **kwargs)
---> 71 plot_obj.generate()
72 plot_obj.draw()
73 return plot_obj.result
File ~/.conda/envs/jb/lib/python3.11/site-packages/pandas/plotting/_matplotlib/core.py:499, in MPLPlot.generate(self)
497 @final
498 def generate(self) -> None:
--> 499 self._compute_plot_data()
500 fig = self.fig
501 self._make_plot(fig)
File ~/.conda/envs/jb/lib/python3.11/site-packages/pandas/plotting/_matplotlib/core.py:698, in MPLPlot._compute_plot_data(self)
696 # no non-numeric frames or series allowed
697 if is_empty:
--> 698 raise TypeError("no numeric data to plot")
700 self.data = numeric_data.apply(type(self)._convert_to_ndarray)
TypeError: no numeric data to plot
df['Bill Type']
169 Anti-Boycotts Act
334 Anti-Boycotts Act
187 Anti-Boycotts Act
283 Anti-Boycotts Act
171 Anti-Boycotts Act
...
266 Trans Segregation Bill
245 Trans Segregation Bill
487 Trans Surveillance Bill
503 Trans Surveillance Bill
117 Trans Surveillance Bill
Name: Bill Type, Length: 674, dtype: object
type(df['Bill Type'][0])
str
type(df.value_counts('Bill Type')[0])
/var/folders/z6/8hbw1n6n3dq2jdw3_zjysj5sws21gh/T/ipykernel_7834/760123532.py:1: FutureWarning: Series.__getitem__ treating keys as positions is deprecated. In a future version, integer keys will always be treated as labels (consistent with DataFrame behavior). To access a value by position, use `ser.iloc[pos]`
type(df.value_counts('Bill Type')[0])
numpy.int64
df.value_counts('Bill Type').plot(kind='bar')
<Axes: xlabel='Bill Type'>
# method chaining: nlargest()
df.value_counts('Bill Type').nlargest(10).plot(kind='bar')
<Axes: xlabel='Bill Type'>
Looking into the pandas.DataFrame.plot docs to see what other params are available, like barh, xlabel and title.
df.value_counts('Bill Type').nlargest(10).plot(kind='barh', xlabel='Number of Bills', title='Most Frequent Categories for Anti-Trans Bills')
<Axes: title={'center': 'Most Frequent Categories for Anti-Trans Bills'}, xlabel='Number of Bills', ylabel='Bill Type'>
df.value_counts('Bill Type').plot(kind='pie')
<Axes: ylabel='count'>
df.value_counts('Youth State Risk').plot(kind='pie')
<Axes: ylabel='count'>
