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/
In [2]:
tornadoes = Table.createFromCsv("Tablesaw/tornadoes_2014.csv")
//print dataset structure
tornadoes.structure().print()
Out[2]:
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
In [6]:
//get header names
tornadoes.columnNames()
Out[6]:
[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width]
In [7]:
//displays the row and column counts
tornadoes.shape()
Out[7]:
908 rows X 11 cols
In [8]:
//displays the first n rows
tornadoes.first(10).print()
Out[8]:
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
In [9]:
tornadoes.structure().selectWhere(column("Column Type").isEqualTo("FLOAT")).print()
Out[9]:
Structure of tornadoes_2014.csv
Index Column Name Column Type
7 Start Lat FLOAT
8 Start Lon FLOAT
9 Length FLOAT
10 Width FLOAT
In [10]:
//summarize the data in each column
tornadoes.summary()
Out[10]:
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
In [11]:
//Mapping operations
def month = tornadoes.dateColumn("Date").month()
tornadoes.addColumn(month);
tornadoes.columnNames()
Out[11]:
[Date, Time, State, State No, Scale, Injuries, Fatalities, Start Lat, Start Lon, Length, Width, Date month]
In [12]:
//Sorting by column
tornadoes.sortOn("-Fatalities").print()
Out[12]:
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
In [13]:
//Descriptive statistics
tornadoes.column("Fatalities").summary().print();
Out[13]:
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
In [14]:
//Performing totals and sub-totals
def injuriesByScale = tornadoes.median("Injuries").by("Scale")
injuriesByScale.setName("Median injuries by Tornado Scale")
injuriesByScale.print()
Out[14]:
Median injuries by Tornado Scale
Scale Median [Injuries]
0 0.0
1 0.0
2 0.0
3 0.0
4 2.0
In [15]:
//Cross Tabs
CrossTab.xCount(tornadoes, tornadoes.categoryColumn("State"), tornadoes.shortColumn("Scale")).print()
Out[15]:
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/
In [16]:
t = Table.createFromCsv("Tablesaw/whiskey.csv")
t.structure().print();
Out[16]:
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
In [17]:
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();
Out[17]:
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
In [18]:
//print centroids for each claster
model.labeledCentroids().print();
Out[18]:
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
In [19]:
//gets the distortion for our model
model.distortion()
Out[19]:
384.36957264957266
In [20]:
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)
Out[20]:
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/
In [21]:
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())
Out[21]:
In [22]:
winsModel = LeastSquares.train(wins, runDifference);
Out[22]:
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
In [23]:
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"));
Out[23]:
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
In [24]:
new Histogram(xLabel:"X",
yLabel:"Proportion",
data: Arrays.asList(runsScored2.residuals()),
binCount: 25);
Out[24]:
Content source: ScottPJones/beaker-notebook
Similar notebooks: