Nebraska legislature: Bills introduced on March 5th

gistfile1.txt

Repo / HOWTO: https://github.com/jhannah/legislature_calendar/tree/main/experiments/CSV_dumps

Following up on this thread:
  https://octodon.social/@deafferret/109759239190597753

Let's pick a random day of the year not in "the first 10 days of a session." I chose March 5th.

How many bills were Introduced on March 5th?

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05" | wc -l
      24
      
24. What were their IDs / years?

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05"
NE/2019-2020_106th_Legislature/csv/history.csv:9028:1229717,2019-03-05,Legislature,1,"Date of introduction"
NE/2019-2020_106th_Legislature/csv/history.csv:9032:1229880,2019-03-05,Legislature,1,"Date of introduction"
NE/2019-2020_106th_Legislature/csv/history.csv:14801:1356059,2020-03-05,Legislature,1,"Date of introduction"
NE/2019-2020_106th_Legislature/csv/history.csv:14808:1356437,2020-03-05,Legislature,1,"Date of introduction"
NE/2019-2020_106th_Legislature/csv/history.csv:14812:1356440,2020-03-05,Legislature,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15246:410940,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15250:410953,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15254:410988,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15258:411014,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15262:411043,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15266:411070,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15270:411098,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15274:411125,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15278:411152,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15282:411206,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15292:411231,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15302:411251,2012-03-05,,1,"Date of introduction"
NE/2011-2012_102nd_Legislature/csv/history.csv:15381:412499,2012-03-05,,1,"Date of introduction"
NE/2013-2014_103rd_Legislature/csv/history.csv:14826:633935,2014-03-05,Legislature,1,"Date of introduction"
NE/2013-2014_103rd_Legislature/csv/history.csv:14830:633938,2014-03-05,Legislature,1,"Date of introduction"
NE/2013-2014_103rd_Legislature/csv/history.csv:14834:633963,2014-03-05,Legislature,1,"Date of introduction"
NE/2013-2014_103rd_Legislature/csv/history.csv:14844:633988,2014-03-05,Legislature,1,"Date of introduction"
NE/2013-2014_103rd_Legislature/csv/history.csv:14847:634296,2014-03-05,Legislature,1,"Date of introduction"
NE/2015-2016_104th_Legislature/csv/history.csv:8704:745304,2015-03-05,Legislature,1,"Date of introduction"

None of those were a Special Session according to the data. The sessions in the data are:

✗ ls -1 NE
2009-2010_101st_Legislature
2011-2012_102nd_Legislature
2013-2014_103rd_Legislature
2015-2016_104th_Legislature
2017-2018_105th_Legislature
2019-2020_106th_Legislature
2021-2021_107th_Legislature_1st_Special_Session
2021-2022_107th_Legislature
2023-2024_108th_Legislature

There were several years containing March 5th Introduction. 2012, 2014, 2015, 2019, 2020.

Let grab those specific Legiscan Bill IDs.

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05" | cut -d : -f 3 | cut -d , -f 1
1229717
1229880
1356059
1356437
1356440
410940
410953
410988
411014
411043
411070
411098
411125
411152
411206
411231
411251
412499
633935
633938
633963
633988
634296
745304

