Summing and grouping in SQLite

  • Event: 2015 CAR Conference
  • Speaker: Troy Thibodeaux of The Associated Press
  • Date/Time: Saturday, Mar. 7 at 3:20pm
  • Location: M109
  • Audio file: No audio file available.

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.

Speaker Bios

  • Troy leads a distributed team of data analysts and developers working in newsrooms across The Associated Press to tell stories using data. His current obsession is data-driven newsroom collaborations. Ask him about SunshineHub or AP's data distros. Troy is based in New Orleans and, like most New Orleanians, probably talks about it too much.

Related Tipsheets

No tipsheets have yet been uploaded for this event.