Data

Miscellaneous Datasets

This is a list of "original" data files that are used in several courses.

 

Zip Code Database (csv file) (csv) I found this on the Internet.

COVID-19_Case_Surveillance_Public_Use_Data-12-04-2020 (csv) An interesting COVID database.

GeoLite2-City-Locations-en (csv) This is the GeoLite2 database that I use in Moodle.

Northwind Database - Full size As far as I can tell, this is the full Northwind database. (sql and ER diagram)

Databases used in Sylvia Vasilik Textbook - SQL Practice Problem

Northwind Practice - This is a reduced Northwind database.

Databases used in Dyer Textbook

Birdwatchers (.zip) As far as I can tell, this is the full birdwatchers database. Used in the Dyer "Learning MySQL and MariaDB" book. (sql)

rookery (.sql) As far as I can tell, this is the full rookery database. Used in the Dyer "Learning MySQL and MariaDB" book.

Clements Checklist of World Birds (.zip) Used in the Dyer "Learning MySQL and MariaDB" book for demonstrating "import," Chapter 15. (csv and xlsx)

Databases used in MySQL Cookbook by DuBois

 

Database use in the Hoffer "Modern Database Management 12e" Textbook

BigPineFurniture

 

Eventually, package each of these into a zip file. The zip file might include csv, xlsx, text, sql, and other files. The goal is to have complete data that is used in a variety of settings (courses.)