Notes From A Spreadsheet

Gnarly Data w/ Arrow, DuckDB, + SQL

ggplot2
databases
arrow
sql
duckdb

Knowing SQL is a must for Data Scientists + other analytics professionals, but how can R users start practicing their SQL skills in a familiar environment? That’s this post!
Aug 13, 2023
Matt Worthington
11 min

A Follow-Up on Open Sourcing Stuff You Know

Spatial Data
GIS
Mapping
Sharing
tidycensus
rdeck

Last week, I shared about how I use R for spatial workflows on social media and got a lot of feedback. Here’s what I’ve learned, plus some more spatial tips.
Oct 4, 2022
Matt Worthington
14 min

A Spatial/GIS Workflow for Interactive Maps in R

Spatial Data
GIS
Mapping
sf
rdeck

In recent years, there’s been a ton of packages released in R for working with and visualizing spatial data that have eliminated my need for things like ArcGIS. Here’s how I use a few of them.
Sep 29, 2022
Matt Worthington
19 min

Analyzing COVID-19 in Austin

COVID19
Public Health
Austin Public Health
I35
Austin
Public Data

Austin has been profiled numerous times throughout the pandemic as being relentless in its efforts to get good COVID-19 data, despite multiple challenges and barriers. This is the first in a set of posts where I take a look at local COVID-19 data for Austin and explore themes of risk, resilience, and disparities as it pertains to COVID-19 in Austin.
Aug 13, 2020
Matt Worthington
10 min

Visualizing American School Finance

School Finance
Public Education
Charter Schools
US Census Bureau

Analyzing School Finances Revenue Breakdowns For Every State From 1993-2015
Mar 28, 2018
Matt Worthington
25 min

My Testimony to The Texas Commission on Public School Finance

School Finance
Public Education
Texas Education Agency
Independent School Districts
Charter Schools

Delivered on March 19, 2018
Mar 21, 2018
Matt Worthington
6 min

ICYMI: This was all about racism

While Rodriguez v. San Antonio ISD worked its way through the courts in 1968, transcripts of Civil Rights hearings revealed a deeper logic at work in San Antonio and the country that sought to disenfranchise Mexican-Americans in almost every facet of life.
Dec 6, 2017
Matt Worthington, Bekah McKneel
14 min

How San Antonio left Edgewood to fend for itself

Reforms of the mid- and late-20th century offered opportunities for some school districts to shore up their property tax base and create more secure funding. Edgewood, however, would not be one of these.
Nov 29, 2017
Matt Worthington
7 min

How San Antonio segregated its schools

The struggles that continue to plague Edgewood ISD are rooted in prejudice. Throughout the 20th century, those prejudices became public policy that would allocate services unevenly across the city, creating intractable inequities still visible in the city’s school districts.
Nov 22, 2017
Matt Worthington
10 min

Why Americans Have No Right To An Education

How Texas’ school finance system helped perpetuate nationwide inequity.
Nov 8, 2017
Matt Worthington
7 min
No matching items