Data is Fun

Where data is fun.

March 25, 2020

Water Usage in NYC

From 1979 – 2018

Data Source:

I found it surprising that water consumption decreased in NYC over the 1979 – 2018 period. Especially since population increased during the same period. The inverse relationship between water consumption and population was unexpected.

March 22, 2020

Canine Waste Bag Dispensers in NYC

Caught off guard with out a bag to pick up your dog’s poop? Maybe one of these locations can help you out. The bag dispensers are located in each of the 5 boroughs. It would be cool if there was some indication of inventory. If it’s completely empty it’s not helpful.

It’s surprising how few of these dispensers are located in Manhattan. It will be interesting to revisit this data in a couple years to see if more are installed. Will the state wide plastic bag ban affect usage of these dispensers? With the slow elimination of plastic store bags will there be more poop on the streets and/or will usage increase?

Data source:

March 01, 2020

School of Data

BETA NYC’s one day School of Data is happening on Saturday, March 7th in NYC. This year it’s in Queens (in Long Island City) at CUNY Law school.

You can get a ticket here.

There are bunch of sessions to choose from. This years sessions are posted here. If you can’t make it to NYC this year there is also a livestream.

I also really like how the data is presented and the flexibility the platform offers. It makes it easy for me to compare across sessions so I can choose the presentations I’m most interested in.

February 25, 2020

NYC Locations Providing Seasonal Flu Vaccines Visualized

Source Data:

2016 Data showing places one can go for a Flu Vaccine in NYC.

February 22, 2020

NYC Data Week 2020

Friday, February 28 – Saturday, March 7, 2020

Be sure to check out the annual weekly event. The official site is here.

Most of the events are free, or low cost.

The list of events can be found here. It’s nice that the information can be filtered, and it makes it easy to register for events. There is a “Select View button” (in the upper left hand corner) that makes it easier to view the data. However, I found it difficult to compare the descriptions across events.

A favorite event during open data week is BETA NYC’s School of Data. School of Data is a one day event (on Sat. March 7th). It’s a fun way to meet others interested in data and/or NYC and learn too. I’d describe it as low cost. It’s not cheap, or free, but compared to conferences that can cost $1000+ it’s a $55 ticket .

February 17, 2020

Excel Tip: Transpose Data

Flip your data with transpose

  1. Highlight the data range
  2. Copy the data
  3. Right Click on the cell where you want to paste the data
  4. Choose Paste special (use the mouse to paste special)
  5. Click on Transpose

Let’s See it in action:

(Note: there is also an Excel Function =TRANSPOSE(), That does the same thing but via formula)