visualizing data with pandas#
import pandas as pd
import matplotlib.pyplot as plt
---------------------------------------------------------------------------
ModuleNotFoundError Traceback (most recent call last)
Cell In[1], line 1
----> 1 import pandas as pd
2 import matplotlib.pyplot as plt
ModuleNotFoundError: No module named 'pandas'
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[34], line 1
----> 1 df['Bill Type'].plot(kind='bar')
File /opt/anaconda3/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 /opt/anaconda3/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 /opt/anaconda3/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 /opt/anaconda3/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'>
