id, time, nodeaddr, appeui, gwaddr, modulation, datarate, snr, rssi, freq, fcount, lat, lon, alt, accuracy, hdop, sats, provider, name, user_agent 293005, 2016-10-07 03:55:41, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -0.20, -114.00, 868.100, null, 52.511610, 5.487571, 40.0, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 293004, 2016-10-07 03:55:39, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -6.20, -117.00, 867.300, null, 52.511582, 5.486838, 41.2, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 293003, 2016-10-07 03:55:37, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -6.00, -114.00, 868.500, null, 52.511562, 5.486367, 42.4, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 293002, 2016-10-07 03:55:29, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 3.50, -108.00, 867.700, null, 52.511536, 5.484815, 44.7, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 293001, 2016-10-07 03:55:27, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 3.20, -107.00, 868.100, null, 52.511543, 5.484248, 44.1, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 293000, 2016-10-07 03:55:24, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 4.20, -113.00, 868.500, null, 52.511553, 5.483885, 43.7, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292999, 2016-10-07 03:55:22, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -3.20, -113.00, 867.500, null, 52.511556, 5.483505, 42.9, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292998, 2016-10-07 03:55:20, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 3.00, -110.00, 868.300, null, 52.511535, 5.483337, 42.7, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292997, 2016-10-07 03:55:16, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -1.00, -113.00, 867.100, null, 52.511434, 5.483227, 42.4, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292996, 2016-10-07 03:55:13, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -3.80, -115.00, 867.900, null, 52.511434, 5.483227, 42.5, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292995, 2016-10-07 03:55:11, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -4.00, -116.00, 868.100, null, 52.511434, 5.483227, 42.5, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292994, 2016-10-07 03:55:08, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -2.20, -115.00, 868.500, null, 52.511379, 5.483202, 42.4, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292993, 2016-10-07 03:55:05, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, -0.20, -111.00, 868.300, null, 52.511262, 5.483215, 41.0, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292992, 2016-10-07 03:54:55, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 2.00, -102.00, 868.500, null, 52.510522, 5.483343, 38.2, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292991, 2016-10-07 03:54:30, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.00, -89.00, 867.100, null, 52.509728, 5.484500, 45.7, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292990, 2016-10-07 03:54:28, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 7.50, -79.00, 868.100, null, 52.509739, 5.484661, 46.1, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292989, 2016-10-07 03:54:24, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.00, -82.00, 867.900, null, 52.509712, 5.484746, 46.3, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292988, 2016-10-07 03:54:22, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 6.80, -81.00, 868.500, null, 52.509702, 5.484759, 46.5, 4.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292987, 2016-10-07 03:54:20, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 8.00, -84.00, 868.300, null, 52.509724, 5.484748, 46.6, 4.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292986, 2016-10-07 03:54:13, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.50, -87.00, 868.100, null, 52.509762, 5.484707, 47.1, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292985, 2016-10-07 03:54:07, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.00, -90.00, 868.300, null, 52.509796, 5.484754, 47.1, 12.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292984, 2016-10-07 03:54:05, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 6.20, -90.00, 868.500, null, 52.509796, 5.484754, 45.1, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292983, 2016-10-07 03:54:02, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 8.20, -89.00, 867.300, null, 52.509796, 5.484754, 44.4, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292982, 2016-10-07 03:53:58, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 7.80, -91.00, 868.100, null, 52.509797, 5.484743, 42.6, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292981, 2016-10-07 03:53:53, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.20, -87.00, 868.300, null, 52.509794, 5.484728, 36.9, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292980, 2016-10-07 03:53:50, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 6.80, -87.00, 868.500, null, 52.509802, 5.484731, 37.4, 6.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292979, 2016-10-07 03:53:48, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.20, -87.00, 867.700, null, 52.509809, 5.484743, 38.3, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292978, 2016-10-07 03:53:46, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 9.20, -85.00, 868.100, null, 52.509823, 5.484742, 37.5, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292977, 2016-10-07 03:53:44, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 6.80, -79.00, 867.500, null, 52.509836, 5.484725, 43.2, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292976, 2016-10-07 03:53:41, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 7.80, -91.00, 867.100, null, 52.509870, 5.484709, 51.1, 8.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up 292975, 2016-10-07 03:53:37, 0004A30B001A5767, 70B3D57ED0000F2E, B827EBFFFEFDB27F, null, SF7BW125, 8.00, -82.00, 868.300, null, 52.509851, 5.484659, 67.1, 24.00, null, null, gps, 2217.3, 70B3D57ED0000F2E/devices/0004A30B001A5767/up Number of rows dumped: 31