Tablesaw comes built-in to the BeakerX Groovy kernel. Tablesaw provides the ability to easily transform, summarize, and filter data, as well as computing descriptive statistics and fundamental machine learning algorithms.
This notebook has some basic demos of how to use Tablesaw, including visualizing the results. This notebook uses the Beaker interactive visualizaiton libraries, but Tablesaw's APIs also work. The notebook covers basic table manipulation, k-means clustering, and linear regression.
More description is available at https://jtablesaw.wordpress.com/an-introduction/
tornadoes = Table.createFromCsv("Tablesaw/tornadoes_2014.csv")
//print dataset structure
tornadoes.structure().print()
Structure of tornadoes_2014.csv Index Column Name Column Type 0 Date LOCAL_DATE 1 Time LOCAL_TIME 2 State CATEGORY 3 State No SHORT_INT 4 Scale SHORT_INT 5 Injuries SHORT_INT 6 Fatalities SHORT_INT 7 Start Lat FLOAT 8 Start Lon FLOAT 9 Length FLOAT 10 Width FLOAT
//get header names
tornadoes.columnNames()
[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width]
//displays the row and column counts
tornadoes.shape()
908 rows X 11 cols
//displays the first n rows
tornadoes.first(10).print()
tornadoes_2014.csv Date Time State State No Scale Injuries Fatalities Start Lat Start Lon Length Width 2014-01-11 06:37:00 GA 0 0 0 0 34.3328 -84.5286 2.9 10.0 2014-01-11 14:32:00 VA 0 0 0 0 37.025 -76.6377 1.36 100.0 2014-01-11 14:32:00 VA 0 0 0 0 36.8769 -76.6721 1.95 50.0 2014-01-11 14:50:00 VA 0 0 0 0 37.08 -76.3 1.08 75.0 2014-02-20 14:25:00 IL 0 2 1 0 39.518 -90.841 12.09 80.0 2014-02-20 14:48:00 IL 0 0 0 0 39.7853 -90.4215 0.27 25.0 2014-02-20 14:52:00 IL 0 0 0 0 39.8193 -90.4178 8.17 50.0 2014-02-20 15:43:00 IL 0 0 0 0 39.5671 -89.6256 0.22 75.0 2014-02-20 15:57:00 IL 0 1 0 0 38.7575 -89.6151 20.56 300.0 2014-02-20 16:09:00 IL 0 2 1 0 39.2586 -89.234 22.38 200.0
tornadoes.structure().selectWhere(column("Column Type").isEqualTo("FLOAT")).print()
Structure of tornadoes_2014.csv Index Column Name Column Type 7 Start Lat FLOAT 8 Start Lon FLOAT 9 Length FLOAT 10 Width FLOAT
//summarize the data in each column
tornadoes.summary()
Table summary for: tornadoes_2014.csv Column: Date Measure Value Count 908 Missing 0 Earliest 2014-01-11 Latest 2014-12-29 Column: Time Measure Value Count 908 Missing 0 Earliest 00:01 Latest 23:59 Column: State Category Count GA 32 NM 15 MT 8 CO 49 WV 9 IN 28 MD 2 CA 9 AL 55 TN 18 NV 6 PA 9 WY 13 ID 3 KS 41 IA 56 MN 24 TX 46 WA 3 OK 17 NE 62 AR 20 ND 14 WI 22 IL 49 SD 29 MS 42 FL 28 AZ 3 NY 11 NC 32 OH 20 DE 1 VA 12 MO 47 ME 4 LA 15 MI 13 SC 7 KY 28 MA 3 CT 1 NH 2 Column: State No Measure Value n 908.0 sum 0.0 Mean 0.0 Min 0.0 Max 0.0 Range 0.0 Variance 0.0 Std. Dev 0.0 Column: Scale Measure Value n 908.0 sum 567.0 Mean 0.6244493 Min 0.0 Max 4.0 Range 4.0 Variance 0.6272737 Std. Dev 0.79200613 Column: Injuries Measure Value n 908.0 sum 684.0 Mean 0.75330395 Min 0.0 Max 193.0 Range 193.0 Variance 57.68108 Std. Dev 7.594806 Column: Fatalities Measure Value n 908.0 sum 48.0 Mean 0.052863438 Min 0.0 Max 16.0 Range 16.0 Variance 0.44262686 Std. Dev 0.6653021 Column: Start Lat Measure Value n 908.0 sum 34690.984 Mean 38.20593 Min 0.0 Max 48.86 Range 48.86 Variance 22.448586 Std. Dev 4.7379937 Column: Start Lon Measure Value n 908.0 sum -83613.02 Mean -92.08483 Min -122.946 Max 0.0 Range 122.946 Variance 91.84773 Std. Dev 9.583722 Column: Length Measure Value n 908.0 sum 3014.49 Mean 3.319923 Min 0.0 Max 45.68 Range 45.68 Variance 28.736567 Std. Dev 5.3606496 Column: Width Measure Value n 908.0 sum 149778.0 Mean 164.95375 Min 0.0 Max 2640.0 Range 2640.0 Variance 57764.465 Std. Dev 240.34239
//Mapping operations
def month = tornadoes.dateColumn("Date").month()
tornadoes.addColumn(month);
tornadoes.columnNames()
[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width, Date month]
//Sorting by column
tornadoes.sortOn("-Fatalities").print()
tornadoes_2014.csv Date Time State State No Scale Injuries Fatalities Start Lat Start Lon Length Width Date month 2014-04-27 18:06:00 AR 0 4 193 16 34.7787 -92.652 41.1 1320.0 APRIL 2014-04-28 14:51:00 MS 0 4 84 10 32.88 -89.43 33.39 1320.0 APRIL 2014-07-08 17:02:00 NY 0 2 0 4 42.99 -75.64 2.5 235.0 JULY 2014-12-23 14:20:00 MS 0 3 50 3 31.2273 -89.8331 12.51 880.0 DECEMBER 2014-04-27 14:20:00 IA 0 1 0 2 41.1325 -92.3117 45.68 1600.0 APRIL 2014-12-23 15:22:00 MS 0 2 0 2 31.6986 -89.2239 5.89 350.0 DECEMBER 2014-04-28 15:47:00 AL 0 3 30 2 34.7753 -87.2324 15.56 600.0 APRIL 2014-04-28 19:09:00 TN 0 3 0 2 35.0066 -86.5497 26.76 500.0 APRIL 2014-04-25 17:20:00 NC 0 2 1 1 36.054 -76.74 37.48 400.0 APRIL 2014-10-13 04:37:00 AR 0 2 4 1 33.6617 -94.2303 2.51 400.0 OCTOBER 2014-04-27 16:29:00 OK 0 2 37 1 36.912 -94.8215 11.37 325.0 APRIL 2014-04-28 17:27:00 MS 0 3 10 1 32.2291 -90.2225 29.72 400.0 APRIL 2014-04-27 16:29:00 OK 0 2 12 1 36.912 -94.8215 7.1 325.0 APRIL 2014-06-16 15:13:00 NE 0 4 0 1 41.9742 -97.04 11.5 500.0 JUNE 2014-06-16 15:00:00 NE 0 4 20 1 41.9528 -97.1369 23.94 500.0 JUNE 2014-02-20 16:54:00 IL 0 1 0 0 39.1784 -88.7233 1.54 100.0 FEBRUARY 2014-02-20 17:43:00 IL 0 0 0 0 39.7821 -87.7409 3.0 75.0 FEBRUARY 2014-02-20 18:40:00 IN 0 0 0 0 40.0044 -86.8666 7.48 40.0 FEBRUARY 2014-02-20 18:42:00 KY 0 0 0 0 37.48 -87.8974 6.22 125.0 FEBRUARY 2014-02-20 19:11:00 MS 0 0 0 0 31.0737 -90.0019 0.45 40.0 FEBRUARY 2014-02-20 19:12:00 KY 0 0 0 0 37.1 -87.75 1.59 125.0 FEBRUARY 2014-02-20 19:48:00 MS 0 0 0 0 31.253 -89.77 0.52 50.0 FEBRUARY 2014-02-20 20:32:00 IN 0 0 0 0 39.656 -85.5679 0.04 25.0 FEBRUARY 2014-02-20 20:33:00 LA 0 1 0 0 30.6913 -92.3903 2.65 75.0 FEBRUARY 2014-02-20 20:45:00 AL 0 1 0 0 34.6889 -87.2589 10.72 450.0 FEBRUARY 2014-02-20 20:51:00 AL 0 1 0 0 34.7858 -87.315 1.82 400.0 FEBRUARY 2014-02-20 20:55:00 AL 0 1 1 0 34.895 -87.2783 2.67 500.0 FEBRUARY 2014-02-20 21:05:00 AL 0 1 0 0 34.8798 -87.0707 2.73 500.0 FEBRUARY 2014-02-20 21:14:00 IN 0 1 0 0 39.1792 -85.2854 0.81 50.0 FEBRUARY 2014-02-20 21:28:00 MS 0 1 0 0 31.455 -89.366 4.62 100.0 FEBRUARY 2014-02-20 21:50:00 MS 0 0 0 0 31.607 -89.255 0.6 50.0 FEBRUARY 2014-02-20 21:53:00 TN 0 1 0 0 35.1935 -86.3331 1.64 400.0 FEBRUARY 2014-02-20 21:53:00 OH 0 0 0 0 39.889 -84.4078 2.03 80.0 FEBRUARY 2014-02-20 22:08:00 TN 0 1 0 0 35.176 -86.2048 1.05 100.0 FEBRUARY 2014-02-20 22:23:00 TN 0 1 0 0 35.287 -85.992 1.98 400.0 FEBRUARY 2014-02-20 22:29:00 TN 0 1 0 0 35.3303 -85.9324 1.21 250.0 FEBRUARY 2014-02-20 23:54:00 OH 0 0 0 0 40.2952 -82.9659 0.13 80.0 FEBRUARY 2014-02-21 00:28:00 AL 0 2 1 0 34.4941 -85.6754 0.83 50.0 FEBRUARY 2014-02-21 01:56:00 AL 0 0 0 0 33.6512 -86.4678 4.2 150.0 FEBRUARY 2014-02-21 07:21:00 GA 0 2 0 0 32.5745 -82.9754 17.47 200.0 FEBRUARY 2014-02-21 07:29:00 GA 0 0 0 0 31.43 -83.576 2.22 300.0 FEBRUARY 2014-02-21 11:15:00 NC 0 0 0 0 34.6697 -79.2903 0.49 25.0 FEBRUARY 2014-02-21 11:23:00 MD 0 0 0 0 38.242 -76.68 23.63 75.0 FEBRUARY 2014-02-21 11:38:00 NC 0 0 0 0 34.7993 -78.9753 0.16 35.0 FEBRUARY 2014-02-21 12:26:00 NC 0 1 0 0 35.277 -78.258 0.83 175.0 FEBRUARY 2014-02-28 20:17:00 CA 0 0 0 0 38.6297 -121.706 0.74 50.0 FEBRUARY 2014-03-01 13:40:00 AZ 0 0 0 0 33.4176 -111.854 0.45 100.0 MARCH 2014-03-06 11:00:00 FL 0 0 0 0 27.865 -82.85 0.05 10.0 MARCH 2014-03-06 11:38:00 FL 0 0 0 0 27.982 -82.604 1.38 15.0 MARCH 2014-03-06 13:30:00 FL 0 0 0 0 26.5793 -80.713 0.25 50.0 MARCH 2014-03-25 20:15:00 CA 0 0 0 0 39.71 -121.67 0.26 10.0 MARCH 2014-03-26 18:24:00 CA 0 0 0 0 38.8051 -121.534 0.63 25.0 MARCH 2014-03-26 18:30:00 CA 0 1 0 0 39.5905 -122.089 0.7 50.0 MARCH 2014-03-26 18:33:00 CA 0 1 0 0 39.5722 -122.099 0.95 50.0 MARCH 2014-03-26 18:45:00 CA 0 1 0 0 39.5845 -122.145 0.58 50.0 MARCH 2014-03-26 19:10:00 CA 0 0 0 0 38.7624 -121.416 4.02 20.0 MARCH 2014-03-27 15:03:00 MO 0 1 0 0 39.91 -94.2 9.25 200.0 MARCH 2014-03-27 15:22:00 MO 0 2 0 0 40.03 -94.0 2.98 100.0 MARCH 2014-03-27 15:41:00 IA 0 0 0 0 40.9854 -93.7744 0.73 75.0 MARCH 2014-03-27 15:55:00 MO 0 0 0 0 40.1 -93.66 12.84 500.0 MARCH 2014-03-28 20:23:00 LA 0 1 0 0 31.4215 -92.4232 1.52 200.0 MARCH 2014-03-29 12:20:00 FL 0 0 0 0 28.3892 -81.1332 2.43 100.0 MARCH 2014-03-29 18:57:00 NC 0 0 0 0 35.591 -78.6905 0.18 145.0 MARCH 2014-03-29 19:08:00 NC 0 0 0 0 35.6539 -78.6334 0.12 75.0 MARCH 2014-03-29 20:40:00 CA 0 0 0 0 39.8435 -121.974 0.01 10.0 MARCH 2014-03-31 14:50:00 MN 0 0 0 0 44.554 -95.9919 10.67 100.0 MARCH 2014-04-02 17:55:00 KS 0 0 0 0 37.0007 -98.3685 0.26 40.0 APRIL 2014-04-02 19:23:00 KS 0 0 0 0 37.2559 -95.9653 0.02 10.0 APRIL 2014-04-03 04:19:00 MO 0 1 0 0 38.67 -90.3625 0.63 100.0 APRIL 2014-04-03 07:30:00 IL 0 1 0 0 38.1057 -88.2256 0.99 90.0 APRIL 2014-04-03 18:27:00 TX 0 0 1 0 33.1851 -96.5234 0.94 40.0 APRIL 2014-04-03 18:56:00 MO 0 0 0 0 36.7518 -90.5799 0.19 50.0 APRIL 2014-04-03 19:03:00 TX 0 1 4 0 33.1959 -96.2488 11.8 750.0 APRIL 2014-04-03 19:40:00 IL 0 0 0 0 37.4657 -89.3103 0.27 50.0 APRIL 2014-04-03 19:52:00 IL 0 0 0 0 37.5092 -89.167 5.03 85.0 APRIL 2014-04-03 20:00:00 MO 0 1 0 0 36.8006 -90.2088 0.55 75.0 APRIL 2014-04-03 20:00:00 IL 0 0 0 0 37.5429 -89.0922 3.18 75.0 APRIL 2014-04-03 20:01:00 MO 0 1 0 0 36.8047 -90.2004 7.43 75.0 APRIL 2014-04-03 20:20:00 TX 0 0 1 0 33.2671 -95.587 0.56 250.0 APRIL 2014-04-03 20:25:00 IL 0 1 0 0 37.6192 -88.8914 0.77 50.0 APRIL 2014-04-03 20:40:00 MO 0 2 0 0 36.6843 -90.8698 3.48 220.0 APRIL 2014-04-04 06:23:00 LA 0 1 0 0 30.3977 -93.1845 1.84 100.0 APRIL 2014-04-04 07:11:00 LA 0 0 0 0 30.3718 -92.5016 0.81 50.0 APRIL 2014-04-06 18:41:00 MS 0 1 0 0 32.8022 -89.0136 1.25 150.0 APRIL 2014-04-07 01:02:00 MS 0 2 8 0 31.6717 -89.6567 16.48 600.0 APRIL 2014-04-07 11:55:00 GA 0 1 0 0 31.5444 -83.2685 1.93 165.0 APRIL 2014-04-07 13:49:00 NC 0 2 5 0 35.57 -76.66 4.7 300.0 APRIL 2014-04-07 14:00:00 NC 0 1 0 0 35.6 -76.54 1.32 200.0 APRIL 2014-04-07 15:23:00 FL 0 0 0 0 30.3879 -84.1433 0.51 50.0 APRIL 2014-04-07 19:50:00 GA 0 0 3 0 33.3025 -84.385 0.94 150.0 APRIL 2014-04-13 14:46:00 TX 0 0 0 0 33.0181 -94.9673 0.28 25.0 APRIL 2014-04-13 15:45:00 TX 0 1 1 0 31.1251 -95.4477 0.79 20.0 APRIL 2014-04-13 16:56:00 IA 0 0 0 0 41.488 -91.4437 1.3 25.0 APRIL 2014-04-13 16:58:00 OK 0 0 0 0 34.59 -97.71 0.37 50.0 APRIL 2014-04-13 17:05:00 OK 0 0 0 0 34.58 -97.66 0.3 40.0 APRIL 2014-04-13 19:45:00 AR 0 1 0 0 35.3658 -94.0375 5.4 450.0 APRIL 2014-04-20 16:10:00 KS 0 0 0 0 39.4 -100.938 0.1 10.0 APRIL 2014-04-20 16:30:00 TX 0 0 0 0 34.51 -100.07 0.2 50.0 APRIL 2014-04-20 16:47:00 KS 0 0 0 0 39.6128 -101.151 0.1 10.0 APRIL 2014-04-24 13:59:00 NC 0 1 0 0 36.2015 -77.9465 1.86 75.0 APRIL 2014-04-24 21:45:00 IL 0 1 0 0 37.7305 -89.3434 2.21 100.0 APRIL 2014-04-25 14:38:00 NC 0 0 0 0 35.479 -77.782 0.27 50.0 APRIL 2014-04-25 14:46:00 NC 0 1 0 0 35.53 -77.74 4.18 125.0 APRIL 2014-04-25 15:18:00 NC 0 0 0 0 35.6 -77.46 0.01 20.0 APRIL 2014-04-25 17:20:00 NC 0 2 0 0 0.0 0.0 0.0 0.0 APRIL 2014-04-25 17:22:00 NC 0 2 2 0 36.06 -76.705 33.46 400.0 APRIL 2014-04-25 17:22:00 NC 0 2 0 0 35.47 -77.26 1.13 75.0 APRIL 2014-04-25 17:35:00 NC 0 3 16 0 35.51 -77.12 20.99 350.0 APRIL 2014-04-25 17:50:00 NC 0 1 0 0 36.2 -76.28 6.21 200.0 APRIL 2014-04-25 18:12:00 NC 0 0 0 0 36.338 -76.241 0.47 50.0 APRIL 2014-04-25 18:28:00 NC 0 0 0 0 36.1985 -75.871 0.83 30.0 APRIL 2014-04-27 11:51:00 MO 0 0 0 0 38.9934 -93.9689 2.38 50.0 APRIL 2014-04-27 13:26:00 NE 0 0 0 0 40.3448 -98.885 0.14 35.0 APRIL 2014-04-27 15:40:00 NE 0 0 0 0 40.9527 -97.7065 0.07 45.0 APRIL 2014-04-27 15:40:00 IA 0 0 0 0 41.9625 -91.3819 0.5 50.0 APRIL 2014-04-27 16:17:00 NE 0 0 0 0 41.2007 -97.7065 0.4 45.0 APRIL 2014-04-27 16:31:00 OK 0 1 0 0 34.548 -94.7109 1.5 250.0 APRIL 2014-04-27 16:35:00 KS 0 2 25 0 36.9987 -94.753 4.27 150.0 APRIL 2014-04-27 16:40:00 KS 0 2 0 0 37.9269 -94.7125 16.13 400.0 APRIL 2014-04-27 16:48:00 KS 0 2 0 0 38.0371 -94.6419 8.5 400.0 APRIL 2014-04-27 17:15:00 MO 0 0 0 0 37.7302 -94.3995 0.34 100.0 APRIL 2014-04-27 18:30:00 WA 0 0 0 0 46.8649 -122.262 0.2 25.0 APRIL 2014-04-27 19:16:00 AR 0 2 1 0 35.2491 -91.9215 7.32 880.0 APRIL 2014-04-27 19:38:00 AR 0 0 0 0 35.4236 -91.674 1.64 250.0 APRIL 2014-04-27 19:43:00 AR 0 1 0 0 35.4639 -91.6414 5.28 100.0 APRIL 2014-04-27 19:52:00 AR 0 1 0 0 35.5439 -91.5524 0.84 50.0 APRIL 2014-04-27 22:45:00 MO 0 0 0 0 36.91 -92.81 0.88 100.0 APRIL 2014-04-28 02:09:00 LA 0 2 0 0 32.8866 -93.875 5.06 550.0 APRIL 2014-04-28 05:46:00 TN 0 0 0 0 35.3615 -89.7486 1.54 75.0 APRIL 2014-04-28 11:36:00 TN 0 1 0 0 35.8808 -85.2931 2.05 100.0 APRIL 2014-04-28 12:57:00 MS 0 0 0 0 32.7526 -90.6067 0.24 50.0 APRIL 2014-04-28 13:38:00 MS 0 3 32 0 34.2261 -88.8242 30.97 440.0 APRIL 2014-04-28 13:51:00 MS 0 1 0 0 33.4039 -89.6647 3.41 100.0 APRIL 2014-04-28 14:56:00 AL 0 1 0 0 34.5219 -87.7494 3.19 100.0 APRIL 2014-04-28 15:56:00 MS 0 1 1 0 32.2835 -90.8697 4.67 200.0 APRIL 2014-04-28 16:10:00 TN 0 2 1 0 36.4286 -89.1416 9.84 150.0 APRIL 2014-04-28 16:10:00 TN 0 2 1 0 36.4286 -89.1416 12.08 150.0 APRIL 2014-04-28 16:14:00 MS 0 1 0 0 33.23 -88.79 7.11 100.0 APRIL 2014-04-28 16:20:00 MS 0 1 0 0 32.3559 -90.5975 13.75 500.0 APRIL 2014-04-28 16:24:00 KY 0 1 0 0 36.5028 -89.0289 2.24 60.0 APRIL 2014-04-28 16:38:00 AL 0 0 0 0 34.1854 -87.998 7.72 100.0 APRIL 2014-04-28 16:39:00 MS 0 1 0 0 33.3011 -88.6286 0.64 100.0 APRIL 2014-04-28 16:46:00 KY 0 0 0 0 36.6537 -88.8654 1.03 25.0 APRIL 2014-04-28 16:48:00 MS 0 1 0 0 32.1229 -90.6352 10.86 300.0 APRIL 2014-04-28 16:50:00 AL 0 1 0 0 34.9476 -86.6465 8.91 100.0 APRIL 2014-04-28 16:53:00 MS 0 2 0 0 33.3664 -88.538 10.31 300.0 APRIL 2014-04-28 17:00:00 MS 0 1 0 0 32.5141 -90.1947 3.82 200.0 APRIL 2014-04-28 17:00:00 GA 0 2 0 0 33.122 -85.0556 5.7 150.0 APRIL 2014-04-28 17:08:00 MS 0 1 0 0 33.49 -88.39 6.35 250.0 APRIL 2014-04-28 17:09:00 TN 0 2 0 0 35.0186 -86.4875 9.53 250.0 APRIL 2014-04-28 17:13:00 MS 0 0 0 0 32.5886 -90.0994 0.8 75.0 APRIL 2014-04-28 17:19:00 MS 0 1 0 0 33.5251 -88.3037 1.95 100.0 APRIL 2014-04-28 17:19:00 MS 0 1 0 0 33.5251 -88.3037 10.03 500.0 APRIL 2014-04-28 17:22:00 AL 0 1 0 0 33.5379 -88.2741 8.08 500.0 APRIL 2014-04-28 17:38:00 MS 0 2 0 0 33.4382 -88.4064 8.06 300.0 APRIL 2014-04-28 17:38:00 MS 0 2 5 0 33.4382 -88.4064 14.27 500.0 APRIL 2014-04-28 17:54:00 AL 0 2 5 0 33.4888 -88.2802 6.21 500.0 APRIL 2014-04-28 18:08:00 MS 0 1 0 0 32.6746 -89.4246 5.05 100.0 APRIL 2014-04-28 18:35:00 AL 0 1 0 0 33.8878 -87.7094 6.97 350.0 APRIL 2014-04-28 18:36:00 MS 0 3 3 0 32.3703 -89.4564 4.27 150.0 APRIL 2014-04-28 18:54:00 MS 0 1 0 0 32.3824 -89.2825 9.57 150.0 APRIL 2014-04-28 19:12:00 MS 0 2 0 0 32.4116 -89.1147 5.59 400.0 APRIL 2014-04-28 19:18:00 AL 0 1 0 0 34.7945 -85.6557 6.13 100.0 APRIL 2014-04-28 19:35:00 MS 0 1 0 0 32.4262 -88.9417 13.11 100.0 APRIL 2014-04-28 19:40:00 AL 0 1 0 0 33.8344 -87.1945 2.39 150.0 APRIL 2014-04-28 20:30:00 AL 0 1 0 0 32.4208 -88.271 1.03 150.0 APRIL 2014-04-28 20:39:00 AL 0 3 0 0 34.0957 -86.7598 8.88 350.0 APRIL 2014-04-28 20:40:00 MS 0 3 15 0 31.7419 -89.0892 10.46 880.0 APRIL 2014-04-28 20:59:00 AL 0 1 13 0 33.0625 -87.6345 12.47 1500.0 APRIL 2014-04-28 21:00:00 AL 0 1 4 0 33.7514 -86.8303 8.78 800.0 APRIL 2014-04-28 21:05:00 GA 0 1 0 0 34.951 -84.8718 3.95 100.0 APRIL 2014-04-28 21:05:00 TN 0 1 0 0 34.9876 -84.8321 0.56 100.0 APRIL 2014-04-28 21:05:00 GA 0 1 0 0 34.951 -84.8718 3.39 100.0 APRIL 2014-04-28 21:09:00 MS 0 2 0 0 31.7579 -88.7559 9.2 250.0 APRIL 2014-04-28 21:13:00 AL 0 2 3 0 33.5856 -87.0055 5.46 1800.0 APRIL 2014-04-28 21:55:00 AL 0 1 0 0 33.3129 -87.2197 4.46 675.0 APRIL 2014-04-28 22:00:00 AL 0 1 0 0 33.3162 -87.111 7.62 913.0 APRIL 2014-04-28 22:16:00 AL 0 2 0 0 33.3592 -86.995 5.14 600.0 APRIL 2014-04-28 22:22:00 AL 0 1 0 0 33.8908 -86.4871 7.81 1000.0 APRIL 2014-04-28 23:15:00 AL 0 1 0 0 31.5759 -87.7633 0.31 200.0 APRIL 2014-04-28 23:24:00 AL 0 2 2 0 33.7993 -86.5395 14.6 1300.0 APRIL 2014-04-28 23:32:00 AL 0 3 0 0 34.1703 -86.0439 11.73 600.0 APRIL 2014-04-28 23:54:00 AL 0 2 0 0 34.3073 -85.9305 2.47 200.0 APRIL 2014-04-29 00:06:00 AL 0 2 0 0 34.3491 -85.8401 11.71 200.0 APRIL 2014-04-29 00:17:00 AL 0 1 0 0 34.0896 -86.155 6.28 200.0 APRIL 2014-04-29 00:28:00 AL 0 0 0 0 34.2243 -86.0781 2.42 75.0 APRIL 2014-04-29 00:36:00 AL 0 1 0 0 34.5048 -85.6174 10.2 200.0 APRIL 2014-04-29 01:23:00 AL 0 1 0 0 34.4282 -85.6466 1.05 200.0 APRIL 2014-04-29 02:25:00 AL 0 0 0 0 32.417 -85.4585 1.74 75.0 APRIL 2014-04-29 02:56:00 AL 0 3 13 0 32.465 -85.2336 11.45 1200.0 APRIL 2014-04-29 12:25:00 NC 0 0 0 0 35.17 -77.35 0.04 25.0 APRIL 2014-04-29 13:52:00 NC 0 1 0 0 35.02 -78.682 1.72 200.0 APRIL 2014-04-29 16:09:00 NC 0 0 0 0 35.848 -77.434 4.15 100.0 APRIL 2014-04-29 17:49:00 NC 0 0 0 0 35.441 -77.7891 0.02 25.0 APRIL 2014-04-29 18:10:00 NC 0 1 0 0 35.1491 -78.3948 0.81 100.0 APRIL 2014-04-30 00:44:00 FL 0 1 0 0 30.8785 -85.5282 1.62 100.0 APRIL 2014-04-30 00:52:00 FL 0 1 0 0 30.8788 -85.3641 4.61 150.0 APRIL 2014-05-06 14:05:00 WY 0 0 0 0 43.2194 -108.383 4.79 30.0 MAY 2014-05-06 14:07:00 WY 0 1 0 0 43.2966 -108.337 1.52 50.0 MAY 2014-05-07 15:08:00 WY 0 0 0 0 41.905 -109.385 0.53 30.0 MAY 2014-05-07 15:15:00 CO 0 0 0 0 40.23 -104.81 2.62 100.0 MAY 2014-05-07 16:05:00 CO 0 0 0 0 40.02 -103.03 0.1 50.0 MAY 2014-05-07 16:22:00 CO 0 0 0 0 40.13 -103.08 5.46 100.0 MAY 2014-05-07 17:25:00 CO 0 0 0 0 40.6 -102.63 0.1 50.0 MAY 2014-05-07 18:03:00 TX 0 0 0 0 34.033 -98.602 0.2 75.0 MAY 2014-05-07 18:06:00 OK 0 0 0 0 34.767 -98.697 1.5 400.0 MAY 2014-05-08 12:45:00 MO 0 0 0 0 36.7525 -93.9845 2.39 50.0 MAY 2014-05-08 14:15:00 TX 0 0 0 0 32.757 -96.889 0.46 120.0 MAY 2014-05-08 15:10:00 CO 0 0 0 0 39.08 -103.62 0.1 50.0 MAY 2014-05-08 15:27:00 CO 0 0 0 0 39.05 -103.57 0.1 50.0 MAY 2014-05-08 15:51:00 MN 0 0 0 0 43.9552 -94.6083 0.83 50.0 MAY 2014-05-08 16:09:00 MN 0 0 0 0 44.1073 -94.379 2.1 50.0 MAY 2014-05-08 16:10:00 MO 0 1 0 0 36.9964 -92.7143 2.5 100.0 MAY 2014-05-08 19:44:00 AR 0 1 0 0 35.3094 -93.1162 1.66 50.0 MAY 2014-05-10 11:47:00 ID 0 0 0 0 43.9914 -112.615 0.02 15.0 MAY 2014-05-10 14:07:00 AL 0 1 0 0 31.0012 -85.6421 2.15 100.0 MAY 2014-05-10 16:15:00 MO 0 2 0 0 39.2115 -94.1926 12.63 500.0 MAY 2014-05-10 17:00:00 MO 0 0 0 0 39.2118 -93.8694 0.64 25.0 MAY 2014-05-10 18:26:00 MO 0 1 0 0 39.1665 -93.172 7.27 1350.0 MAY 2014-05-10 19:16:00 KS 0 0 0 0 37.6598 -96.2804 0.08 75.0 MAY 2014-05-11 14:26:00 NE 0 0 0 0 40.3824 -98.2745 0.07 150.0 MAY 2014-05-11 14:50:00 NE 0 3 0 0 40.4926 -98.1207 20.21 1300.0 MAY 2014-05-11 15:24:00 IA 0 0 0 0 40.6059 -91.5592 0.1 30.0 MAY 2014-05-11 15:25:00 NE 0 2 0 0 40.6638 -97.7309 9.38 750.0 MAY 2014-05-11 15:25:00 NE 0 0 0 0 40.6185 -97.6994 0.04 100.0 MAY 2014-05-11 15:40:00 NE 0 1 0 0 40.6424 -97.5922 6.14 150.0 MAY 2014-05-11 15:57:00 NE 0 3 0 0 40.6922 -97.4531 19.14 2640.0 MAY 2014-05-11 16:04:00 NE 0 0 0 0 40.7501 -97.3875 0.61 25.0 MAY 2014-05-11 16:13:00 NE 0 0 0 0 40.79 -97.29 1.71 100.0 MAY 2014-05-11 16:23:00 NE 0 2 0 0 40.77 -97.2 7.96 500.0 MAY 2014-05-11 16:53:00 NE 0 2 0 0 40.872 -97.0351 4.67 330.0 MAY 2014-05-11 16:58:00 NE 0 1 0 0 40.7407 -97.3808 5.55 700.0 MAY 2014-05-11 17:07:00 NE 0 1 0 0 40.9211 -96.9135 3.0 400.0 MAY 2014-05-11 17:11:00 NE 0 2 0 0 40.97 -96.7955 2.5 300.0 MAY 2014-05-11 17:12:00 KS 0 1 0 0 38.1383 -99.2157 3.3 150.0 MAY 2014-05-11 17:20:00 NE 0 1 0 0 40.959 -96.7986 5.27 280.0 MAY 2014-05-11 17:42:00 NE 0 0 0 0 41.0609 -96.6082 1.8 200.0 MAY 2014-05-11 17:44:00 KS 0 0 0 0 37.8772 -99.4722 0.75 25.0 MAY 2014-05-11 17:55:00 NE 0 1 1 0 40.2988 -97.2741 15.5 500.0 MAY 2014-05-11 17:59:00 NE 0 1 0 0 41.1632 -96.3776 10.69 800.0 MAY 2014-05-11 18:21:00 NE 0 1 0 0 41.2989 -96.254 5.16 200.0 MAY 2014-05-11 18:32:00 SD 0 0 0 0 42.8713 -96.7332 2.4 50.0 MAY 2014-05-11 19:35:00 IA 0 1 0 0 43.0973 -96.0144 3.91 100.0 MAY 2014-05-11 19:44:00 KS 0 0 0 0 38.1762 -98.5622 3.43 50.0 MAY 2014-05-11 19:50:00 IA 0 0 0 0 43.1031 -95.9293 0.86 50.0 MAY 2014-05-11 19:59:00 IA 0 0 0 0 43.178 -95.814 0.49 50.0 MAY 2014-05-11 20:03:00 KS 0 0 0 0 37.5155 -98.9246 4.6 50.0 MAY 2014-05-11 20:12:00 KS 0 0 0 0 38.191 -98.2257 0.42 50.0 MAY 2014-05-11 20:20:00 KS 0 0 0 0 38.2345 -98.2205 1.02 50.0 MAY 2014-05-11 20:43:00 IA 0 2 0 0 41.6108 -94.5128 10.35 240.0 MAY 2014-05-11 20:51:00 KS 0 0 0 0 38.2951 -97.789 1.25 75.0 MAY 2014-05-11 20:54:00 KS 0 0 0 0 38.2239 -97.8003 0.68 50.0 MAY 2014-05-11 20:56:00 IA 0 1 0 0 41.7239 -94.4243 4.33 190.0 MAY 2014-05-11 21:05:00 KS 0 0 0 0 38.363 -97.6304 1.13 75.0 MAY 2014-05-11 21:21:00 IA 0 0 0 0 41.7351 -93.9776 5.91 100.0 MAY 2014-05-11 21:44:00 IA 0 0 0 0 41.9471 -93.7634 1.68 100.0 MAY 2014-05-12 17:45:00 OH 0 0 0 0 41.3474 -82.0332 1.08 100.0 MAY 2014-05-12 18:15:00 OH 0 0 0 0 41.086 -81.864 0.21 40.0 MAY 2014-05-14 12:23:00 KY 0 0 0 0 37.9318 -85.5882 1.5 50.0 MAY 2014-05-14 13:18:00 AL 0 0 0 0 31.9493 -85.7406 0.87 200.0 MAY 2014-05-14 13:21:00 AL 0 0 0 0 32.903 -85.9304 1.89 150.0 MAY 2014-05-14 14:28:00 AL 0 0 0 0 33.2496 -85.949 0.1 30.0 MAY 2014-05-14 14:30:00 NE 0 0 0 0 42.07 -103.24 0.78 30.0 MAY 2014-05-14 15:36:00 KY 0 2 0 0 36.9142 -87.4512 3.74 150.0 MAY 2014-05-14 15:44:00 OH 0 3 0 0 39.6808 -83.848 8.93 400.0 MAY 2014-05-14 21:49:00 GA 0 0 0 0 32.1861 -83.1767 1.72 100.0 MAY 2014-05-14 22:03:00 GA 0 1 0 0 34.3542 -83.5003 7.75 200.0 MAY 2014-05-15 04:46:00 NC 0 0 0 0 35.1297 -80.9008 0.5 40.0 MAY 2014-05-15 07:15:00 FL 0 1 0 0 30.1615 -82.7894 0.4 50.0 MAY 2014-05-15 12:29:00 FL 0 0 0 0 25.7858 -80.3288 0.27 30.0 MAY 2014-05-15 16:10:00 NC 0 1 0 0 35.9538 -78.9347 0.76 150.0 MAY 2014-05-15 17:03:00 PA 0 0 0 0 41.133 -77.431 0.32 100.0 MAY 2014-05-16 01:31:00 VA 0 0 0 0 38.9626 -77.6952 0.4 75.0 MAY 2014-05-18 17:50:00 MT 0 0 0 0 45.16 -105.16 0.1 25.0 MAY 2014-05-18 18:35:00 NE 0 0 0 0 42.01 -103.45 2.07 30.0 MAY 2014-05-18 19:20:00 NE 0 0 0 0 42.1 -103.15 6.18 30.0 MAY 2014-05-20 17:25:00 NE 0 0 0 0 41.9258 -103.924 0.68 25.0 MAY 2014-05-21 13:38:00 NV 0 0 0 0 40.8515 -115.741 0.23 25.0 MAY 2014-05-21 13:48:00 NV 0 0 0 0 40.8362 -115.783 0.26 125.0 MAY 2014-05-21 14:05:00 CO 0 0 0 0 39.7 -104.81 0.1 50.0 MAY 2014-05-21 14:30:00 CO 0 0 0 0 39.7607 -104.81 0.1 50.0 MAY 2014-05-21 14:45:00 CO 0 0 0 0 39.75 -104.6 0.1 50.0 MAY 2014-05-21 16:20:00 CO 0 0 0 0 39.73 -104.17 0.1 50.0 MAY 2014-05-21 17:06:00 CO 0 0 0 0 39.87 -104.04 0.1 50.0 MAY 2014-05-21 17:30:00 NV 0 0 0 0 40.21 -116.93 0.24 50.0 MAY 2014-05-21 18:40:00 ID 0 0 0 0 42.8465 -113.049 3.0 20.0 MAY 2014-05-21 19:15:00 WY 0 0 0 0 42.2021 -105.005 0.94 25.0 MAY 2014-05-22 12:45:00 CO 0 0 0 0 37.5979 -105.613 0.3 25.0 MAY 2014-05-22 13:33:00 NY 0 3 0 0 42.82 -74.19 6.79 440.0 MAY 2014-05-22 14:54:00 DE 0 1 2 0 39.098 -75.667 0.35 50.0 MAY 2014-05-22 15:45:00 VA 0 0 0 0 37.26 -77.24 0.69 25.0 MAY 2014-05-22 16:05:00 VA 0 0 0 0 37.78 -76.94 0.85 50.0 MAY 2014-05-22 16:20:00 VA 0 0 0 0 37.05 -77.1 1.38 100.0 MAY 2014-05-23 13:35:00 WY 0 0 0 0 42.7319 -106.423 2.0 40.0 MAY 2014-05-23 19:05:00 NM 0 0 0 0 32.2718 -103.467 3.65 200.0 MAY 2014-05-24 14:36:00 WY 0 0 0 0 44.9217 -108.443 0.77 20.0 MAY 2014-05-24 16:21:00 TX 0 0 0 0 30.9255 -101.836 0.12 50.0 MAY 2014-05-25 11:39:00 CO 0 0 0 0 38.9285 -105.267 0.08 25.0 MAY 2014-05-25 12:45:00 TX 0 0 0 0 30.3808 -102.874 1.16 200.0 MAY 2014-05-26 10:46:00 TX 0 0 0 0 30.0941 -97.4599 0.5 30.0 MAY 2014-05-26 11:50:00 ME 0 0 0 0 46.148 -67.992 0.23 180.0 MAY 2014-05-26 14:38:00 TX 0 0 0 0 32.4985 -102.105 0.6 200.0 MAY 2014-05-26 15:20:00 TX 0 0 0 0 28.0553 -97.6463 0.12 50.0 MAY 2014-05-26 16:38:00 TX 0 2 0 0 32.2946 -101.286 1.01 400.0 MAY 2014-05-26 16:52:00 TX 0 0 0 0 33.5125 -102.198 2.05 30.0 MAY 2014-05-26 16:57:00 TX 0 0 0 0 31.8935 -101.594 1.33 500.0 MAY 2014-05-26 17:26:00 TX 0 0 0 0 31.87 -101.381 0.67 200.0 MAY 2014-05-26 17:42:00 TX 0 0 0 0 31.8462 -101.355 0.79 300.0 MAY 2014-05-26 17:47:00 TX 0 0 0 0 31.72 -101.21 0.22 40.0 MAY 2014-05-26 18:46:00 ND 0 2 9 0 47.71 -103.28 0.46 100.0 MAY 2014-05-27 11:38:00 OK 0 0 0 0 35.6111 -96.0689 0.3 50.0 MAY 2014-05-27 12:55:00 OK 0 0 0 0 34.18 -97.6775 0.1 30.0 MAY 2014-05-27 13:00:00 OK 0 0 0 0 34.51 -98.49 0.12 50.0 MAY 2014-05-27 13:17:00 SD 0 1 0 0 44.113 -103.593 2.16 300.0 MAY 2014-05-27 17:30:00 TX 0 1 0 0 27.7519 -98.0538 2.34 550.0 MAY 2014-05-27 18:45:00 TX 0 1 0 0 27.3649 -98.1278 5.26 650.0 MAY 2014-05-28 04:32:00 LA 0 1 0 0 30.0389 -90.5975 2.55 75.0 MAY 2014-05-28 11:47:00 IL 0 0 0 0 40.3673 -88.7569 0.2 50.0 MAY 2014-05-28 12:40:00 IL 0 0 0 0 40.7632 -89.0007 0.61 100.0 MAY 2014-05-30 14:38:00 FL 0 0 0 0 26.73 -81.16 0.25 10.0 MAY 2014-05-30 14:45:00 FL 0 0 0 0 27.8175 -82.2657 0.45 50.0 MAY 2014-05-30 16:30:00 SD 0 0 0 0 44.604 -99.278 3.65 50.0 MAY 2014-05-30 16:44:00 SD 0 0 0 0 44.651 -99.312 1.77 50.0 MAY 2014-05-31 08:30:00 SC 0 0 0 0 32.6005 -80.0889 0.11 30.0 MAY 2014-05-31 13:34:00 WY 0 0 0 0 43.34 -110.006 0.32 30.0 MAY 2014-05-31 14:55:00 MT 0 0 0 0 46.73 -106.76 0.1 25.0 MAY 2014-05-31 19:15:00 MT 0 0 0 0 45.86 -105.68 0.1 25.0 MAY 2014-06-01 11:42:00 IA 0 0 0 0 43.3731 -93.931 1.08 25.0 JUNE 2014-06-01 16:43:00 KS 0 0 0 0 39.7684 -97.8971 0.09 50.0 JUNE 2014-06-01 17:12:00 KS 0 0 0 0 39.7145 -97.58 0.01 25.0 JUNE 2014-06-01 17:21:00 ND 0 0 0 0 46.85 -97.29 0.1 25.0 JUNE 2014-06-01 18:03:00 ND 0 0 0 0 46.98 -98.94 0.04 20.0 JUNE 2014-06-02 20:15:00 KY 0 1 0 0 37.0083 -88.5071 1.53 150.0 JUNE 2014-06-03 12:07:00 WY 0 0 0 0 43.7665 -108.864 2.21 30.0 JUNE 2014-06-03 15:18:00 NE 0 0 0 0 41.7341 -99.0582 1.15 50.0 JUNE 2014-06-03 16:01:00 NE 0 0 0 0 41.6372 -98.5321 0.01 25.0 JUNE 2014-06-03 16:02:00 IA 0 2 0 0 41.3174 -95.5606 2.81 680.0 JUNE 2014-06-03 19:20:00 KS 0 0 0 0 38.11 -101.26 0.7 50.0 JUNE 2014-06-03 21:30:00 KS 0 3 2 0 39.97 -96.0455 6.33 500.0 JUNE 2014-06-03 21:33:00 NE 0 1 0 0 40.9207 -97.903 4.12 700.0 JUNE 2014-06-03 22:24:00 KS 0 1 0 0 39.7204 -95.466 2.62 200.0 JUNE 2014-06-04 04:25:00 IL 0 0 0 0 39.1737 -90.3107 1.44 30.0 JUNE 2014-06-04 09:55:00 OH 0 0 0 0 38.6406 -83.2187 1.24 300.0 JUNE 2014-06-04 13:40:00 OH 0 0 0 0 39.1906 -83.8202 4.11 200.0 JUNE 2014-06-04 16:01:00 CO 0 0 0 0 39.76 -104.4 0.1 50.0 JUNE 2014-06-04 17:16:00 KY 0 1 0 0 37.5398 -87.9671 1.14 100.0 JUNE 2014-06-04 17:30:00 KY 0 1 0 0 37.504 -87.914 1.08 75.0 JUNE 2014-06-04 19:30:00 WV 0 1 0 0 38.478 -82.2242 0.51 400.0 JUNE 2014-06-04 20:15:00 CO 0 0 0 0 39.56 -103.58 0.1 50.0 JUNE 2014-06-04 22:15:00 CO 0 1 0 0 39.2971 -103.742 5.24 200.0 JUNE 2014-06-04 22:44:00 CO 0 0 0 0 39.17 -103.32 3.39 100.0 JUNE 2014-06-05 13:14:00 SD 0 0 0 0 43.63 -96.9 0.17 50.0 JUNE 2014-06-05 13:51:00 NE 0 1 0 0 42.1761 -96.5012 1.49 100.0 JUNE 2014-06-05 14:40:00 SD 0 0 0 0 43.41 -96.664 0.4 50.0 JUNE 2014-06-05 15:25:00 ND 0 0 0 0 46.0193 -97.9442 0.1 10.0 JUNE 2014-06-05 15:34:00 AL 0 1 0 0 34.7135 -86.9759 0.74 100.0 JUNE 2014-06-05 16:02:00 ND 0 0 0 0 46.7493 -97.3052 0.1 10.0 JUNE 2014-06-05 16:05:00 MN 0 0 0 0 43.71 -96.32 0.25 50.0 JUNE 2014-06-05 17:21:00 GA 0 0 0 0 34.6123 -84.5534 0.77 50.0 JUNE 2014-06-05 17:49:00 MN 0 0 0 0 43.92 -95.94 0.28 50.0 JUNE 2014-06-05 20:07:00 CO 0 0 0 0 38.1625 -102.975 0.42 50.0 JUNE 2014-06-06 12:05:00 NE 0 0 0 0 42.78 -102.16 0.2 40.0 JUNE 2014-06-06 13:00:00 NE 0 0 0 0 42.9425 -101.283 0.2 40.0 JUNE 2014-06-06 13:35:00 AR 0 1 2 0 35.7888 -91.6408 3.26 75.0 JUNE 2014-06-06 13:51:00 CO 0 1 1 0 37.1532 -104.411 8.58 400.0 JUNE 2014-06-06 13:55:00 NE 0 0 0 0 41.13 -103.89 0.91 25.0 JUNE 2014-06-06 13:56:00 CO 0 0 0 0 40.85 -104.27 0.1 50.0 JUNE 2014-06-06 14:00:00 AR 0 1 0 0 35.4034 -91.1282 2.03 50.0 JUNE 2014-06-06 14:20:00 CO 0 0 0 0 40.17 -104.33 0.5 100.0 JUNE 2014-06-06 14:46:00 CO 0 1 0 0 37.1889 -104.179 1.35 100.0 JUNE 2014-06-06 14:53:00 CO 0 0 0 0 40.82 -102.61 0.1 100.0 JUNE 2014-06-06 16:25:00 NM 0 0 0 0 36.51 -104.22 0.85 100.0 JUNE 2014-06-06 17:35:00 NM 0 0 0 0 34.4876 -103.335 1.24 50.0 JUNE 2014-06-06 17:47:00 KS 0 0 0 0 37.99 -101.22 0.51 25.0 JUNE 2014-06-06 17:58:00 KS 0 0 0 0 37.9843 -101.148 0.6 25.0 JUNE 2014-06-06 17:59:00 KS 0 0 0 0 38.01 -101.13 0.34 25.0 JUNE 2014-06-06 18:15:00 TX 0 0 0 0 35.6958 -102.513 2.46 25.0 JUNE 2014-06-06 18:46:00 SC 0 0 0 0 33.19 -80.96 0.83 40.0 JUNE 2014-06-06 18:52:00 TX 0 0 0 0 36.0816 -100.927 1.65 70.0 JUNE 2014-06-07 08:33:00 NM 0 0 0 0 36.25 -103.28 0.1 20.0 JUNE 2014-06-07 13:35:00 MO 0 0 0 0 38.3663 -91.4706 0.05 20.0 JUNE 2014-06-07 13:48:00 KY 0 1 0 0 36.5565 -89.4974 3.02 200.0 JUNE 2014-06-07 13:48:00 KY 0 1 0 0 36.5565 -89.4974 18.19 200.0 JUNE 2014-06-07 14:00:00 MO 0 1 0 0 36.5218 -89.4644 3.41 200.0 JUNE 2014-06-07 14:12:00 TN 0 1 0 0 36.4798 -89.4321 11.76 200.0 JUNE 2014-06-07 14:56:00 MO 0 0 0 0 38.7436 -90.6011 2.67 20.0 JUNE 2014-06-07 15:14:00 MO 0 0 0 0 38.7817 -90.4592 4.22 40.0 JUNE 2014-06-07 16:19:00 IL 0 0 0 0 38.1657 -90.218 0.34 40.0 JUNE 2014-06-07 16:43:00 IL 0 0 0 0 38.2023 -90.0563 0.3 30.0 JUNE 2014-06-07 16:58:00 NM 0 0 0 0 34.2557 -105.612 0.25 50.0 JUNE 2014-06-07 17:14:00 NM 0 0 0 0 34.2501 -105.639 0.1 50.0 JUNE 2014-06-07 19:25:00 NM 0 0 0 0 33.6912 -104.528 3.73 50.0 JUNE 2014-06-07 23:59:00 GA 0 0 0 0 33.0113 -85.1496 1.8 280.0 JUNE 2014-06-08 10:55:00 CO 0 1 0 0 39.113 -105.057 0.25 100.0 JUNE 2014-06-08 11:06:00 CO 0 0 0 0 39.1586 -104.921 0.1 50.0 JUNE 2014-06-08 12:32:00 CO 0 2 0 0 38.98 -105.445 6.0 150.0 JUNE 2014-06-08 12:54:00 CO 0 0 0 0 40.84 -104.23 0.1 50.0 JUNE 2014-06-08 12:58:00 CO 0 1 1 0 39.7 -104.81 0.25 100.0 JUNE 2014-06-08 13:00:00 CO 0 1 0 0 39.0196 -105.33 0.33 75.0 JUNE 2014-06-08 13:00:00 WY 0 0 0 0 41.0688 -104.255 0.54 25.0 JUNE 2014-06-08 13:12:00 CO 0 0 0 0 39.14 -104.82 0.1 50.0 JUNE 2014-06-08 13:17:00 CO 0 0 0 0 40.12 -104.34 0.1 50.0 JUNE 2014-06-08 13:43:00 CO 0 0 0 0 39.55 -104.32 0.1 50.0 JUNE 2014-06-08 13:43:00 CO 0 0 0 0 39.55 -104.32 0.1 50.0 JUNE 2014-06-08 14:23:00 NM 0 1 0 0 33.7 -105.381 1.75 160.0 JUNE 2014-06-08 15:45:00 NM 0 0 0 0 35.91 -104.83 2.82 50.0 JUNE 2014-06-08 16:35:00 NM 0 0 0 0 36.44 -104.59 1.39 50.0 JUNE 2014-06-08 16:40:00 NM 0 0 0 0 36.5019 -104.538 1.08 50.0 JUNE 2014-06-08 18:41:00 WV 0 1 0 0 39.456 -77.981 1.0 100.0 JUNE 2014-06-08 19:05:00 NM 0 0 0 0 32.35 -104.084 0.22 200.0 JUNE 2014-06-09 07:16:00 TX 0 0 0 0 33.5532 -94.8031 1.71 200.0 JUNE 2014-06-09 19:30:00 AL 0 1 0 0 34.5822 -87.5607 5.86 150.0 JUNE 2014-06-09 20:17:00 SC 0 0 0 0 33.3226 -80.5837 1.87 75.0 JUNE 2014-06-10 12:44:00 AL 0 1 0 0 34.6437 -86.0211 8.4 300.0 JUNE 2014-06-10 15:06:00 TN 0 0 0 0 35.88 -84.51 0.5 100.0 JUNE 2014-06-10 17:23:00 IN 0 0 0 0 38.9889 -86.94 0.5 25.0 JUNE 2014-06-11 12:14:00 ND 0 0 0 0 48.11 -98.81 0.4 30.0 JUNE 2014-06-11 15:54:00 KS 0 0 0 0 38.5212 -101.685 0.1 10.0 JUNE 2014-06-11 15:55:00 MI 0 1 0 0 43.24 -84.21 5.3 300.0 JUNE 2014-06-11 17:10:00 PA 0 1 0 0 40.02 -78.42 10.98 100.0 JUNE 2014-06-11 17:15:00 MN 0 1 0 0 46.5538 -94.9473 1.0 10.0 JUNE 2014-06-11 17:18:00 SD 0 1 0 0 45.6587 -97.6692 0.11 50.0 JUNE 2014-06-11 18:58:00 KS 0 1 0 0 38.7119 -101.098 0.1 25.0 JUNE 2014-06-11 19:20:00 TX 0 0 0 0 31.49 -100.39 0.69 50.0 JUNE 2014-06-11 19:24:00 TX 0 0 0 0 31.4479 -100.378 0.59 75.0 JUNE 2014-06-12 19:18:00 TX 0 0 0 0 30.9321 -98.0402 0.12 50.0 JUNE 2014-06-12 19:25:00 TX 0 2 0 0 30.8685 -98.0875 1.68 100.0 JUNE 2014-06-12 21:30:00 MS 0 1 1 0 34.0312 -88.8194 1.29 200.0 JUNE 2014-06-13 16:41:00 WY 0 2 1 0 44.714 -104.573 16.51 530.0 JUNE 2014-06-13 16:45:00 MT 0 0 0 0 48.43 -109.23 0.25 10.0 JUNE 2014-06-14 16:27:00 KS 0 1 0 0 39.4611 -99.4606 0.78 110.0 JUNE 2014-06-14 17:11:00 CO 0 0 0 0 39.56 -103.53 0.1 50.0 JUNE 2014-06-14 18:31:00 NE 0 0 0 0 40.2937 -99.0621 1.19 75.0 JUNE 2014-06-14 19:25:00 NE 0 0 0 0 40.0516 -98.6851 0.27 25.0 JUNE 2014-06-14 21:05:00 NE 0 0 0 0 40.7197 -98.2167 0.01 25.0 JUNE 2014-06-14 21:24:00 NE 0 0 0 0 40.7197 -98.2167 0.01 25.0 JUNE 2014-06-15 03:17:00 MO 0 0 0 0 38.7347 -94.5357 2.9 25.0 JUNE 2014-06-16 14:38:00 NE 0 0 0 0 41.8596 -97.3602 1.25 100.0 JUNE 2014-06-16 14:42:00 NE 0 4 0 0 41.893 -97.33 12.11 400.0 JUNE 2014-06-16 14:43:00 IA 0 0 0 0 43.37 -96.31 0.2 50.0 JUNE 2014-06-16 15:40:00 NE 0 4 0 0 42.127 -96.8686 15.84 530.0 JUNE 2014-06-16 16:41:00 NE 0 0 0 0 42.36 -96.59 0.26 50.0 JUNE 2014-06-16 16:44:00 IA 0 0 0 0 42.8956 -94.627 6.09 250.0 JUNE 2014-06-16 17:22:00 IA 0 0 0 0 42.7741 -94.1259 4.61 50.0 JUNE 2014-06-16 17:24:00 NE 0 0 0 0 41.7 -99.37 0.2 40.0 JUNE 2014-06-16 17:35:00 NE 0 1 0 0 41.758 -99.2362 2.4 400.0 JUNE 2014-06-16 17:48:00 IA 0 1 0 0 43.2062 -93.3101 3.03 110.0 JUNE 2014-06-16 17:52:00 IA 0 1 0 0 42.875 -93.5054 2.57 175.0 JUNE 2014-06-16 17:56:00 IA 0 0 0 0 43.2216 -93.2126 1.1 40.0 JUNE 2014-06-16 18:01:00 NE 0 2 0 0 41.8028 -99.1407 5.19 500.0 JUNE 2014-06-16 18:20:00 NE 0 2 0 0 41.8397 -98.9986 1.56 700.0 JUNE 2014-06-16 18:28:00 NE 0 2 0 0 41.8348 -98.9567 0.3 400.0 JUNE 2014-06-16 18:30:00 NE 0 0 0 0 41.8295 -98.9537 0.2 40.0 JUNE 2014-06-16 18:39:00 IA 0 1 0 0 42.7918 -92.823 4.71 100.0 JUNE 2014-06-16 18:45:00 IA 0 0 0 0 42.7831 -92.7498 1.72 150.0 JUNE 2014-06-16 18:52:00 IA 0 1 0 0 42.7849 -92.6323 2.12 120.0 JUNE 2014-06-16 19:12:00 IA 0 0 0 0 42.8134 -92.3349 2.0 75.0 JUNE 2014-06-16 20:23:00 ND 0 0 0 0 46.71 -102.9 1.35 25.0 JUNE 2014-06-16 20:30:00 IA 0 1 0 0 42.5412 -91.6484 1.31 50.0 JUNE 2014-06-16 20:33:00 IA 0 1 0 0 42.551 -91.609 12.59 50.0 JUNE 2014-06-16 21:05:00 IA 0 0 0 0 41.9792 -91.8728 0.07 30.0 JUNE 2014-06-16 21:45:00 WI 0 2 5 0 42.7376 -90.5188 3.76 100.0 JUNE 2014-06-16 21:49:00 WI 0 1 0 0 42.7521 -90.4731 0.49 25.0 JUNE 2014-06-16 22:00:00 WI 0 1 0 0 42.8054 -90.3731 4.35 200.0 JUNE 2014-06-16 22:00:00 WI 0 1 0 0 42.8119 -90.3672 1.17 50.0 JUNE 2014-06-16 22:10:00 WI 0 1 0 0 42.8208 -90.2636 0.41 100.0 JUNE 2014-06-16 22:36:00 WI 0 1 0 0 42.825 -89.7828 0.51 125.0 JUNE 2014-06-16 22:36:00 WI 0 1 0 0 42.8157 -89.7947 0.4 125.0 JUNE 2014-06-16 23:08:00 WI 0 3 0 0 43.0024 -89.5579 0.96 100.0 JUNE 2014-06-16 23:15:00 WI 0 2 0 0 43.0431 -89.4799 0.22 200.0 JUNE 2014-06-16 23:21:00 WI 0 1 0 0 43.0772 -89.3696 1.49 300.0 JUNE 2014-06-17 03:40:00 WI 0 1 0 0 42.5323 -89.6119 6.78 641.0 JUNE 2014-06-17 09:57:00 MI 0 1 0 0 44.3722 -83.8247 1.58 100.0 JUNE 2014-06-17 14:27:00 MT 0 3 0 0 45.4783 -104.183 10.0 880.0 JUNE 2014-06-17 15:54:00 MT 0 0 0 0 47.715 -106.704 0.07 15.0 JUNE 2014-06-17 16:40:00 NE 0 0 0 0 42.986 -101.876 0.2 40.0 JUNE 2014-06-17 16:40:00 NE 0 0 0 0 42.5845 -101.761 0.37 40.0 JUNE 2014-06-17 17:28:00 NE 0 0 0 0 42.5122 -101.709 0.73 40.0 JUNE 2014-06-17 18:00:00 NE 0 0 0 0 42.4255 -101.553 0.66 40.0 JUNE 2014-06-17 18:57:00 NE 0 1 0 0 42.5606 -97.3137 3.94 630.0 JUNE 2014-06-17 19:09:00 NE 0 3 0 0 42.5371 -97.2563 3.96 2059.0 JUNE 2014-06-17 19:39:00 NE 0 0 0 0 42.12 -101.15 0.2 20.0 JUNE 2014-06-17 20:03:00 NY 0 1 0 0 43.13 -75.58 11.0 250.0 JUNE 2014-06-17 20:07:00 NE 0 0 0 0 41.9607 -101.269 1.7 40.0 JUNE 2014-06-17 20:10:00 NE 0 1 0 0 42.5078 -97.0519 3.39 850.0 JUNE 2014-06-17 20:10:00 NE 0 0 0 0 42.516 -97.1589 1.29 100.0 JUNE 2014-06-17 20:28:00 NE 0 2 0 0 42.4822 -97.0599 0.94 200.0 JUNE 2014-06-17 20:45:00 NE 0 2 0 0 42.4988 -97.0407 7.81 850.0 JUNE 2014-06-17 21:44:00 SD 0 2 0 0 43.5975 -97.0583 3.37 400.0 JUNE 2014-06-17 22:27:00 IA 0 0 0 0 43.27 -96.0 0.3 50.0 JUNE 2014-06-18 00:15:00 IA 0 0 0 0 43.09 -95.33 0.2 50.0 JUNE 2014-06-18 06:27:00 WI 0 0 0 0 43.1564 -89.7122 0.16 30.0 JUNE 2014-06-18 17:05:00 SD 0 1 0 0 44.2509 -99.3672 0.73 40.0 JUNE 2014-06-18 17:07:00 SD 0 0 0 0 44.18 -99.28 2.0 400.0 JUNE 2014-06-18 17:45:00 SD 0 0 0 0 44.023 -98.939 0.65 250.0 JUNE 2014-06-18 17:58:00 SD 0 1 0 0 44.0487 -98.8351 0.67 50.0 JUNE 2014-06-18 18:00:00 SD 0 0 0 0 45.122 -98.995 1.17 75.0 JUNE 2014-06-18 18:00:00 SD 0 0 0 0 44.433 -99.268 0.21 75.0 JUNE 2014-06-18 18:01:00 SD 0 1 0 0 43.948 -98.7844 6.83 150.0 JUNE 2014-06-18 18:08:00 ND 0 0 0 0 45.99 -99.43 0.02 20.0 JUNE 2014-06-18 18:08:00 SD 0 2 0 0 44.0635 -98.8025 0.77 100.0 JUNE 2014-06-18 18:30:00 SD 0 2 1 0 44.0725 -98.573 2.22 200.0 JUNE 2014-06-18 18:43:00 SD 0 4 2 0 44.0372 -98.4032 11.5 880.0 JUNE 2014-06-18 18:45:00 SD 0 2 0 0 44.034 -98.8908 1.09 100.0 JUNE 2014-06-18 18:49:00 PA 0 0 0 0 41.1059 -79.2986 4.57 150.0 JUNE 2014-06-18 20:16:00 CO 0 0 0 0 40.38 -102.95 0.1 50.0 JUNE 2014-06-18 20:26:00 CO 0 0 0 0 40.3 -103.07 0.1 50.0 JUNE 2014-06-18 20:36:00 CO 0 0 0 0 40.23 -103.07 0.1 50.0 JUNE 2014-06-18 21:24:00 MN 0 0 0 0 44.48 -95.75 0.25 50.0 JUNE 2014-06-19 12:30:00 IA 0 0 0 0 43.15 -95.15 0.15 50.0 JUNE 2014-06-19 13:05:00 SD 0 0 0 0 44.6507 -102.093 0.1 10.0 JUNE 2014-06-19 13:45:00 SD 0 0 0 0 44.5591 -102.113 0.1 10.0 JUNE 2014-06-19 14:03:00 SD 0 0 0 0 44.36 -101.47 0.05 10.0 JUNE 2014-06-19 14:04:00 IA 0 1 0 0 42.4483 -91.3733 15.69 75.0 JUNE 2014-06-19 15:00:00 MN 0 0 0 0 45.3015 -95.7448 0.87 10.0 JUNE 2014-06-19 15:13:00 MN 0 0 0 0 45.2761 -95.6648 4.43 20.0 JUNE 2014-06-19 15:16:00 MN 0 0 0 0 45.7709 -95.7135 3.62 10.0 JUNE 2014-06-19 15:32:00 MN 0 0 0 0 45.3242 -95.5615 0.69 10.0 JUNE 2014-06-19 15:37:00 MN 0 0 0 0 45.0164 -95.5637 1.03 10.0 JUNE 2014-06-19 15:45:00 MN 0 0 0 0 44.9307 -95.4879 0.15 10.0 JUNE 2014-06-20 16:10:00 MN 0 0 0 0 46.4134 -95.6082 0.3 20.0 JUNE 2014-06-21 13:28:00 NM 0 0 0 0 35.0401 -106.07 0.1 30.0 JUNE 2014-06-21 14:36:00 CO 0 1 0 0 40.0 -104.64 0.25 100.0 JUNE 2014-06-21 14:42:00 CO 0 0 0 0 39.8 -104.59 0.1 50.0 JUNE 2014-06-21 15:11:00 CO 0 0 0 0 39.8 -104.42 0.1 50.0 JUNE 2014-06-21 17:43:00 KS 0 0 0 0 38.07 -101.75 0.49 25.0 JUNE 2014-06-21 18:45:00 SD 0 0 0 0 45.3 -100.89 0.28 20.0 JUNE 2014-06-21 19:35:00 MN 0 1 0 0 47.63 -96.4411 2.0 300.0 JUNE 2014-06-22 16:42:00 OK 0 0 0 0 36.6354 -100.272 2.01 100.0 JUNE 2014-06-22 17:03:00 OK 0 1 0 0 36.6286 -100.396 3.77 150.0 JUNE 2014-06-22 17:31:00 OK 0 0 0 0 36.5151 -100.4 0.44 50.0 JUNE 2014-06-22 17:57:00 TX 0 0 0 0 36.4234 -100.416 2.0 50.0 JUNE 2014-06-22 18:06:00 CO 0 0 0 0 40.4 -104.12 0.1 50.0 JUNE 2014-06-22 18:22:00 TX 0 0 0 0 36.3226 -100.335 1.0 75.0 JUNE 2014-06-22 20:50:00 TX 0 1 0 0 35.9433 -100.558 1.86 100.0 JUNE 2014-06-23 12:30:00 SC 0 0 0 0 32.4281 -80.6726 0.01 50.0 JUNE 2014-06-23 16:22:00 IL 0 0 0 0 38.3579 -88.4382 2.89 200.0 JUNE 2014-06-23 16:26:00 IL 0 0 0 0 38.3662 -88.4126 1.8 150.0 JUNE 2014-06-23 16:55:00 OH 0 1 0 0 41.2301 -81.8305 1.72 120.0 JUNE 2014-06-23 18:59:00 OK 0 0 0 0 34.8701 -95.5599 0.5 50.0 JUNE 2014-06-24 11:15:00 IN 0 0 0 0 39.4104 -86.7271 0.5 75.0 JUNE 2014-06-24 11:30:00 IN 0 1 0 0 39.4986 -86.6312 0.25 75.0 JUNE 2014-06-24 12:32:00 IN 0 1 0 0 39.7257 -86.3496 2.84 75.0 JUNE 2014-06-25 14:00:00 WI 0 0 0 0 42.74 -89.44 0.33 30.0 JUNE 2014-06-25 15:14:00 TX 0 0 0 0 28.3177 -97.2761 0.37 50.0 JUNE 2014-06-25 18:05:00 WY 0 1 0 0 44.572 -104.62 5.92 100.0 JUNE 2014-06-26 13:22:00 TX 0 0 1 0 29.3369 -94.9646 0.04 75.0 JUNE 2014-06-26 16:55:00 WY 0 0 0 0 44.053 -105.689 0.33 30.0 JUNE 2014-06-27 10:07:00 TX 0 0 0 0 30.1343 -94.9272 0.01 20.0 JUNE 2014-06-27 10:24:00 TX 0 0 0 0 30.35 -94.9994 0.03 25.0 JUNE 2014-06-27 12:46:00 LA 0 0 0 0 30.0599 -92.8295 4.62 300.0 JUNE 2014-06-27 13:36:00 FL 0 0 0 0 26.5491 -82.0206 1.24 20.0 JUNE 2014-06-27 14:03:00 WI 0 1 0 0 44.9294 -91.7668 7.02 100.0 JUNE 2014-06-27 14:18:00 CO 0 0 0 0 38.5737 -103.057 2.14 100.0 JUNE 2014-06-27 16:40:00 KS 0 0 0 0 39.3 -101.54 1.0 25.0 JUNE 2014-06-27 16:44:00 KS 0 0 0 0 39.29 -101.38 2.0 25.0 JUNE 2014-06-28 13:25:00 TX 0 0 0 0 29.8018 -95.4824 0.73 10.0 JUNE 2014-06-28 14:22:00 OK 0 0 0 0 36.4323 -95.2831 4.3 400.0 JUNE 2014-06-29 05:05:00 KS 0 1 0 0 38.82 -100.56 1.0 50.0 JUNE 2014-06-29 18:28:00 IA 0 0 0 0 42.302 -93.7356 1.99 40.0 JUNE 2014-06-29 19:08:00 IA 0 0 0 0 41.7182 -95.5114 0.5 50.0 JUNE 2014-06-29 19:18:00 IA 0 1 0 0 42.3471 -92.6911 1.9 50.0 JUNE 2014-06-29 19:25:00 IA 0 1 0 0 42.268 -93.0937 1.27 75.0 JUNE 2014-06-29 20:12:00 MO 0 0 0 0 39.5627 -95.0526 0.25 25.0 JUNE 2014-06-29 20:20:00 KS 0 0 0 0 39.0807 -95.6889 1.63 30.0 JUNE 2014-06-29 20:55:00 MO 0 1 0 0 40.3532 -93.4855 6.31 300.0 JUNE 2014-06-29 21:00:00 WI 0 1 0 0 42.9988 -90.6404 8.18 600.0 JUNE 2014-06-29 21:18:00 WI 0 2 0 0 43.0123 -90.4216 29.07 400.0 JUNE 2014-06-29 21:26:00 WI 0 2 0 0 42.9705 -90.2243 5.05 200.0 JUNE 2014-06-29 21:36:00 IA 0 0 0 0 42.09 -90.96 0.1 25.0 JUNE 2014-06-29 22:27:00 WI 0 1 0 0 42.9541 -89.3773 2.32 500.0 JUNE 2014-06-29 23:30:00 IL 0 1 0 0 41.9613 -90.1153 2.24 600.0 JUNE 2014-06-29 23:45:00 MO 0 1 0 0 40.4616 -92.5177 4.74 300.0 JUNE 2014-06-30 11:42:00 IA 0 1 0 0 41.4638 -94.4672 7.12 200.0 JUNE 2014-06-30 12:02:00 IA 0 1 0 0 42.1635 -93.2637 7.54 460.0 JUNE 2014-06-30 12:13:00 IA 0 1 0 0 41.4042 -93.9532 1.34 75.0 JUNE 2014-06-30 12:15:00 IA 0 1 0 0 42.1714 -93.1434 11.01 190.0 JUNE 2014-06-30 12:15:00 IA 0 1 0 0 41.3993 -93.9163 6.38 400.0 JUNE 2014-06-30 12:27:00 IA 0 1 0 0 41.3891 -93.7385 2.03 190.0 JUNE 2014-06-30 13:02:00 IA 0 2 0 0 42.2117 -92.5253 3.7 150.0 JUNE 2014-06-30 13:27:00 IA 0 1 0 0 42.2264 -91.9131 0.43 75.0 JUNE 2014-06-30 15:40:00 MO 0 0 0 0 40.4369 -94.7211 3.52 200.0 JUNE 2014-06-30 17:20:00 CO 0 0 0 0 37.3612 -102.656 0.27 50.0 JUNE 2014-06-30 17:43:00 MO 0 1 0 0 40.3844 -94.3019 2.15 300.0 JUNE 2014-06-30 18:53:00 MO 0 0 0 0 40.1551 -93.9938 2.99 200.0 JUNE 2014-06-30 20:16:00 IL 0 1 0 0 41.5886 -88.9526 1.51 50.0 JUNE 2014-06-30 20:34:00 MO 0 1 0 0 39.2136 -94.3742 0.8 200.0 JUNE 2014-06-30 20:38:00 IL 0 1 0 0 41.4817 -88.5843 1.15 50.0 JUNE 2014-06-30 20:44:00 IL 0 0 0 0 41.4411 -88.4692 2.16 50.0 JUNE 2014-06-30 20:55:00 IL 0 1 0 0 41.6272 -88.1846 3.06 75.0 JUNE 2014-06-30 21:25:00 IL 0 1 0 0 41.2556 -87.7816 4.07 200.0 JUNE 2014-06-30 21:25:00 IL 0 1 0 0 41.2491 -87.7427 8.69 150.0 JUNE 2014-06-30 21:26:00 IL 0 1 0 0 41.2639 -87.7219 3.05 300.0 JUNE 2014-06-30 21:29:00 IL 0 1 0 0 41.2005 -87.6639 2.15 225.0 JUNE 2014-06-30 21:31:00 IL 0 1 0 0 41.1867 -87.6391 3.09 150.0 JUNE 2014-06-30 21:32:00 IL 0 1 0 0 41.2651 -87.5685 2.35 200.0 JUNE 2014-06-30 21:32:00 IL 0 1 0 0 41.2651 -87.5685 3.4 200.0 JUNE 2014-06-30 21:33:00 IL 0 1 0 0 41.2624 -87.554 1.66 100.0 JUNE 2014-06-30 21:35:00 IN 0 1 0 0 41.2782 -87.5267 1.05 200.0 JUNE 2014-06-30 21:35:00 IN 0 1 0 0 41.1863 -87.5263 6.24 300.0 JUNE 2014-06-30 21:38:00 IN 0 1 0 0 41.2609 -87.4869 9.92 500.0 JUNE 2014-06-30 21:39:00 IN 0 1 0 0 41.2537 -87.4601 2.57 250.0 JUNE 2014-06-30 21:39:00 IN 0 1 0 0 41.2784 -87.4677 2.01 150.0 JUNE 2014-06-30 21:42:00 IN 0 1 0 0 41.1918 -87.4071 3.85 300.0 JUNE 2014-06-30 21:49:00 IN 0 1 0 0 41.1888 -87.2757 6.26 200.0 JUNE 2014-06-30 21:55:00 IN 0 1 0 0 41.223 -87.128 0.94 100.0 JUNE 2014-06-30 22:11:00 IN 0 1 0 0 41.5625 -86.858 0.26 200.0 JUNE 2014-06-30 22:24:00 IN 0 1 0 0 41.4787 -86.6837 4.72 200.0 JUNE 2014-06-30 22:25:00 IN 0 1 0 0 41.4189 -86.6409 4.93 400.0 JUNE 2014-06-30 22:29:00 IN 0 1 0 0 41.4187 -86.5304 4.85 400.0 JUNE 2014-06-30 22:35:00 IN 0 1 0 0 41.346 -86.4435 6.85 150.0 JUNE 2014-06-30 22:41:00 IN 0 1 0 0 41.361 -86.2893 0.16 50.0 JUNE 2014-06-30 23:06:00 IN 0 1 0 0 41.1979 -85.9217 0.55 150.0 JUNE 2014-06-30 23:06:00 IN 0 0 0 0 41.4124 -85.9189 1.79 50.0 JUNE 2014-06-30 23:08:00 IN 0 1 0 0 41.0314 -85.8965 7.01 150.0 JUNE 2014-06-30 23:22:00 IN 0 1 0 0 41.0516 -85.6567 0.45 50.0 JUNE 2014-06-30 23:38:00 IN 0 1 0 0 41.6414 -85.4396 0.93 50.0 JUNE 2014-07-02 16:00:00 TX 0 0 0 0 33.1018 -99.613 0.22 50.0 JULY 2014-07-03 14:36:00 NC 0 1 0 0 34.805 -78.009 0.77 200.0 JULY 2014-07-03 18:50:00 NC 0 1 0 0 35.9565 -77.2038 1.13 100.0 JULY 2014-07-03 21:25:00 NC 0 0 0 0 36.34 -76.98 0.9 30.0 JULY 2014-07-03 23:15:00 VA 0 0 0 0 36.88 -76.08 0.31 30.0 JULY 2014-07-03 23:40:00 VA 0 0 0 0 36.92 -76.27 0.25 30.0 JULY 2014-07-04 18:00:00 NH 0 0 0 0 43.5868 -71.3521 0.36 10.0 JULY 2014-07-06 12:42:00 FL 0 0 0 0 28.6506 -80.8433 0.09 35.0 JULY 2014-07-06 17:03:00 IA 0 0 0 0 42.3244 -93.6873 0.55 25.0 JULY 2014-07-06 18:00:00 IA 0 0 0 0 42.6341 -92.8757 0.4 15.0 JULY 2014-07-06 18:58:00 IA 0 1 0 0 42.3327 -92.6384 3.21 100.0 JULY 2014-07-06 19:02:00 MI 0 0 0 0 46.3605 -88.181 5.65 100.0 JULY 2014-07-06 19:08:00 IA 0 0 0 0 42.2975 -92.5902 1.47 20.0 JULY 2014-07-06 19:12:00 IA 0 1 0 0 42.2878 -92.5499 9.68 225.0 JULY 2014-07-06 19:25:00 ND 0 0 0 0 48.028 -102.742 3.77 40.0 JULY 2014-07-06 19:41:00 IA 0 0 0 0 41.5155 -94.2749 0.94 20.0 JULY 2014-07-06 19:45:00 IA 0 0 0 0 41.8202 -93.0568 4.63 80.0 JULY 2014-07-06 19:56:00 IA 0 0 0 0 42.09 -92.25 0.1 10.0 JULY 2014-07-06 20:15:00 IA 0 0 0 0 41.7245 -92.9674 0.52 25.0 JULY 2014-07-06 20:20:00 MI 0 1 6 0 42.85 -85.7 6.25 400.0 JULY 2014-07-06 22:16:00 MI 0 0 0 0 42.94 -84.98 1.0 50.0 JULY 2014-07-06 22:34:00 MI 0 0 0 0 42.9858 -84.9056 0.75 150.0 JULY 2014-07-06 23:00:00 MI 0 0 0 0 43.02 -84.65 1.6 80.0 JULY 2014-07-07 17:40:00 KY 0 0 0 0 38.7711 -84.9331 0.47 200.0 JULY 2014-07-07 17:43:00 MN 0 0 0 0 44.8051 -92.8079 1.3 50.0 JULY 2014-07-07 17:43:00 MN 0 0 0 0 44.8051 -92.8079 2.59 50.0 JULY 2014-07-07 17:46:00 WI 0 0 0 0 44.7987 -92.7831 1.29 50.0 JULY 2014-07-08 11:33:00 OH 0 1 0 0 41.2422 -82.003 8.3 200.0 JULY 2014-07-08 11:43:00 OH 0 1 0 0 41.2702 -81.7612 1.57 200.0 JULY 2014-07-08 12:15:00 OH 0 0 0 0 41.0243 -80.8262 5.39 200.0 JULY 2014-07-08 12:48:00 PA 0 1 0 0 41.1977 -80.3272 2.46 150.0 JULY 2014-07-08 13:25:00 WV 0 1 0 0 39.53 -80.06 2.24 50.0 JULY 2014-07-08 13:55:00 WV 0 1 0 0 39.3729 -80.0405 4.41 150.0 JULY 2014-07-08 16:15:00 PA 0 2 0 0 41.55 -76.48 6.68 500.0 JULY 2014-07-08 16:33:00 NY 0 1 0 0 43.2 -75.6 1.0 600.0 JULY 2014-07-08 16:48:00 NY 0 1 0 0 43.778 -75.5766 12.32 300.0 JULY 2014-07-08 17:00:00 PA 0 0 0 0 41.23 -76.23 0.9 50.0 JULY 2014-07-08 17:05:00 PA 0 1 0 0 41.75 -75.74 1.4 150.0 JULY 2014-07-08 17:25:00 NY 0 1 0 0 43.12 -75.22 1.3 65.0 JULY 2014-07-08 18:40:00 NY 0 0 0 0 43.6905 -73.9874 1.09 100.0 JULY 2014-07-10 13:35:00 VA 0 0 10 0 36.8432 -75.9763 0.34 30.0 JULY 2014-07-12 11:20:00 FL 0 0 0 0 27.2367 -80.757 0.08 15.0 JULY 2014-07-12 14:45:00 CO 0 0 0 0 38.5867 -104.476 0.53 50.0 JULY 2014-07-12 20:20:00 IL 0 0 0 0 41.2584 -90.7362 0.38 50.0 JULY 2014-07-12 20:30:00 IL 0 1 0 0 41.2674 -90.6666 3.7 100.0 JULY 2014-07-12 20:46:00 IL 0 1 0 0 41.2387 -90.5289 2.78 50.0 JULY 2014-07-12 21:00:00 IL 0 1 0 0 41.2141 -90.4256 0.66 50.0 JULY 2014-07-13 13:40:00 WY 0 0 0 0 41.14 -104.628 0.17 25.0 JULY 2014-07-13 14:34:00 NY 0 1 0 0 42.43 -76.93 3.5 125.0 JULY 2014-07-13 15:09:00 NE 0 0 0 0 41.1142 -103.66 0.14 25.0 JULY 2014-07-13 17:37:00 WV 0 0 0 0 39.3996 -78.1886 0.07 50.0 JULY 2014-07-13 18:30:00 NY 0 1 0 0 41.85 -74.77 0.75 270.0 JULY 2014-07-14 11:40:00 CO 0 0 0 0 38.2166 -102.497 0.37 75.0 JULY 2014-07-15 16:52:00 ME 0 1 0 0 44.9107 -69.4075 2.75 800.0 JULY 2014-07-16 18:08:00 TX 0 0 0 0 36.3478 -102.054 0.01 50.0 JULY 2014-07-16 18:26:00 TX 0 0 0 0 36.3128 -102.053 1.34 100.0 JULY 2014-07-16 19:23:00 TX 0 0 0 0 36.0292 -102.084 3.07 100.0 JULY 2014-07-21 12:35:00 TX 0 0 0 0 29.3788 -94.9056 0.1 20.0 JULY 2014-07-21 18:35:00 ND 0 0 0 0 47.62 -98.59 9.08 100.0 JULY 2014-07-21 18:47:00 ND 0 0 0 0 47.78 -98.52 0.01 20.0 JULY 2014-07-21 19:29:00 ND 0 1 0 0 47.82 -97.57 8.0 300.0 JULY 2014-07-21 19:52:00 MN 0 2 0 0 47.7 -96.86 37.92 800.0 JULY 2014-07-23 17:26:00 MS 0 0 0 0 32.429 -90.0285 0.7 25.0 JULY 2014-07-24 06:25:00 VA 0 1 5 0 37.2893 -76.071 7.69 150.0 JULY 2014-07-24 06:30:00 NH 0 0 0 0 43.687 -71.3051 0.02 10.0 JULY 2014-07-24 15:59:00 FL 0 0 0 0 28.4592 -80.992 0.25 15.0 JULY 2014-07-24 19:19:00 MT 0 0 0 0 46.99 -104.27 1.0 100.0 JULY 2014-07-25 14:24:00 FL 0 1 0 0 28.9807 -80.9281 1.69 75.0 JULY 2014-07-27 10:50:00 CT 0 0 0 0 41.6055 -72.9833 0.72 100.0 JULY 2014-07-27 13:29:00 OH 0 0 0 0 40.1236 -83.6134 0.07 50.0 JULY 2014-07-27 14:24:00 KY 0 1 0 0 36.9573 -83.3506 2.0 900.0 JULY 2014-07-27 14:55:00 MA 0 1 0 0 42.453 -73.1858 0.25 20.0 JULY 2014-07-27 15:05:00 ME 0 0 0 0 43.8971 -70.587 0.63 10.0 JULY 2014-07-27 15:45:00 TN 0 1 0 0 36.462 -82.56 0.5 50.0 JULY 2014-07-27 15:47:00 TN 0 0 0 0 36.4477 -82.5498 7.1 300.0 JULY 2014-07-27 15:58:00 TN 0 3 0 0 36.4695 -83.9766 4.66 800.0 JULY 2014-07-27 17:14:00 WV 0 1 0 0 39.3366 -81.1412 4.1 200.0 JULY 2014-07-27 18:05:00 WI 0 0 0 0 43.948 -88.495 0.01 10.0 JULY 2014-07-27 18:39:00 OH 0 0 0 0 39.186 -83.6645 2.52 1300.0 JULY 2014-07-27 18:50:00 WV 0 1 0 0 39.1202 -80.2948 1.07 50.0 JULY 2014-07-28 07:32:00 MA 0 2 2 0 42.398 -71.0219 1.93 660.0 JULY 2014-07-28 13:49:00 ME 0 1 0 0 43.66 -70.68 1.71 80.0 JULY 2014-07-28 15:53:00 CO 0 0 0 0 40.06 -104.8 0.1 50.0 JULY 2014-07-28 16:09:00 CO 0 0 0 0 39.83 -104.79 0.1 50.0 JULY 2014-07-31 14:10:00 NV 0 0 0 0 40.9837 -116.383 0.48 7.0 JULY 2014-07-31 17:10:00 MT 0 0 0 0 48.48 -108.37 0.1 5.0 JULY 2014-08-04 13:40:00 NV 0 0 0 0 35.83 -114.87 0.08 25.0 AUGUST 2014-08-06 18:10:00 CO 0 0 0 0 39.76 -104.42 0.1 50.0 AUGUST 2014-08-09 14:45:00 KS 0 0 0 0 39.8176 -101.878 0.5 10.0 AUGUST 2014-08-09 14:57:00 KS 0 0 0 0 39.6848 -101.693 0.25 10.0 AUGUST 2014-08-09 15:30:00 SD 0 0 0 0 44.7104 -96.4848 0.83 20.0 AUGUST 2014-08-09 15:55:00 KS 0 0 0 0 39.62 -101.63 0.25 10.0 AUGUST 2014-08-11 12:46:00 WI 0 0 0 0 46.5843 -90.9227 0.05 3.0 AUGUST 2014-08-11 13:00:00 OH 0 0 0 0 40.15 -82.056 0.16 25.0 AUGUST 2014-08-12 09:15:00 OH 0 0 0 0 40.1753 -82.6321 0.09 20.0 AUGUST 2014-08-13 19:30:00 WA 0 0 0 0 46.32 -119.8 0.25 15.0 AUGUST 2014-08-15 11:55:00 FL 0 0 0 0 27.52 -80.3563 0.15 15.0 AUGUST 2014-08-15 14:39:00 AZ 0 0 0 0 32.2659 -109.999 0.79 50.0 AUGUST 2014-08-16 14:33:00 FL 0 0 0 0 26.42 -80.27 0.37 10.0 AUGUST 2014-08-17 15:33:00 KY 0 1 0 0 37.7191 -87.5226 1.65 60.0 AUGUST 2014-08-17 16:31:00 KY 0 0 0 0 37.3 -87.0154 0.59 125.0 AUGUST 2014-08-17 18:00:00 IA 0 0 0 0 43.4287 -94.6202 0.83 25.0 AUGUST 2014-08-18 15:23:00 WI 0 0 0 0 44.2299 -88.6176 2.06 50.0 AUGUST 2014-08-20 12:04:00 MI 0 0 0 0 42.7729 -82.8373 0.29 100.0 AUGUST 2014-08-20 13:45:00 ID 0 0 0 0 43.8995 -113.592 0.1 5.0 AUGUST 2014-08-21 04:20:00 MN 0 0 0 0 44.04 -94.92 0.1 50.0 AUGUST 2014-08-21 14:25:00 PA 0 0 0 0 41.09 -78.99 0.54 20.0 AUGUST 2014-08-21 14:27:00 PA 0 0 0 0 41.07 -79.01 5.36 50.0 AUGUST 2014-08-23 16:30:00 SD 0 0 0 0 45.18 -99.11 2.13 10.0 AUGUST 2014-08-23 16:35:00 SD 0 0 0 0 45.18 -99.13 4.4 15.0 AUGUST 2014-08-23 17:31:00 SD 0 1 0 0 45.48 -98.98 1.46 10.0 AUGUST 2014-08-24 16:47:00 MN 0 0 0 0 45.7971 -93.9829 5.67 150.0 AUGUST 2014-08-25 17:40:00 CO 0 0 0 0 38.374 -105.139 0.96 75.0 AUGUST 2014-08-28 16:30:00 KS 0 0 0 0 39.2132 -98.9165 0.1 25.0 AUGUST 2014-08-28 17:30:00 KS 0 1 0 0 38.72 -98.92 2.0 220.0 AUGUST 2014-08-28 17:44:00 SD 0 0 0 0 43.04 -97.38 3.74 50.0 AUGUST 2014-08-31 18:10:00 MA 0 0 0 0 42.24 -71.8 2.06 176.0 AUGUST 2014-08-31 18:57:00 IA 0 0 0 0 42.1122 -94.6781 1.9 60.0 AUGUST 2014-08-31 19:36:00 IA 0 1 0 0 42.3072 -94.0661 3.32 40.0 AUGUST 2014-09-01 11:47:00 MI 0 1 0 0 44.8064 -85.0215 4.02 125.0 SEPTEMBER 2014-09-01 12:16:00 MI 0 1 0 0 44.7577 -84.7721 9.14 75.0 SEPTEMBER 2014-09-01 12:42:00 MI 0 1 0 0 44.9133 -84.5127 7.21 210.0 SEPTEMBER 2014-09-01 12:43:00 MI 0 0 0 0 45.227 -84.548 0.67 30.0 SEPTEMBER 2014-09-01 18:41:00 OK 0 0 0 0 36.9279 -95.1 0.2 50.0 SEPTEMBER 2014-09-01 19:01:00 KS 0 0 0 0 37.1237 -96.7113 3.69 100.0 SEPTEMBER 2014-09-01 19:25:00 KS 0 1 0 0 37.0552 -96.5181 7.4 100.0 SEPTEMBER 2014-09-01 21:43:00 MO 0 1 0 0 38.4299 -90.6635 6.4 60.0 SEPTEMBER 2014-09-01 22:13:00 MO 0 1 0 0 37.0272 -94.4483 2.22 100.0 SEPTEMBER 2014-09-01 22:14:00 MO 0 1 0 0 37.0257 -94.427 2.7 400.0 SEPTEMBER 2014-09-01 22:36:00 MO 0 0 0 0 37.0137 -94.1192 1.24 100.0 SEPTEMBER 2014-09-02 13:09:00 LA 0 1 0 0 32.1474 -93.5826 6.04 350.0 SEPTEMBER 2014-09-02 17:10:00 NY 0 1 0 0 42.1044 -76.7103 6.0 150.0 SEPTEMBER 2014-09-02 18:32:00 NY 0 1 0 0 42.1375 -75.36 0.1 50.0 SEPTEMBER 2014-09-04 02:26:00 ND 0 0 0 0 46.79 -98.09 1.05 30.0 SEPTEMBER 2014-09-04 03:17:00 ND 0 1 0 0 46.65 -97.25 11.64 250.0 SEPTEMBER 2014-09-04 03:48:00 MN 0 2 0 0 46.5 -96.27 2.7 200.0 SEPTEMBER 2014-09-04 04:42:00 MN 0 1 0 0 46.49 -95.39 2.0 250.0 SEPTEMBER 2014-09-06 12:39:00 LA 0 0 0 0 29.9401 -92.7596 0.01 10.0 SEPTEMBER 2014-09-07 12:27:00 SC 0 0 0 0 33.4296 -80.3952 0.43 30.0 SEPTEMBER 2014-09-08 14:45:00 NC 0 2 1 0 34.828 -77.902 0.15 100.0 SEPTEMBER 2014-09-09 15:29:00 NE 0 1 0 0 40.6237 -95.9883 7.72 965.0 SEPTEMBER 2014-09-09 16:50:00 MO 0 0 0 0 40.4411 -95.4534 4.89 25.0 SEPTEMBER 2014-09-09 18:10:00 MO 0 0 0 0 40.2017 -95.0852 3.04 30.0 SEPTEMBER 2014-09-09 18:35:00 MO 0 0 0 0 40.1757 -95.1212 0.08 25.0 SEPTEMBER 2014-09-09 18:40:00 MO 0 0 0 0 40.1853 -95.108 0.11 25.0 SEPTEMBER 2014-09-09 20:10:00 MO 0 0 0 0 38.7557 -90.5923 1.69 25.0 SEPTEMBER 2014-09-09 21:22:00 MO 0 0 0 0 39.9877 -94.3508 0.75 25.0 SEPTEMBER 2014-09-10 01:40:00 MO 0 1 0 0 40.17 -92.74 18.27 20.0 SEPTEMBER 2014-09-10 15:22:00 OH 0 0 0 0 41.17 -81.4 0.47 50.0 SEPTEMBER 2014-09-10 15:29:00 OH 0 0 0 0 41.191 -81.377 0.96 50.0 SEPTEMBER 2014-09-10 15:34:00 OH 0 0 0 0 41.202 -81.299 0.1 20.0 SEPTEMBER 2014-09-10 15:54:00 OH 0 0 0 0 41.335 -81.185 0.76 50.0 SEPTEMBER 2014-09-17 14:38:00 AR 0 0 0 0 35.9894 -92.9662 2.73 250.0 SEPTEMBER 2014-09-19 17:19:00 MN 0 2 0 0 48.86 -97.02 10.0 500.0 SEPTEMBER 2014-09-19 18:21:00 MN 0 1 0 0 48.7 -96.38 7.0 300.0 SEPTEMBER 2014-09-20 18:00:00 NV 0 0 0 0 39.07 -116.51 0.4 20.0 SEPTEMBER 2014-09-21 03:47:00 MI 0 1 0 0 42.7 -83.19 1.23 150.0 SEPTEMBER 2014-09-27 14:55:00 AZ 0 0 0 0 34.465 -112.411 2.1 700.0 SEPTEMBER 2014-09-29 16:25:00 NM 0 1 0 0 36.9028 -106.813 2.26 700.0 SEPTEMBER 2014-09-29 16:25:00 NM 0 1 0 0 36.9028 -106.813 2.26 700.0 SEPTEMBER 2014-09-30 15:45:00 SD 0 0 0 0 45.89 -99.25 0.3 10.0 SEPTEMBER 2014-10-02 19:24:00 AR 0 1 0 0 34.5317 -92.1162 12.71 300.0 OCTOBER 2014-10-02 19:55:00 AR 0 1 0 0 34.6272 -91.5553 4.08 200.0 OCTOBER 2014-10-02 20:28:00 AR 0 0 0 0 35.5725 -90.9038 0.7 33.0 OCTOBER 2014-10-02 23:10:00 KY 0 1 0 0 36.8302 -88.3529 0.38 125.0 OCTOBER 2014-10-03 00:15:00 KY 0 1 0 0 36.8523 -87.5913 1.36 110.0 OCTOBER 2014-10-03 02:12:00 AL 0 0 0 0 34.6881 -86.7267 0.7 250.0 OCTOBER 2014-10-03 03:02:00 AL 0 0 0 0 34.401 -86.149 0.48 75.0 OCTOBER 2014-10-06 00:01:00 OK 0 1 0 0 35.2508 -94.7246 0.8 75.0 OCTOBER 2014-10-06 17:02:00 KY 0 1 0 0 36.8339 -85.3973 0.17 100.0 OCTOBER 2014-10-06 17:13:00 KY 0 1 0 0 36.842 -85.1959 2.17 150.0 OCTOBER 2014-10-06 17:40:00 GA 0 1 0 0 34.9304 -85.1225 0.29 100.0 OCTOBER 2014-10-07 12:50:00 KY 0 1 0 0 38.4602 -85.4629 0.12 50.0 OCTOBER 2014-10-07 13:39:00 KY 0 1 0 0 38.4618 -84.691 12.13 150.0 OCTOBER 2014-10-07 13:48:00 KY 0 1 0 0 38.2846 -84.6896 2.79 150.0 OCTOBER 2014-10-07 13:49:00 KY 0 1 0 0 38.2921 -84.6292 3.55 150.0 OCTOBER 2014-10-07 14:05:00 KY 0 1 0 0 38.3789 -84.358 3.66 275.0 OCTOBER 2014-10-07 14:12:00 KY 0 1 1 0 38.2016 -84.256 1.7 60.0 OCTOBER 2014-10-07 14:35:00 KY 0 1 0 0 38.2059 -83.9386 0.6 50.0 OCTOBER 2014-10-07 14:53:00 KY 0 1 0 0 38.0696 -83.6598 0.3 35.0 OCTOBER 2014-10-07 16:35:00 IN 0 0 0 0 39.5006 -86.7748 0.1 50.0 OCTOBER 2014-10-07 20:41:00 WV 0 2 0 0 37.6014 -81.2012 3.01 150.0 OCTOBER 2014-10-07 20:44:00 KY 0 1 0 0 37.6141 -82.5948 0.1 130.0 OCTOBER 2014-10-07 21:39:00 WV 0 1 2 0 37.4533 -81.2164 5.54 180.0 OCTOBER 2014-10-09 20:10:00 TX 0 1 0 0 35.4213 -101.045 7.03 125.0 OCTOBER 2014-10-10 19:35:00 TN 0 1 0 0 35.8594 -87.3851 1.97 100.0 OCTOBER 2014-10-13 03:52:00 TX 0 1 0 0 32.7681 -95.0456 5.8 275.0 OCTOBER 2014-10-13 04:04:00 AR 0 1 0 0 34.5766 -94.3911 3.66 300.0 OCTOBER 2014-10-13 04:19:00 AR 0 1 0 0 36.1783 -93.8792 3.0 375.0 OCTOBER 2014-10-13 04:43:00 AR 0 0 0 0 33.7279 -94.2339 0.09 50.0 OCTOBER 2014-10-13 05:25:00 MO 0 1 0 0 36.5048 -93.39 0.09 75.0 OCTOBER 2014-10-13 05:58:00 MO 0 0 0 0 37.1593 -93.6799 0.07 50.0 OCTOBER 2014-10-13 06:20:00 MO 0 0 0 0 37.3537 -93.6061 0.43 100.0 OCTOBER 2014-10-13 06:40:00 AR 0 1 0 0 34.0405 -92.9554 3.32 250.0 OCTOBER 2014-10-13 08:00:00 LA 0 1 0 0 31.9764 -93.6991 0.9 200.0 OCTOBER 2014-10-13 08:27:00 AR 0 1 0 0 34.5441 -92.0074 3.31 150.0 OCTOBER 2014-10-13 10:11:00 LA 0 1 0 0 32.4375 -92.2781 0.7 225.0 OCTOBER 2014-10-13 10:16:00 LA 0 2 0 0 32.4921 -92.2421 9.05 300.0 OCTOBER 2014-10-13 11:48:00 AR 0 0 0 0 36.439 -90.3982 0.87 100.0 OCTOBER 2014-10-13 11:59:00 IL 0 0 0 0 38.1272 -90.0143 0.29 50.0 OCTOBER 2014-10-13 12:24:00 IL 0 1 0 0 38.4703 -89.9263 1.38 100.0 OCTOBER 2014-10-13 12:30:00 MO 0 1 0 0 36.9498 -90.1113 9.35 75.0 OCTOBER 2014-10-13 12:43:00 IL 0 1 0 0 38.5363 -89.7248 0.25 50.0 OCTOBER 2014-10-13 12:45:00 MO 0 1 0 0 37.1193 -90.0415 7.16 100.0 OCTOBER 2014-10-13 13:02:00 MO 0 1 0 0 37.2423 -89.9396 2.0 50.0 OCTOBER 2014-10-13 14:54:00 IL 0 2 0 0 39.631 -88.9567 10.0 200.0 OCTOBER 2014-10-13 15:06:00 IL 0 1 0 0 38.4443 -88.9185 3.52 100.0 OCTOBER 2014-10-13 15:07:00 IL 0 1 0 0 38.3715 -88.7566 0.66 50.0 OCTOBER 2014-10-13 15:12:00 IL 0 1 0 0 39.8184 -88.88 0.2 50.0 OCTOBER 2014-10-13 15:20:00 FL 0 0 0 0 30.287 -85.1792 2.58 30.0 OCTOBER 2014-10-13 15:29:00 IL 0 0 0 0 40.0188 -88.7722 2.75 50.0 OCTOBER 2014-10-13 15:43:00 AL 0 0 0 0 34.208 -88.1077 6.01 50.0 OCTOBER 2014-10-13 16:25:00 IN 0 1 0 0 38.0981 -87.9087 3.75 150.0 OCTOBER 2014-10-13 17:09:00 TN 0 1 0 0 36.5001 -87.2952 4.18 75.0 OCTOBER 2014-10-13 17:48:00 AL 0 0 0 0 34.0087 -88.001 1.08 150.0 OCTOBER 2014-10-13 18:29:00 FL 0 0 0 0 29.89 -84.91 0.01 20.0 OCTOBER 2014-10-13 18:29:00 AL 0 1 1 0 34.7318 -87.7029 3.48 200.0 OCTOBER 2014-10-13 18:50:00 FL 0 0 0 0 30.01 -84.91 0.01 20.0 OCTOBER 2014-10-13 19:59:00 FL 0 0 0 0 30.02 -84.98 2.07 20.0 OCTOBER 2014-10-13 20:58:00 FL 0 0 0 0 30.14 -84.91 0.01 20.0 OCTOBER 2014-10-14 02:00:00 FL 0 0 0 0 30.78 -85.36 1.73 20.0 OCTOBER 2014-10-14 02:40:00 GA 0 1 0 0 32.7979 -84.7091 5.86 200.0 OCTOBER 2014-10-14 03:15:00 GA 0 0 0 0 33.6552 -84.5147 2.99 75.0 OCTOBER 2014-10-14 03:20:00 GA 0 0 0 0 33.6776 -84.4662 2.63 75.0 OCTOBER 2014-10-14 03:33:00 GA 0 0 0 0 33.8427 -84.4407 1.07 75.0 OCTOBER 2014-10-14 03:43:00 GA 0 1 0 0 33.9821 -84.3918 1.25 100.0 OCTOBER 2014-10-14 03:55:00 GA 0 1 0 0 34.0748 -84.3255 7.51 100.0 OCTOBER 2014-10-14 06:11:00 SC 0 0 0 0 34.68 -83.21 0.89 100.0 OCTOBER 2014-10-14 18:00:00 SC 0 0 0 0 35.12 -82.24 1.0 50.0 OCTOBER 2014-10-14 18:48:00 NC 0 0 0 0 35.55 -82.07 0.5 100.0 OCTOBER 2014-10-15 10:23:00 VA 0 0 0 0 38.78 -77.06 2.32 75.0 OCTOBER 2014-10-15 11:13:00 MD 0 0 0 0 39.128 -76.829 0.3 75.0 OCTOBER 2014-10-23 14:40:00 WA 0 1 0 0 46.13 -122.946 1.3 66.0 OCTOBER 2014-11-16 19:48:00 LA 0 0 0 0 30.4023 -90.9214 1.12 100.0 NOVEMBER 2014-11-16 20:11:00 LA 0 1 0 0 30.5597 -90.7428 3.87 300.0 NOVEMBER 2014-11-16 20:27:00 MS 0 1 0 0 31.683 -88.9929 2.65 100.0 NOVEMBER 2014-11-17 01:11:00 AL 0 1 0 0 32.699 -87.4659 3.53 300.0 NOVEMBER 2014-11-17 01:37:00 AL 0 1 0 0 31.4418 -88.1545 21.9 150.0 NOVEMBER 2014-11-17 02:51:00 FL 0 0 0 0 30.3 -85.92 0.01 50.0 NOVEMBER 2014-11-17 03:59:00 AL 0 1 0 0 31.6093 -86.7471 5.89 150.0 NOVEMBER 2014-11-17 04:17:00 FL 0 2 2 0 30.4025 -85.0746 22.21 420.0 NOVEMBER 2014-11-17 04:25:00 AL 0 1 0 0 31.7369 -86.4303 40.73 500.0 NOVEMBER 2014-11-17 05:57:00 FL 0 0 0 0 30.699 -85.0191 0.5 50.0 NOVEMBER 2014-11-17 06:24:00 AL 0 1 0 0 32.199 -85.0592 0.22 100.0 NOVEMBER 2014-11-17 08:57:00 GA 0 1 0 0 32.5567 -83.3719 0.05 100.0 NOVEMBER 2014-11-17 12:00:00 FL 0 0 0 0 30.1447 -82.2818 0.8 75.0 NOVEMBER 2014-11-23 11:35:00 AL 0 0 0 0 32.6387 -87.8364 2.05 150.0 NOVEMBER 2014-11-23 14:03:00 AL 0 1 0 0 31.9603 -85.094 3.23 400.0 NOVEMBER 2014-11-23 14:03:00 AL 0 1 0 0 31.9603 -85.094 16.72 400.0 NOVEMBER 2014-11-23 14:07:00 GA 0 1 0 0 32.0002 -85.0653 13.49 75.0 NOVEMBER 2014-11-23 14:27:00 GA 0 1 0 0 32.0315 -84.8078 0.47 100.0 NOVEMBER 2014-11-23 14:37:00 GA 0 1 0 0 32.2982 -84.7905 21.08 75.0 NOVEMBER 2014-11-23 15:01:00 GA 0 0 0 0 32.615 -84.5513 3.16 50.0 NOVEMBER 2014-11-23 15:20:00 GA 0 0 0 0 32.8945 -84.3502 10.98 200.0 NOVEMBER 2014-11-23 15:40:00 GA 0 1 0 0 32.8818 -84.0179 20.02 70.0 NOVEMBER 2014-11-23 15:40:00 GA 0 0 0 0 33.0747 -84.2059 1.44 70.0 NOVEMBER 2014-11-23 15:49:00 GA 0 1 0 0 33.1532 -84.1128 21.55 100.0 NOVEMBER 2014-11-23 16:10:00 GA 0 1 0 0 32.3152 -83.6336 6.4 50.0 NOVEMBER 2014-12-12 11:20:00 CA 0 0 0 0 33.9823 -118.291 0.73 10.0 DECEMBER 2014-12-14 17:09:00 OK 0 0 0 0 35.62 -97.38 0.17 50.0 DECEMBER 2014-12-14 17:38:00 KS 0 0 0 0 37.2915 -98.0097 5.98 100.0 DECEMBER 2014-12-15 17:02:00 MS 0 0 0 0 31.8276 -89.6172 1.53 50.0 DECEMBER 2014-12-15 17:56:00 MS 0 0 0 0 32.3668 -90.7339 1.17 75.0 DECEMBER 2014-12-15 23:18:00 MS 0 0 0 0 31.0936 -90.0188 1.33 150.0 DECEMBER 2014-12-23 12:58:00 GA 0 0 0 0 30.77 -83.33 0.1 25.0 DECEMBER 2014-12-23 13:19:00 LA 0 2 0 0 30.7289 -90.4799 4.62 150.0 DECEMBER 2014-12-23 14:45:00 MS 0 0 0 0 31.4143 -89.5509 0.06 50.0 DECEMBER 2014-12-23 14:46:00 MS 0 0 0 0 31.4247 -89.5358 0.24 50.0 DECEMBER 2014-12-23 16:27:00 MS 0 0 0 0 32.0005 -88.4854 0.49 100.0 DECEMBER 2014-12-24 09:30:00 NC 0 1 1 0 34.3124 -77.917 0.2 25.0 DECEMBER 2014-12-24 11:50:00 GA 0 1 0 0 31.406 -82.251 5.69 100.0 DECEMBER 2014-12-24 16:16:00 OH 0 0 0 0 39.728 -82.634 0.63 30.0 DECEMBER 2014-12-27 13:12:00 TX 0 0 0 0 30.3853 -94.7823 0.23 75.0 DECEMBER 2014-12-27 14:00:00 TX 0 1 0 0 30.6829 -94.2553 4.25 50.0 DECEMBER 2014-12-27 14:35:00 TX 0 1 0 0 30.864 -93.979 1.98 150.0 DECEMBER 2014-12-29 10:26:00 GA 0 2 9 0 30.8157 -83.2833 0.74 180.0 DECEMBER 2014-01-11 06:37:00 GA 0 0 0 0 34.3328 -84.5286 2.9 10.0 JANUARY 2014-01-11 14:32:00 VA 0 0 0 0 37.025 -76.6377 1.36 100.0 JANUARY 2014-01-11 14:32:00 VA 0 0 0 0 36.8769 -76.6721 1.95 50.0 JANUARY 2014-01-11 14:50:00 VA 0 0 0 0 37.08 -76.3 1.08 75.0 JANUARY 2014-02-20 14:25:00 IL 0 2 1 0 39.518 -90.841 12.09 80.0 FEBRUARY 2014-02-20 14:48:00 IL 0 0 0 0 39.7853 -90.4215 0.27 25.0 FEBRUARY 2014-02-20 14:52:00 IL 0 0 0 0 39.8193 -90.4178 8.17 50.0 FEBRUARY 2014-02-20 15:43:00 IL 0 0 0 0 39.5671 -89.6256 0.22 75.0 FEBRUARY 2014-02-20 15:57:00 IL 0 1 0 0 38.7575 -89.6151 20.56 300.0 FEBRUARY 2014-02-20 16:09:00 IL 0 2 1 0 39.2586 -89.234 22.38 200.0 FEBRUARY 2014-02-20 16:36:00 IL 0 1 0 0 39.0158 -88.998 4.8 50.0 FEBRUARY 2014-02-20 16:39:00 MO 0 1 5 0 36.1895 -89.8812 0.24 70.0 FEBRUARY 2014-02-20 16:40:00 IL 0 1 0 0 37.6987 -89.3713 0.39 50.0 FEBRUARY 2014-02-20 16:40:00 IL 0 0 0 0 39.5176 -88.8109 0.28 50.0 FEBRUARY 2014-02-20 16:41:00 MO 0 1 0 0 36.2349 -89.8029 0.04 25.0 FEBRUARY
//Descriptive statistics
tornadoes.column("Fatalities").summary().print();
Column: Fatalities Measure Value n 908.0 sum 48.0 Mean 0.052863438 Min 0.0 Max 16.0 Range 16.0 Variance 0.44262686 Std. Dev 0.6653021
//Performing totals and sub-totals
def injuriesByScale = tornadoes.median("Injuries").by("Scale")
injuriesByScale.setName("Median injuries by Tornado Scale")
injuriesByScale.print()
Median injuries by Tornado Scale Scale Median [Injuries] 0 0.0 1 0.0 2 0.0 3 0.0 4 2.0
//Cross Tabs
CrossTab.xCount(tornadoes, tornadoes.categoryColumn("State"), tornadoes.shortColumn("Scale")).print()
Crosstab Counts: State x Scale 0 1 2 3 4 total AL 12 32 7 4 0 55 AR 5 12 2 0 1 20 AZ 3 0 0 0 0 3 CA 6 3 0 0 0 9 CO 41 7 1 0 0 49 CT 1 0 0 0 0 1 DE 0 1 0 0 0 1 FL 23 4 1 0 0 28 GA 13 16 3 0 0 32 IA 31 22 3 0 0 56 ID 3 0 0 0 0 3 IL 19 27 3 0 0 49 IN 6 22 0 0 0 28 KS 30 7 3 1 0 41 KY 6 21 1 0 0 28 LA 4 8 3 0 0 15 MA 1 1 1 0 0 3 MD 2 0 0 0 0 2 ME 2 2 0 0 0 4 MI 6 7 0 0 0 13 MN 17 4 3 0 0 24 MO 23 21 3 0 0 47 MS 12 17 7 5 1 42 MT 7 0 0 1 0 8 NC 14 11 6 1 0 32 ND 11 2 1 0 0 14 NE 33 13 9 3 4 62 NH 2 0 0 0 0 2 NM 12 3 0 0 0 15 NV 6 0 0 0 0 6 NY 1 8 1 1 0 11 OH 16 3 0 1 0 20 OK 12 3 2 0 0 17 PA 5 3 1 0 0 9 SC 7 0 0 0 0 7 SD 18 6 4 0 1 29 TN 3 10 3 2 0 18 TX 35 9 2 0 0 46 VA 11 1 0 0 0 12 WA 2 1 0 0 0 3 WI 6 11 4 1 0 22 WV 1 7 1 0 0 9 WY 10 2 1 0 0 13 Total 478 327 76 20 7 908
K-means is the most common form of “centroid” clustering. Unlike classification, clustering is an unsupervised learning method. The categories are not predetermined. Instead, the goal is to search for natural groupings in the dataset, such that the members of each group are similar to each other and different from the members of the other groups. The K represents the number of groups to find.
We’ll use a well known Scotch Whiskey dataset, which is used to cluster whiskeys according to their taste based on data collected from tasting notes. As always, we start by loading data and printing its structure.
More description is available at https://jtablesaw.wordpress.com/2016/08/08/k-means-clustering-in-java/
t = Table.createFromCsv("Tablesaw/whiskey.csv")
t.structure().print();
Structure of whiskey.csv Index Column Name Column Type 0 RowID SHORT_INT 1 Distillery CATEGORY 2 Body SHORT_INT 3 Sweetness SHORT_INT 4 Smoky SHORT_INT 5 Medicinal SHORT_INT 6 Tobacco SHORT_INT 7 Honey SHORT_INT 8 Spicy SHORT_INT 9 Winey SHORT_INT 10 Nutty SHORT_INT 11 Malty SHORT_INT 12 Fruity SHORT_INT 13 Floral SHORT_INT 14 Postcode CATEGORY 15 Latitude FLOAT 16 Longitude INTEGER
model = new Kmeans(
5,
t.nCol(2), t.nCol(3), t.nCol(4), t.nCol(5), t.nCol(6), t.nCol(7),
t.nCol(8), t.nCol(9), t.nCol(10), t.nCol(11), t.nCol(12), t.nCol(13)
);
//print claster formation
model.clustered(t.column("Distillery")).print();
Clusters Label Cluster Aberfeldy 0 Aberlour 0 Auchroisk 0 Balmenach 0 Belvenie 0 BenNevis 0 Benrinnes 0 Benromach 0 BlairAthol 0 Dailuaine 0 Dalmore 0 Deanston 0 Edradour 0 GlenOrd 0 Glendronach 0 Glendullan 0 Glenfarclas 0 Glenlivet 0 Glenrothes 0 Glenturret 0 Knochando 0 Longmorn 0 Macallan 0 Mortlach 0 RoyalLochnagar 0 Scapa 0 Strathisla 0 Ardbeg 1 Caol Ila 1 Clynelish 1 Lagavulin 1 Laphroig 1 Talisker 1 Ardmore 2 Balblair 2 Bowmore 2 GlenDeveronMacduff 2 GlenScotia 2 Highland Park 2 Isle of Jura 2 Oban 2 OldFettercairn 2 OldPulteney 2 Springbank 2 Tomatin 2 Tormore 2 Benriach 3 Bladnoch 3 Bruichladdich 3 Bunnahabhain 3 Craigallechie 3 Dalwhinnie 3 GlenGarioch 3 GlenMoray 3 Glenkinchie 3 Glenlossie 3 Inchgower 3 Loch Lomond 3 RoyalBrackla 3 Teaninich 3 Tomintoul 3 AnCnoc 4 ArranIsleOf 4 Auchentoshan 4 Aultmore 4 Cardhu 4 Craigganmore 4 Dufftown 4 GlenElgin 4 GlenGrant 4 GlenKeith 4 GlenSpey 4 Glenallachie 4 Glenfiddich 4 Glengoyne 4 Glenmorangie 4 Linkwood 4 Mannochmore 4 Miltonduff 4 Speyburn 4 Speyside 4 Strathmill 4 Tamdhu 4 Tamnavulin 4 Tobermory 4 Tullibardine 4
//print centroids for each claster
model.labeledCentroids().print();
Centroids Cluster Body Sweetness Smoky Medicinal Tobacco Honey Spicy Winey Nutty Malty Fruity Floral 0 2.7037036 2.4074075 1.4074074 0.074074075 0.0 1.8888888 1.6296296 1.8518518 1.8888888 2.074074 2.148148 1.7037038 1 3.6666667 1.5 3.6666667 3.3333333 0.6666667 0.16666667 1.6666666 0.5 1.1666666 1.3333334 1.1666666 0.16666667 2 1.9230769 2.0769231 2.0 1.0769231 0.23076923 1.1538461 1.3076923 0.84615386 1.6153846 1.7692307 0.9230769 1.0 3 1.3333334 2.0 1.4666667 0.46666667 0.13333334 1.2 1.8 0.53333336 0.8 1.8666667 1.8666667 2.4 4 1.52 2.64 0.96 0.16 0.04 0.88 0.84 0.48 1.4 1.6 2.0 2.0
//gets the distortion for our model
model.distortion()
384.36957264957266
def n = t.rowCount();
def kValues = new double[n - 2];
def distortions = new double[n - 2];
for (int k = 2; k < n; k++) {
kValues[k - 2] = k;
def kmeans = new Kmeans(k,
t.nCol(2), t.nCol(3), t.nCol(4), t.nCol(5), t.nCol(6), t.nCol(7),
t.nCol(8), t.nCol(9), t.nCol(10), t.nCol(11), t.nCol(12), t.nCol(13)
);
distortions[k - 2] = kmeans.distortion();
}
def linearYPlot = new Plot(title: "K-means clustering demo", xLabel:"K", yLabel: "distortion")
linearYPlot << new Line(x: kValues, y: distortions)
In baseball, you make the playoffs by winning more games than your rivals. The number of games the rivals win is out of your control so the A’s looked instead at how many wins it took historically to make the playoffs. They decided that 95 wins would give them a strong chance. Here’s how we might check that assumption in Tablesaw.
More description is available at https://jtablesaw.wordpress.com/2016/07/31/play-moneyball-data-science-in-tablesaw/
baseball = Table.createFromCsv("Tablesaw/baseball.csv");
// filter to the data available at the start of the 2002 season
moneyball = baseball.selectWhere(column("year").isLessThan(2002));
wins = moneyball.nCol("W");
year = moneyball.nCol("Year");
playoffs = moneyball.column("Playoffs");
runDifference = moneyball.shortColumn("RS").subtract(moneyball.shortColumn("RA"));
moneyball.addColumn(runDifference);
runDifference.setName("RD");
def Plot = new Plot(title: "RD x Wins", xLabel:"RD", yLabel: "W")
Plot << new Points(x: moneyball.numericColumn("RD").toDoubleArray(), y: moneyball.numericColumn("W").toDoubleArray())
winsModel = LeastSquares.train(wins, runDifference);
Linear Model: Residuals: Min 1Q Median 3Q Max -14.2662 -2.6511 0.1282 2.9365 11.6570 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) 80.8814 0.1312 616.6747 0.0000 *** RD 0.1058 0.0013 81.5536 0.0000 *** --------------------------------------------------------------------- Significance codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1 Residual standard error: 3.9391 on 900 degrees of freedom Multiple R-squared: 0.8808, Adjusted R-squared: 0.8807 F-statistic: 6650.9926 on 1 and 900 DF, p-value: 0.000
def runDiff = new double[1];
runDiff[0] = 135;
def expectedWins = winsModel.predict(runDiff);
runsScored2 = LeastSquares.train(moneyball.nCol("RS"), moneyball.nCol("OBP"), moneyball.nCol("SLG"));
Linear Model: Residuals: Min 1Q Median 3Q Max -70.8379 -17.1810 -1.0917 16.7812 90.0358 Coefficients: Estimate Std. Error t value Pr(>|t|) (Intercept) -804.6271 18.9208 -42.5261 0.0000 *** OBP 2737.7682 90.6846 30.1900 0.0000 *** SLG 1584.9085 42.1556 37.5966 0.0000 *** --------------------------------------------------------------------- Significance codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1 Residual standard error: 24.7900 on 899 degrees of freedom Multiple R-squared: 0.9296, Adjusted R-squared: 0.9294 F-statistic: 5933.7256 on 2 and 899 DF, p-value: 0.000
new Histogram(xLabel:"X",
yLabel:"Proportion",
data: Arrays.asList(runsScored2.residuals()),
binCount: 25);