5 ms·
NYC Subway Turnstile Data
- tbrock 7y agoWish it came with a script to download the data so I made one if anyone else wants to use it: https://gist.github.com/TylerBrock/106cad5277151913f197daa2994e5991 https://gist.github.com/TylerBrock/106cad5277151913f197daa29...
- crazygringo 7y agoSince they're just direct text file downloads from a single page, there are lots of browser extensions that can handle it for you easily. Or just write a regex to turn the HTML into a bunch of curl commands. The files are all on a single page. It's pretty easy. You don't need a script.
- Avamander 7y agoIf the files are sequentially named then curl can download that very trivially. curl -O http://example/data[0-9].txt http://example/data[0-9].txt
- deleted 7y ago[deleted]
- kevin_thibedeau 7y agoWhy would Jan 20 and Feb 17 have unusually low traffic for a Monday?
- tbrock 7y agoThey are both national holidays in the United States.
- function_seven 7y agoMartin Luther King Day and Presidents’ Day, respectively. (EDITED)
- tbrock 7y ago[EDIT] he’s got it right now. That isn't correct it's actually the other way around. Martin Luther king day is in January and Presidents’ Day is in February.
- function_seven 7y agoOof. Thanks.
- koolba 7y agoThere’s no such thing as “President’s Day”. The actual national holiday is “Washington’s Birthday”: https://en.wikipedia.org/wiki/Washington%27s_Birthday https://en.wikipedia.org/wiki/Washington%27s_Birthday
- function_seven 7y agoFrom that link: > Also called Presidents Day or a variant thereof Thanks for giving me the formal name, though. As a Lincoln fan, I’ll stick with the colloquial :)
- crispyporkbites 7y agoIs there a GitHub / package manager for data yet? I should be able to search an index for relevant datasets, then do a simple ‘install’ command and be able to access them through the popular framework/SDKs, or as a SQL query
- djohnston 7y agoidk why they didn't publish an exported postgres table directly to github, instead of the rails app wrapper
- TheGallopedHigh 7y agoThe DVC lib comes close
- orhmeh09 7y agoThe what?
- TheGallopedHigh 7y agoSorry a bit slow on the reply. You can check out version control for data with DVC here https://dvc.org/ https://dvc.org/
- jrockway 7y agoI believe qri.io is that.
- asah 7y agoquiltdata.com
- crazygringo 7y agoIt's interesting to see not just how ridership plummeted over the past three weeks, but to see that it wasn't just a per-week phenomenon, but that ridership meaningfully decreased throughout the week from Monday through Friday the weeks of 3/9 and 3/16.
- deleted 7y ago[deleted]
- Spooky23 7y ago3/17 was a big day that the second wave of people started to work from home or stop working in NY.
- josephorjoe 7y ago3/9 was the last day I commuted to work and last day I was on the subway. I remember I went into work late and left early to avoid crowds. That was also the day my company changed our policy from "if you want to work from home, talk to your boss to see if that is appropriate" to "if you can work from home, you must work from home". My boss and most of my co-workers were already working from home since the previous week (my boss had announced he was OK w anyone working from home), and I only went in on the 9th because I had agreed to meet w someone in the office. Hard to believe that was 20 days ago...
- lsdafjklsd 7y agoMy wife's last day was the 10th but I had tried to get them to stop earlier, basically put my foot down. We actually left the city that Saturday, now we are dealing with driving around northern New Hampshire with NY plates. Locals are starting to take more notice.
- xfitm3 7y agoWhy exactly are they taking notice?
- 7y ago
- Agnolo_Giotto 7y agoAre the data available in real time?
- bldavies 7y agoSomewhat related/shameless self-plug: I created an R package [1] that provides data on travel times between NYC subway stops. These data can be used to, e.g., visualise and analyse the subway network [2]. [1]: https://github.com/bldavies/nyctrains https://github.com/bldavies/nyctrains [2]: http://bldavies.com/blog/how-central-grand-central-terminal/ http://bldavies.com/blog/how-central-grand-central-terminal/
- flexie 7y agoRidership plummeted to around 10-15 percent of normal last week, but you still have more than 500,000 daily riders. Obviously, health workers and others still need to go to work somehow but although you take 90 percent out of packed NYC subway cars and platforms, you still have plenty passengers for the virus to continue spreading.
- iso1210 7y agoAre the same number of trains running? In London the number of tube trains is down due to drivers+signallers ill/self isolating, meaning that in some cases the trains have been even busier than normal!
- CSMastermind 7y agoNo, they've cut down to 'essential service'
- martinald 7y agoIt's curious that tube drivers seem to be horribly afflicted with this so we can only run a skeleton service, but the buses (which are much closer to passengers) are running a standard weekend service with absolutely no problems.
- lordmax 7y agonice!
- tuna-piano 7y agoThere's a smart thermometer company who publishes data about the percentage of people with fevers in given geographic areas. It's interesting that there is a seemingly similar downward trend in the percentage of people in NYC with fevers ~5 days after subway ridership drops. Covid takes ~5 days from exposure to symptoms and ~12 days from exposure to hospitalization. Of course, these broad population measures almost certainly impact other diseases as well (no kids at school to spread flu). My (almost surely too) optimistic hope is that the huge increases in numbers the past week are mainly due to massive testing ramp ups and that the absolute number of cases has already peaked (for now). Screenshot of NYC graph: https://imgur.com/a/WeaWKj9 https://imgur.com/a/WeaWKj9 Smart thermometer data map: https://healthweather.us/ https://healthweather.us/
- WMCRUN 7y agoOr maybe hospitals aren’t using a consumer smart thermometer and more people are now hospitalized.