SQLite II

  • Event: 2016 CAR Conference
  • Speaker: Emmanuel Martinez of The Markup
  • Date/Time: Saturday, Mar. 12 at 10:15am
  • Location: Denver V
  • Audio file: No audio file available.

The second session in SQLite will get you more comfortable querying a database by learning how to perform math in SQL. Learn how to group columns, perform counts and sums to arrive at keys findings.

Suggested technical experience: Anyone who attended SQLite I or anyone who has some experience with SQL.

Speaker Bios

  • Emmanuel Martinez is a data reporter for Reveal. A graduate of UC Irvine, Martinez received his master’s degree from the University of Southern California, where he studied radio and data journalism. Prior to joining Reveal, he interned for KPCC, the Los Angeles NPR affiliate, where he helped reporters acquire, clean and analyze data. Martinez is based in Reveal’s Emeryville, California, office.

Related Tipsheets

  • SQLite II repo
    The second session in SQLite will get you more comfortable querying a database by learning how to perform math in SQL. Learn how to group columns, perform counts and sums to arrive at key findings. https://github.com/emanthedataman/nicar2016_sqliteII/blob/master/README.md