OK, now lets grab the Nebraska ID and name for each of those:

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05" | cut -d : -f 3 | cut -d , -f 1 | grep -f - `find ./ -name "bills.csv"` | cut -d , -f3,7
LR37,"Congratulate Jonathan Novinski on taking first place in the boys 500-yard freestyle at the 2019 State Swimming and Diving Championship"
LR38,"Congratulate the Wynot High School girls' basketball team and coaches on winning the 2019 Class D-2 state basketball championship"
LR334,"Express sympathy to the family of Charles ""Chuck"" Trimble and recognize his service to native peoples"
LR335,"Congratulate The Very Reverend Craig Loya on his election as the Tenth Bishop of the Episcopal Church in Minnesota and thank him for his ministry in the State of Nebraska"
LR336,"Congratulate nineteen boys from District 48 on their hard work to compete in the 2020 Nebraska State Wrestling Championship"
LB556,"Change provisions relating to redevelopment contracts under the Community Development Law"
LB820A,"Appropriation Bill"
LB821A,"Appropriation Bill"
LB1160A,"Appropriation Bill"
LR443,"Extend sympathy to the family
LR444,"Congratulate the Bluffs Middle School Brass Ensemble on their performance in the rotunda of the State Capitol"
LR445,"Congratulate the Wayne High School girls' bowling team for winning the 2012 Class C state tournament"
LR446,"Congratulate the Pender High School wrestling team for taking second place in the 2012 Class D state championship"
LR447,"Designate October 2012 as Nebraska Bullying Prevention Month"
LR448,"Recognize Film Streams for its contribution to the arts in Nebraska"
LR449,"Recognize March 2012 as Professional Social Work Month in Nebraska"
LR450,"Congratulate the Seward High School girls' basketball team for winning the 2012 Class B state championship"
LR451,"Congratulate Mohit Jain for being named a 2012 Distinguished Finalist in the Prudential Spirit of Community Awards"
LR452,"Interim study to examine the public employees retirement systems administered by the Public Employees Retirement Board"
LB941A,"Appropriation Bill"
LB965A,"Appropriation Bill"
LR469,"Congratulate the Hastings Middle School on its selection as a 2014 MetLife Foundation-NASSP Breakthrough School honoree"
LR470,"Congratulate Alexander Payne for the remarkable success of his recent film
LR471,"Recognize March 2014 as Professional Social Work Month in Nebraska"
LR106,"Congratulate Hitchcock County Elementary School for being named a 2014 Title I Distinguished School by the National Title I Association"

Huh. Yup. Looks like all of those are Resolutions (LR) not Bills (LB),
except for Appropriation Bills, which I assume are special cases?

Just to throw a wider net, let's do all of March for all years, but skip all the Resolutions (LRs)
and skip all the Appropriation Bills:

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-" | cut -d : -f 3 | cut -d , -f 1 | grep -f - `find ./ -name "bills.csv"` | cut -d , -f3,7 | grep -v -E '^LR' | grep -v Appropr
LB248,"Change terminology relating to hearing-impaired persons"
LB255,"Change provisions relating to the Supplemental Nutrition Assistance Program"
LB256,"Authorize participation in insurance coverage for members of a community college board of governors"
LB530,"Require certain insurance policies to comply with federal minimum levels of financial responsibility for motor carriers"
LB556,"Change provisions relating to redevelopment contracts under the Community Development Law"

Huh. So is LB248 (for example) a non-appropriation Bill that was Introduced in March?

Hmm... the 2023 version of that was Introduced in January, not March: https://legiscan.com/NE/bill/LB248/2023

That's the wrong LB248, apparently? What year did we hit in our search? This one apparently:

✗ ack LB248 `find ./ -name "bills.csv"`
NE/2019-2020_106th_Legislature/csv/bills.csv
262:1150115,1641,LB248,4,Passed,2019-05-30,"Change terminology relating to hearing-impaired persons","Change terminology relating to hearing-impaired persons",0,,2019-05-30,"Approved by Governor on May 29, 2019",https://legiscan.com/NE/bill/LB248/2019,https://nebraskalegislature.gov/bills/view_bill.php?DocumentID=36991

So... that wasn't a special session. Let's find it in Legiscan. Here it is:

https://legiscan.com/NE/bill/LB248/2019

So the website says Introduced 2019-01-14... So how did it end up in our sweep?

✗ grep 1150115 `find ./ -name "history.csv"`
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-01-14,Legislature,1,"Date of introduction"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-01-16,Legislature,2,"Referred to Health and Human Services Committee"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-01-17,Legislature,3,"Blood name added"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-02-07,Legislature,4,"Notice of hearing for February 27, 2019"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-03-12,Legislature,5,"Placed on General File"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-10,Legislature,6,"Advanced to Enrollment and Review Initial"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-13,Legislature,7,"Placed on Select File"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-16,Legislature,8,"Advanced to Enrollment and Review for Engrossment"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-21,Legislature,9,"Placed on Final Reading"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-23,Legislature,10,"Passed on Final Reading 47-0-2"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-23,Legislature,11,"President/Speaker signed"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-24,Legislature,12,"Presented to Governor on May 23, 2019"
.//NE/2019-2020_106th_Legislature/csv/history.csv:1150115,2019-05-30,Legislature,13,"Approved by Governor on May 29, 2019"

