From 1979 – 2018
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.
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?
You can get a ticket here.
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.
2016 Data showing places one can go for a Flu Vaccine in NYC.
Friday, February 28 – Saturday, March 7, 2020
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 .
Flip your data with transpose
- Highlight the data range
- Copy the data
- Right Click on the cell where you want to paste the data
- Choose Paste special (use the mouse to paste special)
- 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)