{"push_id":783750085,"size":20,"distinct_size":16,"ref":"refs/heads/gh-pages","head":"5016e8a7b9015b7f4f43b58cf01742be7678497f","before":"db341103e34829d6f836772f9db3040784593372","commits":[{"sha":"8cc855ff67bfcd65a7798b5be46aeebbd3bd734d","author":{"email":"33d4cec8959be25aa1570803ce8017b88fe6ad50@gmail.com","name":"Zack Brym"},"message":"add [back] original Portal plots and species data","distinct":false,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/8cc855ff67bfcd65a7798b5be46aeebbd3bd734d"},{"sha":"45a88c5da2aba8f18a7cf1f308af869cf8ed4345","author":{"email":"33d4cec8959be25aa1570803ce8017b88fe6ad50@gmail.com","name":"Zack Brym"},"message":"Sql-database-structure-1: update to use portal_plots_original.csv","distinct":false,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/45a88c5da2aba8f18a7cf1f308af869cf8ed4345"},{"sha":"f4cd6dc57c924ac51ec68dda430e77d594243a8b","author":{"email":"33d4cec8959be25aa1570803ce8017b88fe6ad50@gmail.com","name":"Zack Brym"},"message":"Sql-database-structure-2: update to use portal_species_original","distinct":false,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/f4cd6dc57c924ac51ec68dda430e77d594243a8b"},{"sha":"1c6e4fa26880ecab69eb2a439b5009df15f07fd5","author":{"email":"33d4cec8959be25aa1570803ce8017b88fe6ad50@gmail.com","name":"Zack Brym"},"message":"Sql-importing-data.md: fix metadata link; minor edits","distinct":false,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/1c6e4fa26880ecab69eb2a439b5009df15f07fd5"},{"sha":"ff6bfb5ab4674270e377d151fa0616b31e9f92f6","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Fix typo in Sql-joins-1","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/ff6bfb5ab4674270e377d151fa0616b31e9f92f6"},{"sha":"6087871483aa33d5ea9d6a29ebc0ea080242a243","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Minor cleanup of Sql-joins-2","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/6087871483aa33d5ea9d6a29ebc0ea080242a243"},{"sha":"906192ae985f0d6da41174349442307d11b91111","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Minor cleanup of Sql-joins-3","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/906192ae985f0d6da41174349442307d11b91111"},{"sha":"7903f1fdc09ff87eef4fb0b541fef82a17b3b5a7","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Minor cleanup of Sql-joins-4","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/7903f1fdc09ff87eef4fb0b541fef82a17b3b5a7"},{"sha":"97ee493cf92ae026ed45cf08823c9a3e472f3579","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Add more explanation to nested queries exercise","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/97ee493cf92ae026ed45cf08823c9a3e472f3579"},{"sha":"a08b619ddaace58a0de39ecfcfb40528163408a4","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Merge pull request #199 from brymz/tidy\n\nAdd Tidy Data Problems as Sql-database-structure","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/a08b619ddaace58a0de39ecfcfb40528163408a4"},{"sha":"1f264cfe3969ee2332b458e9a1611d71e8b6e183","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Merge pull request #200 from ethanwhite/assig-2-cleanup\n\nMinor cleanup of Assignment 2 exercises","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/1f264cfe3969ee2332b458e9a1611d71e8b6e183"},{"sha":"3f47b1c646a535b5bd4f3aa45ed25345ef46f4fd","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Add exercise on identifying problems with messy data","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/3f47b1c646a535b5bd4f3aa45ed25345ef46f4fd"},{"sha":"5c884062fce272b6aae6c47f2119bdf2c8073fa8","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Merge pull request #201 from ethanwhite/tidy-data-exercise\n\nAdd exercise on identifying problems with messy data","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/5c884062fce272b6aae6c47f2119bdf2c8073fa8"},{"sha":"6b241a37a6053eaf57ac94b7065e7eb0364458cb","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Change from Access videos to SQLite videos","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/6b241a37a6053eaf57ac94b7065e7eb0364458cb"},{"sha":"4b261013e48ec621cebe0f85e066e0f4d853d75b","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Add Nested Queries reading","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/4b261013e48ec621cebe0f85e066e0f4d853d75b"},{"sha":"b6694954cf4bb9a6d2ffe04afa250aea1078fd40","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Merge pull request #202 from ethanwhite/update-readings\n\nUpdate readings","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/b6694954cf4bb9a6d2ffe04afa250aea1078fd40"},{"sha":"4f62172c1c592897060ef12c05d81c6eba364a91","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Add missing [Reading] tag","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/4f62172c1c592897060ef12c05d81c6eba364a91"},{"sha":"56f51e03020506ca6804e7ba4077fee333e82e9c","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Improve README as a source of information to newcomers","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/56f51e03020506ca6804e7ba4077fee333e82e9c"},{"sha":"7f2aa2758439c9c71b412eb49fb87d6e7fc7c20e","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Merge pull request #203 from ethanwhite/update-readme\n\nImprove README as a source of information to newcomers","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/7f2aa2758439c9c71b412eb49fb87d6e7fc7c20e"},{"sha":"5016e8a7b9015b7f4f43b58cf01742be7678497f","author":{"email":"0a27e12d062ad71673d57f9c2799b207af316885@weecology.org","name":"Ethan White"},"message":"Add office hours","distinct":true,"url":"https://api.github.com/repos/brymz/datacarp-semester-biology/commits/5016e8a7b9015b7f4f43b58cf01742be7678497f"}]}