uhh... so that data looks good too. I blundered something? My grep | cut | grep stuff is too sloppy, I'm getting 
invalid hits against short strings because I'm not controlling where the match is happening?

Let's go back to the smaller dataset, Mar 5 specifically, and look at the ones there that look like they're breaking
our rules:

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05" | cut -d : -f 3 | cut -d , -f 1 | grep -f - `find ./ -name "bills.csv"` | cut -d , -f3,7
LB556,"Change provisions relating to redevelopment contracts under the Community Development Law"
^ that's the only one on March 5th specifically.

Grab that out of bills:

✗ ack LB556 `find ./ -name "bills.csv"` | grep redev
NE/2021-2022_107th_Legislature/csv/bills.csv:607:1411070,1810,LB556,1,Introduced,2021-01-19,"Change provisions relating to redevelopment contracts under the Community Development Law","Change provisions relating to redevelopment contracts under the Community Development Law",0,,2021-05-27,"Provisions/portions of LB556 amended into LB131 by AM751",https://legiscan.com/NE/bill/LB556/2021,https://nebraskalegislature.gov/bills/view_bill.php?DocumentID=44408

Search history on that one:

✗ grep 1411070 `find ./ -name "history.csv"`
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-01-19,Legislature,1,"Date of introduction"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-01-22,Legislature,2,"Referred to Urban Affairs Committee"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-02-10,Legislature,3,"Notice of hearing for February 23, 2021"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-03-03,Legislature,4,"Placed on General File"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-05-26,Legislature,5,"Motion to suspend rules to indefinitely postpone filed"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-05-27,Legislature,6,"Motion to suspend rules to indefinitely postpone prevailed"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-05-27,Legislature,7,"Indefinitely postponed"
.//NE/2021-2022_107th_Legislature/csv/history.csv:1411070,2021-05-27,Legislature,8,"Provisions/portions of LB556 amended into LB131 by AM751"

That one also was Introduced Jan 19 (not March 5). Huh. Let's try to pin down where exactly our hacky pipeline thing
is failing... Here's the specific failure:

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05" | cut -d : -f 3 | cut -d , -f 1 | grep -f - `find ./ -name "bills.csv"` | grep 1411070
.//NE/2021-2022_107th_Legislature/csv/bills.csv:1411070,1810,LB556,1,Introduced,2021-01-19,"Change provisions relating to redevelopment contracts under the Community Development Law","Change provisions relating to redevelopment contracts under the Community Development Law",0,,2021-05-27,"Provisions/portions of LB556 amended into LB131 by AM751",https://legiscan.com/NE/bill/LB556/2021,https://nebraskalegislature.gov/bills/view_bill.php?DocumentID=44408

Oh, ha, ya, so this is my sloppiness biting me. 

✗ ack -i "Date of introduction" `find ./ -name "history.csv"` | grep "\-03-05" | cut -d : -f 3 | cut -d , -f 1
...
411014
411043
411070  <---- THIS ONE is causing us to quickly, sloppily find 1411070 because it's a substring match
411098
411125
...

Bad Jay. Bad, lazy sloppy programmer Jay. Do things right (time consuming) or don't do them at all!  :)

Conclusion: It appears that "Melody the Great" is correct. I have no evidence that any Bill (LBs) has been Introduced
"after 10 days" of start of session. EXCEPT for Appropriation Bills, which I assume are known exceptions.
Resolutions (LRs) are Introduced all throughout all the years.

Note: I didn't prove it's never happened. They could be one or more in the data somewhere. But I didn't find
any with my quick sloppy methods. If anyone cares I could dig deeper.

Cheers!