Tuesday, January 26, 2021

Biden's Transgender Mlitary Policy Changes Nothing

Outspoken reports:

Biden sides with Trump, signs order on trans military service that changes almost nothing

Now, Joe Biden has revealed he mostly agrees with his predecessor. Critics say the highly-anticipated executive order is an empty screed reaffirming the military’s commitment to enlist all “qualified” and willing Americans, but stops short at changing almost anything in President Trump’s directive. Biden’s order does not eliminate the ban on service members undergoing medical treatment for gender dysphoria. It also, glaring, does not order the military to pay for gender reassignment surgery or other transition-related medical costs, a demand championed by leftwing activists.  

Monday, January 25, 2021

SQL Question

I have a SQL query that counts mass murders caused by mental illness by year.

SELECT year, Count(year) FROM Table2
WHERE ((Table2.cause_ID=15) OR
(Table2.cause_ID=16))
GROUP BY Table2.year;

But there are years with no mental illness mass murders, and this query does not show rows for those years.  How do I tell the query to insert rows with the intervening years and a 0 count?

It appears that I should create a table of years and counts initialized with years starting at my first row in Table2 up to the last row in Table2, then setting each count with the results of the above query.  But Access does not like:

create table allyears (year int, count int );

It shows a syntax error on the next statement after the semicolon.

Someone in the Oregon Legislature Needs to Take My 14th Amendment Class

 Oregon SB 619:

Be It Enacted by the People of the State of Oregon: 

SECTION 1.(1) The Department of Revenue shall establish a program to pay reparations to Black Oregonians who can demonstrate heritage in slavery and who submit an application to the department no later than December 31, 2022.

 (2) A person is eligible for reparations under this section if the person demonstrates that the person: 

(a) Is descended from an American slave;

 (b) Has identified as African-American on legal documents for at least 10 years before the date of the application;

 (c) Is at least 18 years of age, an emancipated minor or a ward, as defined in ORS 419A.004, whose parents are deceased or for whom parental rights have been terminated and have not been reinstated; and 

(d) Has resided in Oregon for at least two years before the date of the application. 

(3) The department shall pay to each eligible applicant the amount of $123,000 in the form of an annuity payable annually for the life of the applicant.

 (4) Reparations paid under this section and the right of a person to an annuity under this section are exempt from garnishment and all state, county and municipal taxation, except as provided under ORS chapter 118, are not subject to execution, garnishment, attachment or any other process or to the operation of any bankruptcy or insolvency law and are unassignable.

Do you suppose this might violate the "equal protection clause"?  Remember Oregon was never a slave state but did contribute two regiments to fight the Confederacy.

If you wanted to stir racist sentiment against black people what more could you do?  I think it would be fairer to track down every descendant of a slave owner (black or white) and confiscate their wealth.

Saturday, January 23, 2021

Biden Protecting Big Pharma? Or Something More Nefarious?

1/23/21 Daily Wire:

President Joe Biden’s United States Department of Health and Human Services (HHS) on Thursday stopped executive orders from his predecessor designed to significantly lower prescription drug prices for Americans, including insulin and epinephrine.

The new administration will apparently re-evaluate the executive action from President Donald Trump toward the end of March. It remains unclear if it will be reinstated.

So just Fascist support of big corporations at the cost of ordinary Americans?  It turns out Epipens, the suddenly skyrocketing essential drug a couple years ago, was one of the items these executive orders reduced.  

Sen. Manchin is the Democrat who has rejected court-packing.  And who is the CEO of Mylan, the maker of EpiPen? Sen. Manchin's daughter? So, if the 60 day suspension is made permanent, who gets rich?

 


Lithium Mining

One of the Trump Administration's last acts was approval of a lithium mine in Nevada.  You doubtless know that lithium is essential for all those electric vehicles at the heart of every environmental wet dream.  Of course, most of it comes from China, so environmentalists are trying hard to stop American lithium mining.  5/17/19 Seattle Times discusses the conflicted feelings of the Greenies.  Do we really want the environmental costs of lithium mining to be entirely in the Third World?  Do we want our Teslas cheap enough that everyone buys one, not just the well-heeled sorts that buy them now?

ICYMI

America's First Freedom this month published articles by me and many of the most important Second Amendment litigators and activists: Steve Halbrook, Dave Kopel, Nick Johnson, Dave Burnett.

Do Not Treat This As Unserious

A friend whose writing many of you know is a nurse back East and had seen more COVID19 deaths of his patients since this started than the previous several years deaths combined. 

The good news is that I know a fair number of people now that have come through this.   A close relative lost his sense of smell and taste, and tested positive.   But other than a few days of malaise,  he has fully recovered.  Worst of all, he was scheduled to get vaccinated the day he lost his sense of taste.

My physical therapist and his family got it and recovered.   Even months later, however,  he is still easily fatigued.  He was a runner so this suggests that the long term effects are serious.

A student last semester and his whole family got it.  They were over it in a week.  "Like a bad flu."

Another acquaintance got it and said it was not as bad as flu.

Another acquaintance will be on oxygen for the rest of his life.  The lung damage was substantial. 

For many people this is a few days of misery.  For some it is a life changing (and not for the better) experience.   For a few percent this is a slow and unpleasant death by asphyxiation. 

Stay masked in public.  The published work shows it reduces risk of infection. The sooner we get past this, the sooner the Fascists will lose their excuses to oppress us.