Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
lil_tee
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
8 ms
·
31.
▲
The Evolution of the New York Times Weddings Section
(vox.com)
4 points
by
lil_tee
10y ago
|
0 comments
32.
▲
Taxi, Uber, and Lyft Usage in New York City
(toddwschneider.com)
117 points
by
lil_tee
11y ago
|
101 comments
33.
▲
Interactive NBA Shot Charts with R and Shiny
(toddwschneider.com)
111 points
by
lil_tee
11y ago
|
20 comments
34.
▲
by
lil_tee
11y ago
TLC just released 6 additional months of trip-level data (Jul-Dec 2015): http://www.nyc.gov/html/tlc/html/about/trip_record_data.shtm... GitHub repo updated to process additional data: https://
35.
▲
New data shows NYC taxi usage down 11% in H2 '15 compared to previous year
(twitter.com)
5 points
by
lil_tee
11y ago
|
1 comments
36.
▲
Taxi Use Patterns Can Tell Us How Good the Super Bowl Was
(nytimes.com)
2 points
by
lil_tee
11y ago
|
0 comments
37.
▲
by
lil_tee
11y ago
Number of bikes in active use does not seem to change with the seasons: https://github.com/toddwschneider/nyc-citibike-data/blob/mas... The summer 2015 increase corresponds to the permanent expansion in Augus
38.
▲
A Tale of Twenty-Two Million Citi Bikes: Analyzing the NYC Bike Share System
(toddwschneider.com)
152 points
by
lil_tee
11y ago
|
42 comments
39.
▲
40% of NYC Taxi Trips Are Uniquely Identified by Census Tracts and Hour
(gist.github.com)
13 points
by
lil_tee
11y ago
|
11 comments
40.
▲
by
lil_tee
11y ago
Yes, the database is all on the machine's local 512 GB hard drive. I did store the downloaded flat text files to an external drive and loaded them into the db from there.
41.
▲
by
lil_tee
11y ago
Sure, there are undoubtedly lots of examples of businesses that opened in desolate areas and created new taxi activity where there had been none previously, I just happened to focus on Williamsburg for the post. Another idea that I didn
42.
▲
by
lil_tee
11y ago
Yep, all on a 2012 MacBook Air. Data size was over 400GB with indexes Simple queries on indexed columns of the trips table take a minute or two, more complicated queries that require a full sequence scan can take up to a few hours
43.
▲
by
lil_tee
11y ago
My dataset does not include livery cabs FiveThirtyEight has some additional for-hire vehicle data in their GitHub which they obtained via FOIL request: https://github.com/fivethirtyeight/uber-tlc-foil-response/tr..
44.
▲
Analyzing 1.1B NYC Taxi and Uber Trips
(toddwschneider.com)
140 points
by
lil_tee
11y ago
|
24 comments
45.
▲
Electability of 2016 Presidential Candidates as Implied by Betting Markets
(toddwschneider.com)
54 points
by
lil_tee
11y ago
|
61 comments
46.
▲
by
lil_tee
11y ago
I did, though I asked permission from the Commissioner first
47.
▲
A Statistical Analysis of the LearnedLeague Trivia Competition
(toddwschneider.com)
18 points
by
lil_tee
11y ago
|
2 comments
48.
▲
Will Greece Will Exit the Eurozone in 2015? – Live Odds
(gambletron2000.com)
8 points
by
lil_tee
11y ago
|
4 comments
49.
▲
Open-Source Loan-Level Analysis of Fannie and Freddie
(toddwschneider.com)
280 points
by
lil_tee
11y ago
|
35 comments
50.
▲
Every Team’s Chances of Winning in Every Minute, According to Gamblers
(toddwschneider.com)
27 points
by
lil_tee
12y ago
|
2 comments
51.
▲
by
lil_tee
12y ago
Mostly to keep the app simple and still deployable on the free Heroku plan. Sure, it could handle multiple locations, but then it would quickly outgrow the free tier
52.
▲
Show HN: Instagram viewer by latitude and longitude, hosted for free on Heroku
(github.com)
49 points
by
lil_tee
12y ago
|
18 comments
53.
▲
The TechCrunch Bubble Index: Parsing Headlines to Quantify Startup Hype
(toddwschneider.com)
114 points
by
lil_tee
12y ago
|
20 comments
54.
▲
The Reddit Front Page Is Not a Meritocracy
(toddwschneider.com)
485 points
by
lil_tee
12y ago
|
147 comments
55.
▲
2014 US Senate Control Live Betting Odds
(gambletron2000.com)
1 points
by
lil_tee
12y ago
|
0 comments
56.
▲
How Many Paths Are Possible in an 18 Hole Round of Match Play Golf?
(toddwschneider.com)
32 points
by
lil_tee
12y ago
|
3 comments
57.
▲
The Traveling Salesman with Simulated Annealing, R, and Shiny
(toddwschneider.com)
158 points
by
lil_tee
12y ago
|
25 comments
58.
▲
Live Probability of Cleveland Cavaliers to Win 2014/15 NBA Championship
(gambletron2000.com)
2 points
by
lil_tee
12y ago
|
0 comments
59.
▲
What is the Longest Disambiguation Page on Wikipedia?
(toddwschneider.com)
97 points
by
lil_tee
12y ago
|
18 comments
60.
▲
What Real-Time Gambling Data Reveals About Sports
(gambletron2000.com)
163 points
by
lil_tee
13y ago
|
64 comments
More ›