id, time, nodeaddr, appeui, gwaddr, modulation, datarate, snr, rssi, freq, fcount, lat, lon, alt, accuracy, hdop, sats, provider, name, user_agent 3150696, 2018-09-12 00:28:47, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -36.00, 904.500, null, 42.341800, -71.153500, 57.3, null, 1.5, null, HDOP, b_test, null 3150695, 2018-09-12 00:27:44, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 6.50, -36.00, 904.300, null, 42.341700, -71.153600, 57.4, null, 1.5, null, HDOP, b_test, null 3150693, 2018-09-12 00:26:41, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.75, -37.00, 904.100, null, 42.341900, -71.153500, 58.5, null, 1.5, null, HDOP, b_test, null 3150691, 2018-09-12 00:25:38, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.00, -37.00, 903.900, null, 42.341900, -71.153600, 58.6, null, 1.5, null, HDOP, b_test, null 3150688, 2018-09-12 00:24:34, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.75, -33.00, 905.300, null, 42.341800, -71.153600, 59.3, null, 1.5, null, HDOP, b_test, null 3150686, 2018-09-12 00:23:31, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.75, -34.00, 905.100, null, 42.341700, -71.153600, 59.1, null, 2.1, null, HDOP, b_test, null 3150685, 2018-09-12 00:22:28, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.00, -47.00, 904.900, null, 42.341700, -71.153600, 59.2, null, 2.1, null, HDOP, b_test, null 3150684, 2018-09-12 00:21:25, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -40.00, 904.700, null, 42.341700, -71.153600, 60.8, null, 2.2, null, HDOP, b_test, null 3150682, 2018-09-12 00:20:22, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -40.00, 904.500, null, 42.341800, -71.153600, 64.7, null, 2.2, null, HDOP, b_test, null 3150681, 2018-09-12 00:19:19, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 7.50, -38.00, 904.300, null, 42.341700, -71.153600, 64.7, null, 2.2, null, HDOP, b_test, null 3150680, 2018-09-12 00:18:16, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -49.00, 904.100, null, 42.341800, -71.153700, 67.5, null, 0.6, null, HDOP, b_test, null 3150678, 2018-09-12 00:17:13, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -33.00, 903.900, null, 42.341800, -71.153700, 67.5, null, 0.6, null, HDOP, b_test, null 3150676, 2018-09-12 00:16:13, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -33.00, 904.100, null, 42.341600, -71.153500, 68.0, null, 2.4, null, HDOP, b_test, null 3150675, 2018-09-12 00:15:10, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -33.00, 903.900, null, 42.341800, -71.153500, 68.7, null, 2.4, null, HDOP, b_test, null 3150672, 2018-09-12 00:12:13, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -28.00, 904.900, null, 42.342000, -71.153600, 70.3, null, 0.0, null, HDOP, b_test, null 3150671, 2018-09-12 00:12:00, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.50, -33.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150670, 2018-09-12 00:11:47, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -27.00, 904.500, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150669, 2018-09-12 00:11:34, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 6.75, -31.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150668, 2018-09-12 00:11:21, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.00, -31.00, 904.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150666, 2018-09-12 00:11:08, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -33.00, 903.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150665, 2018-09-12 00:10:55, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.50, -31.00, 905.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150664, 2018-09-12 00:10:42, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -29.00, 905.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150663, 2018-09-12 00:10:28, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.00, -30.00, 904.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150662, 2018-09-12 00:10:15, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -30.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150659, 2018-09-12 00:10:02, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -30.00, 904.500, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150658, 2018-09-12 00:09:49, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 8.00, -30.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150657, 2018-09-12 00:09:36, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -30.00, 904.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150656, 2018-09-12 00:09:23, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -30.00, 903.900, null, 0.005700, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150655, 2018-09-12 00:09:10, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -29.00, 905.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150653, 2018-09-12 00:08:57, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.50, -36.00, 905.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150652, 2018-09-12 00:08:44, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -35.00, 904.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150650, 2018-09-12 00:08:30, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.00, -34.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150649, 2018-09-12 00:08:17, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.75, -35.00, 904.500, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150648, 2018-09-12 00:08:04, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 7.75, -37.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150646, 2018-09-12 00:07:51, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.25, -36.00, 904.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150645, 2018-09-12 00:07:38, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.75, -39.00, 903.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150644, 2018-09-12 00:07:23, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.00, -36.00, 903.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150643, 2018-09-12 00:05:13, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 8.75, -40.00, 903.900, null, 0.000000, 532.265700, 0.0, null, 0.0, null, HDOP, b_test, null 3150641, 2018-09-12 00:04:46, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -39.00, 904.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150640, 2018-09-12 00:04:33, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.25, -39.00, 903.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150639, 2018-09-12 00:04:24, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -36.00, 905.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150638, 2018-09-12 00:04:11, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -36.00, 904.900, null, -11.228200, 0.000000, 0.0, null, 2.4, null, HDOP, b_test, null 3150636, 2018-09-12 00:03:58, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -35.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150635, 2018-09-12 00:03:45, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -36.00, 904.500, null, 0.000100, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150633, 2018-09-12 00:03:32, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 7.75, -27.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150632, 2018-09-12 00:03:19, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -34.00, 904.100, null, -42.009600, 0.000000, 0.0, null, 2.3, null, HDOP, b_test, null 3150631, 2018-09-12 00:03:06, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -36.00, 903.900, null, -0.000300, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150630, 2018-09-12 00:02:53, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -34.00, 905.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150629, 2018-09-12 00:02:39, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -33.00, 905.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150628, 2018-09-12 00:02:26, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -31.00, 904.900, null, 0.000700, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150627, 2018-09-12 00:02:13, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.25, -34.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150626, 2018-09-12 00:02:00, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.00, -37.00, 904.500, null, -0.000700, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150625, 2018-09-12 00:01:47, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 7.50, -35.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150623, 2018-09-12 00:01:34, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.25, -36.00, 904.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150622, 2018-09-12 00:01:21, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.25, -37.00, 903.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150620, 2018-09-12 00:00:52, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.00, -35.00, 904.500, null, -0.000700, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150619, 2018-09-12 00:00:39, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 8.25, -34.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150618, 2018-09-12 00:00:26, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.00, -36.00, 904.100, null, -611.712000, 0.000000, 0.0, null, 0.2, null, HDOP, b_test, null 3150617, 2018-09-12 00:00:13, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.50, -37.00, 903.900, null, 0.001400, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150616, 2018-09-12 00:00:00, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.00, -36.00, 905.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150615, 2018-09-11 23:59:47, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 11.25, -36.00, 905.100, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150614, 2018-09-11 23:59:33, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -35.00, 904.900, null, -0.000700, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150613, 2018-09-11 23:59:20, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 8.50, -35.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150611, 2018-09-11 23:59:07, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.00, -33.00, 904.500, null, 0.000700, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150610, 2018-09-11 23:58:54, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 7.50, -36.00, 904.300, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150607, 2018-09-11 23:58:41, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.75, -36.00, 904.100, null, -0.804900, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150606, 2018-09-11 23:58:28, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 10.50, -36.00, 903.900, null, 0.000000, 0.000000, 0.0, null, 0.0, null, HDOP, b_test, null 3150605, 2018-09-11 23:57:56, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 8.75, -34.00, 904.900, null, 0.000000, 0.000000, 0.0, null, 2.0, null, HDOP, b_test, null 3150604, 2018-09-11 23:56:53, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 8.50, -35.00, 904.700, null, 0.000000, 0.000000, 0.0, null, 1.6, null, HDOP, b_test, null 3150603, 2018-09-11 23:55:50, patriot, rob, el-ttn-gateway, LORA, SF7BW125, 9.50, -37.00, 904.500, null, 215.722600, 0.000000, 0.0, null, 2.1, null, HDOP, b_test, null Number of rows dumped: 70