Summing and grouping in SQLite
The second session in the SQLite workshop will build up your SQL muscles, adding some common tasks that journalists need every day: getting counts and sums, munging the text of your data to make it more useful and structuring your data in a way that will make you more confident in the conclusions you reach.
This is the second of three SQL sessions using SQLite, but attendance at the earlier session is not required.
Troy Thibodeaux leads the data journalism team at The Associated Press. The data team works with reporters and editors across AP, building software, analyzing and visualizing data, to tell stories in word and pixel. They also manage the data sharing network, which has helped news organizations across the U.S. localize important data stories. He lives in New Orleans with his family and a new dog, and like most New Orleanians, he loves to talk about the place.
No tipsheets have yet been uploaded for this event.