Data and sources
scorecard - College data from the U.S. Dept. of Education. We'll be working with select fields on four-year colleges. https://collegescorecard.ed.gov/data/
txschools, txstaff - Data on public schools, students & teachers in Dallas County, Texas, 2017-18. https://rptsvr1.tea.texas.gov/perfreport/tapr/2018/index.html and https://tea.texas.gov/2018accountability.aspx
wisc_pov07, wisc_pov17 - U.S. Census data showing total population, child population (ages 5-17) and children living in poverty by school district in Wisconsin. https://www.census.gov/programs-surveys/saipe/data/datasets.html
wisc_ratings17 - Public school district ratings in Wisconsin, from report card files. https://apps2.dpi.wi.gov/reportcards/
wisc_crosswalk - File with both federal and state codes for Wisconsin school districts, from the NCES Common Core of Data. https://nces.ed.gov/ccd/pubagency.asp
Helpful links
SQLite - download at https://www.sqlite.org/download.html For Mac, select "Precompiled Binaries for Mac OS X (x86)" For Windows, select "Precompiled Binaries for Windows" and use the 3rd option (Starts with "A bundle of command-line tools...)
DB Browser - download at https://sqlitebrowser.org/dl/
SQLizer - convert data files into an SQL script for importing into DB Browser. Some tweaks required. https://sqlizer.io/#/ Sqlify - another option. https://sqlify.io/convert
SQLite help:
A Gentle Introduction to SQL Using SQLite, https://a-gentle-introduction-to-sql.readthedocs.io/en/latest/
Tech on the Net, https://www.techonthenet.com/sqlite/index.php
SQLite Tutorial, http://www.sqlitetutorial.net/