Skip to content

Instantly share code, notes, and snippets.

@gumdropsteve

gumdropsteve/sample_taxi.csv

Created February 13, 2020 19:18
Show Gist options
  • Save gumdropsteve/37dc0a12c30fd52d81bdfcff915da04b to your computer and use it in GitHub Desktop.
Save gumdropsteve/37dc0a12c30fd52d81bdfcff915da04b to your computer and use it in GitHub Desktop.
Download ZIP
Sample o f the data used in BlazingSQL Distributed Taxi demo Notebook
Raw
sample_taxi.csv
VendorID tpep_pickup_datetime tpep_dropoff_datetime passenger_count trip_distance pickup_longitude pickup_latitude RateCodeID store_and_fwd_flag dropoff_longitude dropoff_latitude payment_type fare_amount extra mta_tax tip_amount tolls_amount improvement_surcharge total_amount
2 2015-01-15 19:05:39 2015-01-15 19:23:42 1 1.59 -73.99389648 40.75011063 1 N -73.97478485 40.75061798 1 12.0 1.0 0.5 3.25 0.0 0.3 17.05
1 2015-01-10 20:33:38 2015-01-10 20:53:28 1 3.3 -74.00164795 40.72424316 1 N -73.99441528 40.7591095 1 14.5 0.5 0.5 2.0 0.0 0.3 17.8
1 2015-01-10 20:33:38 2015-01-10 20:43:41 1 1.8 -73.96334076 40.80278778 1 N -73.95182037 40.8244133 2 9.5 0.5 0.5 0.0 0.0 0.3 10.8
1 2015-01-10 20:33:39 2015-01-10 20:35:31 1 0.5 -74.00908661 40.7138176 1 N -74.00432587 40.71998596 2 3.5 0.5 0.5 0.0 0.0 0.3 4.8
1 2015-01-10 20:33:39 2015-01-10 20:52:58 1 3.0 -73.97117615 40.76242828 1 N -74.00418091 40.74265289 2 15.0 0.5 0.5 0.0 0.0 0.3 16.3
1 2015-01-10 20:33:39 2015-01-10 20:53:52 1 9.0 -73.87437439 40.77404785 1 N -73.98697662 40.75819397 1 27.0 0.5 0.5 6.7 5.33 0.3 40.33
1 2015-01-10 20:33:39 2015-01-10 20:58:31 1 2.2 -73.98327637 40.72600937 1 N -73.99246979 40.74963379 2 14.0 0.5 0.5 0.0 0.0 0.3 15.3
1 2015-01-10 20:33:39 2015-01-10 20:42:20 3 0.8 -74.00266266 40.7341423 1 N -73.99501038 40.72632599 1 7.0 0.5 0.5 1.66 0.0 0.3 9.96
1 2015-01-10 20:33:39 2015-01-10 21:11:35 3 18.2 -73.78304291 40.64435577 2 N -73.9875946 40.75935745 2 52.0 0.0 0.5 0.0 5.33 0.3 58.13
1 2015-01-10 20:33:40 2015-01-10 20:40:44 2 0.9 -73.98558807 40.76794815 1 N -73.98591614 40.75936508 1 6.5 0.5 0.5 1.55 0.0 0.3 9.35
1 2015-01-10 20:33:40 2015-01-10 20:41:39 1 0.9 -73.98861694 40.72310257 1 N -74.00439453 40.72858429 1 7.0 0.5 0.5 1.66 0.0 0.3 9.96
1 2015-01-10 20:33:41 2015-01-10 20:43:26 1 1.1 -73.99378204 40.75141907 1 N -73.96740723 40.75721741 1 7.5 0.5 0.5 1.0 0.0 0.3 9.8
1 2015-01-10 20:33:41 2015-01-10 20:35:23 1 0.3 -74.00836182 40.70437622 1 N -74.00977325 40.70772552 2 3.0 0.5 0.5 0.0 0.0 0.3 4.3
1 2015-01-10 20:33:41 2015-01-10 21:03:04 1 3.1 -73.97394562 40.76044846 1 N -73.99734497 40.73521042 1 19.0 0.5 0.5 3.0 0.0 0.3 23.3
1 2015-01-10 20:33:41 2015-01-10 20:39:23 1 1.1 -74.0067215 40.73177719 1 N -73.99521637 40.73989487 2 6.0 0.5 0.5 0.0 0.0 0.3 7.3
2 2015-01-15 19:05:39 2015-01-15 19:32:00 1 2.38 -73.97642517 40.73981094 1 N -73.98397827 40.75788879 1 16.5 1.0 0.5 4.38 0.0 0.3 22.68
2 2015-01-15 19:05:40 2015-01-15 19:21:00 5 2.83 -73.96870422 40.75424576 1 N -73.9551239 40.7868576 2 12.5 1.0 0.5 0.0 0.0 0.3 14.3
2 2015-01-15 19:05:40 2015-01-15 19:28:18 5 8.33 -73.86306 40.76958084 1 N -73.95271301 40.78578186 1 26.0 1.0 0.5 8.08 5.33 0.3 41.21
2 2015-01-15 19:05:41 2015-01-15 19:20:36 1 2.37 -73.94554138 40.77942276 1 N -73.98085022 40.78608322 1 11.5 1.0 0.5 0.0 0.0 0.3 13.3
2 2015-01-15 19:05:41 2015-01-15 19:20:22 2 7.13 -73.87445831 40.7740097 1 N -73.95237732 40.71858978 1 21.5 1.0 0.5 4.5 0.0 0.3 27.8
2 2015-01-15 19:05:41 2015-01-15 19:31:00 1 3.6 -73.97660065 40.7518959 1 N -73.99892426 40.71459579 2 17.5 1.0 0.5 0.0 0.0 0.3 19.3
2 2015-01-15 19:05:41 2015-01-15 19:10:22 1 0.89 -73.99495697 40.74507904 1 N -73.99993896 40.73464966 1 5.5 1.0 0.5 1.62 0.0 0.3 8.92
2 2015-01-15 19:05:41 2015-01-15 19:10:55 1 0.96 -74.00093842 40.74706268 1 N -74.00356293 40.73551178 1 5.5 1.0 0.5 1.3 0.0 0.3 8.6
2 2015-01-15 19:05:41 2015-01-15 19:12:36 2 1.25 -74.0027771 40.71789169 1 N -74.00791931 40.70421982 1 6.5 1.0 0.5 1.5 0.0 0.3 9.8
2 2015-01-15 19:05:41 2015-01-15 19:22:11 5 2.11 -73.99745941 40.73636246 1 N -73.9781723 40.76185608 1 11.5 1.0 0.5 2.5 0.0 0.3 15.8
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment