This week at work we reviewed everyone’s goals for fall. A fixed the convex
solver for the day-of-week adjustments for the doctor visits signal, but we
haven’t figured out how to install it yet with M still away at her
internship. One of our cases and deaths providers changed the URL of their
dataset without telling us, and made it so that pandas requests got routed
to 403:Forbidden, which was annoying. It did give us the chance to start
archiving the raw data files though, so, silver linings. I met with a pile
of folks from Amazon to start the process of seeing if Redshift will be a
good choice for us. I pair programmed with G for a couple hours and
together we developed the SQL syntax for some of the queries the API server
will need to run on the interim system. Next is figuring out how to make
the existing query builder generate that syntax, which could be tricky. I
got A started writing a new indicator to track vaccination data published
by the CDC. I led the all-hands meeting, which was short since we didn’t
have a Big Picture talk scheduled.
In the kitchen this week the best news is that I opened the white grits I
ordered from Anson Mills and, wow. The texture is irregular and amazing,
creamy but gently toothsome. Fantastic in chili. Doesn’t take as long to
cook as they claim, either, though that may be because I prep a container
with the grits in it that also contains damp ingredients like diced
nectarine and green beans and tomatillos, so it has a chance to hydrate a
bit before cooking. Second best is that if you par-cook brown rice using
the pasta method on the same day you make soup, you can use the drained-off
starchy rice liquid in the soup, and it’s a very good idea indeed.
The new desk is excellent and lets me sit in way more different positions
than before. It is commensurately less sturdy though, so my second monitor
bobbles when I jog the table. I can live with that though.
I’ve been watching the new season of Wynonna Earp. There’s gore, but it’s
largely avoidable and there’s plenty of comic relief. Relationship drama
may cause a mild allergic reaction but it looks like a lot of it is going
to resolve soon.
P has been doing better on the new meds, but still in it.
Weather hot and humid. We’ve both been spending most of our time in the AC.
Some creature ripped up a bunch of the staples holding the garden fence in
place, and had a party with their whole family, so there’s not much left of
the garden. The squash has one leader left so is likely to recover, but the
beans and kale won’t. The cucumber vines are still small and largely
escaped the carnage, some flowers but no fruits yet. Wellp. It was a good
run.